TREE_NAMETREE_NODESOURCE_SETSETIDTIME_SETSEQ_NUMCALC_DTCURRENCY_CDBUSINESS_UNIT_BANKBANK_SETIDBANK_CDBANK_ACCT_KEYY=History-based
POS_IMPC_NOD_V2(SQL View) |
Index Back |
|---|---|
Position Impact at Node viewPosition Impact at Node view. This view sums up position records for each node in the tree. |
| SELECT P.TREE_NAME ,P.TREE_NODE ,P.SOURCE_SET ,T.SETID ,T.TIME_SET ,T.SEQ_NUM ,P.CALC_DT ,P.CURRENCY_CD ,P.BUSINESS_UNIT_BANK ,P.BANK_SETID ,P.BANK_CD ,P.BANK_ACCT_KEY ,SUM(P.POS_IMPCT_ORIG) ,SUM(P.POS_IMPCT_WEIGHT) ,N.PARENT_NODE_NUM ,P.POSITION_CURRENCY ,P.LOCK_VALUE_FLAG ,P.POS_HIST_FLAG ,' ' ,' ' FROM PS_POS_PERIOD_TBL T , PS_POS_IMPCT_HDR P , PSTREENODE N WHERE P.TREE_NAME = N.TREE_NAME AND P.TREE_NODE = N.TREE_NODE AND N.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE WHERE TREE_NAME = P.TREE_NAME) AND P.VALUE_DT <= T.PERIOD_END_DT AND P.VALUE_DT >= T.PERIOD_START_DT AND P.POS_DEF_SRC_SET='Y' GROUP BY P.TREE_NAME ,P.TREE_NODE ,P.SOURCE_SET ,T.SETID ,T.TIME_SET ,T.SEQ_NUM ,P.CALC_DT ,P.CURRENCY_CD ,P.BUSINESS_UNIT_BANK ,P.BANK_SETID ,P.BANK_CD ,P.BANK_ACCT_KEY ,N.PARENT_NODE_NUM ,P.POSITION_CURRENCY ,P.LOCK_VALUE_FLAG, P.POS_HIST_FLAG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 2 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 3 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 4 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | TIME_SET |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that represents a time horizon definition dataset. |
| 6 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 7 | CALC_DT |
Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 8 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | BUSINESS_UNIT_BANK |
Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 10 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 11 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 12 | BANK_ACCT_KEY |
Character(4) | VARCHAR2(4) NOT NULL | A user defined unique identifier that facilitates the identification of a given account with a given bank |
| 13 | POS_IMPCT_ORIG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the calculated monetary value for a specific position tree node; the result |
| 14 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 15 | PARENT_NODE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Parent Node Number |
| 16 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 17 | LOCK_VALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | A field which will Lock/Unlock a value on the CPW. |
| 18 | POS_HIST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
An internal field utilized in order to determine whether the subject cash position worksheet is based up
Y=History-based |
| 19 | POS_AMOUNT_CHAR | Character(30) | VARCHAR2(30) NOT NULL | Character field to store amount |
| 20 | POS_AMOUNT_CHAR2 | Character(30) | VARCHAR2(30) NOT NULL | Character field to store amount |