HRS_JO_PRLOC_VW

(SQL View)
 Index Back

Job Opening Location Areas Int

Job opening location areas based on HR locations or other location areas interface view

SELECT A.HRS_JOB_OPENING_ID , A.HRS_LOCATION_ID , D.DESCR , D.DESCRSHORT , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_JO_LOC_AREA A , PS_HRS_JO_I B , PS_SET_CNTRL_REC C , PS_HRS_LOC_I D WHERE A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID AND C.RECNAME = 'HRS_LOC_AREA_I' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.HRS_LOCATION_ID = D.HRS_LOCATION_ID AND D.SETID = C.SETID AND A.HRS_JO_PRM_LCA_FLG = 'Y'

  • Related Language Record: HRS_JO_LCA_LN_I

  • Parent record: HRS_JO_I

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRS_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone

    Prompt Table: HRS_JO_I

    2 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area

    Prompt Table: HRS_LOCATION

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    6 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    7 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    8 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id