EDR_CF_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	END_DATE	Date(10)	DATE	End Date
5	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	EDR_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Effective Date Range Table
7	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
8	SETCNTRLFLD	Character(18)	VARCHAR2(18) NOT NULL	Tree Structure Node User Key Field Name
9	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
10	FIELD_VALUE80	Character(80)	VARCHAR2(80) NOT NULL	Field value
11	EFFDT	Date(10)	DATE	Effective Date
12	EFFDT_TO	Date(10)	DATE	Effective Date To
13	SQLROWS_TAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
14	SQLROWS_DETAILS	Number(12,0)	DECIMAL(12) NOT NULL	Used in AE
15	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
16	UPDATE_LOG	Character(1)	VARCHAR2(1) NOT NULL	Update Log
17	RECNAME_RSEL	Character(15)	VARCHAR2(15) NOT NULL	Selector range table
18	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive