HR_LOCLY3_VW

(SQL View)
 Index Back

Location View

Union Hourly Location Code View

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

Prompt Table: SETID_TBL

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

Prompt Table: LOCATION_TBL

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