HR_SAL_CHG_COMP

(SQL Table)
 Index Back

Sal Chg for Grp Pay Components

contains the Pay Components of the Employees in HR_SAL_CHG_EE for the self service transaction 'Salary Change for Group without Allocated Budget'.

  • Parent record: HR_SAL_CHG_EE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.

    Prompt Table: GB_GROUP_TBL

    2 ACTION_DT_SS Date(10) DATE NOT NULL Termination Date
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    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 NEW_COMP_RATE_PTS Number(5,0) INTEGER NOT NULL New Comp Rate Points
    9 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    10 NEW_COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL New Compensation Rate
    11 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    12 NEW_COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL New Comp Percent
    13 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

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

    Prompt Table: CURRENCY_CD_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: COMPRT_GRP_TBL

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

    Y/N Table Edit

    Default Value: N

    22 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