HP_FRGE_MTRX_DL

(SQL Table)
 Index Back

Fringe Matrix Detail

This record stores fringe matrix detail and corresponding salary code.

  • Parent record: HP_FRGE_MATRIX

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HP_FRGE_MATRIX_CD Character(5) VARCHAR2(5) NOT NULL Fringe Matrix Code
    2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

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

    Prompt Table: PAYGROUP_TBL

    4 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

    Prompt Table: EMPL_CL_STD_VW

    5 EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    6 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
    D=On Demand
    F=Full-Time
    P=Part-Time
    7 HP_SAL_RANGE_CD Character(5) VARCHAR2(5) NOT NULL Salary Range Code

    Prompt Table: HP_SAL_RANGE

    8 HP_CO_DEF_SAL_RNGE Character(1) VARCHAR2(1) NOT NULL Default Salary Range code for Company

    Y/N Table Edit

    Default Value: N