HRS_LOC_ALL_VW

(SQL View)
 Index Back

All Locations View

This view shows all locations regardless of SETID. Used by the View Job Postings self service transaction so the user

SELECT DISTINCT A.COUNTRY , A.LOCATION , A.DESCR , A.STATE , A.CITY FROM PS_LOCATION_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_LOCATION_TBL B WHERE B.SETID = A.SETID AND B.LOCATION = A.LOCATION AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: LOC_ALL_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code

    Prompt Table: HRS_COUNTRY_VW

    2 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: HRS_CC_STATE_VW

    5 CITY Character(30) VARCHAR2(30) NOT NULL City