SETIDTREE_NAMETREE_BRANCHTREE_NODE_NUMTREE_NODEDefault Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table: CURRENCY_CD_TBL
01=Recursive
02=Non-recursive
POS_IMPCT_NODE2(SQL View) |
Index Back |
|---|---|
Position Impact Tree NodesView of position impact tree nodes. Used in the position monitor. |
| SELECT A.SETID ,A.TREE_NAME ,A.TREE_BRANCH ,A.TREE_NODE_NUM ,A.TREE_NODE ,A.TREE_NODE_NUM_END ,A.TREE_LEVEL_NUM ,A.TREE_NODE_TYPE ,A.PARENT_NODE_NUM ,A.OLD_TREE_NODE_NUM ,A.EFFDT ,CURR_POSITION ,B.NODE_MODE_CODE ,%CurrentDateIn ,%CurrentTimeIn ,A.TREE_NODE ,0 ,0 FROM PSTREENODE A , PS_POS_HDR_TBL B WHERE A.SETID = B.SETID AND A.TREE_NAME = B.TREE_NAME AND A.TREE_NODE = B.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_BRANCH |
Character(20) | VARCHAR2(20) NOT NULL | Tree Branch |
| 4 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 5 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 6 | TREE_NODE_NUM_END | Number(10,0) | DECIMAL(10) NOT NULL | Internal ending node range number |
| 7 | TREE_LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Parent tree level if this is a part of the PSTREEBRANCH record |
| 8 | TREE_NODE_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate whether node represents a Group (G) or a Record (R) in a Query Access Group Tree, |
| 9 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 10 | OLD_TREE_NODE_NUM | Character(1) | VARCHAR2(1) NOT NULL | Old Tree Node |
| 11 | EFFDT | Date(10) | DATE | Effective Date |
| 12 | CURR_POSITION | Character(3) | VARCHAR2(3) NOT NULL |
The currency in which a given exposure or position is defined in the Position tools.
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 13 | NODE_MODE_CODE | Character(2) | VARCHAR2(2) NOT NULL |
An internal work field that holds a specific code which determines if a given position tree node is su
01=Recursive 02=Non-recursive |
| 14 | DATEVAL1 | Date(10) | DATE | DateVal1 |
| 15 | TIMEVAL1 | Time(15) | TIMESTAMP | Time Value |
| 16 | TREE_NODE_DETAIL | Character(254) | VARCHAR2(254) NOT NULL | Tree Node Detail |
| 17 | POS_NODE_LEVEL | Number(10,0) | DECIMAL(10) NOT NULL | Node Level |
| 18 | POS_PAR_NODE_LEVEL | Number(10,0) | DECIMAL(10) NOT NULL | Node Level |