To import data using the Calibration Data Loader, GE Digital APM provides the data loader workbook (Calibration_DataLoader.xlsx) that supports baseline Calibration Management in GE Digital 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 lists the worksheets that are included in the data loader workbook.
|
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. |
|
MI_TESTEQUIP |
This worksheet is used to create or update Test Equipment records. |
|
MI_TST_EQUIP_HIST |
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. |
| MI_SGCY0000 | This worksheet is used to create or update Standard Gas Cylinder records. |
| MI_SGCM0000 |
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. |
| PROF_TEMPLATES | This worksheet is used to create or update Calibration Profile Templates records. |
| MI_CAL_PROF | This worksheet is used to create or update Calibration Profile records. |
|
MI_TMCAAN00 |
This worksheet is used to create or update Calibration Template, Analog records. |
| MI_TMCADSCT | This worksheet is used to create or update Calibration Template, Discrete records. |
| MI_TMCASCAN | This worksheet is used to create or update Calibration Template, Single Component Analyzer records. |
| MI_TMCAMCAN | This worksheet is used to create or update Calibration Template, Multi-Component Analyzer records. |
| MI_TDCAAN00 | 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. |
|
MI_TASKCALB |
This worksheet is used to create or update Calibration Task records. |
|
MI_EVENTS |
This worksheet is used to create or update the following records:
|
|
MI_RESULTS |
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. |
|
MI_RECCLBN |
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. |
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 |
|---|---|---|
|
|
Required Key Fields |
Indicates columns that contain values that are used by the Risk Based Inspection (RBI) 580 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. |
|
|
Fields Required for Calculation |
Indicates columns that contain values that are required to perform calculations in Risk Based Inspection. Some cells only require values in certain cases. Such cases are found in parentheses in the first row of each worksheet. |
|
|
Recommended Fields |
Indicates columns that, according to GE Digital Best Practice for Risk Based Inspection, should contain values. |
|
|
Custom Fields |
Indicates columns where you can specify custom fields. |
Limitations
The Calibration Data Loader has the following limitations:
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 GE Digital APM will be blank.
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. |
The MI_TESTEQUIP 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 |
Character (50) |
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 GE Digital 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 Certified |
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 |
The MI_TST_EQUIP_HIST 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 column 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 |
The MI_SGCY0000 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 |
The MI_SGCM0000 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. |
The PROF_TEMPLATES 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. |
||||||||||
|
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 calibration type, this column must contain a value from 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 calibration type, this column must contain a value from 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 for discrete calibration. 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 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 Assesment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
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. |
The MI_CAL_PROF 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:
|
The MI_TMCAAN00 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 GE Digital 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 Key |
MI_TMCA0000_ASSET_KEY_N | Numeric | A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family Key | MI_TMCA0000_ASSET_FAM_KEY_N | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. | ||||||||||
| 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) |
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. |
||||||||||
| Error Assesment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
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. |
The MI_TMCAAN00 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 GE Digital 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 Key |
MI_TMCA0000_ASSET_KEY_N | Numeric | A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family Key | MI_TMCA0000_ASSET_FAM_KEY_N | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. | ||||||||||
| 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 Assesment | MI_TMCA0000_ERR_ASSES_C | Character (50) |
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:
|
The MI_TMCASCAN 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 Key | MI_TMCA0000_ASSET_KEY_N | Numeric | A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. | ||||||||||
| Asset Family Key | MI_TMCA0000_ASSET_FAM_KEY_N | Numeric | A value is required. If the Asset corresponds to an Equipment record, then enter MI_EQUIP000. | ||||||||||
| 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 |
The MI_TMCAMCAN 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 Key | MI_TMCA0000_ASSET_KEY_N | Numeric | A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. |
| Asset Family Key | MI_TMCA0000_ASSET_FAM_KEY_N | 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 |
The MI_TDCAAN00 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 |
The MI_TASKCALB 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 |
MI_TASK_RELAT_ENTIT_ID_CHR |
Character (255) |
A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. |
|
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. |
The MI_EVENTS worksheet stores details of the following 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_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. |
||||||||||
| 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 Key |
MI_EVENT_ASSET_KEY_N |
Numeric |
A value is required. Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital 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. | ||||||||||
| 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. | ||||||||||
| Asset ID |
MI_EVENT_ASST_ID_CHR |
Character (255) |
Enter the Equipment Technical Number that corresponds to the Equipment that is linked to the Calibration Template. If the value that you enter does not match the Equipment Technical ID of any Equipment in the GE Digital APM database, an error message appears, stating that the Asset is not found, and the batch is not imported. |
||||||||||
|
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 GE Digital 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. |
The MI_RESULTS worksheet stores details of the following 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. |
||||||||
|
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. |
The MI_RECCLBN 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. |
|
Equipment ID |
MI_REC_ASSET_ID_CHR |
Character (2000) |
A value is required. |
|
Calibration Type |
MI_RECCLBN_CALEVNT_CAT_CHR |
Character (100) |
A value is required. |
|
Event ID |
Event ID |
Character |
None |
|
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 |
Copyright © 2018 General Electric Company. All rights reserved.