DTTM_CREATEDFROM_ROLEUSERY/N Table Edit
Y/N Table Edit
1=High
2=Medium
3=Low
Default Value: 2
RB_WF_MSG_REPLY(SQL View) |
Index Back |
|---|---|
CRM Workflow Action Rqst ReplyCRM Workflow Acti |
| 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 |