GPDE_TX_AGS_TBL(SQL Table) |
Index Back |
|---|---|
German Global Payroll AGSThis table stores all of the valid Community Codes for German Global Payroll. Community Codes are 8-digit numbers. The first 2 digits represent the State. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  GPDE_ZIP_CODE |
Character(5) | VARCHAR2(5) NOT NULL | 5-character zip code for Global Payroll Germany |
| 2 | GPDE_POSTAL_CITY |
Character(30) | VARCHAR2(30) NOT NULL | 24-character city field for Global Payroll Germany |
| 3 | GPDE_TX_AGS_ID |
Character(8) | VARCHAR2(8) NOT NULL | Municipality Code for GP Germany. |
| 4 | GPDE_AGS_STATE | Character(2) | VARCHAR2(2) NOT NULL |
German States as defined by the first two digits of the AGS (Community Code). These first two digits represent a State withint Germany.
00=Bayern 01=Schleswig-Holstein 02=Hamburg 03=Niedersachsen 04=Bremen 05=Nordrhein-Westfalen 06=Hessen 07=Rheinland-Pfalz 08=Baden-Wuerttemberg 09=Bayern 10=Saarland 11=Berlin 12=Brandenburg 13=Mecklenburg-Vorpommern 14=Sachsen 15=Sachsen-Anhalt 16=Thueringen |