ITM_TREE_WRK(SQL Table) |
Index Back |
---|---|
Category working scroll |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | SetID | |
2 | Character(18) | VARCHAR2(18) NOT NULL | Tree Name | |
3 | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number | |
4 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
5 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
6 | CATGRY_ITM_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Category Items |
7 | DRILL_DOWN_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Drill Down Button |
8 | DRILL_UP_BUTTON | Character(1) | VARCHAR2(1) NOT NULL | Drill Up Button |
9 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |