{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Monthly Report Totals","Malfunctioning Systems","Large-IPWW Systems"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":7,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Monthly Report Totals","index":0,"n_rows":420,"n_cols":27,"rows_kept":420,"cut":false,"hidden":false,"merged":[[34,2,34,8],[35,2,35,8],[71,1,71,3],[71,4,71,5],[71,8,71,9],[72,1,72,3],[73,1,73,3],[73,4,73,5],[73,6,73,7],[73,8,73,9],[68,1,68,3],[68,4,68,5],[68,6,68,7],[69,1,69,3],[69,4,69,5],[70,1,70,3],[70,4,70,5],[62,1,62,3],[62,4,62,5],[62,6,62,7],[62,8,62,9],[63,1,63,3],[63,4,63,5],[63,6,63,7],[65,4,65,5],[72,4,72,5],[75,4,75,5],[74,1,74,3],[74,4,74,5],[74,6,74,7],[74,8,74,9],[103,1,103,7],[89,1,89,10],[85,1,85,3],[85,4,85,5],[85,6,85,7],[85,8,85,9],[71,6,71,7],[68,8,68,9],[69,6,69,7],[69,8,69,9],[75,6,75,7],[94,6,94,7],[95,6,95,7],[95,4,95,5],[94,4,94,5],[86,4,86,5],[86,6,86,7],[108,2,108,3],[109,2,109,3],[110,2,110,3],[111,2,111,3],[96,1,96,3],[96,4,96,5],[96,6,96,7],[96,8,96,9],[104,2,104,3],[106,2,106,3],[107,2,107,3],[105,2,105,3],[155,1,155,9],[152,2,152,8],[148,2,148,8],[143,2,143,8],[145,2,145,8],[146,2,146,8],[144,2,144,8],[147,2,147,8],[149,2,149,8],[150,2,150,8],[151,2,151,8],[154,2,154,8],[153,2,153,8],[142,2,142,8],[112,2,112,3],[127,1,127,9],[128,2,128,8],[113,2,113,3],[118,2,118,3],[120,2,120,3],[114,2,114,3],[115,2,115,3],[122,2,122,3],[123,2,123,3],[121,2,121,3],[129,2,129,8],[130,2,130,8],[131,2,131,8],[117,2,117,3],[132,2,132,8],[133,2,133,8],[134,2,134,8],[136,2,136,8],[138,2,138,8],[139,2,139,8],[140,2,140,8],[141,2,141,8],[18,2,18,8],[7,2,7,8],[17,2,17,8],[22,2,22,8],[21,2,21,8],[20,2,20,8],[27,2,27,8],[31,2,31,8],[52,1,52,2],[48,1,48,2],[46,1,46,8],[47,1,47,8],[30,2,30,8],[29,2,29,8],[28,2,28,8],[51,1,51,2],[49,1,49,2],[50,1,50,2],[32,1,32,9],[33,2,33,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[42,1,42,9],[19,2,19,8],[116,2,116,3],[1,0,1,9],[2,0,2,9],[4,0,4,1],[4,2,4,3],[11,2,11,8],[26,2,26,8],[25,2,25,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[15,2,15,8],[14,2,14,8],[24,2,24,8],[23,2,23,8],[12,2,12,8],[13,2,13,8],[16,2,16,8],[94,1,94,3],[95,1,95,3],[81,4,81,5],[81,6,81,7],[81,8,81,9],[58,1,58,10],[60,1,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[61,1,61,3],[61,4,61,5],[92,1,92,3],[92,4,92,5],[92,6,92,7],[92,8,92,9],[91,4,91,5],[91,6,91,7],[91,8,91,9],[59,0,59,10],[72,6,72,7],[79,8,79,9],[81,1,81,3],[75,8,75,9],[72,8,72,9],[65,8,65,9],[64,8,64,9],[65,6,65,7],[70,6,70,7],[78,8,78,9],[86,1,86,3],[86,8,86,9],[87,1,87,3],[97,12,97,14],[97,15,97,16],[97,17,97,18],[97,19,97,20],[91,1,91,3],[93,1,93,3],[94,8,94,9],[95,8,95,9],[93,4,93,5],[93,6,93,7],[93,8,93,9],[88,1,88,3],[88,4,88,5],[88,6,88,7],[88,8,88,9],[90,1,90,3],[90,4,90,5],[90,6,90,7],[90,8,90,9],[61,8,61,9],[57,1,57,3],[57,4,57,5],[57,6,57,7],[57,8,57,9],[87,4,87,5],[87,6,87,7],[87,8,87,9],[82,1,82,3],[82,4,82,5],[82,6,82,7],[82,8,82,9],[84,1,84,3],[84,4,84,5],[84,6,84,7],[84,8,84,9],[83,1,83,10],[63,8,63,9],[64,1,64,3],[64,4,64,5],[64,6,64,7],[78,1,78,3],[78,4,78,5],[78,6,78,7],[135,2,135,8],[137,2,137,8],[55,0,56,10],[76,0,76,10],[80,0,80,10],[70,8,70,9],[65,1,65,3],[66,1,66,3],[66,4,66,5],[66,6,66,7],[66,8,66,9],[67,1,67,3],[67,4,67,5],[67,6,67,7],[67,8,67,9],[75,1,75,3],[77,1,77,3],[77,4,77,5],[77,6,77,7],[77,8,77,9],[79,1,79,3],[79,4,79,5],[79,6,79,7],[61,6,61,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"wwp2015(",1,null,{"$f":"YEAR(TODAY())","v":2022}]
["Monthly Report",null,null,null,null,null,null,null,null,null,"v10.43"]
["On-Site Water Protection Program",null,null,null,null,null,null,null,null,null,"2022-09-19"]
[]
["County:",null,"Select Your County",null,null,"Month:",0,"Year:",2021]
[]
[]
[null,"County Use","On-Site Wastewater Activity (Table 1)",null,null,null,null,null,null,"Total"]
[null,"S-1","Site Visits (Includes all OSWW field activities not included below*)"]
[null,"S-1E","Sites Evaluated (includes sites evaluated or re-evaluated for any purpose)*"]
[null,"S-3","Improvement Permits Issued - New or Revision w/ PLAT (Non-expiring)"]
[null,"S-4","Improvement Permits Issued - New or Revision w/ Site Plan (Valid 60 mos)"]
[null,"S-4A","Improvement Permits Issued - Relocation w/ Site Plan (Valid 60 mos)"]
[null,"S-5","Improvement Permits Issued - Expansion of Existing System (Valid 60 mos)"]
[null,"S-7","Improvement Permits Denied (Documented)"]
[null,"S-8","Construction Authorizations - New, Revision, or Relocation"]
[null,"S-9","Construction Authorizations - Expansion"]
[null,"S-10","Construction Authorizations - Repair/Replacement of Malfunctioning System"]
[null,"S-11","Construction Authorizations Denied (Documented)"]
[null,"S-12","Authorizations - Mobile Home Parks*"]
[null,"S-13","Authorizations - Existing System Reuse other than in MHP*"]
[null,"S-13D","Authorizations for System Reuse - Denied*"]
[null,"S-14A","Table V Inspections w/Reports prepared*"]
[null,"S-14B","Migrant Housing Inspections w/Reports prepared*"]
[null,"S-15","Notices of Violation Issued"]
[null,"S-16","Legal Remedies - Injunctions, criminal misdemeanor, administrative penalties"]
[null,"S-17","Permits Revoked (Notice)"]
[null,"S-18","Permits Suspended (Notice)"]
[null,"S-25","Sewage Complaints Investigated*"]
[null,"S-26","Tank Yard Inspections Performed*"]
[null,"S-27","On-Site Consultative Contacts"]
[null,"S-19","Operation Permits Issued*"]
[null,"LHD Activities Associated With Private Permitting Options"]
[null,"S-30A","Engineered Option Permit (EOP) Notice of Intent (NOI) Complete"]
[null,"S-30B","EOP NOI Deemed Incomplete (Owner or Engineer Notified)"]
[null,"S-31","EOP Authorization to Operate (ATO) Issued"]
[null,"S-35A","Authorized On-Site Wastewater Evaluator (AOWE) Notice of Intent (NOI) Complete"]
[null,"S-35B","AOWE NOI Deemed Incomplete (Owner or AOWE Notified)"]
[null,"S-36","AOWE Authorization to Operate (ATO) Issued"]
[null,"S-40","Improvement Permit (ALL) per (a2) (LHD PERMIT PER LSS/AOWE SUBMISSION)"]
[null,"S-41","Construction Authorization (ALL) per (a2) (DESIGN BY AOWE/PE)"]
[null,"S-42","Operation Permit Issued, per (a2)"]
[null,"*     A site visit is assumed to have happened when this activity is reported so there is no need to count an S-1 Site Visit when coding this activity."]
[]
[]
[]
[null,"Number of Operation Permits Issued, Complete Systems (Table 2)"]
[null,"Based on Management System Types from Rule .1961 Table V(a)"]
[null,null,null,"Type I","Type II","Type III","Type IV","Type V","Type VI"]
[null,"Initial / New"]
[null,"Expansion"]
[null,"Repair"]
[null,"Re-permitted"]
[]
[]
["                                                         Operation Permits Issued (Table 3)"]
[]
["System Code","System Description",null,null,"New",null,"Expansion",null,"Repair",null,"Total"]
[null,"Ground Absorption System Types"]
["                             Trench System"]
["GTR","Gravel Trench",null,null,null,null,null,null,null,null,{"$f":"SUM(E61:J61)","v":0}]
["CHM 36","Chamber (3-ft Wide, 11-13\" High)",null,null,null,null,null,null,null,null,0]
["POLY","Polystyrene (EZFlow, Flowtech)",null,null,null,null,null,null,null,null,0]
["CHM LP","Chamber Low Profile",null,null,null,null,null,null,null,null,0]
["LDP ","Large Diameter Pipe (8\" and 10\")",null,null,null,null,null,null,null,null,0]
["CHM 22","Chamber 22\" Wide",null,null,null,null,null,null,null,null,0]
["PPBPS V","PPBPS Vertical",null,null,null,null,null,null,null,null,0]
["PPBPS H","PPBPS Horizontal",null,null,null,null,null,null,null,null,0]
["TCHP","Tire Chips ",null,null,null,null,null,null,null,null,0]
["LPP","Low-Pressure Pipe ",null,null,null,null,null,null,null,null,0]
["DPRAN","Drip Dispersal Anaerobic (Perc Rite)",null,null,null,null,null,null,null,null,0]
["DRIPAE","Drip Dispersal Aerobic",null,null,null,null,null,null,null,null,0]
["CHM HC","Chamber High Capacity",null,null,null,null,null,null,null,null,0]
["SLT","Sand-Lined Trench",null,null,null,null,null,null,null,null,0]
["MLTP","Multi-Pipe (\"Septic Stack\")",null,null,null,null,null,null,null,null,0]
["CHM L20","Chamber ≤ 20\" Wide",null,null,null,null,null,null,null,null,0]
["                           Bed System"]
["GBD","Gravel Bed (Not in Fill)",null,null,null,null,null,null,null,null,{"$f":"SUM(E78:J78)","v":0}]
["OBED","Other Beds (Accepted/Innovative, Not in Fill)",null,null,null,null,null,null,null,null,{"$f":"SUM(E79:J79)","v":0}]
["BIF","Bed in Fill (Innovative)",null,null,null,null,null,null,null,null,{"$f":"SUM(E80:J80)","v":0}]
["                        Hybrid System (Treatment and Dispersal)"]
["PRESBY","Presby AES",null,null,null,null,null,null,null,null,{"$f":"SUM(E82:J82)","v":0}]
["ELJEN","Eljen GSF A42",null,null,null,null,null,null,null,null,{"$f":"SUM(E83:J83)","v":0}]
[null,"Non-Ground Absorption System Type or System Component Only"]
["Tank","Tank or Pump Tank only",null,null,null,null,null,null,null,null,{"$f":"SUM(E85:J85)","v":0}]
["PRV","Privy or Vault Privy (Type I)",null,null,null,null,null,null,null,null,{"$f":"SUM(E86:J86)","v":0}]
["OTL","Other Toilet (Chem, Incin., Comp, Type I)",null,null,null,null,null,null,null,null,{"$f":"SUM(E87:J87)","v":0}]
["OTHER","Other Component Only",null,null,null,null,null,null,null,null,{"$f":"SUM(E88:J88)","v":0}]
["PH","Pump & Haul (Type V)",null,null,null,null,null,null,null,null,{"$f":"SUM(E89:J89)","v":0}]
[null,"Additional System Features (in addition to type of system)"]
["F","System in Fill (Not Bed in Fill)",null,null,null,null,null,null,null,null,{"$f":"SUM(E91:J91)","v":0}]
["GLS","Groundwater Lowering System",null,null,null,null,null,null,null,null,0]
["PS","Pump System (not LPP or Drip)",null,null,null,null,null,null,null,null,0]
["OS","Off-Site System (Innovative)",null,null,null,null,null,null,null,null,0]
["DAF","Dual Alternating Fields",null,null,null,null,null,null,null,null,0]
["DEEP","Deep Installation",null,null,null,null,null,null,null,null,0]
["FEQ","Flow Equalization",null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,"FEQ","Flow Equalization Innovative System",null,null,null,null,null,null,null,null,{"$f":"SUM(P98:U98)","v":0}]
[]
[]
[]
[]
[]
[null," Advanced Pre-Treatment (Table 4)"]
[null,"Code ",null,null,"New ","Expansion","Repair","Total"]
[null,"ADV","Advantex",null,null,null,null,{"$f":"SUM(E106:G106)","v":0}]
[null,"EZT","EZTreat",null,null,null,null,0]
[null,"PEAT","Peat (Puraflo, Ecoflo)",null,null,null,null,0]
[null,"SF","Sand Filter",null,null,null,null,0]
[null,"SPT","SeptiTech",null,null,null,null,0]
[null,"AMPH","Amphidrome",null,null,null,null,0]
[null,"AQUA","Aquarobic",null,null,null,null,0]
[null,"BCLE","Bioclere",null,null,null,null,0]
[null,"BIOKB","Biokube",null,null,null,null,0]
[null,"BIOM","Biomicrobics (FAST)",null,null,null,null,0]
[null,"CLST","Clearstream",null,null,null,null,0]
[null,"CONS","Consolidated",null,null,null,null,0]
[null,"DELTA","Delta",null,null,null,null,0]
[null,"FJCL","Fuji Clean",null,null,null,null,0]
[null,"HA","Hydro-Action",null,null,null,null,0]
[null,"HOOT","Hoot ",null,null,null,null,0]
[null,"JET","Jet ",null,null,null,null,0]
[null,"NORW","Norweco (Singulair)",null,null,null,null,0]
[null,"OTHER","Other Advanced Pre-Treatment",null,null,null,null,0]
[]
[null,"Table 5 Removed"]
[]
[null,"Private Water Supply Protection (Table 6)"]
[null,"Code","Well Activities",null,null,null,null,null,null,"Total"]
[null,"W-1","Well Site Evaluated*"]
[null,"W-2","Grouting Inspection*"]
[null,"W-3","Well Site Consultative Visits"]
[null,"W-4","Well Head Inspection*"]
[null,"W-4A","Well Head Approved*"]
[null,"W-4D","Well Head Disapproved*"]
[null,"W-5","Well Abandonment Observed*"]
[null,"W-6","Well Construction Permit Issued - New"]
[null,"W-7","Well Construction Permit Issued - Repair"]
[null,"W-8","Well Abandonment Permit Issued "]
[null,"W-9","Well Permit Denied"]
[null,"W-10","Well Certificate of Completion Issued - New"]
[null,"W-10D","Well Certificate of Completion Denied - New"]
[null,"W-11","Well Certificate of Completion Issued - Repair"]
[null,"W-11D","Well Certificate of Completion Denied - Repair"]
[null,"W-13","New Well Kit*"]
[null,"W-14","Other Sample Collected*"]
[null,"W-15","Well Complaint Investigation*"]
[null,"W-16","Well Consultative Contacts "]
[null,"W-17","Notices of Violation Issued"]
[null,"W-18","Legal Remedies Taken"]
[null,"W-19","Permits Revoked Notice"]
[null,"W-20","Permits Suspended Notice"]
[null,"W-21","Well Camera or Geophysical Inspection Performed*"]
[null,"W-22","Variance Request (documented)"]
[null,"W-23","Health Risk Evaluation"]
[null,"*     A site visit is assumed to have happened when this activity is reported so there is no need to count an S-1 or a W-3 Site Visit when coding this activity."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select Your County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alamance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alexander"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alleghany"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ashe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beaufort"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bertie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bladen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brunswick"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buncombe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Burke"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cabarrus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caldwell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Camden"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carteret"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caswell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catawba"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chatham"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cherokee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chowan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cleveland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Columbus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Craven"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cumberland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Currituck"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Davidson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Davie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Duplin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Durham"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Edgecombe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forsyth"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Franklin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gaston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graham"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Granville"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Greene"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Guilford"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halifax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Harnett"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Haywood"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Henderson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hertford"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hoke"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hyde"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iredell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jackson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Johnston"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jones"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lee"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lenoir"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Madison"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcdowell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mecklenburg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitchell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montgomery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moore"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nash"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"New Hanover"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Northampton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onslow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orange"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pamlico"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasquotank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pender"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Perquimans"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Person"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pitt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Randolph"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Richmond"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Robeson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rockingham"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rowan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rutherford"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sampson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scotland"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stanly"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stokes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transylvania"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tyrrell"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Union"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wake"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watauga"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wayne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilkes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yadkin"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yancey"]

{"sheet":"Malfunctioning Systems","index":1,"n_rows":309,"n_cols":12,"rows_kept":309,"cut":false,"hidden":false,"merged":[[164,1,164,2],[164,6,164,8],[111,3,111,5],[119,0,119,3],[145,1,145,3],[145,6,145,8],[192,6,192,8],[103,3,103,5],[105,3,105,5],[107,3,107,5],[108,3,108,5],[109,3,109,5],[110,3,110,5],[127,1,127,3],[128,1,128,3],[129,1,129,3],[130,1,130,3],[131,1,131,3],[132,1,132,3],[133,1,133,3],[134,1,134,3],[135,1,135,3],[136,1,136,3],[137,1,137,3],[99,3,99,5],[100,3,100,5],[101,3,101,5],[102,3,102,5],[89,3,89,6],[90,3,90,5],[92,3,92,5],[93,3,93,5],[94,3,94,5],[96,3,96,5],[87,3,87,6],[88,3,88,6],[78,3,78,6],[79,3,79,6],[80,3,80,6],[81,3,81,6],[82,3,82,6],[97,3,97,5],[98,3,98,5],[66,0,66,3],[67,0,67,3],[68,0,68,3],[83,3,83,6],[84,3,84,6],[85,3,85,6],[86,3,86,6],[74,3,74,6],[77,3,77,6],[39,0,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[43,0,43,3],[44,0,44,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[4,0,4,11],[21,0,21,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[8,10,11,10],[8,11,11,11],[12,0,12,3],[13,0,13,3],[14,0,14,3],[6,0,6,11],[7,0,7,11],[8,0,11,3],[8,4,11,4],[8,5,11,5],[8,6,11,6],[121,1,121,3],[122,1,122,3],[123,1,123,3],[124,1,124,3],[125,1,125,3],[126,1,126,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[73,3,73,6],[75,3,75,6],[76,3,76,6],[63,0,63,3],[64,0,64,3],[65,0,65,3],[8,9,11,9],[33,0,33,3],[34,0,34,3],[35,0,35,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[8,8,11,8],[8,7,11,7],[158,1,158,5],[148,1,148,3],[138,1,138,3],[139,1,139,3],[140,1,140,3],[141,1,141,3],[142,1,142,3],[143,1,143,3],[144,1,144,3],[146,1,146,3],[147,1,147,3]]}
[]
[]
[]
[]
["Malfunctioning Systems (System/Component Repairs, other than Tanks Only)"]
[]
["Fill out this section at the time the Operation Permit for the malfunctioning system is issued."]
["For the system that malfunctioned or was damaged or destroyed."]
["Unique Identifier - REQUIRED                  [Physical--\"911\"-- Address]",null,null,null,"Failing System Code","Age (whole number)","Was it Initial or Repair","Permitting Authority for Failing System","Type Distri-bution","Design Flow (gpd)","Type of Failure Code","Primary Cause Code"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Code","Type of Distribution"]
[]
[null,null,"G","Gravity"]
[null,null,"P","Pumped, Pressure Dosed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Code","Causes of Malfunction"]
[]
[null,null,"S","Site Problems: Soil, Inflow, Landscape Position, Gutters, Roots"]
[null,null,"M","Maintenance: Tank not pumped, Filter clogged, etc."]
[null,null,"U","Use: Water leak in house, too much flow for design, grease, etc."]
[null,null,"ID","Installation depth, Excess Cover"]
[null,null,"D","Damaged or Destroyed"]
[null,null,"E","Effluent distribution device, step down, or drop box"]
[null,null,"P","Pressure Dosing Problems"]
[null,null,"A","Age - Normal exhaustion of hydraulic conductivity"]
[null,null,"T","Tank or Pump Tank not Watertight"]
[null,null,"X","Pretreatment failure"]
[null,null,"Z","System Undersized"]
[null,null,"Q","Couldn’t determine"]
[]
[null,null,"Code","Type of Malfunction"]
[]
[null,null,"BU","Back up into facility"]
[null,null,"SD","Surface Discharge"]
[null,null,"FL","Free liquid w/in 3\" of surface"]
[null,null,"P","Requires pumping > 1/month"]
[null,null,"GW","Discharge to Groundwater"]
[]
[]
[null,null,"I","Initial"]
[null,null,"R","Repair"]
[]
[]
[]
["Failing Systems Codes"]
[]
["GTR","Gravel/Trench"]
["GBD","Gravel Bed (Not in Fill)"]
["CHM 36","Chamber (3-ft Wide, 11-13\" High)"]
["POLY","Polystyrene (EZFlow, Flowtech)"]
["CHM LP","Chamber Low Profile"]
["LDP ","Large Diameter Pipe (8\" and 10\")"]
["CHM 22","Chamber 22\" Wide"]
["PPBPS V","PPBPS Vertical"]
["PPBPS H","PPBPS Horizontal"]
["TCHP","Tire Chips "]
["LPP","Low-Pressure Pipe "]
["DPRAN","Drip Dispersal Anaerobic (Perc Rite)"]
["DRIPAE","Drip Dispersal Aerobic"]
["CHM HC","Chamber High Capacity"]
["SLT","Sand-Lined Trench"]
["MLTP","Multi-Pipe (\"Septic Stack\")"]
["CHM L20","Chamber ≤ 20\" Wide"]
["OBED","Other Beds (Accept./Innov., Not in Fill)"]
["BIF","Bed in Fill (Innovative)"]
["PRESBY","Presby AES"]
["ELJEN","Eljen GSF A42"]
["TCT","Terra Cotta Tiles"]
["SP","Straight Pipe"]
["PRIV","Privy"]
["ADVPT","Advanced Pretreatment"]
["OTH","Other"]
["UND","Undetermined"]
["-","Blank"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Code","Permitting Authority for Malfunctioning System"]
[]
["LHD","Local Health Department/State/No Permit"]
["EOP","Engineered Option Permit"]
["AOWE","Authorized On-Site Evaluator"]
["SL","Session Law 2018-114"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Alamance"]
[null,"Alexander"]
[null,"Alleghany"]
[null,"Anson"]
[null,"Ashe"]
[null,"Avery"]
[null,"Beaufort"]
[null,"Bertie"]
[null,"Bladen"]
[null,"Brunswick"]
[null,"Buncombe"]
[null,"Burke"]
[null,"Cabarrus"]
[null,"Caldwell"]
[null,"Camden"]
[null,"Carteret"]
[null,"Caswell"]
[null,"Catawba"]
[null,"Chatham"]
[null,"Cherokee"]
[null,"Chowan"]
[null,"Clay"]
[null,"Cleveland"]
[null,"Columbus"]
[null,"Craven"]
[null,"Cumberland"]
[null,"Currituck"]
[null,"Dare"]
[null,"Davidson"]
[null,"Davie"]
[null,"Duplin"]
[null,"Durham"]
[null,"Edgecombe"]
[null,"Forsyth"]
[null,"Franklin"]
[null,"Gaston"]
[null,"Gates"]
[null,"Graham"]
[null,"Granville"]
[null,"Greene"]
[null,"Guilford"]
[null,"Halifax"]
[null,"Harnett"]
[null,"Haywood"]
[null,"Henderson"]
[null,"Hertford"]
[null,"Hoke"]
[null,"Hyde"]
[null,"Iredell"]
[null,"Jackson"]
[null,"Johnston"]
[null,"Jones"]
[null,"Lee"]
[null,"Lenoir"]
[null,"Lincoln"]
[null,"Macon"]
[null,"Madison"]
[null,"Martin"]
[null,"McDowell"]
[null,"Mecklenburg"]
[null,"Mitchell"]
[null,"Montgomery"]
[null,"Moore"]
[null,"Nash"]
[null,"New Hanover"]
[null,"Northampton"]
[null,"Onslow"]
[null,"Orange"]
[null,"Pamlico"]
[null,"Pasquotank"]
[null,"Pender"]
[null,"Perquimans"]
[null,"Person"]
[null,"Pitt"]
[null,"Polk"]
[null,"Randolph"]
[null,"Richmond"]
[null,"Robeson"]
[null,"Rockingham"]
[null,"Rowan"]
[null,"Rutherford"]
[null,"Sampson"]
[null,"Scotland"]
[null,"Stanly"]
[null,"Stokes"]
[null,"Surry"]
[null,"Swain"]
[null,"Transylvania"]
[null,"Tyrrell"]
[null,"Union"]
[null,"Vance"]
[null,"Wake"]
[null,"Warren"]
[null,"Washington"]
[null,"Watauga"]
[null,"Wayne"]
[null,"Wilkes"]
[null,"Wilson"]
[null,"Yadkin"]
[null,"Yancey"]

{"sheet":"Large-IPWW Systems","index":2,"n_rows":136,"n_cols":14,"rows_kept":136,"cut":false,"hidden":false,"merged":[[135,4,135,6],[129,4,129,6],[130,4,130,6],[131,4,131,6],[132,4,132,6],[133,4,133,6],[134,4,134,6],[124,4,124,6],[125,4,125,6],[126,4,126,6],[128,4,128,6],[127,4,127,6],[119,4,119,7],[120,4,120,7],[123,4,123,6],[121,4,121,7],[116,11,116,13],[117,11,117,13],[118,11,118,13],[114,11,114,13],[115,11,115,13],[116,4,116,7],[117,4,117,7],[118,4,118,7],[114,4,114,7],[115,4,115,7],[109,11,109,14],[106,11,106,14],[107,11,107,14],[108,11,108,14],[113,11,113,13],[111,11,111,14],[108,4,108,7],[106,4,106,7],[107,4,107,7],[109,4,109,7],[113,4,113,7],[104,4,104,7],[104,11,104,14],[98,4,98,7],[98,11,98,14],[105,11,105,14],[96,4,96,7],[96,11,96,14],[97,4,97,7],[97,11,97,14],[103,4,103,7],[103,11,103,14],[105,4,105,7],[93,11,93,14],[94,11,94,14],[95,11,95,14],[90,11,90,14],[91,11,91,14],[92,11,92,14],[93,4,93,7],[94,4,94,7],[95,4,95,7],[90,4,90,7],[91,4,91,7],[92,4,92,7],[72,0,72,3],[73,0,73,3],[74,0,74,3],[88,4,88,7],[88,11,88,14],[89,4,89,7],[89,11,89,14],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[65,0,65,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[42,0,42,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[136,4,136,6],[119,11,119,13],[7,4,10,4],[7,5,10,5],[7,6,10,6],[7,7,10,7],[7,8,10,8],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[7,9,10,9],[7,10,10,10],[7,11,10,11],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[18,0,18,3],[19,0,19,3],[4,0,5,13],[6,0,6,13],[7,0,10,3],[99,4,99,7],[100,4,100,7],[99,11,99,14],[110,4,110,7],[110,11,110,14],[7,12,10,12],[7,13,10,13],[11,0,11,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[30,0,30,3],[31,0,31,3],[32,0,32,3]]}
[]
[]
[]
[]
["Large/Industrial Process (IPWW) Systems [Also Called Underground Injection Control, or \"UIC  Systems]"]
[]
["Fill out this section at the time there is any Permitting, Inspection, or Enforcement Activity for a Large (>3000 GPD) or IPWW System "]
["System/Facility Name (Per OSWP Large System/IPWW DataBase, Or New)",null,null,null,"Existing or New","OSWP File No.","LHD Permit Number","Operating Status","Permit Activity","Inspection Activity","Enforcement Activity","Violation","Type of Failure Code","Primary Cause Code"]
[]
[]
[]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[null,null,null,"Code","Status"]
[null,null,null,"E","Existing"]
[null,null,null,"N","New"]
[]
[]
[]
[]
[]
[null,null,null,"Code","Operating Status",null,null,null,null,null,"Code","Permit Activity"]
[null,null,null,"PW","Proposed Project",null,null,null,null,null,"APL","Application Received"]
[null,null,null,"UC","Under Construction",null,null,null,null,null,"REV","Project Reviewed"]
[null,null,null,"AC","Active/Operational",null,null,null,null,null,"IP","Improvement Permit Issued"]
[null,null,null,"NB","Never Built/Project Abandoned",null,null,null,null,null,"CA","Construction Authorization Issued"]
[null,null,null,"RH","Another System Permitted By Health Department",null,null,null,null,null,"IPCA","IP and CA Issued"]
[null,null,null,"CS","Connected to City Sewer",null,null,null,null,null,"OP","Operation Permit Issued"]
[null,null,null,"FC","Facility Closed",null,null,null,null,null,"OPR","Operation Permit Reissued"]
[null,null,null,"SD","System Destroyed/No Longer There",null,null,null,null,null,"PD","Permit Denied"]
[null,null,null,"RD","Another System Permitted by DWR/DEM",null,null,null,null,null,"PSRR","Permit Suspended/Revoked/Recinded"]
[null,null,null,"IA","Installed/Inactive/Not in Use",null,null,null,null,null,"MOP","Modification Proposed"]
[null,null,null,"SA","System Abandoned"]
[]
[]
[]
[null,null,null,"Code","Inspection Activity",null,null,null,null,null,"Code","Enforcement Activity"]
[null,null,null,"PRCO","Preconstruction Meeting",null,null,null,null,null,"NOV","Notice of Violation"]
[null,null,null,"CO","Construction Inspection",null,null,null,null,null,"ADM","Administration Penality Request"]
[null,null,null,"RP","Routine/Peroidic Inspection",null,null,null,null,null,"PSR","Permit Suspension/Revocation"]
[null,null,null,"EC","Complaint Inspection",null,null,null,null,null,"CIR","Injunction/Civil Referal"]
[null,null,null,"ABI","Abandonment Inspection",null,null,null,null,null,"CRR","Criminal Penalities"]
[null,null,null,"OTH","Other Inspection",null,null,null,null,null,"NONC","Notice of Non-Compliance "]
[null,null,null,null,null,null,null,null,null,null,"OTH","Other"]
[]
[]
[null,null,null,"Code","Violation",null,null,null,null,null,"Code","Type of Malfunction"]
[null,null,null,"MS","System Malfunction",null,null,null,null,null,"BU","Back up into facility"]
[null,null,null,"NOP","No Operator",null,null,null,null,null,"SD","Surface Discharge"]
[null,null,null,"OP","Operation and Maintenance",null,null,null,null,null,"FL","Free liquid w/in 3\" of surface"]
[null,null,null,"MR","Monitoring/Reporting",null,null,null,null,null,"P","Requires pumping > 1/month"]
[null,null,null,"ESE","Effluent Standadrd Exceedence",null,null,null,null,null,"GW","Discharge to Groundwater"]
[null,null,null,"GSE","Groundwater Standard Exceedence"]
[null,null,null,"OWP","Operating Without Permit"]
[]
[]
[null,null,null,"Code","Primary Cause of Malfunction"]
[null,null,null,"S","Site Problems: Soil, Inflow, Landscape Position, Gutters, Roots"]
[null,null,null,"M","Maintenance: Tank not pumped, Filter clogged, etc."]
[null,null,null,"U","Use: Water leak in house, too much flow for design, grease, etc."]
[null,null,null,"ID","Installation Depth/Excess Cover"]
[null,null,null,"D","Damaged or Destroyed"]
[null,null,null,"E","Effluent distribution device, step down, or drop box"]
[null,null,null,"P","Pressure Dosing Problems"]
[null,null,null,"A","Age - Normal exhaustion of hydraulic conductivity"]
[null,null,null,"T","Tank or Pump Tank not Watertight"]
[null,null,null,"X","Pretreatment failure"]
[null,null,null,"Z","System Undersized"]
[null,null,null,"Q","Couldn’t determine"]