HRS_JOOFR_HT_VW

(SQL View)
 Index Back

JOB OFFER HEADER VIEW

JOB OFFER HTML Email 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 , POS.DESCR , OFR.BUSINESS_UNIT , BU.DESCR , J.JOB_FAMILY , JFM.DESCR , OFR.OFFER_DT , %Sql(HR_HT_EMAIL_DATE,OFR.OFFER_DT) , OFR.HRS_PROP_ST_DT , %Sql(HR_HT_EMAIL_DATE,OFR.HRS_PROP_ST_DT) , OFR.HRS_OFR_DT_EXP , %Sql(HR_HT_EMAIL_DATE,OFR.HRS_OFR_DT_EXP) , H.NAME_DISPLAY , Z.NAME_DISPLAY , ANM.NAME_DISPLAY , CASE J.JOB_FAMILY WHEN ' ' THEN ' ' ELSE J.JOB_FAMILY %Concat ' (' %Concat JFM.DESCR %Concat ')' END , CASE OFR.POSITION_NBR WHEN ' ' THEN ' ' ELSE OFR.POSITION_NBR %Concat ' (' %Concat POS.DESCR %Concat ')' END , CASE OFR.BUSINESS_UNIT WHEN ' ' THEN ' ' ELSE OFR.BUSINESS_UNIT %Concat ' (' %Concat BU.DESCR %Concat ')' END , CASE OFR.JOBCODE WHEN ' ' THEN ' ' ELSE OFR.JOBCODE %Concat ' (' %Concat JCD.DESCR %Concat ')' END , 'X' FROM PS_HRS_OFFER_VW 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 LEFT OUTER JOIN PS_JOBCODE_TBL_VW JCD ON JCD.SETID = OFR.SETID_JOBCODE AND JCD.JOBCODE = OFR.JOBCODE , 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 PS_HRS_XLAT_EFF_VW X ON X.FIELDNAME = 'HRS_JO_TYPE' AND X.FIELDVALUE = J.HRS_JO_TYPE , PS_BUS_UNIT_TBL_HR BU , PS_HRS_APP_NAMES ANM 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 OFR.HRS_PERSON_ID = ANM.HRS_PERSON_ID AND ANM.NAME_TYPE = 'PRI'

  • Related Language Record: HRS_JOOFR_HT_LN

    • # 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 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    15 JOB_FAMILY Character(6) VARCHAR2(6) NOT NULL Job Family
    16 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    17 OFFER_DT Date(10) DATE Offer Date
    18 DESCR25 Character(25) VARCHAR2(25) NOT NULL Short description
    19 HRS_PROP_ST_DT Date(10) DATE Start Date
    20 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description
    21 HRS_OFR_DT_EXP Date(10) DATE Offer Expiration Date
    22 DESCR25_2 Character(25) VARCHAR2(25) NOT NULL Description part 2
    23 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    24 NAME_FIELD Character(50) VARCHAR2(50) NOT NULL Name Field
    25 NAME_DESCR Character(50) VARCHAR2(50) NOT NULL Description
    26 DESCR40 Character(40) VARCHAR2(40) NOT NULL Description
    27 DESCR45 Character(45) VARCHAR2(45) NOT NULL Description
    28 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    29 DESCR50_1 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    30 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.