PAY_END_DTPAY_OL_DT_CN_VW(SQL View) |
Index Back |
|---|---|
View Online Chq PayEndDate-CanThis view is used to provide a list box to select PayEndDates that can be used to access the Online Cheque data entry panel for Canada. Those Pay Calendars that have a runid, are open to off-cycle processing and are for a Canadian Paygroup are selected. |
| select A.PAY_END_DT ,A.COMPANY ,A.PAYGROUP from PS_PAY_CALENDAR A ,PS_PAYGROUP_TBL B where A.PAY_OFF_CYCLE_CLS = 'N' and A.RUN_ID <> ' ' and A.COMPANY=B.COMPANY and A.PAYGROUP=B.PAYGROUP and B.COUNTRY = 'CAN' and B.EFFDT= (select max(C.EFFDT) from PS_PAYGROUP_TBL C where C.COMPANY=B.COMPANY and C.PAYGROUP=B.PAYGROUP and C.EFFDT<=A.PAY_END_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 3 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |