POS_IMP_HDR_VW

(SQL View)
 Index Back

Position Impacts Header Record


SELECT A.TREE_NAME ,A.TREE_NODE ,A.POS_SOURCE_ID ,A.SOURCE_SET ,A.VALUE_DT ,A.CALC_DT ,A.CURRENCY_CD ,A.BUSINESS_UNIT_BANK ,A.BANK_SETID ,A.BANK_CD ,A.BANK_ACCT_KEY ,A.POS_HIST_FLAG ,A.DESCR50 ,A.CALC_TM ,A.POS_IMPCT_ORIG ,A.POS_IMPCT_WEIGHT ,A.POSITION_CURRENCY ,A.POS_DEF_SRC_SET ,A.LOCK_VALUE_FLAG FROM PS_POS_IMPCT_HDR A

# 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