SSF_PAY_CALNDR(SQL View) |
Index Back |
---|---|
SSF Pay Calendar ViewSSF 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 |