120Water Import Template Documentation

Column Header	Data Type & Restrictions
120WATER LOCATION ID	Whole Number
EXTERNAL LOCATION ID	Text field
120WATER ASSET ID	Whole Number
EXTERNAL ASSET ID	Text field
DESCRIPTION	Text field
STATUS	One of: InService OutOfService Abandoned Removed Replaced Stubbed
CUSTOMER OWNED MATERIAL	Any option from the ServiceLineMaterial reference table (available from the left menu).
CUSTOMER OWNED LEAD SOLDER	One of: Yes No Unknown
CUSTOMER OWNED VERIFIED BY	Text field
CUSTOMER OWNED VERIFIED DATE	A date or year: mm/dd/yyyy or yyyy
CUSTOMER OWNED VERIFICATION METHOD	One of: null VisualExcavation Visual - Excavation Records Age Other Visual VisualSwab Visual - Swab 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
CUSTOMER OWNED REMOVAL DATE	A date or year: mm/dd/yyyy or yyyy
CUSTOMER OWNED INSTALLED DATE	A date or year: mm/dd/yyyy or yyyy
CUSTOMER OWNED LINE DEPTH	Whole Number greater than or equal to 0.0
CUSTOMER OWNED LINE DIAMETER	Any option from the ServiceLineDiameter reference table (available from the left menu).
SYSTEM OWNED MATERIAL	Any option from the ServiceLineMaterial reference table (available from the left menu).
SYSTEM OWNED LEAD SOLDER	One of: Yes No Unknown
SYSTEM OWNED VERIFIED BY	Text field
SYSTEM OWNED VERIFIED DATE	A date or year: mm/dd/yyyy or yyyy
SYSTEM OWNED VERIFICATION METHOD	One of: null VisualExcavation Visual - Excavation Records Age Other Visual VisualSwab Visual - Swab 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
SYSTEM OWNED REMOVAL DATE	A date or year: mm/dd/yyyy or yyyy
SYSTEM OWNED INSTALLED DATE	A date or year: mm/dd/yyyy or yyyy
SYSTEM OWNED LINE DEPTH	Whole Number greater than or equal to 0.0
SYSTEM OWNED LINE DIAMETER	Any option from the ServiceLineDiameter reference table (available from the left menu).
LEAD FITTINGS	One of: Yes No Unknown
FITTING VERIFIED BY	Text field
FITTINGS VERIFIED DATE	A date or year: mm/dd/yyyy or yyyy
FITTINGS VERIFICATION METHOD	One of: Other Visual VisualSwab Visual - Swab 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
LATITUDE	Number With Decimal
LONGITUDE	Number With Decimal
SYSTEM OWNED CLASSIFICATION BASIS	One of: null Other Age Modeling Records Visual Excavation Visual - Excavation Meter Visual - Meter NotAvailable N/A PredictiveModeling Predictive Modeling Swab Visual - Swab WQSTargeted Water Quality Sampling - Targeted WQSFlushed Water Quality Sampling - Flushed WQSSequential Water Quality Sampling - Sequential WQSOther Water Quality Sampling - Other ServiceLine2 Service Line > 2" OperatorInterview Operator Interview CustomerIdentification Customer Identification Interpolation
CUSTOMER OWNED CLASSIFICATION BASIS	One of: null Other Age Modeling Records Visual Excavation Visual - Excavation Meter Visual - Meter NotAvailable N/A PredictiveModeling Predictive Modeling Swab Visual - Swab WQSTargeted Water Quality Sampling - Targeted WQSFlushed Water Quality Sampling - Flushed WQSSequential Water Quality Sampling - Sequential WQSOther Water Quality Sampling - Other ServiceLine2 Service Line > 2" OperatorInterview Operator Interview CustomerIdentification Customer Identification Interpolation
SYSTEM OWNED NOTES	Text field
CUSTOMER OWNED NOTES	Text field
SYSTEM OWNED PREVIOUSLY LEAD	One of: Yes No Unknown
LEAD SOLDER	One of: Yes No Unknown
OTHER LEAD EQUIPMENT	Text field
CUSTOMER OWNED VERIFIED	True or False
SYSTEM OWNED VERIFIED	True or False
SYSTEM OWNED MATERIAL OTHER	Text field
SYSTEM OWNED VERIFICATION METHOD OTHER	Text field
CUSTOMER OWNED MATERIAL OTHER	Text field
CUSTOMER OWNED VERIFICATION METHOD OTHER	Text field
FITTINGS VERIFICATION METHOD OTHER	Text field
SYSTEM OWNED INSTALLED AFTER LEAD BAN	One of: Yes No Unknown N/A
CUSTOMER OWNED INSTALLED AFTER LEAD BAN	One of: Yes No Unknown N/A
OWNERSHIP	One of: Split System-Owned Customer-Owned Unknown
SYSTEM OWNED DIAMETER OVER TWO INCHES	True or False
CUSTOMER OWNED DIAMETER OVER TWO INCHES	True or False
CONSUMER NOTICE COMPLETED	True or False
CONSUMER NOTICE COMPLETION DATE	A date or year: mm/dd/yyyy or yyyy
CUSTOMER OWNED CLASSIFICATION BASIS NOTES	Text field
SYSTEM OWNED CLASSIFICATION BASIS NOTES	Text field

Service Lines Import Template