HR_SALCHG_DTLVW

(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 , B.COMP_RATECD , C.DESCR , A.SS_TRANS_ID , A.EMPLID ,D.NAME , A.EMPL_RCD , B.EFFDT , 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 , PS_COMP_RATECD_TBL C , PS_NAMES D 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 AND C.COMP_RATECD=B.COMP_RATECD AND A.EMPLID =D.EMPLID

# 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 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SS_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Key Used in SS Framework
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
9 EFFDT Date(10) DATE Effective Date

Default Value: %date

10 COMP_RATE_POINTS Number(5,0) INTEGER NOT NULL Comp Rate Points
11 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
12 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
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 CHANGE_PCT Signed Number(8,3) DECIMAL(6,3) NOT NULL Change Percent
15 CHANGE_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Change Amount
16 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
17 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
18 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
19 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
20 DESCR5 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
21 DESCR6 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
22 DESCR7 Character(30) VARCHAR2(30) NOT NULL This field is used in a complex query that shows many descr fields.
23 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
24 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
25 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
26 DESCR40_1 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
27 DESCR40_2 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
28 DESCR40_3 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40