GPDE_TX_CHURCH(SQL Table) |
Index Back |
|---|---|
Church Tax tableChurch Tax table |
| # | 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_SPOUSE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Spouse Distribution Percent |
| 4 | GPDE_TX_DIST_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Catholic Distribution Percent |
| 5 | GPDE_TX_LUMP_SM_RT | Number(6,2) | DECIMAL(5,2) NOT NULL | Lump Sum Tax Rate |
| 6 | GPDE_TX_MIN_CLS_56 | Character(1) | VARCHAR2(1) NOT NULL |
Minimum for Tax Class V/VI
Y/N Table Edit Default Value: Y |
| 7 | GPDE_TX_MIN_NO_INC | Character(1) | VARCHAR2(1) NOT NULL |
Minimum if No Income Tax
Y/N Table Edit Default Value: N |