RB_TD_NDERECVW

(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.NODE_DESCR FROM PS_RB_TD_NODE A WHERE A.TD_NODE_TYPE IN ('VIEW','EIP','PCDE')

  • Related Language Record: RB_TD_NDERECLVW

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