PAY_END_DTPAY_OL_DT_US_VW(SQL View) |
Index Back |
|---|---|
View Online Chq PayEndDate-USAThis view is used to provide a list box to select PayEndDates that can be used to access the Online Check data entry panel for USA. Those Pay Calendars that have a runid, are open to off-cycle processing and are for a USA 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.EFFDT <= A.PAY_END_DT and C.COMPANY=B.COMPANY and C.PAYGROUP=B.PAYGROUP) |
| # | 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 |