GP_PAYGROUPEFFDTDefault Value: %date
PAY_BEGIN_DTPAY_END_DTCAL_RUN_IDGPBR_VAC_CAL_VW(SQL View) |
Index Back |
|---|---|
Check Vacation CalendarCheck if it is a Vacation Calendar. |
| SELECT A.GP_PAYGROUP , A.EFFDT , A.PAY_BEGIN_DT , A.PAY_END_DT , A.CAL_RUN_ID , A.OFF_CYCLE_ID , A.CAL_PRD_ID , A.SRC_CAL_RUN_ID FROM PS_GPBR_VAC_CAL A WHERE A.EFFDT = (SELECT MAX(B.EFFDT) FROM PS_GPBR_VAC_CAL B WHERE A.GP_PAYGROUP = B.GP_PAYGROUP AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | PAY_BEGIN_DT |
Date(10) | DATE | Pay Period Begin Date |
| 4 | PAY_END_DT |
Date(10) | DATE | Pay Period End Date |
| 5 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 6 | OFF_CYCLE_ID | Character(18) | VARCHAR2(18) NOT NULL | Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments |
| 7 | CAL_PRD_ID | Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 8 | SRC_CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Source Calendar Run ID |