RB_WF_WL_GRP(SQL Table) |
Index Back |
|---|---|
CRM Workflow Group WorklistCRM Workflow Group Worklist Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Group Worklist Nameg | |
| 2 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 3 | RB_WF_WL_PRIVATE | Character(1) | VARCHAR2(1) NOT NULL |
Private Worklist
Y/N Table Edit |
| 4 | QUEUE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Group Worklist is ERMS Queue
Y/N Table Edit Default Value: N |
| 5 | MCFUQQUEUEID | Character(32) | VARCHAR2(32) NOT NULL | Queue ID |
| 6 | AUTO_ACCEPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Auto Accept
Y/N Table Edit Default Value: N |
| 7 | SLA_TIME_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Unit of time to use in SLA units for Mailbox
D=Day(s) H=Hour(s) M=Minute(s) Default Value: M |
| 8 | SLA_TIME_UNIT1 | Character(1) | VARCHAR2(1) NOT NULL |
Unit of time to use in SLA units for Mailbox
D=Day(s) H=Hour(s) M=Minute(s) Default Value: M |
| 9 | INTERNAL_TIMEOUT | Number(3,0) | SMALLINT NOT NULL | Warning Notification |
| 10 | EXTERNAL_TIMEOUT | Number(3,0) | SMALLINT NOT NULL | Final Notification |
| 11 | EMAIL_ADD_CASE_CB | Character(1) | VARCHAR2(1) NOT NULL |
Checkbox to indicate a Case is to be created for every new Inbound Email.
Y/N Table Edit Default Value: N |
| 12 | BUSINESS_UNIT_RC | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit field for Case identified in Quality
Prompt Table:
BUS_UNIT_TBL_FS
|
| 13 | DISP_TMPL_FAM_CD | Character(30) | VARCHAR2(30) NOT NULL |
Display Template Family Code
Prompt Table:
RDT_TMPL_FAMILY
|