PC_TREE_DEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PC_TREE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to identify type of tree (project or wbs). PRJ=Project WBS=Work Breakdown Structure
2	SETCNTRL_IND	Character(1)	VARCHAR2(1) NOT NULL	Tree Structure User Key Field Type Indicator B=Business Unit N=None S=SetId Indirection U=User Defined
3	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
4	ALL_VALUES	Character(1)	VARCHAR2(1) NOT NULL	Tree Level All Values flag N=No Y=Yes
5	USE_LEVELS	Character(1)	VARCHAR2(1) NOT NULL	Tree Definition Level Use Type L=Loosely Enforced N=Level Not Used S=Strictly Enforced
6	DUPLICATE_LEAF	Character(1)	VARCHAR2(1) NOT NULL	Tree Definition allow duplicate leaf flag
7	TREE_CATEGORY	Character(18)	VARCHAR2(18) NOT NULL	Category name for the Tree
8	TREE_ACC_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Tree Access Method for nVision: S=Sub-select, J=Join to Selector, L=Use Literal Values (Suppress Joins) D=Use Application Defaults J=Join to Tree Selector L=Use Literal Values S=Sub-SELECT Tree Selector
9	TREE_ACC_SELECTOR	Character(1)	VARCHAR2(1) NOT NULL	Tree Access Selector for nVision: D=Dynamic Selectors, S=Static Selectors D=Dynamic Selectors S=Static Selector
10	TREE_ACC_SEL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Tree Defintion Tree Access Selector Option for nVision B=Range of Values (BETWEEN) R=Range of Values (>=...<=) S=Single Values
11	PC_TREE_LVL_PRE	Character(10)	VARCHAR2(10) NOT NULL	When creating a tree definition, this identifies the prefix for all levels of the tree.
12	TREE_NODE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate whether node represents a Group (G) or a Record (R) in a Query Access Group Tree,
13	FILE_NAME_SHORT	Character(30)	VARCHAR2(30) NOT NULL	File Name