HRS_LOC_GBL_VW (SQL View)	Index Back
All Locations View This view shows all locations globally regardless of SETID or COUNTRY_CD. Used by the Update/Create Resume self service transaction so the user can select a preferred geographic location to be associated with an application.

HRS_LOC_GBL_VW

(SQL View)

All Locations View

This view shows all locations globally regardless of SETID or COUNTRY_CD. Used by the Update/Create Resume self service transaction so the user can select a preferred geographic location to be associated with an application.

SELECT DISTINCT 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_GBL_VW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 STATE Character(6) VARCHAR2(6) NOT NULL State

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	STATE	Character(6)	VARCHAR2(6) NOT NULL	State
4	CITY	Character(30)	VARCHAR2(30) NOT NULL	City