GVT_POI_TBL

(SQL Table)
 Index Back

GVT: Personnel Office Table

GVT: 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_LANG

  • Parent Record Of GVT_POI_RT_VW GVT_POI_SIG_TBL

    • # 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