PAY_CALC_RUNCTL

(SQL Table)
Index Back

Payroll Calc Run Control

The Pay Calculation Run Control record manages the pay calculation 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 PROCESS_ON_OFF Character(1) VARCHAR2(1) NOT NULL Process On-Cycle or Off-Cycle
F=Process Off-Cycle Checks
O=Process On-Cycle Checks
5 PRELIMINARY_CALC Character(1) VARCHAR2(1) NOT NULL Preliminary Calculation Run

Y/N Table Edit

Default Value: Y

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

Prompt Table: COMPANY_TBL

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

Prompt Table: PAYGROUP_TBL

8 PAY_END_DT Date(10) DATE Pay Period End Date

Prompt Table: PAY_CALENDAR

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

Y/N Table Edit

Default Value: Y

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

Prompt Table: PAY_PAGE_WORK

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

Prompt Table: PAY_PAGE_WORK

12 CALC_SELECT Character(1) VARCHAR2(1) NOT NULL Select Checks to Calculate
A=(Re)Calculate All Checks
N=Only Calculate Where Needed

Default Value: N

13 XFER_CALC_ERRS Character(1) VARCHAR2(1) NOT NULL Transfer Calc Errors

Y/N Table Edit

Default Value: N

14 PROC_ERR086 Character(1) VARCHAR2(1) NOT NULL Process Error 086

Default Value: Y