SETIDTREE_NAMETREE_NODERANGE_FROMRANGE_TOEFFDTDefault Value: %date
PV_ITMCAT_TR_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID ,A.TREE_NAME ,A.TREE_NODE ,' ' ,' ' ,A.EFFDT ,' ' FROM PSTREENODE A ,PSTREEDEFN C WHERE C.TREE_STRCT_ID = 'ITEMS' AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE WHERE SETID = A.SETID AND EFFDT <= %CurrentDateIn AND TREE_NAME = A.TREE_NAME) AND A.TREE_NAME IN ( SELECT DISTINCT TREE_NAME FROM PSTREEDEFN WHERE TREE_STRCT_ID = 'ITEMS') AND EXISTS ( SELECT 'X' FROM PSTREEDEFN WHERE SETID = A.SETID AND TREE_NAME = A.TREE_NAME AND EFFDT = A.EFFDT AND EFF_STATUS = 'A' ) |
| # | 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_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 4 | RANGE_FROM |
Character(30) | VARCHAR2(30) NOT NULL | Lower boundary for detail value that contains a range of values |
| 5 | RANGE_TO |
Character(30) | VARCHAR2(30) NOT NULL | Upper boundary for detail value that contains a range of values |
| 6 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | DYNAMIC_RANGE | Character(1) | VARCHAR2(1) NOT NULL | Tree Leaf Dynamic detail range flag |