GVT_UNION_NEGBL

(SQL Table)
 Index Back

Union Negotiability Appeals

Use GVT_UNION_NEGBL to identify the items from a Union Agreement that are NOT Negotiable. You can create multiple non-negotiable items per union agreement - each with a unique identifier and effective date.

  • Parent Record Of GVT_NGBLTY_STEP

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

    Prompt Table: UNION_TBL

    3 GVT_NEGBLTY_ITEM Character(7) VARCHAR2(7) NOT NULL Non-Negotiable Item
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 GVT_ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item's Status
    F=Pending - FLRA
    K=Unknown
    N=Non-Negotiable
    P=Pending - Agency
    U=Pending - Union
    W=Withdrawn
    Y=Negotiable

    Default Value: P