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" ALWAYS 2306050001D Regulatory Details RegProtectionDecision VARCHAR(16) The regulatory protection action enforced by the system, such as Reg E 90 and Reg E 10. ALWAYS RegE10 Regulatory Details RegProtectionDecisionDateTime TIMESTAMP_NTZ(9) Datetime that Reg Protection Decision was processed. ALWAYS 2023-09-09 21:00:00 Regulatory Details PCDocRequirementSatisfiedDateTime TIMESTAMP_NTZ(9) Datetime that any applicable provisional credit document requirement was satisfied. CONDITIONAL 2023-09-09 21:00:00 Only applicable when documents are required AND received. Regulatory Details RegE10ProcessingOutcome VARCHAR(64) Defines the protective action taken by the system when the Reg E PC timeframe expired. CONDITIONAL DenyProvisionalCredit Only applicable when RegProtectionDecision is “RegE10”. Regulatory Details PCDenyReason VARCHAR(64) The reason provided for denying provisional credit. CONDITIONAL Missing Documentation Only applicable when PC was not granted. Dispute Details Status VARCHAR(64) Represents the current stage or step of a particular process or lifecycle, such as a claim or dispute. ALWAYS OPEN-ANALYZE 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|2306050001D