Maximo Mappings
Maximo Equipment Mappings
The following table contains a list of Maximo fields that are used to populate fields in the Equipment records created in APM when you use the Maximo Equipment Adapter.
| APM Family ID | APM Field ID | APM Field Caption | Maximo Table | Maximo Internal ID | Maximo Adapter Label | Comments |
|---|---|---|---|---|---|---|
| MI_EQUIP000 | MI_EQUIP000_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 APM key field. |
| MI_EQUIP000 | MI_EQUIP000_CHANGE_DATE_D | CMMS Last Changed Date | ASSET | CHANGEDATE | Changed Date | None |
| MI_EQUIP000 | MI_EQUIP000_CRITI_IND_C | Criticality Indicator | ASSET | PRIORITY | Priority | None |
| MI_EQUIP000 | MI_EQUIP000_EQUIP_ID_C | Equipment ID | ASSET | ASSETNUM | Asset | This is a APM key field. |
| MI_EQUIP000 | MI_EQUIP000_EQUIP_LNG_DESC_T | Equipment Long Description | ASSET | DESCRIPTION_LONGDESCRIPTION | On the Maximo interface, this value appears in the Long Description box. | None |
| MI_EQUIP000 | MI_EQUIP000_SN_C | Equipment Serial Number | ASSET | SERIALNUM | Manufacturer Serial Number | None |
| MI_EQUIP000 | MI_EQUIP000_EQUIP_SHRT_DESC_C | Equipment Short Description | ASSET | DESCRIPTION | On the Maximo interface, this value appears next to the Asset box. | None |
| MI_EQUIP000 | MI_EQUIP000_EQUIP_TECH_NBR_C | Equipment Technical Number | ASSET | ASSETID | None. This field does not appear on the Maximo interface. | None |
| MI_EQUIP000 | MI_EQUIP000_TYPE_C | Equipment Type | ASSET | ASSETTYPE | Type | None |
| MI_EQUIP000 | MI_EQUIP000_EQUIP_VNDR_C | Equipment Vendor | ASSET | VENDOR | Vendor | None |
| MI_EQUIP000 | MI_EQUIP000_FNC_LOC_C | Functional Location | ASSET | LOCATION | Location | None |
| MI_EQUIP000 | MI_EQUIP000_INV_NO_C | Inventory Number | ASSET | ITEMNUM | Rotating Item | None |
| MI_EQUIP000 | MI_EQUIP000_MFR_C | Manufacturer | ASSET | MANUFACTURER | Manufacturer | None |
| MI_EQUIP000 | MI_EQUIP000_OBJ_TYP_C | Object Type | CLASSSTRUCTURE | HIERARCHYPATH | Classification | None |
| MI_EQUIP000 | MI_EQUIP000_OBJ_TYP_DESC_C | Object Type Description | CLASSSTRUCTURE | DESCRIPTION_CLASS | Class Description | None |
| MI_EQUIP000 | MI_EQUIP000_PRCH_D | Purchase Date | ASSET | INSTALLDATE | Installation Date | None |
| MI_EQUIP000 | MI_EQUIP000_SITE_C | Site | ASSET | SITEID | Site | None |
| MI_EQUIP000 | MI_EQUIP000_SYS_ST_C | System Status | ASSET | STATUS | Status | None |
| MI_EQUIP000 | MI_EQUIP000_WRNTY_EXPR_D | Warranty Expiration Date | ASSET | WARRANTYEXPDATE | None. This field does not appear on the Maximo interface. | None |
Maximo Functional Location Mappings
The following table contains a list of Maximo fields that are used to populate fields in the Functional Location records created in APM when you use the Maximo Functional Location Adapter:.
| APM Family ID |
APM Field ID | APM Field Caption | MAXIMO Table | Maximo Internal ID | Maximo Adapter Label | Comments |
|---|---|---|---|---|---|---|
| MI_FNCLOC00 | MI_FNCLOC00_CHANGE_DATE_D | CMMS Last Changed Date | LOCATION | CHANGEDATE | None. This field does not appear on the Maximo interface. | None |
| MI_FNCLOC00 | MI_FNCLOC00_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 APM key field. |
| MI_FNCLOC00 | MI_FNCLOC00_CRTCAL_IND_C | Criticality Indicator | LOCATION | LOCPRIORITY | Priority | None |
| MI_FNCLOC00 | MI_FNCLOC00_FAIL_CLASS_C | Failure Class | LOCATION | FAILURECODE | Failure Class | None |
| MI_FNCLOC00 | MI_FNCLOC00_FNC_LOC_C | Functional Location | LOCATION | LOCATION | Location | This is a APM key field. |
| MI_FNCLOC00 | MI_FNCLOC00_FNC_LOC_DESC_C | Functional Location Description | LOCATION | DESCRIPTION | On the Maximo interface, this value appears next to the Location box. | None |
| MI_FNCLOC00 | MI_FNCLOC00_INTERNAL_ID_C | Functional Location Internal ID | LOCATION | LOCATIONSID | None. This field does not appear on the Maximo interface. | None |
| MI_FNCLOC00 | MI_FNCLOC00_FNC_LOC_LNG_DESC_C | Functional Location Long Description | LOCATION | DESCRIPTION_LONGDESCRIPTION | This value appears in the Long Description box. | None |
| MI_FNCLOC00 | MI_FNCLOC00_TYPE_C | Location Type | LOCATION | TYPE | Type | None |
| MI_FNCLOC00 | MI_FNCLOC00_OBJ_TYP_C | Object Type | CLASSSTRUCTURE | HIERARCHYPATH | Classification | None |
| MI_FNCLOC00 | MI_FNCLOC00_OBJ_TYP_DESC_C | Object Type Description | CLASSSTRUCTURE | DESCRIPTION_CLASS | Class Description | None |
| MI_FNCLOC00 | MI_FNCLOC00_SITE_C | Site | LOCATION | SITEID | Site | None |
| MI_FNCLOC00 | MI_FNCLOC00_SUPR_FNC_LOC_C | Superior Functional Location | LOCATION | PARENT | Parent | None |
| MI_FNCLOC00 | MI_FNCLOC00_SYS_STATUS_C | System Status | LOCATION | STATUS | Status | None |
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 APM when you extract Work Orders and Service Request using the Maximo Work History Adapter.
Values Mapped from Maximo Work Orders to APM Work History Records
| APM Family Name | APM Work History Field ID | 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 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 APM key field. |
Values Mapped from Maximo Service Request to APM Work History Records
| APM Family | APM Work History Field ID | APM Work History Field Caption | Maximo Table | Maximo Internal ID | Maximo Interface Label | Comments |
|---|---|---|---|---|---|---|
| MI_EVWKHIST | MI_EVENT_ASST_ID_CHR | Equipment ID | SR | ASSETNUM | Asset | None |
| MI_EVWKHIST | MI_EVENT_SHRT_DSC_CHR | Event Short Description | SR | DESCRIPTION | Summary | None |
| MI_EVWKHIST | MI_EVENT_LOC_ID_CHR | Location ID | SR | LOCATION | Location | None |
| MI_EVWKHIST | MI_EVWKHIST_SITE_C | Site | SR | SITEID | Site | None |
| MI_EVWKHIST | MI_EVWKHIST_OBJECT_NUMBER_C | OBJECT NUMBER | SR | "QM"+TICKETID | None. This field does not appear on the Maximo interface. | This is a APM key field. |
| MI_EVWKHIST | MI_EVWKHIST_RQST_CHNG_DT_D | Change Date | SR | CHANGEDATE | None. This field does not appear on the Maximo interface. | None |
| MI_EVWKHIST | MI_EVWKHIST_RQST_ID_C | Request ID | SR | TICKETID | Service Request | None |
| MI_EVWKHIST | MI_EVENT_ID | Event ID | SR | TICKETID | Service Request | None |
| 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 APM key field. |
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 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 APM Work History Detail Records
| APM Family | APM Work History Field ID | 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 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 APM key field. |
Values Mapped from Maximo Service Request Details to APM Work History Detail Records
| APM Family | APM Work History Field ID | 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 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 APM key field. |
Maximo Recommendation Mappings
The following tables contain a list of APM Recommendation fields that are used to populate Maximo Work Orders and Service Requests when you use the Maximo Notification Management Adapter.
Values Mapped to Maximo Work Order from APM Recommendation
| APM Family | APM Field | Maximo Object Structure | Maximo Field |
|---|---|---|---|
| MI_REC | MI_REC_ASSET_ID_CHR | WORKORDER | ASSETNUM |
| MI_REC | MI_REC_SHORT_DESCR_CHR | WORKORDER | DESCRIPTION |
| MI_REC | MI_REC_LONG_DESCR_TX | WORKORDER | DESCRIPTION_LONG |
| MI_REC | MI_REC_LOC_ID_CHR | WORKORDER | LOCATION |
| MI_REC | MI_REC_SITE_C | WORKORDER | SITEID |
| MI_REC | MI_REC_TARGE_COMPL_DATE_DT | WORKORDER | TARGCOMPDATE |
| CONSTANT | WORKORDER | WORKORDER | WOCLASS |
| CONSTANT | PM | WORKORDER | WORKTYPE |
| CONSTANT | Add/Change | WORKORDER | @action |
Values Mapped to Maximo Service Request from APM Recommendation
| APM Family | APM Field | Maximo Object Structure | Maximo Field |
|---|---|---|---|
| MI_REC | MI_REC_ASSET_ID_CHR | SR | ASSETNUM |
| MI_REC | MI_REC_SHORT_DESCR_CHR | SR | DESCRIPTION |
| MI_REC | MI_REC_LONG_DESCR_TX | SR | DESCRIPTION_LONG |
| MI_REC | MI_REC_LOC_ID_CHR | SR | LOCATION |
| MI_REC | MI_REC_SITE_C | SR | SITEID |
| MI_REC | MI_REC_TARGE_COMPL_DATE_DT | SR | TARGET FINISH |
| CONSTANT | SR | SR | CLASS |
| CONSTANT | Add/Change | SR | @action |