Data Loader
About the Calibration Data Loaders
Using the Calibration Data Loader, you can implement Calibration Management when you have calibration data in a legacy system, which is not supported by APM. To import data using the Calibration Data Loader, APM provides an Excel template, Calibration_DataLoader.xlsx, Calibration_Management_Functional_Test.xlsx, which supports baseline Calibration Management in APM. You must export your legacy system so that the data can be used to populate the template. The data from the template will then be imported into APM using the Calibration Data Loader.
The data loader workbook can be used in the following scenarios:
- Loading existing legacy calibration data into APM so that you can retain visibility into previous calibration results, compare the results with current and future results, and generate graphs and reports.
- Loading calibration data from a documenting process calibrator that is not supported by APM.
After importing the data, the Calibration Data Loader creates the following records in APM:
- Test Equipment
- Test Equipment Detail
- Standard Gas Cylinder
- Standard Gas Components
- Calibration Profile
- Calibration Template, Analog
- Calibration Template, Discrete
- Calibration Template, Single Component Analyzer
- Calibration Template, Multi-Component Analyzer
- Calibration Template Detail, Analyzer
- Calibration Template, Functional Test
- Calibration Template Detail, Functional Test
- Calibration Task
- Calibration, Analog
- Calibration, Discrete
- Calibration, Single Component Analyzer
- Calibration, Multi-Component Analyzer
- Calibration, Functional Test
- Calibration Results, Analog
- Calibration Results, Discrete
- Calibration Results, Analyzer
- Calibration Results, Functional Test
- Calibration Recommendation
About the Calibration Data Loaders Requirements
Before importing data using the data loader workbook, you must have completed the following steps:
- Deploy the Calibration Management module.
- Populate the Equipment, Functional Location, or custom asset to establish relationship with the families in Calibration Management.
- Enter a valid Asset ID into the data loader workbook. To do this, the Equipment, Functional Location, or custom asset must exist in the APM database.
- By default, the Standard Gas Cylinder family is not linked to any other family (except Standard Gas Component) used in Calibration Management. If you want to create Standard Gas Cylinder and Standard Gas Component records using the Data Loader, and link them to Equipment, Functional Location, or custom asset, then you must define the relationship using the Has Standard Gas relationship family by creating the following relationship definition:
- Predecessor: Equipment, Functional Location, or custom asset
- Predecessor Cardinality: Zero or many
- Successor: Standard Gas Cylinder
- Successor Cardinality: Zero or Many
- The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role.
About the Calibration Data Loaders Data Model
The Calibration Data Loader does not load the entire data model illustrated in the normal help documentation. The following data model illustrates the records that the Data Loader supports. Equipment, Functional Location, or custom asset records, illustrated in green, must exist prior to importing data.
About the Calibration Data Loader General Loading Strategy
The imported data must load in a specific sequence in order to successfully populate fields, to create records, and to link them to the predecessor and/or successor records.
Best Practices
When importing data using the data loader workbook, you must use the following best practices:
- ID fields (Row 2 of each worksheet) must not include special characters (other than underscores) or spaces.
- Columns (including columns representing custom fields) in the worksheets should be formatted as Text.
- You should not try to create and update a component in the same data loader workbook.
- You must consider the rules described in the Workbook Layout and Use section of this document while using the Calibration Data Loader.
Load Sequence
The data load is performed in the following sequence:
- The Batch worksheet is processed. All the records that contain the same batch number are uploaded together.
- The Test Equipment worksheet is processed. The Data Loader searches for the record that you have specified in the Equipment ID column. If the record exists, it is updated. Otherwise, a Test Equipment is created.
- The Test Equipment History worksheet is processed. If a Test Equipment History record exists for the Test Equipment specified in the Parent ID column, it is deleted, and a new Test Equipment History record is created based on the details you provide in this worksheet.
- The Standard Gas Cylinder worksheet is processed. The Data Loader searches for the record that you have specified in the Standard Gas Cylinder ID column. If the record exists, it is updated. Otherwise, a Standard Gas Cylinder is created.
- The Standard Gas Component worksheet is processed. If a Standard Gas Component record exists for the Standard Gas Cylinder specified in the Parent Key column, it is deleted, and a new Standard Gas Component record is created based on the details you provide in this worksheet.
- The Profile Template worksheet is processed. The Data Loader searches for the record that you have specified in the Template ID column. If the record exists, it is updated. Otherwise, depending on the value in the Calibration Type column, one of the following records is created:
- Calibration Template, Analog
- Calibration Template, Discrete
- Calibration Template, Single Component Analyzer
- Calibration Template, Multi-Component Analyzer
- Calibration Template, Functional Test
- The Calibration Profile worksheet is processed. The Data Loader searches for the record that you have specified in the Profile ID column. If the record exists, it is updated. Otherwise, a Calibration Profile is created and linked to the template that you have specified in the Profile Template column.
- The Analog Template, Discrete Template, Single Component Template, Multi Component Template and Functional Test Template worksheets are processed. The Data Loader searches for the records that you have specified in the Template ID column. If the records exist, they are updated. Otherwise, the following records are created:
- Calibration Template, Analog
- Calibration Template, Discrete
- Calibration Template, Single Component Analyzer
- Calibration Template, Multi-Component Analyzer
- Calibration Template, Functional Test
These records are linked to the profile and Equipment, Functional Location, or custom asset you have specified in the Profile ID and Asset ID columns respectively.
- The Single Comp Temp Detail worksheet is processed. If a Calibration Template Detail, Analyzer record exists for the template specified in the Template Parent ID column, it is updated. Otherwise, it is created and linked to the Calibration Template, Single Component Analyzer record that you have specified in the Template Parent ID column.
- The Functional Test Detail worksheet is processed. If Calibration Template Detail, Functional Test record exists for the template specified in the Template Parent ID column, it is updated. Otherwise. It is created and linked to the Calibration Template, Functional Test record that you have specified in the Template Parent ID column Formatted: Font: Bold, Complex Script Font: Bold ©
- The Calibration Task worksheet is processed. The Data Loader searches for the record that you have specified in the Task ID column. If the record exists, it is updated. Otherwise, a Calibration Task is created and linked to the Equipment, Functional Location, or custom asset that you have specified in the Asset ID column and the Calibration Template that you have specified in the Calibration Template ID column.
- The Calibration Event worksheet is processed. The Data Loader searches for the record that you have specified in the Event ID column. If the record exists, it is updated. Otherwise, one of the following records is created for each row:
- Calibration, Analog
- Calibration, Discrete
- Calibration, Single Component Analyzer
- Calibration, Multi-Component Analyzer
- Calibration, Functional Test
The record is linked to the Equipment, Functional Location, or custom asset and Test Equipment that you have specified in the Asset ID, Test Equipment ID No 1, Test Equipment ID No 2, and Test Equipment ID No 3 columns respectively.
- The Calibration Result worksheet is processed. For the Calibration record specified in the Event ID column, if a Calibration Results record exists with the sequence:
- If the value in the Calibration Results Family ID column is MI_CRAN0000, and the Calibration Results, Analog record that you have specified in the Event ID and Calibration Sequence Number columns exists, then the Calibration Results, Analog record is updated. Otherwise, it is created and linked to the Calibration, Analog record that you have specified in the Parent Key (Analog) column.
- If the value in the Calibration Results Family ID column is MI_CRDS0000, and the Calibration Result, Discrete record that you have specified in the Event ID and Calibration Sequence Number columns exists, then the Calibration Result, Discrete record is updated. Otherwise, it is created and linked to the Calibration, Discrete record that you have specified in the Parent Key (Discrete) column.
- If the value in the Calibration Results Family ID column is MI_CRANZR00, and the Calibration Results, Analyzer record that you have specified in the Event ID and Calibration Sequence Number columns exists, then the Calibration Results, Analyzer record is updated. Otherwise, it is created and linked to the Calibration, Analyzer Single Component or the Calibration, Analyzer Multi-Component record that you have specified in the Parent Key(Single/Multi Component) column.
- If the Calibration Result from Calibration_Management_Functional_Test.xlsx is processed, and the Calibration Results, Functional Test record that you have specified with the Event ID and Calibration Sequence Number columns exist, then the Calibration Results, Functional Test record is updated. Otherwise, it is created and linked to the Calibration, Functional Test record that you have specified in the Event ID column.
- The Calibration Recommendation worksheet is processed. The Data Loader searches for the record that you have specified in the Recommendation ID column. If the record exists, it is updated. Otherwise, it is created and linked to the Equipment, Functional Location, or custom asset and Calibration records that you have specified in the Asset ID and Event ID columns respectively.
About the Calibration Data Loader Workbook Layout and Use
To import data using the Calibration Data Loader, APM provides the data loader workbook (Calibration.xlsx and Calibration-Functional Test.xlsx) that supports baseline Calibration Management in APM. You must use this workbook to import data. You can modify the workbook to include custom fields used by your organization.
The following table provides a list of the worksheets that are included in the data loader workbook (Calibration.xlsx):
| Worksheet | Description |
|---|---|
| Batch | This worksheet is used to define the batches. Data is imported in batches. All the records that are assigned a particular batch number will be imported together. If a record in a batch is not imported, then none of the records in the batch are imported. |
| Test Equipment |
This worksheet is used to create or update Test Equipment records. |
| Test Equipment History |
This worksheet is used to create Test Equipment History records. If a Test Equipment History record with the same ID exists, it is deleted, and a new one is created based on the values you enter in this worksheet. |
| Standard Gas Cylinder | This worksheet is used to create or update Standard Gas Cylinder records. |
| Standard Gas Component | This worksheet is used to create Standard Gas Component records. If a Standard Gas Component record with the same ID exists, it is deleted, and a new one is created based on the values you enter in this worksheet. |
| Profile Template |
This worksheet is used to create or update Calibration Profile Templates records. |
| Calibration Profile |
This worksheet is used to create or update Calibration Profile records. |
| Analog Template |
This worksheet is used to create or update Calibration Template, Analog records. |
| Discrete Template | This worksheet is used to create or update Calibration Template, Discrete records. |
| Single Component Template | This worksheet is used to create or update Calibration Template, Single Component Analyzer records. |
| Multi Component Template | This worksheet is used to create or update Calibration Template, Multi-Component Analyzer records. |
| Single Comp Temp Detail | This worksheet is used to create or update Calibration Template Detail, Analyzer records. Note: You can use the same worksheet to create or update Calibration Template Detail, Analyzer records for a profile template or an applied template. |
| Calibration Task | This worksheet is used to create or update Calibration Task records. |
| Calibration Event | This worksheet is used to create or update the following records:
|
| Calibration Result | For manual calibration, this worksheet is used to create or update the following records:
You cannot, however, create or update the aforementioned records for an automated calibration. |
| Calibration Recommendation | This worksheet is used to create or update Calibration Recommendation records. |
| (Picklist) | This worksheet provides a list of valid values available for fields that have pick lists. When you load data using the data loader, the data in this worksheet is not loaded. |
The following table provides a list of the worksheets that are included in the data loader workbook (Calibration-Functional Test.xlsx):
| Worksheet | Description |
|---|---|
| ProfileTemplate | This worksheet is used to create or update Calibration Profile Templates records. |
| Functional Test Detail | This worksheet is used to create or update Calibration Template Detail, Functional Test records. |
| Calibration Profile | This worksheet is used to create or update Calibration Profile records. |
| Functional Test Template | This worksheet is used to create or update Calibration Template, Functional Test records. |
| Calibration Task | This worksheet is used to create or update CalibrationTask records. |
| Calibration Event | This worksheet is used to create or update Calibration, Functional Test records. |
| Calibration Result | This worksheet is used to create or update Calibration Results, Functional Test records. |
| Calibration Recommendation | This worksheet is used to create or update Calibration Recommendation records. |
Color Coding
Certain columns on the worksheets have different functions and requirements. To illustrate this, certain columns are color-coded. The following table lists the colors and what they represent.
|
Color |
Description |
Comments |
|---|---|---|
| Grey |
Lookup Fields |
Indicates columns that contain values that are used by the Calibration Management Data Loader to look up and create records. If these columns are removed from the worksheets, the data load will fail. While the worksheets require that these columns be present, values are not necessarily required in these columns. |
| Red | Fields Required for Calculation | Indicates columns that contain values that are required to perform calculations. Some cells only require values in certain cases. Such cases are found in parentheses in the first row of each worksheet. |
| Blue | Recommended Fields | Indicates columns that are recommended to contain values. |
| Green | Custom Fields | Indicates columns where you can specify custom fields. |
Limitations
The Calibration Data Loader has the following limitations:
- You must use the data loader workbook. If you modify the format of the values in columns in any of the worksheets, you will not be able to import data.
- The values that you enter in the data loader workbook are case-sensitive.
-
If you reimport data, the records that have been created by the Calibration Data Loader will be updated. Therefore, while reimporting data, if you remove the data for a field in the data loader workbook, the value for the corresponding field in APM will be blank.
Worksheet Details
The workbook Calibration.xlsx has following worksheets:
Batch
This worksheet is used to define batches.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must be unique. Enter a batch number. Data related to all the rows that contain the same batch number in the remaining worksheets is imported in a single batch. |
Test Equipment Worksheet
The Test Equipment worksheet stores the details of the Test Equipment records.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
|
Equipment ID |
MI_TESTEQUIP_EQUIP_ID_C |
Character (50) |
A value is required and must be unique. This value identifies the Test Equipment. |
|
Serial Number |
MI_TESTEQUIP_SN_C |
Numeric |
A value is required. |
|
Certification Interval |
MI_TESTEQUIP_CERT_INTV_N |
Numeric |
A value is required. |
|
Certification Units |
MI_TESTEQUIP_CERT_UNITS_C |
Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_TIME_UNITS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Model Number |
MI_TESTEQUIP_MOD_NO_C |
Character (50) |
A value is required. |
|
Manufacturer |
MI_TESTEQUIP_MFR_C |
Character (50) |
A value is required. |
|
Last Certification Date |
MI_TESTEQUIP_CERT_DATE_D |
Date |
A value is required. Enter the value in the following format: YYYY-MM-DD HH:mm:ss |
| Site Reference Name | MI_SITE_NAME | Character (255) |
Important: Site Reference records must preexist in APM. The data loader does not create Site Reference records, but simply provides foreign key data in the asset records, as determined in the source workbook. If the site reference record does not preexist, then you will receive an error.
Note: Only super users are permitted to update Site Reference records.
|
|
Assigned To |
MI_TESTEQUIP_ASSIGNED_TO_C |
Character (50) |
None |
|
Category |
MI_TESTEQUIP_SAP_CATEG_C |
Character (50) |
None |
|
Certification Supplier is ISO/IEC 17025 Centified |
MI_TESTEQUIP_CERT_SUPP_CERT_C |
Character (5) |
None |
|
Class |
MI_TESTEQUIP_SAP_CLASS_C |
Character (50) |
None |
|
NIST Traceability Required |
MI_TESTEQUIP_NIST_REQD_C |
Character (5) |
None |
|
Purchase Date |
MI_TESTEQUIP_PRCH_D |
Date |
Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
|
Purchase Order Number |
MI_TESTEQUIP_PO_NO_C |
Character (50) |
None |
|
Type |
MI_TESTEQUIP_OBJ_TYP_C |
Character (50) |
None |
|
Last Check Date |
MI_TESTEQUIP_LST_CHK_DATE_D |
Date |
Enter the value in the following format: YYYY-MM-DD HH:mm:ss |
|
Check Interval |
MI_TESTEQUIP_CHECK_INTV_N |
Numeric |
None |
|
Check Interval Units |
MI_TESTEQUIP_CHK_INTV_UNITS_C |
Character (50) |
This field is required only if the Check Interval field contains a value. This column may only contain one of the System Code IDs in the MI_TIME_UNITS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Description |
MI_TESTEQUIP_DESCR_C |
Character (255) |
None |
|
Vendor |
MI_TESTEQUIP_EQUIP_VNDR_C |
Character (50) |
None |
|
Maintenance Plant |
MI_TESTEQUIP_MAINT_PLANT_C |
Character (50) |
None |
Test Equipment History Worksheet
The Test Equipment History worksheet stores the details of the Test Equipment History records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric | A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Parent ID | MI_TST_EQUIP_HIST_PARE_KEY_N | Character (50) | A value is required. This cell may only contain a value that exists in the list in the Test Equipment ID field for Test Equipment records. |
| Certification Date | MI_TST_EQUIP_HIST_CERT_DT_D | Date | A value is required. Enter the value in the following format: YYYY-MM-DD HH:mm:ss |
| Certification Number | MI_TST_EQUIP_HIST_CERT_NUM_C | Character (50) | A value is required. |
| Supplier | MI_TST_EQUIP_HIST_SUPPL_C | Character | A value is required. |
| Entered By | MI_TST_EQUIP_HIST_ENT_BY_C | Character (50) | A value is required. |
| Date Created | MI_TST_EQUIP_HIST_DATE_C | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
Standard Gas Cylinder Worksheet
The Standard Gas Cylinder worksheet stores the details of the Standard Gas Cylinder records.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Standard Gas Cylinder ID | MI_SG000000_CYL_ID | Character (50) | A value is required. |
| Site Reference Name | MI_SITE_NAME | Character (50) | A value is required. |
| Standard Gas Cylinder Description | MI_SG000000_CYL_DESCR_C | Character (255) | None |
| Minimum Cylinder Pressure | MI_SGCY0000_MIN_CYL_PRES_N | Numeric | None |
| Actual Sample Volume | MI_SGCY0000_SMPL_VOL_N | Numeric | None |
| Laboratory Analysis Number | MI_SGCY0000_LAB_NBR_C | Character (50) | None |
| Cylinder Connection Number | MI_SGCY0000_CYL_CONN_C | Character (25) | This column may only contain one of the System Code IDs in the MI GAS CYLINDER CONNECTION NUMBER System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Cylinder Type | MI_SGCY0000_CYL_TYP_C | Character (50) | This column may only contain one of the System Code IDs in the MI GAS CYLINDER TYPE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Cylinder Manufacturer | MI_SGCY0000_CYL_MFR_C | Character (50) | None |
| Cylinder Size | MI_SGCY0000_CYL_SZ_C | Character (25) | This column may only contain one of the System Code IDs in the MI GAS CYLINDER SIZE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Expiration Date | MI_SGCY0000_CYL_EXP_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| In Service Date | MI_SGCY0000_CYL_IN_SRVC_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| Cylinder Owner | MI_SGCY0000_CYL_OWNR_C | Character (50) | None |
Standard Gas Component Worksheet
The Standard Gas Component worksheet stores details of Standard Gas Components.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Standard Component Name | MI_SGCM0000_CMPNT_NM_C | Character (50) | A value is required. This column may only contain one of the System Code IDs in the MI CHEMICAL COMPONENTS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Standard Analytical Result | MI_SGCM0000_ANLYTCL_RSLT_N | Numeric | A value is required. |
| Standard Component UOM | MI_SGCM0000_CMPNT_UOM_C | Character (15) | A value is required. This column may only contain one of the System Code IDs in the UOME System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Parent Key | MI_SGCM0000_PARE_KEY_N | Numeric | A value is required. Enter the ID of the Standard Gas Cylinder. It will be converted to the parent key when you import data. |
| Standard Gas Cylinder Description | MI_SG000000_CYL_DESCR_C | Character (255) | None |
| Standard Blend Tolerance | MI_SGCM0000_BLND_TOL_N | Numeric | None |
| Standard Requested Value | MI_SGCM0000_REQ_VAL_N | Numeric | None |
| Standard Gas Cylinder ID | MI_SG000000_CYL_ID | Character (50) | Enter the ID of the Standard Gas Cylinder. |
| Standard Balance Content | MI_SGCM0000_BLNC_CNTNT_L | Boolean | Enter True or False. |
Profile Template Worksheet
The Profile Template worksheet stores the details of the Calibration Profile Template records.
|
Field Caption |
Field ID |
Data Type (Length) |
Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
|
Template ID |
MI_TM000000_ID |
Character (255) |
A value is required and must be unique. This value identifies the Template. | ||||||||||
| Calibration Family ID | Family_ID | Character (50) | A value is required. Enter one of the following values based on the calibration type:
| ||||||||||
| Calibration Type | MI_TMCA0000_CAL_TYP_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_TYPE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Error Assessment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
A value is required in the Calibration Template, Analog records, Calibration Template, Discrete, and Calibration Template, Single Component Analyzer records. This column may only contain one of the System Code IDs in the CALIBRATION_ERROR_ASSESSMENT System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
|
Input Type |
MI_TMCA0000_INPUT_TYP_C |
Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
|
Output Type |
MI_TMCA0000_OUTPU_TYP_C |
Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
|
Max Error Limit |
MI_TMCA0000_ERR_LIM_N |
Numeric |
A value is required. | ||||||||||
| Primary Input LRV | MI_TMCA0000_PRI_IN_LRV_N | Numeric | A value is required. | ||||||||||
| Primary Input URV | MI_TMCA0000_PRI_IN_URV_N | Numeric | A value is required. | ||||||||||
|
Primary Input Range Units |
MI_TMCA0000_PRI_IN_RV_UOM_C |
Character (10) |
A value is required. Depending on the value in the Calibration Type field, this field contains one of the following System Code Tables:
| ||||||||||
|
Primary Output LRV (Analog) |
MI_TMCA0000_PRI_OUT_LRV_N |
Numeric |
A value is required for analog calibration. | ||||||||||
|
Primary Output URV (Analog) |
MI_TMCA0000_PRI_OUT_URV_N |
Numeric |
A value is required for an analog calibration.
| ||||||||||
| Primary Output Units | MI_TMCA0000_PRI_OUT_UOM_C | Character (10) |
A value is required. Depending on the value in the Calibration Type field, this field contains one of the following System Code Tables:
| ||||||||||
| SW 1 Setpoint (Discrete) | MI_TMCA0000_SW1_SP_N | Numeric | A value is required for discrete calibration. | ||||||||||
|
Activate Switch 1 (Discrete) |
MI_TMCA0000_SPEC_INC_DEC_01_C | Numeric | A value is required for discrete calibration. | ||||||||||
| SW 1 Contact State | MI_TMCA0000_SW1_CNTCT_ST_C | Numeric |
A value is required. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. This field is enabled only when a value exists in the Calibration Strategy field. | ||||||||||
| Reset Set Point | MI_TMCA0000_RESET_SET_POINT_N | Numeric | A value is required for discrete calibration using the GE Druck calibrators. | ||||||||||
| Ramp Time | MI_TMCA0000_RAMP_TIME_N | Numeric | A value is required for discrete calibration using the GE Druck calibrators. | ||||||||||
| Repeat Count | MI_TMCA0000_REP_COUNT_N | Numeric | A value is required for discrete calibration using the GE Druck calibrators. | ||||||||||
| Calibration Strategy (Single Component) | MI_TMCA0000_STRATEGY_C | Character (25) | A value is required for single component analyzer calibration and must match the ID of an existing Calibration Strategy. | ||||||||||
| Template State | MI_TM000000_STATE_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Loop Power | MI_TMCA0000_LOOP_PWR_C | Character (15) |
If using the Fluke calibrator, this column may only contain one of the System Code IDs defined by the FLUKE POWER SOURCE value in the MI_CALIBRATION_REFERENCES System Code Table. If using the GE Druck calibrator, this column may only contain one of the System Code IDs in the MI_CALIBRATION_YES_OR_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Manual Entered Input Values | MI_TMCA0000_IN_MEV_L | Boolean | Enter True or False. | ||||||||||
| Manual Entered Output Values | MI_TMCA0000_OUT_MEV_FLG | Boolean | Enter True or False. | ||||||||||
| Performs Square Root | MI_TMCA0000_PERF_SQRT_C | Character (1) |
This column may only contain one of the System Code IDs in the MI_YES_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Enable Automated Calibrations | MI_TMCA0000_ENABL_AUTO_CAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Lower Range Value | MI_TMCA0000_CUST_IN_LRV_N | Numeric | None | ||||||||||
| Custom Input Upper Range Value | MI_TMCA0000_CUST_IN_URV_N | Numeric | None | ||||||||||
| Custom Output Lower Range Value | MI_TMCA0000_CUST_OUT_LRV_N | Numeric | None | ||||||||||
| Custom Output Upper Range Value | MI_TMCA0000_CUST_OUT_URV_N | Numeric | None | ||||||||||
| Custom Input Range UOM | MI_TMCA0000_CUST_IN_RN_UOM_C | Character (50) |
A value is required. Depending on the value in the Calibration Type field, this field contains one of the following System Code Tables:
| ||||||||||
| Custom Output Range UOM | MI_TMCA0000_CUST_OUT_RN_UOM_C | Character (50) |
A value is required. Depending on the value in the Calibration Type field, this field contains one of the following System Code Tables:
| ||||||||||
| TC Linear | MI_TMCA0000_TC_LIN_F | Boolean | Enter True or False. | ||||||||||
| RTD Wiring Configuration | MI_TMCA0000_RTD_WIR_CNFG_C | Character (50) |
This column may only contain one of the System Code IDs by the RTD Wiring Configuration value in the MI_CALIBRATION_REFERENCES. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Linear TC LRV | MI_TMCA0000_LIN_TC_LRV_N | Numeric | None | ||||||||||
| Linear TC URV | MI_TMCA0000_LIN_TC_URV_N | Numeric | None | ||||||||||
| Custom Output Values | MI_TMCA0000_CUST_OUT_VAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Values | MI_TMCA0000_CUST_IN_VAL_F | Boolean | Enter True or False. | ||||||||||
| Temperature Element Type | MI_TMCA0000_TMP_EL_TP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
Calibration Profile Worksheet
The Calibration Profile worksheet stores the details of the Calibration Profile records.
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
| Profile ID | MI_CAL_PROF_PROF_ID_CHR | Character (255) | A value is required and must be unique. This value identifies the Calibration Profile. | ||||||||||
| Device Type | MI_CAL_PROF_DEVI_TYPE_C | Character (255) | A value is required. | ||||||||||
| Profile Template | MI_CAL_PROF_PROF_TEMP_CHR | Character (50) | A value is required. | ||||||||||
| Calibration Strategy | MI_CAL_PROF_CALI_STRA_C | Character (50) |
A value is required and must match the ID of an existing Calibration Strategy. | ||||||||||
| Profile Template Family ID | MI_CAL_PROF_TEMP_FMLY_ID_CHR | Character (50) |
A value is required. Enter one of the following values based on the calibration type:
|
Analog Template Worksheet
The Analog Template worksheet stores the details of the Calibration Template, Analog records.
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric | A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
| Template ID | MI_TM000000_ID | Character (255) | A value is required and must be unique. This value identifies the Calibration Template, Analog record. After importing data, the value in this field (in the corresponding record in APM) will be updated to include the values in the following fields:
| ||||||||||
| Input Type | MI_TMCA0000_INPUT_TYP_C | Character (50) | A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Output Type | MI_TMCA0000_OUTPU_TYP_C | Character (50) | This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Max Error Limit | MI_TMCA0000_ERR_LIM_N | Numeric | A value is required. | ||||||||||
| Primary Input LRV | MI_TMCA0000_PRI_IN_LRV_N | Numeric | A value is required. | ||||||||||
| Primary Input URV | MI_TMCA0000_PRI_IN_URV_N | Numeric | A value is required. | ||||||||||
| Primary Input Range Units | MI_TMCA0000_PRI_IN_RV_UOM_C | Character (10) |
A value is required. Depending on the value in the Calibration Type field, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Primary Output LRV | MI_TMCA0000_PRI_OUT_LRV_N | Numeric | A value is required for analog and single component analyzer calibrations. | ||||||||||
| Primary Output URV | MI_TMCA0000_PRI_OUT_URV_N | Numeric | A value is required for analog and single component analyzer calibrations. | ||||||||||
| Primary Output Units | MI_TMCA0000_PRI_OUT_UOM_C | Character (10) | A value is required. Depending on the value in the Calibration Type field, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Asset ID | ASSET_ID | Numeric | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. | ||||||||||
| Profile ID | MI_CAL_PROF_PROF_ID_CHR | Character (255) | A value is required and must be unique. This value identifies the Calibration Profile. Note: The Profile ID will create a relationship between this Applied Template and the Profile. | ||||||||||
| Error Assessment | MI_TMCA0000_ERR_ASSES_C | Character (50) | A value is required. This column may only contain one of the System Code IDs in the CALIBRATION_ERROR_ASSESSMENT System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Template State | MI_TM000000_STATE_C | Character (50) | This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Loop Power | MI_TMCA0000_LOOP_PWR_C | Character (15) | If using the Fluke calibrator, this column may only contain one of the System Code IDs defined by the FLUKE POWER SOURCE value in the MI_CALIBRATION_REFERENCES System Code Table. If using the GE Druck calibrator, this column may only contain one of the System Code IDs in the MI_CALIBRATION_YES_OR_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Manual Entered Input Values | MI_TMCA0000_IN_MEV_L | Boolean | Enter True or False. | ||||||||||
| Manual Entered Output Values | MI_TMCA0000_OUT_MEV_FLG | Boolean | Enter True or False. | ||||||||||
| Performs Square Root | MI_TMCA0000_PERF_SQRT_C | Character (1) | This column may only contain one of the System Code IDs in the MI_YES_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Enable Automated Calibrations | MI_TMCA0000_ENABL_AUTO_CAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Lower Range Value | MI_TMCA0000_CUST_IN_LRV_N | Numeric | None | ||||||||||
| Custom Input Upper Range Value | MI_TMCA0000_CUST_IN_URV_N | Numeric | None | ||||||||||
| Custom Output Lower Range Value | MI_TMCA0000_CUST_OUT_LRV_N | Numeric | None | ||||||||||
| Custom Output Upper Range Value | MI_TMCA0000_CUST_OUT_URV_N | Numeric | None | ||||||||||
| Custom Input Range UOM | MI_TMCA0000_CUST_IN_RN_UOM_C | Character (50) |
A value is required. Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Custom Output Range UOM | MI_TMCA0000_CUST_OUT_RN_UOM_C | Character (50) |
A value is required. Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| TC Linear | MI_TMCA0000_TC_LIN_F | Boolean | Enter True or False. | ||||||||||
| RTD Wiring Configuration | MI_TMCA0000_RTD_WIR_CNFG_C | Character (50) | This column may only contain one of the System Code IDs by the RTD Wiring Configuration value in the MI_CALIBRATION_REFERENCES. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Linear TC LRV | MI_TMCA0000_LIN_TC_LRV_N | Numeric | None | ||||||||||
| Linear TC URV | MI_TMCA0000_LIN_TC_URV_N | Numeric | None | ||||||||||
| Custom Output Values | MI_TMCA0000_CUST_OUT_VAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Values | MI_TMCA0000_CUST_IN_VAL_F | Boolean | Enter True or False. | ||||||||||
| Temperature Element Type | MI_TMCA0000_TMP_EL_TP_C | Character (50) | This column may only contain one of the System Code IDs in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
Discrete Template Worksheet
The Discrete Template worksheet stores the details of the Calibration Template, Discrete records.
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
|
Template ID |
MI_TM000000_ID |
Character (255) |
A value is required and must be unique. This value identifies the Template. After importing the data, the value in this field (in the corresponding record in APM) will be updated to include the values in the following fields:
| ||||||||||
| Input Type |
MI_TMCA0000_INPUT_TYP_C |
Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Output Type |
MI_TMCA0000_OUTPU_TYP_C |
Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Max Error Limit | MI_TMCA0000_ERR_LIM_N | Numeric | A value is required. | ||||||||||
| Primary Input LRV | MI_TMCA0000_PRI_IN_LRV_N | Numeric | A value is required. | ||||||||||
| Primary Input URV | Primary Input URV | Primary Input URV | A value is required. | ||||||||||
| Primary Input Range Units |
MI_TMCA0000_PRI_IN_RV_UOM_C |
Character (10) |
A value is required. Depending on the calibration type, this column must contain a value from one of the following System Code Tables:
| ||||||||||
| SW 1 Setpoint | MI_TMCA0000_SW1_SP_N | Numeric | A value is required. | ||||||||||
| Activate Switch 1 | MI_TMCA0000_SPEC_INC_DEC_01_C | Numeric | A value is required. | ||||||||||
| SW 1 Contact State | MI_TMCA0000_SW1_CNTCT_ST_C | Numeric | A value is required. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Reset Set Point | MI_TMCA0000_RESET_SET_POINT_N | Numeric | A value is required. | ||||||||||
| Ramp Time | MI_TMCA0000_RAMP_TIME_N | Numeric | A value is required. | ||||||||||
| Repeat Count | MI_TMCA0000_REP_COUNT_N | Numeric | A value is required. | ||||||||||
| Asset ID | ASSET_ID | Numeric | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. | ||||||||||
| Profile ID | MI_CAL_PROF_PROF_ID_CHR | Character (255) |
A value is required and must be unique. This value identifies the Calibration Profile. Note: The Profile ID will create a relationship between this Applied Template and the Profile.
| ||||||||||
| Template State | MI_TM000000_STATE_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Loop Power | MI_TMCA0000_LOOP_PWR_C | Character (15) |
If using the Fluke calibrator, this column may only contain one of the System Code IDs defined by the FLUKE POWER SOURCE value in the MI_CALIBRATION_REFERENCES System Code Table. If using the GE Druck calibrator, this column may only contain one of the System Code IDs in the MI_CALIBRATION_YES_OR_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Manual Entered Input Values | MI_TMCA0000_IN_MEV_L | Boolean | Enter True or False. | ||||||||||
| Manual Entered Output Values | MI_TMCA0000_OUT_MEV_FLG | Boolean | Enter True or False. | ||||||||||
| Performs Square Root | MI_TMCA0000_PERF_SQRT_C | Character (1) | This column may only contain one of the System Code IDs in the MI_YES_NO System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Enable Automated Calibrations | MI_TMCA0000_ENABL_AUTO_CAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Lower Range Value | MI_TMCA0000_CUST_IN_LRV_N | Numeric | None | ||||||||||
| Custom Input Upper Range Value | MI_TMCA0000_CUST_IN_URV_N | Numeric | None | ||||||||||
| Custom Output Lower Range Value | MI_TMCA0000_CUST_OUT_LRV_N | Numeric | None | ||||||||||
| Custom Output Upper Range Value | MI_TMCA0000_CUST_OUT_URV_N | Numeric | None | ||||||||||
| Custom Input Range UOM | MI_TMCA0000_CUST_IN_RN_UOM_C | Character (50) |
Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Custom Output Range UOM | MI_TMCA0000_CUST_OUT_RN_UOM_C | Character (50) |
A value is required. Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| TC Linear | MI_TMCA0000_TC_LIN_F | Boolean | Enter True or False. | ||||||||||
| RTD Wiring Configuration | MI_TMCA0000_RTD_WIR_CNFG_C | Character (50) |
This column may only contain one of the System Code IDs by the RTD Wiring Configuration value in the MI_CALIBRATION_REFERENCES. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Linear TC LRV | MI_TMCA0000_LIN_TC_LRV_N | Numeric | None | ||||||||||
| Linear TC URV | MI_TMCA0000_LIN_TC_URV_N | Numeric | None | ||||||||||
| Custom Output Values | MI_TMCA0000_CUST_OUT_VAL_F | Boolean | Enter True or False. | ||||||||||
| Custom Input Values | MI_TMCA0000_CUST_IN_VAL_F | Boolean | Enter True or False. | ||||||||||
| Temperature Element Type | MI_TMCA0000_TMP_EL_TP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Error Assessment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the CALIBRATION_ERROR_ASSESSMENT System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Primary Output Units | MI_TMCA0000_PRI_OUT_UOM_C | Character (10) |
Depending on the value in the Calibration Type field, this column may contain System Codes in one of the following System Code Tables:
|
Single Component Template Worksheet
The Single Component Template worksheet stores the details of the Calibration Template, Single Component Analyzer records.
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
| Template ID | MI_TM000000_ID | Character (255) | A value is required. | ||||||||||
| Input Type | MI_TMCA0000_INPUT_TYP_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI CALIBRATION IO TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Output Type | MI_TMCA0000_OUTPU_TYP_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI CALIBRATION IO TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Calibration Strategy | MI_TMCA0000_STRATEGY_C | Character (25) |
A value is required and must match the ID of an existing Calibration Strategy. | ||||||||||
| Primary Input LRV | MI_TMCA0000_PRI_IN_LRV_N | Numeric | A value is required. | ||||||||||
| Primary Input URV | MI_TMCA0000_PRI_IN_URV_N | Numeric | A value is required. | ||||||||||
| Primary Input Range Units | MI_TMCA0000_PRI_IN_RV_UOM_C | Character (50) |
A value is required. Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Primary Output LRV | MI_TMCA0000_PRI_OUT_LRV_N | Numeric | A value is required. | ||||||||||
| Primary Output URV | MI_TMCA0000_PRI_OUT_URV_N | Numeric | A value is required. | ||||||||||
| Primary Output Units | MI_TMCA0000_PRI_OUT_UOM_C | Character (50) |
A value is required. Depending on the calibration type, this column must contain System Codes in one of the following System Code Tables:
| ||||||||||
| Calibration Type | MI_TMCA0000_CAL_TYP_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the MI_CALIBRATION_TYPE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Asset ID | ASSET_ID | Numeric | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. | ||||||||||
| Profile ID | MI_CAL_PROF_PROF_ID_CHR | Character (255) |
A value is required and must be unique. This value identifies the Calibration Profile. Note: The Profile ID will create a relationship between this Applied Template and the Profile.
| ||||||||||
| Template Short Description | MI_TM000000_SHRT_DSC_C | Character (255) | None | ||||||||||
| Enterprise <number> Code | MI_TM000000_ERP_01_CD_C | Character (50) | None | ||||||||||
| Enterprise <number> Description | MI_TM000000_ERP_01_DESC_C | Character (255) | None | ||||||||||
| Template Long Description | MI_TM000000_LNG_DSC_T | Text | None | ||||||||||
| Template Type | MI_TM000000_TEMP_TYPE_C | Character (50) | None | ||||||||||
| Template State | MI_TM000000_STATE_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Temperature Element Type | MI_TMCA0000_TMP_EL_TP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Lock Output Range | MI_TMCA0000_LCK_OUT_RNG_F | Boolean | Enter True or False. | ||||||||||
| Manufacturer | MI_TMCA0000_MFR_C | Character (255) | None | ||||||||||
| Model Number | MI_TMCA0000_MOD_NO_C | Character (255) | None | ||||||||||
| Serial Number | MI_TMCA0000_SN_C | Character (255) | None | ||||||||||
| Refresh Equipment Data | MI_TMCA0000_REF_EQ_DA_F | Boolean | Enter True or False. | ||||||||||
| Max Error Limit | MI_TMCA0000_ERR_LIM_N | Numeric | None | ||||||||||
| Tag Description | MI_TMCA0000_TAG_DESCR_C | Character (255) | None | ||||||||||
| Local ID | MI_TMCA0000_LOCAL_ID_N | Numeric | None | ||||||||||
| Repeat Count | MI_TMCA0000_REP_COUNT_N | Numeric | None | ||||||||||
| Reset Set Point | MI_TMCA0000_RESET_SET_POINT_N | Numeric | None | ||||||||||
| Ramp Time | MI_TMCA0000_RAMP_TIME_N | Numeric | None | ||||||||||
| Error Assessment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
A value is required. This column may only contain one of the System Code IDs in the CALIBRATION_ERROR_ASSESSMENT System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
Multi Component Template Worksheet
The Multi Component Template worksheet stores the details of Calibration Template, Multi-Component Analyzer records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Template ID | MI_TM000000_ID | Character (255) | A value is required. |
| Calibration Type | MI_TMCA0000_CAL_TYP_C | Character (50) | A value is required. |
| Asset ID | ASSET_ID | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | |
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. |
| Profile ID | MI_CAL_PROF_PROF_ID_CHR | Character (255) |
A value is required and must be unique. This value identifies the Calibration Profile. Note: The Profile ID will create a relationship between this Applied Template and the Profile.
|
| Template Short Description | MI_TM000000_SHRT_DSC_C | Character (255) | None |
| Enterprise <number> Code | MI_TM000000_ERP_01_CD_C | Character (50) | None |
| Enterprise <number> Description | MI_TM000000_ERP_01_DESC_C | Character (255) | None |
| Template Type | MI_TM000000_TEMP_TYPE_C | Character (50) | None |
| Template Long Description | MI_TM000000_LNG_DSC_T | Text | None |
| Template State | MI_TM000000_STATE_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Temperature Element Type | MI_TMCA0000_TMP_EL_TP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Lock Output Range | MI_TMCA0000_LCK_OUT_RNG_F | Boolean | Enter True or False. |
| Input Type | MI_TMCA0000_INPUT_TYP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_IO_TYPES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Manufacturer | MI_TMCA0000_MFR_C | Character (255) | None |
| Model Number | MI_TMCA0000_MOD_NO_C | Character (255) | None |
| Max Error Limit | MI_TMCA0000_ERR_LIM_N | Numeric | None |
| Serial Number | MI_TMCA0000_SN_C | Character (255) | None |
| Refresh Equipment Data | MI_TMCA0000_REF_EQ_DA_F | Boolean | Enter True or False. |
| Tag Description | MI_TMCA0000_TAG_DESCR_C | Character (255) | None |
| Local ID | MI_TMCA0000_LOCAL_ID_N | Numeric | None |
| Repeat Count | MI_TMCA0000_REP_COUNT_N | Numeric | None |
| Reset Set Point | MI_TMCA0000_RESET_SET_POINT_N | Numeric | None |
| Ramp Time | MI_TMCA0000_RAMP_TIME_N | Numeric | None |
Single Comp Temp Detail Worksheet
The Single Comp Temp Detail worksheet is used to define Calibration Template Detail, Analyzer records for a Calibration Template, Single Component Analyzer record.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Template Parent ID | PARENT_ID | Character (255) | A value is required and must match the ID of a Calibration Template, Single Component Analyzer. Otherwise, all the rows in the batch are skipped. |
| Calibration Template Detail ID | MI_TD000000_ID | Character (100) | If you do not enter a value in this column, after you import data, the corresponding field is populated with a system-generated value. |
| Component Name | MI_TDCAAN00_CMPNT_NM_C | Character (255) |
This column may only contain one of the System Code IDs in the MI CHEMICAL COMPONENTS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Component Value | MI_TDCAAN00_CMPNT_VAL_N | Numeric | None |
| Component Units | MI_TDCAAN00_CMPNT_UOM_C | Character (50) |
This column may only contain one of the System Code IDs defined by the STANDARD GAS UOM value in the MI_CALIBRATION_REFERENCES System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Standard Balance Content | MI_TDCAAN00_BLNC_CNTNT_F | Boolean | Enter True or False. |
| Percent of Scale Test Point | MI_TDCAAN00_PCT_SCL_N | Numeric | None |
| Percent of Scale Sequence Number | MI_TDCAAN00_PCT_SQNC_N | Numeric | None |
| Input Up/Dn | MI_TDCAAN00_UP_DN_TP_C | Character (50) | None |
| Calibration Template Detail Description | MI_TD000000_SHRT_DESC_C | Character (255) | None |
Calibration Task Worksheet
The Calibration Task worksheet stores the details of the Calibration Task records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
|
Task ID |
MI_TASK_ID |
Character (255) |
A value is required. |
|
Asset ID |
ASSET_ID | Character (255) | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in the Asset ID Configuration for Equipment, Functional Location, or custom asset field that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. |
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. |
|
Task Assigned To |
MI_TASK_ASSGN_TO_C |
Character (50) |
None |
|
Task Description |
MI_TASK_DESC_TX |
Character |
None |
|
Task State |
MI_TASK_TASK_STATE_CHR |
Character (50) |
This column may only contain one of the System Code IDs in the CTST System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Reoccurring |
MI_TASK_REOCC_FLG |
Boolean |
Enter True or False. |
|
Route Number |
MI_TASK_ROUTE_NO_C |
Character (25) |
None |
|
Unconstrain Min/Max Dates |
MI_TASK_UNCONSTR_MN_MX_DT_FLG |
Boolean |
Enter True or False. |
|
Last Date |
MI_TASK_LAST_DATE_DT |
Date |
Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
|
Rejectable |
MI_TASK_REJEC_FLG |
Boolean |
Enter True or False. |
|
Modifiable |
MI_TASK_MODIF_FLG |
Boolean |
Enter True or False. |
|
Task Type |
MI_TASK_TASK_TYPE_CHR |
Character (50) |
None |
|
Min Interval |
MI_TASK_MIN_INTER_NBR |
Numeric |
None |
|
Desired Interval |
MI_TASK_DESIR_INTER_NBR |
Numeric |
None |
|
Desired Interval UOM |
MI_TASK_DESIR_INTER_UOM_C |
Character (50) |
This column may only contain one of the System Code IDs in the MI_STRATEGY_REFERENCE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Max Interval |
MI_TASK_MAX_INTER_NBR |
Numeric |
None |
|
Calibration Template ID |
MI_TASKCALB_CALIB_TEMPL_ID_N |
Numeric |
A value is required and must match the ID of a Calibration Template. If it does not match, the Calibration Task will still be created, but not linked to a Calibration Template. |
Calibration Event Worksheet
The Calibration Event worksheet stores details of the following records:
- Calibration, Analog
- Calibration, Discrete
- Calibration, Analyzer Single Component
- Calibration, Analyzer Multi-Component
- Calibration, Functional Test
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||||
|
Event ID |
MI_EVENT_ID |
Character (255) |
A value is required. | ||||||||||
|
Calibration Strategy |
MI_EVCALIBR_STRATEGY_C |
Character (20) |
A value is required and must match the ID of an existing Calibration Strategy.
Note: If you are creating Functional Test calibration record without defining the Functional Test templates, then add MI_EVCALIBR_STRATEGY_C field to Calibration Event worksheet in Calibration – Functional Test.xlsx file before import. | ||||||||||
| Calibration Type | MI_EVCALIBR_CALIB_TYP_C | Character (50) |
This column may only contain one of the System Code IDs in the MI_CALIBRATION_TYPE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Primary Output LRV |
MI_EVCALIBR_PRI_OUT_LRV_N |
Numeric |
A value is required. | ||||||||||
| Primary Input LRV |
MI_EVCALIBR_PRI_IN_LRV_N |
Numeric |
A value is required. | ||||||||||
| Calibration Error Limit |
MI_EVCALIBR_ERR_LIM_N |
Numeric |
A value is required. | ||||||||||
| Primary Output URV |
MI_EVCALIBR_PRI_OUT_URV_N |
Numeric |
A value is required. | ||||||||||
| Primary Input URV |
MI_EVCALIBR_PRI_IN_URV_N |
Numeric |
A value is required. | ||||||||||
| Asset ID | ASSET_ID | Numeric | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Event Family ID | Family_ID | Character |
A value is required. Depending on the calibration type, this column must contain one of the following values:
| ||||||||||
|
Primary Output Units |
MI_EVCALIBR_PRI_OUT_UOM_C |
Character (10) |
A value is required. Depending on the calibration type, this column must contain System Codes from one of the following System Code Tables:
| ||||||||||
| Primary Input Range Units | MI_EVCALIBR_PRI_IN_RV_UOM_C | Character (10) |
A value is required. Depending on the calibration type, this column must contain a value from one of the following System Code Tables:
| ||||||||||
| Event Start Date | MI_EVENT_STRT_DT | Date | A value is required. Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Calibration Template Key | MI_EVCALIBR_CAL_TMP_KEY_N | Numeric | A value is required. This column may only contain a value that exists in the list in the Template ID field for Calibration Templates. | ||||||||||
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. | ||||||||||
| Input Characteristic Curve | MI_EVCALIBR_IN_CC_CURV_C | Character (25) | This column may only contain one of the System Code IDs in the MI CHARACTERISTIC CURVE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
| Calibration Closed | MI_EVCALIBR_CAL_CLOSE_L | Boolean | Enter True or False. | ||||||||||
| Location ID | MI_EVENT_LOC_ID_CHR | Character (255) | None | ||||||||||
| Equipment Manufacturer | MI_EVCALIBR_ASST_MFG_C | Character (255) | None | ||||||||||
| Equipment Model Number | MI_EVCALIBR_ASST_MOD_NO_C | Character (255) | None | ||||||||||
|
Equipment Serial Number |
MI_EVCALIBR_ASST_SN_C |
Character (255) |
None | ||||||||||
|
Maintenance Type |
MI_EVCALIBR_MAINT_TYPE_C |
Character (25) |
This column may only contain one of the System Code IDs in the MI_MAINTENANCE_TYPE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||||
|
WO Reference (Event) |
MI_EVCALIBR_WO_NO_C |
Character (30) |
None | ||||||||||
|
Scheduled Calibration Date |
MI_EVCALIBR_SCHED_CAL_D |
Date |
Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
|
Calibration Technician |
MI_EVCALIBR_TECH_NM_C |
Character (35) |
None | ||||||||||
|
Calibration Approval By |
MI_EVCALIBR_CAL_APPR_NM_C |
Character (50) |
None | ||||||||||
| Secondary Output LRV | MI_EVCALIBR_SEC_OUT_LRV_N | Numeric | None | ||||||||||
| Secondary Output Units | MI_EVCALIBR_SEC_OUT_UOM_C | Character (10) | None | ||||||||||
| Secondary Output URV | MI_EVCALIBR_SEC_OUT_URV_N | Numeric | None | ||||||||||
| Test Equipment ID No 1 | MI_EVCALIBR_TST_EQU_ID_01_C | Character (255) | The value in this column must match the ID of a Test Equipment. | ||||||||||
| Test Equipment ID No 2 | MI_EVCALIBR_TST_EQU_ID_02_C | Character (255) | The value in this column must match the ID of a Test Equipment. | ||||||||||
| Test Equipment ID No 3 | MI_EVCALIBR_TST_EQU_ID_03_C | Character (255) | The value in this column must match the ID of a Test Equipment. | ||||||||||
| Test Equipment Manufacturer 1 | MI_EVCALIBR_TST_EQU_MFR_01_C | Character (50) | None | ||||||||||
| Test Equipment Manufacturer 2 | MI_EVCALIBR_TST_EQU_MFR_02_C | Character (50) | None | ||||||||||
| Test Equipment Manufacturer 3 | MI_EVCALIBR_TST_EQU_MFR_03_C | Character (50) | None | ||||||||||
| Test Equipment Model Number 1 | MI_EVCALIBR_TST_EQU_MDL_01_C | Character (50) | None | ||||||||||
| Test Equipment Model Number 2 | MI_EVCALIBR_TST_EQU_MDL_02_C | Character (50) | None | ||||||||||
| Test Equipment Model Number 3 | MI_EVCALIBR_TST_EQU_MDL_03_C | Character (50) | None | ||||||||||
| Test Equipment Serial Number 1 | MI_EVCALIBR_TST_EQU_SN_01_C | Character (50) | None | ||||||||||
| Test Equipment Serial Number 2 | MI_EVCALIBR_TST_EQU_SN_02_C | Character (50) | None | ||||||||||
| Test Equipment Serial Number 3 | MI_EVCALIBR_TST_EQU_SN_03_C | Character (50) | None | ||||||||||
| Test Equipment Cal. Expire 1 | MI_EVCALIBR_TST_EQ_CAL_EX_1_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Test Equipment Cal. Expire 2 | MI_EVCALIBR_TST_EQ_CAL_EX_2_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Test Equipment Cal. Expire 3 | MI_EVCALIBR_TST_EQ_CAL_EX_3_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Test Equipment Last Cal. 1 | MI_EVCALIBR_TST_EQ_LS_CAL_1_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Test Equipment Last Cal. 2 | MI_EVCALIBR_TST_EQ_LS_CAL_2_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Test Equipment Last Cal. 3 | MI_EVCALIBR_TST_EQ_LS_CAL_3_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Location Short Description | MI_EVENT_LOC_SHRT_DESC_CHR | Character (255) | None | ||||||||||
| Asset Type | MI_EVENT_ASST_TYP_CHR | Character (50) | None | ||||||||||
| Asset Short Description | MI_EVENT_ASST_DESC_CHR | Character (255) | None | ||||||||||
| Asset Category | MI_EVENT_ASST_CTGRY_CHR | Character (50) | None | ||||||||||
| Secondary Input LRV | MI_EVCALIBR_SEC_IN_LRV_N | Numeric | None | ||||||||||
| Secondary Input Range Units | MI_EVCALIBR_SEC_IN_RV_UOM_C | Character (10) | None | ||||||||||
| Secondary Input URV | MI_EVCALIBR_SEC_IN_URV_N | Numeric | None | ||||||||||
| Event End Date | MI_EVENT_END_DT | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss | ||||||||||
| Event Long Description | MI_EVENT_LNG_DSC_TX | Character | None | ||||||||||
| Actual Work Time | MI_EVENT_ACTUAL_WRK_TM_N | Numeric | None | ||||||||||
| Off Line Duration | MI_EVCALIBR_OFF_LINE_DURA_N | Numeric | None | ||||||||||
| Calibration Task ID | MI_EVCALIBR_CAL_TSK_ID_C | Character (50) | This column may contain a value that exists in the list in the Task ID field for Calibration Task records. If the value that you enter does not match the Task ID of any Calibration Task in the APM database, then this field is blank after you import data. | ||||||||||
| Test Equipment Status 1 | MI_EVCALIBR_TST_EQU_STAT_01_C | Character (50) | None | ||||||||||
| Test Equipment Status 2 | MI_EVCALIBR_TST_EQU_STAT_02_C | Character (50) | None | ||||||||||
| Test Equipment Status 3 | MI_EVCALIBR_TST_EQU_STAT_03_C | Character (50) | None | ||||||||||
| Output Characteristic Curve | MI_EVCALIBR_OUT_CC_CURV_C | Character (25) | This column may only contain one of the System Code IDs in the MI CHARACTERISTIC CURVE System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
Calibration Result Worksheet
The Calibration Result worksheet stores details of the following records:
- Calibration Results, Analog
- Calibration Result, Discrete
- Calibration Results, Analyzer
| Field Caption | Field ID | Data Type (Length) | Comments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
BATCH_ID |
BATCH_ID |
Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. | ||||||||
|
As Found Error |
MI_CALRESLT_AFE_N |
Numeric |
A value is required. | ||||||||
|
Input Measure AF |
MI_CALRESLT_IN_MEAS_AF_N |
Numeric |
A value is required. | ||||||||
|
Primary Output AF |
MI_CALRESLT_PRI_OUT_AF_N |
Numeric |
A value is required. | ||||||||
|
Calibration Sequence Number |
MI_CALRESLT_TST_SEQ_N |
Number |
A value is required. | ||||||||
| Standard Name | MI_CRANZR00_CMPNT_NM_C | Character (255) |
A value is required for multi-component analyzer calibration. This column may only contain one of the System Code IDs in the MI_CHEMICAL_COMPONENTS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||
|
Event ID |
MI_CALRESLT_ID |
Character (255) |
A value is required. Enter the ID of one of the following records:
| ||||||||
|
Percent of Scale TP |
MI_CALRESLT_POS_TP_N |
Numeric |
A value is required. | ||||||||
|
Input Up/Dn |
MI_CALRESLT_UP_DN_TP_C |
Character (2) |
A value is required. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. | ||||||||
| Switch Number (Discrete) | MI_CRDS0000_SW_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Found Reset Point (Discrete) | MI_CRDS0000_AF_RSET_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Found Trip Point | MI_CRDS0000_AF_TP_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Found Dead Band | MI_CRDS0000_AF_DB_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Left Reset Point | MI_CRDS0000_AL_RSET_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Left Trip Point | MI_CRDS0000_AL_TP_N | Numeric | A value is required for discrete calibration. | ||||||||
| As Left Dead Band | MI_CRDS0000_AL_DB_N | Numeric | A value is required for discrete calibration. | ||||||||
| Standard Value | MI_CRANZR00_CMPNT_VAL_N | Numeric | A value is required for single component and multi-component analyzer calibrations. | ||||||||
| Calibration Results Family ID | Family_ID | Character (255) |
A value is required. Depending on the family of the Calibration Results record, enter one of the following IDs:
| ||||||||
| As Found Value | MI_CRANZR00_AF_VAL_N | Numeric | A value is required for multi-component analyzer calibrations. | ||||||||
|
Primary Output AL |
MI_CALRESLT_PRI_OUT_AL_N |
Numeric |
None | ||||||||
|
Input Measure AL |
MI_CALRESLT_IN_MEAS_AL_N |
Numeric |
None | ||||||||
| Parent Key(Single/Multi Component) | MI_CRANZR00_PARE_KEY_N | Numeric | A value is required for single component or multi-component analyzer calibrations. This column may only contain a value that exists in the list in the Event ID field for Calibration, Single Component Analyzer or Calibration, Multi-Component Analyzer records. | ||||||||
|
Parent Key (Analog) |
MI_CRAN0000_PARE_KEY_N |
Numeric |
A value is required for analog calibrations. This column may only contain a value that exists in the list in the Event ID field for Calibration, Analog records. | ||||||||
|
Parent Key (Discrete) |
MI_CRDS0000_PARE_KEY_N |
Numeric |
A value is required for discrete calibrations. This column may only contain a value that exists in the list in the Event ID field for Calibration, Discrete records. |
Calibration Recommendation Worksheet
The Calibration Recommendation worksheet stores details of the Calibration Recommendation records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric | A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Target Completion Date | MI_REC_TARGE_COMPL_DATE_DT | Date | A value is required. Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| Recommendation ID | MI_REC_ID | Character (255) | A value is required and must be unique. This value identifies the Recommendation. |
| Asset ID | ASSET_ID | Numeric | A value is required. Enter the Asset ID that corresponds to the Asset ID configured in Asset ID Configuration for Equipment, Functional Location, or custom asset that is linked to the Calibration Template. If the value that you enter does not match the Asset ID of any Equipment, Functional Location, or custom asset in the APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. |
| Calibration Type | MI_RECCLBN_CALEVNT_CAT_CHR | Character (100) | A value is required. |
| Event ID | Event ID | Character | None |
| Asset Family ID | ASSET_FAMILY_ID | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. If the Asset corresponds to a Functional Location record, then enter MI_FNCLOC00. If the Asset corresponds to any of the custom asset record, then enter family ID of that asset family. |
|
Reevaluate? |
MI_REC_REEVAL_FLG |
Boolean |
Enter True or False. |
|
Calibration Recommendation Basis |
MI_RECCLBN_CALEVNT_ID_CHR |
Character (100) |
Enter the Event ID. |
|
Reevaluation Notification List |
MI_REC_REEVAL_NOTIF_LIST_CHR |
Character (2000) |
None |
|
Days Before Due Date to be Notified |
MI_REC_DAYS_BEF_DUE_DT_NOT_NBR |
Numeric |
None |
|
Generate Work Request |
MI_REC_WO_INTERFACE_FLAG_F |
Boolean |
Enter True or False. |
|
Meridium Task ID |
MI_REC_MERIDIUM_TASK_ID_C |
Character (255) |
None |
|
Final State Lock |
MI_REC_FINAL_STATE_LOCK_F |
Boolean |
Enter True or False. |
|
Final Approver Name |
MI_REC_FINAL_APPROVE_NAME_C |
Character (255) |
None |
|
Required Equipment Status |
MI_REC_REQUI_EQUIP_STATU_CHR |
Character (50) |
This column may only contain one of the System Code IDs in the MI_STATUS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Reevaluation Alert Body Text |
MI_REC_REEVAL_EMAIL_TX |
Character |
None |
|
Implementation Alert Text |
MI_REC_NOTIF_EMAIL_TEXT_CHR |
Character |
None |
|
Alert Assignee When Due? |
MI_REC_NOTIFY_RP_FLG |
Boolean |
Enter True or False. |
|
Reevaluation Date |
MI_REC_REEVAL_DT |
Date |
Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
|
Business Impact |
MI_REC_IMPAC_CHR |
Character (100) |
This column may only contain one of the System Code IDs in the MI_BUSINESS_IMPACT System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
|
Frequency of Alert After Due Date |
MI_REC_NOTIF_AFTER_DD_CHR |
Character (50) |
This column may only contain one of the System Code IDs in the MI_FREQ_OF_ALERTS System Code Table. Refer to the (Picklist) worksheet in the data loader workbook for a list of values that you can enter in this column. |
| Completion Comments | MI_REC_CLOSE_COMME_TX | Character | None |
| Implemented Date | MI_REC_COMPL_DATE_DT | Date | Enter the value in the following format: YYYY-MM-DD HH:mm:ss |
| Recommendation Headline | MI_REC_SHORT_DESCR_CHR | Character (255) | None |
| Recommendation Description | MI_REC_LONG_DESCR_TX | Character | None |
| Recommendation Priority | MI_REC_PRIORITY_C | Character (50) | None |
| Author Lock | MI_REC_AUTHOR_LOCK_F | Boolean | Enter True or False. |
| Assigned To Name | MI_REC_ASSIG_NM_CHR | Character (255) | None |
| Mandatory Date | MI_REC_MANDA_DATE_DT | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| Create SAP Notification? | MI_REC_CREATE_SAP_NOTIF_FLG | Boolean | Enter True or False. |
| Work Request Reference | MI_REC_WK_REQ_REF_CHR | Character (50) | None |
| Work Request Equipment | MI_REC_WR_EQUIP_C | Character (255) | None |
| Work Request Functional Location | MI_REC_WR_LOC_C | Character (255) | None |
| Technical Number | MI_REC_TECHNICAL_NUM_C | Character (50) | None |
| Status | MI_REC_STATU_CHR | Character (255) | None |
| Recommendation Type | MI_REC_TYPE_CHR | Character (255) | None |
| Reviewer Name | MI_REC_REVIE_NM_CHR | Character (255) | None |
| Author Name | MI_REC_AUTHO_NM_CHR | Character (255) | None |
| Creation Date | MI_REC_CREAT_DATE_DT | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| MI_SM_STATE_ID_C | MI_SM_STATE_ID_C | Character | None |
| MI_SM_STATE_ENTERED_D | MI_SM_STATE_ENTERED_D | Date | Enter a value in the following format: YYYY-MM-DD HH:mm:ss |
| MI_SM_STATE_OWNER_ID_C | MI_SM_STATE_OWNER_ID_C | Character | None |
Worksheet Details
The workbook Calibration-Functional Test.xlsx has following worksheets:
Functional Test Detail Worksheet
The Functional Test Detail worksheet stores details of the Calibration Template Detail and Functional Test records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Template Parent ID | PARENT_ID | Character(255) | Avalue is required and must be unique.This value identifies the Parent Template for the detail template |
| Sequence Number | MI_TDCAFC00_SEQUE_NUMBE_N | Numeric | A value is required and must be unique and in ascending order |
| Instruction | MI_TDCAFC00_INSTR_T | Character(255) | A value is required to indicate the calibration steps or instructions |
| Response Type | MI_TDCAFC00_INSTR_TYPE_C | Character(255) | A value is required to indicate the response type from the pick list |
| Expected Response | MI_TDCAFC00_EXPD_RESP_C | Character(255) | A value is required if the Validate check box is selected. This value will be compared with user entered response in the calibration event |
| Validate | MI_TDCAFC00_VALIDATE_RESP_F | Boolean | A value is required if you want to compare the Expected Response with user entered response in the Calibration event to make it as PASS or FAIL |
| Condition 1 | MI_TDCAFC00_CONDI_01_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 2 | MI_TDCAFC00_CONDI_02_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 3 | MI_TDCAFC00_CONDI_03_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 4 | MI_TDCAFC00_CONDI_04_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 5 | MI_TDCAFC00_CONDI_05_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 6 | MI_TDCAFC00_CONDI_06_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 7 | MI_TDCAFC00_CONDI_07_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 8 | MI_TDCAFC00_CONDI_08_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 9 | MI_TDCAFC00_CONDI_09_C | Character(255) | Provide the value if the Response Type is set to Selection |
| Condition 10 | MI_TDCAFC00_CONDI_10_C | Character(255) | Provide the value if the Response Type is set to Selection |
Calibration Result
The Calibration Result worksheet stores details of the Calibration Result, Functional Test records.
| Field Caption | Field ID | Data Type (Length) | Comments |
|---|---|---|---|
| BATCH_ID | BATCH_ID | Numeric |
A value is required and must match one of the values that you enter in the Batch worksheet. Additionally, all the records that are linked to one another must contain the same batch number. |
| Event ID | MI_CALRESLT_ID | Character(255) | Avalue is required and must be unique.This value identifies the Parent Event ID to which this record links as result record. |
| Sequence Number | MI_CALRESLT_TST_SEQ_N | Numeric | This value is copied from its template detail record by default. Provide the value if you want to override it. Otherwise remove this column the worksheet. |
| Instruction | MI_CRFUNC00_INSTR_T | Character(255) | This value is copied from its template detail record by default. Provide the value if you want to override it. Otherwise remove this column the worksheet. |
| Response Type | MI_CRFUNC00_INSTR_TYPE_C | Character(255) | This value is copied from its template detail record by default. Provide the value if you want to override it. Otherwise remove this column the worksheet |
| Expected Response | MI_CRFUNC00_EXPD_RESP_C | Character(255) | This value is copied from its template detail record by default. Provide the value if you want to override it. Otherwise remove this column the worksheet |
| Validate | MI_CRFUNC00_VALIDATE_RESP_F | Boolean | This value is copied from its template detail record by default. Provide the value if you want to override it. Otherwise remove this column the worksheet Enter 1 for Validate, Enter 0 for not to Validate. |
| Response 1 | MI_CRFUNC00_RESPO_01_C | Character(255) | A value required to record the response. If Validate is true, this value will be compared with expected response from the template detail record. This field will be picklist when the Response Type is either Boolean or Selection |
| Response 2 | MI_CRFUNC00_RESPO_02_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 3 | MI_CRFUNC00_RESPO_03_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 4 | MI_CRFUNC00_RESPO_04_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 5 | MI_CRFUNC00_RESPO_05_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 6 | MI_CRFUNC00_RESPO_06_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 7 | MI_CRFUNC00_RESPO_07_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 8 | MI_CRFUNC00_RESPO_08_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 9 | MI_CRFUNC00_RESPO_09_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
| Response 10 | MI_CRFUNC00_RESPO_10_C | Character(255) | This field is enabled only if the Response Type is Selection. This field display as picklist and values copied from its template detail record. Provide the value if required |
About the Calibration Data Loader Load Verification
About This Task
Procedure
- Access the details of the import job. These details indicate if any errors were encountered during the data load. The log may help account for any records that are not loaded.
- In Calibration Management or Record Manager, access the assets specified in the data loader workbook, and then verify that the expected Calibration records are present or updated, and that any associated records that you expected to be created are also present in the database.
- To access a list of Calibration Templates created after a specific date, run the following query:
SELECT [MI_TMCA0000].[MI_TM000000_ID] "Template ID", [MI_TMCA0000].[MI_TMCA0000_CAL_TYP_C] "Calibration Type", [MI_TMCA0000].[MI_TMCA0000_INPUT_TYP_C] "Input Type", [MI_TMCA0000].[MI_TMCA0000_OUTPU_TYP_C] "Output Type", [MI_TMCA0000].[MI_TMCA0000_IS_MAST_TEMP_L] "Is Master Template", [MI_TMCA0000].LAST_UPDT_DT "Created Date"FROM [MI_TMCA0000] WHERE [MI_TMCA0000].LAST_UPDT_DT >= (? :d :caption='Enter Date') - To access a list of Calibration Tasks created after a specific date, run the following query:
SELECT [MI_TASKCALB].[MI_TASK_ID] "Task ID", [MI_TASKCALB].[MI_TASK_LAST_DATE_DT] "Last Date", [MI_TASKCALB].[MI_TASK_NEXT_DATE_DT] "Next Date", [MI_TASKCALB].[MI_TASK_DESIR_INTER_NBR] "Desired Interval", [MI_TASKCALB].[MI_TASK_DESIR_INTER_UOM_C] "Desired Interval UOM", [MI_TASKCALB].LAST_UPDT_DT "Created Date" FROM [MI_TASKCALB] WHERE [MI_TASKCALB].LAST_UPDT_DT >= (? :d :caption='Enter Date') - To access a list of Calibrations created after a specific date, run the following query:
SELECT [MI_EVCALIBR].[MI_EVENT_ID] "Event ID", [MI_EVCALIBR].[MI_EVCALIBR_CALIB_TYP_C] "Calibration Type", [MI_EVCALIBR].[MI_EVCALIBR_STRATEGY_C] "Calibration Strategy", [MI_EVCALIBR].[MI_EVCALIBR_CAL_CLOSE_L] "Calibration Closed", [MI_EVCALIBR].[MI_SM_STATE_ID_C] "Calibration State", [MI_EVCALIBR].LAST_UPDT_DT "Created Date"FROM [MI_EVCALIBR] WHERE [MI_EVCALIBR].LAST_UPDT_DT >= (? :d :caption='Enter Date')