POS_SQL_VW2 (SQL View)	Index Back
Position SQL View - 2 Return all Nodes for the Position Tree's 2/13/98 AK - Modified view to include Deal Condition SQL with having to turn on the Use Source flag

POS_SQL_VW2

(SQL View)

Position SQL View - 2

Return all Nodes for the Position Tree's 2/13/98 AK - Modified view to include Deal Condition SQL with having to turn on the Use Source flag

SELECT A.SETID , A.TREE_NAME , A.TREE_NODE , H.TREE_NODE_NUM , H.PARENT_NODE_NUM , B.SOURCE_SET , A.POS_SOURCE_ID , A.INCLUDE_DEAL_CHK , B.POS_DEAL_SRC_SET , A.WHERE_TYPE , C.POS_IS_DEAL_SRC , A.SQL_STMT FROM PSTREENODE H , PS_POS_WHERE_HDR A , PS_POS_SOURCE_SET B , PS_POS_SOURCE_TBL C WHERE H.SETID = A.SETID AND H.TREE_NAME = A.TREE_NAME AND H.TREE_NODE = A.TREE_NODE AND A.SETID=B.SETID AND A.TREE_NAME=B.TREE_NAME AND A.SOURCE_SET=B.SOURCE_SET AND A.SETID=C.SETID AND A.POS_SOURCE_ID=C.POS_SOURCE_ID AND EFFDT = ( SELECT MAX(EFFDT ) FROM PSTREENODE WHERE SETID = H.SETID AND TREE_NAME = H.TREE_NAME AND TREE_NODE = H.TREE_NODE ) AND A.USE_SOURCE = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

3 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

4 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number

5 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number

6 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

7 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

8 INCLUDE_DEAL_CHK Character(1) VARCHAR2(1) NOT NULL Allows the user to instruct the position monitor tool to utilize a particular tree node when

9 POS_DEAL_SRC_SET Character(1) VARCHAR2(1) NOT NULL A checkbox that determines if the current source set is to be used for deal condtions or selection criteria.

10 WHERE_TYPE Character(2) VARCHAR2(2) NOT NULL An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p
01=Bin Impact
02=Deal Conditions

11 POS_IS_DEAL_SRC Character(1) VARCHAR2(1) NOT NULL Filed used to determine if a Position source is over a deal table

12 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
4	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
5	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
6	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
7	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
8	INCLUDE_DEAL_CHK	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to instruct the position monitor tool to utilize a particular tree node when
9	POS_DEAL_SRC_SET	Character(1)	VARCHAR2(1) NOT NULL	A checkbox that determines if the current source set is to be used for deal condtions or selection criteria.
10	WHERE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p 01=Bin Impact 02=Deal Conditions
11	POS_IS_DEAL_SRC	Character(1)	VARCHAR2(1) NOT NULL	Filed used to determine if a Position source is over a deal table
12	SQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.