| notes |
<p style='margin-bottom:0in; margin-bottom:.0001pt;'><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>Attributes of Public Health related complaints reported by
the public and investigated by Louisville Metro Department of Public Health and
Wellness. Personal/identifying data has been removed. EstID column can be
joined to the EstablishmentID column in the Establishments table to show
attributes of the establishment when a regulated establishment is involved.</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
<b><span style='background:white;'><br /></span></b></span></p><p style='margin-bottom:0in; margin-bottom:.0001pt;'><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><b><span style='background:white;'>Data Dictionary:</span></b><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>RequestComplaintID-System ID</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>Rcode-Code for Type of Complaint or Request</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>RCodeDescription-Text of type of complaint or request</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>EHS-the license number of the technician investigating</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>section-complaint section</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>TakenBy-who took the complaint or service request</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>Method-how the complaint or service request was taken in</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>Duplicate-is this a duplicate request? System notation</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>EstID-Associated permitted facility if applicable</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>oss_id-associated onsite sewage file if applicable</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>RequestDate-date of request or complaint</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>ResolvedDate-date request or complaint was resolved</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>NextInspDate-scheduled next inspection date</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>IsCityorCounty-is this a city or county request?</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>Status-is the request open or resolved?</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>RequestType-request type</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>IsFollowUp-is this a folowo up entry to an already open
request</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>OwnerType- Owner or agent? If applicable</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>PersonOrPremiseZip-zip code of subject person</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>ComplaintantZip-zip code of person making the complaint</span><span style='font-size:12.0pt; font-family:"Arial",sans-serif; color:#4C4C4C;'><br />
</span><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4D4D4D; background:white;'>OwnerZip-zip code of the owner of the premises if applicable</span></p>
<p style='margin-bottom:0in; margin-bottom:.0001pt; background:white;'>Health and Wellness Protects and promotes the health, environment and well being of the people of Louisville, providing health-related programs and health office locations community wide.<br /></p>
<p style='margin-bottom:15.0pt; background:white;'><span style='font-size:12.0pt; font-family:"inherit",serif; color:navy;'>Contact:</span></p>
<p style='margin-bottom:15.0pt; background:white;'><span style='font-size:12.0pt; font-family:"inherit",serif; color:navy;'>Gerald Kaforski</span></p>
<p style='margin-bottom:15.0pt; background:white;'><span style='font-size:12.0pt; font-family:"Lato",serif; color:#4C4C4C;'><a href='mailto:gerald.kaforski@louisvilleky.gov' rel='nofollow ugc'><span style='font-family:"inherit",serif; color:navy;'>gerald.kaforski@louisvilleky.gov</span></a></span></p>
|