PIN_NUMPIN_TAKE_NUMPrompt Table: GP_PIN_ABSTK_VW
GPSC_ELM_TK_DAY(SQL View) |
Index Back |
|---|---|
Absence Take Entitlement DayAllows to combine multiple takes for one day. |
| SELECT PIN_NUM ,EFFDT ,PIN_TAKE_NUM FROM PS_GP_ABS_TAKE_DAY WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | EFFDT | Date(10) | DATE | Effective Date |
| 3 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL |
Absence Take
Prompt Table: GP_PIN_ABSTK_VW |