HRS_LOC_AR_NS_V

(SQL View)
 Index Back

Nested Locations

Nested locations within a recruiting location area

SELECT A.SETID , A.HRS_LOCATION_ID , A.LOCATION , CASE WHEN A.hrs_loc_id = 0 THEN A.hrs_location_id ELSE A.hrs_loc_id END , A.HRS_SEQ_NUM , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_LOC_AREA A , PS_HRS_LOC_AREA_VW B WHERE A.setid = B.setid AND A.hrs_loc_id = B.hrs_location_id

  • Parent record: HRS_LOCATION

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 HRS_LOCATION_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area

    Prompt Table: HRS_RECR_LOC_I

    3 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HRS_LOCATN_I

    4 HRS_LOC_ID Number(15,0) DECIMAL(15) NOT NULL Recruiting location area within a recruiting location area

    Prompt Table: HRS_RECR_LOC_I

    5 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 HRS_ROW_ADD_DTTM DateTime(26) TIMESTAMP Row Added DateTime
    7 HRS_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Added Operator Id
    8 HRS_ROW_UPD_DTTM DateTime(26) TIMESTAMP Row Updated DateTime
    9 HRS_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Row Updated Operator Id