POS_IMPC_NOD_S2 (SQL View)	Index Back
Position Impact at Node view Position Impact at Node view. This view sums up position records for each node in the tree. This view is used for source sets.

POS_IMPC_NOD_S2

(SQL View)

Position Impact at Node view

Position Impact at Node view. This view sums up position records for each node in the tree. This view is used for source sets.

SELECT P.TREE_NAME ,P.TREE_NODE ,T.SOURCE_SET ,T.SETID ,' ' ,T.SEQ_NUM ,P.CALC_DT ,P.VALUE_DT ,P.CURRENCY_CD ,P.BUSINESS_UNIT_BANK ,P.BANK_SETID ,P.BANK_CD ,P.BANK_ACCT_KEY ,SUM(P.POS_IMPCT_ORIG) ,SUM(P.POS_IMPCT_WEIGHT) ,N.PARENT_NODE_NUM ,P.POSITION_CURRENCY ,P.LOCK_VALUE_FLAG ,P.POS_HIST_FLAG ,' ' ,' ' FROM PS_POS_IMPCT_HDR P , PSTREENODE N , PS_POS_SOURCE_SET T WHERE P.TREE_NAME = N.TREE_NAME AND P.TREE_NODE = N.TREE_NODE AND N.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREENODE WHERE TREE_NAME = P.TREE_NAME) AND P.TREE_NAME=T.TREE_NAME AND P.SOURCE_SET=T.SOURCE_SET AND T.TREE_NAME=N.TREE_NAME GROUP BY P.TREE_NAME ,P.TREE_NODE ,T.SOURCE_SET ,T.SEQ_NUM ,P.CALC_DT ,P.VALUE_DT,P.CURRENCY_CD ,P.BUSINESS_UNIT_BANK ,P.BANK_SETID ,P.BANK_CD ,P.BANK_ACCT_KEY ,N.PARENT_NODE_NUM ,P.POSITION_CURRENCY ,T.SETID ,P.LOCK_VALUE_FLAG,P.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 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

5 TIME_SET Character(10) VARCHAR2(10) NOT NULL A unique key identifier that represents a time horizon definition dataset.

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

7 CALC_DT Date(10) DATE The calculation date for a given data set within the Position tools.

8 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

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_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 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number

17 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.

18 LOCK_VALUE_FLAG Character(1) VARCHAR2(1) NOT NULL A field which will Lock/Unlock a value on the CPW.

19 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

20 POS_AMOUNT_CHAR Character(30) VARCHAR2(30) NOT NULL Character field to store amount

21 POS_AMOUNT_CHAR2 Character(30) VARCHAR2(30) NOT NULL Character field to store amount

#	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	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	TIME_SET	Character(10)	VARCHAR2(10) NOT NULL	A unique key identifier that represents a time horizon definition dataset.
6	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
8	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
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_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	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
17	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
18	LOCK_VALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A field which will Lock/Unlock a value on the CPW.
19	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
20	POS_AMOUNT_CHAR	Character(30)	VARCHAR2(30) NOT NULL	Character field to store amount
21	POS_AMOUNT_CHAR2	Character(30)	VARCHAR2(30) NOT NULL	Character field to store amount