COMP_SUMM_VW (SQL View)	Index Back
Compensation Summary View COMP_SUMM_VW is a view of an employee's salary history, based on their Job records. Only their hire record and any record with a change in salary are retrieved by this view. It is used to display compensation history in several Salary Administration panels.

COMP_SUMM_VW

(SQL View)

Compensation Summary View

COMP_SUMM_VW is a view of an employee's salary history, based on their Job records. Only their hire record and any record with a change in salary are retrieved by this view. It is used to display compensation history in several Salary Administration panels.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.ACTION ,A.ACTION_REASON ,A.BUSINESS_UNIT ,A.JOBCODE ,A.COMP_FREQUENCY ,A.COMPRATE ,A.CHANGE_AMT ,A.CHANGE_PCT ,A.ANNUAL_RT ,A.HOURLY_RT ,A.CURRENCY_CD ,B.SETID ,A.SAL_ADMIN_PLAN ,A.GRADE ,A.STEP ,A.GRADE_ENTRY_DT FROM PS_JOB A , PS_SET_CNTRL_REC B WHERE (A.CHANGE_AMT <> 0 OR A.ACTION IN('HIR','REH','ASG')) AND A.HR_STATUS = 'A' AND B.SETCNTRLVALUE=A.BUSINESS_UNIT AND B.RECNAME='SAL_PLAN_TBL'

# 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 NOT NULL Effective 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

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

8 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

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
Prompt Table: COMP_FREQ_VW

10 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate

11 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount

12 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent

13 ANNUAL_RT Number(19,3) DECIMAL(18,3) NOT NULL Annual Rate

14 HOURLY_RT Number(19,6) DECIMAL(18,6) NOT NULL Hourly Rate

15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

16 SETID_SALARY Character(5) VARCHAR2(5) NOT NULL Salary Set ID

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

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

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

20 GRADE_ENTRY_DT Date(10) DATE Grade Entry Date

#	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 NOT NULL	Effective 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
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
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 Prompt Table: COMP_FREQ_VW
10	COMPRATE	Number(19,6)	DECIMAL(18,6) NOT NULL	Compensation Rate
11	CHANGE_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Change Amount
12	CHANGE_PCT	Signed Number(8,3)	DECIMAL(6,3) NOT NULL	Change Percent
13	ANNUAL_RT	Number(19,3)	DECIMAL(18,3) NOT NULL	Annual Rate
14	HOURLY_RT	Number(19,6)	DECIMAL(18,6) NOT NULL	Hourly Rate
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
16	SETID_SALARY	Character(5)	VARCHAR2(5) NOT NULL	Salary Set ID
17	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
18	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
19	STEP	Number(2,0)	SMALLINT NOT NULL	Step
20	GRADE_ENTRY_DT	Date(10)	DATE	Grade Entry Date