CAL_IDPrompt Table: GP_CALENDAR
GPMX_CAL_VW(SQL View) |
Index Back |
|---|---|
PTU Calendar Prompt ViewCalendar Prompt View -- Used by PTU Process |
| SELECT DISTINCT C.CAL_ID FROM PS_GP_CALENDAR C WHERE EXISTS ( SELECT 'X' FROM PS_GP_CAL_RUN_DTL D , PS_GP_CAL_RUN A WHERE D.GP_PAYGROUP = C.GP_PAYGROUP AND D.CAL_ID = C.CAL_ID AND D.CAL_RUN_ID = A.CAL_RUN_ID AND A.RUN_FINALIZED_IND = 'N' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CAL_ID |
Character(18) | VARCHAR2(18) NOT NULL |
calendar id
Prompt Table: GP_CALENDAR |