HRS_JOB_LOC_VW

(SQL View)
 Index Back

Job Opening Location

Location of Job Opening

SELECT A.HRS_JOB_OPENING_ID , A.HRS_PRM_LOCATION , C.DESCR , C.CITY , C.STATE , C.COUNTRY , A.HRS_PRM_LOC_AREA , RL.HRS_RECR_LOCATION FROM PS_HRS_JOB_OPENING A LEFT OUTER JOIN PS_HRS_JOB_LOC_VW2 RL ON (A.HRS_JOB_OPENING_ID = RL.HRS_JOB_OPENING_ID) LEFT OUTER JOIN PS_HRS_LOCATION_I4 C ON (A.HRS_PRM_LOCATION = C.LOCATION AND A.BUSINESS_UNIT = %Substring(C.SETCNTRLVALUE,1,5))

  • Related Language Record: HRS_JOB_LOC_LV1

    • # 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
    2 HRS_PRM_LOCATION Character(10) VARCHAR2(10) NOT NULL Primary Recruiting Location of Job Opening,
    3 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location
    4 CITY Character(30) VARCHAR2(30) NOT NULL City
    5 STATE Character(6) VARCHAR2(6) NOT NULL State
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    7 HRS_PRM_LOC_AREA Number(15,0) DECIMAL(15) NOT NULL Primary recruiting location area
    8 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location