HRS_OFF_DTL_VW3

(SQL View)
 Index Back

Offer Detail View

Offer Detail View for Mobile Approvals

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'

  • Related Language Record: HRS_OFF_DTLVW3L

    • # 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
    9 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    10 HRS_DESCR Character(30) VARCHAR2(30) NOT NULL Description