RB_WF_MSG_FWD

(SQL View)
Index Back

CRM Workflow Action Rqst Fwd

CRM Workflow Action Request Forward

SELECT DTTM_CREATED , FROM_ROLEUSER , EMAIL_FLAG , worklist_flag , EMAIL_SUBJECT254 , REPORT_FILENAME , GEN_MSG_PRIORITY , EMAIL_TEXTLONG FROM PS_RB_WF_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_FLAG Character(1) VARCHAR2(1) NOT NULL Email Flag

Y/N Table Edit

4 WORKLIST_FLAG Character(1) VARCHAR2(1) NOT NULL Worklist Flag.........................................................

Y/N Table Edit

5 EMAIL_SUBJECT254 Character(254) VARCHAR2(254) NOT NULL Email Subject
6 REPORT_FILENAME Character(80) VARCHAR2(80) NOT NULL Attachment
7 GEN_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low

Default Value: 2

8 EMAIL_TEXTLONG Long Character CLOB Message Text