POS_WHERE_HDR

#	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	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
4	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset Prompt Table: POS_SOURCE_TBL
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name Default Value: POS_HDR_TBL.TREE_NODE
6	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 Default Value: 01
7	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
8	APPLY_2_ALL_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to designate that given SQL data criteria is to apply to all nodes on a given Po Y/N Table Edit Default Value: N
9	USE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to associate a predefined position source with a selected position tree node (cash worksh Y/N Table Edit Default Value: N
10	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
11	SQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.