RB_WF_MSG

(SQL Table)
Index Back

CRM Workflow Action Request

CRM Workflow Action Request. Persistent storage of action request parameters and message request

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DTTM_CREATED DateTime(26) TIMESTAMP NOT NULL Datetime Created
2 FROM_ROLEUSER Character(30) VARCHAR2(30) NOT NULL From Roleuser
3 EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Email Flag
4 WORKLIST_FLAG Character(1) VARCHAR2(1) NOT NULL Worklist Flag.........................................................
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 URL1 Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
9 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
10 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
11 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
12 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
13 ACTION Character(3) VARCHAR2(3) NOT NULL This field describes job action in job details record.
14 DELAY_DTTM DateTime(26) TIMESTAMP Delay Datetime
15 RB_WF_NOTIFY_WHEN Character(1) VARCHAR2(1) NOT NULL Notification delivery time
L=Send Later
N=Send Now
16 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag
17 RB_ACT_RQST_CD Character(30) VARCHAR2(30) NOT NULL Action Request Code - this code is used primarily for Quality Worklist/Workflow when 'Assign To' is manually entered.
18 SEND_URL Character(1) VARCHAR2(1) NOT NULL SEND_URL
19 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID
20 EMAIL_TEXTLONG Long Character CLOB Message Text