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 CONDITIONAL 2306060014C Only applicable for assignments associated with a claim. For example, orphan email assignments will not have a value. Key DisputeId VARCHAR(32) Unique ID associated with a disputed transaction. Format: YYMMDD#####"D" CONDITIONAL 2306050001D Only applicable for dispute-level assignments. Key AssignmentId VARCHAR(64) A unique ID associated with an Assignment. ALWAYS 8a62b606-9629-44e1-9961-01b9c0c6f6a2 Assignment Details FlowType VARCHAR(128) The flow where a flow action is completed. ALWAYS CollectCustomerDocumentation Assignment Details TaskLabel VARCHAR(128) Identifies the name of a task/assignment. ALWAYS Pending Documents Assignment Details WorkGroup VARCHAR(128) Defines the function and/or skillset require to complete a task and determines who will work the task. Work Groups have been deprecated in favor of Assignment Groups. ALWAYS Pending Assignment Details WorkQueue VARCHAR(128) Also referred to as a "queue" or "workbasket", a work queue is a container assignments and is aligned to a specific work group that works the assignments. ALWAYS PendingDocuments Assignment Details ServiceLevelName VARCHAR(128) Name of the Service Level Agreement (SLA) rule associated with a flow assignment. CONDITIONAL PendingDocuments Only applicable for assignments that have a configured SLA. Primarily used for system assignments. Assignment Details AssignmentState VARCHAR(16) Represents the state of an assignment when an event is created: "Created" or "Completed". ALWAYS "Created", "Completed" Assignment Details PerformedById VARCHAR(128) The unique ID of the operator that performed an action. CONDITIONAL devan.robertson@quavo.com Assignment Details GoalDateTime TIMESTAMP_NTZ(9) A Service Level Agreement threshold associated with an assignment. CONDITIONAL 2023-09-09 21:00:00 Only applicable for assignments that have a configured SLA. Primarily used for system assignments. Assignment Details DeadlineDateTime TIMESTAMP_NTZ(9) A Service Level Agreement threshold associated with an assignment. Typically, this is the datetime that some action must/will occur. CONDITIONAL 2023-09-09 21:00:00 Only applicable for assignments that have a configured SLA. Primarily used for system assignments. Assignment Details GoalExecutedDateTime TIMESTAMP_NTZ(9) Represents the date that the SLA goal was executed. CONDITIONAL 2023-09-09 21:00:00 Only applicable for assignments that have a configured SLA. Primarily used for system assignments. Assignment Details DeadlineExecutedDateTime TIMESTAMP_NTZ(9) Represents the date that the SLA deadline was executed. CONDITIONAL 2023-09-09 21:00:00 Only applicable for assignments that have a configured SLA. Primarily used for system assignments. Claim Details NextRecoveryDateTime TIMESTAMP_NTZ(9) Represents the date that the next recovery action must be completed by an issuer or acquirer to continue in the recovery process. CONDITIONAL 2023-09-09 21:00:00 Only applicable for dispute-level assignments where a recovery deadline exists. Claim Details FinalRegDateTime TIMESTAMP_NTZ(9) Represents the date that the regulatory resolution SLA is scheduled to expire. CONDITIONAL 2023-09-09 21:00:00 Only applicable for assignments on a claim where a regulatory deadline exists. Claim Details ProvisionalCreditDateTime TIMESTAMP_NTZ(9) Datetime when provisional credit was granted on a claim. CONDITIONAL 2023-09-09 21:00:00 Only applicable when provisional credit has been granted. Claim Details CustomerContactDate DATE Represents the date that the claim was received from the accountholder. CONDITIONAL 2023-09-09 Only applicable for assignments associated with a specific claim. Claim Details ClaimReasonType VARCHAR(64) See Claim Category. For a more precise description, see Claim Reason. CONDITIONAL Fraud Only applicable for assignments associated with a specific claim. Claim Details ClaimType VARCHAR(64) See Transaction Type. CONDITIONAL CardPinless Only applicable for assignments associated with a specific claim. Assignment Details CreateDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. ALWAYS 2023-09-09 21:00:00 Assignment Details FlowInError VARCHAR(64) For internal triaging purposes only. CONDITIONAL ReadNewCorr_148 Only applicable for error assignments. For internal triage purposes only. Assignment Details ErrorStep VARCHAR(32) For internal triaging purposes only. CONDITIONAL SubProcess2 Only applicable for error assignments. For internal triage purposes only. Assignment Details ErrorMessage VARCHAR(256) For internal triaging purposes only. CONDITIONAL ProblemFlow_AddFlowFail Only applicable for error assignments. For internal triage purposes only. Assignment Details AssignmentStatus VARCHAR(64) The status of the claim or dispute at the time the assignment was created. ALWAYS 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