RB_WF_MSG_FWD(SQL View) |
Index Back |
|---|---|
CRM Workflow Action Rqst FwdCRM Workflow Action Request Forward |
| SELECT DTTM_CREATED , FROM_ROLEUSER , EMAIL_FLAG , worklist_flag , EMAIL_SUBJECT254 , REPORT_FILENAME , GEN_MSG_PRIORITY , EMAIL_TEXTLONG FROM PS_RB_WF_MSG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DateTime(26) | TIMESTAMP | Datetime Created | |
| 2 | Character(30) | VARCHAR2(30) NOT NULL | From Roleuser | |
| 3 | EMAIL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Email Flag
Y/N Table Edit |
| 4 | WORKLIST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Worklist Flag.........................................................
Y/N Table Edit |
| 5 | EMAIL_SUBJECT254 | Character(254) | VARCHAR2(254) NOT NULL | Email Subject |
| 6 | REPORT_FILENAME | Character(80) | VARCHAR2(80) NOT NULL | Attachment |
| 7 | GEN_MSG_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low Default Value: 2 |
| 8 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |