HRS_OFF_DTL_VW2

(SQL View)
 Index Back

Offer Detail View

Offer Detail View

SELECT A.HRS_PERSON_ID , A.HRS_RCMNT_ID , A.HRS_OFF_ID , A.OFFER_COMPONENT , B.DESCR , A.OFFER_AMT , ' ' , A.CURRENCY_CD , A.OFFER_FREQUENCY , X1.XLATLONGNAME , PYM.HRS_DESCR FROM PS_HRS_OFF_DTL A LEFT OUTER JOIN PS_HRS_XLAT_EFF_VW X1 ON X1.FIELDNAME = 'OFFER_FREQUENCY' AND X1.FIELDVALUE = A.OFFER_FREQUENCY AND X1.EFF_STATUS = 'A' , PS_HRS_OFF_CMPNT B , PS_HRS_PAYMODE_VW PYM WHERE A.OFFER_COMPONENT = B.OFFER_COMPONENT AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HRS_OFF_CMPNT C WHERE C.OFFER_COMPONENT = B.OFFER_COMPONENT AND C.EFFDT <= %CurrentDateIn) AND PYM.OFFER_COMPONENT = A.OFFER_COMPONENT AND B.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
2 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
3 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
4 OFFER_COMPONENT Character(7) VARCHAR2(7) NOT NULL Offer Component

Prompt Table: HRS_OFF_CMPNT_I

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 OFFER_AMT Number(19,6) DECIMAL(18,6) NOT NULL Offer Amount
7 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

9 OFFER_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Indicates the offer amount frequency.
A=Annual
B=Biweekly
C=Contract
D=Daily
F=Every Four Weeks
H=Hourly
M=Monthly
O=One-Time
Q=Quarterly
S=Semimonthly
W=Weekly
10 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
11 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description