GM_TREE_R_EF_VW(SQL View) |
Index Back |
|---|---|
Detail Tree Effdt View |
| select A.SETID ,A.TREE_NAME ,A.TREE_LEVEL_NUM ,A.TREE_LEVEL ,A.TREE_BRANCH ,A.TREE_NODE ,A.DESCR ,A.RANGE_FROM ,A.RANGE_TO from PS_GM_TREE_F_TO_VW A where A.effdt = (select max(b.effdt) from PS_GM_TREE_F_TO_VW b where b.setid = A.setid and b.tree_name = a.tree_name and b.tree_branch = a.tree_branch and b.tree_node = a.tree_node and b.tree_level_num = a.tree_level_num and a.range_from = b.range_from and a.range_to = b.range_to and b.effdt <= %currentdatein) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 3 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 4 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL | Tree Level Number |
| 5 | TREE_BRANCH | Character(20) | VARCHAR2(20) NOT NULL | Tree Branch |
| 6 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | RANGE_FROM | Character(30) | VARCHAR2(30) NOT NULL | Lower boundary for detail value that contains a range of values |
| 9 | RANGE_TO | Character(30) | VARCHAR2(30) NOT NULL | Upper boundary for detail value that contains a range of values |