Return
 
    INDIGENOUS COMMISSION
REGULAR VIRTUAL TEAMS MEETING
211 WEST ASPEN AVENUE
             WEDNESDAY, 
FEBRUARY 01, 2023,
 12:00 P.M.
             
1. Call to Order

Co-chair Washington called the meeting to order at 12:03 PM.
             
2. Roll Call
NOTE: One or more Commission Members may be in attendance telephonically or by other technological means.
Diana Cudeii, Ex-Officio; Present
Seat Vacant, Ex-Officio
Seat Vacant, Ex-Officio
Cora M. Phillips; Excused Absence
Joe. W. Washington, Co-Chair; Present
Darrell Marks; Present
Fawn Toya, Co-Chair; Present
Kiara Weathersby; Present
Shawna Whitehat; Excused Absence
Jonathan Yellowhair; Present

Others present: Staff Liaison Rose Toehe; Council Liaison Councilmember Lori Matthews; City Manager Greg Clifton presenter; Mayor Becky Daggett; Water Services Brad Hill presenter; Water Services staff Erin Young; Cheyenne Grabiec, public; DeAnn Wegert, CODA; Jean Toner, CODA; Jenna Ortega, Sustainability; Savannah Reuille, public.
             
A.
Land Acknowledgment

The Flagstaff City Council humbly acknowledges the ancestral homelands of this area’s Indigenous nations and original stewards. These lands, still inhabited by Native descendants, border mountains sacred to Indigenous peoples. We honor them, their legacies, their traditions, and their continued contributions. We celebrate their past, present, and future generations who will forever know this place as home.
             
3. Public Comment
At this time, any member of the public may address the Commission on any subject within their jurisdiction that is not scheduled before the Commission on that day. Due to Open Meeting Laws, the Commission cannot discuss or act on items presented during this portion of the agenda. To address the Commission on an item that is on the agenda, please wait for the Chair to call for Public Comment at the time the item is heard. (Five minutes maximum per person)

None at this time.
             
4. APPROVAL OF MINUTES
             
A. Approval of Minutes for January 4, 2023
Motion to approve Minutes as is or approve with amendments.

Co-chair Toya made a motion to approve Minutes as is. Co-chair Washington seconded. It was passed unanimously.
             
5. GENERAL BUSINESS/POSSIBLE VOTE

None at this time.
             
6. DISCUSSION ITEMS
             
A. Water Discussion with City Manager and staff from Water Services
City Manager Greg Clifton and Water Services staff will give an overview of the current review and approval process for contracts and agreements involving reclaimed water. This is in response to a request made by the members of the Indigenous Commission during the June 1, 2022 regular meeting.

City Manager Clifton and Water Services Interim Director Brad Hill provided presentation regarding reclaimed water. Regarding Contracts and Agreements, Mr. Hill explained that there are two overarching documents that guide city staff and City Council. Both are approved by City Council. The first one is city code and it's various elements. Another one that may not be quite familiar, but also adopted by City Council. On reclaim water agreements, the City has not created a new water customer. Therefore, there has not been a new water reclaimed water agreement since December of 2012, ten years ago. The reason being is that until there is some pieces of infrastructure in place in the reclaim water system, there is not the volume of water, at least in the summer time, to allow for the addition of new customers. It would be different if there's a customer that wants to use the water during a different time, the city would consider it. Typically water use is wanted during the summer and there is no excess water in the summer. That is why there are no new customers in the past 10 years.

Commissioner Marks pointed out and asked questions pertaining to caps/limitations as to how much water is distributed to any one organization (whether leasing or buying the water); What considerations are made for climate change since 2012; and what is considered differently in the way water is being utilized, specifically to Native Americans' consideration around the environment in our area? Are there opportunities for some of that decision making to come back to City Council so there's more transparency and for more communities, including Indigenous, to be informed and voice how that water is being used?

Mr. Hill stated that in order to service all existing customers, the City began capping usage, so now all of the reclaimed agreements have a monthly and an annual cap. Water conservation programs are implemented indoors, like low flow toilets, shower heads, etc. Water use indoors typically doesn't change, even if it might get super hot during a seasonal month or climate change over time. As compared to outdoor water usage, that changes over time. In terms of the decision making, from the staff side, there is planning in terms of future water, whether water conservation, water resource planning, quantifying the how the community uses water today and then how it can use water into the future based off land use and zoning etc. Water Resource Manager will be working toward in the next year or so, the water resource Master Plan that will help begin to identify how water is used currently and how water can be used into the future. There will be opportunities for the Community and this Commission as well as City Council, to weigh in on those planning efforts.

Commissioner Marks added that Indigenous people have to think and protect resources seven generations into the future and how money should not be the catalyst/motivator in water usage. Having younger people to take part of that decision making is important. Mr. Hill informed of the state's requirement for municipalities to begin planning for 100 years. While it was not a requirement for Flagstaff, this started in 2009 and again in 2013; however, the process to update and reengage is coming up again in 2030 or before. That would be a time for community members to take opportunity to be involved.

There were also some discussion on water supply in terms of groundwater and surface water, and how that interacts with Flagstaff and region. The valley cities cannot come for Northern Arizona's groundwater supply and is lawfully protected since 1990s. Surface water (Colorado River) is different and there are court cases involved with those at this point, both instate and out of state.

City Manager Clifton also commented on what the City is doing administratively. Due to the importance of this discussion, the full comment of City Manager Clifton has been included here.

City Manager Clifton believes there are concerns by the Commission as to how the City deals with these matters administratively and what could be done to open up the process to allow for more engagement. He shared a document and highlighted two paragraphs. He explained, three years ago in January of 2020, there were steps that were put into place under his direction as city manager. There has been issues in the past about contracts that were not finding their way to the Council dais for discussion because pursuant to code, or procurement policy, which is embodied in the code. These were set up for administrative approval on things that were approved administratively but that it did not bring to Council.

So, CM team came up with an administrative directive three years ago. It reads as follows: If the community may have a high level of interest in a particular item or issue, please be sure to communicate clearly within the staff summary to the Council what the area of concern might be. That there’s a statement intended to make sure that we give Council a heads up when something may be of high interest, or perhaps controversy that's out of professional courtesy, so that our Council is aware. That there may be some things that need to be carefully discussed.

The last bullet item is more relevant, and it reads as follows: Please obtain Council input prior to the procurement of any outside services and prior to the formalization of any contractual relationships. Provide Council with routine updates during and subsequent to with the procurement or contractual process.

The takeaway is, the staff will do their part to try to get that to the Council dais, even though they may not have to. The best example where that occurs is in the procurement policy. Under the procurement policy and other policies that like the one Brad Hill referenced, staff may not have to go to the Council to solicit approval of anything. But the staff can, as a matter of professional courtesy, and that's what this is about, that Council should at least be apprised of these. More important to this discussion, the Community should have an opportunity to weigh in on things and share comments or concerns.

It's not to say that others will have a decision-making authority, but at least it is placed on the agenda, which is public and discussed in the Council forum, that brings matters that would otherwise be dealt with administratively. This has relevance to some of the concerns of this Commission and frankly, to others in the Community. City Manager stated it is good governance to not just have things approved when the Community has wants to have a voice in it and there are concerns. It is better governance to put light on that discussion and offer that opportunity.

Right now, it is just an administrative directive. Those are embodied in our website for the staff to deal with. This conversation has also come up now, the possibility to see insertion within our procurement code at some point and it would be more formalized. It is also not to suggest that all things should go to Council. There's a proper delegation that occurs and when they do generate that level of community interest. City leadership wants to make sure they are not stifling the conversation and precluding people from engaging in a discussion.

Councilmember Lori Matthews stated that she would be cautious to get involved in contractual procedures, because it muddies up the waters and it makes it a less effective. In City governance, we have great trust in the highly skilled staff members in each department.
             
B. Water Discussion with City Manager and staff from Water Services
A FAIR item was put forward by an Indigenous Commissioner at the January 4, 2023 regular meeting. The FAIR item is to have a discussion on the City of Flagstaff’s plan on addressing water and drought, as the state of Arizona is reported by media to be looking at a 30% reduction in water usage.

There was some conversation that happen in the prior agenda item that is part of this item, so notes from that conversation has been moved to this section. There was also an explanation between the difference between the two water agenda items under #6.

City Manager Clifton said, the City is pursuing a pilot project in water utility in the interest of improving water quality, whether it be wastewater treatment, in this arena it's could be with reclaimed water. What are the the technologies and the best practices that could enable the City to make the water cleaner? There is rapidly evolving technology in the state and federal regulations. Many local jurisdictions, like Flagstaff and elsewhere are trying new technologies to greatly improve water quality to the point where you know ultimately it lends itself to Direct Potable Reuse (DPR) drinking water.

Erin Young, Water Resources Manager, provided the following. There are potential regulations coming down on reclaimed water and wastewater quality that are likely to impact Flagstaff. Water Services is trying to stay ahead of the regulations while taking advantage of funding that is available through the Bureau of Reclamation. This would potentially provide a drought security - drought mitigation by allowing the advanced treatment of reclaimed water for additional uses such as Direct Potable Reuse (DPR). ADEQ, through their contractor, will be conducting a stakeholder survey across section of communities all around Arizona. ADEQ wants to know the perception of DPR and what people see as barriers. There is a lot happening in water, to protect it as a resource for generations, and to improve water quality. It is also to allow communities to recycle to the best of their abilities because water is important in the Southwest.

Councilmember Matthews encouraged the younger generation to come into Council meetings and provide public comment. She would like to get more community engagement and those not being heard. This makes for a healthy and vibrant community and the Indigenous community is a vital and vibrant part of identity in Flagstaff.

There was a discussion about the water quality, drought considerations, and the seriousness of having water to begin with, and what are the protections. Questions included: How is City Council dealing/managing new building/s where there is water waste or so much use of water? Who are these being built for? Water shortages in Maricopa County?

Councilmember Matthews stated Maricopa County water shortages are different than in Northern Arizona because they have a different water source than we have here and was commented on earlier. The City has set a plan, designed for growth up to 100,000 population and for 100 years. With the water wells the City has and planning is definitely managed very closely as we look at new development and expansion. City Manager said, the City has a 100 year plan, which is really less than 100 year plan because there is projections on plateauing in terms of growth, and not have the same concerns as the neighbors to the south.

Ms. Young added that the state of drought impacts different parts of Arizona differently. Flagstaff is not on Colorado River water. The City is not having to accommodate the cut that other communities are doing. In planning, one point is the City's award winning water conservation program. Staff does not hit every restaurant or hotel on checking on water use and maybe some improvements to make. Please email Rose for something Water Services might help with, the City has a fantastic rebate program. The designation of adequate water supply includes Upper Lake Mary Water, reclaimed water use, direct reuse, the purple pipe that we know today, ground water, and water from springs in the inner basin. What the DPR is and these new rules for expanding reclaimed water use provides us with some new tools. These can be new water supplies that can be added to that designation of adequate water supply. It also allows Flagstaff with more flexibility in how to meet future water demands. Being stewards of the resources that we have, it is an exciting time because of the advancements in technology and in regulation. Ms. Young also mentioned the Regional Plan will also have some information pertaining to the rule on groundwater transfers for better understanding.

Commissioners expressed gratitude for both of these water conversations and look forward to build on them.
             
7. INFORMATIONAL ITEMS TO/FROM COMMISSION MEMBERS, STAFF, AND FUTURE AGENDA ITEM REQUESTS

Co-chairs will alternate in running all remaining meetings in 2023.
             
8. ADJOURNMENT

Co-chair Washington adjourned the meeting at 1:03 PM.

    

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 08-May-24 12:52 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
235 ms 235 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.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/cfm_utilities/utilities.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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 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 @ 00:52:05.005
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 00:52:05.005
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 00:52:05.005
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 00:52:05.005
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 00:52:05.005
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 00:52:05.005
	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 @ 00:52:05.005
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:52:05.005
		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 @ 00:52:05.005
	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 @ 00:52:05.005
		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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
		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 @ 00:52:05.005
		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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=15ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:52:05.005
	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=16ms, Records=17) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:52:05.005
		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) = 2023-02-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-02-28 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:52:05.005
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=78ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
SELECT fas.form_num fas_form_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
	   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.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 = 3708 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:52:05.005
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3708

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 00:52:05.005
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(3708 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 @ 00:52:05.005
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3707 
getAllMnLines (Datasource=frsRO, Time=63ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
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 = 3707 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 = 861 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=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
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 @ 00:52:05.005
	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=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
		
	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 = 861 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 861 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 @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18649 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18650 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18658 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18651 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18652 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18659 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18653 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18654 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18660 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18661 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18655 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18656 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 00:52:05.005
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 00:52:05.005
	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 @ 00:52:05.005
	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 @ 00:52:05.005
		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 @ 00:52:05.005
		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=2&get_year=2023&dsp=min&seq=3708
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=2&get_year=2023&dsp=min&seq=3708
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=9605297
cftoken=4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
hitcount=4
lastvisit={ts '2024-05-08 00:52:05'}
timecreated={ts '2024-05-08 00:52:05'}
urltoken=CFID=9605297&CFTOKEN=4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
Cookie Variables:
CFID=9605297
CFTOKEN=4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3708
Session Variables:
cfid=9605297
cftoken=4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9605297_4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
subdir=/public/
tzoffset=0
urltoken=CFID=9605297&CFTOKEN=4f2ac916c64df9f1-67A978ED-BCAD-8CF7-B0204E9EB1E5C898
URL Parameters:
dsp=min
get_month=2
get_year=2023
id=
mt=ALL
seq=3708
Debug Rendering Time: 0 ms