HRS_JO_SALRNG

(SQL View)

SELECT A.HRS_JOB_OPENING_ID ,A.HRS_JO_MIN_RT ,A.HRS_JO_MAX_RT , A.PAY_FREQ_ABBRV , A.CURRENCY_CD , B.FREQ_ANNUAL_FACTOR FROM PS_HRS_JO_RQMT A , PS_HRS_FREQUENCY_I B ,PS_HRS_JOB_OPENING C WHERE A.HRS_JOB_OPENING_ID=C.HRS_JOB_OPENING_ID AND C.HRS_PRM_JOBCODE=A.JOBCODE AND B.FREQUENCY_ID=A.PAY_FREQ_ABBRV AND B.EFFDT=( SELECT MAX(B_ED.EFFDT) FROM PS_HRS_FREQUENCY_I B_ED WHERE B_ED.FREQUENCY_ID = B.FREQUENCY_ID AND B_ED.EFFDT <= %CurrentDateIn) AND B.FREQ_ANNUAL_FACTOR<>0 AND A.PAY_FREQ_ABBRV <>' '

# 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 HRS_JO_MIN_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening minimum rate

3 HRS_JO_MAX_RT Number(22,6) DECIMAL(21,6) NOT NULL Job opening maximum rate

4 PAY_FREQ_ABBRV Character(1) VARCHAR2(1) NOT NULL Pay Frequency
A=Annual
B=Bi-weeky
H=Hour
M=Month
Y=Year

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 FREQ_ANNUAL_FACTOR Number(12,7) DECIMAL(11,7) NOT NULL Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.

#	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	HRS_JO_MIN_RT	Number(22,6)	DECIMAL(21,6) NOT NULL	Job opening minimum rate
3	HRS_JO_MAX_RT	Number(22,6)	DECIMAL(21,6) NOT NULL	Job opening maximum rate
4	PAY_FREQ_ABBRV	Character(1)	VARCHAR2(1) NOT NULL	Pay Frequency A=Annual B=Bi-weeky H=Hour M=Month Y=Year
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	FREQ_ANNUAL_FACTOR	Number(12,7)	DECIMAL(11,7) NOT NULL	Specifies the factor used for annualization/deannualization in a frequency conversion. The Frequency Annualization Factor is expressed in times per year.