GPDE_AGS_ST_VW(SQL View) |
Index Back |
---|---|
German States for AGSList of German States according to the German Community Codes (AGS) |
SELECT XLATLONGNAME , XLATSHORTNAME , %Substring(FIELDVALUE, 1, 2) FROM PSXLATITEM WHERE FIELDNAME = 'GPDE_AGS_STATE' AND FIELDVALUE <> '00' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
2 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
3 | 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 |