Printed Agenda

REGULAR COUNCIL MEETING
TUESDAY
SEPTEMBER 21, 2021

COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
3:00 P.M.

ATTENTION

IN-PERSON AUDIENCES AT CITY COUNCIL MEETINGS HAVE RESUMED WITH LIMITED CAPACITY

The meetings will continue to be live streamed on the city's website (https://www.flagstaff.az.gov/1461/Streaming-City-Council-Meetings)

***PUBLIC COMMENT***

WE ARE NO LONGER USING TELEPHONE COMMENTS

All verbal public comments will be given through a virtual public comment platform

If you want to provide a verbal comment during the Council Meeting, use the link below to join the virtual public comment room.

VIRTUAL PUBLIC COMMENT WAITING ROOM

Written comments may be submitted to publiccomment@flagstaffaz.gov. All comments submitted via email will be considered written comments and will be documented into the record as such.

AGENDA
A M E N D E D


1.					CALL TO ORDER NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this regular meeting, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).

ROLL CALL

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.

MAYOR DEASY
VICE MAYOR DAGGETT
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY

COUNCILMEMBER SALAS
COUNCILMEMBER SHIMONI
COUNCILMEMBER SWEET

PLEDGE OF ALLEGIANCE AND MISSION STATEMENT

MISSION STATEMENT

The mission of the City of Flagstaff is to protect and enhance the quality of life for all.

PUBLIC PARTICIPATION

Public Participation enables the public to address the Council about an item that is not on the agenda. Comments relating to items that are on the agenda will be taken at the time that the item is discussed. If you wish to address the Council at tonight's meeting, please complete a comment card and submit it to the recording clerk as soon as possible. Your name will be called when it is your turn to speak. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.

PROCLAMATIONS AND RECOGNITIONS

Proclamation: Adult Education and Family Literacy Week

Proclamation: Flagstaff Symphony Orchestra 72^nd Season

CITY MANAGER REPORT

City Manager Report

STAFF RECOMMENDED ACTION:

Information Only

COUNCIL LIAISON REPORTS AND INFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF

I~~NFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF, FUTURE AGENDA ITEM REQUESTS~~


9.		COVID-19 UPDATE

	A.	COVID-19 Update

		STAFF RECOMMENDED ACTION:
		This presentation is for informational purposes only.

10.		LIQUOR LICENSE PUBLIC HEARINGS

	A.	Consideration and Action on Liquor License Application: Bryan James Lubbehusen, "Square Root Foods," 2223 E. 7th Avenue, Series 10 (beer and wine store), New License.

		STAFF RECOMMENDED ACTION:
		Hold the public hearing. The City Council has the option to: (1) Forward the application to the State with a recommendation for approval; (2) Forward the application to the State with a recommendation for denial based on information from staff, the testimony received at the public hearing and/or other factors.

	B.	Consideration and Action on Liquor License Application: Ryan Witner Anderson, "Target," 1650 S. Milton Road, Series 09 (liquor store - all spirituous liquor), New Application.

		STAFF RECOMMENDED ACTION:
		Hold the public hearing. The City Council has the option to: (1) Forward the application to the State with a recommendation for approval; (2) Forward the application to the State with a recommendation for denial based on information from staff, the testimony received at the public hearing and/or other factors.

11.		ROUTINE ITEMS

	A.	Recognition of Bus Art Winners and Ratification: Beautification and Public Art Commission recommendations for Bus Art Project on Climate Change and Hope

		STAFF RECOMMENDED ACTION:
		Ratify the contracts awarded by the Beautification and Public Arts Commission related to a bus art project on climate change and hope.

	B.	Update and Review: Working Calendar and Future Agenda Item Requests

12.		REGULAR AGENDA

	A.	Consideration and Adoption of Ordinance No. 2021-22: An ordinance of the City Council of the City of Flagstaff clarifying the duties of the Beautification and Public Art Commission, and clarifying that the Procurement Code Manual procedures apply to expenditures for Arts and Sciences and Beautification funds; providing for repeal of conflicting ordinances, severability, and establishing an effective date.

		STAFF RECOMMENDED ACTION:
		At the September 21, 2021 Council Meeting: 1) Read Ordinance No. 2021-22 by title only for the first time 2) City Clerk reads Ordinance No. 2021-22 by title only (if approved above) At the October 5, 2021 Council Meeting: 3) Read Ordinance No. 2021-22 by title only for the final time 4) City Clerk reads Ordinance No. 2021-22 by title only (if approved above) 5) Adopt Ordinance No. 2021-22

	B.	Consideration and Adoption of Resolution No. 2021-43 and Ordinance No. 2021-21: A resolution of the Flagstaff City Council declaring as a public record that certain document filed with the City Clerk and entitled "Nuisance Noise Code Amendments;" and an ordinance of the City Council of the City of Flagstaff, amending the Flagstaff City Code, Title 6, Police Regulations, Chapter 6-08, Noise Control, by adopting by reference that certain document entitled "Nuisance Noise Code Amendments;" providing for penalties, repeal of conflicting ordinances, severability, and establishing an effective date

		STAFF RECOMMENDED ACTION:
		At the September 21, 2021 Council Meeting: 1) Read Resolution No. 2021-43 by title only 2) City Clerk Reads Resolution No. 2021-43 by title only (if approved above) 3) Read Ordinance No. 2021-21 by title only for the first time 4) City Clerk reads Ordinance No. 2021-21 by title only (if approved above) At the October 2, 2021 Council Meeting: 5) Adopt Resolution No. 2021-43 6) Read Ordinance No. 2021-21 by title only for the final time 7) City Clerk reads Ordinance No. 2021-21 by title only (if approved above) 8) Adopt Ordinance No. 2021-21

13.		DISCUSSION ITEMS

	A.	Lone Tree Overpass Project Update

		STAFF RECOMMENDED ACTION:
		Present a design update to City Council for the Lone Tree Overpass Project and facilitate discussion.

	B.	Public Release of Draft Active Transportation Master Plan

		STAFF RECOMMENDED ACTION:
		Information and discussion only; no Council action required

	C.	Discussion of Letter Regarding 4FRI RFP Cancellation

		STAFF RECOMMENDED ACTION:
		Discussion and possible direction.


14.		FUTURE AGENDA ITEM REQUESTS After discussion and upon agreement by three members of the Council, an item will be moved to a regularly-scheduled Council meeting.

	A.	Future Agenda Item Request (F.A.I.R.) A Citizens' Petition seeking to "designate that Woody Way Traffic is a one-way street westbound only. Allowing for emergency vehicle access."

		STAFF RECOMMENDED ACTION:
		Council direction.

15.		~~INFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF,~~ CITY COUNCIL REQUESTS FOR FUTURE AGENDA ITEMS

16.		ADJOURNMENT

CERTIFICATE OF POSTING OF NOTICE

The undersigned hereby certifies that a copy of the foregoing notice was duly posted at Flagstaff City Hall on                      , at                a.m./p.m. in accordance with the statement filed by the City Council with the City Clerk.

Dated this               day of                                       , 2021.

__________________________________________
Stacy Saltzburg, MMC, City Clerk

Debugging Information

ColdFusion Server Standard	2016,0,16,320445
Template	/print_agenda.cfm
Time Stamp	20-May-24 01:27 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
188 ms	188 ms	1	D:\inetpub\PublicPages\print_agenda.cfm
94 ms	94 ms	1	D:/inetpub/PublicPages/public/publish/print_agenda_dsp.cfm
31 ms	31 ms	1	CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc \| qryAgLines(1326) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms	1 ms	11	D:/inetpub/PublicPages/public/publish/print_agenda_ud_load.cfm
0 ms	0 ms	1	CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc \| fGetAGPaddingOptions([complex value], YES, AGPad) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms	0 ms	1	CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc \| qryAgenda(1326, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
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	11	D:/inetpub/PublicPages/public/publish/print_agenda_ud.cfm
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 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 @ 13:27:46.046

			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 @ 13:27:46.046

				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'

all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	SELECT code_type FROM user_define

all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, dataSortOrder as sort_order,

		   c.misc_alpha2,
 		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26','AG TIME')
	AND (opt_form_id = '' OR opt_form_id IS NULL)

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:27:46.046

			select top 1 * from codes

qryResults (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 13:27:46.046

	SELECT fas.form_num fas_form_num, fas.rev_num fas_rev_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, fas.form_num ag_num,
		   ft.* ,
		   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id, mt.meeting_type,
		   agt.ag_template_name, agt.ag_template_id, agt.ag_item_rowid, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   form_hist.stat_date as bo_date,
	 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo,
	 	   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_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, 
	 	   	  c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all
	 	   
	 	   ,c2.misc_alpha2 level_descriptor, c3.descr custom_print_routine_name
	FROM fas
	INNER JOIN agenda AS ft ON (ft.form_num = fas.form_num)
	INNER JOIN form_hist ON (form_hist.form_id = fas.form_id AND
				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 AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = m.meeting_id)	
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = m.the_meeting_type)
	LEFT OUTER JOIN codes AS c3 ON (c3._rowid = ft.custom_print_routine)
	WHERE fas.form_id = 'AGENDA' AND
		  fas.form_num = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1326

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:27:46.046

		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) = 1327

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

		SELECT valid_code, descr, long_descr from codes
		WHERE code_type = 'AG_FONT'

getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'

checkField (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 13:27:46.046

		SELECT * from agenda_ln WHERE _rowid > 1 and _rowid < 5

final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 13:27:46.046

		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1326

qryResults (Datasource=frsRO, Time=31ms, Records=32) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 13:27:46.046

	SELECT al._rowid ln_rowid, al.form_num, al.seq_num,  al.alt_ai_num, 
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.header_ln, al.footer_ln, al.page_br,	
		   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,
		   al.video_link,
		   ai.*,

		   am.ag_item_rowid, am.prt_exp_agenda, am.submitted_for, am.submitted_for_more, c1.descr ag_time_descr,
		   CASE WHEN al.header_ln = 'Y' THEN 1
		   		WHEN al.footer_ln = 'Y' THEN 3
		   		ELSE 2 END AS line_sort,
		   
		   as1.sort_seq sort_level1,
		   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.alt_ai_num IS NOT NULL then al.alt_ai_num 
		   		WHEN am.ainumber = '' then '-1'
				WHEN am.ainumber = '0' then '-1'
				WHEN am.ainumber IS NULL then '-1'
		   ELSE am.ainumber END AS sort_memo2,		   
		   
		   al.ag_size, al.ag_font, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
		   am.allow_comment, am.ainumber, al.ag_memo_id, al.ag_memo_rev, al.ag_line_status, c.descr status_desc, al.ag_subject, al.ag_title ag_heading,
		   al.left_justify, al.color_impact,
		   al.ag_area, aa.descr ag_area_desc, al.ag_subarea, asa.descr ag_subarea_desc, 
		   codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,	   
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_action ELSE al.ag_action END as ag_action,
		   fu1.text_value skipAIprint
	FROM agenda_ln al
	INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
	INNER JOIN meetings m ON (m.meeting_id = a.meeting_id)	
	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 ss_ag_item AS ai ON (ai.form_num = al.form_num AND ai._rowid = am.ag_item_rowid)
	
	LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = m.the_meeting_type AND aa.ag_area = al.ag_area and aa.obsolete <> 'Y')          
	LEFT OUTER JOIN area_subarea AS asa ON (asa.meeting_type = m.the_meeting_type AND asa.ag_area = al.ag_area and asa.ag_subarea = al.ag_subarea and asa.obsolete <> 'Y')
	LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = al.ag_line_status)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = al.ag_size)
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
	LEFT OUTER JOIN form_userdef AS fu1 ON (fu1.form_id = 'AG_MEMO' AND fu1.form_num = al.ag_memo_id AND fu1.rev_num = al.ag_memo_rev AND fu1.fld_label = 'Skip Printing AB#' and fu1.text_value = 'Y')
	
	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)))
	WHERE al.form_num = ?
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1326

getAgHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	select * from getAgLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4

getAgFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4

getAgLines (Datasource=, Time=0ms, Records=30) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	select * from getAgLines where header_ln <> 'Y' and footer_ln <> 'Y'
	order by line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo

getorig (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 13:27:46.046

	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle
	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) = 'AGENDA' AND form_num = 1326
	AND stat_action = 'ADD'

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:27:46.046

			select top 1 * from codes

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 13:27:46.046

			select c.misc_alpha aHead_pad, c.misc_alpha2 aBody_pad, c.misc_alpha3 aAGItems_pad
			from codes c 
			where c.code_type = ? and 
			     c.valid_code = CAST(1327 as varchar)

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = AGPad

AQLogo (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

		SELECT printed_logo, logo_plcmnt FROM getform

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5886 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5886 AND
			rev_num = 0
		order by au.seq_num

items (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5895 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5895 AND
			rev_num = 0
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5857 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 85 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5857 AND
			rev_num = 1
		order by au.seq_num

items (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5858 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 85 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5858 AND
			rev_num = 1
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5843 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5843 AND
			rev_num = 1
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5883 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 86 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5883 AND
			rev_num = 0
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5837 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 86 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5837 AND
			rev_num = 1
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5846 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5846 AND
			rev_num = 1
		order by au.seq_num

items (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5859 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5859 AND
			rev_num = 0
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5891 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5891 AND
			rev_num = 0
		order by au.seq_num

items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 13:27:46.046

				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 5880 AND rev_num = 1 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num

getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 13:27:46.046

		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 82 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 5880 AND
			rev_num = 1
		order by au.seq_num

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\print_agenda.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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFTOKEN=2d9bfd4929bd655f%2DEC9B0E06%2DE053%2D8074%2D7D62E9B58F73AEBE; CFID=9930157
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//print_agenda.cfm?id=0&reloaded=true&seq=1326
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\print_agenda.cfm
QUERY_STRING=id=0&reloaded=true&seq=1326
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/print_agenda.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=9930157
cftoken=2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE
hitcount=55
lastvisit={ts '2024-05-20 13:27:46'}
timecreated={ts '2024-05-20 13:27:31'}
urltoken=CFID=9930157&CFTOKEN=2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE

Cookie Variables:
CFID=9930157
CFTOKEN=2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE

Session Variables:
ailist=Query (18)
cfid=9930157
cftoken=2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9930157_2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE
subdir=/public/
tzoffset=0
urltoken=CFID=9930157&CFTOKEN=2d9bfd4929bd655f-EC9B0E06-E053-8074-7D62E9B58F73AEBE

URL Parameters:
id=0
reloaded=true
seq=1326

Debug Rendering Time: 0 ms