RC_PAY_UNSHT

(SQL Table)
 Index Back

Payroll Un-sheet Run Control

This Run Control Record manages the Payroll Confirmation process

# 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 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

Prompt Table: PAY_RUN_TBL

4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

6 PAY_END_DT Date(10) DATE Pay Period End Date

Prompt Table: PAY_CALENDAR

7 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Default Value: Y

8 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #

Prompt Table: PAY_PAGE_WORK

9 PAGE_NUM_THRU Number(4,0) SMALLINT NOT NULL Thru Page Number

Prompt Table: PAY_PAGE_WORK

10 CYCLE_SELECT Character(1) VARCHAR2(1) NOT NULL Off-Cycle
B=Both
F=Off-Cycle
O=On-Cycle

Default Value: O