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 |