FT_CFVS_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	AS_OF_DATE	Date(10)	DATE	As of Date
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CALLING_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Calling Program
5	CFV_SETID	Character(5)	VARCHAR2(5) NOT NULL	ChartField Valuse Set SetID
6	CORR_ID	Character(3)	VARCHAR2(3) NOT NULL	3 Digit Correlation ID
7	CORRELATION_ID	Character(2)	VARCHAR2(2) NOT NULL	Correlation ID
8	DELETE_LIMIT	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL AE batch processes to perform deletes rather than truncate.
9	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
10	FIELDNAME_SEQ_FLD	Character(18)	VARCHAR2(18) NOT NULL	Sequence Field
11	INCLUDE_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Include Inactive ChartFields
12	RECNAME_SEL_TBL	Character(15)	VARCHAR2(15) NOT NULL	Selector table name
13	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
14	SQLROWS_STAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
15	SQLROWS_CFVSET	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
16	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
17	USE_GTT	Character(1)	VARCHAR2(1) NOT NULL	Use Global Temp Table Flag Default Value: N