PROJ_ND_NON_VW

(SQL View)
Index Back

Tree Dynamic Detail Nodes


select a.setid, a.tree_name, a.tree_node, a.effdt from PSTREENODE a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREE_NAME_SETID Character(5) VARCHAR2(5) NOT NULL TableSet
2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
4 EFFDT Date(10) DATE NOT NULL Effective Date