HR_SS_BASE_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.EFFDT , A.ACTION , A.ACTION_REASON , A.ANNUAL_RT , A.CURRENCY_CD , A.COMP_FREQUENCY , A.COMPRATE , A.MONTHLY_RT , A.HOURLY_RT , A.HR_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 , A.REG_REGION , A.PAID_HOURS , A.PAID_HRS_FREQUENCY , A.STD_HOURS , A.STD_HRS_FREQUENCY , A.SUPERVISOR_ID , A.REPORTS_TO FROM PS_JOB A , PS_JOBCODE_TBL B WHERE (A.ACTION IN ('PAY','HIR', 'REH') OR A.CHANGE_PCT <> 0) AND A.HR_STATUS = 'A' AND 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 Rcd Nbr
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 SS_CHANGE_DATE Date(10) DATE Click to see more details
    6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_TBL

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

    Prompt Table: ACTN_REASON_TBL

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

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    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

    Default Value: INSTALLATION.COMP_FREQUENCY

    Prompt Table: COMP_FREQ_VW

    11 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    12 MONTHLY_RT Number(19,3) DECIMAL(18,3) NOT NULL Monthly Rate
    13 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    14 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
    A=Active
    I=Inactive
    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 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

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

    Prompt Table: SAL_GRADE_TBL

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

    Prompt Table: SAL_STEP_TBL

    20 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary SetID
    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 SURVEY_SALARY Number(8,0) INTEGER NOT NULL Survey Salary
    23 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
    24 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    25 PAID_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Paid Hours
    26 PAID_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Paid Work Period
    27 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    28 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    29 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    30 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number