SETIDTREE_NAMEPOS_SQL_VW(SQL View) |
Index Back |
|---|---|
Position SQL ViewGet All Nodes that need SQL Generating |
| SELECT H.SETID, H.TREE_NAME, H.TREE_NODE, H.TREE_NODE_NUM, H.PARENT_NODE_NUM, B.POS_SOURCE_ID, B.SQL_STMT FROM PSTREENODE H, PS_POS_WHERE_HDR B WHERE H.SETID = B.SETID AND H.TREE_NAME = B.TREE_NAME AND H.TREE_NODE = B.TREE_NODE AND H.EFFDT = (SELECT MAX(EFFDT ) FROM PSTREENODE WHERE SETID = H.SETID AND TREE_NAME = H.TREE_NAME AND TREE_NODE = H.TREE_NODE ) |
| # | 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 | POS_SOURCE_ID | Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 7 | SQL_STMT | Long Character(8192) | CLOB | An internal work field that contains SQL text that is to be utilized in treasury application processing. |