IT_MTRC_PR1_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
3	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Serial ID
4	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	AREA_VALUE	Character(10)	VARCHAR2(10) NOT NULL	Area Value
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
8	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
9	TOTAL_CNT_SUMM	Number(8,0)	INTEGER NOT NULL	Total Count
10	PROGRESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Progress Status C=Complete I=In Progress N=New
11	GROUP_BY_AREA	Character(1)	VARCHAR2(1) NOT NULL	Group By Area B=Business Unit D=Department Name L=Location Name
12	TEMP_FLD	Character(1)	VARCHAR2(1) NOT NULL	Temporary Field for App Engine
13	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
14	AS_OF_DATE	Date(10)	DATE	As of Date
15	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
16	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
17	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
18	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
19	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
20	SQLROWS_TARGET	Number(12,0)	DECIMAL(12) NOT NULL	Used in GL Allocation AE programs (FS_ALLC)