CF_EXP_PRC_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	RECNAME_DETAIL	Character(15)	VARCHAR2(15) NOT NULL	Detail Record
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	TAO_TBL_NAME	Character(15)	VARCHAR2(15) NOT NULL	Base TAO Table Name
8	SQLROWS_TAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
9	SQLROWS_1	Number(9,0)	DECIMAL(9) NOT NULL	Used in AE
10	SQLROWS_2	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
11	SQLROWS_3	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
12	SQLROWS_4	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
13	AS_OF_DATE	Date(10)	DATE	As of Date
14	CUT_OFF_DATE	Date(10)	DATE	Cut Off Date
15	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
16	CHARTFIELD	Character(18)	VARCHAR2(18) NOT NULL	ChartField
17	CHARTFIELD_VALUE	Character(30)	VARCHAR2(30) NOT NULL	ChartField Value
18	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
19	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
20	EFFDT_FROM	Date(10)	DATE	Effective Date From
21	EFFDT_TO	Date(10)	DATE	Effective Date To
22	EFFDT_TARG	Date(10)	DATE	New Effective Date
23	OTBI_SRC_INSTANCE	Number(15,4)	DECIMAL(14,4) NOT NULL	OTBI Process Instance
24	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
25	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name
26	BASE_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
27	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
28	RELLANGRECNAME	Character(15)	VARCHAR2(15) NOT NULL	Related Language Record Name
29	SHORTNAME1	Character(15)	VARCHAR2(15) NOT NULL	Holds the Shortname value.
30	EXT_SYSTEM_ID	Character(10)	VARCHAR2(10) NOT NULL	External System ID