DTTM_CREATEDFROM_ROLEUSERE=Email
W=Worklist
Default Value: W
1=High
2=Medium
3=Low
Default Value: 2
GEN_MSG_REPLY(SQL View) |
Index Back |
|---|---|
Generic Message Reply View |
| SELECT DTTM_CREATED , FROM_ROLEUSER , EMAIL_WL_FLAG , EMAIL_SUBJECT , REPORT_FILENAME , GEN_MSG_PRIORITY , %TextIn(EMAIL_TEXTLONG) FROM PS_GEN_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_WL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Email or Worklist?
E=Email W=Worklist Default Value: W |
| 4 | EMAIL_SUBJECT | Character(30) | VARCHAR2(30) NOT NULL | Subject of the email |
| 5 | REPORT_FILENAME | Character(80) | VARCHAR2(80) NOT NULL | Attachment |
| 6 | GEN_MSG_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low Default Value: 2 |
| 7 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |