GEN_MSG_FORWARD

index back

Generic Message Forward 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 Field Type Column Type Description
DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
FROM_ROLEUSER Character(30) VARCHAR2(30) NOT NULL From Roleuser
EMAIL_WL_FLAG Character(1) VARCHAR2(1) NOT NULL Email or Worklist?
E=Email
W=Worklist

Default: W

EMAIL_SUBJECT Character(30) VARCHAR2(30) NOT NULL Subject of the email
REPORT_FILENAME Character(80) VARCHAR2(80) NOT NULL Attachment
GEN_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low

Default: 2

EMAIL_TEXTLONG Long Character CLOB Message Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19