HomeMy WebLinkAbout21 Industrial Inspections Data EntryIndustria
ata
1 Inspections
anagement
---------------------------------------------------------------------------------------------------------------
O
OR, HOW I LEARNED TO STOP WORRYING
AND LOVE THE DATABASE
In the Field: Inspection Form
Designed to walk you through
i Page is general conditions for all
i operations
i Page 2: stuff for NPDES or SPPP
� facilities
Room for lots of additional
comments
Checkboxes for compliance status
i Inspector signature block
Last page for helpful references
In the Office: Industrial Database
Use for keeping track of inspections and facilities
Use for pre- and post -investigation research
Main Swrlshhoald
Search for Fxisti ng Faeil it+y
Add New Facility
Go to Inspections Due Reports
Go to Monthiy Reports Menu
Go to Report Menu
Go to Letters Menu
Database Change Lag
Print 91-P n k N1* Wa nk Fvl lvw-
Inspection Farm I Iup Inspection Foam
Go to Queries Menu
Major differences b/w Inspections &
Investigations Databases
----------------------------------------------- r"�%
1111�1_j -----------------------------------------------
Investigations are stored on
a per -incident basis.
• Results in the same location
being listed multiple times for
separate investigations
Can be a more time-
consuming to search
18 Millennium Automotive Group
19 rkirlharn`;; Autn Mart
I Inspection Num - Inspection DE - Inspection Result -
0 09-18WI-124 12/9 f 2008 IN COMPLIANCE
0 11-18WI-060 5 f 25f 2011 VIOLATION
0 11-18WI-105 9 f 12f 2011 IN COMPLIANCE
0 14-18WI-096 6 J16f 2014 Violation
0 14-18WI-123 8 f 12/2014 Progressing
0 14-18WI-125 8/21/2014 Progressing
0 14-18WI-161 10/17/2014 In compliance
0
Inspections are stored on a
per -facility basis.
• Locations all listed once
• Location has its inspections
linked to it
tblFaciIityGenera lInfo rmation
IngFacilityID
strFacilityName
strFa ci I ityStreetAd d res s
strFacilityCity
strFacilityState
strFacilityZip
strFa ci I ityM a i I in gAd d res s
strFa ci I ityM a i I in g City
4511 Chapel Hill Boulevard
3601 Hillsborough Road
tbl Fa ci I ityIn spedi on Records
1 strInspectionNumber
I� CIDIngFacilityI6 =_
dtmInspectionDate
strResult
memComments
strComplianceIssuel
strCo rre ctiveActi o nl
Compliance Issue ] -
4511 Chapel Hi
3601 Hillsboro
Operating under Morgan Jeep. Very clean fora mechai
The three drums currently stored behind the facility ne Automotive: Fluids st Discontinue storage c
By no later than July 18, 2014, correct the fallow Automotive: Fluids st Please see additional
On 8f12f 14, CT conducted a follow up inspection at Dur
On 9/21/14 CT returned to Durham's Auto Mart to mak
After revieingthe revised SPPP for Durham's Auto M Automotive: Fluids st
Major differences b/w Inspections &
Investigations Databases
----------------------------------------------- r"�%
1111�1j -----------------------------------------------
Searching the Industrial Database
M Main Search Farm
0
Find a facility record
Fa-cilky Fame
4
Street Address
[Ge, General Facility Info
F7 Database Change Lag
Enter any combination of any part of the facility name or address.