Fields
Data Category Event Field/Column Name Data Type Definition 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 Correspondence Details CorrespondenceId VARCHAR Unique ID associated with a correspondence object (Letter, Email, etc.). ALWAYS c7358441-1cdf-46c9-a81e-58d7f8967f49 Correspondence Details EmailReceivedDateTime TIMESTAMP_NTZ(9) DateTime that an email was received. ALWAYS 2023-09-09 21:00:00 AI Processing Details EmailProcessedDateTime TIMESTAMP_NTZ(9) DateTime that an email was evaluated by AI. CONDITIONAL 2023-09-09 21:00:00 AI Processing Details AIEmailCategory VARCHAR Email classification as determined by AI. CONDITIONAL Auto Reply, Withdraw Request Correspondence Details EmailSubject VARCHAR Content of the email subject line. CONDITIONAL Re: #Secure# Message from Quavo Bank 2410230199C AI Processing Details UserValidationOutcome BOOLEAN Result of user validation review. CONDITIONAL TRUE, FALSE AI Processing Details ValidatedByUsername VARCHAR Username of the user that completed the AI classification review assignment. CONDITIONAL devan.robertson@quavo.com 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 EvemtItemId 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