HR_SS_SALCNG_VW

(SQL View)
 Index Back

Compensation History

Compensation History Self Service Transaction: This view returns "Hire" and "Pay Rate Change" rows from JOB.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ , A.ACTION , A.ACTION_REASON , A.ANNUAL_RT , A.CURRENCY_CD , A.COMP_FREQUENCY , A.COMPRATE , A.MONTHLY_RT , A.HOURLY_RT , A.EMPL_STATUS , A.CHANGE_AMT , A.CHANGE_PCT , A.SAL_ADMIN_PLAN , A.GRADE , A.STEP , A.SETID_SALARY , B.DESCR , B.SURVEY_SALARY , B.CURRENCY_CD FROM PS_JOB A , PS_JOBCODE_TBL B WHERE A.SETID_JOBCODE = B.SETID AND A.JOBCODE = B.JOBCODE AND %EffdtCheck(JOBCODE_TBL, B, A.EFFDT)

  • Related Language Record: HR_SSBASEVW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

    6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    7 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    9 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

    Default Value: INSTALLATION.COMP_FREQUENCY

    Prompt Table: COMP_FREQ_VW

    10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    11 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    12 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    13 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    14 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    15 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    16 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

    17 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

    Prompt Table: SAL_GRADE_TBL

    18 STEP Number(2,0) SMALLINT NOT NULL Step

    Prompt Table: SAL_STEP_TBL

    19 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID
    20 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    21 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary
    22 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code