RB_TD_TRNODE_VW

(SQL View)
 Index Back

Work Record for 360 Degree

Work Record for 360 Degree Tree

SELECT b.TREECTL_NAME , a.TREE_NODE_ID , a.NODE_DESCR , a.RB_TRANSACTION_ID ,a.DISABLE_INACTIVEBO ,a.MARKET ,a.TD_NODE_TYPE ,a.FUNCTION_NAME ,a.APPCLASSID ,a.APPCLASS_PATH , b.TREE_NODE , b.DISPLAY_OPTION1 , b.PARENT_NODE , b.TREE_LEVEL_NUM , b.CHILD_NODE_TYPE , b.TREE_TAG , b.SEQNUM , b.MAX_ROWS_SCROLL , b.MAX_ROWS_FETCH , b.EXPANDED_FLAG , b.HIDE_HEADER , a.ROOT_FLAG , b.CHILD_NODE_NUM , b.OVERRIDE_IMAGE , b.VIEW_NAME , b.ID_NAME , b.ID_TYPE , b.ID_VALUE , a.SRCH_RECORD , a.SETCNTRLFLD , a.SETCNTRLVALUE , a.NODE_ACTION , a.TRANSFER_MODE , a.TDNODE_FLG , a.PORTAL_NAME , a.PORTAL_OBJNAME , a.SUBINT_OBJ_TYPE , b.SYNCID , b.SYNCDTTM , b.FILTER_FLG , a.RB_TD_GRID_ID , c.RB_TD_RGRID_ID , c.MESSAGE_SET_NBR01 , c.MESSAGE_NBR01 , c.MESSAGE_SET_NBR02 , c.MESSAGE_NBR02 FROM PS_RB_TD_TREE_NDE b , PS_RB_TD_NODE a , PS_RB_TD_NODE_RGRD c WHERE a.TREE_NODE_ID = b.TREE_NODE_ID AND a.TREE_NODE_ID = c.TREE_NODE_ID (+) AND b.STATUS = 'A'

  • Related Language Record: RB_TD_NODEV_RLR

    • # 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
    3 NODE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree node description.
    4 RB_TRANSACTION_ID Character(25) VARCHAR2(25) NOT NULL Transaction ID
    5 DISABLE_INACTIVEBO Character(1) VARCHAR2(1) NOT NULL This flag is used to identify if the Action is to be disabled for Inactive Business Objects.
    6 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    7 TD_NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
    EIP=EIP - (Synchronous)
    PCDE=PeopleCode
    PLAC=Placeholder
    VIEW=View
    8 FUNCTION_NAME Character(30) VARCHAR2(30) NOT NULL Function Name
    9 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
    10 APPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL Application Class Full Path
    11 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    12 DISPLAY_OPTION1 Character(1) VARCHAR2(1) NOT NULL Display Option
    B=Both
    D=Description
    N=Name
    13 PARENT_NODE Character(20) VARCHAR2(20) NOT NULL Parent Tree Node
    14 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
    15 CHILD_NODE_TYPE Character(3) VARCHAR2(3) NOT NULL Folder
    LEA=Leaf
    NOD=Folder
    16 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
    17 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    18 MAX_ROWS_SCROLL Number(5,0) INTEGER NOT NULL Max Number of Rows in Scrolls
    19 MAX_ROWS_FETCH Number(5,0) INTEGER NOT NULL Max. Rows to Fetch
    20 EXPANDED_FLAG Character(1) VARCHAR2(1) NOT NULL Expanded Flag
    21 HIDE_HEADER Character(1) VARCHAR2(1) NOT NULL Hide the Lead/Opportunity Header fields.
    22 ROOT_FLAG Character(1) VARCHAR2(1) NOT NULL Root Flag
    23 CHILD_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Child Node Number
    24 OVERRIDE_IMAGE Character(30) VARCHAR2(30) NOT NULL Override Image
    25 VIEW_NAME Character(30) VARCHAR2(30) NOT NULL View Name
    26 ID_NAME Character(20) VARCHAR2(20) NOT NULL ID Fld in View
    27 ID_TYPE Character(3) VARCHAR2(3) NOT NULL ID Type
    CHA=Character
    NUM=Number
    28 ID_VALUE Character(30) VARCHAR2(30) NOT NULL ID Value
    29 SRCH_RECORD Character(15) VARCHAR2(15) NOT NULL Search Record
    30 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
    31 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
    32 NODE_ACTION Character(1) VARCHAR2(1) NOT NULL Node Action
    A=Action
    C=Portal Content Reference
    G=Dynamic Grid
    N=None
    P=Application Class
    T=Transfer
    33 TRANSFER_MODE Character(1) VARCHAR2(1) NOT NULL Transfer Mode
    A=Add
    C=Correction
    E=Data Entry
    L=Update/Display All
    U=Update/Display
    34 TDNODE_FLG Character(1) VARCHAR2(1) NOT NULL Field for Indicating whether node is Search or New Node
    F=Folder
    N=Add Node
    S=Search Node
    V=View All
    35 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    36 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
    37 SUBINT_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL sub-interaction object type
    38 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.
    39 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    40 FILTER_FLG Character(1) VARCHAR2(1) NOT NULL Use this field as Filter
    N=No
    Y=Yes
    41 RB_TD_GRID_ID Character(30) VARCHAR2(30) NOT NULL Unique Identifier field for Dynamic Grid. This is a key field in RB_TD_DYNGRDHDR, RB_TD_DYNGHDLNG, RB_TD_DYNGRDLN
    42 RB_TD_RGRID_ID Character(30) VARCHAR2(30) NOT NULL Unique Identifier field for Dynamic Grid. This is a key field in RB_TD_DYNGRDHDR, RB_TD_DYNGHDLNG, RB_TD_DYNGRDLN
    43 MESSAGE_SET_NBR01 Number(5,0) INTEGER NOT NULL Message Catalog Number is used to store the message catalog number and dynamically retrieve a message.

    Prompt Table: RB_MSGSET_VW

    44 MESSAGE_NBR01 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: RB_TD_MSGCAT_V1

    45 MESSAGE_SET_NBR02 Number(5,0) INTEGER NOT NULL Catalog Number

    Prompt Table: RB_MSGSET_VW

    46 MESSAGE_NBR02 Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: RB_TD_MSGCAT_V2