HRS_JOOFR_HTVW3

(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 , CASE WHEN J.HRS_JOB_OPENING_ID > 0 THEN J.HRS_PRM_PST_TITLE ELSE MSG.MESSAGE_TEXT END , J.HRS_JOB_OPENING_ID , J.HRS_JO_TYPE , ' ' , J.SETID_DEPT , OFR.JOBCODE , ' ' , OFR.POSITION_NBR , ' ' , OFR.BUSINESS_UNIT , BU.DESCR , J.JOB_FAMILY , ' ' , 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) , ' ' , ' ' , ANM.NAME_DISPLAY , ' ' , ' ' , ' ' , ' ' , ' ' ,SCR.SETID ,OFR.RECRUITER_ID , ' ' ,OFR.HRS_HIRING_MGR_ID , 'X' FROM PS_HRS_OFFER OFR , PS_SET_CNTRL_REC SCR , PS_HRS_RCMNT RCM LEFT OUTER JOIN PS_HRS_JOB_OPENING J ON J.HRS_JOB_OPENING_ID = RCM.HRS_JOB_OPENING_ID , PS_BUS_UNIT_TBL_HR BU , PS_HRS_APP_NAMES ANM , PS_INSTALLATION INST , PSMSGCATDEFN MSG WHERE OFR.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'JOBCODE_TBL' AND 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' AND MSG.MESSAGE_SET_NBR = 18177 AND MSG.MESSAGE_NBR = 51

  • Related Language Record: HRS_JOOFRLHTVW3

    • # 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 DESCR40_1 Character(40) VARCHAR2(40) NOT NULL Field used to hold a character field of up to length 40
    31 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    32 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID
    33 HRS_JOB_ID_STR Character(10) VARCHAR2(10) NOT NULL This is used in Fluid Approval to display blank value for Job Opening ID for Job Offer transaction
    34 HRS_HIRING_MGR_ID Character(11) VARCHAR2(11) NOT NULL Hiring Manager
    35 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.