RIT_TREE_NDE_VW

(SQL View)
 Index Back

Tree Node


SELECT b.Market , a.TREECTL_NAME , a.TREE_NODE4 , a.TREE_NODE , a.STATUS , a.NODE_DESCR , a.DISPLAY_OPTION1 , a.PARENT_NODE , a.TREE_LEVEL_NUM , b.SEQNUM , a.TREE_TAG , a.CHILD_NODE_TYPE , a.CHILD_NODE_NUM , a.VIEWNAME , a.SETCNTRLFLD , a.SETCNTRLVALUE , a.ID_NAME , a.ID_TYPE , a.ID_VALUE , a.NODE_DESCR_FLD , a.NODE_DESCR_FLD2 , a.NODE_DESCR_FLD3 , a.NODE_DESCR_FLD4 , a.MENUNAME , a.BARNAME , a.ITEMNAME , a.PAGENAME , a.SRCH_RECORD , a.TRANSFER_MODE , b.MAX_ROWS_SCROLL , b.VISIBLE , a.ORDER_BY_COLS , a.TREECTL_NODE , b.HIDE_HEADER , a.CONSUMER_FLAG , a.SUBINT_OBJ_TYPE , b.EXPANDED_FLAG , a.RIT_TREE_ACTION , a.WHERE_TYPE FROM PS_RIT_TREECTL_NDE a ,PS_RIT_CONFIG_TREE b WHERE a.TREECTL_NAME = b.TREECTL_NAME AND a.TREE_NODE4 = b.TREE_NODE4

  • Related Language Record: RIT_TREENDE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    2 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name
    3 TREE_NODE4 Character(4) VARCHAR2(4) NOT NULL Tree Node Name (ID)
    4 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    6 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.
    7 DISPLAY_OPTION1 Character(1) VARCHAR2(1) NOT NULL Display Option
    B=Both
    D=Description
    N=Name

    Default Value: D

    8 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node

    Prompt Table: RBF_TREECTL_NDE

    9 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record

    Default Value: 1

    10 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    11 TREE_TAG Character(3) VARCHAR2(3) NOT NULL Tree Tag
    L_L=Leaf Under Leaf
    L_N=Leaf Under Node
    N_L=Node Under Leaf
    N_N=Node Under Node
    N_R=Node Under Root
    R=Root
    12 CHILD_NODE_TYPE Character(3) VARCHAR2(3) NOT NULL Folder
    LEA=Leaf
    NOD=Folder

    Default Value: NOD

    13 CHILD_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Child Node Number

    Default Value: 999

    14 VIEWNAME Character(30) VARCHAR2(30) NOT NULL View Name
    15 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
    16 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    17 ID_NAME Character(20) VARCHAR2(20) NOT NULL ID Fld in View
    18 ID_TYPE Character(3) VARCHAR2(3) NOT NULL ID Type
    CHA=Character
    NUM=Number

    Default Value: CHA

    19 ID_VALUE Character(30) VARCHAR2(30) NOT NULL ID Value
    20 NODE_DESCR_FLD Character(20) VARCHAR2(20) NOT NULL Description Field
    21 NODE_DESCR_FLD2 Character(20) VARCHAR2(20) NOT NULL Second Field
    22 NODE_DESCR_FLD3 Character(20) VARCHAR2(20) NOT NULL Third Field
    23 NODE_DESCR_FLD4 Character(20) VARCHAR2(20) NOT NULL Fourth Field
    24 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    25 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    26 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    27 PAGENAME Character(30) VARCHAR2(30) NOT NULL Page Name
    28 SRCH_RECORD Character(15) VARCHAR2(15) NOT NULL Search Record
    29 TRANSFER_MODE Character(1) VARCHAR2(1) NOT NULL Transfer Mode
    A=Add
    C=Correction
    E=Data Entry
    L=Update/Display All
    U=Update/Display

    Default Value: U

    30 MAX_ROWS_SCROLL Number(5,0) INTEGER NOT NULL Max Number of Rows in Scrolls

    Default Value: 0

    31 VISIBLE Character(1) VARCHAR2(1) NOT NULL Show Sub Page

    Y/N Table Edit

    Default Value: Y

    32 ORDER_BY_COLS Character(50) VARCHAR2(50) NOT NULL Order by
    33 TREECTL_NODE Character(30) VARCHAR2(30) NOT NULL Node name
    34 HIDE_HEADER Character(1) VARCHAR2(1) NOT NULL Hide the Lead/Opportunity Header fields.

    Y/N Table Edit

    Default Value: N

    35 CONSUMER_FLAG Character(1) VARCHAR2(1) NOT NULL To indicate whether a person has a consumer role.

    Y/N Table Edit

    Default Value: N

    36 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    37 EXPANDED_FLAG Character(1) VARCHAR2(1) NOT NULL Expanded Flag

    Y/N Table Edit

    Default Value: Y

    38 RIT_TREE_ACTION Character(1) VARCHAR2(1) NOT NULL Tree Action Type
    N=None (Link Inactive)
    P=Fire PeopleCode(See Document)
    T=Transfer (Transfer to Page)
    39 WHERE_TYPE Character(1) VARCHAR2(1) NOT NULL Where Type
    D=Default Where Clause
    E=Exception Where Clause