UNION_TBL

(SQL Table)
 Index Back

Unions

Use UNION_TBL to identify unions your company deals with. You can use a subordinate record named UNION_ERNCD_TBL to record the pay earnings codes (for payroll processing) that are valid for members of a particular union. You can create multiple UNION_TBL records for a union, each with a unique effective date.

  • Related Language Record: UNION_TBL_LANG

  • Parent Record Of GVT_UNION_CNTCT GVT_UNION_STWD UNION_ERNCD_TBL UNION_TBL_BRA UNION_TBL_IND

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code
    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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 UNION_LOCAL_FLG Character(1) VARCHAR2(1) NOT NULL Union Local Flag

    Y/N Table Edit

    Default Value: N

    7 BARG_UNIT Character(4) VARCHAR2(4) NOT NULL Bargaining Unit
    1=Bargaining Unit 1
    2=Bargaining Unit 2

    Prompt Table: HR_BARG_UNIT

    8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    9 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    10 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    11 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    12 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    13 CITY Character(30) VARCHAR2(30) NOT NULL City
    14 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    15 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    16 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    17 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    18 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    19 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    20 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    21 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    22 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    23 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    24 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    25 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
    26 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
    27 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    28 UNION_STEWARD_NAME Character(50) VARCHAR2(50) NOT NULL Union Steward
    29 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date
    30 CONTRACT_END_DT Date(10) DATE Contract End Date
    31 VACATION_PLAN Character(6) VARCHAR2(6) NOT NULL Vacation Plan
    32 SICK_PLAN Character(6) VARCHAR2(6) NOT NULL Sick Leave Plan
    33 SDI_ADMIN_PCT Number(3,2) DECIMAL(2,2) NOT NULL SDI Administration Percent
    34 DISABILITY_INS Character(1) VARCHAR2(1) NOT NULL Disability Insurance
    N=Not Applicable
    P=Covered (if hired < 1/1/80)
    Y=Covered

    Default Value: Y

    35 LIFE_INS Character(2) VARCHAR2(2) NOT NULL Life Insurance
    15=$15,000
    30=$30,000
    50=$50,000
    NA=Not Applicable

    Default Value: NA

    36 RETMT_PICKUP_PCT Number(4,2) DECIMAL(3,2) NOT NULL Retirement Pickup Percent
    37 FICA_PICKUP Character(1) VARCHAR2(1) NOT NULL FICA Pickup

    Y/N Table Edit

    Default Value: N

    38 CALLBACK_MIN_HOURS Number(3,1) DECIMAL(2,1) NOT NULL Callback Minimum Hours
    39 CALLBACK_RATE Number(3,1) DECIMAL(2,1) NOT NULL Callback Factor
    40 TUITION_LIMIT Character(1) VARCHAR2(1) NOT NULL Tuition Limit
    1=$100
    2=$125
    3=$373.33
    N=None

    Default Value: 2

    41 CERTIFIED Character(1) VARCHAR2(1) NOT NULL Certified

    Y/N Table Edit

    Default Value: Y

    42 CLOSED_SHOP Character(1) VARCHAR2(1) NOT NULL Closed Shop

    Y/N Table Edit

    Default Value: N

    43 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    44 WORK_DAY_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Number of Hours in a Work Day
    45 BAND_WIDTH_FROM Time(15) TIMESTAMP Band Width From Time
    46 BAND_WIDTH_THRU Time(15) TIMESTAMP Band Width Thru Time
    47 CORE_TM_FROM Time(15) TIMESTAMP Core time Thru
    48 CORE_TM_THRU Time(15) TIMESTAMP Core Time From