HRS_OFF_DTL_VW

(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 FROM PS_HRS_OFF_DTL A , PS_HRS_OFF_CMPNT B 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)

  • Related Language Record: HRS_OFF_DTL_LVW

    • # 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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    8 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