HRS_JOOFR_HTVW2

(SQL View)
 Index Back

JOB OFFER HEADER VIEW

JOB OFFER Mobile Approval Header view

SELECT DISTINCT OFR.HRS_OFF_ID , OFR.HRS_PERSON_ID , OFR.HRS_RCMNT_ID , J.HRS_PRM_PST_TITLE , J.HRS_JOB_OPENING_ID , J.HRS_JO_TYPE , X.XLATLONGNAME , J.SETID_DEPT , OFR.JOBCODE , JCD.DESCR , OFR.POSITION_NBR , CASE WHEN INST.FED = 'Y' THEN POS.GVT_ORG_TTL_DESCR ELSE POS.DESCR END , OFR.BUSINESS_UNIT , BU.DESCR , J.JOB_FAMILY , JFM.DESCR , J.COMPANY , OFR.OFFER_DT , OFR.HRS_PROP_ST_DT , OFR.HRS_OFR_DT_EXP , H.NAME_DISPLAY , Z.NAME_DISPLAY , ANM.NAME_DISPLAY FROM PS_HRS_OFFER OFR LEFT OUTER JOIN PS_HRS_PERSON_NM_I Z ON Z.EMPLID = OFR.RECRUITER_ID LEFT OUTER JOIN PS_HRS_PERSON_NM_I H ON H.EMPLID = OFR.HRS_HIRING_MGR_ID LEFT OUTER JOIN PS_HRS_POS_DTA_VW POS ON POS.POSITION_NBR = OFR.POSITION_NBR , PS_HRS_RCMNT RCM LEFT OUTER JOIN PS_HRS_JOB_OPENING J ON J.HRS_JOB_OPENING_ID = RCM.HRS_JOB_OPENING_ID LEFT OUTER JOIN PS_JOB_FAMILY_EFVW JFM ON JFM.JOB_FAMILY = J.JOB_FAMILY LEFT OUTER JOIN PSXLATITEM X ON X.FIELDNAME = 'HRS_JO_TYPE' AND X.FIELDVALUE = J.HRS_JO_TYPE , PS_JOBCODE_TBL JCD , PS_BUS_UNIT_TBL_HR BU , PS_HRS_APP_NAMES ANM , PS_INSTALLATION INST WHERE RCM.HRS_PERSON_ID = OFR.HRS_PERSON_ID AND RCM.HRS_RCMNT_ID = OFR.HRS_RCMNT_ID AND JCD.SETID = ( SELECT SCR.SETID FROM PS_SET_CNTRL_REC SCR WHERE SCR.SETCNTRLVALUE = OFR.BUSINESS_UNIT AND RECNAME = 'JOBCODE_TBL') AND JCD.JOBCODE = OFR.JOBCODE AND JCD.EFFDT = ( SELECT MAX(JCD2.EFFDT) FROM PS_JOBCODE_TBL JCD2 WHERE JCD2.SETID = JCD.SETID AND JCD2.JOBCODE = JCD.JOBCODE AND JCD2.EFFDT <= %CurrentDateIn) AND JCD.EFF_STATUS = 'A' AND BU.BUSINESS_UNIT = OFR.BUSINESS_UNIT AND OFR.HRS_PERSON_ID = ANM.HRS_PERSON_ID AND ANM.NAME_TYPE = 'PRI'

  • Related Language Record: HRS_JOOFRHTVW2L

    • # 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 POSTING_TITLE Character(200) VARCHAR2(200) NOT NULL Job posting title
    5 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
    6 HRS_JO_TYPE Character(1) VARCHAR2(1) NOT NULL Job Opening Type
    P=Continuous Job Opening
    R=Standard Requisition
    7 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    9 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    10 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    11 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    12 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
    13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    16 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    17 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    18 OFFER_DT Date(10) DATE Offer Date
    19 HRS_PROP_ST_DT Date(10) DATE Start Date
    20 HRS_OFR_DT_EXP Date(10) DATE Offer Expiration Date
    21 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    22 NAME_FIELD Character(50) VARCHAR2(50) NOT NULL Name Field
    23 NAME_DESCR Character(50) VARCHAR2(50) NOT NULL Description