HRS_JO_LOC_AR_V

(SQL View)
 Index Back

Job Opening Recruiting Loc

Job opening recruiting locations candidate Gateway

SELECT A.HRS_JOB_OPENING_ID , A.HRS_SRCH_APPLICA , A.HRS_SEQ_NUM , A.HRS_RECR_LOC_ALL , A.HRS_RECR_LOCATION , A.HRS_RECR_LOC_LVL01 , A.HRS_RECR_LOC_LVL02 , A.HRS_RECR_LOC_LVL03 , A.HRS_RECR_LOC_LVL04 , A.HRS_RECR_LOC_LVL05 , A.HRS_LOCATION_ID , A.HRS_LOC_ID_LVL01 , A.HRS_LOC_ID_LVL02 , A.HRS_LOC_ID_LVL03 , A.HRS_LOC_ID_LVL04 , A.HRS_LOC_ID_LVL05 FROM PS_HRS_RLOC_HIER A

  • Related Language Record: HRS_JO_LOC_ARLV

    • # 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_RECR_LOC_ALL Long Character CLOB Location
    5 HRS_RECR_LOCATION Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    6 HRS_RECR_LOC_LVL01 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    7 HRS_RECR_LOC_LVL02 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    8 HRS_RECR_LOC_LVL03 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    9 HRS_RECR_LOC_LVL04 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    10 HRS_RECR_LOC_LVL05 Character(30) VARCHAR2(30) NOT NULL Job opening recruiting location
    11 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area

    Prompt Table: HRS_LOCATION

    12 HRS_LOC_ID_LVL01 Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area
    13 HRS_LOC_ID_LVL02 Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area
    14 HRS_LOC_ID_LVL03 Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area
    15 HRS_LOC_ID_LVL04 Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area
    16 HRS_LOC_ID_LVL05 Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area