HR_RUN_CNTL_LAY (SQL Table)	Index Back
HR Run Control - Layoff HR_RUN_CNTL_LAY contains input parameters for Application Engine - Execute Layoff. This record is used when execution of Layoff is requested from the Process Scheduler. There will be 1 row of Effective dated Job for each employee included as part of Layoff.

HR_RUN_CNTL_LAY

(SQL Table)

HR Run Control - Layoff

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

Parent Record Of HR_RUN_CNTL_LY2

# 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

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 LBR_PROP_TERM_DT Date(10) DATE Proposed Termination Date

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

#	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
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	LBR_PROP_TERM_DT	Date(10)	DATE	Proposed Termination Date
7	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance