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) |
