SETIDITEM_TYPE_GROUPEFFDTA=Active
I=Inactive
GROUP_ITEMS_VW(SQL View) |
Index Back |
|---|---|
Item Group Items View |
| SELECT A.SETID ,A.ITEM_TYPE_GROUP, A.EFFDT, A.EFF_STATUS, A.TREE_NAME, B.TREE_NODE, E.RANGE_FROM, E.RANGE_TO FROM PS_ITEM_GROUP_TBL A, PS_ITEM_GROUP_DTL B, PSTREEDEFN C, PSTREENODE D, PSTREELEAF E WHERE B.SETID = A.SETID AND B.ITEM_TYPE_GROUP = A.ITEM_TYPE_GROUP AND B.EFFDT = A.EFFDT AND C.SETID = A.TREE_NAME_SETID AND C.TREE_NAME = A.TREE_NAME AND C.EFFDT = (SELECT MAX(CC.EFFDT) FROM PSTREEDEFN CC WHERE CC.SETID = C.SETID AND CC.TREE_NAME = C.TREE_NAME AND CC.EFFDT <= %CURRENTDATEIN) AND C.EFF_STATUS = 'A' AND C.VALID_TREE = 'Y' AND D.SETID = C.SETID AND D.TREE_NAME = C.TREE_NAME AND D.TREE_NODE = B.TREE_NODE AND D.EFFDT = C.EFFDT AND E.SETID = C.SETID AND E.TREE_NAME = C.TREE_NAME AND E.EFFDT = C.EFFDT AND E.TREE_NODE_NUM >= D.TREE_NODE_NUM AND E.TREE_NODE_NUM <= D.TREE_NODE_NUM_END |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | ITEM_TYPE_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Item Type Group |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 6 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 7 | RANGE_FROM | Character(30) | VARCHAR2(30) NOT NULL | Lower boundary for detail value that contains a range of values |
| 8 | RANGE_TO | Character(30) | VARCHAR2(30) NOT NULL | Upper boundary for detail value that contains a range of values |