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" CONDITIONAL 2306050001D Not applicable for letter approvals. Approval Details DisputeAmount NUMBER(9,2) The current amount in dispute, accounting for any recoveries or adjustments. CONDITIONAL 99.95 Not applicable for letter approvals. Approval Details ApprovalType VARCHAR(64) The type of action that resulted in an approval assignment. Possible values include "Deny Dispute", "Provisional Credit", "Send Letter", and "Write Off". ALWAYS Write Off, Provisional Credit, Deny Dispute, Letter Approval Details Outcome VARCHAR(32) Outcome of the review: "Approve" or "Deny" ALWAYS Approve, Decline Approval Details ApprovalInfo VARCHAR(64) Additional details of the approval, such as the name of the letter being sent. CONDITIONAL Additional Information Only applicable for letter approvals. Approval Details CreatedByUserID VARCHAR(64) ID of the user that performed the action that led to the approval requirement. ALWAYS devan.robertson@quavo.com Approval Details PerformedByUserID VARCHAR(64) ID of the user, typically a manager, that completed the approval task. 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