120Water Import Template Documentation

Column Header	Data Type & Restrictions
ASSET ID	This is the 120Water identifier for the service line the connector is associated to - this is a set of whole numbers
MATERIAL	Any option from the ServiceLineMaterial reference table (available from the left menu).
IS PRIMARY	True or False
EXTERNAL ID	Text field
NOTES	Text field
VERIFICATION METHOD	One of: Other Visual VisualMeter Visual Inspection at the Meter Pit VisualAtInsideBuilding Visual Inspection at/inside Building Customer Customer Self-Identification CctvInternal CCTV Inspection at Curb Box - Internal CctvExternal CCTV Inspection at Curb Box - External MechanicalExcavation Mechanical Excavation VacuumExcavation Vacuum Excavation Age Records
VERIFICATION DATE	A date: mm/dd/yyyy
VERIFIED BY	Text field

Connectors Import Template