GVT_GEOLOC_CDLANGUAGE_CDEFFDTGVT_GEOLOC_LANG(SQL Table) |
Index Back |
|---|---|
Gvt Geographic LocationLOCATION_TBL is an edit table. Use it to record information about your company's work sites. Related Language record for GVT_GEOLOC_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_GEOLOC_CD |
Character(9) | VARCHAR2(9) NOT NULL | Geog Location Code |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | GVT_ST_CNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State/Country Description |
| 5 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 6 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 7 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 8 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |