SSF_PAY_CALNDR

(SQL View)
Index Back

SSF Pay Calendar View

SSF Product View of PAY_CALENDAR. Can be used for related displays, prompt tables, etc.

SELECT COMPANY ,PAYGROUP ,PAY_END_DT ,RUN_ID ,PAY_OFF_CYCLE_CAL ,PAY_BEGIN_DT ,CHECK_DT ,PAY_PDS_PER_YEAR ,REVERSE_FLAG ,PAY_SHEETS_RUN ,PAY_PRECALC_RUN ,PAY_CALC_RUN ,PAY_CONFIRM_START ,PAY_CONFIRM_RUN ,PAY_CHECKS_RUN ,PAY_OFF_CYCLE ,PAY_OFF_CYCLE_CLS ,GL_INTERFACE_RUN ,SINGLE_CHECK ,CONFIRM_ERRORS FROM PS_PAY_CALENDAR

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

Prompt Table: HCR_COMPANY_I

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

Prompt Table: SSF_PAYGRP_VW

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
5 PAY_OFF_CYCLE_CAL Character(1) VARCHAR2(1) NOT NULL Off-Cycle Calendar?

Y/N Table Edit

Default Value: N

6 PAY_BEGIN_DT Date(10) DATE NOT NULL Pay Period Begin Date
7 CHECK_DT Date(10) DATE NOT NULL Check date.
8 PAY_PDS_PER_YEAR Number(3,0) SMALLINT NOT NULL Pay Periods Per Year
9 REVERSE_FLAG Character(1) VARCHAR2(1) NOT NULL Reverse Accruals

Y/N Table Edit

Default Value: N

10 PAY_SHEETS_RUN Character(1) VARCHAR2(1) NOT NULL Paysheets Run

Y/N Table Edit

Default Value: N

11 PAY_PRECALC_RUN Character(1) VARCHAR2(1) NOT NULL Payroll Preliminary Calc Run

Y/N Table Edit

Default Value: N

12 PAY_CALC_RUN Character(1) VARCHAR2(1) NOT NULL Payroll Calculation Run

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

18 GL_INTERFACE_RUN Character(1) VARCHAR2(1) NOT NULL GL Interface Run

Y/N Table Edit

Default Value: N

19 SINGLE_CHECK Character(1) VARCHAR2(1) NOT NULL Multiple State Employer

Y/N Table Edit

Default Value: N

20 CONFIRM_ERRORS Character(1) VARCHAR2(1) NOT NULL Continue With Errors

Y/N Table Edit