TREECTL_NAMETREE_NODE_IDLANGUAGE_CDRB_TD_NODEV_RLR(SQL View) |
Index Back |
|---|---|
Work Record for 360 Degree TreWork Record for 360 Degree Tree |
| SELECT b.TREECTL_NAME , a.TREE_NODE_ID , c.LANGUAGE_CD , c.NODE_DESCR , a.RB_TRANSACTION_ID , a.DISABLE_INACTIVEBO ,a.FUNCTION_NAME ,a.APPCLASSID ,a.APPCLASS_PATH , b.TREE_NODE , b.PARENT_NODE , b.EXPANDED_FLAG , b.HIDE_HEADER , a.ROOT_FLAG , b.OVERRIDE_IMAGE , b.VIEW_NAME , b.ID_NAME , b.ID_VALUE , a.SRCH_RECORD , a.SETCNTRLFLD , a.SETCNTRLVALUE , a.PORTAL_NAME , a.PORTAL_OBJNAME , a.RB_TD_GRID_ID FROM PS_RB_TD_NODE a , PS_RB_TD_TREE_NDE b , PS_RB_TD_NODE_RLR c WHERE a.TREE_NODE_ID = b.TREE_NODE_ID AND b.STATUS = 'A' AND a.TREE_NODE_ID = c.TREE_NODE_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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | NODE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Tree node description. |
| 5 | RB_TRANSACTION_ID | Character(25) | VARCHAR2(25) NOT NULL | Transaction ID |
| 6 | DISABLE_INACTIVEBO | Character(1) | VARCHAR2(1) NOT NULL | This flag is used to identify if the Action is to be disabled for Inactive Business Objects. |
| 7 | FUNCTION_NAME | Character(30) | VARCHAR2(30) NOT NULL | Function Name |
| 8 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 9 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 10 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 11 | PARENT_NODE | Character(20) | VARCHAR2(20) NOT NULL | Parent Tree Node |
| 12 | EXPANDED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Expanded Flag |
| 13 | HIDE_HEADER | Character(1) | VARCHAR2(1) NOT NULL | Hide the Lead/Opportunity Header fields. |
| 14 | ROOT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Root Flag |
| 15 | OVERRIDE_IMAGE | Character(30) | VARCHAR2(30) NOT NULL | Override Image |
| 16 | VIEW_NAME | Character(30) | VARCHAR2(30) NOT NULL | View Name |
| 17 | ID_NAME | Character(20) | VARCHAR2(20) NOT NULL | ID Fld in View |
| 18 | ID_VALUE | Character(30) | VARCHAR2(30) NOT NULL | ID Value |
| 19 | SRCH_RECORD | Character(15) | VARCHAR2(15) NOT NULL | Search Record |
| 20 | SETCNTRLFLD | Character(18) | VARCHAR2(18) NOT NULL | Tree Structure Node User Key Field Name |
| 21 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 22 | PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
| 23 | PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 24 | 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 |