Return
 

 
  INDIGENOUS COMMISSION
VIRTUAL TEAMS REGULAR MEETING
211 WEST ASPEN AVENUE
             WEDNESDAY,11:00 A.M., JUNE 1, 2022
             
1. Call to Order
Co-chair Washington called the meeting to order at 11:21 PM.
             
2. Roll Call
NOTE: One or more Commission Members may be in attendance telephonically or by other technological means.
Diana Cudeii, Ex-Officio; Absent
Dorothy D. Gishie, Ex-Officio; Absent
Meg Kabotie Adakai, E-Officio; Present, joined later
Cora M. Phillips, Co-Chair; Present
Joe. W. Washington, Co-Chair; Present
Darrell Marks; Present
Fawn Toya; Present
Kiara Weathersby; Excused Absence
Shawna Whitehat; Excused Absence (texted at 11:51 AM)
Jonathan Yellowhair; Present, joined later

Others present: Rose Toehe, Staff Liaison; Erin Young, Water Services, presenter; Sara Dechter, Community Development, presenter; Jenna Ortega, Sustainability; DeAnn Wegwert, CODA; Greg Clifton, City Manager.
             
A.
LAND ACKNOWLEDGEMENT
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 speaker)

None.
             
4. APPROVAL OF MINUTES
             
A. Approval of Minutes for April 6, 2022
Motion to approve Minutes as is or approve with amendments.

Co-Chair Washington made a motion to approve the Minutes as is. Commissioner Toya seconded. The motion passed unanimously.
             
5. DISCUSSION ITEMS AND POSSIBLE DECISION
             
A. Water Services Invitation and Update
Ms. Erin Young, Water Resources Manager, will provide a short presentation on the following:
  • Invitation for a tour of the Reclaimed Water Facility
  • Update on the Reclaimed Water Policy and the status of the workgroup
  • There will be few minutes for discussion
Ms. Young provided an open invitation to the Commission for reclaimed water facility tours. Water Services has resumed tours again and open to Commissions and the public by appointment. Water Services staff with Water Reclamation staff are willing to assist with touring the facilities and learning about the wastewater treatment process. This would be an advantage once it comes time to talking about reclaimed water policy again. There is interest from Commissioners Toya and Marks to tour facilities. A poll will be sent for commissioners who are absent.

Ms. Young continued with update on Reclaimed Water policy. Two years ago, the Community Stakeholder Committee on reclaimed water was Water Services' first attempt at revisiting reclaimed water policy. Water Services has a water policy and a city code that determines how reclaimed water agreements are issued. There is a need to launch a phase two effort. Water Services has had a lot of turnover with essential staff positions that need to be part of those efforts, including the Director and Engineering Manager. The Water Commission will be the focal point of developing a scope of work and how the community provides input. As that gets developed, Ms. Young will keep the Indigenous Commission and other city commissions informed on the timeline.

There were some questions from the Commissioners. Commissioner Marks asked on growth in Flagstaff regarding water use/projected use and dramatic changes. Ms. Young said, there is a staggering sort of change in water demand and will be part of the Regional Plan effort and plan for water demand to meet the needs of the voter approved Regional Plan. So there will be a lot of discussion around that. There has not been any new reclaimed water agreements; however, there is a Water Smart grant that will hopefully provide funds for aquifer recharge and recovery. Co-chair Washington asked a question on who makes a decision to sell reclaimed water to other entities and he understood that Council made that a staff function. Does the Council ratify or approve that or whether the staff can simply make the agreements? Is that correct? Ms. Young answered, yes, the authority to issue new reclaimed water agreements does lie with the Water Services Director and that conversation occurred a couple years ago with City Council for Council to to take that on. Council ultimately voted not to change it at that time. There is an outstanding fare item on this topic. She also suggested if the Indigenous Commission would like to see that on Council agenda, maybe making a recommendation for that to be on Council agenda, or perhaps for the Water Commission to also provide their thoughts on that topic. With that suggestion, Commissioner Toya stated she strongly believed the Commission should request that this be brought up and find a new way to engage the subject. Commissioner Toya made a motion to have this subject be addressed to City Council and bring this matter back to the table if possible. It was seconded by Commissioner Marks. Motion passed. Ms. Young stated she would follow up with City Manager Clifton. Ms. Toehe suggested they meet with City Manager together.
             
B. Flagstaff Regional Plan - Second Visit
The project team from Community Development including Ms. Sara Dechter, Comprehensive & Neighborhood Planning Manager, will provide a presentation involving discussion on the Flagstaff Regional Plan and Commissioners hands-on involvement with activities involving this process. This information can be found on the attachment associated with this agenda item.

Ms. Dechter introduced herself and recalled an April presentation to this Commission on the Regional Plan. She talked about what it is and why they would like the Commissions' input and to bring back the exercise that was discussed at the last presentation. She also went through the digital white board and invited the commissioners to add comments. This is part of the brainstorming process to include your ideas. What was covered the last time was that the plan is sparse on its discussion of Indigenous community members and the City's relationships with the Indigenous communities that surround Flagstaff. There's a need to add those viewpoints. The focus now is on strengths and weaknesses, opportunities, and threats (SWOT) of the current plan. What are the inputs that evolve and how that can be adopted into the plan for the voters to approve. It's about the need to create an inclusive and comprehensive vision for our community.

There will also be components of water, transportation, land use, natural resources, parks, open space, etc. Some of this process is also about bringing together data from the County about surrounding areas of Bellemont, Fort Valley, Doney Park, Mountainaire, and Kachina Village. That conversation will start with workshops in the fall. After gathering all the values, attitudes, and the needed data, the City will come up with a first phase. There was also a discussion with City Council regarding the collaborative process and what that could look like, including funding in the next fiscal year. Recruitment of community member with experience in facilitating collaborative services and that pursues compensation for participants, which is an equity emerging practice in urban planning. We want to understand how a compensation policy could help overcome barriers to participation. So if the Indigenous members of our community want to be involved in discussing or even be involved in helping set up the collaborative process, please reach out to Ms. Dechter. 

There was a lot of discussion back and forth regarding the process, barriers, current status of Indigenous community members, including youth and elder voices, and outreach in general. Survey questions are important too, are they culturally based. Community needs to recognize through community building that participation is important, not there to just extract information. For more in depth information, visit the City website regarding the Regional Plan and surveys attached to this process.
             
6. GENERAL BUSINESS AND POSSIBLE DECISION
             
A. National Navajo Code Talker Day, Indigenous Peoples Day and Native American Heritage Month
Ms. Toehe, Staff Liaison, will provide information on the following:
  • National Navajo Code Talker Day on Sunday, August 14, 2022
  • Indigenous Peoples Day on Monday, October 10, 2022 and
  • Native American Heritage Month in November 2022.
Ms. Toehe requested assistance with planning all three of the above events. The request was the Commission to form an informal work group to work on these events. This will involve the Commissioners to be more active in the events usually planned by the Coordinator. Commissioners Marks and Yellowhair, were willing to assist, while Commissioner Toya will assist when she can.
             
B. Commissioner Resignation
Informational item to the Commission, details will be provided by Ms. Toehe. Commissioner Dorothy D. Gishie turned in her resignation on May 12, 2022.

Ms. Toehe stated that Commissioner Dorothy Gishie had submitted her resignation on May 12, 2022. That position is an ex-officio position as it's part of the County's Indigenous Peoples Advisory Council (IPAC). The MOU with the County is that the Indigenous Commission will have three ex-officio members that serve on IPAC. The individuals also have to live outside of city limits and enrolled in a federally recognized or state recognized Indigenous nation. Currently, there is no one on IPAC who fits that criteria, so recruitment has to be done by IPAC. This means it may take a several months to complete due to recruitment, the application process, getting on Board of Supervisors' (BOS) agenda, getting appointed by BOS, and finally applying to the Indigenous Commission & getting appointed by City Council at a Council meeting.
             
C. Possible Change in Start Time of Indigenous Commission Meetings
The Indigenous Commission currently has two members who are not able to join the meeting until 12:00 PM. After input from all Commissioners, decide if it would be advantageous to the Commission to change the start time from 11:00 AM to 1200 PM.

This topic is on the agenda because there are currently two Commissioners who cannot join the meeting until an hour later. It would be beneficial to give them some time to hear from them and if the situation is still the same. Hopefully, this will not interfere with other Commissioners who have to be off at 1:00 o'clock. From the last poll, it seemed most were flexible; however, a discussion would be appropriate to do. Time was given to Commissioners Yellowhair and Kabotie Adakai to speak to this situation. Commissioner Kabotie Adakai stated that for the summer, she is able to join at 11:00am or close to that time; however, in August her schedule will return back to the way it was, when she is not able to join until 12:00pm. Commissioner Yellowhair stated he had talked with his supervisor and he is not able to change the schedule he has for group supervision. As a therapist under an associate license, he has to have supervision for two years in order to get fully licensed and part of that is group dynamic supervision. This is scheduled every Wednesday at 11:00am with the entire Behavioral Health Unit.

After discussion, it was decided that a poll will be taken with the Commissioners who were absent and to vote on the change if supported at the next meeting. Commissioner Toya made a motion to hold the next meeting at 12:00pm. Co-chair Washington seconded the motion. The motion passed unanimously.
             
7. INFORMATIONAL ITEMS TO/FROM COMMISSION MEMBERS, STAFF, AND FUTURE AGENDA ITEM REQUESTS

Commissioner Toya thanked the Commissioners who helped to prepare the City Council presentation. She felt Commissioner Weathersby took on a lot on the Commission's behalf in dedicating her time, data, and work into the report. Commissioner Wegwert from CODA introduced herself. She is interested in issues that the Indigenous Commission is considering and wanted to listen in.
             
8. ADJOURNMENT
Co-chair Washington adjourned the meeting at 12:37 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 01-May-24 03:31 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
234 ms 234 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/Application.cfm
47 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.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/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
281 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 03:31:07.007
			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 @ 03:31:07.007
				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 @ 03:31:07.007
			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 @ 03:31:07.007
				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 @ 03:31:07.007
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 03:31:07.007
	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 @ 03:31:07.007
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:31:07.007
		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 @ 03:31:07.007
	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 @ 03:31:07.007
		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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
		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 @ 03:31:07.007
		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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
	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 @ 03:31:07.007
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:31:07.007
	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=15ms, Records=22) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:31:07.007
		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) = 2022-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2022-06-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 03:31:07.007
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
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 = 3542 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 03:31:07.007
		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) = 3542

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 03:31:07.007
			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(3542 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 @ 03:31:07.007
	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 @ 03:31:07.007
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3541 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
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 = 3541 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 = 781 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=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
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 @ 03:31:07.007
	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 @ 03:31:07.007
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
		
	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 = 781 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 781 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 @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17079 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17080 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17088 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17081 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17082 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17089 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17083 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17090 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17091 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17084 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17092 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17093 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17094 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17085 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17086 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:31:07.007
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 03:31:07.007
	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 @ 03:31:07.007
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 03:31:07.007
		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 @ 03:31:07.007
		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=6&get_year=2022&dsp=min&seq=3542
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=6&get_year=2022&dsp=min&seq=3542
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=9423095
cftoken=ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
hitcount=4
lastvisit={ts '2024-05-01 03:31:07'}
timecreated={ts '2024-05-01 03:31:07'}
urltoken=CFID=9423095&CFTOKEN=ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
Cookie Variables:
CFID=9423095
CFTOKEN=ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3542
Session Variables:
cfid=9423095
cftoken=ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9423095_ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
subdir=/public/
tzoffset=0
urltoken=CFID=9423095&CFTOKEN=ca0418da00e6fe38-04E3A7A3-DCD8-C071-8DBC10D1FAE84B9F
URL Parameters:
dsp=min
get_month=6
get_year=2022
id=
mt=ALL
seq=3542
Debug Rendering Time: 0 ms