GVT_POILANGUAGE_CDEFFDTGVT_POI_LANG(SQL Table) |
Index Back |
|---|---|
GVT: Personnel Office TableGVT: This table is used to identify US Federal Government Personnel Offices, the Agency/Sub-Agency they belong to, their addresses, telephone numbers, and contact names. It may be used in the future as the basis for addressing internal/external communications including Electronic Commerce transmittal and routing. Related Language record GVT_POI_TBL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_POI |
Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | GVT_PO_ADDR1 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 1 |
| 6 | GVT_PO_ADDR2 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 2 |
| 7 | GVT_PO_ADDR3 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 3 |
| 8 | GVT_PO_ADDR4 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 4 |
| 9 | GVT_PO_ADDR5 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 5 |
| 10 | GVT_ELEC_CMRCE_ID | Character(35) | VARCHAR2(35) NOT NULL | Electronic Commerce Address |