GPDE_TX_RELIGIO

(SQL Table)
Index Back

Church Tax Table

Church Tax table/religion

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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 %
2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 GPDE_TX_RELIGION Character(3) VARCHAR2(3) NOT NULL Religion
00=No confession
01=Roman Catholic
02=Old Catholic
03=Evangical Lutheran
04=Evangical Ref.
05=French Reform i.0.
06=Free Religion Baden
07=Israelite
08=Religion Tax Rheinland Pfalz
09=Free Religion Offenbach
10=Free Religion Mainz
11=Israelite Religion Baden
12=Israelite Religion Wurttemberg
13=Israelite Religion Frankfurt/M
14=Israelite Religion Country
15=Free Religion Pfalz
16=Free Religion Comunity Alzey
17=Jewish Culture Tax HH
18=Jewish Culture Tax SH
4 GPDE_TX_RATE Signed Number(7,2) DECIMAL(5,2) NOT NULL Tax Rate
5 GPDE_TX_MIN_MONLY Number(11,2) DECIMAL(10,2) NOT NULL Monthly Minimum Tax
6 GPDE_TX_MON_CUR Character(3) VARCHAR2(3) NOT NULL Monthly Min Tax Currency

Default Value: DEM

Prompt Table: CURRENCY_CD_TBL

7 GPDE_TX_MIN_DAILY Number(7,2) DECIMAL(6,2) NOT NULL Daily Minimum Tax
8 GPDE_TX_DAY_CUR Character(3) VARCHAR2(3) NOT NULL Daily Min Tax Currency

Default Value: DEM

Prompt Table: CURRENCY_CD_TBL

9 GPDE_TX_MAX_PCT Number(6,2) DECIMAL(5,2) NOT NULL Maximum Percent