RIT_TREECTL_NDE

(SQL Table)
 Index Back

Tree Node

Table contains the relationship between tree and node. This table was used in CRM 8.4 and is not being used anymore in crm versions greater then 8.4

  • Related Language Record: RIT_TREECTL_LNG

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

    Default Value: A

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

    Default Value: D

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

    Prompt Table: RIT_TREECTL_NDE

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

    Default Value: 1

    9 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    10 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
    11 CHILD_NODE_TYPE Character(3) VARCHAR2(3) NOT NULL Folder
    LEA=Leaf
    NOD=Folder

    Default Value: NOD

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

    Default Value: 999

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

    Default Value: CHA

    18 ID_VALUE Character(30) VARCHAR2(30) NOT NULL ID Value
    19 NODE_DESCR_FLD Character(20) VARCHAR2(20) NOT NULL Description Field
    20 NODE_DESCR_FLD2 Character(20) VARCHAR2(20) NOT NULL Second Field
    21 NODE_DESCR_FLD3 Character(20) VARCHAR2(20) NOT NULL Third Field
    22 NODE_DESCR_FLD4 Character(20) VARCHAR2(20) NOT NULL Fourth Field
    23 WHERE_TYPE Character(1) VARCHAR2(1) NOT NULL Where Type
    D=Default Where Clause
    E=Exception Where Clause

    Default Value: D

    24 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: RBT_MENU_VW

    25 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: RB_BARNAME_VW
    Set Control Field: MENUNAME

    26 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: RB_ITEMNAME_VW
    Set Control Field: BARNAME

    27 PAGENAME Character(30) VARCHAR2(30) NOT NULL Page Name

    Prompt Table: RBT_PAGENAME_VW
    Set Control Field: ITEMNAME

    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)

    Default Value: N

    39 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    40 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    41 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    42 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    43 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    44 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time