FT_FND_LABEL

#	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
5	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
6	FT_TREE_STRUCT_CD	Character(30)	VARCHAR2(30) NOT NULL	Tree Structure Code
7	FT_DATA_SOURCE_ID	Character(32)	VARCHAR2(32) NOT NULL	Data Source ID
8	FT_LABEL_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	Label ID GUID
9	FT_LABEL_SHORT_NAM	Character(50)	VARCHAR2(50) NOT NULL	Label Short Name
10	FT_ICON_NAME	Character(40)	VARCHAR2(40) NOT NULL	Icon Name
11	FT_EFF_START_DATE	Date(10)	DATE	Effective Start Date
12	FT_EFF_END_DATE	Date(10)	DATE	Effective End Date
13	FT_SET_ID_GUID	Character(36)	VARCHAR2(36) NOT NULL	Set ID GUID
14	FT_CREATED_BY	Character(64)	VARCHAR2(64) NOT NULL	Created By
15	FT_CREATION_DATE	Date(10)	DATE	Creation Date
16	FT_LAST_UPDATED_BY	Character(64)	VARCHAR2(64) NOT NULL	Last Updated By
17	FT_LAST_UPD_DATE	Date(10)	DATE	Last Updated Date
18	FT_LAST_UPD_LOGIN	Character(32)	VARCHAR2(32) NOT NULL	Last Updated Login
19	FT_ENTERPRISE_ID	Number(18,0)	DECIMAL(18) NOT NULL	Enterprise ID
20	FT_LANGUAGE	Character(4)	VARCHAR2(4) NOT NULL	Language
21	FT_PROC_MARKER	Character(36)	VARCHAR2(36) NOT NULL	Process marker field
22	FT_ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag N=No Y=Yes Default Value: N
23	FT_BYPASS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Bypass Flag Default Value: N
24	FT_ALTERNATE_REC	Character(50)	VARCHAR2(50) NOT NULL	Source Record
25	FT_ALTERNATE_KEY	Character(254)	VARCHAR2(254) NOT NULL	Alternate Key