HRS_LOC_AREA_I

(SQL View)
 Index Back

Locations in RS Area Intfc

All locations within a recruiting location area interface

SELECT A.SETID , A.HRS_LOCATION_ID , A.HRS_SEQ_NUM , A.LOCATION , A.HRS_LOC_ID , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_LOC_AREA A

  • Parent record: HRS_LOC_I

    • # 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_LOC_I

    3 HRS_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: HRS_LOCATION_I

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

    Prompt Table: HRS_LOC_I

    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