HRS_JOOFRLHTVW3

(SQL View)
 Index Back

Record used for Fluid approval

This record is used for Job Offer Fluid Approvals

SELECT DISTINCT OFR.HRS_OFF_ID , OFR.HRS_PERSON_ID , OFR.HRS_RCMNT_ID , BU.LANGUAGE_CD , CASE WHEN J.HRS_JOB_OPENING_ID > 0 THEN J.HRS_PRM_PST_TITLE ELSE MSG.MESSAGE_TEXT END FROM PS_HRS_OFFER OFR , PS_HRS_RCMNT RCM LEFT OUTER JOIN PS_HRS_JO_LNG J ON J.HRS_JOB_OPENING_ID = RCM.HRS_JOB_OPENING_ID , PS_BUS_UNIT_HR_LNG BU , PSMSGCATLANG MSG WHERE RCM.HRS_PERSON_ID = OFR.HRS_PERSON_ID AND RCM.HRS_RCMNT_ID = OFR.HRS_RCMNT_ID AND BU.BUSINESS_UNIT = OFR.BUSINESS_UNIT AND MSG.MESSAGE_SET_NBR = 18177 AND MSG.MESSAGE_NBR = 1030 AND BU.LANGUAGE_CD = MSG.LANGUAGE_CD

  • Related Language Record for HRS_JOOFR_HTVW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_OFF_ID Number(15,0) DECIMAL(15) NOT NULL Offer ID
    2 HRS_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL Person Id
    3 HRS_RCMNT_ID Number(15,0) DECIMAL(15) NOT NULL App Tracking Recruitment ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title