OI_TFLT_PRC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	TREE_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
6	RECNAME_2	Character(15)	VARCHAR2(15) NOT NULL	Record 2 Name
7	RECNAME_RSEL	Character(15)	VARCHAR2(15) NOT NULL	Selector range table
8	RECNAME_TEMP	Character(18)	VARCHAR2(18) NOT NULL	Temporary Record
9	TREE_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Tree Level Number
10	TREE_LEVEL_NUM	Number(3,0)	SMALLINT NOT NULL	Parent tree level if this is a part of the PSTREEBRANCH record
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
12	FIELDNAME_TREENODE	Character(18)	VARCHAR2(18) NOT NULL	Tree Node field
13	FIELDNAME_DESCR	Character(18)	VARCHAR2(18) NOT NULL	Fieldname Journal Line Descr
14	FIELDNAME_TREELVL	Character(18)	VARCHAR2(18) NOT NULL	Tree Node field
15	FIELDNAME_DTLDESCR	Character(18)	VARCHAR2(18) NOT NULL	Name of Field
16	TREE_NODE_NUM	Number(10,0)	DECIMAL(10) NOT NULL	Internal beginning node range number
17	TREE_NAME_OTBI	Character(30)	VARCHAR2(30) NOT NULL	Tree Name
18	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
19	SEQNBR_LAST	Number(5,0)	INTEGER NOT NULL	Sequence Number
20	SQLROWS	Number(5,0)	INTEGER NOT NULL	SQL Rows
21	SQLROWS_2	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
22	SQLROWS_TAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
23	SQLROWS_TSELD	Number(12,0)	DECIMAL(12) NOT NULL	SQL Rows for detail tree selector. Used in FT_TREESEL.
24	SQLROWS_DETAILS	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
25	SQLROWS_TARGET	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL Allocation AE programs (FS_ALLC)
26	SQLROWS_TARGET2	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL batch processes
27	SQLROWS_TARGET3	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL batch processes
28	SQLROWS_TSELR	Number(12,0)	DECIMAL(12) NOT NULL	SQL Rows for range tree selector. Used in FT_TREESEL.
29	SQLROWS_3	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
30	TAO_TBL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Base TAO Table Name
31	OTBI_SRC_INSTANCE	Number(15,4)	DECIMAL(14,4) NOT NULL	OTBI Process Instance
32	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
33	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
34	PROCESS_STEP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Step Flag
35	VERSION_TREE	Number(10,0)	DECIMAL(10) NOT NULL	Tree Version
36	TFLT_PRCS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Tree Flattener Process Status I=In Process L=User Lock
37	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update
38	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
39	ALL_VALUES	Character(1)	VARCHAR2(1) NOT NULL	Tree Level All Values flag N=No Y=Yes
40	UPDATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Prior Operations
41	UPDATE_LOG	Character(1)	VARCHAR2(1) NOT NULL	Update Log
42	TREE_INEFFDT	Date(10)	DATE	Effective date of the Tree
43	TFLT_TYPE_DL	Character(1)	VARCHAR2(1) NOT NULL	Tree Type Indicator: Detail List
44	TFLT_TYPE_OI	Character(1)	VARCHAR2(1) NOT NULL	Tree Type Indicator: OTBI
45	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive