OI_TFLT_LOG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
6	TREE_INEFFDT	Date(10)	DATE	Effective date of the Tree
7	ALL_VALUES	Character(1)	VARCHAR2(1) NOT NULL	Tree Level All Values flag N=No Y=Yes
8	OTBI_SRC_INSTANCE	Number(15,4)	DECIMAL(14,4) NOT NULL	OTBI Process Instance
9	CREATED_DTTM	DateTime(26)	TIMESTAMP	Created Date and time
10	ROWCOUNT1	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
11	ROWCOUNT2	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
12	ROWCNT_TREER	Number(12,0)	DECIMAL(12) NOT NULL	Row Count
13	VERSION_TREE	Number(10,0)	DECIMAL(10) NOT NULL	Tree Version
14	UPDATE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Update Prior Operations
15	TFLT_PRCS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Tree Flattener Process Status I=In Process L=User Lock
16	DTL_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Detail Record name
17	DTL_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Tree Structure Detail Record name
18	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
19	OPRID_LAST_UPDT	Character(30)	VARCHAR2(30) NOT NULL	Last User to Update