SALARY_PLAN

(SQL Table)
 Index Back

EE Proposed Salary Increase

SALARY_PLAN is the main record in the Salary Planning application. It contains the projected increases by employee. SALARY_PLAN has the same key structure as the Job record because approved increases are batch loaded to Job by an SQR once a plan is completed. This SQR sets the Loaded_To_Job flag to indicate that the data has been moved.

  • 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 JOB_EFFDT Date(10) DATE Job Effective Date
    6 JOB_EFFSEQ Number(3,0) SMALLINT NOT NULL Job Effective Sequence
    7 RANK Number(3,0) SMALLINT NOT NULL Rank
    8 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Prompt Table: ACTION_SP_VW

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

    Prompt Table: ACTN_REASON_TBL

    10 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
    11 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
    12 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
    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 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate
    15 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate
    16 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
    17 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period
    18 ANNUAL_INCREASE Signed Number(20,3) DECIMAL(18,3) NOT NULL Annual Increase
    19 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    20 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

    Default Value: P

    21 MONTHS_LAST_INCR Number(5,1) DECIMAL(4,1) NOT NULL Months Since Last Increase
    22 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    23 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

    Prompt Table: POSITION_DATA

    24 SAL_ADMIN_PLAN Character(4) VARCHAR2(4) NOT NULL Salary Administration Plan

    Prompt Table: SAL_PLAN_TBL

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

    Prompt Table: SAL_GRADE_TBL

    26 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    27 HIRE_DT Date(10) DATE First Start Date
    28 REHIRE_DT Date(10) DATE Rehire Date
    29 REFRESH_SW Character(1) VARCHAR2(1) NOT NULL Submit all Sessions

    Y/N Table Edit

    Default Value: N

    30 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_TBL_HR

    31 LOADED_TO_JOB Character(1) VARCHAR2(1) NOT NULL Loaded to Job

    Y/N Table Edit

    Default Value: N

    32 JOB_BASED Character(1) VARCHAR2(1) NOT NULL Based On Job Row

    Y/N Table Edit

    Default Value: Y

    33 AMOUNT_IND Character(1) VARCHAR2(1) NOT NULL Amount Indicator
    A=Amount
    P=Percent
    R=Compensation Rate
    34 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    35 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    36 BUDGET_START_DT Date(10) DATE Budget Start Date
    37 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
    38 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
    BW=Bi-weekly
    FB=Fee Basis
    PA=Per Annum
    PD=Per Diem
    PH=Per Hour
    PM=Per Month
    PW=Piece Work
    SM=Semi-monthly
    SY=School Year
    WC=Without Compensation