CATEGORY_NS_VW

(SQL View)
 Index Back

Asset Categories View


SELECT DISTINCT a.category , a.descr FROM PS_CATEGORY_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_CATEGORY_TBL b WHERE b.effdt <= %CurrentDateIn AND b.eff_status = 'A' AND b.setid = a.setid AND b.category = a.category)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description