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 | |
Transaction Details | Network | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Network |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | Mastercard, Visa | |
Claim Details | ClaimChannel | VARCHAR(32) | Multiexcerpt include |
---|
macro_uuid | 5685cd1e-99c2-40db-9a77-74d274228986 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Claim Channel |
---|
|
| ALWAYS | Online Banking | |
Card Details | CardType | VARCHAR(16) | Multiexcerpt include |
---|
macro_uuid | 97e89f13-1c2e-41c7-925f-3c97f32515db |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | BIN |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | Debit | |
Card Details | BIN | VARCHAR(8) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | BIN |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 412356, 41235678 | |
Transaction Details | TransactionType | VARCHAR | Multiexcerpt include macro |
---|
macro_uuid | 3195254b-6a01-4d6a-9f3d-3dfe0f7f14a1 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Transaction Type |
---|
addpanel | false |
---|
|
| ALWAYS | ATM | |
Key | ClaimId | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Claim ID |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | 2306060014C | |
Key | DisputeId | VARCHAR(32) | Multiexcerpt include macro |
---|
macro_uuid | a3e31307-8cb9-40d8-8eef-f74f27879680 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Dispute ID |
---|
addpanel | false |
---|
|
| ALWAYS | 2306060014D | |
Claim Details | ClaimStatus | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Status Work |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | RESOLVED-PAID | |
Dispute Details | DisputeStatus | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Status Work |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | RESOLVED-PAID | |
Dispute Details | DisputeStatusType | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Status Work |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | | |
Dispute Details | Decision | VARCHAR(64) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Claim Decision |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | Paid, Denied | |
Dispute Details | DenyReason | VARCHAR | Multiexcerpt include macro |
---|
macro_uuid | 2e92bee9-0ad2-4bd4-a47b-9c6aee2a8ac7 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Deny Reason |
---|
addpanel | false |
---|
|
| CONDITIONAL | No Error | |
Transaction Details | TransactionDate | DATE | Multiexcerpt include macro |
---|
macro_uuid | f9b82b6c-1d48-4821-afec-d7c7a4493a68 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Transaction Date |
---|
addpanel | false |
---|
|
| ALWAYS | 2023-09-09 | |
Claim Details | CreateDateContactDate | DATE | Multiexcerpt include |
---|
macro_uuid | 45c8dff0d99ef6b8-944fca27-4e534139-8ee38c27-da245af4a17679c2824a1215 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | CREATEDATETIMECustomer Contact Date |
---|
|
| CONDITIONALALWAYS | 2023-09-09 | |
Claim Dispute Details | CustomerContactDateCreateDate | DATE | Multiexcerpt include |
---|
macro_uuid | d99ef6b845c8dff0-ca27944f-41394e53-8c278ee3-79c2824a1215da245af4a176 |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Customer Contact DateCREATEDATETIME |
---|
|
| CONDITIONALALWAYS | 2023-09-09 | |
Claim Dispute Details | ClaimAmountInvestigationDate | NUMBER(20,2TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
macro_uuid | 261deb9e-b155-44f1-9f3e-b8d10e211bcd |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Claim AmountInvestigation Completed Date |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 123.45 | Claim Details | ClaimState | VARCHAR2023-09-09 21:00:00 | |
Dispute Details | ResolvedDate | TIMESTAMP_NTZ(9) | VARCHAR(64 Multiexcerpt include |
---|
macro_uuid | 261deb9e-b155-44f1-9f3e-b8d10e211bcd |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description | addpanel | false |
---|
PageWithExcerpt | Claim Status Type |
---|
|
| ALWAYS | OPEN | Dispute Details | Decision | Resolution Date | shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | |
Transaction Details | AuthorizationStatus | VARCHAR(32) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Claim DecisionAuthorization Status |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONALALWAYS | PaidPending, DeniedPosted | |
Claim Transaction Details | DiscoveryDate | DATEMerchantCategoryCode | VARCHAR(6) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Customer Discovery DateMerchant Category Code |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 2023-09-09 | Compliance 8999 | |
Transaction Details | InvestigationDate | TIMESTAMP_NTZ(9) | Merchant | | 2023-09 Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Investigation Completed Date |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 09 21:00:00 | Compliance Details | ResolutionDeadline | TIMESTAMP_NTZ(9) | multiexcerpt-include-macro |
---|
macro_uuid | 027fa8efde3e24ca-0adf565a-4d6441c8-8d22b800-eb934d764d70c2659d0922c2 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Regulatory Resolution DeadlineMerchant Name |
---|
addpanel | false |
---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Claim Details | ResolvedDate | TIMESTAMP_NTZ(9) | Multiexcerpt include | MultiExcerptNameALWAYS
| PAYPAL | |
Transaction Details | POSEntryMode | | 2023-09-09 21:00:00 Multiexcerpt include macro |
---|
macro_uuid | de3e24ca-565a-41c8-b800-c2659d0922c2 |
---|
name | glossary_description |
---|
PageWithExcerpt | Resolution Date |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | templateData | eJyLjgUAARUAuQ== |
---|
page | POS Entry Mode |
---|
addpanel | false |
---|
|
| CONDITIONAL | 81 | |
Transaction Details | AuthorizationStatus | VARCHAR(32)TransactionDescription | | Dispute Details | DisputeCount | NUMBER(3,0 Multiexcerpt include | MultiExcerptName-macro |
---|
macro_uuid | de3e24ca-565a-41c8-b800-c2659d0922c2 |
---|
name | glossary_description |
---|
PageWithExcerpt | Authorization Status |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| ALWAYS | Pending, Posted | Transaction Details | MerchantCategoryCode | VARCHAR(6) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Merchant Category Code |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 4829 | Risk Details | PotentialAbuse | BOOLEAN | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Potential Abuse |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | FALSE | Risk Details | EmployeeClaim | BOOLEAN | Multiexcerpt include |
---|
macro_uuid | 91afd1e2-a292-4a59-a8a4-669839e9b53a |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Potential Abuse |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | false | Claim Details | PCDecision | VARCHAR(16) | Multiexcerpt include |
---|
macro_uuid | 91afd1e2-a292-4a59-a8a4-669839e9b53a |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | PC Decision |
---|
|
| CONDITIONAL | Grant | Claim Details | PCDate | TIMESTAMP_NTZ(9) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | PROVISIONALCREDITDATETIME |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 2023-09-09 21:00:00 | Claim Details | Reclassifications | NUMBER(3,0) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Reclassification Count |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 1 | Claim Details | RequiredDocuments | NUMBER(3,0) | Multiexcerpt include |
---|
MultiExcerptName | glossary_description |
---|
PageWithExcerpt | Required Document Count |
---|
shouldDisplayInlineCommentsInIncludes | false |
---|
|
| CONDITIONAL | 1 |
Metadata | CreatedBy | VARCHAR(64) | The username of the user that created the claim. | CONDITIONAL | devan.robertson@quavo.com | Available in 24.01.03. |
| templateData | eJyLjgUAARUAuQ== |
---|
page | Transaction Description |
---|
addpanel | false |
---|
|
| ALWAYS | PAYPAL *CASHAPP0777701 402-935-7733 CA | |
Dispute Details | DisputeAmount | NUMBER(20,2) | Multiexcerpt include |
---|
macro_uuid | 6e32305a103f1606-35071b62-48ee436a-9aa381bb-09af5eaba4e5d17588afd4cb |
---|
templateData | eJyLjgUAARUAuQ== |
---|
MultiExcerptName | glossary_description |
---|
addpanel | false |
---|
PageWithExcerpt | Dispute CountAmount |
---|
|
| CONDITIONAL2 | 123.59 | |
Dispute Transaction Details | DisputeAmountTransactionAmount | NUMBER(20,2) | Multiexcerpt include |
---|
macro_uuid | 103f160623775cb8-919d-1b624041-436a-81bb-d17588afd4cb90f7-115777927901 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== | MultiExcerptName |
---|
glossary_descriptionpage | Transaction Amount | addpanel | false | PageWithExcerpt
---|
|
| ALWAYS | 123.59 | |
Dispute Details | AccoundholderAmount | NUMBER(20,2) | Amount of all accountholder adjustments. | CONDITIONAL | 123.59 | |
Dispute Details | MerchantCreditAmount | NUMBER(20,2) | Multiexcerpt include macro |
---|
macro_uuid | 27d56e9c-828f-40d8-8c30-5ae5841cecd6 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Merchant Credit Balance |
---|
addpanel | false |
---|
|
| CONDITIONAL | 123.59 | |
Dispute Details | RecoveredAmount | NUMBER(20,2) | Multiexcerpt include macro |
---|
macro_uuid | 5835dccc-cf95-4910-9bc2-9c45ad829860 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Recovered Amount |
---|
addpanel | false |
---|
|
| CONDITIONAL | 123.59 | |
Dispute Details | LossAmount | NUMBER(20,2) | Multiexcerpt include macro |
---|
macro_uuid | bec857fa-cc36-4255-a95d-491416e54f60 |
---|
name | glossary_description |
---|
templateData | eJyLjgUAARUAuQ== |
---|
page | Loss Balance |
---|
addpanel | false |
---|
|
| CONDITIONAL | 123.59 | |
Dispute Details | DeniedAmount | NUMBER(20,2) | Total amount denied. | CONDITIONAL | 123.59 | |