TR_WHERE_TB_TMP (SQL Table)	Index Back
Position Bin 'Where' TableTREE

TR_WHERE_TB_TMP

(SQL Table)

Position Bin 'Where' TableTREE

# 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

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

6 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number

7 CURR_POSITION Character(3) VARCHAR2(3) NOT NULL The currency in which a given exposure or position is defined in the Position tools.

8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 999

9 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

10 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym
Prompt Table: POS_SOURCE_VW

11 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du
Prompt Table: %EDITTABLE

12 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a

13 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b

14 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days

15 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With

16 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=(
02=((
03=(((
04=((((

17 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=)
02=))
03=)))
04=))))

18 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR

19 NODE_SQL Character(254) VARCHAR2(254) NOT NULL Represents the field in which a user can enter specific SQL criteria in order to select and display position data.

#	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
5	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
6	SEQ_NUMBER	Number(3,0)	SMALLINT NOT NULL	Expense Sequence Number
7	CURR_POSITION	Character(3)	VARCHAR2(3) NOT NULL	The currency in which a given exposure or position is defined in the Position tools.
8	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 999
9	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
10	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym Prompt Table: POS_SOURCE_VW
11	FIELD_VALUE_STR	Character(30)	VARCHAR2(30) NOT NULL	An accounting template field designated to support the substitution of desired character field values du Prompt Table: %EDITTABLE
12	FIELD_VALUE_NBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An accounting template field designated to support the substitution of desired monetary amounts during a
13	FIELD_VALUE_DATE	Date(10)	DATE	An accounting template field designated to support the substitution of desired dates during accounting b
14	RELATIVE_DATE	Character(1)	VARCHAR2(1) NOT NULL	"Represents the number of days
15	COMP_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL field comparison syntax when the user is creating node specific data selection criteria <=< <==<= <>=<> === >=> >==>= B=Begins With C=Contains E=Ends With NB=Doesn't Begins With NC=Doesn't Contains NE=Doesn't Ends With
16	OPEN_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data 01=( 02=(( 03=((( 04=((((
17	CLOSE_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat 01=) 02=)) 03=))) 04=))))
18	AND_OR_TXT	Character(3)	VARCHAR2(3) NOT NULL	Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi AND=AND OR=OR
19	NODE_SQL	Character(254)	VARCHAR2(254) NOT NULL	Represents the field in which a user can enter specific SQL criteria in order to select and display position data.