RB_TD_TREE_HDR

(SQL Table)
 Index Back

360 View Tree Header

360 View Tree Header. This is used by the Tree definition in 360-Degree View.

  • Related Language Record: RB_TD_TREE_RLR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 TREE_SPEC_TYPE Character(1) VARCHAR2(1) NOT NULL This field is used as a flag to check the whether Interaction with status 'Callback' need to set to complete or not.
    G=Set status to complete
    S=Do not set status to complete

    Default Value: S

    4 TREECTL_RECNAME Character(20) VARCHAR2(20) NOT NULL Tree Control Record Name

    Prompt Table: RB_TD_RECDFN_VW

    5 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
    6 TREECTL_ID_TYPE Character(3) VARCHAR2(3) NOT NULL Tree Control ID Field Type
    CHA=Character
    NUM=Number

    Default Value: CHA

    7 TREECTL_ID_NAME Character(20) VARCHAR2(20) NOT NULL Tree Control ID Field Name

    Prompt Table: RB_TD_KEYFLD_VW

    8 MOBILE_FLG Character(1) VARCHAR2(1) NOT NULL Mobile Flag
    N=Normal Tree
    Y=Mobile Tree

    Y/N Table Edit

    Default Value: N

    9 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

    Y/N Table Edit

    Default Value: N

    10 DATE_CRITERIA Character(4) VARCHAR2(4) NOT NULL Date Criteria
    A=7 - View All
    D0=1 - Today
    D1=2 - Yesterday
    D15=4 - Last 2 Weeks
    D17=3 - Last Week
    D30=5 - Last Month
    Y1=6 - Last Year
    11 MAX_DATE_CRITERIA Character(4) VARCHAR2(4) NOT NULL Date Criteria
    A=7 - View All
    D0=1 - Today
    D1=2 - Yesterday
    D15=4 - Last 2 Weeks
    D17=3 - Last Week
    D30=5 - Last Month
    Y1=6 - Last Year
    12 DATE_FILTER Character(18) VARCHAR2(18) NOT NULL Date Filter Field
    13 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    14 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
    15 PAGE_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Page Field Name
    16 PAGE_SIZE Number(3,0) SMALLINT NOT NULL Page Size
    17 DISPLAY_LEVELS Number(2,0) SMALLINT NOT NULL Display Levels
    18 COLLAPSED_IMAGE Character(30) VARCHAR2(30) NOT NULL Collapsed Image Name

    Prompt Table: RC_TB_IMAGE_VW

    19 EXPANDED_IMAGE Character(30) VARCHAR2(30) NOT NULL Expanded Image Name

    Prompt Table: RC_TB_IMAGE_VW

    20 END_NODE_IMAGE Character(30) VARCHAR2(30) NOT NULL End Node Image Name

    Prompt Table: RC_TB_IMAGE_VW

    21 LEAF_IMAGE Character(30) VARCHAR2(30) NOT NULL Name of image that is used for leaf , i.e. detail values in tree

    Prompt Table: RC_TB_IMAGE_VW

    22 FOOTNOTE_IMAGE Character(30) VARCHAR2(30) NOT NULL Image Field for Footnote Image on 360-Degree View.

    Prompt Table: RC_TB_IMAGE_VW

    23 IMAGE_WIDTH Number(2,0) SMALLINT NOT NULL Image Width
    24 IMAGE_HEIGHT Number(2,0) SMALLINT NOT NULL Image Height
    25 INDENT_PIXELS Number(2,0) SMALLINT NOT NULL Indent Pixels
    26 TREECTL_VERSION Number(4,0) SMALLINT NOT NULL HTML Tree Version
    27 TOP_NODE_NUM Number(7,0) INTEGER NOT NULL Top Node Num
    28 LEFT_LEVEL_NUM Number(2,0) SMALLINT NOT NULL Left Level Num
    29 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    30 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    31 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    32 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    33 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.
    34 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    35 RC_MAINT_OWNER Character(1) VARCHAR2(1) NOT NULL Call center Maintenance Owner
    0=PeopleSoft
    1=PeopleSoft / Customer Modified
    2=Customer

    Default Value: 2

    36 SYSD_APPLICATION01 Character(1) VARCHAR2(1) NOT NULL PS CRM Core
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    37 SYSD_APPLICATION02 Character(1) VARCHAR2(1) NOT NULL Financial Services
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    38 SYSD_APPLICATION03 Character(1) VARCHAR2(1) NOT NULL Telecommunications
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    39 SYSD_APPLICATION04 Character(1) VARCHAR2(1) NOT NULL Government
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    40 SYSD_APPLICATION05 Character(1) VARCHAR2(1) NOT NULL Energy
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    41 SYSD_APPLICATION06 Character(1) VARCHAR2(1) NOT NULL Insurance
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    42 SYSD_APPLICATION07 Character(1) VARCHAR2(1) NOT NULL High Technology
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    43 SYSD_APPLICATION08 Character(1) VARCHAR2(1) NOT NULL HR HelpDesk
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    44 SYSD_APPLICATION09 Character(1) VARCHAR2(1) NOT NULL System Data Field for Application 9. Application 9 is used for Wealth Management.
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N

    45 SYSD_APPLICATION10 Character(1) VARCHAR2(1) NOT NULL Used in Application 10
    N=No
    S=Sample Data
    Y=Yes

    Y/N Table Edit

    Default Value: N