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