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 Reclassification Details ReasonType VARCHAR(64) General categorization of the claim. For a more precise description, see Claim Reason. ALWAYS Fraud Reclassification Details Reason VARCHAR(64) Identifies the specific reason associated with the claim. ALWAYS Stolen Reclassification Details OriginalReason VARCHAR(64) Original Reason applied to the claim upon submission. ALWAYS Stolen Reclassification Details PreviousReasonType VARCHAR(64) ReasonType value prior to the reclassification. ALWAYS Fraud Reclassification Details PreviousReason VARCHAR(64) Reason value prior to the reclassification. ALWAYS Stolen Reclassification Details PerformedByOperatorId VARCHAR(128) The unique ID of the operator that performed an action. ALWAYS 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 56f34472-3412-4144-b4c7-430b928f1d24 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|2306050001D