RUN_CNTL_DEPT

(SQL Table)
Index Back

HR Run Control - Departments

RUN_CNTL_REQSN contains input parameters for SQR APP004 - Requisition Posting. This record is used when SQR APP004 is requested from the Process Scheduler. There will be 1 row of data for each job posting 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_HR.SETID

Prompt Table: SETID_TBL

4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL