PSTREELVLNUMVW

Return to Index

Tree Mgr Level Page

PlatformView Text
DefaultSELECT DISTINCT LVL.SETID ,LVL.TREE_NAME , LVL.TREE_LEVEL_NUM , LVL.TREE_LEVEL , LVL_VW.DESCR FROM PSTREELEVEL LVL , PS_TREE_LEVEL_VW LVL_VW WHERE LVL_VW.TREE_LEVEL = LVL.TREE_LEVEL

PeopleSoft Field NameDescription
DTL_SETIDTree Structure Summary Detail Tree SetId
DTL_TREE_NAMETree Structure Summary Detail Tree Name
TREE_LEVEL_NUMParent tree level if this is a part of the PSTREEBRANCH record
TREE_LEVELTree Level Number
DESCRDescription

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010