Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties

Name

ActionsUser

Type

View

Description

A normalized version of the Completed Actions table that includes only user actions, claim and dispute attributes for filtering/analysis, and actual user names from the User Profile table.

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptTenant ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

qvo-stg

Key

Tenant

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageTenant
addpanelfalse

ALWAYS

Default

Key

ClientId

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClient ID
shouldDisplayInlineCommentsInIncludesfalse

ALWAYS

Default

Key

Client

VARCHAR(64)

Multiexcerpt include macro
macro_uuid92aefef2-6d9d-4064-a29c-4aff6b6b5512
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageClient
addpanelfalse

ALWAYS

Default

Claim Details

ClaimType

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Type
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Card-Pinless

Claim Details

ClaimCategory

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Category
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Fraud

Claim Details

ClaimReason

VARCHAR(64)

Multiexcerpt include
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Stolen

Compliance Details

RegulatoryCoverage

VARCHAR

Multiexcerpt include
macro_uuid5685cd1e-99c2-40db-9a77-74d274228986
MultiExcerptNameglossary_description
PageWithExcerptClaim Reason
shouldDisplayInlineCommentsInIncludesfalse

CONDITIONAL

Reg E

Task Details

FlowType

VARCHAR

Differentiates between Front Office and Back Office actions.

ALWAYS

Front Office, Back Office

Task Details

Flow

VARCHAR

Name of flow where assignment is generated.

CONDITIONAL

Manual Fraud Reporting

Task Details

Assignment

VARCHAR

Name of the task associated with the action.

CONDITIONAL

Manual Fraud Reporting

Action Details

Action

VARCHAR

Name of the action that was completed.

ALWAYS

Report Fraud

Action Details

CompletedBy

VARCHAR

First initial and last name of the user that completed the action.

ALWAYS

D. Robertson

Action Details

ActionDateTime

DATE

Datetime that the action was completed.

ALWAYS

2023-09-09

Task Details

Parent

VARCHAR

Multiexcerpt include macro
macro_uuid9a0193d8-5746-40a4-91d8-abcf05cab2ef
nameglossary_description
templateDataeJyLjgUAARUAuQ==
pageCLAIMDISPUTE
addpanelfalse

ALWAYS

OPEN

Change Log

Date

Change Summary

12/10/2024

Timestamp columns converted from NTZ to TZ format for compatibility.

12/11/2024

Added FlowType column