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 | GPCH_PK_EIPIB | Character(10) | VARCHAR2(10) NOT NULL | Emplid |
2 | GPCH_PK_EILCD | 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 | GPCH_PK_EIBUA | 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 |