HRS_GEO_LOC_I2

(SQL View)
Index Back

Recruit Locations Prompt View

Recruiting Locations Prompt View

SELECT A.HRS_LOCATION_ID , A.SETID , A.STATUS , A.DESCR , A.DESCRSHORT , %subrec(HRS_AUDIT_SBR, A) FROM PS_HRS_LOCATION A

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

    Prompt Table: HRS_SET_LOC_VW

    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    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