UPG_COMP_TMP

(SQL Table)
 Index Back

EE Compensation Data

COMPENSATION is a subordinate record to JOB. Use this record to specify an employee's compensation components. This is a copy of the record used in the UPG RETIREES conversion.

  • Parent record: JOB

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: JOB.EMPLID

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Default Value: JOB.EMPL_RCD

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: JOB.EFFDT

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: JOB.EFFSEQ

    5 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
    6 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RATECD_TBL

    7 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    8 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    9 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    10 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
    A=Annual
    B=Biweekly
    C=Contract
    D=Daily
    H=Hourly
    M=Monthly
    S=Semimonthly
    W=Weekly

    Prompt Table: COMP_FREQ_VW

    11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    12 MANUAL_SW Character(1) VARCHAR2(1) NOT NULL Manual Switch

    Y/N Table Edit

    Default Value: N

    13 CONVERT_COMPRT Number(19,6) DECIMAL(18,6) NOT NULL Converted Comp Rate
    14 RATE_CODE_GROUP Character(6) VARCHAR2(6) NOT NULL Rate Code Group Name

    Prompt Table: COMPRT_GRP_TBL

    15 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    16 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    17 CHANGE_PTS Signed Number(6,0) DECIMAL(5) NOT NULL Change Points
    18 FTE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Apply FTE for Annualization

    Y/N Table Edit

    Default Value: N

    19 CMP_SRC_IND Character(1) VARCHAR2(1) NOT NULL Rate Code Source Indicator
    A=Absorbing Premium
    B=Non-Absorbing Premium
    C=Combination Rule
    E=Seniority Pay
    J=Job Code
    M=Manual
    N=None
    P=Payroll
    R=Employee Review
    S=Salary Step

    Default Value: N