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 Only applicable for dispute-level actions. Key AssignmentId VARCHAR(64) A unique ID associated with an Assignment. CONDITIONAL 70b1c86d-d06f-4c93-bab2-0e938a4ef768 Only applicable for actions associated with an assignment. Action Details ClaimDispute VARCHAR(32) Identifies a relationship to a claim or a dispute. ALWAYS Claim, Dispute Action Details FlowAction VARCHAR(128) An action availlable to the system and/or users to complete a task in a workflow. ALWAYS GetIssuerAlertStatus Action Details FlowType VARCHAR(128) The flow where a flow action is completed. ALWAYS FraudAlert Action Details TaskName VARCHAR(128) Identifies the name of a task/assignment. CONDITIONAL Pend for Ethoca Case Status Only applicable for actions associated with an assignment. Action Details AddedById VARCHAR(128) The unique ID of the operator that performed an action. ALWAYS Action Details CreateDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. ALWAYS 2023-09-09 21:00:00 Action Details SaveDateTime TIMESTAMP_NTZ(9) The datetime that the action was completed. ALWAYS 2023-09-09 21:00:00 Action Details Points NUMBER(5,2) Point value associated with an action. CONDITIONAL 15.00 Not in use. 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