POS_IMPCT_HDR(SQL Table) |
Index Back |
---|---|
Position Impacts Header Record |
# | 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 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
14 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
15 | 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 |
16 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
17 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
18 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL |
a checkbox that identifies the default position source set.
Default Value: N |
19 | LOCK_VALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A field which will Lock/Unlock a value on the CPW.
Default Value: N |