Maximo Work History Detail Mappings

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

Values Mapped from Maximo Work History Details to GE Digital APM Work History Detail Records

GE Digital APM Family	GE Digital APM Work History Field ID	GE Digital APM Work History Field Caption	Maximo Table	Maximo Internal ID	Maximo Interface Label	Comments
MI_DTWKHIST	MI_DTWKHIST_ASST_ID_C	Equipment ID	WORKORDER	ASSETNUM	Asset	None
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_DESC_C	Work History Detail Description	WORKORDER	DESCRIPTION	Description	None
MI_DTWKHIST	MI_DTWKHIST_DTL_NARTV_T	Detail Narrative	WORKORDER	DESCRIPTION_LONGDESCRIPTION	This value appears in the Long Description box.	None
MI_DTWKHIST	MI_DTWKHIST_LOC_ID_C	Location ID	WORKORDER	LOCATION	Location	None
MI_DTWKHIST	MI_DTWKHIST_CNDTN_CD_C	Condition Code	WORKORDER	PROBLEMCODE	Problem Code	None
MI_DTWKHIST	MI_DTWKHIST_SITE_C	Site	WORKORDER	SITEID	Site	None
MI_DTWKHIST	MI_DTWKHIST_WRK_HISTRY_ID_C	Work History ID	WORKORDER	WONUM	Work Order	None
MI_DTWKHIST	MI_DTWKHIST_ORDR_ID_C	Order ID	WORKORDER	WONUM	Work Order	None
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_ID_C	History Detail ID	WORKORDER	WONUM	Work Order	This is a GE Digital APM key field.
MI_DTWKHIST	MI_DTWKHIST_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.

Values Mapped from Maximo Service Request Details to GE Digital APM Work History Detail Records

GE Digital APM Family	GE Digital APM Work History Field ID	GE Digital APM Work History Field Caption	Maximo Table	Maximo Internal ID	Maximo Interface Label	Comments
MI_DTWKHIST	MI_DTWKHIST_ASST_ID_C	Equipment ID	SR	ASSETNUM	Asset	None
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_DESC_C	Work History Detail Description	SR	DESCRIPTION	Summary	None
MI_DTWKHIST	MI_DTWKHIST_LOC_ID_C	Location ID	SR	LOCATION	Location	None
MI_DTWKHIST	MI_DTWKHIST_SITE_C	Site	SR	SITEID	Site ID	None
MI_DTWKHIST	MI_DTWKHIST_RQST_ID_C	Request ID	SR	TICKETID	Service Request	None
MI_DTWKHIST	MI_DTWKHIST_EVNT_DTL_ID_C	History Detail ID	SR	TICKETID	Service Request	This is a GE Digital APM key field.
MI_DTWKHIST	MI_DTWKHIST_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.