Name: Inspection_Development

Display Field: fac_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -94.50686
YMin: 38.5680050070001
XMax: -92.1524799859999
YMax: 38.8130100000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,0,0,255],"size":8,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,0,255],"width":1}},"label":"BEHS - CC","description":"Survey Data Locations"},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

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)
• fac_dvn (type: esriFieldTypeString, alias: DVN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• esri_user_query (type: esriFieldTypeString, alias: Assigned Username, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• fac_purpose (type: esriFieldTypeString, alias: Purpose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [INITIAL: INITIAL], [EMERGENCY: EMERGENCY REQUEST], [SPECIAL CIRCUMSTANCE: SPECIAL CIRCUMSTANCE], ... 6 more ...)
• fac_name (type: esriFieldTypeString, alias: Establishment name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STATE_VENDOR_NO (type: esriFieldTypeString, alias: STATE_VENDOR_NO, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CONTRACT_NO (type: esriFieldTypeString, alias: CONTRACT_NO, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• CONTRACT_NAME (type: esriFieldTypeString, alias: CONTRACT_NAME, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• VENDOR_REMIT (type: esriFieldTypeString, alias: VENDOR_REMIT, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Atrate (type: esriFieldTypeInteger, alias: Attempt Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Srate (type: esriFieldTypeInteger, alias: SC Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Rrate (type: esriFieldTypeInteger, alias: Reinspection Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Arate (type: esriFieldTypeInteger, alias: Annual Rate:, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• lpha_name (type: esriFieldTypeString, alias: LPHA Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• fac_county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspection_pass_new (type: esriFieldTypeString, alias: Inspection Pass, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• inspection_date_new (type: esriFieldTypeDate, alias: Inspection Date (New), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• state_lpha (type: esriFieldTypeString, alias: What agency is completing inspection?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• participating_lpha (type: esriFieldTypeString, alias: Is this a DHSS inspection system user?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• manual_remove (type: esriFieldTypeString, alias: Manually Remove, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [None: None], [Remove: Remove])
• close_request (type: esriFieldTypeString, alias: Close Request Reason, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [DESE sent request in error: DESE sent request in error], [No Response from Facility: Facility never responded to repeated attempts to schedule an inspection], [Facility withdrew request: Facility withdrew request], ... 3 more ...)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• fac_request_date (type: esriFieldTypeDate, alias: Request Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• fac_phone (type: esriFieldTypeString, alias: Establishment Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_email (type: esriFieldTypeString, alias: Facility Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_contactname (type: esriFieldTypeString, alias: Facility Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_establishment_geocode (type: esriFieldTypeString, alias: Full address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_zip (type: esriFieldTypeString, alias: ZIP code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_district (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_water_sewer (type: esriFieldTypeString, alias: Water/Sewer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [PRIVATE: PRIVATE], [PUBLIC: PUBLIC], [PRIVATE WATER/PUBLIC SEWER: PRIVATE WATER/PUBLIC SEWER], ... 1 more ...)
• fac_type (type: esriFieldTypeString, alias: Type of Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CHILD CARE CENTER: CHILD CARE CENTER], [FAMILY HOME: FAMILY HOME], [GROUP HOME: GROUP HOME], ... 1 more ...)
• fac_status (type: esriFieldTypeString, alias: Facility Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [ACTIVE: ACTIVE], [PENDING: PENDING])
• fac_capacity (type: esriFieldTypeDouble, alias: Facility Capacity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fac_age_range (type: esriFieldTypeString, alias: Age Range, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_shifts (type: esriFieldTypeString, alias: Shifts, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_circumstance (type: esriFieldTypeString, alias: Special Circumstances, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_Supervisor (type: esriFieldTypeString, alias: Supervisor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [AARON WINSLOW: AARON WINSLOW], [ANN WINKLER: ANN WINKLER], [EDITH TODD: EDITH TODD], ... 12 more ...)
• fac_Supervisor_email (type: esriFieldTypeString, alias: Supervisor Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspector_name (type: esriFieldTypeString, alias: Inspector's Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [name: name], [AARON WINSLOW: AARON WINSLOW], [AMANDA BOERTIEN: AMANDA BOERTIEN], ... 21 more ...)
• inspector_phone (type: esriFieldTypeString, alias: Inspector Telephone Number:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_inspector_email (type: esriFieldTypeString, alias: Inspector Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fac_checklist_date (type: esriFieldTypeDate, alias: Checklist Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• req_to_ephs (type: esriFieldTypeDate, alias: Assigned Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspection_due_date (type: esriFieldTypeDate, alias: Supervisor Assigned Inspection Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• fac_comments (type: esriFieldTypeString, alias: Facility Comments, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• gh_time_in (type: esriFieldTypeDate, alias: Arrival Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• gh_inspection_date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• gh_a1 (type: esriFieldTypeString, alias: 1. Clean and free of unsanitary conditions., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a2 (type: esriFieldTypeString, alias: 2. No environmental hazards observed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a3 (type: esriFieldTypeString, alias: 3. No evidence of insects, spiders, rodents or pest harborage., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a4 (type: esriFieldTypeString, alias: 4. Well ventilated, no evidence of mold, noxious or harmful odors., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a5 (type: esriFieldTypeString, alias: 5. Screens on windows and doors used for ventilation in good repair., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a6 (type: esriFieldTypeString, alias: 6. No indications of lead hazards., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a7 (type: esriFieldTypeString, alias: 7. No toxic or dangerous plants accessible to children., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a8 (type: esriFieldTypeString, alias: 8. Medicines and other toxic agents not accessible to children and stored to prevent contamination of child contact items., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a9 (type: esriFieldTypeString, alias: 9. All sinks equipped and mixing faucets or combination faucets with hot and cold running water under pressure., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a10 (type: esriFieldTypeString, alias: 10. Hot water temperature at sinks accessible to children: 100 degrees - 120 degrees F., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a10_b (type: esriFieldTypeString, alias: Temp(s) at time of inspection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_a11 (type: esriFieldTypeString, alias: 11. Pets free of diseases communicable to man., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a12 (type: esriFieldTypeString, alias: 12. Pets living quarters clean and well maintained., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a13 (type: esriFieldTypeString, alias: 13. Reptiles prohibited on the premises. Birds of the Parrot Family tested for Psittacosis., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a14 (type: esriFieldTypeString, alias: 14. Swimming/wading pools filtered, treated, tested and water quality records maintained. Meets local codes., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a15 (type: esriFieldTypeString, alias: 15. A minimum of 18[double_quote] separation between drinking fountains and hand sinks., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_a16 (type: esriFieldTypeString, alias: 16. No high hazard cross connections., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_a_observations (type: esriFieldTypeString, alias: gh_section_a_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_a_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_b1 (type: esriFieldTypeString, alias: 1. Select Water Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Community: Community], [Non-Community: Non-Community], [Private: Private])
• gh_b3_private (type: esriFieldTypeString, alias: 1. Constructed to prevent contamination., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_b4_private (type: esriFieldTypeString, alias: 2. Meets DHSS water quality requirements., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_b5 (type: esriFieldTypeString, alias: A. Bacteriological sample results:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_b6 (type: esriFieldTypeString, alias: B. Chemical sample results:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_b_observations (type: esriFieldTypeString, alias: gh_section_b_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_b_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_c1 (type: esriFieldTypeString, alias: Select Sewer Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Community: Community], [On-Site: On-Site])
• gh_c2 (type: esriFieldTypeString, alias: 1. DNR Regulated System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_c4 (type: esriFieldTypeString, alias: 2. DHSS Regulated System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_c9 (type: esriFieldTypeString, alias: Meets DHSS requirements., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_c10 (type: esriFieldTypeString, alias: 3. Meets local requirements., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_c_observations (type: esriFieldTypeString, alias: gh_section_c_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_c_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_d1 (type: esriFieldTypeString, alias: 1. Caregivers and children wash hands using soap, warm running water and sanitary hand drying methods., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_d2 (type: esriFieldTypeString, alias: 2. Care givers and children wash hands BEFORE: preparing, serving, and eating food; glove use. AFTER: toileting, diapering, assisting with toileting, nose blowing, handling raw food, glove use, cleaning and sanitizing, outdoor play, handling animals, eating, smoking, and as necessary., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_d3 (type: esriFieldTypeString, alias: 3. Personnel preparing food free of infection or illness., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_d_observations (type: esriFieldTypeString, alias: gh_section_d_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_d_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_e1 (type: esriFieldTypeString, alias: 1. Food from an approved source and in sound condition; no excessively dented cans., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e2 (type: esriFieldTypeString, alias: 2. No use of home-canned food. No unpasteurized milk., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e3 (type: esriFieldTypeString, alias: 3. Ground beef cooked to 155° F; poultry and pooled eggs to 165° F; pork to 145°F; and all other foods cooked to at least 135° F; all hot food kept at 135° F or above., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e4 (type: esriFieldTypeString, alias: 4. Precooked food reheated to 165° F., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e5 (type: esriFieldTypeString, alias: 5. Food requiring refrigeration stored at 41° F or below.., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e6_a (type: esriFieldTypeString, alias: 6. Refrigerator 41° F or below, accessible readable thermometer required. Foods in freezer frozen solid., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e6_b (type: esriFieldTypeString, alias: 6b.Temp(s) at time of inspection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_e7 (type: esriFieldTypeString, alias: 7. Metal stemmed thermometer reading 0 - 220° F in 2° increments for checking food temperatures., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e8 (type: esriFieldTypeString, alias: 8. Food, food related items and utensils covered and stored to prevent contamination by pests, toxic agents, cleaning agents, water drain lines, medicines, dust, splash and other foods., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e9 (type: esriFieldTypeString, alias: 9. Food, toxic agents, cleaning agents not in their original containers shall be properly labeled., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e10 (type: esriFieldTypeString, alias: 10. No food stored or prepared in diapering areas or bathrooms., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e11 (type: esriFieldTypeString, alias: 11. Food stored in food grade containers only., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e12 (type: esriFieldTypeString, alias: 12. Food thawed under refrigeration, 70° F running water, or microwave if part of the cooking process., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e13 (type: esriFieldTypeString, alias: 13. No animals in food preparation or food storage areas., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e14 (type: esriFieldTypeString, alias: 14. No eating, smoking, drinking during food preparation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e15 (type: esriFieldTypeString, alias: 15. Food served and not eaten shall not be re-served to children in care., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_e16 (type: esriFieldTypeString, alias: 16. Refrigerated potentially hazardous foods properly marked with 7-day discard date after opening or preparation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_e_observations (type: esriFieldTypeString, alias: gh_section_e_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_e_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_f1 (type: esriFieldTypeString, alias: 1. All items requiring sanitizing shall be washed, rinsed, and sanitized with approved agents, methods, and concentrations., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f2 (type: esriFieldTypeString, alias: 2. All utensils and toys air dried., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3 (type: esriFieldTypeString, alias: 3. The following items washed, rinsed and sanitized after each use:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3_a (type: esriFieldTypeString, alias: 3A. Food utensils, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3_b (type: esriFieldTypeString, alias: 3B. Food contact surfaces including eating surfaces, high chairs, etc., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3_c (type: esriFieldTypeString, alias: 3C. Potty chairs and adapter seats., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3_d (type: esriFieldTypeString, alias: 3D. Diapering surfaces., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f3_e (type: esriFieldTypeString, alias: 3E. All toys that have had contact with body fluids., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f4 (type: esriFieldTypeString, alias: 4. The following items washed, rinsed and sanitized after each use:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f4_a (type: esriFieldTypeString, alias: 4A. Toilets, urinals, handsinks., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f4_b (type: esriFieldTypeString, alias: 4B. Non-absorbant floors in infant/toddler spaces., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f4_c (type: esriFieldTypeString, alias: 4C. Infant/Toddler toys used during the day., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f5 (type: esriFieldTypeString, alias: 5. Walls, ceiling, and floors clean and in good repair. Cleaned and sanitized when contacted by body fluids., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f6 (type: esriFieldTypeString, alias: 6. Appropriate test strips available to check proper concentration of sanitizing agents., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_f7 (type: esriFieldTypeString, alias: 7. Soiled laundry stored and handled in a manner which does not contaminate food and food related items and child contact items., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_f_observations (type: esriFieldTypeString, alias: gh_section_f_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_f_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_g1 (type: esriFieldTypeString, alias: 1.Single service items not reused., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g2 (type: esriFieldTypeString, alias: 2. All food equipment and utensils in good repair., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g3 (type: esriFieldTypeString, alias: 3. Food preparation and storage areas have adequate lighting., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g4 (type: esriFieldTypeString, alias: 4. Kitchen equipment that produces excessive grease laden vapors, moisture, or heat is properly vented., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g5 (type: esriFieldTypeString, alias: 5. Facilities shall have a dedicated mechanical refrigeration for facility use only.Exception: License-Exempt facilities approved BEFORE October 31, 1997., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g6 (type: esriFieldTypeString, alias: 6. No carpeting or absorbent floor coverings in food preparation areas., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g7 (type: esriFieldTypeString, alias: 7. Adequate preparation and storage equipment for hot foods., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g8 (type: esriFieldTypeString, alias: 8. Facilities with a capacity of 20 children or less shall have:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_g8a (type: esriFieldTypeString, alias: A. Mechanical dishwasher that sanitizes; or employ an additional sanitizing rinse in conjunction with the mechanical dishwasher; or a 3 compartment sink or a 2 compartment sink with a third portable compartment for the final sanitizing step., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g8b (type: esriFieldTypeString, alias: B. If a mechanical dishwasher is used, a minimum of two sinks located in the food preparation area labeled as: 1) Hand washing only 2) Food preparation only., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g9 (type: esriFieldTypeString, alias: 9. Facilities with a capacity of more than 20 children approved BEFORE October 31, 1991, shall have:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_g9a (type: esriFieldTypeString, alias: A. Mechanical dishwasher that sanitizes; or employ an additional sanitizing rinse in conjunction with the mechanical dishwasher; or use a 3 compartment sink., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g9b (type: esriFieldTypeString, alias: B. If a mechanical dishwasher is used, a minimum of two sinks located in food preparation areas labeled as: 1) Hand washing only 2) Food preparation only., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g10 (type: esriFieldTypeString, alias: 10. Facilities with a capacity of more than 20 children approved AFTER October 31, 1991 shall have:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_g10a (type: esriFieldTypeString, alias: A. Facilities located in a provider's residence shall have separate food preparation and storage areas., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g10b (type: esriFieldTypeString, alias: B. A commercial dishwasher or a 3 compartment sink in addition to a separate hand washing sink., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_g10c (type: esriFieldTypeString, alias: C. If a commercial dishwasher is used, a sink located in the food preparation area labeled as food preparation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_g_observations (type: esriFieldTypeString, alias: gh_section_g_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_g_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_h1 (type: esriFieldTypeString, alias: 1.Catered food from inspected and approved source., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_h2 (type: esriFieldTypeString, alias: 2. Safe food temperature maintained during transport., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_h2_b (type: esriFieldTypeString, alias: 2B. Temperature at arrival:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_h3 (type: esriFieldTypeString, alias: 3. Facility using catered food exclusively shall have a hand washing sink in kitchen/food service area., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_h4 (type: esriFieldTypeString, alias: 4. Facility not using single service utensils exclusively meets applicable dishwashing requirements as stated in Section G(8), G(9), or G(10)., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_h5 (type: esriFieldTypeString, alias: 5. Food and food related items protected from contamination during transport., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_h_observations (type: esriFieldTypeString, alias: gh_section_h_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_h_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_i1 (type: esriFieldTypeString, alias: 1.Cleaned as needed or at least daily., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i2 (type: esriFieldTypeString, alias: 2. Paper towels stored and dispensed in a manner that minimizes contamination. All equipment in good repair., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i3 (type: esriFieldTypeString, alias: 3. Facilities approved AFTER October 31, 1991 have:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_i3a (type: esriFieldTypeString, alias: Enclosed with full walls and solid doors. Doors closed when not in use., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i4 (type: esriFieldTypeString, alias: 4. Facilities approved AFTER October 31, 1998 have:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_i4a (type: esriFieldTypeString, alias: Mechanical venting to prevent molds and odors., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i5 (type: esriFieldTypeString, alias: 5. Hand washing sinks located in or immediately adjacent to the bathrooms., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i6 (type: esriFieldTypeString, alias: 6. No carpeting or absorbent floor coverings., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i7 (type: esriFieldTypeString, alias: 7. Sufficient lighting for cleaning., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_i8 (type: esriFieldTypeString, alias: 8. No storage of toothbrushes or mouthable toys., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_i_observations (type: esriFieldTypeString, alias: gh_section_i_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_i_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_j1 (type: esriFieldTypeString, alias: 1.If food preparation occurs, shall have a sink for food preparation separate from the diapering hand washing sink., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_j2 (type: esriFieldTypeString, alias: 2. Utensils used in the I/T Unit washed, rinsed and sanitized after each use with proper methods and equipment., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_j_observations (type: esriFieldTypeString, alias: gh_section_j_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_j_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_k1 (type: esriFieldTypeString, alias: 1. No utensils or toys washed, rinsed or stored in the diaper changing area, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_k2 (type: esriFieldTypeString, alias: 2. Hand sink with warm running water located in the diapering area immediately accessible to the diapering surface., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_k3 (type: esriFieldTypeString, alias: 3.Diapering surface smooth, easily cleanable, nonabsorbent, and in good repair, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_k4 (type: esriFieldTypeString, alias: 4. Soiled diapers stored in a solid, nonabsorbent container with tight fitting lid located in diapering area., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_k5 (type: esriFieldTypeString, alias: 5. Soiled diaper container emptied, washed, rinsed, and sanitized daily., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_k_observations (type: esriFieldTypeString, alias: gh_section_k_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_k_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_l1 (type: esriFieldTypeString, alias: 1. Adequate number of containers., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_l2 (type: esriFieldTypeString, alias: 2. Clean, nonabsorbent, in sound condition., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_l3 (type: esriFieldTypeString, alias: 3.Outside refuse area clean; containers covered at all times., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_l4 (type: esriFieldTypeString, alias: 4. Inside food refuse containers covered as required., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_l5 (type: esriFieldTypeString, alias: 5. Restrooms used by staff have covered refuse containers., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• gh_section_l_observations (type: esriFieldTypeString, alias: gh_section_l_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_section_l_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_reinspection_date (type: esriFieldTypeDate, alias: Reinspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• gh_inspection_approved_date (type: esriFieldTypeDate, alias: Approved Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• gh_inspector_followup (type: esriFieldTypeString, alias: The inspector has discussed the issues marked by an askerisk (*) and/or marked by an (X) on this form., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• gh_fac_signature_2 (type: esriFieldTypeString, alias: Child Care Provider Typed Signature:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gh_time_out (type: esriFieldTypeDate, alias: Departure Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• time_in (type: esriFieldTypeDate, alias: Arrival Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspection_date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• a1 (type: esriFieldTypeString, alias: 1. Clean and free of unsanitary conditions., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a2 (type: esriFieldTypeString, alias: 2. No environmental hazards observed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a3 (type: esriFieldTypeString, alias: 3. No evidence of insects, spiders, rodents or pest harborage., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a4 (type: esriFieldTypeString, alias: 4. Well ventilated, no evidence of mold, noxious or harmful odors., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a5 (type: esriFieldTypeString, alias: 5. Screens on windows and doors used for ventilation in good repair., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a6 (type: esriFieldTypeString, alias: 6. No indications of lead hazards., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a7 (type: esriFieldTypeString, alias: 7. No toxic or dangerous plants accessible to children., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a8 (type: esriFieldTypeString, alias: 8. Medicines and other toxic agents not accessible to children and stored to prevent contamination of child contact items., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a9 (type: esriFieldTypeString, alias: 9. All sinks equipped and mixing faucets or combination faucets with hot and cold running water under pressure., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a10 (type: esriFieldTypeString, alias: 10. Hot water temperature at sinks accessible to children: 100 degrees - 120 degrees F., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a10_temp (type: esriFieldTypeString, alias: Temp(s) at time of inspection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• a11 (type: esriFieldTypeString, alias: 11. Pets free of diseases communicable to man., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a12 (type: esriFieldTypeString, alias: 12. Pets living quarters clean and well maintained., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a13 (type: esriFieldTypeString, alias: 13. Reptiles prohibited on the premises. Birds of the Parrot Family tested for Psittacosis., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• a14 (type: esriFieldTypeString, alias: 14. Swimming/wading pools filtered, treated, tested and water quality records maintained. Meets local codes., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_a_observations (type: esriFieldTypeString, alias: section_a_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_a_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• b1 (type: esriFieldTypeString, alias: 1. Select Water Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Community: Community], [Non-Community: Non-Community], [Private: Private])
• b2 (type: esriFieldTypeString, alias: 2. No high hazard cross connections., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• b3_private (type: esriFieldTypeString, alias: 3. Constructed to prevent contamination., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• b4_private (type: esriFieldTypeString, alias: 4. Meets DHSS water quality requirements., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• b5 (type: esriFieldTypeString, alias: A. Bacteriological sample results:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• b6 (type: esriFieldTypeString, alias: B. Chemical sample results:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_b_observations (type: esriFieldTypeString, alias: section_b_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_b_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c1 (type: esriFieldTypeString, alias: Select Sewer Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Community: Community], [On-Site: On-Site])
• c2 (type: esriFieldTypeString, alias: DNR Regulated System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c4 (type: esriFieldTypeString, alias: DHSS Regulated System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c6 (type: esriFieldTypeString, alias: 1. Functioning properly at time of inspection., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• c7 (type: esriFieldTypeString, alias: 2. Single-Family residence lot consisting of three or more acres., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• c8 (type: esriFieldTypeString, alias: 3. Health Hazard to children., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• c9 (type: esriFieldTypeString, alias: Meets DHSS and/or local requirements., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_c_observations (type: esriFieldTypeString, alias: section_c_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_c_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• d1 (type: esriFieldTypeString, alias: 1. Caregivers and children wash hands using soap, warm running water and sanitary hand drying methods., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• d2 (type: esriFieldTypeString, alias: 2. Caregivers and children wash hands after toileting, diapering, assisting with toileting and nose blowing; before preparing food; after handling raw food, cleaning and sanitizing, outdoor play, handling animals, smoking and as necessary., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• d3 (type: esriFieldTypeString, alias: 3. An empty sink available in the kitchen to wash hands during food preparation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• d4 (type: esriFieldTypeString, alias: 4. Hand sink with warm running water accessible at all times to wash hand after using bathroom and diapering., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• d5 (type: esriFieldTypeString, alias: 5. Personnel preparing food free of infection or illness., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_d_observations (type: esriFieldTypeString, alias: section_d_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_d_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• e1 (type: esriFieldTypeString, alias: 1. Food from an approved source and in sound condition; no excessively dented cans., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e2 (type: esriFieldTypeString, alias: 2. No use of home-canned food. No unpasteurized milk., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e3 (type: esriFieldTypeString, alias: 3. If meals are served, kitchens shall have adequate equipment to store and prepare food safely with a minimum of a stove or other cooking equipment sized to meet the needs of the facility; a two compartment sink with hot and cold running water; and a refrigerator., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e4 (type: esriFieldTypeString, alias: 4. Ground beef cooked to 155° F; poultry and pooled eggs to 165° F; pork to 145°F; and all other foods cooked to at least 135° F; all hot food kept at 135° F or above., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e5 (type: esriFieldTypeString, alias: 5. Precooked food reheated to 165° F., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e6 (type: esriFieldTypeString, alias: 6. Food requiring refrigeration stored at 41° F or below., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e7_a (type: esriFieldTypeString, alias: 7a. Refrigerator 41° F or below, accessible readable thermometer required. Foods in freezer frozen solid., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e7_b (type: esriFieldTypeString, alias: 7 b.Temp(s) at time of inspection:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• e8 (type: esriFieldTypeString, alias: 8. Metal stemmed thermometer reading 0 - 220° F in 2° increments for checking food temperatures., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e9 (type: esriFieldTypeString, alias: 9. Food, food related items and utensils covered and stored to prevent contamination by pests, toxic agents, cleaning agents, water drain lines, medicines, dust, splash and other foods., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e10 (type: esriFieldTypeString, alias: 10. Food, toxic agents, cleaning agents not in their original containers shall be properly labeled., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e11 (type: esriFieldTypeString, alias: 11. No food stored or prepared in diapering areas or bathrooms., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e12 (type: esriFieldTypeString, alias: 12. Food stored in food grade containers only., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e13 (type: esriFieldTypeString, alias: 13. Food thawed under refrigeration, 70° F running water, or microwave if part of the cooking process., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e14 (type: esriFieldTypeString, alias: 14. No animals in food preparation or food storage areas., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e15 (type: esriFieldTypeString, alias: 15. No eating, smoking, drinking during food preparation., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• e16 (type: esriFieldTypeString, alias: 16. Food served and not eaten shall not be re-served to children in care., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_e_observations (type: esriFieldTypeString, alias: section_e_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_e_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• f1 (type: esriFieldTypeString, alias: 1. Food utensils washed rinsed and air-dried., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f2 (type: esriFieldTypeString, alias: 2. Single-service items used only once., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f3 (type: esriFieldTypeString, alias: 3. Food contact surfaces cleaned-in-place are washed, rinsed, and sanitized after each use with approved agents., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f4 (type: esriFieldTypeString, alias: 4. Infant/toddler toys washed, rinsed and air dried after contact with body fluids, when soiled or at least daily., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f5 (type: esriFieldTypeString, alias: 5. Diapering surface and potty chairs washed, rinsed and sanitized after each use with approved agents., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f6 (type: esriFieldTypeString, alias: 6. Test kits available to check proper concentration of sanitizing agents., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• f7 (type: esriFieldTypeString, alias: 7. Soiled laundry stored and handled in a manner which does not contaminate food and food related items and child contact items., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_f_observations (type: esriFieldTypeString, alias: section_f_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_f_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• g1 (type: esriFieldTypeString, alias: 1. Adequate number of containers., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• g2 (type: esriFieldTypeString, alias: 2. Clean, nonabsorbent, insect and rodent proof., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• g3 (type: esriFieldTypeString, alias: 3. Outside refuse containers covered at all times., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• g4 (type: esriFieldTypeString, alias: 4. Inside containers covered when full or accessible to children., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• g5 (type: esriFieldTypeString, alias: 5. Soiled diapers stored in solid, non-absorbent container with tight-fitting lid located within the diapering area., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Defects Noted: X], [Not Observed: N.O.], [Not Applicable: N.A], ... 2 more ...)
• section_g_observations (type: esriFieldTypeString, alias: section_g_observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• section_g_x (type: esriFieldTypeString, alias: Issues Noted:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reinspection_date (type: esriFieldTypeDate, alias: Reinspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspection_approved_date (type: esriFieldTypeDate, alias: Approved Date:, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspector_followup (type: esriFieldTypeString, alias: The inspector has discussed the issues marked by an askerisk (*) and/or marked by an (X) on this form., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• fac_signature_2 (type: esriFieldTypeString, alias: Child Care Provider Typed Signature:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• time_out (type: esriFieldTypeDate, alias: Departure Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• a1_x_1 (type: esriFieldTypeString, alias: A1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a2_x_1 (type: esriFieldTypeString, alias: A2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a3_x_1 (type: esriFieldTypeString, alias: A3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a4_x_1 (type: esriFieldTypeString, alias: A4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a5_x_1 (type: esriFieldTypeString, alias: A5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a6_x_1 (type: esriFieldTypeString, alias: A6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a7_x_1 (type: esriFieldTypeString, alias: A7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a8_x_1 (type: esriFieldTypeString, alias: A8. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a9_x_1 (type: esriFieldTypeString, alias: A9. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a10_x_1 (type: esriFieldTypeString, alias: A10. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a11_x_1 (type: esriFieldTypeString, alias: A11. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a12_x_1 (type: esriFieldTypeString, alias: A12. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a13_x_1 (type: esriFieldTypeString, alias: A13. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• a14_x_1 (type: esriFieldTypeString, alias: A14. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• b2_x_1 (type: esriFieldTypeString, alias: B2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• b3_private_x_1 (type: esriFieldTypeString, alias: B3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• b4_private_x_1 (type: esriFieldTypeString, alias: B4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• c9_x_1 (type: esriFieldTypeString, alias: Meets DHSS and/or local requirements, observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• d1_x_1 (type: esriFieldTypeString, alias: D1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• d2_x_1 (type: esriFieldTypeString, alias: D2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• d3_x_1 (type: esriFieldTypeString, alias: D3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• d4_x_1 (type: esriFieldTypeString, alias: D4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• d5_x_1 (type: esriFieldTypeString, alias: D5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e1_x_1 (type: esriFieldTypeString, alias: E1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e2_x_1 (type: esriFieldTypeString, alias: E2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e3_x_1 (type: esriFieldTypeString, alias: E3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e4_x_1 (type: esriFieldTypeString, alias: E4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e5_x_1 (type: esriFieldTypeString, alias: E5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e6_x_1 (type: esriFieldTypeString, alias: E6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e7_a_x_1 (type: esriFieldTypeString, alias: E7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e8_x_1 (type: esriFieldTypeString, alias: E8. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e9_x_1 (type: esriFieldTypeString, alias: E9. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e10_x_1 (type: esriFieldTypeString, alias: E10. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e11_x_1 (type: esriFieldTypeString, alias: E11. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e12_x_1 (type: esriFieldTypeString, alias: E12. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e13_x_1 (type: esriFieldTypeString, alias: E13. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e14_x_1 (type: esriFieldTypeString, alias: E14. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e15_x_1 (type: esriFieldTypeString, alias: E15. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• e16_x_1 (type: esriFieldTypeString, alias: E16. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f1_x_1 (type: esriFieldTypeString, alias: F1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f2_x_1 (type: esriFieldTypeString, alias: F2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f3_x_1 (type: esriFieldTypeString, alias: F3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f4_x_1 (type: esriFieldTypeString, alias: F4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f5_x_1 (type: esriFieldTypeString, alias: F5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f6_x_1 (type: esriFieldTypeString, alias: F6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• f7_x_1 (type: esriFieldTypeString, alias: F7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• g1_x_1 (type: esriFieldTypeString, alias: G1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• g2_x_1 (type: esriFieldTypeString, alias: G2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• g3_x_1 (type: esriFieldTypeString, alias: G3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• g4_x_1 (type: esriFieldTypeString, alias: G4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• g5_x_1 (type: esriFieldTypeString, alias: G5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• general_comments_1 (type: esriFieldTypeString, alias: Use this section to provide any additional comments, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a1_x_1 (type: esriFieldTypeString, alias: A1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a2_x_1 (type: esriFieldTypeString, alias: A2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a3_x_1 (type: esriFieldTypeString, alias: A3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a4_x_1 (type: esriFieldTypeString, alias: A4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a5_x_1 (type: esriFieldTypeString, alias: A5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a6_x_1 (type: esriFieldTypeString, alias: A6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a7_x_1 (type: esriFieldTypeString, alias: A7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a8_x_1 (type: esriFieldTypeString, alias: A8. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a9_x_1 (type: esriFieldTypeString, alias: A9. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a10_x_1 (type: esriFieldTypeString, alias: A10. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a11_x_1 (type: esriFieldTypeString, alias: A11. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a12_x_1 (type: esriFieldTypeString, alias: A12. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a13_x_1 (type: esriFieldTypeString, alias: A13. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a14_x_1 (type: esriFieldTypeString, alias: A14. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a15_x_1 (type: esriFieldTypeString, alias: A15. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_a16_x_1 (type: esriFieldTypeString, alias: A16. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_b3_private_x_1 (type: esriFieldTypeString, alias: B1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_b4_private_x_1 (type: esriFieldTypeString, alias: B2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_c9_x_1 (type: esriFieldTypeString, alias: Meets DHSS requirements, observations., SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_c10_x_1 (type: esriFieldTypeString, alias: Meets Local requirements, observations., SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_d1_x_1 (type: esriFieldTypeString, alias: D1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_d2_x_1 (type: esriFieldTypeString, alias: D2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_d3_x_1 (type: esriFieldTypeString, alias: D3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e1_x_1 (type: esriFieldTypeString, alias: E1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e2_x_1 (type: esriFieldTypeString, alias: E2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e3_x_1 (type: esriFieldTypeString, alias: E3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e4_x_1 (type: esriFieldTypeString, alias: E4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e5_x_1 (type: esriFieldTypeString, alias: E5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e6_a_x_1 (type: esriFieldTypeString, alias: E6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e7_x_1 (type: esriFieldTypeString, alias: E7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e8_x_1 (type: esriFieldTypeString, alias: E8. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e9_x_1 (type: esriFieldTypeString, alias: E9. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e10_x_1 (type: esriFieldTypeString, alias: E10. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e11_x_1 (type: esriFieldTypeString, alias: E11. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e12_x_1 (type: esriFieldTypeString, alias: E12. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e13_x_1 (type: esriFieldTypeString, alias: E13. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e14_x_1 (type: esriFieldTypeString, alias: E14. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e16_x_1 (type: esriFieldTypeString, alias: E15. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_e17_x_1 (type: esriFieldTypeString, alias: E16. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f1_x_1 (type: esriFieldTypeString, alias: F1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f2_x_1 (type: esriFieldTypeString, alias: F2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_x_1 (type: esriFieldTypeString, alias: F3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_a_x_1 (type: esriFieldTypeString, alias: F3A. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_b_x_1 (type: esriFieldTypeString, alias: F3B. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_c_x_1 (type: esriFieldTypeString, alias: F3C. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_d_x_1 (type: esriFieldTypeString, alias: F3D. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f3_e_x_1 (type: esriFieldTypeString, alias: F3E. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f4_x_1 (type: esriFieldTypeString, alias: F4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f4_a_x_1 (type: esriFieldTypeString, alias: F4A. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f4_b_x_1 (type: esriFieldTypeString, alias: F4B. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f4_c_x_1 (type: esriFieldTypeString, alias: F4C. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f5_x_1 (type: esriFieldTypeString, alias: F5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f6_x_1 (type: esriFieldTypeString, alias: F6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_f7_x_1 (type: esriFieldTypeString, alias: F7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g1_x_1 (type: esriFieldTypeString, alias: G1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g2_x_1 (type: esriFieldTypeString, alias: G2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g3_x_1 (type: esriFieldTypeString, alias: G3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g4_x_1 (type: esriFieldTypeString, alias: G4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g5x_1 (type: esriFieldTypeString, alias: G5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g6_x_1 (type: esriFieldTypeString, alias: G6. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g7_x_1 (type: esriFieldTypeString, alias: G7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g8a_observation_1 (type: esriFieldTypeString, alias: G8A Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g8b_observation_1 (type: esriFieldTypeString, alias: G8B Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g9a_observation_1 (type: esriFieldTypeString, alias: G9A Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g9b_observation_1 (type: esriFieldTypeString, alias: G9B Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g10a_observation_1 (type: esriFieldTypeString, alias: G10A Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g10b_observation_1 (type: esriFieldTypeString, alias: G10B Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_g10c_observation_1 (type: esriFieldTypeString, alias: G10C Observation:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_h1_x_1 (type: esriFieldTypeString, alias: H1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_h2_x_1 (type: esriFieldTypeString, alias: H2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_h3_x_1 (type: esriFieldTypeString, alias: H3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_h4_x_1 (type: esriFieldTypeString, alias: H4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_h5_x_1 (type: esriFieldTypeString, alias: H5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i1_x_1 (type: esriFieldTypeString, alias: I1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i2_x_1 (type: esriFieldTypeString, alias: I2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i3_x_1 (type: esriFieldTypeString, alias: I3. Observations, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i4_x_1 (type: esriFieldTypeString, alias: I4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i5_x_1 (type: esriFieldTypeString, alias: I5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i6_x_1 (type: esriFieldTypeString, alias: I5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i7_x_1 (type: esriFieldTypeString, alias: I7. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_i8_x_1 (type: esriFieldTypeString, alias: I8. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_j1_x_1 (type: esriFieldTypeString, alias: J1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_j2_x_1 (type: esriFieldTypeString, alias: J2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_k1_x_1 (type: esriFieldTypeString, alias: k1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_k2_x_1 (type: esriFieldTypeString, alias: K2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_k3_x_1 (type: esriFieldTypeString, alias: K3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_k4_x_1 (type: esriFieldTypeString, alias: K4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_k5_x_1 (type: esriFieldTypeString, alias: K5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_l1_x_1 (type: esriFieldTypeString, alias: L1. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_l2_x_1 (type: esriFieldTypeString, alias: L2. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_l3_x_1 (type: esriFieldTypeString, alias: L3. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_l4_x_1 (type: esriFieldTypeString, alias: L4. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_l5_x_1 (type: esriFieldTypeString, alias: L5. Observations:, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• gh_general_comments_1 (type: esriFieldTypeString, alias: Use this section to provide any additional comments, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• time_out_capture (type: esriFieldTypeString, alias: Departure Time (CST):, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• time_in_capture (type: esriFieldTypeString, alias: Arrival Time (CST), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• gh_time_out_capture (type: esriFieldTypeString, alias: Departure Time (CST):, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• gh_time_in_capture (type: esriFieldTypeString, alias: Arrival Time (CST):, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• esri_user (type: esriFieldTypeString, alias: Username (System), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• username (type: esriFieldTypeString, alias: Username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sys_mode (type: esriFieldTypeString, alias: Mode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sys_status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• operating_system (type: esriFieldTypeString, alias: Operating System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• app_version (type: esriFieldTypeString, alias: App Version, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• device_model (type: esriFieldTypeString, alias: Device Model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• on_line (type: esriFieldTypeString, alias: Online, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• summarize_all_violations (type: esriFieldTypeString, alias: Violations noted in any part of the inspection?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• gh_summarize_all_violations (type: esriFieldTypeString, alias: Violations noted in any part of the inspection? (GH), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• summary_violation (type: esriFieldTypeString, alias: Summary Violation (use for FH report), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• gh_summary_violation (type: esriFieldTypeString, alias: Summary Violation (use for GH Report), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• contactemail1 (type: esriFieldTypeString, alias: LPHA Email 1, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• contactemail2 (type: esriFieldTypeString, alias: LPHA Email 2, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• close_request_date (type: esriFieldTypeDate, alias: Close Request Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• other_reason (type: esriFieldTypeString, alias: Describe Other Reason, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• closing_detail (type: esriFieldTypeString, alias: Closing Explanation, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• verify_billing (type: esriFieldTypeString, alias: Verify Billing, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Presystem Billing: Presystem Billing])
• verify_billing_date (type: esriFieldTypeDate, alias: Verify Billing Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• billed (type: esriFieldTypeString, alias: Submitting for Billing, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• verify_no (type: esriFieldTypeString, alias: Reason for not verifying for payment, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• sc_hours (type: esriFieldTypeInteger, alias: Enter the number of hours approved for Special Circumstance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• invoice_number (type: esriFieldTypeString, alias: Invoice Number (calculate), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• invoice_display (type: esriFieldTypeString, alias: Invoice Display (DH38), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• date_text (type: esriFieldTypeString, alias: Stores text for invoice number (DH38), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: Inspection_Development
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/23/2024 2:50:26 PM

Schema Last Edit Date: 5/23/2024 2:50:26 PM

Data Last Edit Date: 5/23/2024 2:50:26 PM

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