TREECTL_NAMETREE_NODE_IDRB_TD_GRID_IDRB_TD_ND_GRD_VW(SQL View) |
Index Back |
|---|---|
Tree Node GridThis view returns all the Dynamic Grid's associated with the node in the tree |
| SELECT TN.TREECTL_NAME ,N.TREE_NODE_ID ,N.RB_TD_GRID_ID ,N.NODE_DESCR ,G.DESCR254 FROM PS_RB_TD_TREE_NDE TN , PS_RB_TD_NODE N , PS_RB_TD_DYNGRDHDR G WHERE N.TREE_NODE_ID = TN.TREE_NODE_ID AND N.RB_TD_GRID_ID <> ' ' AND N.NODE_ACTION='G' AND N.RB_TD_GRID_ID = G.RB_TD_GRID_ID |
| # | 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 |
| 4 | NODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Tree node description. |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |