UNION_ERNCD_TBL

(SQL Table)
 Index Back

Union Earnings Codes

Use UNION_ERNCD_TBL to identify the pay earnings codes (for payroll processing) that are valid for members of a particular union. If you're using this record, you must also create the parent record, UNION_TBL. You can create multiple UNION_ERNCD_TBL records for a union.

  • Parent record: UNION_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UNION_CD Character(3) VARCHAR2(3) NOT NULL Union Code

    Prompt Table: UNION_TBL

    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    4 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    5 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

    Prompt Table: ERN_PROG_DESCR2