Minutes

             
A Consideration and Adoption of Ordinance No. 2018-40: An ordinance of the Mayor and Council of the City of Flagstaff, Arizona amending the Flagstaff City Code, Title 12, Floodplains, Chapter 12-02, Stormwater Management Utility, by amending the  Schedule of Stormwater Management Utility Service Charges and Fees; providing for repeal of conflicting ordinances, severability, penalties, and establishing an effective date. (Changes in stormwater fees)         
 
  Mayor Evans opened the Public Hearing.
 
Stormwater Manager Chris Kirkendall provided a PowerPoint presentation that covered the following:
 
STORMWATER UTILITY SERVICE CHARGE
OVERVIEW
COUNCIL DIRECTION
COMMUNITY NEEDS
STORMWATER CURRENT TOP 10 PRIORITIES
PUBLIC OUTREACH
 
Councilmember Barotz asked why the Water Commission did not have a recommendation. Water Services Director Brad Hill stated that there was significant discussion and they considered both the ten- and twelve-year options. They did not like either option so they opted to offer no recommendation.
 
Management Services Director Rick Tadder continued the presentation.
 
SERVICE CHARGE INCREASE OBJECTIVES
STORMWATER SERVICE CHARGE – $36 MILLION INCREASE FOR CAPITAL PROJECTS
STORMWATER SERVICE CHARGE – INCREMENTAL INCREASE
$36 MILLION INCREASE FOR CAPITAL PROJECTS - INCREMENTAL INCREASE
 
Councilmember Overton asked if it is possible to leave the current rate and assign it to bond debt over a longer period of time such as 25 or 30 years. Mr. Tadder explained that the current rate would not be enough in that time frame as some of that funding has already been set for other projects. Councilmember Overton asked if it would be enough to fund the federal obligation for the Rio de Flag to which Mr. Tadder responded no.
 
Capital Improvements Engineer Bret Peterson continued the presentation.
 
RIO DE FLAG FLOOD CONTROL PROJECT UPDATE
ARMY CORPS OF ENGINEERS’ ITEMS
BNSF RAILWAY COORDINATION ITEMS
PUBLIC INVOLVEMENT UPDATE
 
Councilmember McCarthy asked if all three options would allow for the Rio de Flag project to be funded along with all the other capital projects. Mr. Tadder stated that all projects would be completed but the pay as you go options would delay some of the projects until adequate funding is generated.
 
Councilmember Barotz asked who pays the stormwater fee. Mr. Tadder stated that everyone within City limits pay the stormwater fee. The residential fee is capped at five ERUs.
 
Mr. Tadder continued the presentation.
 
ACCELERATED PROJECTS SCENARIO
 
Ms. Goodrich stated that the City is at a point with the Army Corp. of Engineers (ACE) with the Rio de Flag project where it is important to understand that as early as October 2019 ACE may be asking for solid assurance that the City has the $30 to $36 million it needs for its share of the project. This is why the options are being provided now to generate the funds sooner rather than go through a pay as you go program. While a pay as you go program would get the $36 million it would not happen soon enough.
 
Councilmember Overton asked if there are other funding mechanisms if the Rio de Flag project did not come to fruition. It is difficult to ask citizens to pay for a project that has been going on for 15 years with no assurance it will actually come forward. Ms. Goodrich stated that the City needs to start accumulating funds regardless of who does the project. In terms of other funding alternatives, she believes that as long as the City can show ACE that there is a plan in place to accumulate the funding, it would be enough to move forward and give the Council time to develop an appropriate fee schedule.
 
Vice Mayor Whelan asked if the Council were to move forward with revenue bonds and the project were to not come forward if the bond funds could be returned. Ms. Goodrich stated the Council could give direction to return those funds. Mr. Tadder added that approving the rate does not authorize the debt, that is a separate action by the Council.
 
Mr. Tadder concluded the presentation.
 
ACCELERATED PROJECTS SCENARIO - $33M/25 YEAR DEBT
ACCELERATED PROJECTS SCENARIO - $33M/25 YEAR DEBT – INCREMENTAL INCREASE
FLAT RATE SCENARIO
 
Mayor Evans asked if the Coconino County Flood Control District has provided any indication that the Rio de Flag project could be funded by the District. Ms. Goodrich stated that the District has not provided that information.
 
Vice Mayor Whelan stated that the Rio de Flag project has been going on for a very long time and it now looks like a real possibility to get it done. The City needs to move on the rates and keep the fee as small as possible. If the way to go is revenue bonds that can be pulled back if the project does not go forward then that is what she is supportive of doing.
 
The following individuals addressed Council in opposition of changes to stormwater fees:
  • Stephen Vedral
  • Rick Lopez
  • Andy Fernandez
The following comments were received:
  • It is difficult to absorb the doubling of anything into a budget.
  • It is already expensive to live in Flagstaff this will make it even more so.
  • The Rio de Flag project began as a $20 million project and now it is a $130 million project.
  • Skeptical that ACE will actually come through and deliver the project.
  • The what ifs need to be addressed before asking citizens to shoulder the cost.
  • NAU needs to come to the table as a financial partner, they have a huge impact in the event of a flood.
  • The City has been dragging their feet on the project and now the citizens are paying for that.
A written comment card in opposition of changes to stormwater fees was submitted by Joe Galli.
 
Councilmember Barotz stated that putting this off only makes the City more vulnerable and if ACE does not come through the money will be needed more than ever to complete the project without them.
 
Mayor Evans agreed and offered that there is a billion-dollar issue right in the middle of the city that needs to be addressed with or without ACE and the City needs the funding to address it.

Councilmember Overton agreed that the project is a top priority and the City is at capacity. He is advocating for looking at a flat tax and using that revenue for bonding to show ACE that a plan is in place. Without 100% plans he is not comfortable charging the citizens for something that is still unknown.
 
Councilmember Odegaard offered that he believes the City is at a crossroads with ACE committing to begin construction by 2020. He expressed support for revenue bonds that are paid for by the stormwater fee. He acknowledged that it is an increase, but it is one where the community will see a physical impact in the City.
 
Councilmember McCarthy stated that he is supportive of the 25-year bonding option.
 
Mayor Evans asked if it would be possible to adopt the ordinance and delay the collection of fees until July 2019 to see if ACE will deliver as promised. Mr. Tadder explained that it is an option should a majority of Council be supportive.
 
There being no further public comment Mayor Evans closed the Public Hearing.
 
Councilmember Putzova stated that the stormwater fee must be part of the solution because it is the impervious surfaces that are contributing to the issue.
 
  Moved by Councilmember Charlie Odegaard, seconded by Councilmember Jim McCarthy to read Ordinance 2018-40 by title for the first time with the debt financed option.
  Moved by Mayor Coral J. Evans, seconded by Councilmember Scott Overton to amend the motion to have a start time of July 1, 2019 and reserve the option to bring the ordinance back in case the Army Corp of Engineers does not meet the first deadline.

Councilmember Putzova stated that the proposed rate per ERU is regardless of the size of the surface; she asked why a tiered approach has not been pursued based on the side of the property. Ms. Goodrich explained that for the City to provide a tiered rate for a particular user it has to show a direct impact to some part of the infrastructure. For example, if the City had to put in larger storm sewer drains for a big box store because of the water that comes off the surface of that property versus a neighborhood which does not need as large of a drain, then there would be a clear nexus to create tiered rates. However, there is no variation in the infrastructure needed regardless of the size of the surface. Mr. Solomon added that stormwater rates have to be standard across the board; if they are not, the rates can be considered an arbitrary fee.
  Vote: 5 - 2
 
NAY: Councilmember Charlie Odegaard
  Councilmember Jim McCarthy
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE MAYOR AND COUNCIL OF THE CITY OF FLAGSTAFF, ARIZONA AMENDING THE FLAGSTAFF CITY CODE, TITLE 12, FLOODPLAINS, CHAPTER 12-02, STORMWATER MANAGEMENT UTILITY, BY AMENDING THE SCHEDULE OF STORMWATER MANAGEMENT UTILITY SERVICE CHARGES AND FEES; PROVIDING FOR REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, PENALTIES, AND ESTABLISHING AN EFFECTIVE DATE.

A break was held from 7:51 p.m. through 8:05 p.m.
 


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_minutes_popup.cfm
Time Stamp 28-Mar-24 11:04 PM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
109 ms 109 ms 1 top level D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 16 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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 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 @ 23:04:54.054
			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 @ 23:04:54.054
				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 @ 23:04:54.054
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
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) = 393

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:04:54.054
		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) = 787

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:04:54.054
			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(787 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 @ 23:04:54.054
	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 @ 23:04:54.054
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 393

getLines (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
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 = 786 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) = 393
Parameter #2(cf_sql_integer) = 8579

getMinutes (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
	SELECT meet_minutes, ln_rowid, seq_num, time_of_vote, _rowid,
			text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 393 AND
		  rev_num = 0 AND
		  ln_rowid = 8579 AND
		  meet_minutes IS NOT NULL
getMotions (Datasource=frsRO, Time=16ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
	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 = 393 AND
		  motion.rev_num = 0 AND
		  motion.ln_rowid = 8579 AND
		  motion.motion_status <> 'VERBIAGE'
	ORDER BY motion.motion_seq
getVotes (Datasource=frsRO, Time=15ms, Records=14) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
	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 = 393 AND
		  v.rev_num = 0 ANd
		  v.ln_rowid = 8579 
	ORDER BY sort2, sort1						
	
SortedList (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_min_print.cfm @ 23:04:54.054
	SELECT * from sortList
	ORDER BY seqNum
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 6117 
getMotion (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
				    	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 = 2092 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 8579 AND
						      motion_seq = 2 
getMotionVote (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 8579 AND
							  getVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:04:54.054
	
		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 @ 23:04:54.054
				    	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 = 2147 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 8579 AND
						      motion_seq = 3 
getMotionVote (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 8579 AND
							  getVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:04:54.054
	
		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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:04:54.054
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotion (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
				    	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 = 2148 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 8579 AND
						      motion_seq = 4 
getMotionVote (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 8579 AND
							  getVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:04:54.054
	
		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 @ 23:04:54.054
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 23:04:54.054
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 6119 


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=393&ln=8579&reloaded=false
HTTP_USER_AGENT=claudebot
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm
QUERY_STRING=seq=393&ln=8579&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=8640202
cftoken=38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
hitcount=2
lastvisit={ts '2024-03-28 23:04:54'}
timecreated={ts '2024-03-28 23:04:54'}
urltoken=CFID=8640202&CFTOKEN=38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
Cookie Variables:
CFID=8640202
CFTOKEN=38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
Session Variables:
cfid=8640202
cftoken=38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8640202_38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
subdir=/public/
tzoffset=0
urltoken=CFID=8640202&CFTOKEN=38cd191f7146a9fe-580C851B-B28C-7F82-35714A95EC83B6F2
URL Parameters:
ln=8579
reloaded=false
seq=393
Debug Rendering Time: 0 ms