UPG_WF_MSG_AET

(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 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
3 FROM_ROLEUSER Character(30) VARCHAR2(30) NOT NULL From Roleuser
4 EMAIL_FLAG Character(1) VARCHAR2(1) NOT NULL Email Flag
5 WORKLIST_FLAG Character(1) VARCHAR2(1) NOT NULL Worklist Flag.........................................................
6 EMAIL_SUBJECT254 Character(254) VARCHAR2(254) NOT NULL Email Subject
7 REPORT_FILENAME Character(80) VARCHAR2(80) NOT NULL Attachment
8 GEN_MSG_PRIORITY Character(1) VARCHAR2(1) NOT NULL Priority
1=High
2=Medium
3=Low
9 URL1 Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
10 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)
11 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
13 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
14 ACTION Character(3) VARCHAR2(3) NOT NULL This field describes job action in job details record.
15 DELAY_DTTM DateTime(26) TIMESTAMP Delay Datetime
16 RB_WF_NOTIFY_WHEN Character(1) VARCHAR2(1) NOT NULL Notification delivery time
L=Send Later
N=Send Now
17 DONE_FLAG Character(1) VARCHAR2(1) NOT NULL Done Flag
18 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.
19 SEND_URL Character(1) VARCHAR2(1) NOT NULL SEND_URL
20 CMF_ID Character(36) VARCHAR2(36) NOT NULL Correspondence ID
21 CMF_INSTANCE_ID Character(36) VARCHAR2(36) NOT NULL Correspondence Instance ID
22 MERGE_DATE Date(10) DATE Correspondence Send Date
23 MERGE_TIME Time(15) TIMESTAMP Correspondence Send Time
24 SEND_DATE Date(10) DATE Correspondence Send Date
25 SEND_TIME Time(15) TIMESTAMP Correspondence Send Time
26 SUBMIT_DATE Date(10) DATE Correspondence Submit Date
27 SEND_TO_LONG Long Character CLOB TO Recipients
28 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
29 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
30 RB_DUMMY1 Character(3) VARCHAR2(3) NOT NULL Multi-purpose Dummy field-----
31 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
32 STEPNAME Character(80) VARCHAR2(80) NOT NULL Step Name
33 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
34 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
35 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.