TR_NOD_SRC_TMP (SQL Table)	Index Back
Views used by the Tree

TR_NOD_SRC_TMP

(SQL Table)

Views used by the Tree

# 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 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 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: Y

6 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

7 SELECT_CRITERIA Character(1) VARCHAR2(1) NOT NULL Selection Criteria

#	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	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	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: Y
6	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
7	SELECT_CRITERIA	Character(1)	VARCHAR2(1) NOT NULL	Selection Criteria