GPCH_PK_EIPIBGPCH_PK_ID_ALTGPCHPK022_TMP(SQL Table) |
Index Back |
|---|---|
Pens. Interface Upload TableTable for the Application Engine Pension Interface Upload Process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_PK_EIPIB |
Character(10) | VARCHAR2(10) NOT NULL | Emplid |
| 2 | GPCH_PK_ID_ALT |
Number(9,0) | DECIMAL(9) NOT NULL | PK Alternate ID |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | HIRE_DT | Date(10) | DATE | First Start Date |
| 5 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 6 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 7 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |