POS_TREE_TBL (SQL Table)	Index Back
Position Tree User Table Position Tree table. For data that applies to the total tree

POS_TREE_TBL

(SQL Table)

Position Tree User Table

Position Tree table. For data that applies to the total tree

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
Prompt Table: POS_TREE_VW

3 MUST_BE_IN_LIMIT Character(2) VARCHAR2(2) NOT NULL Allows the user to indicate that a given deal transaction must be included in the detail
Y/N Table Edit

4 RT_RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Market Rate Index
Prompt Table: RT_INDEX_FX_VW

5 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_FX_VW

6 VERSION_NUMBER Number(5,0) INTEGER NOT NULL Represents the Tools version number of a given position tree object.
Default Value: 1

7 CARRY_TOT_FWD_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to designate that the total net position amount in a position tree definition
Y/N Table Edit

8 ADD_AMT_TREE_NODE Character(20) VARCHAR2(20) NOT NULL Allows the user to select a particular tree node (postion or cash worksheet category) and have i
Prompt Table: POS_TREENOD_VW1

9 ALLOW_MANUAL_CB Character(1) VARCHAR2(1) NOT NULL Allow Manual Updates
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: POS_TREE_VW
3	MUST_BE_IN_LIMIT	Character(2)	VARCHAR2(2) NOT NULL	Allows the user to indicate that a given deal transaction must be included in the detail Y/N Table Edit
4	RT_RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Market Rate Index Prompt Table: RT_INDEX_FX_VW
5	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. Prompt Table: RT_TYPE_FX_VW
6	VERSION_NUMBER	Number(5,0)	INTEGER NOT NULL	Represents the Tools version number of a given position tree object. Default Value: 1
7	CARRY_TOT_FWD_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to designate that the total net position amount in a position tree definition Y/N Table Edit
8	ADD_AMT_TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Allows the user to select a particular tree node (postion or cash worksheet category) and have i Prompt Table: POS_TREENOD_VW1
9	ALLOW_MANUAL_CB	Character(1)	VARCHAR2(1) NOT NULL	Allow Manual Updates Y/N Table Edit Default Value: N