7.A.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From:
Co-Submitter: Chris Kirkendall
Date: 11/27/2018
Meeting Date: 12/04/2018

TITLE:
Consideration and Adoption of Resolution No. 2018-43 and Ordinance No. 2018-32:  An ordinance and resolution amending the Flagstaff City Code, Title 7, Health and Sanitation, and Title 12, Floodplains, to adopt an Enforcement Response Plan related to enforcement of water, pretreatment, wastewater, and stormwater regulations, including administrative fines and/or penalties for violations
STAFF RECOMMENDED ACTION:
At the December 4, 2018 Council Meeting:
1) Adopt Resolution No. 2018-43
2) Read Ordinance No. 2018-32 by title only for the final time
3) City Clerk reads Ordinance No. 2018-32 by title only (if approved above)
4) Adopt Ordinance 2018-32
Executive Summary:
Flagstaff Water Services has developed an Enforcement Response Plan (ERP) and drafted code changes to meet the requirements of a state-issued stormwater general permit and City Code requirements for the industrial pretreatment program in Title 7. 

The ERP provides clear guidance and direction to both City staff and our regulated customers which will take any guesswork out of the enforcement process.  The draft ERP was organized to establish escalating enforcement procedures and penalties and identify staff roles and responsibilities. It was written to provide our regulated customers every opportunity to return to compliance prior to any escalated enforcement proceedings. 

Flagstaff Water Services solicited comments to the ERP from our customers and from the Flagstaff Water Commission.  Beginning August 7, 2018, the draft ERP was posted on the Flagstaff Water Services Website, posted in the AZ Daily Sun, posted on the Flagstaff Water Services Facebook page and provided to our permitted industrial users thru Email.  Flagstaff Water Services also presented the ERP to the Flagstaff Water Commission in August 2018 and again in October, 2018.
Financial Impact:
The ERP establishes an administrative fine schedule for violation of specific regulations.  Any person violating the regulations may be subject to the fines. The City may collect some fines where in the past it did not pursue financial recourse for violations.  The anticipated financial impact to the City is nominal. 
Policy Impact:
The proposed ERP supports City compliance with the Clean Water Act and protection of water supplies and water services facilities.
Connection to Council Goal, Regional Plan and/or Team Flagstaff Strategic Plan:
ENVIRONMENTAL AND NATURAL RESOURCES
Actively manage an dprotect all environmental and natural resources.

CODE COMPLIANCE
Achieve comprehensive and equitable code compliance.
 
Has There Been Previous Council Decision on This:
No, no prior adoption of an ERP.  Council is considering the ERP at a work session on November 13, 2018.
Background and History:
The Arizona Department of Environmental Quality (ADEQ) issued a new small Municipal Separate Storm Sewer System (MS4) general permit on September 30, 2016.  The City of Flagstaff is required to meet the conditions of the new permit, which includes developing an Emergency Response Plan (ERP) and enforcement procedures.  Additionally, Flagstaff City Code requires an ERP for the Industrial Pretreatment program.  Water Services staff has developed a draft ERP that meets both of these requirements by incorporating the pretreatment and stormwater programs.  Additionally, the ERP also incorporates the Cross-Connection Control program, which is part of the Industrial Pretreatment Program.

The ERP was written to set escalating enforcement procedures and penalties for code violations to the Stormwater and Industrial Pretreatment Programs.  The language was drafted to allow violators to return to compliance with no penalties, provided the issues are corrected within a calendar quarter or the violator has entered into an administrative agreement with the City to correct the issues.  The ERP provides clear guidance and direction to City staff and provides the expectations to the regulated industry and penalties/corrective action for non-compliance.  The ERP takes any guesswork out of the enforcement process.

The ERP was developed to meet the following criteria:
  • Respond to and comply with changes in state law
  • Set escalating enforcement procedures and penalties (prioritization) for code violations.
  • Identify staff Roles and Responsibilities by Position Title
  • Sets how the City will exercise its legal authority to comply with the State stormwater permit and pretreatment code.
Escalating enforcement procedures are as follows:
  • Inspection Report/Warning Letter
  • Notice of Violation/Corrective Action Notice
  • Administrative Order/Stop Work Order
  • Administrative fines/penalties
  • Civil Litigation – At Discretion of City Attorney's Office
Changes to Title 7 and 12 of existing City Code were also required to implement and enforce provisions of the ERP.  Changes to the stormwater code in Title 12 were needed to provide the ability to enter into consent agreements or administrative orders, establish a civil penalty authority, and the authority to impose criminal sanctions.  The pretreatment code in Title 7 also needs some revisions to clean up the authority to match the ERP.  Title 7 was organized by adding a separate chapter to include all enforcement for Water Services in Title 7, Chapter 1.  Changes were made in Title 7, Chapter 2 to clean up definitions, fix broken links to other Code, as a result of renumbering changes and change the name of Industrial Waste to Industrial Pretreatment.  The enforcement process in title 12, chapter 3 of the stormwater code matches that found in title 7, chapter 1 of the Water Services Code.

Flagstaff Water Services solicited comments from our customers on the draft ERP.  Beginning August 7, 2018, the draft ERP was posted on the Flagstaff Water Services Website, posted in the AZ Daily Sun, posted on the Flagstaff Water Services Facebook page and provided to our permitted industrial users thru Email.  Additionally, flyers were printed and handed out by inspectors in the field.  Flagstaff Water Services also presented the ERP to the Flagstaff Water Commission in August 2018 and again in October.
Key Considerations:
The City is required to adopt an Enforcement Response Plan (ERP) to comply with the ADEQ state general permit issued for Municipal Separate Storm Sewer Systems (MS4);

The proposed ERP creates a uniform enforcement process for industrial pretreatment, cross-connection, and/or stormwater regulations.

Attachments: Res. 2018-43
Draft ERP
Exhibit A Part 1 pretreatment regs
Exhibit A Part 2 stormwater
Ord. 2018-32


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_ag_memo.cfm
Time Stamp 01-May-24 12:34 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level D:\inetpub\PublicPages\public\publish\print_ag_memo.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(3801, 4, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/flagstaff.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
187 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 12:34:28.028
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 12:34:28.028
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:34:28.028
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 12:34:28.028
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop,
		   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.date_final,
		   fas.final_prt_date, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4,al.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold,
	 	   	 
	 	   		c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all,
	 	   	
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (fas.form_num = ft.form_num AND fas.rev_num = ft.rev_num)
	INNER JOIN form_hist ON (UPPER(form_hist.form_id) = fas.form_id AND UPPER(form_hist.stat_action) = 'ADD' AND form_hist.form_num = fas.form_num AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3801
Parameter #2(cf_sql_integer) = 4

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 12:34:28.028
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 12:34:28.028
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 12:34:28.028
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 791 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 791 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 790 AND agi._rowid = 86)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 791 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 86 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 86)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '86')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi14')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '86'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 3801 AND
				      u.rev_num = 4 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi14'
			
fi14q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi14' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2018-12-04

getPXvalue (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submit_for (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
			SELECT ee.title utitle,
			ee.fname + ' ' + ee.lname name
			,ee.lname, ee.fname, p.phone_no, p.phone_ext, websecur.email,
			dept.dept_desc, dd.div_desc,
			case when ee.title is null then 'false' else 'true' end as display_title
			FROM websecur
			LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
			LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
			LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
										dd.div_code = ee.division)
			LEFT OUTER JOIN phone AS p ON (p.empl_id = websecur.empl_id AND is_primary = 'Y')
			WHERE login_id = 'ckirkendall'
		
getSubmitFor (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
			SELECT * from submit_for WHERE submit_for.name LIKE 'Chris Kirkendall%'
		
submittor (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'scamp'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 3801 AND
      rev_num = 4
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 3801 AND ag_memo_dol.rev_num = 4
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=16ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 3801 AND
		  ad.rev_num = 4 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT * from codes where code_type ='asdfasdfasfa'
	
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 3801 AND
		      rev_num = 4
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 3801 AND form_rte.rev_num = 4 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 3801 AND
		  rev_num = 4 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = 'AI86')
		LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by)
		LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
		WHERE UPPER(hist.form_id) = 'AG_MEMO' AND
			  hist.form_num = 3801 AND
			  hist.rev_num = 4 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 12:34:28.028
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:34:28.028
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 791

GetThisLine (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:34:28.028
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
					   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
					   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
					   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 790 AND ai._rowid = 86)
				
				LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
				LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = al.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(al.ag_level1 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = al.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(al.ag_level2 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = al.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(al.ag_level3 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = al.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(al.ag_level4 AS binary(8)))
				LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
				LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
				WHERE al._rowid = 18820 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:34:28.028
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 790
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:34:28.028
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 790
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:34:28.028
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 790
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 12:34:28.028
		SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
			   ud.form_label, codes.descr, codes.large_misc_alpha
		FROM form_userdef AS u
		INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
		LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
		WHERE u.form_id = 'AG_MEMO' AND
			  u.form_num = 3801 AND
			  u.rev_num = 4 and
			  ud.form_label LIKE '%submitter%'
	


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\public\publish\print_ag_memo.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//public/publish/print_ag_memo.cfm?seq=3801&rev_num=4&mode=External&reloaded=true&id=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\public\publish\print_ag_memo.cfm
QUERY_STRING=seq=3801&rev_num=4&mode=External&reloaded=true&id=
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_ag_memo.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9432630
cftoken=db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
hitcount=2
lastvisit={ts '2024-05-01 12:34:28'}
timecreated={ts '2024-05-01 12:34:28'}
urltoken=CFID=9432630&CFTOKEN=db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
Cookie Variables:
CFID=9432630
CFTOKEN=db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
Session Variables:
cfid=9432630
cftoken=db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9432630_db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
subdir=/public/
tzoffset=0
urltoken=CFID=9432630&CFTOKEN=db9f499f97278624-18522BD3-E279-F9CB-286A52466A0C0755
URL Parameters:
id=
mode=External
reloaded=true
rev_num=4
seq=3801
Debug Rendering Time: 0 ms