SETIDTREE_NAMEPOS_SQL_VW3(SQL View) |
Index Back |
|---|---|
Position SQL View - 32/23/98 AK - Get all pos sources which are being used but has no selection criteria defined at that node. |
| select B.SETID, B.TREE_NAME, B.TREE_NODE, H.TREE_NODE_NUM, H.PARENT_NODE_NUM, C.SOURCE_SET, B.POS_SOURCE_ID, ' ', C.POS_DEAL_SRC_SET, B.SQL_STMT from PSTREENODE H, PS_POS_WHERE_HDR B, PS_POS_SOURCE_SET C WHERE H.SETID = B.SETID AND H.TREE_NAME = B.TREE_NAME AND H.TREE_NODE = B.TREE_NODE AND EFFDT = (Select Max(J.EFFDT ) from PSTREENODE J Where J.SETID = H.SETID AND J.TREE_NAME = H.TREE_NAME AND J.TREE_NODE = H.TREE_NODE ) AND B.USE_SOURCE = 'Y' AND C.SETID=B.SETID AND C.TREE_NAME=B.TREE_NAME AND C.SOURCE_SET=B.SOURCE_SET |
| # | 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 | TREE_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 5 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 6 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 7 | POS_SOURCE_ID | Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 8 | INCLUDE_DEAL_CHK | Character(1) | VARCHAR2(1) NOT NULL | Allows the user to instruct the position monitor tool to utilize a particular tree node when |
| 9 | POS_DEAL_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL | A checkbox that determines if the current source set is to be used for deal condtions or selection criteria. |
| 10 | SQL_STMT | Long Character(8192) | CLOB | An internal work field that contains SQL text that is to be utilized in treasury application processing. |