WM_FANL_SUM_TMP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KEY1_FLD_VAL	Character(50)	VARCHAR2(50) NOT NULL	Key 1 Field Value
2	KEY2_FLD_VAL	Character(50)	VARCHAR2(50) NOT NULL	Key 2 Field Value
3	KEY3_FLD_VAL	Character(50)	VARCHAR2(50) NOT NULL	Key 3 Field Value
4	KEY4_FLD_VAL	Character(50)	VARCHAR2(50) NOT NULL	Key 4 Field Value
5	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes Default Value: Y
6	WM_FAIL_SUMM_CNT	Number(8,0)	INTEGER NOT NULL	Summary Count
7	WM_FAIL_REC_COUNT	Number(8,0)	INTEGER NOT NULL	Failure Count
8	DAYS_BETW_FAILURE	Number(8,0)	INTEGER NOT NULL	Mean Time Betw Failure (Days)
9	UNITS_BETW_FAILURE	Signed Number(23,6)	DECIMAL(21,6) NOT NULL	Mean Meter Units Betw Failure
10	METER_TYPE	Character(30)	VARCHAR2(30) NOT NULL	Meter Type Prompt Table: AM_METER_TYPE
11	TOTAL_REPAIR_HRS	Number(16,3)	DECIMAL(15,3) NOT NULL	Mean Time to Repair (Hrs)
12	TOTAL_REPAIR_COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Mean Cost to Repair
13	REPAIR_COST_LBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Labor Repair Cost
14	REPAIR_COST_MAT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Material Repair Cost
15	REPAIR_COST_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Procurement Repair Cost
16	REPAIR_COST_TLS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Tools Repair Cost
17	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURR_CD_EFF_VW