What are the common ILI data elements for ingestion?

We've put together a list of required inline inspection data fields that are common across both single and multiple file import.  CIM utilizes these extensively and while we are continuously optimizing our ingestion engine to handle various formats and scenarios with unstructured data, we require the data to be minimally formatted based on the below structure.

The file can be in an excel (.xls or xlsx) or csv (.csv) format and the field names with an asterisk (*) are mandatory for any ILI file, and those with a double (**) asterisk are mandatory for volumetric (corrosion wall loss) feature types.

OneBridge Field Name	Field Type	Field Name Examples
*feature_type	text (50)	Weld, Feature, Pipe, Group, Dent, Mill Anomaly, etc.
feature_id	text (50)	Whole number, no decimals, no commas
*absolute_odometer	decimal (16,3)	Wheel Count (ft), Log Distance
us_weld_distance	decimal (16,3)	Distance from U/S Weld (ft)
ds_weld_distance	decimal (16,3)	Distance from D/S Weld (ft)
**length	decimal (10,3)	Length (in)
**width	decimal (10,3)	Width (in)
**orientation	float	Clock position, Degrees
seam_orientation	float	Seam position, Seam clock, Seam degrees
us_agm_distance	decimal (16,3)	Distance to U/S AGM (ft)
ds_agm_distance	decimal (16,3)	Distance to D/S AGM (ft)
**max_depth_percentage	decimal (10,3)	Anomaly Depth, % Depth of Anomaly
*measured_wall_thickness	decimal (10,4)	Wall Thickness, WT (in)
us_agm_reference	text (500)	U/S AGM (ft)
ds_agm_reference	text (500)	D/S AGM (ft)
b31g_maop	Decimal (5,0)	Segment MOP
b31g_erf	Decimal (14, 6)
mod31g.maop	decimal (5,0)
mod31g.erf	decimal (14, 6)
comments	text (700)	No carriage returns, no commas
internal_external	boolean	Internal or External Anomaly
latitude	float
longitude	float