Return
JOINT FLAGSTAFF CITY COUNCIL/CHAMBER OF COMMERCE
WORK SESSION
MONDAY, DECEMBER 9, 2019
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
             
1. Call to Order

Mayor Evans called the Joint City/Greater Flagstaff Chamber of Commerce held December 9, 2019, to order at 6:01 p.m.
             
2.
Pledge of Allegiance and Mission Statement

The Council and audience recited the pledge of allegiance and Vice Mayor Shimoni read the Mission Statement of the City of Flagstaff.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
ABSENT:









PRESENT:

PRESIDENT/CEO JULIE PASTRICK
CHAIRWOMAN BRENDA HAZLETT
MEMBER GUILLERMO CORTES
MEMBER ROBBY FINDLAY
MEMBER RON GETTO
MEMBER FLO SPYROW
ABSENT:

VICE CHAIRMAN MARK LOVE






             
4. Public Participation:

Public Participation enables the public to address the Council about an items that the agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment on an item that is on the agenda is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. 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.

None
             
5. Healthcare Industry
  Ms. Pastrick introduced Chamber Board Member and President and CEO of Northern Arizona Flo Spyrow who provided a PowerPoint presentation that covered the following:
 
OVERVIEW
INTRODUCTION: FLO SPYROW
NORTHERN ARIZONA HEALTHCARE
THE NEW ERA
NAH SYSTEM
CARE CLOSE TO HOME
HALLIE MUELLER
NICOLE ZYGADLO
OUR DIRECTION
OUR NORTH STAR
VALUES
OUR JOURNEY IS OUR MISSION
HEALTHCARE FOR TODAY AND THE FUTURE
            AMBULATORY CAMPUS
            FLEXIBILITY FOR FUTURE GROWTH AND CONTRACTION
            WELLNESS
OUR IMPACT
COMMUNITY IMPACT
WORKFORCE
IMPORTANT WORK AHEAD
COMPETITION IS ON THE RISE
FUTURE NEEDS ARE CLEAR
FMC VISION
AMAZING CARE AT AN AFFORDABLE COST
AREAS OF FOCUS
DESIGNING NORTHERN ARIZONA’S’ HEALTHCARE EXPERIENCE OF THE FUTURE
OUR PARTNERSHIP
BUILDING A ROBUST COMMUNITY…TOGETHER
WE COMMIT TO YOU
YOUR PARTNERSHIP IS CRITICAL
 
Vice Mayor Shimoni asked how technology is being used for hard to reach populations. Ms. Spyrow stated that there are telehealth monitors situated throughout the reservations and rural areas. The biggest challenge is lack of broadband access and limited vendors who know the equipment. They are looking at different grant opportunities to expand broadband and enhance the services.
 
Vice Mayor Shimoni asked about outreach for accessibility and cost of services. Ms. Spyrow noted that there are a number of technologies where people can assess elective procedures based on their insurance. They are developing an ambulatory platform will help with increased affordability. They are working to provide more opportunities that reduce the cost of healthcare for patients now and in the future.
 
Councilmember Aslan noted the growth being experienced in the Verde Valley. Ms. Spyrow agreed and stated that they are watching things closely and looking at ways to expand.
 
Councilmember Salas asked about attracting physicians to the area. Ms. Spyow stated that as they recruit physicians and executives, they want to offer good education systems, quality retail, economic opportunity, and quality community.
 
Mayor Evans asked about residency programs. Ms. Spyrow indicated that physicians tend to stay where they are trained so residency programs are important. There is a residency program for internal medicine in Cottonwood and they try to retain at least 25% of residents. North Country Healthcare has recently been approved for a residency program which will allow training at Flagstaff Medical Center. They also have surgical residents in the trauma program and they are looking to expand into other specialty areas for residency. An area of need in Flagstaff is mental health and there is movement to establish clinical opportunities to support the growing need.
 
Ms. Spyrow spoke briefly about upcoming expansion opportunities and a new healthcare campus.
 
Council expressed gratitude to Ms. Spyrow for her presentation and for the work of North Country Healthcare.
             
6. Transportation, Infrastructure, Technology and Economic Indicators
  Ms. Patrick introduced Board Member Robby Findlay, Co-owner of Findlay Automotive. Mr. Findlay stated that Findlay Automotive strives to be the best place to work, buy a car, service a car, and serve the community. Since the recession, they have consistently sold over 100 Toyotas a month in addition to used cars. The car business has flattened and is currently trending downward. There are many things that are contributing to this but he is mostly concerned with what is happening locally. Generally, they are doing well in other cities and states but in Flagstaff they we are seeing downward trends in sales, they are down in employee count, and up in payroll. They would like to see the community be more business friendly and they want to be there to help. The sales tax rate is a component; they can compete on the sales price but sales tax is high and has no ability to negotiate. Minimum wage is another contributing factor along with the cost of housing.
 
Councilmember Aslan left the meeting at 6:56 p.m.
 
Mayor Evans acknowledged the challenge with minimum wage but explained that as a voter approved initiative the Council’s hands are tied with no ability to make adjustments. Many of the sales tax components are also voter driven to pay for various bond projects. There are things that can be done better but it is also a nexus with community desire for things that cost money.
 
Councilmember McCarthy indicated that he often hears about how difficult it is to build in Flagstaff. There are terrain challenges with hills and rocky terrains, and they have heard about how long it takes to get through the process. There is no solution to the slope of land and the rock and they are working to refine the internal process.
 
Ms. Pastrick stated that most of what they are hearing is about the permitting process and they would like to see an attempt to develop a fast track permitting process so the carrying costs of the developer can be reduced.
 
Ms. Pastrick introduced Board Member and Owner of Starlite Bowling Alley Ron Getto. Mr. Getto stated that after the second election to increase the minimum wage he decided to immediately go to the $15 per hour. This has come with clear repercussions; his labor costs have gone up by about $50,000 per year and as a result, hours had to be reduced, so while employees are being paid more they are working less hours. They have also had to make adjustments to the overall customer experience; they are not open for lunch two days a week and the bar is not staffed until 3:00 p.m., and at some point they will have to raise prices and pass the cost on the customer. The community made the decision to raise the minimum wage and they will ultimately need to bear some of the costs of that decision. He stated that there are many local governments who have offered tax credits to small businesses who are doing the right thing.
 
Council expressed their concerns with the minimum wage as well, including the assessment from the State of Arizona to cover the difference between the state and local minimum wage for services provided by the state. They also indicated that there is more than wages that impact the cost of living and running a small business such as the cost of housing and healthcare. All of these things together are what makes it difficult to live and work. They also discussed the minimum wage impact study and how they hope it will provide insight into the matter.
 
Ms. Pastrick introduced Board Member and Key Engineering Partner of Shepard Wesnitzer Inc. (SWI), Guillermo Cortes. Mr. Cortes reported on a couple of recent projects. He indicated that there are 27 employees with SWI with 13 being located in Flagstaff. He is also involved with Kick Stand Café so he understands the impacts of the minimum wage and having to raise prices. He explained that transportation and infrastructure can be very costly for industry coming into town; people want to come into areas with established infrastructure. He acknowledged Propositions 419 and 420 and the important projects they are supporting. When developers come to Flagstaff and ask to rezone a parcel it is the unknown of the offsite infrastructure that they will be required to provide that can bring the cost up. What it takes to go through a site rezone or a direct rezone is challenging and they take time. One of the bigger issues is the amount of engineering studies that have to be performed; they are costly and take time to complete. Being open to partnerships and how the city can partner on infrastructure projects can help a development move forward and be successful.
 
Ms. Spyrow added that with the new healthcare facility, they are being told it could be two years before a shovel can go into the ground. This is difficult and in addition to the time it will take they are faced with having to build roads and bring in infrastructure; this means millions have to be put into the facility that would not otherwise be required in other cities.
 
Mr. Cortes stated that Community Development Director Dan Folke has been holding meetings with developers to discuss concerns, brainstorm possible solutions, and get a general understanding of how to try and address the concerns. Increasing communication is very much appreciated and shows a willingness to hear and consider the concerns.
 
There was brief discussion about the Flagstaff Local movement and the various things the city is doing to increase economic development and bring people to the community.
 
Three takeaways from the meeting were the following:
  1. Strengthening workforce development and talent pipeline with regard to healthcare and automotive services. This should include middle and high school students.
  2. Explore ways to incentivize programs, activities, and tax credits that can be extended to local businesses.
  3. Strengthen the commitment to infrastructure and transportation and seize the opportunities for public/private partnerships when new development comes in.
Mayor Evans indicated that a work session is forthcoming to have a presentation on the results of the minimum wage study and it would be nice to include a conversation about doing a tax credit for small businesses and what that might look like. Mr. Clifton stated that it is quite relevant to the conversation and they can start the discussion with the consultant in January.
 
Mayor Evans also requested a work session to discuss transportation and infrastructure as well as to discuss the permitting process. Mr. Folke stated that a work session presentation on impact fees is coming to Council on January 7, 2020 to discuss the renewal of the police and fire impact fees as well as other possible impact fees for roads, parks, and other infrastructure.
             
7. Informational Items To/From Flagstaff Chamber, Mayor, Council and City Manager
  Councilmember Salas stated that she would like to look into opportunities for a transition program, there are state and federal dollars to utilize and it would be helpful to understand how the programs work. She thanked the Chamber for their participation in the meeting.
 
Councilmember Odegaard thanked the Chamber for their participation and appreciation for the conversations.
 
Mr. Cortes thanked the Council for hosting them and the opportunity for discussion.
 
Councilmember McCarthy thanked everyone for participating and noted the good relationships that are built through communication.
 
Mr. Findlay noted that when talking about tax rebates for small businesses the automotive sector needs something to take away the competitive disadvantage they have with other municipalities.
 
Vice Mayor Shimoni thanked the Chamber for attending and for the work they do in the community. He encouraged everyone to sign up and participate in the Flagstaff Local movement.
 
Ms. Spyrow thanked the Council for the candid and honest conversations to discuss challenges and opportunities.
 
Councilmember Whelan expressed appreciation for the conversations and willingness to work together. She indicated a desire to meet more frequently with the Chamber to continue conversations.
 
Mr. Getto thanked the Council for hosting and listening to their viewpoints. He is excited about the future of the bowling alley and supporting the community.
 
Ms. Patrick thanked everyone for their time and participation and openness to conversations about how to make Flagstaff the best it can be.
 
Mayor Evans thanked everyone for their participation and stated that she is looking forward to future conversations.
             
8. Public Participation
  Economic Development Director Heidi Hansen offered congratulations to Business Attraction Manager Gail Jackson on her new position of leading ECONA as the Interim CEO.
             
9. Adjournment

The Joint Meeting of the Flagstaff City Council and Greater Flagstaff Chamber of Commerce held December 9, 2019, adjourned at 8:46 p.m.
 
                  
___________________________________
MAYOR
  ATTEST:

 
 
  _________________________________
CITY CLERK
 

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 05-May-24 11:59 AM
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
203 ms 203 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 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/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
218 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 @ 11:59:19.019
			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 @ 11:59:19.019
				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'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:59:19.019
			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 @ 11:59:19.019
				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'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:59:19.019
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:59:19.019
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:59:19.019
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=15ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR 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')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:59:19.019
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2019-12-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2019-12-31 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:59:19.019
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=63ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
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.date_final, fas.final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc,
	   agt.ag_template_name, agt.ag_template_id,
	   codes.long_descr px_size, codes.descr pdf_format, 
	   mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type,
 	   agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place
FROM minutes ft
INNER JOIN fas ON (fas.form_id = 'MINUTES' AND fas.form_num = ft.form_num AND fas.rev_num = ft.rev_num)
INNER JOIN form_hist ON (UPPER(form_hist.form_id) = fas.form_id AND
			UPPER(form_hist.stat_action) = 'ADD' AND
			form_hist.form_num = fas.form_num)
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 crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE ft.meeting_id = 945 
get_temp_vars (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:59:19.019
		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) = 945

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 11:59:19.019
			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(945 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\agpub_min_dsp.cfm @ 11:59:19.019
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 944 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
SELECT ml._rowid ln_rowid, ml.ln_rowid ml_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.footer_ln, ml.left_justify, ml.page_br,		
	   c.descr as status_desc,
	   
	   
	   ai.*,
	   
	   am.ag_item_rowid,
	   
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.left_justify,		
	   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_title ELSE '' END as ag_title,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action
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 = 944 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 = 474 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
	       
				'Y' can_look, 'Y' can_link	
			
			,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid,
			min.minutes_published min_published,
			a.agenda_published ag_published
	FROM minutes min
	INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num)
	INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND
		  							   docs.rev_num = ml.rev_num AND
		  							   docs.ln_rowid = ml._rowid
		  							
		  								AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
		  							)
	LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num)
	WHERE min.form_num = 474 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 474 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10616 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10619 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10614 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10615 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10623 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9571 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10622 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9574 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10620 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9577 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10617 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9580 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 10618 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:59:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:59:19.019
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:59:19.019
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:59:19.019
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:59:19.019
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


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\agenda_publish.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=//agenda_publish.cfm?id=&mt=ALL&get_month=12&get_year=2019&dsp=min&seq=945
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\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=12&get_year=2019&dsp=min&seq=945
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.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=9535305
cftoken=32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
hitcount=4
lastvisit={ts '2024-05-05 11:59:19'}
timecreated={ts '2024-05-05 11:59:19'}
urltoken=CFID=9535305&CFTOKEN=32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
Cookie Variables:
CFID=9535305
CFTOKEN=32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=945
Session Variables:
cfid=9535305
cftoken=32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9535305_32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
subdir=/public/
tzoffset=0
urltoken=CFID=9535305&CFTOKEN=32fac92de7106cd7-E50A347B-B3EE-39FB-8229901E2BDE349C
URL Parameters:
dsp=min
get_month=12
get_year=2019
id=
mt=ALL
seq=945
Debug Rendering Time: 0 ms