GPCH_RP_PK021(SQL Table) |
Index Back |
|---|---|
Upload Staging TablePension Interface Upload Staging Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 2 | GPCH_AL_CPAY_ENDDT |
Date(10) | DATE NOT NULL |
Current Pay End Date
Prompt Table: GPCH_RP_DATE_VW |
| 3 | GPCH_SI_PROV_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Provider Type
0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File C=Base AL08 D=GRFI-FRFI E=EO-APG I=BNK_BNQ Default Value: 6 |
| 4 | GPCH_SI_PROV_CD |
Character(6) | VARCHAR2(6) NOT NULL |
Provider Code
Prompt Table: GPCH_PK_PROV2VW |
| 5 | GPCH_PK_EIFJH_W |
Date(10) | DATE NOT NULL | Billing date |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 7 | GPCH_PK_EIPIB |
Character(10) | VARCHAR2(10) NOT NULL | Emplid |
| 8 | GPCH_PK_EILCD |
Character(6) | VARCHAR2(6) NOT NULL | Pay element |
| 9 | STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 10 | GPCH_PK_EISAZ | Character(2) | VARCHAR2(2) NOT NULL | Record Type |
| 11 | GPCH_PK_EISTS | Character(1) | VARCHAR2(1) NOT NULL | Status key |
| 12 | GPCH_PK_EIKAS | Character(3) | VARCHAR2(3) NOT NULL | Pension Fund No. |
| 13 | GPCH_PK_EIVD1_W | Date(10) | DATE | Book entry date |
| 14 | GPCH_PK_EIVER | Character(9) | VARCHAR2(9) NOT NULL | Insurant ID |
| 15 | GPCH_PK_EIBEG | Character(9) | VARCHAR2(9) NOT NULL | Beneficiary ID |
| 16 | GPCH_PK_EIPKA | Character(3) | VARCHAR2(3) NOT NULL | Pension Fund Type |
| 17 | GPCH_PK_EIBUA |
Character(2) | VARCHAR2(2) NOT NULL | Booking class |
| 18 | GPCH_PK_EIJNR | Character(3) | VARCHAR2(3) NOT NULL | Journal ID |
| 19 | GPCH_PK_EILNR | Character(9) | VARCHAR2(9) NOT NULL | Pay company |
| 20 | GPCH_PK_EIGVF_0 | Number(12,2) | DECIMAL(11,2) NOT NULL | Calculation base for Pension Fund |
| 21 | GPCH_PK_EIGGF_0 | Number(8,4) | DECIMAL(7,4) NOT NULL | Calculation base |
| 22 | GPCH_PK_EIBET_0 | Number(12,2) | DECIMAL(11,2) NOT NULL | Payout |
| 23 | GPCH_PK_EIPZ1_0 | Number(10,4) | DECIMAL(9,4) NOT NULL | Valid factor or percent of calculation |
| 24 | GPCH_PK_EINAM | Character(30) | VARCHAR2(30) NOT NULL | Name of the beneficiary |
| 25 | GPCH_PK_EIAHV | Character(11) | VARCHAR2(11) NOT NULL | National ID |
| 26 | GPCH_PK_EITXT | Character(30) | VARCHAR2(30) NOT NULL | Cancellation for correction booking |
| 27 | GPCH_PK_EIBEZ | Character(30) | VARCHAR2(30) NOT NULL | Description of pension type |
| 28 | GPCH_PK_EIEND | Character(1) | VARCHAR2(1) NOT NULL | End code |