PSARCH_IDPSARCH_BATCHNUMTREE_NAMETREE_NODEPOS_SOURCE_IDSOURCE_SETVALUE_DTCALC_DTCURRENCY_CDBUSINESS_UNIT_BANKBANK_SETIDBANK_CDBANK_ACCT_KEYPOS_HIST_FLAGY=History-based
Y/N Table Edit
Default Value: N
Default Value: N
POS_IMPCT_HIST(SQL Table) |
Index Back |
|---|---|
Position Impacts Header RecordHistory Table to store archived POS_IMPCT_HDR records |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | TREE_NODE |
Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 5 | POS_SOURCE_ID |
Character(18) | VARCHAR2(18) NOT NULL | "A unique key identifier that represents a position source dataset |
| 6 | SOURCE_SET |
Character(20) | VARCHAR2(20) NOT NULL | A field name describing a group od position sources. |
| 7 | VALUE_DT |
Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 8 | CALC_DT |
Date(10) | DATE | The calculation date for a given data set within the Position tools. |
| 9 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | BUSINESS_UNIT_BANK |
Character(5) | VARCHAR2(5) NOT NULL | The general ledger business unit associated with a given bank/counterparty. |
| 11 | BANK_SETID |
Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 12 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 13 | 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 |
| 14 | 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 |
| 15 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 16 | CALC_TM | Time(15) | TIMESTAMP | The calculation time for a given data set within the Position tools. |
| 17 | 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 |
| 18 | POS_IMPCT_WEIGHT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Pos Impact Weight Amt Value |
| 19 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | The transaction currency of a given position or exposure. |
| 20 | POS_DEF_SRC_SET | Character(1) | VARCHAR2(1) NOT NULL |
a checkbox that identifies the default position source set.
Default Value: N |
| 21 | LOCK_VALUE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A field which will Lock/Unlock a value on the CPW.
Default Value: N |