GPCH_EO_RATE_TYPE01=Type 01
02=Type 02
03=Type 03
04=Type 04
EFFDTGPCH_EO_ANNUAL_AMDefault Value: CHF
Prompt Table: CURRENCY_CD_TBL
GPCH_EO_DATA(SQL Table) |
Index Back |
|---|---|
EO Data TableEO-Tabelle Soldmeldekarte |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPCH_EO_RATE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
DSG - EO-Tabelle - Soldmeldekarte
01=Type 01 02=Type 02 03=Type 03 04=Type 04 |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | GPCH_EO_ANNUAL_AM |
Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Annual Amount |
| 4 | GPCH_EO_AVERAGE_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | Average Earnings |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CHF Prompt Table: CURRENCY_CD_TBL |
| 6 | GPCH_EO_0_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | 0 Children |
| 7 | GPCH_EO_MAR1_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | Married, 1Child |
| 8 | GPCH_EO_MAR2_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | Married, 2 Children |
| 9 | GPCH_EO_MAR3_AM | Number(11,2) | DECIMAL(10,2) NOT NULL | Married, 3 Children |