POS_IMPCT_VIEW (SQL View)	Index Back
Position Impact-Limit View View of Position Impacts Header Record and Limit. It is used to check adhoc limit.

POS_IMPCT_VIEW

(SQL View)

Position Impact-Limit View

View of Position Impacts Header Record and Limit. It is used to check adhoc limit.

SELECT H.TREE_NAME ,H.TREE_NODE ,H.VALUE_DT ,SUM(H.POS_IMPCT_ORIG) ,H.CALC_DT ,L.CURR_LIMIT ,L.LIMIT_MIN ,L.LIMIT_MAX ,L.INTERNAL_EXTERNAL FROM PS_POS_IMPCT_HDR H , PS_POS_LMT_TBL L WHERE VALUE_DT = %CurrentDateIn AND CALC_DT = %CurrentDateIn AND H.TREE_NAME = L.TREE_NAME AND H.TREE_NODE = L.TREE_NODE GROUP BY H.TREE_NAME, H.TREE_NODE, H.VALUE_DT, H.CALC_DT, L.CURR_LIMIT,L.LIMIT_MAX, L.LIMIT_MIN,L.INTERNAL_EXTERNAL

# 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 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.

4 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

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

6 CURR_LIMIT Character(3) VARCHAR2(3) NOT NULL The currency in which a given position limit is defined in the Position tools.

7 LIMIT_MIN Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the minimum amount of exposure established by the treasury for a given tree node (position or cash wo

8 LIMIT_MAX Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents the maximum amount of exposure established by the treasury for a given tree node (position or cash wo

9 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given defined bank account is utilized for internal or ext
E=External
I=Internal

#	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	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
4	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
5	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
6	CURR_LIMIT	Character(3)	VARCHAR2(3) NOT NULL	The currency in which a given position limit is defined in the Position tools.
7	LIMIT_MIN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the minimum amount of exposure established by the treasury for a given tree node (position or cash wo
8	LIMIT_MAX	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents the maximum amount of exposure established by the treasury for a given tree node (position or cash wo
9	INTERNAL_EXTERNAL	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given defined bank account is utilized for internal or ext E=External I=Internal