HR_PAY_CAL_XREF

(SQL Table)
Index Back

HR - Pay Calendar XREF Table

The Pay Calendar record contains cycles for payroll processing created for Pay Groups. This XREF table will be used for HR Wage Progression processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

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

Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

Prompt Table: PAY_RUN_VW

5 PAY_CONFIRM_START Character(1) VARCHAR2(1) NOT NULL Payroll Confirmation Started

Y/N Table Edit

Default Value: N

6 PAY_CONFIRM_RUN Character(1) VARCHAR2(1) NOT NULL Payroll Confirmation Run

Y/N Table Edit

Default Value: N

7 PAY_CHECKS_RUN Character(1) VARCHAR2(1) NOT NULL Paychecks Run

Y/N Table Edit

Default Value: N

8 PAY_OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off-Cycle Calcs Outstanding

Y/N Table Edit

Default Value: N

9 PAY_OFF_CYCLE_CLS Character(1) VARCHAR2(1) NOT NULL Off-Cycle Closed

Y/N Table Edit

Default Value: N