RIT_TREECTL_HDR

(SQL Table)
Index Back

Tree Specification Search Rec

Tree Specification Record. This record contains all the information about the tree definition

# 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
31 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
32 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
33 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
34 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
35 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.
36 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time