Work History Data Loader
About the Work History Data Loader
The Work History Data Loader allows a user to load historical work order data from an Excel workbook. The loader will create the necessary work history and work history detail records and link them to the corresponding equipment or functional location records as defined in the Excel workbook.
About the Work History Data Loader Data Model
The data for Work History and Work History detail families is loaded from a single Excel workbook containing a single worksheet. This includes Work History and Work History Detail.
Relationships:
- The Work History records are linked to Equipment and/or Functional Location records via the relationship Has Work History [MIR_HSWKHST].
- The Work History Detail records will be related to the appropriate Work History records via the relationship family Has Event Detail [MIR_EVNTDET].
The Work History Data Loader General Loading Strategy
This section describes any prerequisites to loading the data and the order in which the data will be loaded.
About This Task
Note: Before reading this section, refer to the Data Model section.
The Work History and Work History Detail data load must be performed in a specific sequence to successfully populate fields, create records, and link them to the predecessor and/or successor records.
Procedure
Work History Data Loader Load Verification
Use this query in any APM database to populate an Excel format with the required data fields.
Work History Data Query
SELECT 'Customer Event Id' "Customer Event Id", [MI_EVWKHIST].[MI_EVENT_ID]
"Event ID", [MI_EQUIP000].[MI_EQUIP000_EQUIP_ID_C] "Equipment ID",
[MI_EQUIP000].[MI_EQUIP000_EQUIP_TECH_NBR_C] "Equipment Technical Number",
[MI_FNCLOC00].[MI_FNCLOC00_FNC_LOC_C] "Functional Location",
[MI_EVWKHIST].[MI_EVWKHIST_SAP_SYSTEM_C] "CMMS System",
[MI_EVWKHIST].[MI_EVWKHIST_ACTIV_CAUSE_C] "Activity Cause",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_PM_ACT_DESC_C] "Activity Type Description",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_PM_ACT_C] "Activity Type",
[MI_EVWKHIST].[MI_EVWKHIST_BRKDN_IND_F] "Breakdown Indicator",
[MI_EVWKHIST].[MI_EVWKHIST_DETCT_MTHD_CD_C] "Detection Method Code",
[MI_EVWKHIST].[MI_EVWKHIST_DETCT_MTHD_DESC_C] "Detection Method Description",
[MI_EVWKHIST].[MI_EVWKHIST_EFFCT_CD_C] "Effect Code",
[MI_EVWKHIST].[MI_EVWKHIST_EFFCT_DESC_C] "Effect Description",
[MI_EVWKHIST].[MI_EVWKHIST_EVENT_DATE_DESC_C] "Event Date Description",
[MI_EVWKHIST].[MI_EVENT_LNG_DSC_TX] "Event Long Description",
[MI_EVWKHIST].[MI_EVENT_SHRT_DSC_CHR] "Event Short Description",
[MI_EVWKHIST].[MI_EVENT_STRT_DT] "Event Start Date",
[MI_EVWKHIST].[MI_EVWKHIST_STATUS_C] "Event Status",
[MI_EVWKHIST].[MI_EVENT_TYP_CHR] "Event Type",
[MI_EVWKHIST].[MI_EVWKHIST_FAILR_MODE_CD_C] "Failure Mode Code",
[MI_EVWKHIST].[MI_EVWKHIST_FAILR_MODE_DESC_C] "Failure Mode Description",
[MI_EVWKHIST].[MI_EVWKHIST_FAILURE_REM_T] "Failure Remarks",
[MI_EVWKHIST].[MI_EVWKHIST_FNCTNL_LOSS_CD_C] "Functional Loss Code",
[MI_EVWKHIST].[MI_EVWKHIST_FNCTNL_LOSS_DESC_C] "Functional Loss Description",
[MI_EVWKHIST].[MI_EVWKHIST_MAINT_COMPL_D] "Maintenance Completion Date",
[MI_EVWKHIST].[MI_EVWKHIST_MAINT_CST_UOM_C] "Maintenance Cost UOM",
[MI_EVWKHIST].[MI_EVWKHIST_MAINT_CST_N] "Maintenance Cost",
[MI_EVWKHIST].[MI_EVWKHIST_MAINT_START_D] "Maintenance Start Date",
[MI_EVWKHIST].[MI_EVWKHIST_MECH_DWN_TIME_N] "Mechanical Down Time",
[MI_EVWKHIST].[MI_EVWKHIST_MECH_AVAIL_D] "Mechanically Available Date",
[MI_EVWKHIST].[MI_EVWKHIST_MECH_UNAVL_D] "Mechanically Unavailable Da",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_CRT_DT_D] "Order Creation Date",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_DESC_C] "Order Description",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_ID_C] "Order ID",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_MAINT_PLAN_C] "Order Maintenance Plan",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_PRTY_DESC_C] "Order Priority Description",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_PRTY_C] "Order Priority",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_REF_DT_D] "Order Reference Date",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_SYS_CND_DES_C] "Order System Condition Desc",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_SYS_COND_C] "Order System Condition",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_SYS_STAT_C] "Order System Status",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_TYP_CD_C] "Order Type Code",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_TYP_DESC_C] "Order Type Description",
[MI_EVWKHIST].[MI_EVWKHIST_ORDR_USER_STAT_C] "Order User Status",
[MI_EVWKHIST].[MI_EVWKHIST_PM_NBR_C] "PM Number",
[MI_EVWKHIST].[MI_EVWKHIST_PRDN_CST_N] "Production Cost",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_ID_C] "Request ID",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_CRT_DT_D] "Request Creation Date",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_DESC_C] "Request Description",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_PRTY_DESC_C] "Request Priority Descriptio",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_PRTY_C] "Request Priority",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_SYS_STAT_C] "Request System Status",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_TYP_CD_C] "Request Type Code",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_TYP_DESC_C] "Request Type Description",
[MI_EVWKHIST].[MI_EVWKHIST_RQST_USER_STAT_C] "Request User Status",
[MI_EVWKHIST].[MI_EVWKHIST_SCHED_COMPL_D] "Scheduled Completion Date",
[MI_EVWKHIST].[MI_EVWKHIST_SCHED_START_D] "Scheduled Start Date",
[MI_EVWKHIST].[MI_EVWKHIST_TARGET_COMPL_D] "Target Completion Date",
[MI_EVWKHIST].[MI_EVWKHIST_TARGET_START_D] "Target Start Date",
[MI_EVWKHIST].[MI_EVWKHIST_TIME_TO_REPR_N] "Time To Repair (TTR)",
[MI_EVWKHIST].[MI_EVWKHIST_TOTL_CST_N] "Total Cost",
[MI_EVWKHIST].[MI_EVWKHIST_WORK_HIST_TYPE_C] "Work History Type",
[MI_EVWKHIST].[MI_EVWKHIST_WO_PRIORTY_N] "Work Order Priority",
'WHD_Customer WHD ID' "WHD_Customer WHD ID", [MI_DTWKHIST].[MI_DTWKHIST_EVNT_DTL_ID_C]
"WHD_Work History Detail ID", [MI_DTWKHIST].[MI_DTWKHIST_EVNT_DTL_DESC_C]
"WHD_Work Hist Detail Desc", [MI_DTWKHIST].[MI_DTWKHIST_ORDR_ID_C]
"WHD_Order ID", [MI_DTWKHIST].[MI_DTWKHIST_RQST_ID_C] "WHD_Request ID",
[MI_DTWKHIST].[MI_DTWKHIST_CAUSE_CD_C] "WHD_Cause Code",
[MI_DTWKHIST].[MI_DTWKHIST_CAUSE_DESC_C] "WHD_Cause Description",
[MI_DTWKHIST].[MI_DTWKHIST_CNDTN_CD_C] "WHD_Condition Code",
[MI_DTWKHIST].[MI_DTWKHIST_CNDTN_DESC_C] "WHD_Condition Description",
[MI_DTWKHIST].[MI_DTWKHIST_DTL_NARTV_T] "WHD_Detail Narrative",
[MI_DTWKHIST].[MI_DTWKHIST_MAINT_ITEM_CD_C] "WHD_Maintainable Item Code",
[MI_DTWKHIST].[MI_DTWKHIST_MAINT_ITEM_DESC_C] "WHD_Maintainable Item Desc",
[MI_DTWKHIST].[MI_DTWKHIST_MAINT_ACTN_CD_C] "WHD_Maintenance Action Code",
[MI_DTWKHIST].[MI_DTWKHIST_MAINT_ACTN_DESC_C] "WHD_Maintenance Action Desc"
FROM [MI_EVWKHIST] JOIN_PRED [MI_EQUIP000] JOIN_PRED [MI_FNCLOC00]
ON {MIR_FLHSEQ} ON {MIR_HSWKHST} JOIN_SUCC [MI_DTWKHIST] ON {MIR_EVNTDET}
About the Work History Data Loader Workbook Layout and Use
To import data using the Work History Data Loader, APM provides an Excel workbook, Work History.xlsx, which supports baseline data loading of work history and work history detail records in APM. This workbook must be used to perform the data load.
Note: Worksheets in the workbook not being used may be left blank, but should not be deleted from the workbook.
The following table lists the worksheets that are included in the Foundation Work History Data Loader workbook.
|
Worksheet |
Description |
|---|---|
| Configuration | The Configuration worksheet is needed to describe the type of data that you will be loading and how that data should be handled during the data load. |
| WorkHistory | This worksheet is used to specify data for import to the Work History family. |
| WorkHistoryToWHDetails | This worksheet is used to specify data for import to the Work History Detail family. |
| WorkHistoryToEquipment | This worksheet is used to link Work History to Equipment records. |
| WorkHistoryToFLOCs | This worksheet is used to link Work History to Functional Location records. |
Configuration Worksheet
The Configuration worksheet tells the Data Loader what types of data are being loaded and how the data is to be loaded, and is standard for all data loads regardless of the type of data that you are loading. The following table outlines the options that are valid or the values that are expected in each of the columns on the Configuration worksheet
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| Number of Rows to Chunk | OPTION_NUMBER_ROWS_TO_CHUNK | Character | Option to break-up or chunk data. |
| Load Data From Worksheet | LOAD_DATA_WORKSHEET | Boolean | Identifies if data from the corresponding worksheet identified in the Data Worksheet ID column will be loaded or not.
|
| Data Worksheet ID | DATA_WORKSHEET_ID | Character | This column contains the name of the <data> worksheet where the actual data is located. It needs to have the same name as the <data> worksheet in the data loader workbook. |
| Batch Size | BATCH_SIZE | Character | Modifying this field is required to determine the number of records processed in each batch. Enter the batch size you want, and the Data Loader will process that many records per batch. For example, if you want to use a batch size of 100, enter 100, and the data loader will process 100 records per batch. Note: The recommended batch size is 100. If the Batch Size column is removed from the source workbook, the data loader will default to a batch size of 100. In addition to processing the data in batches, the log file reports progress by batch. |
| Primary Family ID | PRIMARY_FAMILY_ID | Character | Depending on the type of data that you are working with, this will contain the Relationship Family ID or the Entity Family ID. You can also allow the data in source file to determine the Family ID by encapsulating the Field ID that contains the Family ID data in brackets (<>). For example, if in the <data> worksheet there is a column with an ID of PRIMARY_FAMILY_ID, where each row contains the corresponding Family ID, then in this column you should put the value of <PRIMARY_FAMILY_ID>. If the Family ID in the Meridium, Inc. metadata contains spaces, then you have to use this feature. |
| Primary Family Key Fields | PRIMARY_FAMILY_KEY_FIELDS | Character | This column contains the Field IDs associated with the Primary Family that are used to uniquely identify a record. If more than one field is to be used, then each Field ID needs to be separated by a | (Pipe) character. In the case where you are loading data into a relationship, if no keys fields exist or are used, use the <none> constant. If the Primary Action is ACTION_INSERTONLY, then no key fields need to be specified, so you can use the <none> constant. |
| Family Type | FAMILY_TYPE | Character | The value is this column should be Entity or Relationship depending on the type of data that is being loaded. |
| Predecessor Family ID | PRED_FAMILY_ID | Character | When the Family Type is Relationship, this column will contain the value of the Entity Family ID that is the predecessor in the relationship. Otherwise, it should contain the <none> constant. You can also use the data in each of the rows to determine the Predecessor Family ID. |
| Predecessor Family Key Fields | PRED_FAMILY_KEY_FIELDS | Character | This column contains the Field ID or IDs associated with the Predecessor Family that are used to uniquely identify the predecessor record. If more than one field is to be used, then each Field ID needs to be separated by a | (Pipe) character. If the Predecessor Action is ACTION_INSERTONLY, then no key fields need to be specified, so you can use the <none> constant. |
| Successor Family ID | SUCC_FAMILY_ID | Character | When the Family Type is Relationship, this column will contain the value of the Entity Family ID that is the successor in the relationship. Otherwise, it should contain the <none> constant. You can also use the data in each of the rows to determine the Successor Family ID. |
| Successor Family Key Fields | SUCC_FAMILY_KEY_FIELDS | Character | This column contains the Field ID or IDs associated with the Successor Family that are used to uniquely identify the successor record. If more than one field is to be used, then each Field ID needs to be separated by a | (Pipe) character. If the Successor Action is ACTION_INSERTONLY, then no key fields need to be specified, so you can use the <none> constant. |
| Primary Action | PRIMARY_ACTION | Character | The value in this column will determine the action that will be applied to the Primary Family records. If the Family Type is Entity, then the possible values are:
Deleting a record and purging a record will both delete the current record, the difference being that the purge action will delete the record and all of the links or relationships tied to that record. The delete action will simply attempt to delete the record, and if it is related to another record, the delete will fail. If The Family Type is Relationship, then the possible values are:
|
| Predecessor Action | PRED_ACTION | Character | The value in this column will determine the action that will be applied to the Predecessor Family records. The possible values are:
If The Family Type is Entity, then the values need to be
|
| Successor Action | SUCC_ACTION | Character | The value in this column will determine the action that will be applied to the Successor Family records. The possible values are:
If The Family Type is Entity, then the values need to be
|
| Insert with Null Values? | OPTION_INSERT_ON_NULL | Boolean | When setting field values on a new record, if a value coming across is NULL, the field values will be set to NULL if this option is set to True. |
| Update with Null Values? | OPTION_UPDATE_ON_NULL | Boolean | When setting field values on an existing record, if a value coming across is NULL, the field values will be set to NULL if this option is set to True. |
| Replace an Existing Link? | OPTION_REPLACE_EXISTING_LINK | Boolean | The Replace Existing Relationship option is used to determine how a relationship is to be maintained by its cardinality definition. For example, the relationship Location Contains Asset that is defined in the Configuration Manager. It has a cardinality defined as Zero or One to Zero or One, has a Location LP-2300, and contains the Asset P-2300. If, in the data load, you assign the Asset P-5000 to be contained in the Location LP-2300, and you have set the Replace Existing Link property to True, then the data loader will link P-5000 to LP-2300 and unlink P-2300 from LP-2300. This assumes that P-5000 is not currently linked to another location. The same is true for a relationship that is defined as Zero or One to Zero or Many, or Zero or Many to Zero or One. |
| Allow Change of Family? | OPTION_ALLOW_CHANGE_OF_FAMILY | Boolean | Allows the data loader to move an entity from one family to another. For example, this would allow an entity that is currently assigned to the Centrifugal Pump family to be moved to the Reciprocating Pump family. All relationships will be maintained as long as the family to which the entity is being moved allows the same relationships. Note: Because of the extra processing required, by selecting this option, the interface performance will decrease. |
WorkHistory
| Field ID | Filed Caption | Data Type (Length) | Comments |
|---|---|---|---|
| Event ID | MI_EVENT_ID | Character (255) | Generated by the system, and is not loaded. |
| CMMS System | MI_EVWKHIST_SAP_SYSTEM_C | Character (50) | None |
| Equipment ID | MI_EVENT_ASST_ID_CHR | Character (255) | Used as unique key to find equipment. |
| Asset Tech ID | MI_EVWKHIST_ASST_TECH_ID_C | Character (255) | None |
| Location ID | MI_EVENT_LOC_ID_CHR | Character (255) | Is a key field, and is used to find Functional Location. |
| Activity Cause | MI_EVWKHIST_ACTIV_CAUSE_C | Character (255) | None |
| Activity Cause Description | MI_EVWKHIST_ACTIV_CAUSE_DESC_C | Character (255) | None |
| Activity Type | MI_EVWKHIST_ORDR_PM_ACT_C | Character (50) | None |
| Activity Type Description | MI_EVWKHIST_ORDR_PM_ACT_DESC_C | Character (255) | None |
| Breakdown Indicator | MI_EVWKHIST_BRKDN_IND_F | Boolean | None |
| Detection Method Code | MI_EVWKHIST_DETCT_MTHD_CD_C | Character (50) | None |
| Detection Method Description | MI_EVWKHIST_DETCT_MTHD_DESC_C | Character (255) | None |
| Effect Code | MI_EVWKHIST_EFFCT_CD_C | Character (50) | None |
| Effect Description | MI_EVWKHIST_EFFCT_DESC_C | Character (50) | None |
| Event Date Description | MI_EVWKHIST_EVENT_DATE_DESC_C | Character (255) | None |
| Event Long Description | MI_EVENT_LNG_DSC_TX | Text | None |
| Event Short Description | MI_EVENT_SHRT_DSC_CHR | Character (255) | None |
| Event Start Date | MI_EVENT_STRT_DT | Date | None |
| Event Status | MI_EVWKHIST_STATUS_C | Character (50) | None |
| Event Type | MI_EVENT_TYP_CHR | Character (255) | None |
| Failure Mode Code | MI_EVWKHIST_FAILR_MODE_CD_C | Character (50) | None |
| Failure Mode Description | MI_EVWKHIST_FAILR_MODE_DESC_C | Character (255) | None |
| Failure Remarks | MI_EVWKHIST_FAILURE_REM_T | Text | None |
| Functional Loss Code | MI_EVWKHIST_FNCTNL_LOSS_CD_C | Character (50) | None |
| Functional Loss Description | MI_EVWKHIST_FNCTNL_LOSS_DESC_C | Character (50) | None |
| Maintenance Completion Date | MI_EVWKHIST_MAINT_COMPL_D | Date | None |
| Maintenance Cost UOM | MI_EVWKHIST_MAINT_CST_UOM_C | Character (10) | None |
| Maintenance Cost | MI_EVWKHIST_MAINT_CST_N | Numeric | None |
| Maintenance Start Date | MI_EVWKHIST_MAINT_START_D | Date | None |
| Mechanical Down Time | MI_EVWKHIST_MECH_DWN_TIME_N | Numeric | Calculated by system. |
| Mechanically Available Date | MI_EVWKHIST_MECH_AVAIL_D | Date | None |
| Mechanically Unavailable Date | MI_EVWKHIST_MECH_UNAVL_D | Date | None |
| Order Creation Date | MI_EVWKHIST_ORDR_CRT_DT_D | Date | None |
| Order Description | MI_EVWKHIST_ORDR_DESC_C | Character (255) | None |
| Order ID | MI_EVWKHIST_ORDR_ID_C | Character (50) | None |
| Order Maintenance Plan | MI_EVWKHIST_ORDR_MAINT_PLAN_C | Character (50) | None |
| Order Priority | MI_EVWKHIST_ORDR_PRTY_C | Character (50) | None |
| Order Priority Description | MI_EVWKHIST_ORDR_PRTY_DESC_C | Character (255) | None |
| Order Reference Date | MI_EVWKHIST_ORDR_REF_DT_D | Date | None |
| Order System Condition | MI_EVWKHIST_ORDR_SYS_COND_C | Character (50) | None |
| Order System Condition Description | MI_EVWKHIST_ORDR_SYS_CND_DES_C | Character (255) | None |
| Order System Status | MI_EVWKHIST_ORDR_SYS_STAT_C | Character (255) | None |
| Order Type Code | MI_EVWKHIST_ORDR_TYP_CD_C | Character (50) | None |
| Order Type Description | MI_EVWKHIST_ORDR_TYP_DESC_C | Character (50) | None |
| Order User Status | MI_EVWKHIST_ORDR_USER_STAT_C | Character (255) | None |
| PM Number | MI_EVWKHIST_PM_NBR_C | Character (255) | None |
| Production Cost | MI_EVWKHIST_PRDN_CST_N | Numeric | None |
| Request ID | MI_EVWKHIST_RQST_ID_C | Character (50) | None |
| Request Creation Date | MI_EVWKHIST_RQST_CRT_DT_D | Date | None |
| Request Description | MI_EVWKHIST_RQST_DESC_C | Character (255) | None |
| Request Priority | MI_EVWKHIST_RQST_PRTY_C | Character (50) | None |
| Request Priority Description | MI_EVWKHIST_RQST_PRTY_DESC_C | Character (255) | None |
| Request System Status | MI_EVWKHIST_RQST_SYS_STAT_C | Character (255) | None |
| Request Type Code | MI_EVWKHIST_RQST_TYP_CD_C | Character (50) | None |
| Request Type Description | MI_EVWKHIST_RQST_TYP_DESC_C | Character (255) | None |
| Request User Status | MI_EVWKHIST_RQST_USER_STAT_C | Character (255) | None |
| Scheduled Completion Date | MI_EVWKHIST_SCHED_COMPL_D | Date | None |
| Scheduled Start Date | MI_EVWKHIST_SCHED_START_D | Date | None |
| Target Completion Date | MI_EVWKHIST_TARGET_COMPL_D | Date | None |
| Target Start Date | MI_EVWKHIST_TARGET_START_D | Date | None |
| Work History Type | MI_EVWKHIST_WORK_HIST_TYPE_C | Character (50) | None |
| Work Order Priority | MI_EVWKHIST_WO_PRIORTY_N | Numeric | None |
| Site Reference Name | MI_SITE_NAME | Character (50) | None |
WorkHistoryToWHDetails Worksheet
On the WorkHistoryToWHDetails worksheet, you will find work history and work history detail fields.
Note: Each row in this worksheet represents a unique record. You should not include the same asset more than once.
| Field ID | Field Caption | Data Type (Length) | Comments |
|---|---|---|---|
| Event ID | MI_EVWKHIST|MI_EVENT_ID | Character (255) | Generated by the system, and is not loaded. |
| CMMS System | MI_EVWKHIST|MI_EVWKHIST_SAP_SYSTEM_C | Character (50) | None |
| Work Detail History ID | MI_DTWKHIST|MI_DTWKHIST_EVNT_DTL_ID_C | Character (50) | None |
| CMMS System | 'MI_DTWKHIST|MI_DTWKHIST_SAP_SYSTEM_C | Character (50) | None |
| Work History ID | MI_DTWKHIST|MI_DTWKHIST_WRK_HISTRY_ID_C | Character (50) | None |
| Work History Detail Description | MI_DTWKHIST|MI_DTWKHIST_EVNT_DTL_DESC_C | Character (255) | None |
| Order ID | MI_DTWKHIST|MI_DTWKHIST_ORDR_ID_C | Character (50) | None |
| Request ID | MI_DTWKHIST|MI_DTWKHIST_RQST_ID_C | Character (50) | Request ID from the associated order ID on the WH record, if not work order. |
| Cause Code | MI_DTWKHIST|MI_DTWKHIST_CAUSE_CD_C | Character (50) | None |
| Cause Description | 'MI_DTWKHIST|MI_DTWKHIST_CAUSE_DESC_C | Character (255) | None |
| Condition Code | MI_DTWKHIST|MI_DTWKHIST_CNDTN_CD_C | Character (20) | None |
| Condition Description | MI_DTWKHIST|MI_DTWKHIST_CNDTN_DESC_C | Character (255) | None |
| Detail Narrative | MI_DTWKHIST|MI_DTWKHIST_DTL_NARTV_T | Text | None |
| Maintainable Item Code | MI_DTWKHIST|MI_DTWKHIST_MAINT_ITEM_CD_C | Character (50) | None |
| Maintainable Item Description | MI_DTWKHIST|MI_DTWKHIST_MAINT_ITEM_DESC_C | Character (255) | None |
| Maintenance Action Code | MI_DTWKHIST|MI_DTWKHIST_MAINT_ACTN_CD_C | Character (50) | None |
| Maintenance Action Description | MI_DTWKHIST|MI_DTWKHIST_MAINT_ACTN_DESC_C | Character (255) | None |
| Equipment ID | MI_DTWKHIST|MI_DTWKHIST_ASST_ID_C | Character (50) | None |
| Functional Location ID | MI_DTWKHIST|MI_DTWKHIST_LOC_ID_C | Character (50) | None |
| Site Reference Name | MI_DTWKHIST|MI_SITE_NAME | Character (50) | None |
| Sub Object Number | MI_DTWKHIST|MI_DTWKHIST_SUB_OBJECT_NUM_C | Character (50) | None. |
WorkHistoryToEquipment Worksheet
| Field ID | Filed Caption | Data Type (Length) | Comments |
|---|---|---|---|
| Event ID | MI_EVWKHIST|MI_EVENT_ID | Character (255) | None |
| CMMS System | 'MI_EVWKHIST|MI_EVWKHIST_SAP_SYSTEM_C | Character (50) | None |
| Equipment ID | 'MI_EQUIP000|MI_EQUIP000_EQUIP_ID_C | Character (50) | None |
| CMMS System | 'MI_EQUIP000|MI_EQUIP000_SAP_SYSTEM_C | Character (50) | None |
WorkHistoryToFLOCs Worksheet
| Field ID | Filed Caption | Data Type (Length) | Comments |
|---|---|---|---|
| Event ID | MI_EVWKHIST|MI_EVENT_ID | Character (255) | None |
| CMMS System | 'MI_EVWKHIST|MI_EVWKHIST_SAP_SYSTEM_C | Character (50) | None |
| Functional Location Internal | 'MI_FNCLOC00|MI_FNCLOC00_INTERNAL_ID_C | Character (50) | None |
| CMMS System | 'MI_FNCLOC00|MI_FNCLOC00_SAP_SYSTEM_C | Character (50) | None |