HR_SAL_CHG_C_VW

(SQL View)
 Index Back

Salary Change Components View

HR_SAL_CHG_C_VW is a view used in the Salary Change for Group without Allocated Budget - self service transaction. It is used to scroll in the Compensation Components of the Employees of a Group.

SELECT S.GB_GROUP_ID ,S.VERSIONGBQDM ,S.EMPLID ,S.EMPL_RCD ,S.JOB_EFFDT ,S.JOB_EFFSEQ ,C.COMP_EFFSEQ ,C.COMP_RATECD ,C.COMP_RATE_POINTS ,C.COMPRATE ,C.COMP_PCT ,C.COMP_FREQUENCY ,C.CURRENCY_CD ,C.MANUAL_SW ,C.CONVERT_COMPRT ,C.RATE_CODE_GROUP ,C.CHANGE_AMT ,C.CHANGE_PCT ,C.CHANGE_PTS ,C.FTE_INDICATOR ,C.CMP_SRC_IND FROM PS_SAL_PLN_GRP_RES S ,PS_COMPENSATION C WHERE S.EMPLID = C.EMPLID AND S.EMPL_RCD = C.EMPL_RCD AND S.JOB_EFFDT = C.EFFDT AND S.JOB_EFFSEQ = C.EFFSEQ

  • Parent record: HR_SAL_CHG_E_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    2 VERSIONGBQDM Number(10,0) DECIMAL(10) NOT NULL Version Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 EFFDT Date(10) DATE NOT NULL Effective Date
    6 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    7 COMP_EFFSEQ Number(3,0) SMALLINT NOT NULL Compensation Eff Sequence
    8 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

    Prompt Table: COMP_RATECD_TBL

    9 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
    10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    11 COMP_PCT Number(7,3) DECIMAL(6,3) NOT NULL Comp Percent
    12 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

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

    Prompt Table: CURRENCY_CD_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: COMPRT_GRP_TBL

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

    Y/N Table Edit

    Default Value: N

    21 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