OPRIDPrompt Table: OPRDEFN2
MESSAGE_IDE=Email
W=Worklist
Default Value: E
1=High
2=Medium
3=Low
Default Value: 2
GEN_MSG_DEFN(SQL Table) |
Index Back |
|---|---|
Generic Message Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2 |
| 2 | MESSAGE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Message ID |
| 3 | EMAIL_SUBJECT | Character(30) | VARCHAR2(30) NOT NULL | Subject of the email |
| 4 | EMAIL_WL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Email or Worklist?
E=Email W=Worklist Default Value: E |
| 5 | GEN_MSG_PRIORITY | Character(1) | VARCHAR2(1) NOT NULL |
Priority
1=High 2=Medium 3=Low Default Value: 2 |
| 6 | EMAIL_TEXTLONG | Long Character | CLOB | Message Text |