HR_SALCHG_DTL_V

(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.TRANSACTION_NAME , A.SS_GRP_ID , A.SS_TRANS_ID , A.EMPLID , A.EMPL_RCD , 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_SS_KEYS A , PS_SS_DTL_SALCHANG B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.SS_GRP_ID = B.SS_GRP_ID AND A.SS_TRANS_ID = B.SS_TRANS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 SS_GRP_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
3 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 EFFDT Date(10) DATE Effective Date

Default Value: %date

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