RB_TD_NDERECLVW

(SQL View)
 Index Back

Node-MessageRec View

This view returns nodes with the record name. this view is used as the prompt table on RB_TD_EIP_INOPT table for TREE_NODE_ID field

SELECT A.TREE_NODE_ID , A.LANGUAGE_CD ,A.NODE_DESCR FROM PS_RB_TD_NODE_RLR A , PS_RB_TD_NODE B WHERE B.TD_NODE_TYPE IN ('VIEW','EIP','PCDE') AND A.TREE_NODE_ID = B.TREE_NODE_ID

  • Related Language Record for RB_TD_NDERECVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREE_NODE_ID Character(15) VARCHAR2(15) NOT NULL Node ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.