PC_TREE_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PC_SCH_PTR_OPT	Character(4)	VARCHAR2(4) NOT NULL	Options for Project Tree Integration with Third Party scheduling software APP=Append Node to Existing Tree NEW=Create New Tree UPD=Update Existing Tree
3	PC_TREE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to identify type of tree (project or wbs). PRJ=Project WBS=Work Breakdown Structure
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
5	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
6	TREE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Tree Description
7	PARENT_NODE	Character(20)	VARCHAR2(20) NOT NULL	Parent Tree Node
8	INTFC_ID	Number(8,0)	INTEGER NOT NULL	Interface ID
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
10	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
11	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
14	NODE_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Tree Definition Node Count
15	WORK_CNT	Number(10,0)	DECIMAL(10) NOT NULL	Count of Anything
16	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
17	TREE_STRCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Name (see PSTREESTRCT).
18	ALL_VALUES	Character(1)	VARCHAR2(1) NOT NULL	Tree Level All Values flag N=No Y=Yes
19	USE_LEVELS	Character(1)	VARCHAR2(1) NOT NULL	Tree Definition Level Use Type L=Loosely Enforced N=Level Not Used S=Strictly Enforced
20	DUPLICATE_LEAF	Character(1)	VARCHAR2(1) NOT NULL	Tree Definition allow duplicate leaf flag
21	TREE_CATEGORY	Character(18)	VARCHAR2(18) NOT NULL	Category name for the Tree
22	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
23	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
24	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
25	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.
26	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,
27	PC_TREE_FILEPATH	Character(30)	VARCHAR2(30) NOT NULL	A temporary file path for processes which write to files. Used in the Tree Loader (PC_TREE_LOAD) program to write the tree import data to a specified filepath. Also used in Program Budgeting as a temporary place for the Load from Excel process.
28	FILE_NAME_SHORT	Character(30)	VARCHAR2(30) NOT NULL	File Name
29	PC_SCH_FIELD3	Character(40)	VARCHAR2(40) NOT NULL	Generic field used for Projects Third Party Schedule Integration.
30	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
31	PC_SCH_FIELD5	Character(40)	VARCHAR2(40) NOT NULL	Generic field used for Projects Third Party Schedule Integration.
32	PC_INDENT_LEVEL	Number(3,0)	SMALLINT NOT NULL	Tree Indent Level
33	PC_INDENT_ADJUST	Number(3,0)	SMALLINT NOT NULL	For Primavera integration. Used for adjusting Primavera tree indent level to Peoplesoft's levels.
34	TREE_DEFN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Tree Definition Flag
35	TREE_LEVEL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Tree Level Flag
36	TREE_NODE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Tree Node Flagg
37	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
38	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.