Minutes

             
E Consideration and Adoption of Resolution No. 2019-21:  A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement Between the State of Arizona Department of Revenue and City of Flagstaff for local tax administration; providing for expiration of the existing agreement; and establishing an effective date.         
 
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Charlie Odegaard to read Resolution No. 2019-21 by title only.
  Vote: 6 - 0 - Unanimously
  A RESOLUTION OF THE FLAGSTAFF CITY COUNCIL, APPROVING AN INTERGOVERNMENTAL AGREEMENT BETWEEN THE STATE OF ARIZONA AND THE CITY OF FLAGSTAFF FOR LOCAL TAX ADMINISTRATION; PROVIDING FOR EXPIRATION OF THE EXISTING AGREEMENT; AND ESTABLISHING AN EFFECTIVE DATE
 
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Charlie Odegaard to adopt Resolution No. 2019-21.
  Vote: 6 - 0 - Unanimously


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_minutes_popup.cfm
Time Stamp 18-Mar-24 08:45 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
93 ms 93 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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
93 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 @ 20:45:30.030
			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 @ 20:45:30.030
				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 @ 20:45:30.030
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 20:45:30.030
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) = 430

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

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 20:45:30.030
			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(886 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 @ 20:45:30.030
	SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 20:45:30.030
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 430

getLines (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 20:45:30.030
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 = 885 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) = 430
Parameter #2(cf_sql_integer) = 9477

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


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=430&ln=9477&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=430&ln=9477&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=8412869
cftoken=7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
hitcount=2
lastvisit={ts '2024-03-18 20:45:30'}
timecreated={ts '2024-03-18 20:45:30'}
urltoken=CFID=8412869&CFTOKEN=7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
Cookie Variables:
CFID=8412869
CFTOKEN=7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
Session Variables:
cfid=8412869
cftoken=7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8412869_7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
subdir=/public/
tzoffset=0
urltoken=CFID=8412869&CFTOKEN=7787170986b54381-501B4278-D22B-9E25-43F30A6FEB6F734E
URL Parameters:
ln=9477
reloaded=false
seq=430
Debug Rendering Time: 0 ms