GVT_POI_TBL(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. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | GVT_POI | Character(4) | VARCHAR2(4) NOT NULL | Personnel Office ID |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
6 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL |
Sub-Agency
Prompt Table: GVT_SUBAGCY_TBL |
7 | GVT_AUTO_SUBM_PT | Character(5) | VARCHAR2(5) NOT NULL | Automated Submitting Point |
8 | GVT_OPM_REG_OFC | Character(1) | VARCHAR2(1) NOT NULL |
OPM Oversight Office
A=Atlanta Region C=Chicago Region D=Dallas Region P=Philadelphia S=San Francisco Region W=Washington Area Service Center |
9 | GVT_PO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Personnel Officer's Name |
10 | GVT_PO_ADDR1 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 1 |
11 | GVT_PO_ADDR2 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 2 |
12 | GVT_PO_ADDR3 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 3 |
13 | GVT_PO_ADDR4 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 4 |
14 | GVT_PO_ADDR5 | Character(35) | VARCHAR2(35) NOT NULL | Personnel Ofc Address Line 5 |
15 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
16 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
17 | GVT_ELEC_CMRCE_ID | Character(35) | VARCHAR2(35) NOT NULL | Electronic Commerce Address |
18 | ZIP | Character(10) | VARCHAR2(10) NOT NULL | Postal Code |
19 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |