GPCHPK023_TMP

(SQL Table)
Index Back

Pens. Interface Upload Table

Table 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