Return
CITY COUNCIL WORK SESSION
TUESDAY, MAY 30, 2023
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
 3:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Daggett called the meeting of the Flagstaff City Council held May 30, 2023, to order at 3:01 p.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR DAGGETT
VICE MAYOR ASLAN
COUNCILMEMBER HARRIS
COUNCILMEMBER HOUSE
COUNCILMEMBER MATTHEWS (virtually)
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SWEET
ABSENT:









  Others present: City Manager Greg Clifton; City Attorney Sterling Solomon.
             
3. Pledge of Allegiance, Mission Statement, and Land Acknowledgement

The Council and audience recited the pledge of allegiance, Councilmember Harris read the Mission Statement of the City of Flagstaff, and Councilmember McCarthy read the Land Acknowledgement.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.

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.
             
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared 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 at the meeting 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 to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
  Connie Folsom addressed Council with concerns about Pickleball at Bushmaster Park.
 
Jill Stephenson addressed Council in opposition to the NAH rezone stating that the project needs more evaluation.
 
Tom Pearson addressed Council about carbon neutrality.
 
Stefan Sommer addressed Council in opposition to the NAH rezone stating that the project is inadequate in terms of sustainability.
 
Kathy Flaccus addressed Council in opposition to the NAH rezone stating that the project will cost taxpayers too much.
 
Paul Haro submitted a written comment regarding police brutality.
             
5.
Review of Draft Agenda for the June 6, 2023 City Council Meeting
  None
             
6. Proclamation: Two Spirit Day
  Mayor Daggett read and presented the proclamation. Katt Jim and Holly Figueroa made a few remarks in support of the proclamation.
             
7. Proclamation: Gun Violence Awareness Day
  Mayor Daggett read and presented the proclamation. Mary Grove made a few remarks in support of the proclamation.
             
8. Proclamation: LGBTQIA2S+ Month
  Councilmember House read and presented the proclamation and presented it to Jean Toner on behalf of the Commission on Diversity Awareness. Ms. Toner made a few remarks in support of the proclamation.
             
9.
May Work Anniversaries
  Senior Deputy City Manager Shannon Anderson provided a PowerPoint presentation that covered the following:
 
MAY EMPLOYEE WORK ANNIVERSARIES!
FIVE YEAR ANNIVERSARIES
ROBERT WALLACE, OPEN SPACE SUPERVISOR
KEITH CHAMBERLAIN, GRANTS AND CONTRACTS SPECIALIST
DANIEL LOGAN, PUBLIC WORKS MANAGER
TEN YEAR ANNIVERSARIES
KEVIN SAPP, POLICE SERGEANT
MARIANNE SULLIVAN, SENIOR ASSISTANT CITY ATTORNEY
TWENTY YEAR ANNIVERSARIES
RYAN CHURCH, FIRE ENGINEER
25 YEARS PLUS!!!
MARION LEE, WATER SERVICES ADMINISTRATIVE SPECIALIST
GRANT KELLY, POLICE SERGEANT
             
10. Resource Planning for Electric Grid Reliability
  Climate Program Manager Jenny Niemann introduced APS Managers Mike Eugenis and Judson Tillinghast who provided a PowerPoint presentation that covered the following:
 
APS INTEGRATED RESOURCE PLAN
COMMITTED TO A CLEAN ENERGY FUTURE
2023 APS RESOURCE DIVERSITY
SALES FORECAST UPDATE
MAINTAINING A DIVERSE ENERGY MIX IS IMPORTANT
CUSTOMER TO GRID SOLUTION
OUR STRATEGY
ELECTRIC VEHICLES
COOL REWARDS PROGRAM
COMMUNITY PARTNERSHIPS
KEEPING IT RELIABLE
 
Councilmember Matthews asked how APS will handle the increased power demands if Flagstaff reaches its goal by 2030. She is concerned about power outages, particularly in the winter months when there may be no other heating source available to people. Mr. Tillinghast stated that there are different teams that focus on the reliability of the transmission system and distribution systems. There are plans from a resource planning perspective that determine what resources are needed to meet peak load and plans to ensure that the transmission system and distribution system is built out accordingly. APS Public Affairs Manager Janet Dean stated that outages happen on the system, and the goal is to be as reliable as possible to get customers restored as fast as possible. There are redundancies through loops so they are able to get many customers back online quickly.
 
Councilmember Matthews asked if there are fee increases during peak times to encourage reduced demand. Mr. Tillinghast stated that he is not aware of that. There are energy efficiency programs that seek to reduce energy consumption in general, the rate structures of time of use rates are developed to encourage people to use more energy outside of the demand hours to reduce cost.
 
Councilmember Matthews asked about diversity in the power system and what is being done to build the infrastructure for that diversity. Mr. Eugenis stated that there is an interconnected grid that has the ability to transport energy as needed. There are quite a few projects planned in this area over the next ten years.
 
Councilmember Matthews stated that clean energy comes with a hefty price tag. She noted that Tucson citizens recently turned down an energy conversion due to the cost. She asked if the commitment is to convert 65% to clean energy if that would mean an increase in rates. Mr. Eugenis stated that the bids that come in for renewable energy are the most economical and that is where they are investing. Ms. Dean added that there are a lot of rate plans available to customers that allow them to choose how and when they use their energy to fit their needs and budget.
 
Councilmember Harris asked what outreach is being done to help residents understand what they can do in case of an outage. Ms. Dean stated that it is a partnership with APS and emergency management to communicate with customers and establish warming centers when necessary. Ms. Niemann added that it would be much the same as it is today. Currently, heating and water heating is done through a dual fuel system where both gas and electricity are needed to run a furnace or water heater, so the preparedness components are the same. Electric homes can be more resilient because only one fuel source is needed.
 
Tom Pearson and Laura Kessler addressed Council regarding the presentation. The following comments were provided:
  • The goal should not be to convert everything to electric.
  • It is important to maintain energy diversity.
  • The goal of 100% renewable energy is not viable for the safety of the community.
  • An all-electric focus can leave the community vulnerable during times of outages.
  • Things like large backup generators for homes and businesses will be needed and people are not thinking about those expenses when going to a fully electric environment.
Sustainability Director Nicole Antonopoulos stated that the focus is to obtain as much electricity as possible from renewable resources. The goal was for 100% of municipal energy to be from renewable energy by 2025 and that goal has already been met. Another goal was for 68% of the community electricity use would be from renewable energy, nowhere in the plan does it call for every resident to be net zero or carbon-free. To reach this goal, more aggressive building codes will increase renewable energy installation and usage in new buildings. The third goal is to support solar installation on existing residential buildings. The intent is to take advantage of the superior efficiency of electricity and support the reduction of natural gas usage by 62% in the residential sector. This does mean that everyone immediately goes to all electric but rather when appliances need replacing that they are replaced with electric appliances.
 
Vice Mayor Aslan asked for a history of how the effort came to be. Ms. Antonopoulos stated that the conversation to be 100% reliable on renewable energy started in 2016 with a former City Council. In 2017 Sustainability staff were directed to achieve 100% clean energy for the city organization and the Flagstaff community. This prompted the draft of the community-wide Climate Action and Adaptation Plan. Following that, there was a call to action from the community to declare a climate emergency. This was followed by the development of the Carbon Neutrality Plan to get the city as an organization and the community at carbon neutrality by 2030.
 
Councilmember McCarthy noted that many people say that implementing the plan will cost a lot of money, while that is true, it will cost even more if nothing is done. He is very supportive of the work that is being done. He also mentioned that a majority of homes in Flagstaff with natural gas appliances do not have a system that will heat their home if the power goes out. The reliability on electricity is already standard practice.
 
Councilmember Harris stated that there needs to be more involvement in getting the information to the public. It is a disservice to assume that everyone is reading and educated about the Carbon Neutrality Plan. It is also important to be sensitive to the language being used when talking about limited resources.
 
Councilmember Matthews reiterated her concern about reliability and protecting the most vulnerable. Many of the plans have unforeseen consequences and after reading more about what Tucson went through, at some point, the matter should be put out to the citizens to see what they want. While this has gone through multiple years and multiple Councils, it may not be a true representation of the community as a whole.
 
Councilmember McCarthy stated that ultimately this is about grid reliability. The biggest takeaway is that it is very important that APS have their transmission lines set up for redundancy to lessen the number of people impacted by a power outage. There needs to be a bigger focus on redundancy.
             
11. Annual Report for MOONSHOT at the Northern Arizona Center for Entrepreneurship and Technology (NACET) - 2023
  Community Investment Director David McIntire provided opening comments and introduced Executive Director Diana White who provided a PowerPoint presentation that covered the following:
 
MOONSHOT AT NACET
2021-2022 REVIEW
A LOOK AT THE NUMBERS
TOTAL INVESTMENT FUNDS
TOTAL REVENUE GENERATED
JOBS
2022 OCCUPANCY RATES AND NEW TENANTS
CURRENT OCCUPANCY RATE AT NACET
A LOOK AT A FEW MOONSHOT AT NACET EVENTS
4TH ANNUAL PIONEER PITCH STATE-WIDE TOUR
WINNERS TOOK HOME THEIR SHARE OF $30,000 IN CASH PRIZES!
THE 3RD ANNUAL SHOEMAKER AWARDS
WE MEAN BUSINESS
 
Vice Mayor Aslan asked if Ms. White could speak about the Shoemaker Awards. Ms. White stated that the Shoemaker Awards were something started three years ago as a celebration of the progress of the tenants but to also incorporate a Northern Arizona pitch event that provides an opportunity for entrepreneurs to compete for financial prizes.
 
A break was held from 5:09 p.m. through 5:23 p.m.
             
12. J.W. Powell Specific Plan Study Update
  Senior Project Manager David Pedersen, Coconino County Public Works Director Christopher Tressler, and Planning Director Michelle McNulty provided a PowerPoint presentation that covered the following:
 
J.W. POWELL BLVD SPECIFIC PLAN STUDY
VICINITY MAP
KEY STAKEHOLDERS
JWP BLVD COUNCIL-APPROVED ALIGNMENT
JWP SPECIFIC PLAN STUDY PROJECT TEAM
UPDATE
FLOODING UPDATE – HEROLD RANCH ROAD
WHAT IS A SPECIFIC PLAN?
CHANGE ORDER 5
 
Jennifer Kotalik submitted a written comment urging the Council to revert back to the original alignment.
 
Mary Norton submitted a written comment asking for the Open Space Commission to be involved in the study.
 
Vice Mayor Aslan stated that there was a request from an Open Space commissioner to include open space and parks and recreation as the plan moves forward, specifically related to Hoffman Tank. Ms. McNulty stated that staff has already been meeting with Parks, Recreation, Open Space, and Events staff on acquisitions they are interested in that area. There is quite a bit of scope addressing the open space and trails in the area, and they can add a presentation to the Open Space Commission as part of the scope. Mr. Pedersen added that they have also been coordinating with Arizona Game and Fish about the area as it is a wildlife corridor.
 
Councilmember Matthews asked when construction is set to begin. Mr. Pedersen stated that now that the final route has been determined, they are looking at three to five years for construction to start. While there is not a definitive plan, they are excited to be closer to a buildable design.
             
13. Wildland Fire Preparedness Briefing
  Wildland Fire Manager Paul Oltrogge introduced Fire Department Engineer/Paramedic and Southwest IMT Situation Unit Leader Katie Brown, USFS Flagstaff Ranger District Forest Fire Planner Jesse Causer, and APS Northeast Division Manager Joe Weathersby. The group provided a PowerPoint presentation that covered the following:
 
2023 WILDLAND FIRE PREPAREDNESS UPDATE
PARTNERS AND PRESENTERS
WFM WITHIN COMMUNITY RISK REDUCTION
FLAGSTAFF FIRE DEPARTMENT RESPONSE
FLAGSTAFF FIRE DEPARTMENT – SEVERITY STAFFING
AVIATION RESOURCES
PRECIPITATION
DROUGHT MONITORING
SEASONAL OUTLOOK
NATIONAL PREDICTIVE SERVICES
SIGNIFICANT WILDFIRE POTENTIAL OUTLOOK
APS WILDFIRE PREPAREDNESS AND RESPONSE
APS HAS A PLAN
APS WILDFIRE PREVENTION
APS MITIGATION PROTOCOLS
APS WILDFIRE RESPONSE
THE EVOLUTION OF THE EVACUATION MAP
EVACUATION MAP
BE SET – BE AWARE
EVACUATING FROM WILDFIRES
HIGHLIGHTS
FFD RISK MANAGEMENT ASSESSMENT
 
Councilmember Matthews thanked the presenters. She stated that the city is surrounded by forest, and this should be the number one focus. Flagstaff has been recognized nationally for its innovation and leadership in fire mitigation efforts.
             
14. Public Participation

None
             
15. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Councilmember Sweet reminded everyone that Friday is First Friday Artwalk, Hullabaloo is happening at Wheeler Park on Saturday, and the Farmers Market is on Sunday.
 
Councilmember McCarthy reported that MetroPlan had an advance last week to discuss their work plan for the next year.
 
Vice Mayor Aslan reported that he was in San Antonio with Discover Flagstaff for a convention where they highlighted how Flagstaff is packaged and presented to international tourist groups. He attended the Tourism Commission meeting and Sustainability Commission meeting and was invited to a meeting at Grand Canyon to discuss a protected area that is being proposed for national monument status. Lastly, he reported that he chaired the Colorado Plateau Water Advisory Committee meeting where City Manager Clifton provided an update on the Rio de Flag project.
 
Councilmember Harris reported that she participated in a session with NALA at the Museum of Norther Arizona. It was an opportunity to talk to Flagstaff Leaders about city issues. She reported that Juneteenth events are coming up on June 17, 2023 at South Beaver School.
 
Councilmember Matthews reported that she was also a speaker at the NALA event. It was a great event that was well attended; it was great to hear from the community and share thoughts and ideas.
 
Mayor Daggett reported that she gave opening remarks at the Water Utility Leadership forum, she was impressed with the event and applauded the efforts of Water Services Manager Erin Young who oversaw half of the day. She also reported that she was on Radio Sunnyside to talk about water. Last week she attended the Helios Education Foundation in Phoenix for the Arizona Mayor’s Education Roundtable where they discussed a variety of data related to all aspects of education in Arizona.
             
16. Adjournment

The Special Meeting of the Flagstaff City Council held May 30, 2023, adjourned at 6:45 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 06-May-24 06:16 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
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
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.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/Application.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
234 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 @ 06:16:35.035
			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 @ 06:16:35.035
				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=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 06:16:35.035
			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 @ 06:16:35.035
				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 @ 06:16:35.035
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 06:16:35.035
	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 @ 06:16:35.035
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:16:35.035
		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 @ 06:16:35.035
	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 @ 06:16:35.035
		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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
		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 @ 06:16:35.035
		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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:16:35.035
	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=18) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:16:35.035
		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-05-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-05-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 06:16:35.035
			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(3743 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 @ 06:16:35.035
	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 @ 06:16:35.035
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3742 
getAllMnLines (Datasource=frsRO, Time=32ms, Records=18) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
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 = 3742 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 = 937 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=15ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
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 @ 06:16:35.035
	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 @ 06:16:35.035
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
		
	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 = 937 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 937 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 @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19845 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19843 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12611 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19850 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19844 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12612 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19846 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12613 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19856 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12614 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19857 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12615 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19858 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12616 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19859 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12617 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19852 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12618 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19853 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12619 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19854 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12620 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19855 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12621 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19848 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19847 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12622 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19849 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:16:35.035
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 06:16:35.035
	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 @ 06:16:35.035
	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 @ 06:16:35.035
		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 @ 06:16:35.035
		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=5&get_year=2023&dsp=min&seq=3743
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=5&get_year=2023&dsp=min&seq=3743
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=9554821
cftoken=813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
hitcount=4
lastvisit={ts '2024-05-06 06:16:35'}
timecreated={ts '2024-05-06 06:16:35'}
urltoken=CFID=9554821&CFTOKEN=813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
Cookie Variables:
CFID=9554821
CFTOKEN=813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3743
Session Variables:
cfid=9554821
cftoken=813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9554821_813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
subdir=/public/
tzoffset=0
urltoken=CFID=9554821&CFTOKEN=813bb08173447f43-0C472009-9B7B-3101-8436CD22A3E7B15B
URL Parameters:
dsp=min
get_month=5
get_year=2023
id=
mt=ALL
seq=3743
Debug Rendering Time: 0 ms