GVT_BU_UNION

(SQL Table)
 Index Back

Federal Barganing Unit/Unions

This table allows the combination of Barganing Unit and Union with Federal specific fields You can create multiple records for a barganing unit/union combination, each with a unique effective date.

  • Related Language Record: GVT_BU_UN_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: GVT_BARG_UNIT

    2 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 GVT_DT_UNION_RCGNZ Date(10) DATE Date Union Recognized
    6 GVT_UNION_TYPE Character(1) VARCHAR2(1) NOT NULL Union Type
    G=US Federal Government Union
    O=Other
    P=Private Sector Union
    U=Public Union
    7 GVT_AFFILIATED_ORG Character(1) VARCHAR2(1) NOT NULL Union Affiliate
    1=AFGE
    A=AFL-CIO
    B=AFSME
    C=NAGE
    D=NFFE
    E=NTEU
    I=Independent
    O=Other
    8 GVT_UNION_FAX_NBR Character(12) VARCHAR2(12) NOT NULL Fax Number
    9 GVT_UNION_SCOPE Character(1) VARCHAR2(1) NOT NULL Union Scope
    I=International Union
    L=Local Union
    N=National Union
    R=Regional
    10 GVT_PRTNRSHP_AGRMT Character(1) VARCHAR2(1) NOT NULL Partnership Agreement
    11 GVT_PRTNRSHIP_DATE Date(10) DATE Partnership Agreement Date
    12 GVT_PRTNR_COUNCIL Character(1) VARCHAR2(1) NOT NULL Partnership Council
    13 GVT_PRT_COUNCIL_DT Date(10) DATE Partnership Council Date
    14 GVT_LMR_TNG_HRS Number(3,0) SMALLINT NOT NULL LMR Training Hours Required
    15 COMMENTS Long Character CLOB Comment