FT_TSEL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
4	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
5	AS_OF_DATE	Date(10)	DATE	As of Date
6	AS_OF_DATE_FROM	Date(10)	DATE	As of Date From
7	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
8	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	RECNAME_SEL_TBL	Character(15)	VARCHAR2(15) NOT NULL	Selector table name
11	RECNAME_RSEL	Character(15)	VARCHAR2(15) NOT NULL	Selector range table
12	CORRELATION_ID	Character(2)	VARCHAR2(2) NOT NULL	Correlation ID
13	JOIN_SW	Character(1)	VARCHAR2(1) NOT NULL	Successful/Outer Join Switch
14	INCLUDE_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Include Inactive ChartFields
15	SETID_TREE	Character(5)	VARCHAR2(5) NOT NULL	SetID
16	FIELDNAME_TREENODE	Character(18)	VARCHAR2(18) NOT NULL	Tree Node field
17	FROM_CLAUSE_LONG	Long Character(1000)	VARCHAR2(1000)	From clause to dynamic SQL (long char)
18	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
19	TSEL_CORR_ID	Character(2)	VARCHAR2(2) NOT NULL	Tree selector correlation id
20	TNODE_CORR_ID	Character(3)	VARCHAR2(3) NOT NULL	Correlation id of the setup table that stores the tree nodes
21	SQLROWS_TSELD	Number(12,0)	DECIMAL(12) NOT NULL	SQL Rows for detail tree selector. Used in FT_TREESEL.
22	SQLROWS_TSELR	Number(12,0)	DECIMAL(12) NOT NULL	SQL Rows for range tree selector. Used in FT_TREESEL.
23	DELETE_LIMIT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL AE batch processes to perform deletes rather than truncate.
24	RETURN_CD	Character(1)	VARCHAR2(1) NOT NULL	Return Code 0=Return OK 1=Return error
25	USE_GTT	Character(1)	VARCHAR2(1) NOT NULL	Use Global Temp Table Flag Default Value: N
26	USE_TSEL_FTREE	Character(1)	VARCHAR2(1) NOT NULL	Use Tree Selector to Flatten Tree
27	USE_FLT_TREE	Character(1)	VARCHAR2(1) NOT NULL	Use Flatten Tree Switch
28	RECNAME_TFLT	Character(15)	VARCHAR2(15) NOT NULL	Detail Flatten Tree
29	FIELDNAME_CF	Character(18)	VARCHAR2(18) NOT NULL	ChartField Name
30	FIELDNAME_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Field name
31	CFV_SET	Character(20)	VARCHAR2(20) NOT NULL	ChartField Value Set
32	DELETE_TEMP	Character(1)	VARCHAR2(1) NOT NULL	Delete Temp. Tables
33	UPDATE_STATS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Statistics Flag Y/N Table Edit Default Value: Y
34	USE_EDR	Character(1)	VARCHAR2(1) NOT NULL	Use EDR Switch