| Page Properties |
|---|
Name | ActionsUser |
|---|
Type | View |
|---|
Description | A normalized version of the Completed Actions table that includes only back office 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 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Tenant ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | qvo-stg | |
Key | Tenant | VARCHAR(64) | | Multiexcerpt include macro |
|---|
| macro_uuid | 92aefef2-6d9d-4064-a29c-4aff6b6b5512 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Tenant |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Default | |
Key | ClientId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Client ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Default | |
Key | Client | VARCHAR(64) | | Multiexcerpt include macro |
|---|
| macro_uuid | 92aefef2-6d9d-4064-a29c-4aff6b6b5512 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Client |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Default | |
Claim Details | ClaimType | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Type |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Card-Pinless | |
Claim Details | ClaimCategory | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Category |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Fraud | |
Claim Details | ClaimReason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Stolen | |
Compliance Details | RegulatoryCoverage | VARCHAR | | Multiexcerpt include |
|---|
| macro_uuid | 5685cd1e-99c2-40db-9a77-74d274228986 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Reg E | |
Task Details | Parent | VARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 9a0193d8-5746-40a4-91d8-abcf05cab2ef |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | CLAIMDISPUTE |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Claim, Dispute | |
Key | ClaimId | VARCHAR | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306060014C | |
Claim Details | ClaimStatus | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Status Work |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | RESOLVED-PAID | |
Claim Details | ClaimResolvedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Resolution Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Key | DisputeId | VARCHAR | | Multiexcerpt include |
|---|
| macro_uuid | 553c0991-8024-44b7-a6fc-c249260d0f54 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306060014C | |
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-09Task Details | |
Change Log
ParentOPENVARCHAR | | Multiexcerpt include macro |
|---|
| macro_uuid | 9a0193d8-5746-40a4-91d8-abcf05cab2ef |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | CLAIMDISPUTE |
|---|
| addpanel | false |
|---|
|
| ALWAYS | Change Summary |
|---|
12/10/2024 | Timestamp columns converted from NTZ to TZ format for compatibility. |
12/11/2024 | Added FlowType column |
12/18/2024 | Added ClaimResolvedDate column |
