OI_TFLT_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	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
6	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
7	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
8	OI_TFLT_PROC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Process Type D=Delete Values F=Flatten Tree Default Value: F
9	OTBI_SRC_INSTANCE	Number(15,4)	DECIMAL(14,4) NOT NULL	OTBI Process Instance
10	DATE_REQ_OPTION2	Character(1)	VARCHAR2(1) NOT NULL	Request Date Option A=As-Of Date S=System Date Default Value: S
11	AS_OF_DATE	Date(10)	DATE	As of Date
12	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
13	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
14	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name Prompt Table: %EDITTABLE
15	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree Prompt Table: %EDITTABLE2
16	FORCE_PROCESS_SW	Character(1)	VARCHAR2(1) NOT NULL	Generic force processing switch Y/N Table Edit Default Value: N
17	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
18	RUN_CNTL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Run Control Flag
19	DELETE_LIMIT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL AE batch processes to perform deletes rather than truncate.
20	FIRST_PASS_SW	Character(1)	VARCHAR2(1) NOT NULL	First Pass Switch
21	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status