Maximo Work History Mappings

The following tables list the Maximo fields that are used to populate the fields in the Work History records created in GE Digital APM when you extract Work Orders and Service Request using the Maximo Work History Adapter:

Values Mapped from Maximo Work Orders to GE Digital APM Work History Records

GE Digital APM Family Name	GE Digital APM Work History Field ID	GE Digital APM Work History Field Caption	Maximo Table Name	Maximo Internal ID	Maximo Interface Label	Comments
MI_EVWKHIST	MI_EVWKHIST_MAINT_COMPL_D	Maintenance Completion Date	WORKORDER	ACTFINISH	Actual Finish	None
MI_EVWKHIST	MI_EVWKHIST_ACT_LABOR_COST_N	Actual Labor Cost	WORKORDER	ACTLABCOST	Actual Labor Cost	None
MI_EVWKHIST	MI_EVWKHIST_ACT_LABOR_TIME_N	Actual Labor	WORKORDER	ACTLABHRS	Actual Labor Hours	None
MI_EVWKHIST	MI_EVWKHIST_ACT_MTRL_COST_N	Actual Material Cost	WORKORDER	ACTMATCOST	Actual Material Cost	None
MI_EVWKHIST	MI_EVWKHIST_ACT_SERV_COST_N	Actual Service Cost	WORKORDER	ACTSERVCOST	Actual Service Cost	None
MI_EVWKHIST	MI_EVWKHIST_MAINT_START_D	Maintenance Start Date	WORKORDER	ACTSTART	Actual Start	None
MI_EVWKHIST	MI_EVWKHIST_ACT_TOOL_COST_N	Actual Tool Cost	WORKORDER	ACTTOOLCOST	Actual Tool Cost	None
MI_EVWKHIST	MI_EVWKHIST_MAINT_CST_N	Maintenance Cost	WORKORDER	ACTTOTALCOST	Actual Total Cost	None
MI_EVWKHIST	MI_EVWKHIST_EQU_LOC_PRIORTY_N	Equipment Location Priority	WORKORDER	ASSETLOCPRIORITY	Asset/Location Priority	None
MI_EVWKHIST	MI_EVENT_ASST_ID_CHR	Equipment ID	WORKORDER	ASSETNUM	Asset	None
MI_EVWKHIST	MI_EVWKHIST_CALC_PRIORTY_N	Calculated Priority	WORKORDER	CALCPRIORITY	Asset/Location Priority	None
MI_EVWKHIST	MI_EVENT_MODFD_BY_CHR	Modified By	WORKORDER	CHANGEBY	Modified By	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_CHNG_DT_D	Order Last Change Date	WORKORDER	CHANGEDATE	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVWKHIST_CREW_ID_C	Crew ID	WORKORDER	CREWID	Crew	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_DESC_C	Order Description	WORKORDER	DESCRIPTION	Description	None
MI_EVWKHIST	MI_EVENT_SHRT_DSC_CHR	Event Short Description	WORKORDER	DESCRIPTION	Description	None
MI_EVWKHIST	MI_EVENT_LNG_DSC_TX	Event Long Description	WORKORDER	DESCRIPTION_LONGDESCRIPTION	This value appears in the Long Description box.	None
MI_EVWKHIST	MI_EVWKHIST_EST_LABOR_COST_N	Estimated Labor Cost	WORKORDER	ESTLABCOST	Estimated Labor Cost	None
MI_EVWKHIST	MI_EVWKHIST_EST_LABOR_TIME_N	Estimated Labor	WORKORDER	ESTLABHRS	Estimated Labor Hours	None
MI_EVWKHIST	MI_EVWKHIST_EST_MTRL_COST_N	Estimated Material Cost	WORKORDER	ESTMATCOST	Estimated Material Cost	None
MI_EVWKHIST	MI_EVWKHIST_EST_SERV_COST_N	Estimated Service Cost	WORKORDER	ESTSERVCOST	Estimated Service Cost	None
MI_EVWKHIST	MI_EVWKHIST_EST_TOOL_COST_N	Estimated Tool Cost	WORKORDER	ESTTOOLCOST	Estimated Tool Cost	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_MAINT_PLAN_C	Order Maintenance Plan	WORKORDER	JPNUM	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_PRTY_DESC_C	Order Priority Description	WORKORDER	JUSTIFYPRIORITY	Priority Justification	None
MI_EVWKHIST	MI_EVWKHIST_LEAD_CRAFT_C	Lead Craft	WORKORDER	LEAD	Lead	None
MI_EVWKHIST	MI_EVENT_LOC_ID_CHR	Location ID	WORKORDER	LOCATION	Location	None
MI_EVWKHIST	MI_EVWKHIST_ACT_OUT_LBR_CST_N	Actual Outside Labor Cost	WORKORDER	OUTLABCOST	Outside Labor Cost	None
MI_EVWKHIST	MI_EVWKHIST_ACT_OUT_MTR_CST_N	Actual Outside Material Cost	WORKORDER	OUTMATCOST	Outside Material Cost	None
MI_EVWKHIST	MI_EVWKHIST_ACT_OUT_TL_CST_N	Actual Outside Tool Cost	WORKORDER	OUTTOOLCOST	Outside Tool Cost	None
MI_EVWKHIST	MI_EVWKHIST_PM_NBR_C	PM Number	WORKORDER	PMNUM	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVWKHIST_RQST_ID_C	Request ID	WORKORDER	ORIGRECORDID	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVWKHIST_RQST_TYP_CD_C	Request Type Code	WORKORDER	ORIGRECORDCLASS	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVENT_STRT_DT	Event Start Date	WORKORDER	REPORTDATE	Reported Date	None
MI_EVWKHIST	MI_EVWKHIST_SCHED_COMPL_D	Scheduled Completion Date	WORKORDER	SCHEDFINISH	Scheduled Finish	None
MI_EVWKHIST	MI_EVWKHIST_SCHED_START_D	Scheduled Start Date	WORKORDER	SCHEDSTART	Scheduled Start	None
MI_EVWKHIST	MI_EVWKHIST_SITE_C	Site	WORKORDER	SITEID	Site	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_SYS_STAT_C	Order System Status	WORKORDER	STATUS	Status	None
MI_EVWKHIST	MI_EVWKHIST_TARGET_COMPL_D	Target Completion Date	WORKORDER	TARGCOMPDATE	Target Finish	None
MI_EVWKHIST	MI_EVWKHIST_TARGET_START_D	Target Start Date	WORKORDER	TARGSTARTDATE	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVENT_ID	Event ID	WORKORDER	WONUM	Work Order	None
MI_EVWKHIST	MI_EVWKHIST_ORDER_ID_N	Order ID	WORKORDER	WONUM	Work Order	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_PRTY_C	Order Priority	WORKORDER	WOPRIORITY	Priority	None
MI_EVWKHIST	MI_EVWKHIST_ORDR_TYP_CD_C	Order Type Code	WORKORDER	WORKTYPE	None. This field does not appear on the Maximo interface.	None
MI_EVWKHIST	MI_EVWKHIST_OBJECT_NUMBER_C	Object Number	WORKORDER	"OR"+WONUM	None. This field does not appear on the Maximo interface.	This field appears as a drop-down list box in GE Digital APM.
MI_EVWKHIST	MI_EVWKHIST_SAP_SYSTEM_C	CMMS System	Automatically populated by the Maximo System.	Automatically populated by the Maximo System.	Automatically populated by the Maximo System.	This is a GE Digital APM key field.