GPCHPK023_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 | Character(10) | VARCHAR2(10) NOT NULL | Emplid | |
| 2 | Character(6) | VARCHAR2(6) NOT NULL | Pay element | |
| 3 | GPCH_PK_EIFJH_W | Date(10) | DATE | Billing date | 
| 4 | GPCH_PK_UPL_TYPE | Character(1) | VARCHAR2(1) NOT NULL | 
Upload Type
 S=Standard U=Update  | 
| 5 | Character(2) | VARCHAR2(2) NOT NULL | Booking class | |
| 6 | TYPE_OF_GROUP | Character(1) | VARCHAR2(1) NOT NULL | 
Type of Group
 E=Student Group X=External Org Group  | 
| 7 | SEQ_NBR_TEXT | Character(1) | VARCHAR2(1) NOT NULL | Rec Seq | 
| 8 | GPCH_PK_EIVD1_W | Date(10) | DATE | Book entry date | 
| 9 | GPCH_PK_EIGVF_0 | Number(12,2) | DECIMAL(11,2) NOT NULL | Calculation base for Pension Fund | 
| 10 | GPCH_PK_EIGGF_0 | Number(8,4) | DECIMAL(7,4) NOT NULL | Calculation base | 
| 11 | GPCH_PK_EIBET_0 | Number(12,2) | DECIMAL(11,2) NOT NULL | Payout | 
| 12 | GPCH_PK_EIPZ1_0 | Number(10,4) | DECIMAL(9,4) NOT NULL | Valid factor or percent of calculation | 
| 13 | GPCH_PK_EIFJH | Character(4) | VARCHAR2(4) NOT NULL | Billing date year | 
| 14 | GPCH_PK_EIFMO | Character(2) | VARCHAR2(2) NOT NULL | Billing date month | 
| 15 | GPCH_PK_EIFTG | Character(2) | VARCHAR2(2) NOT NULL | Billing date day | 
| 16 | GPCH_PK_EIVD1 | Character(2) | VARCHAR2(2) NOT NULL | Book entry century | 
| 17 | GPCH_PK_EIVD2 | Character(2) | VARCHAR2(2) NOT NULL | Book entry year | 
| 18 | GPCH_PK_EIVDM | Character(2) | VARCHAR2(2) NOT NULL | Book entry month | 
| 19 | GPCH_PK_EIVDT | Character(2) | VARCHAR2(2) NOT NULL | Book entry day | 
| 20 | GPCH_PK_EIGVF | Character(11) | VARCHAR2(11) NOT NULL | Calculation base | 
| 21 | GPCH_PK_EIGGF | Character(7) | VARCHAR2(7) NOT NULL | Calculation base | 
| 22 | GPCH_PK_EIBET | Character(11) | VARCHAR2(11) NOT NULL | Payout | 
| 23 | GPCH_PK_EIPZ1 | Character(9) | VARCHAR2(9) NOT NULL | Valid factor or percent of calculation |