FT_DTREENODE_C

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
6	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
7	TREE_BRANCH	Character(20)	VARCHAR2(20) NOT NULL	Tree Branch
8	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
9	PARENT_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Parent Node Number
10	PARENT_NODE_NAME	Character(20)	VARCHAR2(20) NOT NULL	Name of parent node
11	FT_TREE_STRUCT_CD	Character(30)	VARCHAR2(30) NOT NULL	Tree Structure Code
12	FT_TREE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Tree Code
13	FT_TREE_VER_GUID	Character(36)	VARCHAR2(36) NOT NULL	Tree Version GUID
14	FT_TREE_NODE_GUID	Character(36)	VARCHAR2(36) NOT NULL	Tree Node ID GUID
15	FT_PARENTNODE_GUID	Character(36)	VARCHAR2(36) NOT NULL	Parent Tree Node ID GUID
16	FT_DATA_SOURCE_ID	Character(32)	VARCHAR2(32) NOT NULL	Data Source ID
17	FT_PK1_START_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK1 Start Value
18	FT_PK2_START_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK2 Start Value
19	FT_PK3_START_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK3 Start Value
20	FT_PK4_START_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK4 Start Value
21	FT_PK5_START_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK5 Start Value
22	FT_PK1_END_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK1 End Value
23	FT_PK2_END_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK2 End Value
24	FT_PK3_END_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK3 End Value
25	FT_PK4_END_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK4 End Value
26	FT_PK5_END_VALUE	Character(100)	VARCHAR2(100) NOT NULL	PK5 End Value
27	FT_REF_TREE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Reference Tree Code
28	FT_REF_TREE_VER_ID	Character(32)	VARCHAR2(32) NOT NULL	Reference Tree Version ID
29	FT_TREE_LABEL_ID	Character(32)	VARCHAR2(32) NOT NULL	Tree Label ID
30	FT_PARENT_SRC_ID	Character(32)	VARCHAR2(32) NOT NULL	Parent Data Source ID GUID
31	FT_PARENT_PK1_VAL	Character(100)	VARCHAR2(100) NOT NULL	Parent PK1 Value
32	FT_PARENT_PK2_VAL	Character(100)	VARCHAR2(100) NOT NULL	Parent PK2 Value
33	FT_PARENT_PK3_VAL	Character(100)	VARCHAR2(100) NOT NULL	Parent PK3 Value
34	FT_PARENT_PK4_VAL	Character(100)	VARCHAR2(100) NOT NULL	Parent PK4 Value
35	FT_PARENT_PK5_VAL	Character(100)	VARCHAR2(100) NOT NULL	Parent PK5 Value
36	FT_PARENT_LBL_ID	Character(32)	VARCHAR2(32) NOT NULL	Parent Tree Label ID
37	FT_SORT_ORDER	Number(18,0)	DECIMAL(18) NOT NULL	Sort Order
38	FT_DEPTH	Number(18,0)	DECIMAL(18) NOT NULL	Depth
39	FT_CHILD_COUNT	Number(18,0)	DECIMAL(18) NOT NULL	Child Count
40	FT_CREATED_BY	Character(64)	VARCHAR2(64) NOT NULL	Created By
41	FT_CREATION_DATE	Date(10)	DATE	Creation Date
42	FT_LAST_UPDATED_BY	Character(64)	VARCHAR2(64) NOT NULL	Last Updated By
43	FT_LAST_UPD_DATE	Date(10)	DATE	Last Updated Date
44	FT_LAST_UPD_LOGIN	Character(32)	VARCHAR2(32) NOT NULL	Last Updated Login
45	FT_LANGUAGE	Character(4)	VARCHAR2(4) NOT NULL	Language
46	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
47	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
48	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
49	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
50	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key