120Water Import Template Documentation

Column Header	Data Type & Restrictions
120WATER LOCATION ID	Whole Number
EXTERNAL LOCATION ID	Text field
CUSTOMER ID	Text field
120WATER ASSET ID	Text field
EXTERNAL ASSET ID	Text field
ADDRESS LINE 1	Text field fewer than 100 characters long
ADDRESS LINE 2	Text field fewer than 100 characters long
CITY	Text field fewer than 60 characters long
STATE	Text field fewer than 50 characters long
ZIP	Text field A zip code in 5 or 5-4 format
COUNTY	Text field
MAILING ADDRESS LINE 1	Text field
MAILING ADDRESS LINE 2	Text field
MAILING CITY	Text field
MAILING STATE	Text field
MAILING ZIP	Text field A zip code in 5 or 5-4 format
BUILDING	Text field
NEIGHBORHOOD	Text field
LOCATION NAME	Text field
LATITUDE	Number With Decimal less than or equal to 90.0 greater than or equal to -90.0
LONGITUDE	Number With Decimal less than or equal to 180.0 greater than or equal to -180.0
GIS LOCATION ID	Text field
DWELR CODE	Text field
LCR TIER	One of: 1 Tier 1 Tier1 2 Tier 2 Tier2 3 Tier 3 Tier3 4 Tier 4 Tier4 5 Tier 5 Tier5
PROPERTY CLASSIFICATION	One of: null SingleFamilyResidence Single Family Residence Commercial Industrial Public MultiFamilyResidence Multi-Family Residence ElementarySchool Elementary School SecondarySchool Secondary School ChildcareFacility Childcare Facility NonResidential Non-Residential SingleFamilyResidenceWChildcare Single Family Residence w/ Childcare MultiFamilyResidenceWChildcare Multi-Family Residence w/ Childcare HospitalOrMedicalCareFacility Hospital or Medical Care Facility NursingHome Nursing Home Other
PARCEL NUMBER	Text field
YEAR BUILT	A four digit year: yyyy
LOT SQUARE FEET	Number With Decimal
WATER MAIN MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Ductile Iron Asbestos Concrete Brass Polyethylene Reinforced Concrete Iron Pipe 0 1 2 3 4 5 6 7 8 9 10 11 12 13
WATER MAIN SIZE	Number With Decimal
WATER MAIN INSTALLED YEAR	A four digit year: yyyy
CURB STOP MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Brass 0 1 2 3 4 5 6 7 8
CURB STOP SIZE	Number With Decimal
CURB STOP INSTALLED YEAR	A four digit year: yyyy
METER MATERIAL	One of: Cast Iron PVC Lead Copper Galvanized HDPE Unknown Brass 0 1 2 3 4 5 6 7 8
METER SIZE	Number With Decimal
METER INSTALLED YEAR	A four digit year: yyyy
OTHER BUILDINGS ON PROPERTY	True or False
HAS CHILDREN UNDER 7	True or False
HAS PREGNANT WOMEN	True or False
DISADVANTAGED NEIGHBORHOOD	True or False
PROPERTY OWNED BY BUSINESS	True or False
BUSINESS NAME	Text field
ESTIMATED HOME VALUE	Number With Decimal
NOTES	Text field fewer than 100 characters long
POINT OF ENTRY OR POINT OF USE TREATMENT	One of: Yes No Unknown
BUILDING PLUMBING LEAD SOLDER	One of: Yes No Unknown
CURRENT LCR SAMPLING SITE	One of: Yes No Unknown
SENSITIVE POPULATION	One of: No Yes - School Yes - Daycare Yes - Elementary School Yes - Multifamily Yes - Secondary School Yes - Other
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: mm/dd/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 StatisticalAnalysis Statistical Analysis PredictiveModeling Predictive Modeling Interpolation
CUSTOMER OWNED REMOVAL DATE	A date: mm/dd/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: mm/dd/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 StatisticalAnalysis Statistical Analysis PredictiveModeling Predictive Modeling Interpolation
SYSTEM OWNED REMOVAL DATE	A date: mm/dd/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: mm/dd/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
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 StatisticalAnalysis Statistical Analysis 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 StatisticalAnalysis Statistical Analysis 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: mm/dd/yyyy
CUSTOMER OWNED CLASSIFICATION BASIS NOTES	Text field
SYSTEM OWNED CLASSIFICATION BASIS NOTES	Text field

Location & Service Lines