| # |
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 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: COMPANY_TBL.EFFDT
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
GPDE_AL_FIS_YY_END |
Character(2) |
VARCHAR2(2) NOT NULL |
Fiscal Year End
01=January
02=february
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
|
| 5 |
GPDE_TX_UNIT |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Unit
Prompt Table:
GPDE_TX_UNIT
|
| 6 |
GPDE_TX_CHRCHSTATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Church State
01=Schleswig-Holstein
02=Hamburg
03=Niedersachsen 9 %
04=Bremen
05=Nordrhein-Westfalen
06=Hessen
07=Rheinland-Pfalz
08=Baden-Wurtemberg
09=Bayern
10=Saarland
11=Berlin
12=Brandenburg
13=Mecklenburg-Vorpommern
14=Sachsen
15=Sachsen-Anhalt
16=Thuringen
17=Stadt Bremerhaven
18=Oberfinanzdirektion Kiel
93=Niedersachsen 8 %
|
| 7 |
GPDE_TX_CHAMBER_BR |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Chamber Bremen
Prompt Table:
GPDE_TX_UNIT
|
| 8 |
GPDE_TX_CHAMBER_SA |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Chamber Saarland
Prompt Table:
GPDE_TX_UNIT
|
| 9 |
GPDE_TX_LUMP_SM_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Lump Sum Church Tax
|
| 10 |
GPDE_TX_LUMP_SM_RT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Lump Sum Tax Rate
|