GPCH_PK_EIBUAGPCH_PK_EIPIBGPCH_PK_EILCDGPCHPK021_TMP(SQL Table) |
Index Back |
|---|---|
Upload Table for File LayoutPension Interface Upload Table where are stored the data of the File to be read, while the Application Engine Runs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_PK_EISAZ | Character(2) | VARCHAR2(2) NOT NULL | Record Type |
| 2 | GPCH_PK_EISTS | Character(1) | VARCHAR2(1) NOT NULL | Status key |
| 3 | GPCH_PK_EIKAS | Character(3) | VARCHAR2(3) NOT NULL | Pension Fund No. |
| 4 | GPCH_PK_EIVD1 | Character(2) | VARCHAR2(2) NOT NULL | Book entry century |
| 5 | GPCH_PK_EIVD2 | Character(2) | VARCHAR2(2) NOT NULL | Book entry year |
| 6 | GPCH_PK_EIVDM | Character(2) | VARCHAR2(2) NOT NULL | Book entry month |
| 7 | GPCH_PK_EIVDT | Character(2) | VARCHAR2(2) NOT NULL | Book entry day |
| 8 | GPCH_PK_EIVER | Character(9) | VARCHAR2(9) NOT NULL | Insurant ID |
| 9 | GPCH_PK_EIBEG | Character(9) | VARCHAR2(9) NOT NULL | Beneficiary ID |
| 10 | GPCH_PK_EIPKA | Character(3) | VARCHAR2(3) NOT NULL | Pension Fund Type |
| 11 | GPCH_PK_EIBUA |
Character(2) | VARCHAR2(2) NOT NULL | Booking class |
| 12 | GPCH_PK_EIJNR | Character(3) | VARCHAR2(3) NOT NULL | Journal ID |
| 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_EIPIB |
Character(10) | VARCHAR2(10) NOT NULL | Emplid |
| 17 | GPCH_PK_EILNR | Character(9) | VARCHAR2(9) NOT NULL | Pay company |
| 18 | GPCH_PK_EILCD |
Character(6) | VARCHAR2(6) NOT NULL | Pay element |
| 19 | GPCH_PK_EIGVF | Character(11) | VARCHAR2(11) NOT NULL | Calculation base |
| 20 | GPCH_PK_EIGGF | Character(7) | VARCHAR2(7) NOT NULL | Calculation base |
| 21 | GPCH_PK_EIBET | Character(11) | VARCHAR2(11) NOT NULL | Payout |
| 22 | GPCH_PK_EIPZ1 | Character(9) | VARCHAR2(9) NOT NULL | Valid factor or percent of calculation |
| 23 | GPCH_PK_EINAM | Character(30) | VARCHAR2(30) NOT NULL | Name of the beneficiary |
| 24 | GPCH_PK_EIAHV | Character(11) | VARCHAR2(11) NOT NULL | National ID |
| 25 | GPCH_PK_EITXT | Character(30) | VARCHAR2(30) NOT NULL | Cancellation for correction booking |
| 26 | GPCH_PK_EIBEZ | Character(30) | VARCHAR2(30) NOT NULL | Description of pension type |
| 27 | GPCH_PK_EIEND | Character(1) | VARCHAR2(1) NOT NULL | End code |