HRS_RLOC_HIER_L

(SQL View)
 Index Back

Job Opening Recruiting Loc

Related Language Record for HRS_RLOC_HIER_V.

SELECT A.HRS_JOB_OPENING_ID , 'CG' , 1 , ML.HRS_LOCATION_ID , ML.LANGUAGE_CD , ML.HRS_RECR_LOC_ALL , ML.HRS_RECR_LOC_LVL01 , ML.HRS_RECR_LOC_LVL01 , ML.HRS_RECR_LOC_LVL02 , ML.HRS_RECR_LOC_LVL03 , ML.HRS_RECR_LOC_LVL04 , ML.HRS_RECR_LOC_LVL05 FROM PS_HRS_JO_LOC_AREA A INNER JOIN PS_HRS_JOB_OPENING B ON A.HRS_JOB_OPENING_ID = B.HRS_JOB_OPENING_ID INNER JOIN PS_SET_CNTRL_REC C ON %Substring(C.SETCNTRLVALUE , 1 ,5) = B.BUSINESS_UNIT AND C.RECNAME = 'HRS_LOC_AREA_I' INNER JOIN PS_HRS_RLOC_MAP_JP M ON M.HRS_LOCATION_ID = A.HRS_LOCATION_ID AND M.SETID = C.SETID AND B.HRS_JOB_OPENING_ID <> 0 INNER JOIN PS_HRS_RLOC_MJP_LN ML ON ML.HRS_LOCATION_ID = M.HRS_LOCATION_ID AND ML.SETID = M.SETID

  • Related Language Record for HRS_RLOC_HIER_V

    • # 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_SRCH_APPLICA Character(4) VARCHAR2(4) NOT NULL application where the search location is used/
    CG=Candidate Gateway
    TAM=Talent Aquisition Management
    3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 HRS_RECR_LOC_ALL Long Character CLOB Location
    7 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    8 HRS_RECR_LOC_LVL01 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    9 HRS_RECR_LOC_LVL02 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    10 HRS_RECR_LOC_LVL03 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    11 HRS_RECR_LOC_LVL04 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    12 HRS_RECR_LOC_LVL05 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location