PIN_NUMPIN_TAKE_NUMGP_AUD_TK5_DAY(SQL Table) |
Index Back |
|---|---|
Absence Take Entitlement DayAllows to combine multiple takes for one day. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 2 | PIN_TAKE_NUM |
Number(8,0) | INTEGER NOT NULL | Absence Take |
| 3 | EFFDT | Date(10) | DATE | Effective Date |
| 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 |