| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TARIFF_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Tariff
01=Metal Processing
02=Banking
03=Building and Civil Engineering
04=Clothing Industry
05=Chemical Industry
06=Printing Industry
07=Retail Trade
08=Fossil Oil and Gas Extraction
09=Glass Industry
10=Wholesale and Foreign Trade
11=Wood Processing
12=Rubber Processing
13=Ceramics
14=Agriculture
15=Leather Processing
16=Public Sector
17=Paper Industry
18=Paper Processing
19=Sawing Industry
20=German Seaports
21=Hard-Coal Mining
22=Textile Industry
23=Insurance
24=Housing Industry
25=Periodical Publishers
26=Newspaper Publishers
27=Tobacco Industry
|
| 2 |
TARIFF_AREA_GER |
Character(3) |
VARCHAR2(3) NOT NULL |
Tariff Area
Prompt Table:
GPDE_ER_TRFAREA
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
GPDE_PS_EE_CATG |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Category
01=Wage Earner
02=Salaried Employee
03=Apprentice
04=Retiree
05=Retiree Over Tariff
06=Without Employee Status
07=Half Orphan
08=Company Pensioner
09=Widower/Orphan
11=Student Writing Thesis
12=Doctorant Writing dissertation
13=Award Holder
14=Industrial Trainee
15=Retrainee
16=Hired Help
|
| 5 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 6 |
GPDE_ER_CAPACC_AMT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Capital Accumulation Maximum
|
| 7 |
CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 8 |
GPDE_ER_CAPACCWAIT |
Number(2,0) |
SMALLINT NOT NULL |
Waiting Period in Months
|
| 9 |
GPDE_ER_VACNBONPCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Vacation Bonus
|
| 10 |
GPDE_ER_ACCT_FEE |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Bank Account Fee
|
| 11 |
CURRENCY_CD2 |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 12 |
GPDE_TXG_PROC_PRD |
Character(4) |
VARCHAR2(4) NOT NULL |
Processing Period
M=Monthly
N=None
Y=Yearly
Default Value: N
|
| 13 |
GPDE_ER_PY_MM_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Pay Month Only
|
| 14 |
GPDE_DE_PE_SCHED |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Schedule
|
| 15 |
GPDE_ER_BASE_MMSTD |
Number(2,0) |
SMALLINT NOT NULL |
Regular Monthly Pay
|
| 16 |
GPDE_ER_BASE_MMVAR |
Number(2,0) |
SMALLINT NOT NULL |
Variable Monthly Pay
|
| 17 |
GPDE_ER_MID_YY_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Prorate Midyear Percent
|
| 18 |
GPDE_KUG_TERMPRIOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminated Prior to KUG Begin
Y/N Table Edit
Default Value: N
|
| 19 |
GPDE_KUG_TERM_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Terminated During KUG Period
Y/N Table Edit
Default Value: N
|
| 20 |
GPDE_KUG_ER_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
KUG Employer Subsidy %
|
| 21 |
GPDE_ER_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer Contribution Basis
G=Gross
N=Not Applicable
T=Net
Default Value: N
|
| 22 |
GPDE_ER_SICK_PCNT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Additional Sick
|
| 23 |
GPDE_AB_ENTITLEMNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entitlement Plan
Prompt Table:
GPDE_AB_ENTITLE
|