RB_TD_TRNDEGRD

(SQL View)
 Index Back

Tree Node Grid

This view returns all the Dynamic Grid's associated with the node in the tree

SELECT A.TREECTL_NAME ,B.TREE_NODE_ID ,B.RB_TD_GRID_ID FROM PS_RB_TD_TREE_NDE A , PS_RB_TD_NODE B WHERE B.TREE_NODE_ID = A.TREE_NODE_ID AND B.RB_TD_GRID_ID <> ' ' AND B.NODE_ACTION='G'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name
2 TREE_NODE_ID Character(15) VARCHAR2(15) NOT NULL Node ID
3 RB_TD_GRID_ID Character(30) VARCHAR2(30) NOT NULL Unique Identifier field for Dynamic Grid. This is a key field in RB_TD_DYNGRDHDR, RB_TD_DYNGHDLNG, RB_TD_DYNGRDLN