PIN_NUMPIN_TAKE_NUMPrompt Table: GP_PIN_ABSTK_VW
GP_AUD_TK5_D_VW(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 |
| # | 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 |
| 4 | GP_AUD_CHAR_NM14 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 5 | GP_AUD_LINK14 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 6 | GP_AUD_CHAR_VAL14 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |