EMPL_CTG_L2

(SQL Table)
 Index Back

Employee Subcategory Level 2

Employee Subcategory Level 2

  • Related Language Record: EMPL_CTG_L2_LNG

  • Parent record: EMPL_CTG_L1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_LAB_VLD_VW

    2 LABOR_AGREEMENT Character(6) VARCHAR2(6) NOT NULL Labor Agreement

    Prompt Table: EMPL_CTG

    3 EMPL_CTG Character(6) VARCHAR2(6) NOT NULL Employee Category

    Prompt Table: EMPL_CTG_L1

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EMPL_CTG_L1 Character(6) VARCHAR2(6) NOT NULL Employee Subcategory
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    8 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
    9 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CLASS_TBL
    Set Control Field: REG_REGION

    10 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Prompt Table: REG_STANDARD_VW