GEN_MSG_DEFN(SQL Table) |
Index Back |
---|---|
Generic Message Definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2 |
|
2 | 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 |