ITM_CATALOG_VW

(SQL View)
 Index Back

Tree/Category view


select a.tree_name, a.descr from PSTREEDEFN a where a.EFFDT = (select max(EFFDT) from PSTREEDEFN where A.SETID = SETID and EFFDT <= %currentdatein and TREE_NAME = a.TREE_NAME)

  • Related Language Record: ITM_CATALOG_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATALOG_ID Character(18) VARCHAR2(18) NOT NULL Catalog ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description