RIT_TREECTL_HDR(SQL Table) |
Index Back |
---|---|
Tree Specification Search RecTree 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 |