Fields
Data Category Event Field/Column Name Data Type Description Applicability Sample Value Notes Key TenantId VARCHAR(32) Unique ID associated with each Quavo client. ALWAYS qvo-stg Key ClientId VARCHAR(64) A unique ID representing a single client. ALWAYS Default Key ClaimId VARCHAR(32) Unique ID associated with a claim. Format: YYMMDD<Ordinal Number>"C" Example: 2405230003C ALWAYS 2306060014C Key DisputeId VARCHAR(32) Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" ALWAYS 2306050001D Posting Details PostingMatchList[].TransactionDate/TRANSACTIONDATE DATE The date of the transaction, as provided by the system of record. This generally represents the Posting Date. CONDITIONAL 2023-10-07 Only applicable when provided by the System of Record. Posting Details PostingMatchList[].AuthorizationCode/AUTHCODE VARCHAR(10) A credit card authorization or approval code is an alphanumeric string generated at the POS. Normally consisting of five to six characters, this one-time approval code is unique to each transaction. CONDITIONAL 031832 Only applicable when provided by the System of Record. Posting Details PostingMatchList[].TransactionId/TRANSACTIONID VARCHAR(256) A unique ID associated with a transaction. This value is provided by the transaction system of record. CONDITIONAL 5315158617D1116187908 Only applicable when provided by the System of Record. Posting Details PostingMatchList[].PostingDate/POSTINGDATE DATE The date the transaction posted to the customer/member account. CONDITIONAL 2023-0909 Only applicable when provided by the System of Record. Posting Details PostingMatchList[].Description/DESCRIPTION VARCHAR(256) A description of the transaction as provided by the system of record. Typically, this will match what the customer/member sees on their account statement. CONDITIONAL STARLINK INTERNET Only applicable when provided by the System of Record. Posting Details PostingMatchList[].MerchantName/MERCHANTNAME VARCHAR(256) Name of the business providing goods or services, as provided by the system of record. CONDITIONAL STARLINK INTERNET Only applicable when provided by the System of Record. Posting Details PostingMatchList[].Amount/AMOUNT NUMBER(9,2) The amount of the posted transaction. ALWAYS 133.13 Posting Details AuthMatchingOutcome/OUTCOME VARCHAR(16) For merchant credit checking, this represents the result of the check or user review. ALWAYS "Auto", "Manual", "No Match" Posting Details PostingMatchList[].Iteration/ITERATION NUMBER(2,0) For matching algorithms, such as merchant credit or authorization posting, this number represents the the highest probability rule that resulted in a match. CONDITIONAL 1 Only applicable when a potential match is identified. Posting Details PostingMatchList[].MatchResult/MATCHRESULT VARCHAR(16) For matching algorithms, such as merchant credit or authorization posting, this represents whether a match was applied automatically or referred to a user. CONDITIONAL "Auto Match", "Review" Only applicable when a potential match is identified. Posting Details PostingMatchList[].PostedDisputeId/POSTEDDISPUTEID VARCHAR(32) Unique ID associated with the posting record of a disputed authorization. Format: YYMMDD#####"D" CONDITIONAL 2310110380D Only applicable for authorizations that post. Metadata EventDateTime TIMESTAMP_NTZ(9) The datetime that the event was recorded. ALWAYS 2023-09-09 21:00:00 Metadata EventIdentifier VARCHAR(64) A unique ID associated with each business event. ALWAYS 70b1c86d-d06f-4c93-bab2-0e938a4ef768 Metadata EventItemId VARCHAR(64) An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event. ALWAYS qvo-stg|2302030002D