GP_PAYGROUPCAL_IDGPSG_FA_TMP2_VW(SQL View) |
Index Back |
|---|---|
Unfinalized Calendar Prompt VwThis view retreves CAL_ID for unfinalized off cycle calendars. |
| SELECT DISTINCT D.GP_PAYGROUP , D.CAL_ID FROM PS_GP_PYE_CAL D , PS_GP_OFFCYCLE B WHERE D.GP_PAYGROUP = B.GP_PAYGROUP AND D.OFF_CYCLE_ID = B.OFF_CYCLE_ID AND B.GP_RUN_STATUS <> 'F' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PAYGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 2 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL | calendar id |