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