WM_XMLP_PM_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	DUE_DT_FROM	Date(10)	DATE	Used in Voucher Maintenance Component
5	FROM_RDG	Signed Number(21,4)	DECIMAL(19,4) NOT NULL	Next preventive maintenance due reading
6	TO_RDG	Signed Number(21,4)	DECIMAL(19,4) NOT NULL	Next preventive maintenance due reading
7	DUE_DT_TO	Date(10)	DATE	Used in Voucher Maintenance Component
8	PERC_DUE_FROM	Signed Number(16,0)	DECIMAL(15) NOT NULL	Preventive Maintenance percent due
9	PERC_DUE_TO	Signed Number(16,0)	DECIMAL(15) NOT NULL	Preventive Maintenance percent due
10	PM_CALC_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Preventive Maintenance Calculation type 100=Sampling days 101=Sampling Readings 102=Cycle 103=Average from Asset 2=Specific Date 200=Meter Reading 3=Day Interval 300=CBM Alert 4=Week interval 5=Month Interval by day 6=Month interval by date
11	PM_PROC_OPT	Character(1)	VARCHAR2(1) NOT NULL	Process Options 1=Preventive 2=Projection
12	CBM_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	CBM Alert source 1=AM Reading Tolerance 2=MM Alert 3=Alert set manually
13	PM_SCHD_ID	Character(10)	VARCHAR2(10) NOT NULL	Preventive Maintenance Schedule ID
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	REPORT_DEFN_ID	Character(12)	VARCHAR2(12) NOT NULL	Report Name (see PSXPRPTDEFN).
16	TMPLDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Template ID (see PSXPTMPLDEFN).
17	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
18	ASOFDATE	Date(10)	DATE	As of Date