HR_SALCHG_DTLV2

(SQL View)
 Index Back

Adhoc Salary Change HTML Email

Adhoc Salary Change. Used to retrieve data for the detail section of HTML email

SELECT A.EMPLID , A.EMPL_RCD , A.ACTION_DT_SS , A.EFFSEQ , B.EFFDT , B.COMP_RATECD , B.COMP_RATE_POINTS , B.COMPRATE , B.COMP_FREQUENCY , B.CURRENCY_CD , B.CHANGE_PCT , B.CHANGE_AMT , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_HR_SALCHG_DAT A , PS_HR_SALCHG_COMP B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.ACTION_DT_SS = B.ACTION_DT_SS AND A.EFFSEQ = B.EFFSEQ

# 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 ACTION_DT_SS Date(10) DATE Termination Date
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
7 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
8 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
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
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
12 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
13 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
14 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
15 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
16 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
17 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
18 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
19 DESCR7 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.