RUN_CNTL_BTCHMS(SQL Table) |
Index Back |
|---|---|
HR Run Control - ActionsRUN_CNTL_ACTION contains input parameters for SQR PER015 - Personnel Actions History. This record is used when SQR PER015 is requested from the Process Scheduler. There will be 1 row of data for each job action requested. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL |
User ID
Prompt Table: PRCSRQST_OPERVW |
| 4 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL |
Process Name
Prompt Table: PRCSRQST_PRCVW |
| 5 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: %EDITTABLE |
| 6 | MESSAGE_SRCH_CRIT | Character(1) | VARCHAR2(1) NOT NULL |
Message Search Criteria
N=Program Name O=Operator ID P=Process Instance R=Process Name Default Value: P |
| 7 | PROGRAM_NAME | Character(8) | VARCHAR2(8) NOT NULL |
Program Name
Prompt Table: MSG_LOG_PROG_VW |
| 8 | PI_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Process Instance Option
L=Use Latest Process Instance P=Use Other Default Value: L |
| 9 | INCLUDE_CANCEL | Character(1) | VARCHAR2(1) NOT NULL |
Include Statuses of Cancel
Y/N Table Edit Default Value: Y |
| 10 | INCLUDE_ERROR | Character(1) | VARCHAR2(1) NOT NULL |
Include Statuses of Error
Y/N Table Edit Default Value: Y |
| 11 | INCLUDE_MESSAGE | Character(1) | VARCHAR2(1) NOT NULL |
Include Status of Message
Y/N Table Edit Default Value: Y |
| 12 | INCLUDE_WARNING | Character(1) | VARCHAR2(1) NOT NULL |
Include Status of Warning
Y/N Table Edit Default Value: Y |
| 13 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |