Str_Prim_PM2 (type: esriFieldTypeString, alias: (AA) STRUCTURE-PRIMARY PLUMBING MATERIAL 2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Copper: Copper], [Copper Pipe with Lead Solder: Copper Pipe with Lead Solder], ... 5 more ...)
Bldg_PM_Ins_Date (type: esriFieldTypeString, alias: (AB) BUILDING PLUMBING MATERIAL INSTALL DATE, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Before 1989: Before 1989], [Between 1989 and 2014: Between 1989 and 2014], [After 2014: After 2014], ... 1 more ...)
samplingsite (type: esriFieldTypeString, alias: (AC) IS THIS LOCATION TO BE USED FOR A LEAD AND COPPER SAMPLE SITE PLAN?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
YEAR_INSTALLED (type: esriFieldTypeSmallInteger, alias: (G) PWS SERVICE LINE INSTALL DATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
INLET_MATERIAL (type: esriFieldTypeString, alias: (I) CURRENT PUBLIC SERVICE LINE MATERIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Copper: Copper], [HDPE: HDPE], [PVC: PVC], ... 6 more ...)
Ver_Source_Util (type: esriFieldTypeString, alias: (K) VERIFICATION SOURCE (Public Side), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Records Only: Records Only], [Installation Date After Lead Ban: Installation Date After Lead Ban], [Field Inspection Only: Field Inspection Only], ... 4 more ...)
RecordVerDate (type: esriFieldTypeDate, alias: (L) RECORD VERIFICATION DATE (PUBLIC SIDE), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilverified (type: esriFieldTypeString, alias: (M) DESCRIBE THE FIELD VERIFICATION METHOD (PUBLIC SIDE), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Customer self-identification: Customer Self-Identification], [CCT investigation at curb stop internal: CCT investigation at curb stop internal], [CCT investigation at curb stop external: CCT investigation at curb stop external], ... 4 more ...)
OUTLET_MATERIAL (type: esriFieldTypeString, alias: (Q) CURRENT CUSTOMER SERVICE LINE MATERIAL , SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Copper: Copper], [HDPE: HDPE], [PVC: PVC], ... 6 more ...)
Ver_Source_Cust (type: esriFieldTypeString, alias: (S) VERIFICATION SOURCE (CUSTOMER SIDE), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Records Only: Records Only], [Field Inspection Only: Field Inspection Only], [Records Validation: Records Validation], ... 4 more ...)
RecordVerDate2 (type: esriFieldTypeDate, alias: (T) RECORD VERIFICATION DATE (CUSTOMER SIDE), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custverified (type: esriFieldTypeString, alias: (U) DESCRIBE THE FIELD VERIFICATION METHOD (CUSTOMER SIDE), SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [Customer self-identification: Customer Self-Identification], [CCT investigation at curb stop internal: CCT investigation at curb stop internal], [CCT investigation at curb stop external: CCT investigation at curb stop external], ... 4 more ...)
buildingtype (type: esriFieldTypeString, alias: (X) BUILDING TYPE/USE, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Meter pit/Single Service Connection: Meter pit/Single Service Connection], [Single Family: Single Family], [Multi-Family: Multi-Family], ... 6 more ...)
Str_Prim_PM1 (type: esriFieldTypeString, alias: (Z) STRUCTURE-PRIMARY PLUMBING MATERIAL 1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Copper: Copper], [Copper Pipe with Lead Solder: Copper Pipe with Lead Solder], ... 5 more ...)
UtilityNotes (type: esriFieldTypeString, alias: MAIN TO CURB STOP - EXTERNAL NOTES, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
DATE_OF_LSLR (type: esriFieldTypeDate, alias: MONTH OF LEAD SERVICE LINE REPLACEMENT, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)