COMPANYPAYGROUPPAY_END_DTPYKB_CN_CAL_VW(SQL View) |
Index Back |
|---|---|
Payroll Insights CAN CalendarPayroll Insights Canada Calendar View |
| SELECT A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT ,A.RUN_ID ,A.PAY_BEGIN_DT ,A.PAY_OFF_CYCLE_CAL ,A.PAY_SHEETS_RUN ,A.PAY_CALC_RUN ,A.PAY_CONFIRM_RUN ,A.ADVICE_RUN ,A.PDF_ADVICE ,A.PAYCHECKS_RUN ,A.PDF_PAYCHECK ,A.GL_INTERFACE_RUN ,A.CA_GL_INTFC_RUN ,A.PROC_DTTMSTAMP FROM PS_PAY_CALENDAR A ,PS_PAYGROUP_TBL B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_PAYGROUP_TBL B2 WHERE B2.COMPANY = B.COMPANY AND B2.PAYGROUP = B.PAYGROUP AND B2.EFFDT <= %CurrentDateIn) AND B.COUNTRY = 'CAN' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | PAYGROUP |
Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 3 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 4 | RUN_ID | Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 5 | PAY_BEGIN_DT | Date(10) | DATE | Pay Period Begin Date |
| 6 | PAY_OFF_CYCLE_CAL | Character(1) | VARCHAR2(1) NOT NULL | Off-Cycle Calendar |
| 7 | PAY_SHEETS_RUN | Character(1) | VARCHAR2(1) NOT NULL | Paysheets Run |
| 8 | PAY_CALC_RUN | Character(1) | VARCHAR2(1) NOT NULL | Payroll Calculation Run |
| 9 | PAY_CONFIRM_RUN | Character(1) | VARCHAR2(1) NOT NULL | Payroll Confirmation Run |
| 10 | ADVICE_RUN | Character(1) | VARCHAR2(1) NOT NULL | Advice Forms |
| 11 | PDF_ADVICE | Character(1) | VARCHAR2(1) NOT NULL | PDF Advice Forms |
| 12 | PAYCHECKS_RUN | Character(1) | VARCHAR2(1) NOT NULL | Paychecks |
| 13 | PDF_PAYCHECK | Character(1) | VARCHAR2(1) NOT NULL | PDF Paychecks |
| 14 | GL_INTERFACE_RUN | Character(1) | VARCHAR2(1) NOT NULL | GL Interface Run |
| 15 | CA_GL_INTFC_RUN | Character(1) | VARCHAR2(1) NOT NULL | CA GL Interface Run |
| 16 | PROC_DTTMSTAMP | DateTime(26) | TIMESTAMP | Process Date Timestamp |