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 | ClientId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Client ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | Default | |
Key | ClaimId | VARCHAR(32) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2306060014C | |
Key | ClaimType | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Type |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Card-Pinless | |
Account Details | CustomerId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | customer id |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 123456 | |
Account Details | IsEmployeeClaim | BOOLEAN | | CONDITIONAL | false | |
Account Details | AccountNumber | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Account ID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 0000123456 | |
Account Details | IsEnrolledInAutopay | BOOLEAN | | CONDITIONAL | TRUE | |
Account Details | NextPaymentDate | DATE | | CONDITIONAL | 2023-09-09 | |
Account Details | StatementCycleDate | DATE | | CONDITIONAL | 2023-09-09 | |
Account Details | AccountOpenDate | DATE | | Multiexcerpt include macro |
|---|
| macro_uuid | 8539b451-d921-460e-8dd1-53050f3060a7 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Account Open Date |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | 2023-09-09 | Available in 24.01.03. |
Account Details | AccountType | VARCHAR(32) | | Multiexcerpt include macro |
|---|
| macro_uuid | 8539b451-d921-460e-8dd1-53050f3060a7 |
|---|
| name | glossary_description |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| page | Account Open Date |
|---|
| addpanel | false |
|---|
|
| CONDITIONAL | “Deposit”, “Credit Card” | Available in 24.01.03. |
Card Details | CardType | VARCHAR(16) | | CONDITIONAL | Debit | |
Card Details | CardBIN | VARCHAR(8) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | BIN |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 412356, 41235678 | |
Card Details | CardNumberLast4 | VARCHAR(4) | Last 4 digits of the Card Number. | CONDITIONAL | 5555 | |
Claim Details | ReasonType | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Category |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Fraud | |
Claim Details | Reason | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Reason |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Stolen | |
Claim Details | ChannelOrigin | VARCHAR(32) | | ALWAYS | Online Banking | |
Claim Details | ClaimAmount | NUMBER(20,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Amount |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 123.45 | |
Claim Details | TotalClaimAmount | NUMBER(20,2) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Total Claim Amount |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 123.45 | |
Claim Details | CustomerContactDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Contact Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 | |
Claim Details | CustomerDiscoveryDate | DATE | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Customer Discovery Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 | |
Claim Details | IsPotentialAbuse | BOOLEAN | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Potential Abuse |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | FALSE | |
Claim Details | Status | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Status Work |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | RESOLVED-PAID | |
Claim Details | ProvisionalCreditDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | PROVISIONALCREDITDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Claim Details | PCDecision | VARCHAR(16) | | CONDITIONAL | Grant | |
Claim Details | Decision | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Claim Decision |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | Paid, Denied | |
Claim Details | HasIdentifiedSuspect | BOOLEAN | | Multiexcerpt include |
|---|
| macro_uuid | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Resolution Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Claim Details | PCDecisionFromIIDPreSubmission | VARCHAR(16) | | Multiexcerpt include |
|---|
| macro_uuid | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| MultiExcerptName | glossary_description |
|---|
| addpanel | false |
|---|
| PageWithExcerpt | PC Decision From IID PreSubmission |
|---|
|
| ALWAYS | AutoPay, Review | Available in 24.01.03. |
Claim Details | PCDecisionReason | VARCHAR(255) | | Multiexcerpt include |
|---|
| macro_uuid | db9d0b0b-3d45-4a33-9637-e2c1a4e0c2df |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| MultiExcerptName | glossary_description |
|---|
| addpanel | false |
|---|
| PageWithExcerpt | PC Decision Reason |
|---|
|
| CONDITIONAL | | Available in 24.01.03. |
Claim Details | ResolvedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Resolution Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Claim Details | InvestigationCompleteDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Investigation Completed Date |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Claim Details | ReclassificationCount | NUMBER(3,0) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reclassification Count |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 1 | |
Claim Details | RequiredDocumentCount | NUMBER(3,0) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Required Document Count |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 1 | |
Claim Details | TimeZone | VARCHAR(48) | | ALWAYS | America/Los_Angeles | |
Claim Details | WasPCManuallyWithheld | BOOLEAN | | Multiexcerpt include |
|---|
| macro_uuid | 110346a1-c1f8-45bd-bf93-efc782936b02 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reclassification Count |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | TRUE, FALSE | Available in 24.01.03. |
Compliance Details | RegE10DateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reg E 10 DateTime |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | PCDocRequirementSatisifedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| macro_uuid | 69e181af-8ebb-4e96-b6b2-96aebc3aa1e5 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reg E 10 DateTime |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegE10ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegE45DateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reg E DateTime |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegE90DateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegEThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ30DateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reg Z 30 DateTime |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ30ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ90DateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | Reg Z DateTime |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZ90ThresholdDateTime | TIMESTAMP_NTZ(9) | | CONDITIONAL | 2023-09-09 21:00:00 | |
Compliance Details | RegZPCThresholdDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| macro_uuid | 8205c579-7f38-4507-b8b9-68628f59264f |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| MultiExcerptName | glossary_description |
|---|
| addpanel | false |
|---|
| PageWithExcerpt | Reg Z Withholding Threshold Date |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | RegZPCDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| macro_uuid | 8205c579-7f38-4507-b8b9-68628f59264f |
|---|
| templateData | eJyLjgUAARUAuQ== |
|---|
| MultiExcerptName | glossary_description |
|---|
| addpanel | false |
|---|
| PageWithExcerpt | Reg Z Withholding Date |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Compliance Details | IsFCRA | BOOLEAN | Indicates whether the FCRA Override was applied to the claim. | CONDITIONAL | FALSE | |
Metadata | CreatedbyUserId | VARCHAR(64) | The username of the user that created the claim. | CONDITIONAL | devan.robertson@quavo.com | Available in 24.01.03. |
Metadata | SaveDateTime | TIMESTAMP_NTZ(9) | | ALWAYS | 2023-09-09 21:00:00 | |
Metadata | CreateDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | CREATEDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | SubmittedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| macro_uuid | 863749f2-d1af-469c-a9ba-f14473f15b1f |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | CREATEDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Metadata | StatusChangedDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| macro_uuid | 0029fa70-44a4-47ae-8b0d-98991ddce573 |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | CREATEDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Available in 24.01.03. |
Metadata | EventDateTime | TIMESTAMP_NTZ(9) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTDATETIME |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 2023-09-09 21:00:00 | |
Metadata | EventIdentifier | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTIDENTIFIER |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | 70b1c86d-d06f-4c93-bab2-0e938a4ef768 | |
Metadata | EventItemId | VARCHAR(64) | | Multiexcerpt include |
|---|
| MultiExcerptName | glossary_description |
|---|
| PageWithExcerpt | EVENTITEMID |
|---|
| shouldDisplayInlineCommentsInIncludes | false |
|---|
|
| ALWAYS | qvo-stg|2306060014C | |
