LOCATION_MC_VW

(SQL View)
 Index Back

View of Locations for MC


select distinct a.location, a.descr from PS_LOCATION_TBL a where a.effdt = (select max(b.effdt) from PS_LOCATION_TBL b where a.setid = b.setid and a.location = b.location) and a.eff_status = 'A'

  • Related Language Record: LOCATION_MC_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