SAL_PLAN_INC_VW

(SQL View)
Index Back

EE Last Incr Data - Sal Plan

SAL_PLAN_INC_VW is a view which retrieves the last increase for employees as of the salary plan start date. It is used in the Salary Planning application.

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.ACTION , A.ACTION_REASON , A.COMP_FREQUENCY , A.COMPRATE , A.CHANGE_AMT , A.CHANGE_PCT , A.EFFDT , A.CURRENCY_CD FROM PS_JOB A WHERE A.CHANGE_AMT > 0 OR A.ACTION IN('HIR','REH','ASG','ADL')

# 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 NOT NULL Effective Date
4 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

5 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
6 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
7 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
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 LAST_INCREASE_DT Date(10) DATE Date Last Increase
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code