RBF_TREECTL_HDR

(SQL Table)
Index Back

Tree Specification Search Rec

Tree Specification Search Record to identify a tree

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TREECTL_NAME Character(15) VARCHAR2(15) NOT NULL Tree Name
2 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

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

Default Value: CHA

6 TREECTL_ID_NAME Character(20) VARCHAR2(20) NOT NULL Tree Control ID Field Name
7 PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name
8 COLLAPSED_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
9 COLLAPSED_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
10 EXPANDED_MSGNUM Number(5,0) INTEGER NOT NULL Message Number
11 EXPANDED_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
12 PAGE_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Page Field Name
13 PAGE_SIZE Number(3,0) SMALLINT NOT NULL Page Size
14 DISPLAY_LEVELS Number(2,0) SMALLINT NOT NULL Display Levels
15 COLLAPSED_IMAGE Character(30) VARCHAR2(30) NOT NULL Collapsed Image Name
16 EXPANDED_IMAGE Character(30) VARCHAR2(30) NOT NULL Expanded Image Name
17 END_NODE_IMAGE Character(30) VARCHAR2(30) NOT NULL End Node Image Name
18 LEAF_IMAGE Character(30) VARCHAR2(30) NOT NULL Name of image that is used for leaf , i.e. detail values in tree
19 IMAGE_WIDTH Number(2,0) SMALLINT NOT NULL Image Width
20 IMAGE_HEIGHT Number(2,0) SMALLINT NOT NULL Image Height
21 INDENT_PIXELS Number(2,0) SMALLINT NOT NULL Indent Pixels
22 TREECTL_VERSION Number(4,0) SMALLINT NOT NULL HTML Tree Version
23 TOP_NODE_NUM Number(7,0) INTEGER NOT NULL Top Node Num
24 LEFT_LEVEL_NUM Number(2,0) SMALLINT NOT NULL Left Level Num
25 DEFERPROC Number(1,0) SMALLINT NOT NULL Deferred Processing mode
26 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name