SAL_PLAN_APP_VW

(SQL View)
 Index Back

EE Proposed Salary Increase VW

This view displays the proposed salary changes on the salary plan approval panel. Only the fields rank and status are enterable.

SELECT SP.EMPLID ,SP.EMPL_RCD ,SP.EFFDT ,SP.EFFSEQ ,SP.RANK ,SP.ACTION ,SP.ACTION_REASON ,SP.CHANGE_AMT ,SP.CHANGE_PCT ,SP.COMPRATE ,SP.COMP_FREQUENCY ,SP.ANNUAL_RT ,SP.ANNUAL_INCREASE ,SP.CURRENCY_CD ,SP.DEPTID ,SP.SALARY_PLAN_STATUS FROM PS_SALARY_PLAN SP

  • Parent record: PER_ORG_ASGN_VW

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

    Prompt Table: PERSON

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

    Prompt Table: PER_ORG_ASGN_VW

    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 RANK Number(3,0) SMALLINT NOT NULL Rank
    6 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_SP_VW

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

    Prompt Table: ACTN_REASON_TBL

    8 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    9 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    11 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
    12 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    13 ANNUAL_INCREASE Signed Number(20,3) DECIMAL(18,3) NOT NULL Annual Increase
    14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    16 SALARY_PLAN_STATUS Character(1) VARCHAR2(1) NOT NULL Salary Plan Status
    A=Approved
    I=Ineligible for Increase
    N=No Increase Given
    P=Proposed
    R=Processed