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 | DTTM_CREATED | DateTime(26) | TIMESTAMP | Datetime Created |
2 | FROM_ROLEUSER | 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 |