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 UserId VARCHAR(64) A unique ID representing a single client. ALWAYS devan.robertson@quavo.com User Details IsAllowedAllClients BOOLEAN CONDITIONAL TRUE Only applicable when configured. User Details ClientsCSV VARCHAR(256) Comma-separated list of Client IDs. Generally seen when viewing user records to identify the clients the user has access to. CONDITIONAL P4114,P2870,P6839,P711,P531,P713 Only applicable when configured. User Details FirstName VARCHAR(64) Users First Name CONDITIONAL Devan Only applicable when configured. User Details LastName VARCHAR(64) Users Last Name CONDITIONAL Robertson Only applicable when configured. User Details UserRoles[].Name/USERROLE VARCHAR(128) List of User Groups assigned to a user profile. ALWAYS QFD_User User Details ISUSERDISABLED BOOLEAN Indicates if the user has been disabled. CONDITIONALS TRUE, FALSE Added in 25.01. Work Details ISUSERAVAILABLETORECEIVEWORK BOOLEAN Indicates if the user is configured to receive work via Get Next Work. CONDITIONAL TRUE, FALSE Added in 25.01. Work Details ISCLIENTUSER BOOLEAN Indicates whether the user is a client user. CONDITIONAL TRUE, FALSE Added in 25.01. Work Details BYPASSORGANIZATIONALFILTERING BOOLEAN CONDITIONAL TRUE, FALSE Added in 25.01. Work Details WORKREGULATORYMODE VARCHAR(32) Indicates the regulatory work mode applied. CONDITIONAL "Reg Only", "Non Reg Only", "Both" Added in 25.01. Work Details WORKROUTINGMODE VARCHAR(32) Indicates whether the user receives work based on general workgroups or specific assignment groups. CONDITIONAL "Workgroup", "Assignment Group" Added in 25.01. Work Details WORKHIGHDOLLARMODE VARCHAR(32) Indicates the regulatory work mode applied. CONDITIONAL “Low Dollar”, “High Dollar”, “Both” Added in 25.01. Work Details WORKALLOWEDACCOUNTTYPESCSV VARCHAR(3000) Comma-separated list of specific account types the user is configured to work. CONDITIONAL "CreditCard","Deposit" Added in 25.01. Work Details WORKALLOWEDCLAIMTYPESCSV VARCHAR(3000) Comma-separated list of specific claim types the user is configured to work. CONDITIONAL "ACH","ATMDEP","ATMWD","BalanceTransfer","BillPay","Card","CardPinless","CardPinned","Check","ConvenienceCheck","P2P","RTP","Unknown","Wire","Zelle" Added in 25.01. Work Details WORKALLOWEDCLAIMREASONTYPESCSV VARCHAR(3000) Comma-separated list of specific claim reasons the user is configured to work. CONDITIONAL "AccountMerchService","NonFraudATM","AuthChargeback","BalanceTransfer","BillPay","ConvenienceCheck","NonFraud","Fraud","FraudAccountIssue","NonFraudIncorrect","NonFraudMissing","MerchantNotRecognized","NonFraudRevoked" Added in 25.01. Work Details WORKALLOWEDASSIGNMENTGROUPSCSV VARCHAR(3000) Comma-separated list of specific assignment groups the user is configured to work. CONDITIONAL Daily Critical Assignments,Daily Maintenance Assignments,Final Investigation Deadline Assignments,High Dollar Assignments,Initial Review Assignments,Later Lifecycle Recovery Assignments,Manager Assignments,Next Recovery Deadline Assignments,Non Reg Assignments,Past Recovery/Reg Deadline Assignments,Unworkable Assignments Added in 25.01. Work Details ASSIGNMENTSCSV VARCHAR(3000) Comma-separated list of specific assignments the user is configured to work. "Initial Investigation","Provisional Credit Review" Added in 25.01. Metadata CreateDateTime TIMESTAMP_NTZ(9) The datetime that a record was created. ALWAYS 2023-09-09 21:00:00 Metadata UpdateDateTime TIMESTAMP_NTZ(9) The datetime that a record was updated. ALWAYS 2023-09-09 21:00:00 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|devan.robertson@quavo.com