FT_TSEL_GEN_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID_TREE	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	RECNAME_SEL_TBL	Character(15)	VARCHAR2(15) NOT NULL	Selector table name
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	SQL_TEXT30	Character(30)	VARCHAR2(30) NOT NULL	SQL Text
6	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
7	FIELDNAME_TREENODE	Character(18)	VARCHAR2(18) NOT NULL	Tree Node field
8	FIELDNAME_FROM	Character(18)	VARCHAR2(18) NOT NULL	This fieldname from field is used to by the power pricer reports so that it could be used to filter the reporting criteria.
9	FIELDNAME_TO	Character(18)	VARCHAR2(18) NOT NULL	Destination Field
10	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
11	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
12	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
13	ROWCOUNT2	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
14	VERSION_TREE	Number(10,0)	DECIMAL(10) NOT NULL	Tree Version
15	UPDATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Prior Operations
16	FLT_TREE_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Use Flatten Tree Switch
17	USE_FLT_TREE	Character(1)	VARCHAR2(1) NOT NULL	Use Flatten Tree Switch
18	EDR_CF_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Maintain Chartfield Effective Dated Range data
19	EDR_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Effective Date Range Table
20	TFLT_TYPE_DL	Character(1)	VARCHAR2(1) NOT NULL	Tree Type Indicator: Detail List