Name: School_Childcare_Sampling

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

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: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/31/2026 6:32:56 PM

Schema Last Edit Date: 5/27/2026 7:30:43 PM

Data Last Edit Date: 8/31/2026 6:32:56 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat