TREE_NAMETREE_NODEPOS_SOURCE_IDSOURCE_SETVALUE_DTCALC_DTCURRENCY_CDBUSINESS_UNIT_BANKBANK_SETIDBANK_CDBANK_ACCT_KEYPOS_HIST_FLAGY=History-based
Y/N Table Edit
POS_IMPCT_H_TMP(SQL Table) |
Index Back |
|---|---|
Position Impacts Header TempTemporary record for Pos Impact Header. Used when calculating recursive totals for AE. since DB2-MVS and Informix do not support self referencing Inserts. #@%^& |
| # | 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 | POS_SOURCE_ID |
Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 4 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 5 | VALUE_DT |
Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 6 | CALC_DT |
Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 7 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 8 | BUSINESS_UNIT_BANK |
Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 9 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 10 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 11 | 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 |
| 12 | 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 Y/N Table Edit |
| 13 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
| 14 | 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 |
| 15 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 16 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 17 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL | a checkbox that identifies the default position source set. |
| 18 | LOCK_VALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | A field which will Lock/Unlock a value on the CPW. |