COMPANYPrompt Table: COMPANY_TBL
PAYGROUPPrompt Table: PAYGROUP_TBL
PAY_END_DTY/N Table Edit
Y/N Table Edit
Y/N Table Edit
Y/N Table Edit
HP_CNTPAY_CALVW(SQL View) |
Index Back |
|---|---|
Pay Calendar ViewPay Calendar View used for Contract Pay |
| SELECT COMPANY , PAYGROUP , PAY_END_DT , PAY_BEGIN_DT , PAY_SHEETS_RUN , PAY_CALC_RUN , PAY_CONFIRM_RUN , PAY_OFF_CYCLE_CLS FROM PS_PAY_CALENDAR WHERE PAY_SHEETS_RUN = 'N' OR PAY_OFF_CYCLE_CLS = 'N' |
| # | 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 | PAY_BEGIN_DT | Date(10) | DATE NOT NULL | Pay Period Begin Date |
| 5 | PAY_SHEETS_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Paysheets Run
Y/N Table Edit |
| 6 | PAY_CALC_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Calculation Run
Y/N Table Edit |
| 7 | PAY_CONFIRM_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Confirmation Run
Y/N Table Edit |
| 8 | PAY_OFF_CYCLE_CLS | Character(1) | VARCHAR2(1) NOT NULL |
Off-Cycle Closed
Y/N Table Edit |