RB_TD_TNDE_VW

(SQL View)
 Index Back

Tree Node View

Tree Node View used as a prompt view.

SELECT a.TREECTL_NAME , a.TREE_NODE_ID , b.NODE_DESCR FROM PS_RB_TD_TREE_NDE a , PS_RB_TD_NODE b WHERE a.TREE_NODE_ID = b.TREE_NODE_ID

  • Related Language Record: RB_TD_TNDE_LVW

    • # 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

    Prompt Table: RB_TD_NODE

    3 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.