RB_TD_TNDE_LVW

(SQL View)
 Index Back

Tree Node View

Tree Node View used as a prompt view.

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

  • Related Language Record for RB_TD_TNDE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.