RUN_CNTL_IDOPRIDAPPR=Send For Approval
CNCL=Cancelled
COMP=Completed
IP=In Progress
PREV=Preview and Personalize
PVRD=Preview Ready
SBMT=Submitted
Y/N Table Edit
Default Value: N
0=All
1=Email
2=Print
3=Fax
4=Print & Fax
RBC_REQSTRUNCTL(SQL Table) |
Index Back |
|---|---|
CM Request Run Control TableCorrespondence Management Request Run Control Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | CMF_ID | Character(36) | VARCHAR2(36) NOT NULL | Correspondence ID |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | CMF_REQST_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Correspondence Request Status
APPR=Send For Approval CNCL=Cancelled COMP=Completed IP=In Progress PREV=Preview and Personalize PVRD=Preview Ready SBMT=Submitted |
| 6 | DATA_READY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
XML Data extraction Ready status. It is used in DOC Merge Process
Y/N Table Edit Default Value: N |
| 7 | RB_DELV_CHANNEL | Character(1) | VARCHAR2(1) NOT NULL |
Delivery Channel.
Please make sure to update the RB_DELV_CHANNEL2 field with the XLAT values in future when Fax channel is enabled. RB_DELV_CHANNEL2 field is used in the Correspondence search.
0=All 1=Email 2=Print 3=Fax 4=Print & Fax |
| 8 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |