HR_RUN_CNTL_REI

(SQL Table)
Index Back

HR Run Control - Reinstatement

HR_RUN_CNTL_REI contains input parameters for Application Engine - Execute Reinstatement. This record is used when execution of Reinstatement is requested from the Process Scheduler. There will be 1 row of Effective dated Job for each employee included as part of Reinstatement.

# 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 LBR_ROSTER_ID Character(11) VARCHAR2(11) NOT NULL Roster ID

Prompt Table: HR_LBR_ROSTER

4 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

5 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

Prompt Table: ACTN_REASON_TBL

6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance