HRS_JO_SALRANGE

(SQL View)
 Index Back

Salary Range View

Salary Range View created for use in Job Posting Search Index Pre-Processing Library.

SELECT A.HRS_JOB_OPENING_ID , D.SETID , D.HRS_PRM_JOBCODE ,CASE WHEN A.PAY_FREQ_ABBRV = 'Y' THEN A.HRS_JO_MIN_RT WHEN (A.PAY_FREQ_ABBRV = 'H' AND B.FREQ_ANNUAL_FACTOR IS NULL) THEN %Truncate(%DecMult(A.HRS_JO_MIN_RT,D.NUM_PRD),6) ELSE %Truncate(%DecMult(A.HRS_JO_MIN_RT,B.FREQ_ANNUAL_FACTOR),6) END , CASE WHEN A.PAY_FREQ_ABBRV = 'Y' THEN A.HRS_JO_MAX_RT WHEN (A.PAY_FREQ_ABBRV = 'H' AND B.FREQ_ANNUAL_FACTOR IS NULL) THEN %Truncate(%DecMult(A.HRS_JO_MAX_RT,D.NUM_PRD),6)ELSE %Truncate(%DecMult(A.HRS_JO_MAX_RT,B.FREQ_ANNUAL_FACTOR),6) END ,A.PAY_FREQ_ABBRV ,A.CURRENCY_CD FROM PS_HRS_JO_RQMT A LEFT OUTER JOIN PS_HRS_FRQUENCY_I B ON A.PAY_FREQ_ABBRV = B.FREQUENCY_ID ,PS_HRS_JO_SALRN_I D WHERE A.JOBCODE = D.HRS_PRM_JOBCODE AND A.PAY_FREQ_ABBRV <>' ' AND A.HRS_JO_PRM_JCD_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 HRS_PRM_JOBCODE Character(6) VARCHAR2(6) NOT NULL Primary Job Code of Job Opening.
4 HRS_JO_MIN_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening minimum rate
5 HRS_JO_MAX_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening maximum rate
6 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year
7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code