Minutes

             
A Consideration and Adoption of Ordinance No. 2020-13:  An ordinance of the City Council of the City of Flagstaff, amending the Flagstaff City Code, Title 7 Health and Sanitation, Chapter 7-03 Water System Regulations, Section 7-03-001-0010, Subsection A Water Rates, to establish a new Water Resources Infrastructure Protection through Wildland Fire Management Fee; providing for penalties, repeal of conflicting ordinances, severability, and establishing an effective date.         
 
  Mayor Evans opened the public hearing on Items 7A and 7B.
 
Sustainability Director Nicole Antonopoulos provided a PowerPoint presentation that covered the following:
 
WATER RESOURCE INFRASTRUCTURE PROTECTION INITIATIVE AND RESTRUCTURING ENVIRONMENTAL MANAGEMENT FEES
DISCUSSION
 
Wildland Fire Manager Neil Chapman continued the presentation.
 
BACKGROUND
ONGOING WILDLAND FIRE MANAGEMENT PROGRAM FUNDING
WILDFIRE MANAGEMENT
CUSTOMER IMPACT – FINANCIAL SCENARIOS
 
Ms. Antonopoulos concluded the presentation.
 
CLIMATE CHANGE IN FLAGSTAFF
VULNERABILITIES: WHAT IS AT RISK?
ENVIRONMENTAL MANAGEMENT FEE
A FEE RESTRUCTURE – WHY?
PROPOSED FEE RESTRUCTURE
RESIDENTIAL CUSTOMER IMPACT EXAMPLE WITH TYPICAL MUNICIPAL BILL SERVICE
COMMERCIAL CUSTOMER IMPACT EXAMPLE WITH MUNICIPAL TRASH AND RECYCLING SERVICE
EMF/WRIP RESIDENTIAL IMPACT SUMMARY
TIMELINE
OUTREACH
BUILDING COMMUNITY TOGETHER
ADVANCING CITY INITIATIVES
 
The following individuals addressed Council:
  • Karin Malis-Clark
  • Anne Mottek
The following comments were received:
  • The City of Flagstaff has been a leader and a partner in Forest Health; the fee will enable the City to sustain that leadership and continue to be a strong partner.
  • Considering the investment that Flagstaff voters have already made in the Flagstaff Watershed Protection Project, continuing forest health and restoration measures that reduce severe wildfire risk and potential destruction of our watersheds, is critical to maintaining quality of life for citizens.

There being no further public comment Mayor Evans closed the public hearing on Item 7A.
 
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Austin Aslan read Ordinance No. 2020-13 by title only for the first time with the minor change of going from Option 1 to Option 2.
  Moved by Councilmember Charlie Odegaard, seconded by Councilmember Regina Salas to amend the motion to go with Option 1.
 
Councilmember McCarthy stated that Option 2 provides additional watershed protection and Option 1 eliminates that. The average cost to the household is $0.52 per month which he believes is minimal.
 
Councilmember Aslan agreed stating that he prefers to see funding go toward wildfire management.
 
Councilmember Odegaard stated that he is concerned about raising fees for new projects in the face of housing concerns. He is also concerned about starting the new projects associated with Option 2 during the pandemic.
  Vote: 3 - 4
 
AYE: Councilmember Charlie Odegaard
  Councilmember Regina Salas
  Mayor Coral Evans
  Vote: 3 - 4
 
AYE: Councilmember Austin Aslan
  Councilmember Jamie Whelan
  Councilmember Jim McCarthy
  Moved by Councilmember Austin Aslan, seconded by Vice Mayor Adam Shimoni to read Ordinance No. 2020-13 as presented by title only for the first time.
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, AMENDING THE FLAGSTAFF CITY CODE, TITLE 7 HEALTH AND SANITATION, SECTION 7-03 WATER SYSTEM REGULATIONS, SECTION 7-03-001-0010, SUBSECTION A WATER RATES, TO ESTABLISH A NEW WATER RESOURCES INFRASTRUCTURE PROTECTION THROUGH WILDLAND FIRE MANAGEMENT FEE; PROVIDING FOR PENALTIES, REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, AND ESTABLISHING AN EFFECTIVE DATE
 


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_minutes_popup.cfm
Time Stamp 28-Apr-24 06:12 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
125 ms 125 ms 1 top level D:\inetpub\PublicPages\public\publish\print_minutes_popup.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
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/include_min_print.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
140 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 @ 18:12:05.005
			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 @ 18:12:05.005
				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 @ 18:12:05.005
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
SELECT fas.form_num fas_form_num, 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.final_stop fas_final_stop,
	   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id,
	   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo, mt.meeting_type,
	   cv.misc_alpha vote_indent, cr.misc_alpha roll_indent,
	   am.long_descr vote_label, am.misc_alpha motion_verbiage
FROM fas
INNER JOIN MINUTES AS ft ON (ft.form_num = fas.form_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)
INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_FONT' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_FONT' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
WHERE UPPER(fas.form_id) = 'MINUTES' AND
			fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 491

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:12:05.005
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1064

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(1064 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
	SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 491

getLines (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
SELECT ml._rowid _rowid, ml.form_num, ml.rev_num, ml.seq_num,
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.page_br,
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action,
	   CASE WHEN ml.ainumber IS NOT NULL THEN ml.ainumber ELSE am.ainumber END as ainumber,
	   c.descr as status_desc,
	   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box2_label, ai.box2_disp, ai.box3_label, ai.box3_disp, ai.box4_label,
	   ai.box4_disp, ai.box5_label, ai.box5_disp, ai.box6_label, ai.box6_disp, ai.box7_label, ai.box7_disp,
	   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_underline, ai.lbl_size,
	   ai._rowid as ag_item_rowid
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)

LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 1063 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)
LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = ? AND
	  ml._rowid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 491
Parameter #2(cf_sql_integer) = 10986

getMinutes (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
	SELECT meet_minutes, ln_rowid, seq_num, time_of_vote, _rowid,
			text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 491 AND
		  rev_num = 0 AND
		  ln_rowid = 10986 AND
		  meet_minutes IS NOT NULL
getMotions (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
	SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text, motion.time_of_vote,
		   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
		   motion.motion_status status_desc, motion._rowid, motion.seq_num, c.misc_alpha disp_after_motion
	FROM minutes_ln_motion motion
    INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
	LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
										  r.rev_num = motion.rev_num AND
										  r.valid_code = motion.motion_id)
	LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
										  r2.rev_num = motion.rev_num AND
										  r2.valid_code = motion.second_id)
	LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
	WHERE motion.form_num = 491 AND
		  motion.rev_num = 0 AND
		  motion.ln_rowid = 10986 AND
		  motion.motion_status <> 'VERBIAGE'
	ORDER BY motion.motion_seq
getVotes (Datasource=frsRO, Time=16ms, Records=21) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
	SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
		   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type,
		   v.seq_num sort1, motion.time_of_vote, m.meeting_id,
		   c3.long_descr vote_label,
		   CASE WHEN c2.long_descr = 'Y' THEN 1
				WHEN c2.long_descr = 'N' THEN 2
				ELSE 3 END AS sort2
	FROM minutes_ln_vote AS v
	INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
	INNER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote AND c2.misc_alpha3 = 'Y')
	LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND c3.valid_code = CAST(m.meeting_id AS varchar))
	LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND
										  r.rev_num = v.rev_num AND
										  r.valid_code = v.valid_code)
	LEFT OUTER JOIN minutes_ln_motion motion ON
			(motion.form_num = v.form_num AND
		 	 motion.rev_num = v.rev_num AND
		 	 motion.ln_rowid = v.ln_rowid AND
		 	 motion.motion_seq = v.motion_seq)
	WHERE v.form_num = 491 AND
		  v.rev_num = 0 ANd
		  v.ln_rowid = 10986 
	ORDER BY sort2, sort1						
	
SortedList (Datasource=, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\include_min_print.cfm @ 18:12:05.005
	SELECT * from sortList
	ORDER BY seqNum
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 10580 
getMotion (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 2862 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 10986 AND
						      motion_seq = 2 
getMotionVote (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 10986 AND
							  getVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
getMotion (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 2863 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 10986 AND
						      motion_seq = 3 
getMotionVote (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 10986 AND
							  getVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'N' 
getMotion (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 2864 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 10986 AND
						      motion_seq = 4 
getMotionVote (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 10986 AND
							  getVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'N' 
getMotion (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
				    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
							   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, c.misc_alpha disp_after_motion
				        FROM minutes_ln_motion motion
				        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
						LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
															  r.rev_num = motion.rev_num AND
															  r.valid_code = motion.motion_id)
						LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
															  r2.rev_num = motion.rev_num AND
															  r2.valid_code = motion.second_id)
						LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
						WHERE motion._rowid = 2865 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 10986 AND
						      motion_seq = 5 
getMotionVote (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 10986 AND
							  getVotes.motion_seq = 5 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:12:05.005
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 18:12:05.005
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 7195 


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_minutes_popup.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_minutes_popup.cfm?seq=491&ln=10986&reloaded=false
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_minutes_popup.cfm
QUERY_STRING=seq=491&ln=10986&reloaded=false
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_minutes_popup.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=9361744
cftoken=eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
hitcount=2
lastvisit={ts '2024-04-28 18:12:05'}
timecreated={ts '2024-04-28 18:12:05'}
urltoken=CFID=9361744&CFTOKEN=eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
Cookie Variables:
CFID=9361744
CFTOKEN=eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
Session Variables:
cfid=9361744
cftoken=eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9361744_eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
subdir=/public/
tzoffset=0
urltoken=CFID=9361744&CFTOKEN=eca799d63ca59e24-89E7921E-AEB2-8BD2-793C0B3E52FDB612
URL Parameters:
ln=10986
reloaded=false
seq=491
Debug Rendering Time: 0 ms