About the Rounds Data Loaders Workbook Layout and Use

Field Caption	Field ID	Data Type (Length)	Comments
Allowable Value Batch ID	OPR_AL_VL_ID	Character (50)	This field is required for identification during the data load process and must be unique. It is not imported to GE Digital APM.
Type	MI_OPR_AL_VL_TYPE_CHR	Character (50)	This field is required. The valid values for this field are: Character Numeric
Category	MI_OPR_AL_VL_CATEG_CHR	Character (50)	This field is required.
Value	MI_OPR_AL_VL_VALUE_CHR	Character (50)	This field is required.

Worksheet	Description
Template Group Worksheet (MI_DTACLTMP)	This worksheet is used to specify the Template Groups.
Measurement Location Worksheet (MI_ML_TMPLT)	This worksheet is used to specify Measurement Location Templates that will be related to Template Groups. Note that no relationships are created when this worksheet is imported. The arrangement of Measurement Location Templates is defined by Checkpoint Template Sequence records which are created when the next worksheet is imported.
Checkpoint Template Sequence Worksheet (MI_HSCPTMP)	This worksheet is used to specify Checkpoint Template Sequence records that define how ML Templates are arranged into Template Groups. Note that an ML Template can appear in multiple Template Groups, and it can appear in a Template Group more than once.
Lubrication Requirement Worksheet (MI_LR_TMPLT)	This worksheet is used to define Lubrication Requirement Templates. Note that no relationships are created when this worksheet is imported.
Checkpoint Condition Worksheet (MI_CHKPCOND)	This worksheet is used to specify Checkpoint Conditions that will be related to checkpoints in Template Groups.

Template Group Worksheet (MI_DTACLTMP)

Field Caption	Field ID	Data Type (Length)	Comments
Template Group Batch ID	ROUNDS_MLTG_ID	Character (50)	This field is required for identification during the data load process and must be unique. It is not imported to GE Digital APM.
ID	MI_DTACLTMP_ID_C	Character (50)	This field is required and must be unique.
Site Reference Name	MI_SITE_NAME	Character (50)	This field is required and must match an existing Site name. Note: If you want to set the site reference to be a Global Site Reference, enter the constant ‘Global’ in the MI_SITE_NAME column on the spreadsheet.
Description	MI_DTACLTMP_DESCR_C	Character (255)	Please provide a brief description.

Measurement Location Worksheet (MI_ML_TMPLT)

Field Caption	Field ID	Data Type (Length)	Comments
Template Group Batch ID	ROUNDS_MLTG_ID	Character (50)	This field is required for identification during the data load process. It should match the ID of the Template Group to which the ML Template will be linked. Use <Dummy ID> if you want to import standalone records not linked to a Template Group. Not imported to GE Digital APM.
Template Item ID	ROUNDS_MLT_ID	Character (50)	This field is required for identification during the data load process. Not imported to GE Digital APM.
Template ID	MI_ML_TMPLT_TEMPL_ID_C	Character (50)	This field is required and must be unique.
ML Type	MI_ML_TMPLT_MEAS_LOC_TYPE_C	Character (50)	This field is required. The valid values for this field are: Character Numeric
Site Reference Name	MI_SITE_NAME	Character (50)	This field is required and must match an existing Site name. Note: If you want to set the site reference to be a Global Site Reference, enter the constant ‘Global’ in the MI_SITE_NAME column on the spreadsheet.
Description	MI_ML_TMPLT_DESC_C	Character (255)	Please provide a brief description.
Unit of Measure	MI_ML_TMPLT_UOM_C	Character (50)	Must be a valid value in the global Unit of Measure list. Disabled if the ML Type field is Character.
Status	MI_ML_TMPLT_STAT_C	Character (50)	The default value for this field is Active.
Schedule	MI_ML_TMPLT_SCHEDULE_C	Character (255)	If specified, must be valid JSON Schedule.
Checkpoint Locked	MI_CP_TMPLT_LOCKED_L	Boolean	The default value for this field is False.
Requires Equipment Shutdown	MI_CP_TMPLT_REQU_EQUI_SHUT_FLG	Logical	The default value for this field is False.
Category	MI_ML_TMPLT_CATEG_C	Character (50)	All specified values must match the Category field in pre-existing Allowable Value records where the Category and Type match the Category and ML Type defined for this ML.
Allowable Values	MI_ML_TMPLT_ALLOW_VAL_C	Multi-value, max 10 values, Character (255)	All specified Values must match the Value field in pre-existing Allowable Value records where the Category and Type match the Category and ML Type defined for this MLT. The \| (pipe) character is used to separate each allowable value.
Lower Level 1 Action	MI_ML_TMPLT_LO_LVL1_ACT_C	Character (50)	None
Lower Level 1 Character Value	MI_ML_TMPLT_LO_LVL1_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Lower Level 1 Numeric Value*	MI_ML_TMPLT_LO_LVL1_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 1 Message	MI_ML_TMPLT_LO_LVL1_MSG_C	Character (50)	None
Lower Level 2 Action	MI_ML_TMPLT_LO_LVL2_ACT_C	Character (50)	None
Lower Level 2 Character Value	MI_ML_TMPLT_LO_LVL2_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Lower Level 2 Numeric Value*	MI_ML_TMPLT_LO_LVL2_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 2 Message	MI_ML_TMPLT_LO_LVL2_MSG_C	Character (50)	None
Lower Level 3 Action	MI_ML_TMPLT_LO_LVL3_ACT_C	Character (50)	None
Lower Level 3 Character Value	MI_ML_TMPLT_LO_LVL3_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Lower Level 3 Numeric Value*	MI_ML_TMPLT_LO_LVL3_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 3 Message	MI_ML_TMPLT_LO_LVL3_MSG_C	Character (50)	None
Upper Level 1 Action	MI_ML_TMPLT_UP_LVL1_ACT_C	Character (50)	None
Upper Level 1 Character Value	MI_ML_TMPLT_UP_LVL1_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Upper Level 1 Numeric Value*	MI_ML_TMPLT_UP_LVL1_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Upper Level 1 Message	MI_ML_TMPLT_UP_LVL1_MSG_C	Character (50)	None
Upper Level 2 Action	MI_ML_TMPLT_UP_LVL2_ACT_C	Character (50)	None
Upper Level 2 Character Value	MI_ML_TMPLT_UP_LVL2_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Upper Level 2 Numeric Value*	MI_ML_TMPLT_UP_LVL2_ALRT_N	Numeric	None. This field is disabled if the ML Type field is Character.
Upper Level 2 Message	MI_ML_TMPLT_UP_LVL2_MSG_C	Character (50)	None
Upper Level 3 Action	MI_ML_TMPLT_UP_LVL3_ACT_C	Character (50)	None
Upper Level 3 Character Value	MI_ML_TMPLT_UP_LVL3_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the MLT. This field is disabled if the ML Type field is Numeric.
Upper Level 3 Numeric Value*	MI_ML_TMPLT_UP_LVL3_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Upper Level 3 Message	MI_ML_TMPLT_UP_LVL3_MSG_C	Character (50)	None
Product	MI_ML_TMPLT_PRODUCT_C	Character (50)	None
Minimum Valid Value	MI_ML_TMPLT_MIN_VLDVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Maximum Target Value	MI_ML_TMPLT_MAX_TRGVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Minimum Target Value	MI_ML_TMPLT_MIN_TRGVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Maximum Valid Value	MI_ML_TMPLT_MAX_VLDVAL_N	Numeric	None. This field is disabled if ML type field is Character.
More Information	MI_ML_TMPLT_MORE_INFO_C	Character (255)	None

* For a Numeric ML Template, the limit values must be in descending order (i.e., lower level 3<lower level 2<lower level 1<upper level 1<upper level 2<upper level 3).

Checkpoint Template Sequence Worksheet (MI_HSCPTMP)

Field Caption	Field ID	Data Type (Length)	Comments
Template Group Batch ID	ROUNDS_MLTG_ID	Character (50)	This field is required for identification during the data load process. It must match the ID of the Template Group to which the Checkpoint Template Sequence record will be linked. Not imported to GE Digital APM.
CTS ID	CTS_ID	Character (50)	This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Group ID/Predecessor CTC ID	MI_HSCPTMP_PRED_ENTY_KEY_N	Character (50)	This field is required. If the checkpoint does not have a predecessor Checkpoint Condition, you should specify the Predecessor Template Group ID as defined in the ROUNDS_MLTG_ID column of the Template Groups sheet in the current data loader workbook. The data loader will automatically populate the field on the record with the relevant Entity Key. If the checkpoint does have a predecessor Checkpoint Condition, specify the CTC ID for the predecessor Checkpoint Condition in this field.
Template ID	MI_HSCPTMP_SUCC_ENTY_KEY_N	Character (50)	This field is required. You should specify the Template ID as defined in the ROUNDS_MLT_ID column of the Templates sheet in the current data loader workbook. The data loader will automatically populate the field on the record with the relevant Entity Key.
Sequence	MI_HSCPTMP_SEQ_N	Numeric	This field is required and must be unique within the collection of Checkpoint Template Sequence records associated with any Template Group.
Template Group ID	MI_HSCPTMP_REL_TMPG_KEY_N	Numeric	This field is required for identification during the data load process and must match the ID of the template group to which the Checkpoint Template Sequence is being applied. Not imported GE Digital APM.

Checkpoint Condition Worksheet (MI_CHKPCOND)

Field Caption	Field ID	Data Type (Length)	Comments
Template Group Batch ID	ROUNDS_MLTG_ID	Character (50)	This field is required for identification during the data load process. It must match the ID of the Template Group to which the Checkpoint Template Sequence record will be linked. Not imported to GE Digital APM.
CPC ID	CPC_ID	Character (50)	This field defines the ID for the Checkpoint Condition. If you want to include conditions in your template, this field is required and must be unique.
Predecessor CTS ID	MI_CHKPCOND_PRED_KEY_N	Numeric	Use this field to determine the predecessor checkpoint for the Checkpoint Condition. This field specifies the Checkpoint Template Sequence ID (CTS ID) defined in the Checkpoint Template Sequence worksheet for the predecessor checkpoint.
Sequence Number	MI_CHKPCOND_SEQ_NUM_N	Numeric	This field defines the sequence for sibling Checkpoint Conditions (that is, Checkpoint Conditions with the same Predecessor CTS ID). If you are adding a Checkpoint Condition for the first time: If no value is specified in this field, a value will be automatically assigned to the Checkpoint Condition during the data load process. If you specify a value in this field, the sequence that you specify will be used to determine the order of sibling Checkpoint Conditions. If you are updating an existing Checkpoint Condition: If no value is specified in this field, the existing sequence will remain intact. If you specify a value in this field, the sequence that you specify will be used to determine the order of sibling Checkpoint Conditions.
Template Group ID	MI_HSCPTMP_REL_TMPG_KEY_N	Numeric	This field is required for identification during the data load process and must match the ID of the template group to which the Checkpoint Template Sequence is being applied. Not imported GE Digital APM.
Field Name	MI_CHKPCOND_FLD_NAM_C	Character (50)	This field behaves differently depending on whether the Predecessor CTS ID refers to a Measurement Location or a Lubrication Requirement: If the Predecessor CTS ID refers to a Measurement Location, this field specifies the category for the Measurement Location. If the Predecessor CTS ID refers to a Lubrication Requirement, this field specifies the lubricant type for the Lubrication Requirement.
Field Value for Character Type	MI_CHKPCOND_FLD_VAL_CHAR_C	Character (250)	This field specifies the reading value that, for a predecessor Measurement Location with an ML Type of Character, determines whether the condition has been met to display successor checkpoints.
Field Value for Numeric Type	MI_CHKPCOND_FLD_VAL_NUM_N	Numeric	This field specifies the reading value that, for a predecessor Measurement Location with an ML Type of Numeric, determines whether the condition has been met to display successor checkpoints.
Possible Condition	MI_CHKPCOND_POSS_COND_C	Character (200)	This field specifies the relationship between the predecessor checkpoint value and the value in the Checkpoint Condition Field Value field that determines whether to display successor checkpoints in Rounds Data Collection. If the predecessor checkpoint has a Type value of Numeric, enter one of the following values: < <= = >= > If the predecessor checkpoint has a Type value of Character, enter the following value in this field: is.
Type	MI_CHKPCOND_TYPEC	Character (50)	This field is required. The valid values for this field are: Character Numeric

Lubrication Requirement Worksheet (MI_LR_TMPLT)

Field Caption	Field ID	Data Type (Length)	Comments
Template Group Batch ID	ROUNDS_MLTG_ID	Character (50)	Lubrication Requirement records can be created without being linked to a Route by specifying <Dummy ID> as the Route ID and the Route Batch ID as 1000000000. Not imported to GE Digital APM. You can create orphan Lubrication Requirement Templates using this DL.
Template Item ID	ROUNDS_LRT_ID	Character (50)	This field is required for identification during the data load process. Not imported to GE Digital APM.
Template ID	MI_ML_TMPLT_TEMPL_ID_C	Character (50)	This field is required and must be unique.
LR Type	MI_LR_TMPLT_LR_TYPE_C	Character (50)	This field is required. The valid values for this field are: Character Numeric
Description	MI_ML_TMPLT_DESC_C	Character (255)	Please provide a brief description.
Unit of Measure	MI_ML_TMPLT_UOM_C	Character (50)	The field must be a valid value in the global Unit of Measure list. This field is disabled if the LR Type field is Character.
Status	MI_ML_TMPLT_STAT_C	Character (50)	The valid values for this field are Active or Inactive. This field is set to Active by default.
Schedule	MI_ML_TMPLT_SCHEDULE_C	Character (255)	If specified, must be valid JSON Schedule.
Checkpoint Locked	MI_CP_TMPLT_LOCKED_L	Logical	The default value for this field is False.
Requires Equipment Shutdown	MI_CP_TMPLT_REQU_EQUI_SHUT_FLG	Logical	The default value for this field is False.
Lubricant	MI_LR_TMPLT_LUBR_C	Character (50)	This field must be a pre-existing Lubricant value in the Lubricant family where the Method and Manufacturer are as specified for this LR Template.
Number of Points	MI_LR_TMPLT_NO_OF_POINTS_N	Numeric	None
Capacity	MI_LR_TMPLT_CAP_N	Numeric	None
Quantity	MI_LR_TMPLT_QTY_N	Numeric	None
Method	MI_LR_TMPLT_METHOD_C	Character (50)	This field must be a pre-existing Method defined in a Lubricant record.
Skip Reason	MI_LR_TMPLT_SKIP_REAS_C	Character (50)	None
Change Out Triggers Update?	MI_LR_TMPLT_CH_OUT_TRIG_UPD_L	Logical	The default value for this field is False.
Component	MI_LR_TMPLT_COMP_C	Character (50)	None
Lubricant Manufacturer	MI_LR_TMPLT_LUBR_MFR_C	Character (50)	None
Capacity Unit Of Measure	MI_LR_TMPLT_CAPTY_UOM_C	Character (50)	None
Priority	MI_LR_TMPLT_PRIOR_C	Character (50)	None

Worksheet	Description
Route Worksheet (MI_ROUTE000)	This worksheet is used to specify Route records.
Security User Worksheet (MI_Security User)	This worksheet is used to assign a security user for the Route identified by Route Id in each row in the Security User (MI_Security User) worksheet. You can also unassign all the Security Users from a Route by leaving the User ID field blank. You may leave all rows blank to make no Route assignment changes.
Measurement Location Worksheet (MI_MEAS_LOC)	This worksheet is used to specify the measurement locations that will be linked to each Route. You can import Measurement Locations that are not linked to a Route by specifying <Dummy ID> for the Route ID. Note that Measurement Locations may be related to a Measurement Location Template. If one is specified, the values from the template will be used to populate the fields in the Measurement Location. Required values that are provided from the Measurement Location Template need not be specified again in this worksheet. If this worksheet specifies a value for any field that is populated from the Measurement Location Template, it will be over-written with the value from the Measurement Location Template.
Checkpoint Task Worksheet (MI_CP_TASK0)	This worksheet is used to specify the schedule information to be added to the Checkpoint Task records that will be created for each Measurement Location that is imported. Note that it is not required to specify any data on this worksheet. If no data is specified, the Checkpoint Task records will be created with the schedule information from the Measurement Location Template specified in the related Measurement Location.
Checkpoint Condition Worksheet (MI_CHKPCOND)	This worksheet is used to specify Checkpoint Conditions that will be related to checkpoints in Rounds Routes.

Route Worksheet (MI_ROUTE000)

Field Caption	Field ID	Data Type (Length)	Comments
Route Batch ID	ROUNDS_ROUTE_ID	Character (50)	This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Route Id	MI_ROUTE000_ROUTE_ID_C	Character (50)	This field is required and must be unique, When you use the data loader to create Route, Measurement Locations and Checkpoint task records. When you use the data loader to create Route, Measurement Locations and Checkpoint task records and assign the security users to Routes. Note: This field is not required and may not be populated on this worksheet when you only assign or un-assign the security users to Routes.
Site Reference Name	MI_SITE_NAME	Character (50)	This field is required and must match an existing Site name Note: If you want to set the site reference to be a Global Site Reference, enter the constant ‘Global’ in the MI_SITE_NAME column on the spreadsheet.
Route Description	MI_ROUTE000_ROUTE_DESC_C	Character (125)	Please provide a brief description. Note: If you are using a Windows Mobile Device, GE Digital recommends that you do not enter Route descriptions longer than 40 characters.
Status	MI_ROUTE000_STAT_C	Character (50)	The valid values for this field are Active or Inactive. The default value for this field is Inactive.
Schedule	MI_ROUTE000_SCHED_C	Character (2000)	If specified, must be valid JSON Schedule definition. Note: To enable users to copy the JSON schedule text, an alternative Route with schedule datasheet is provided showing the Schedule Text (copy/paste enabled) field.
Route Scan ID	MI_ROUTE000_BARCD_ID_C	Character (50)	This field is required and must be unique.
Next Date	MI_ROUTE000_NEXT_DATE_D	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss.
Last Date	MI_ROUTE000_LAST_DATE_D	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss.

Security User Worksheet (MI_Security User)

Field Caption	Field ID	Data Type (Length)	Comments
Route Batch ID	ROUNDS_ROUTE_ID	Character (50)	This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Route Id	MI_ROUTE000_ROUTE_ID_C	Character (50)	This field is required and must be unique. The field needs to be populated on this worksheet when you are assigning the security users to Routes.
User ID	SEUS_ID	Character (50)	This field is required for assigning the User to the Route during the load process and must be unique. The Security User and the corresponding Human Resource records must already be part of the baseline database. If the field is left blank, the Route will be un-assigned.

Measurement Location Worksheet (MI_MEAS_LOC)

Field Caption	Field ID	Data Type (Length)	Comments
Route Batch ID	ROUNDS_ROUTE_ID	Character (50)	This field is required for identification during the data load process. It should match the ID of the Route to which the Measurement Location record will be linked. Use <Dummy ID> if you are importing standalone Measurement Location records. It is not imported to GE Digital APM.
ML Identifier	ROUNDS_ML_ID	Character (50)	This field is required for identification during the data load process and must be unique. It is not imported to GE Digital APM.
Checkpoint ID	MI_CHECK_PT_CHEC_ID_C	Character (50)	This field is required and must be unique. If the value matches an existing Checkpoint ID, the ML record will be updated, otherwise a new ML record will be created.
Parent Condition Batch ID	MI_CHKPCOND_BATCH_ID	Character (50)	This field is required only if the checkpoint has a parent Checkpoint Condition. If the checkpoint has a predecessor Checkpoint Condition, this field is used for identification during the data load process and must match the batch ID of the predecessor Checkpoint Condition. Not imported to GE Digital APM.
Parent Condition Identifier	MI_CHKPCOND_ID_C	Character (50)	This field is required only if the checkpoint has a parent Checkpoint Condition. If the checkpoint has a predecessor Checkpoint Condition, this field is used for identification during the data load process and must match the ID of the predecessor Checkpoint Condition. Not imported to GE Digital APM.
ML Type	MI_MEAS_LOC_MEAS_LOC_TYPE_C	Character (50) Numeric	This field is required if Is LR? column contains False or is empty. The valid values for this field are Character or Numeric. The ML Type of the Measurement Location must match the ML Type of the template specified by the Template field, if applicable.
LR Type	MI_MEAS_LOC_MEAS_LOC_TYPE_C	Character (50)	This field is required if Is LR? column contains True. The valid values for this field are Checkoff, Changeout and Tracking. The LR Type of the Lubrication Requirement must match the LR Type of the template specified by the Template ID field, if applicable.
Is LR?	ROUNDS_CHECK_PT_IS_LR	Logical	The default value of this field is False. Enter True to specify that a Lubrication Requirement is being loaded.
Description	MI_MEAS_LOC_DESC_C	Character (255)	Please provide a brief description.
Bluetooth Measurement Type	MI_MEAS_LOC_BT_MEAS_TYPE_C	Character (255)	None
Checkpoint Locked	MI_CHECK_PT_LOCKED_L	Logical	The default value of this field is False.
Requires Equipment Shutdown	MI_CP_TMPLT_REQU_EQUI_SHUT_FLG	Logical	The default value for this field is False.
Unit of Measure	MI_MEAS_LOC_UOM_C	Character (50)	Must be a valid value in the global Unit of Measure list. This field is disabled if the ML Type field is Character.
Template	MI_MEAS_LOC_TEMPL_C	Character (50)	This field is required and must be unique. Must match an existing ML Template ID. The ML Type of the template specified by the ML Template ID must match the ML Type of Measurement Location, if applicable.
Related Asset Key	MI_CHECK_PT_REL_ASSET_KEY_N	Numeric	If provided, must be the entity key of an existing Equipment or Functional Location record. The checkpoint will be linked to this asset.
Scan ID	MI_CHECK_PT_BARCD_ID_C	Character (50)	None
Related Asset Id	MI_MEAS_LOC_RELAT_ASSET_ID_C	Character (50)	If this value matches an existing Equipment ID (for Equipment) or Functional Location (for Functional Locations) the checkpoint will be linked to this asset.
Asset Description	MI_MEAS_LOC_ASSET_DESCR_C	Character (50)	None
Status	MI_MEAS_LOC_STAT_C	Character (50)	The valid values for this field are Active or Inactive. The default value for this field is Active.
Sequence	MI_MEAS_LOC_SEQ_N	Numeric	This field is not required but if specified, it must be unique on the Route.
Category	MI_MEAS_LOC_CATEG_C	Character (50)	Must match the Category field on an existing Allowable Value record, where the Type field matches the ML Type value specified.
Allowable Values	MI_MEAS_LOC_ALLOW_VAL_C	Multi-value, max 10 values, Character (255)	All specified Values must match the Value field in pre-existing Allowable Value records where the Category and Type match the Category and ML Type defined for this ML. The \| (pipe) character is used to separate each allowable value.
Lower Level 1 Action	MI_MEAS_LOC_LO_LVL1_ACT_C	Character (50)	None
Lower Level 1 Character Value	MI_MEAS_LOC_LO_LVL1_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Lower Level 1 Message	MI_MEAS_LOC_LO_LVL1_MSG_C	Character (50)	None
Lower Level 2 Action	MI_MEAS_LOC_LO_LVL2_ACT_C	Character (50)	None
Lower Level 2 Character Value	MI_MEAS_LOC_LO_LVL2_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Lower Level 2 Message	MI_MEAS_LOC_LO_LVL2_MSG_C	Character (50)	None
Upper Level 3 Numeric Value*	MI_MEAS_LOC_UP_LVL3_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Upper Level 2 Numeric Value*	MI_MEAS_LOC_UP_LVL2_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Upper Level 1 Numeric Value*	MI_MEAS_LOC_UP_LVL1_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 1 Numeric Value*	MI_MEAS_LOC_LO_LVL1_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 2 Numeric Value*	MI_MEAS_LOC_LO_LVL2_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 3 Numeric Value	MI_MEAS_LOC_LO_LVL3_ALRT_N	Numeric	None. This field is disabled if ML type field is Character.
Lower Level 3 Action	MI_MEAS_LOC_LO_LVL3_ACT_C	Character (50)	None
Lower Level 3 Character Value	MI_MEAS_LOC_LO_LVL3_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Lower Level 3 Message	MI_MEAS_LOC_LO_LVL3_MSG_C	Character (50)	None
Upper Level 1 Action	MI_MEAS_LOC_UP_LVL1_ACT_C	Character (50)	None
Upper Level 1 Character Value	MI_MEAS_LOC_UP_LVL1_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Upper Level 1 Message	MI_MEAS_LOC_UP_LVL1_MSG_C	Character (50)	None
Upper Level 2 Action	MI_MEAS_LOC_UP_LVL2_ACT_C	Character (50)	None
Upper Level 2 Character Value	MI_MEAS_LOC_UP_LVL2_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Upper Level 2 Message	MI_MEAS_LOC_UP_LVL2_MSG_C	Character (50)	None
Upper Level 3 Action	MI_MEAS_LOC_UP_LVL3_ACT_C	Character (50)	None
Upper Level 3 Character Value	MI_MEAS_LOC_UP_LVL3_ALRT_C	Character (50)	Must use one of the Allowable Values specified for the ML. This field is disabled if the ML Type field is Numeric.
Upper Level 3 Message	MI_MEAS_LOC_UP_LVL3_MSG_C	Character (50)	None
Product	MI_MEAS_LOC_PRODUCT_C	Character (50)	None
Maximum Target Value	MI_MEAS_LOC_MAX_TRGVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Minimum Valid Value	MI_MEAS_LOC_MIN_VLDVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Minimum Target Value	MI_MEAS_LOC_MIN_TRGVAL_N	Numeric	None. This field is disabled if ML type field is Character.
Maximum Valid Value	MI_MEAS_LOC_MAX_VLDVAL_N	Numeric	None. This field is disabled if ML type field is Character.
More Information	MI_MEAS_LOC_MORE_INFO_C	Character (255)	None
Download Stored Document	MI_MEAS_LOC_DWLD_STRD_DOC_L	Logical	The default value for this field is False.
Action ID	MI_MEAS_ACTION_ID_EXT	Character (50)	This field matches the Action ID (MI_ACTION_ID_C field) of an Action record that is linked to the Strategy identified by the value in the MI_MEAS_STRATEGY_EXT column. If no matching Strategy / Action combination is found, the Measurement Location is not linked to an Action.
Strategy ID	MI_MEAS_STRATEGY_EXT	Character (255)	This field matches the Strategy ID (MI_STRATEGY_ID_C field) of the Strategy (MI_STRATEGY family) containing the Action to which the Measurement Location will be linked.
Lubricant	MI_LUBR_REQ_LUBR_C	Character (50)	This field must be a pre-existing Lubricant value in the Lubricant family where the Method and Manufacturer are as specified for this LR.
Number of Points	MI_LUBR_REQ_NO_OF_POINTS_N	Numeric	None
Capacity	MI_LUBR_REQ_CAP_N	Numeric	None
Quantity	MI_LUBR_REQ_QTY_N	Numeric	None
Method	MI_LUBR_REQ_METHOD_C	Character (50)	This field must be a pre-existing Method defined in a Lubricant record.
Skip Reason	MI_LUBR_REQ_SKIP_REAS_C	Character (50)	None
Change Out Triggers Update?	MI_LUBR_REQ_CH_OUT_TRIG_UPD_L	Logical	The default value of this field is False.
Component	MI_LUBR_REQ_COMP_C	Character (50)	None
Lubricant Manufacturer	MI_LUBR_REQ_LUBR_MFR_C	Character (50)	This field must be a pre-existing value in a Lubricant record where the Method field is as specified for this LR.
Priority	MI_LUBR_REQ_PRIOR_C	Character (50)	None
Capacity Unit of Measure	MI_LUBR_REQ_CAPTY_UOM_C	Character (50)	None

Checkpoint Task Worksheet (MI_CP_TASK0)

Field Caption	Field ID	Data Type (Length)	Comments
Route Batch ID	ROUNDS_ROUTE_ID	Character (50)	This field is required for identification during the data load process. It should match the ID of the Route to which the Measurement Location record will be linked. Use <Dummy ID> if you are importing standalone Measurement Location records. Not imported to GE Digital APM.
ML Identifier	ROUNDS_ML_ID	Character (50)	This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Next Date	MI_TASK_NEXT_DATE_DT	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss.
Schedule	MI_TASK_SCHEDULE_C	Character (255)	If provided, must be valid JSON Schedule definition. Note: To enable users to copy the JSON schedule text, an alternative Checkpoint Task with Schedule datasheet is provided showing the Schedule Text (copy/paste enabled) field.
Non-compliance Date	MI_CP_TASK0_NON_COMP_D	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss.
Non Compliance Date Interval	MI_CP_TASK0_NONCMP_DT_INTR_NBR	Numeric	If provided, must be a positive integer.
Non Compliance Next Check Date	MI_CP_TASK0_NON_CMP_NXT_CHK_D	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss.

Checkpoint Condition Worksheet (MI_CHKPCOND)

Field Caption	Field ID	Data Type (Length)	Comments
Route Batch ID	ROUNDS_MLTG_ID	Character (50)	This field is required for identification during the data load process. It must match the ID of the Route to which the Checkpoint Condition will be linked. Not imported to GE Digital APM.
Condition Batch ID	MI_CHKPCOND_BATCH_ID	Character (50)	This field specifies the batch ID for the Checkpoint Condition. This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Condition Identifier	MI_CHKPCOND_ID_C	Character (50)	This field is required for identification during the data load process and must be unique. Not imported to GE Digital APM.
Parent ML Batch ID	PARENT_ROUNDS_ML_ID	Character (50)	This field is required for identification during the data load process and must match the ML Identifier of the predecessor checkpoint as defined in the Measurement Location worksheet. Not imported to GE Digital APM.
Parent ML ID	MI_CHECK_PT_PR_CHEC_ID_C	Character (50)	This field is required for identification during the data load process and must match the Checkpoint ID for the predecessor checkpoint as defined in the Measurement Location worksheet. Not imported to GE Digital APM.
Field Name	MI_CHKPCOND_FLD_NAM_C	Character (50)	This field behaves differently depending on whether the Predecessor CTS ID refers to a Measurement Location or a Lubrication Requirement: If the Predecessor CTS ID refers to a Measurement Location, this field specifies the category for the Measurement Location. If the Predecessor CTS ID refers to a Lubrication Requirement, this field specifies the lubricant type for the Lubrication Requirement.
Field Value for Character Type	MI_CHKPCOND_FLD_VAL_CHAR_C	Character (250)	This field specifies the reading value that, for a predecessor Measurement Location with an ML Type of Character, determines whether the condition has been met to display successor checkpoints.
Field Value for Numeric Type	MI_CHKPCOND_FLD_VAL_NUM_N	Numeric	This field specifies the reading value that, for a predecessor Measurement Location with an ML Type of Numeric, determines whether the condition has been met to display successor checkpoints.
Possible Condition	MI_CHKPCOND_POSS_COND_C	Character (200)	This field specifies the relationship between the predecessor checkpoint value and the value in the Checkpoint Condition Field Value field that determines whether to display successor checkpoints in Rounds Data Collection. If the predecessor checkpoint has a Type value of Numeric, enter one of the following values: < <= = >= > If the predecessor checkpoint has a Type value of Character, enter the following value in this field: is.
Type	MI_CHKPCOND_TYPEC	Character (50)	This field is required. The valid values for this field are: Character Numeric
Sequence Number	MI_CHKPCOND_SEQ_NUM_N	Numeric	This field defines the sequence for sibling Checkpoint Conditions (that is, Checkpoint Conditions with the same Predecessor CTS ID). If you are adding a Checkpoint Condition for the first time: If no value is specified in this field, a value will be automatically assigned to the Checkpoint Condition during the data load process. If you specify a value in this field, the sequence that you specify will be used to determine the order of sibling Checkpoint Conditions. If you are updating an existing Checkpoint Condition: If no value is specified in this field, the existing sequence will remain intact. If you specify a value in this field, the sequence that you specify will be used to determine the order of sibling Checkpoint Conditions.

Field Caption	Field ID	Data Type (Length)	Comments
Reading Batch ID	ROUNDS_READING_ID	Character (50)	This field is required.
Related ML Entity Key	MI_READING0_RELAT_ML_ENTIT_KEY_N	Numeric	This field must match the Entity Key of an existing Measurement Location or Lubrication Requirement. Either this field or Checkpoint ID is required.
Checkpoint ID	MI_CHECK_PT_CHEC_ID_C	Character (50)	This field must match the Checkpoint ID of an existing Measurement Location or Lubrication Requirement. Either this field or Related ML Entity Key is required.
Comment	MI_READING0_COMME_C	Character (255)	None
Action Taken	MI_READING0_ACTIO_TAKEN_C	Character (50)	Must use one of the Action Taken values specified for the related Measurement Location.
Reading Value Character	MI_READING0_RDG_VAL_CHAR_C	Character (50)	For Measurement Locations, must use one of the Allowable Values in the Category specified for the related Measurement Location. For Lubrication Requirements, must use a code in the system code table LR_CHAR_POSS_VALS (Possible values for Character type LRs). This field is disabled if the ML Type of the related Measurement Location is Numeric. It is always enabled for Lubrication Requirements.
Reading Value Numeric	MI_READING0_RDG_VAL_NUM_N	Numeric	For Measurement Locations, if a Category is specified for the related Measurement Location, must use one of the Allowable Values. This field is disabled if the ML Type of the related Measurement Location is Character or if the LR Type of the related Lubrication Requirement is Check Off.
Taken by	MI_READING0_RDG_TAKEN_BY_C	Character (50)	Must match an existing GE Digital APM User ID.
Reading Taken Date	MI_READING0_RDG_TAKEN_DT_D	Date	UTC time formatted as yyyy-mm-dd hh:mm:ss. Readings for the same Measurement Location or Lubrication Requirement should be ordered earliest first.