COMPANYPAYGROUPPAY_END_DTPAY_OL_DT_VW(SQL View) |
Index Back |
|---|---|
View Online PayEndDate for RevThis view is used to provide a list box to select PayEndDates that can be used for posting a reversal in online check processing. Those Paycalendars that have a runid and are still open to off-cycle processing are provided for the selected company and paygroup. |
| select A.COMPANY ,A.PAYGROUP ,A.PAY_END_DT from PS_PAY_CALENDAR A where A.PAY_OFF_CYCLE_CLS = 'N' and A.RUN_ID <> ' ' |
| # | 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 |