All Layers and Tables (ServiceLine

Layers:

Layer: ServiceLine (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
accountid (type: esriFieldTypeString, alias: EPA ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
location (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sensitivepop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes - School: Yes - School], [Yes - Day Care: Yes - Day Care], [Yes - MF Home: Yes - Multifamily Home], ... 2 more ...)
disadvantaged (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilassetid (type: esriFieldTypeString, alias: Utility Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
utilmaterial (type: esriFieldTypeString, alias: Utility Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Copper: Copper], [Galvanized Steel: Galvanized Steel], ... 6 more ...)
everlead (type: esriFieldTypeString, alias: Ever Lead?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No], [U: Unknown])
utilinstalldate (type: esriFieldTypeDate, alias: Utility Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utildiameter (type: esriFieldTypeDouble, alias: Utility Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0.25: 1/4"], [0.5: 1/2"], ... 18 more ...)
utilverified (type: esriFieldTypeString, alias: Utility Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilverifmethod (type: esriFieldTypeString, alias: Utility Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external], ... 4 more ...)
utilverifdate (type: esriFieldTypeDate, alias: Utility Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilstatus (type: esriFieldTypeString, alias: Utility Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Unknown: Unknown])
utilnotes (type: esriFieldTypeString, alias: Utility Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
custassetid (type: esriFieldTypeString, alias: Customer Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
custmaterial (type: esriFieldTypeString, alias: Customer Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Copper: Copper], [Galvanized Steel: Galvanized Steel], ... 6 more ...)
custinstalldate (type: esriFieldTypeDate, alias: Customer Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custdiameter (type: esriFieldTypeDouble, alias: Customer Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Unknown], [0.25: 1/4"], [0.5: 1/2"], ... 18 more ...)
custverified (type: esriFieldTypeString, alias: Customer Side Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
custverifmethod (type: esriFieldTypeString, alias: Customer Verification Method, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Visual inspection at the meter pit: Visual inspection at the meter pit], [Customer self-identification: Customer self-identification], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], ... 5 more ...)
custverifdate (type: esriFieldTypeDate, alias: Customer Verification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custstatus (type: esriFieldTypeString, alias: Customer Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Lead: Lead], [Non-Lead: Non-Lead], ... 1 more ...)
custnotes (type: esriFieldTypeString, alias: Customer Side Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
bothsidesstatus (type: esriFieldTypeString, alias: Full Service Line Lead Classification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Galvanized Requiring Replacement: Galvanized Requiring Replacement], ... 1 more ...)
leadsolder (type: esriFieldTypeString, alias: Lead Solder in Service Line, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Don't Know: Don't Know])
otherfittings (type: esriFieldTypeString, alias: Premise Other Fittings Containing Lead, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
buildingtype (type: esriFieldTypeString, alias: Building Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Building: Building], [Other: Other], [Single Family: Single Family], ... 1 more ...)
pointofentry (type: esriFieldTypeString, alias: Premise Point-of-Entry or Point-of-Use, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
copperwithlead (type: esriFieldTypeString, alias: Premise Copper Pipes with Lead Solder Before Lead Ban, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
samplingsite (type: esriFieldTypeString, alias: Compliance Sampling Site, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
utilscheddate (type: esriFieldTypeDate, alias: Utility Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilreplacedate (type: esriFieldTypeDate, alias: Utility Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custscheddate (type: esriFieldTypeDate, alias: Customer Side Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custreplacedate (type: esriFieldTypeDate, alias: Customer Side Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
filter (type: esriFieldTypeString, alias: Water Pitcher Filter, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Never Required: Never Required], [Required: Required])
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
filterscheddate (type: esriFieldTypeDate, alias: Water Pitcher Filter Date Scheduled, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
filterprovidedate (type: esriFieldTypeDate, alias: Water Pitcher Filter Date Provided, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
serviceuse (type: esriFieldTypeString, alias: Service Line Use, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Irrigation: Irrigation], [Fire: Fire], [Potable: Potable], ... 1 more ...)
utilpredmat (type: esriFieldTypeString, alias: Utility Predicted Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
utilpredprob (type: esriFieldTypeDouble, alias: Utility Predicted Material Probability, SQL Type: sqlTypeOther, nullable: true, editable: true)
custpredmat (type: esriFieldTypeString, alias: Customer Predicted Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
custpredprob (type: esriFieldTypeDouble, alias: Customer Predicted Material Probability, SQL Type: sqlTypeOther, nullable: true, editable: true)
servicestatus (type: esriFieldTypeString, alias: Service Line Working Status , SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [In Service: In Service], [Out of Service: Out of Service], [Abandoned/Disconnected: Abandoned/Disconnected])
lastmodeldate (type: esriFieldTypeDate, alias: Predictive Model Last Run Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
connectorstatus (type: esriFieldTypeString, alias: Connector Classification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Unknown: Unknown], [Copper: Copper], ... 2 more ...)
connectorscheddate (type: esriFieldTypeDate, alias: Connector Scheduled Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
connectorreplacedate (type: esriFieldTypeDate, alias: Connector Replacement Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
utilreplacestatus (type: esriFieldTypeString, alias: Utility Side Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 3 more ...)
custreplacestatus (type: esriFieldTypeString, alias: Customer Side Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Needs Replacement: Needs Replacement], [Scheduled Replacement: Scheduled Replacement], ... 4 more ...)
custresponsetotal (type: esriFieldTypeString, alias: Customer Response to Replacement Requests, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Approved Replacement: Approved Replacement], [Denied Replacement: Denied Replacement], [Doesn't Need Replacement: Doesn't Need Replacement], ... 7 more ...)
custmaterialoriginal (type: esriFieldTypeString, alias: Customer Material Original, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Lead-lined galvanized: Lead-lined galvanized], [Galvanized: Galvanized], ... 6 more ...)
utilmaterialoriginal (type: esriFieldTypeString, alias: Utility Material Original, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Lead: Lead], [Lead-lined galvanized: Lead-lined galvanized], [Galvanized: Galvanized], ... 6 more ...)
tier (type: esriFieldTypeString, alias: Tier, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Tier 1: Tier 1], [Tier 2: Tier 2], [Tier 3: Tier 3], ... 3 more ...)
utilmaterialreplaced (type: esriFieldTypeString, alias: Utility Side Replaced Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other])
custmaterialreplaced (type: esriFieldTypeString, alias: Customer Side Replaced Material, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Non-Lead - Copper: Non-Lead - Copper], [Non-Lead - Plastic: Non-Lead - Plastic], [Non-Lead - Other: Non-Lead - Other])
replacestatus (type: esriFieldTypeString, alias: Full Line Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Doesn't Need Replacement: Doesn't Need Replacement], [Both Sides Need Replaced: Both Sides Need Replaced], [Utility Side Needs Replaced: Utility Side Needs Replaced], ... 10 more ...)
custbasisclass (type: esriFieldTypeString, alias: Customer Basis of Material Classification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Water sampling only with no records: Water sampling only with no records], [Field inspection only with no records: Field inspection only with no records], ... 6 more ...)
utilbasisclass (type: esriFieldTypeString, alias: Utility Basis of Material Classification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Water sampling only with no records: Water sampling only with no records], [Field inspection only with no records: Field inspection only with no records], ... 6 more ...)
replpriorityrank (type: esriFieldTypeInteger, alias: Replacement Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
schoolpriorityrank (type: esriFieldTypeInteger, alias: School Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
ccpriorityrank (type: esriFieldTypeInteger, alias: Childcare Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
newcustomerdate (type: esriFieldTypeDate, alias: newcustomerdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Relationships:

Notifications (0) -- Related To: Notifications (1)
SchoolChildcareSampling (1) -- Related To: School_Childcare_Sampling (2)
Sampling (2) -- Related To: Sampling (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

Notifications (1)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
notifreason (type: esriFieldTypeString, alias: Reason for Notification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Material Requires Notification: Material Requires Notification], [Service Line Replacement: Service Line Replacement], [Service Line Disturbance: Service Line Disturbance], ... 3 more ...)
notifmethod (type: esriFieldTypeString, alias: Notification Method, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Phone: Phone], [Mail: Mail], [Email: Email], ... 3 more ...)
notifdate (type: esriFieldTypeDate, alias: Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
custresponse (type: esriFieldTypeString, alias: Customer Response to Notification, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Approved Replacement: Approved Replacement], [Denied Replacement: Denied Replacement], [Approved Sampling: Approved Sampling], ... 1 more ...)
nonresponsive (type: esriFieldTypeString, alias: Non-Responsive for 30 Days, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [Not Yet: Not Yet], [Customer Responded: Customer Responded])
custresponsedate (type: esriFieldTypeDate, alias: Customer Response Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Relationships:

Notifications (0) -- Related To: ServiceLine (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

School_Childcare_Sampling (2)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
facilitytype (type: esriFieldTypeString, alias: Facility Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [School: School], [Childcare: Childcare], [Both School and Childcare: Both School and Childcare])
sampledby (type: esriFieldTypeString, alias: Sampled By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [School Childcare Staff: School Childcare Staff], [Utility: Utility], [Other: Other])
sampledate (type: esriFieldTypeDate, alias: Sampling Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
resultdate (type: esriFieldTypeDate, alias: Result Received Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
leadssite1 (type: esriFieldTypeDouble, alias: Lead - School Site 1 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadssite2 (type: esriFieldTypeDouble, alias: Lead - School Site 2 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadssite3 (type: esriFieldTypeDouble, alias: Lead - School Site 3 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadssite4 (type: esriFieldTypeDouble, alias: Lead - School Site 4 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadssite5 (type: esriFieldTypeDouble, alias: Lead - School Site 5 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
labIDs1 (type: esriFieldTypeString, alias: Lab Sample ID - School Site 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
labIDs2 (type: esriFieldTypeString, alias: Lab Sample ID - School Site 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
labIDs3 (type: esriFieldTypeString, alias: Lab Sample ID - School Site 3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
labIDs4 (type: esriFieldTypeString, alias: Lab Sample ID - School Site 4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
labIDs5 (type: esriFieldTypeString, alias: Lab Sample ID - School Site 5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ssite1 (type: esriFieldTypeString, alias: School Site 1 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ssite2 (type: esriFieldTypeString, alias: School Site 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ssite3 (type: esriFieldTypeString, alias: School Site 3 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ssite4 (type: esriFieldTypeString, alias: School Site 4 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ssite5 (type: esriFieldTypeString, alias: School Site 5 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
leadccsite1 (type: esriFieldTypeDouble, alias: Lead - CC Site 1 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadccsite2 (type: esriFieldTypeDouble, alias: Lead - CC Site 2 (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
labIDcc1 (type: esriFieldTypeString, alias: Lab Sample ID - CC Site 1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
labIDcc2 (type: esriFieldTypeString, alias: Lab Sample ID - CC Site 2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ccsite1 (type: esriFieldTypeString, alias: CC Site 1 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ccsite2 (type: esriFieldTypeString, alias: CC Site 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
waiver (type: esriFieldTypeString, alias: Waiver Granted for Previous Sampling, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
resultnotifieddate (type: esriFieldTypeDate, alias: Sample Result Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
sampledeliverdate (type: esriFieldTypeDate, alias: Sample Kit Delivered Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
scheduledate (type: esriFieldTypeDate, alias: Sample Schedule Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
schoolpriorityrank (type: esriFieldTypeInteger, alias: School Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
ccpriorityrank (type: esriFieldTypeInteger, alias: Childcare Priority Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
location (type: esriFieldTypeString, alias: Other Location Identifier, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Relationships:

SchoolChildcareSampling (1) -- Related To: ServiceLine (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Sampling (3)

Name:

Display Field:

Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
leadfirstliter (type: esriFieldTypeDouble, alias: Lead - 1st Liter (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
leadfifthliter (type: esriFieldTypeDouble, alias: Lead - 5th Liter (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
copperfirstliter (type: esriFieldTypeDouble, alias: Copper - 1st Liter (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
labsampleidfirst (type: esriFieldTypeString, alias: Lab Sample ID - 1st Liter, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
labsampleidfifth (type: esriFieldTypeString, alias: Lab Sample ID - 5th Liter, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
assetguid (type: esriFieldTypeGUID, alias: Asset Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
highresultlead (type: esriFieldTypeDouble, alias: Lead - Higher Result, SQL Type: sqlTypeOther, nullable: true, editable: true)
resultdate (type: esriFieldTypeDate, alias: Result Received Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
samplingreason (type: esriFieldTypeString, alias: Reason for Sampling, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Compliance for 90th Percentile: Compliance for 90th Percentile], [Voluntary: Voluntary], [Post Replacement: Post Replacement])
sampledby (type: esriFieldTypeString, alias: Sampled By, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Homeowner: Homeowner], [Utility: Utility], [Other: Other])
sampledate (type: esriFieldTypeDate, alias: Sampling Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
resultnotifieddate (type: esriFieldTypeDate, alias: Sample Result Notification Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
sampledeliverdate (type: esriFieldTypeDate, alias: Sample Kit Delivered Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
replacestatus (type: esriFieldTypeString, alias: Full Line Replacement Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
tier (type: esriFieldTypeString, alias: Tier, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
postreplacementsampling (type: esriFieldTypeDate, alias: Date to Start Post Replacement Sampling Activities, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
samplingsite (type: esriFieldTypeString, alias: Compliance Sampling Site, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
samplingperiod (type: esriFieldTypeString, alias: Sampling Period Year, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Relationships:

Sampling (2) -- Related To: ServiceLine (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: