POS_CRNTCALC_VW

(SQL View)
 Index Back

Position Impacts Header Record


SELECT TREE_NAME ,TREE_NODE ,POS_SOURCE_ID ,SOURCE_SET ,VALUE_DT ,CALC_DT ,CURRENCY_CD ,BUSINESS_UNIT_BANK ,BANK_SETID ,BANK_CD ,BANK_ACCT_KEY ,POS_HIST_FLAG ,DESCR50 ,CALC_TM ,POS_IMPCT_ORIG ,POS_IMPCT_WEIGHT ,POSITION_CURRENCY ,POS_DEF_SRC_SET ,LOCK_VALUE_FLAG FROM PS_POS_IMPCT_HDR A WHERE A.CALC_DT = ( SELECT MAX(B.CALC_DT) FROM PS_POS_IMPCT_HDR B WHERE B.TREE_NAME = A.TREE_NAME AND B.TREE_NODE =A.TREE_NODE AND B.POS_SOURCE_ID =A.POS_SOURCE_ID AND B.SOURCE_SET =A.SOURCE_SET AND B.VALUE_DT = A.VALUE_DT AND B.CURRENCY_CD =A.CURRENCY_CD AND B.BUSINESS_UNIT_BANK =A.BUSINESS_UNIT_BANK AND B.BANK_SETID = A.BANK_SETID AND B.BANK_CD =A.BANK_CD AND B.BANK_ACCT_KEY =A.BANK_ACCT_KEY AND B.POS_HIST_FLAG =A.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 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