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

 
MINUTES
             
1.
Call to Order

Mayor Daggett called the Work Session held May 9, 2023, to order at 3:04 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
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 Matthews read the Mission Statement 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.
  Michael Pappas addressed Council with concerns and complaints about Mountain Line operations.
 
Michele James, on behalf of Friends of Flagstaff’s Future, addressed Council with concerns about the NAH proposal. There will be detrimental effects of moving the hospital outside of the city core. NAH can retrofit and renovate the existing facility while also continuing its vision.
 
Sandra Lubarsky addressed Council about the NAH proposal. There is no opinion from outside experts with knowledge of these types of projects. It is important to understand the impacts of a medical retail facility on the outskirts of town.
 
Dapper Dre addressed Council about bike safety and road design. We spend hundreds of millions of dollars on projects and safety should be built into the road and intersection designs. The city continues to design to the convenience of cars and speeding them up, the focus needs to change to prioritizing bicycles and pedestrians.
 
Bryan Bates addressed Council about the repurposing of NAH’s legacy campus and taking the time needed to look for hidden opportunities that could save time and frustration.
 
Stefan Sommer, on behalf of the Northern Arizona Climate Alliance, addressed Council with concerns about the NAH proposal. The concerns focused on the carbon footprint of the development, the climate impacts, and suggestions to mitigate the impacts.
 
Adam Shimoni addressed Council with concerns about the traffic impact analysis done for NAH. He indicated that he believes that the modeling is problematic and it is too car-centric.
 
Written comments in opposition to the relocation of the hospital were received by the following:
  • Terry and Reva Clay
  • Lynn Sweitzer
  • Sabra Daly
  • Danielle and Carlos Ramos
  • Jesse and Candra Faulkner

A written comment in opposition to pickleball courts at Bushmaster Park was submitted by Cindy Haro.
             
5. Review of Draft Agenda for the May 16, 2023 City Council Meeting

None
             
6. Proclamation: Provider Appreciation Day
  Mayor Daggett read and presented the Provider Appreciation Day proclamation.
             
7. Proclamation: Mental Health Awareness Week
  Councilmember House read and presented the Mental Health Awareness Week proclamation.
             
8. Proclamation: National Economic Development Week
  Councilmember Sweet read and presented the National Economic Development Week proclamation.
             
9. Proclamation: National Travel and Tourism Week
  Councilmember Matthews read and presented the National Travel and Tourism Week proclamation.
             
10. National Travel and Tourism Week Update
  Convention and Visitor’s Bureau Director Trace Ward provided a PowerPoint presentation that covered the following:
 
NATIONAL TRAVEL & TOURISM WEEK
THE VISITOR ECONOMY IS ESSENTIAL
VIDEO
FLAGSTAFF APPROACH TO NATIONAL TRAVEL AND ECO TOURISM WEEK
 
Council and staff briefly discussed the I-17 clean-up event.
 
Councilmember Sweet thanked the tourism team for the work they do for the business community and for keeping Flagstaff top of mind.
             
11. Economic Development Week 2023
  Business Retention and Expansion Manager John Saltonstall and Business Attraction Manager Jack Fitchett provided a PowerPoint presentation that covered the following:
 
ECONOMIC DEVELOPMENT WEEK 2023
ACTIVITIES THROUGHOUT FLAGSTAFF
PARTNERS
 
Moonshot@NACET Executive Director Diana White addressed Council covering the following points:
  • Strategies for more community engagement.
  • New Director of Events and Community Engagement position.
  • Success stories from the last few months.
    • Three companies received over $7000 in ARPA funding.
    • In person workshops have started back up again.
    • Pitch events.
    • Occupancy is over 70%.
    • $5.6 million in funding.
    • $6.4 million in revenue.
    • 437 jobs created or retained.
  • Economic development is a community effort.
Economic Collaborative of Northern Arizona President and CEO Gail Jackson addressed Council covering the following points:
  • In Winslow, there are 1,200 acres of industrial land where they are looking to be innovative by creating the first-of-its-kind inland port. This will provide millions of square feet for warehousing and manufacturing, many jobs, access to rail and major interstates, and the revitalization of an underutilized airport. It will also bring new housing developments.
  • In Camp Verde, they are celebrating the announcement of a new manufacturer and framing service company. It will be 110,000 square feet and create over 180 jobs. They anticipate full operations in the spring of 2024.
  • The NAH relocation will be transformational for the region and the health of the economy.
  • They are working on a strategic plan for the region that will tie all municipalities together.
  • They are conducting a labor analysis and identifying workforce needs.
  • There is a workforce housing analysis being done with the intent to develop tangible goals for the region.
  • They continue to find and bring high-wage, low-impact jobs to Northern Arizona to keep the quality of life high.
Councilmember Matthews stated that it is exciting to hear about the new industry and economic vitality that is stimulating Northing Arizona. She appreciates the collaborative efforts throughout Flagstaff to bring and keep businesses here.

Councilmember McCarthy stated that he continues to be amazed at the great work Economic Vitality has been doing.
 
Vice Mayor Aslan stated that he helped facilitate a conversation between BlockLite and NAH about the use of carbon-capturing cinderblocks. There are exciting possibilities there, and he is proud of the team and their efforts to advance businesses such as these. Mr. Saltonstall stated that there are some exciting things coming from BlockLite, and it is always great when materials can be sourced locally.
 
Mayor Daggett voiced her appreciation to the team for their hard work in building strong partnerships and relationships throughout the region. Councilmember House agreed and added that she likes the live neighborly engagement.
             
12. Mountain Line Update to City Council
  Mountain Line CEO and General Manager Heather Dalmolin provided a PowerPoint presentation that covered the following:
 
MOUNTAIN LINE TODAY AND BEYOND
FY2023 PERFORMANCE
BUDGET REVIEW
COMPENSATION RECOMMENDATIONS
BENEFIT RECOMMENDATIONS
FY2024 OPERATING BUDGET
BUDGET RESULTS
5 YEAR FINANCIAL OUTLOOK
 
Councilmember Matthews asked how many trips are done per day collectively across all routes. Ms. Dalmolin stated that it is about 500 trips per day.
 
Councilmember Matthews asked how many riders are coming from NAU. Ms. Dalmolin stated that 50% of the ridership on Route 10 is NAU riders when school is in session.
 
Councilmember Matthews asked how often the taxi service runs. Ms. Dalmolin stated that they do not restrict the use of the taxi service; people must qualify for the paratransit service, but there is no restriction on when trips can be made or how many trips can be taken, but they receive a value of up to $300 per month. Users are able to be qualified on a short-term or long-term basis depending upon need.
 
Councilmember House asked about the anticipated increases with the shift to electrification of the fleet. Ms. Dalmolin stated that when they made the decision to transition to zero emissions, they did a study which found that the change from the current hybrid vehicles to zero-emission electric vehicles would reduce the maintenance costs because there are not the same amount of moving parts to be maintained. The challenge with a zero-emission fleet is the actual cost to charge the vehicles. It is not a direct offset from the savings realized in general maintenance. There will be an increase in the cost to charge the vehicles.
 
Mountain Line Transit Planner Bizzy Collins continued the presentation.
 
TRANSIT NEEDS (2022)
TRANSIT NEEDS (2021)
TRANSIT NEEDS (2019)
FLAGSTAFF IN MOTION
TRANSIT VISION
 
Councilmember McCarthy asked if there is any data that indicates that a route to the hospital would be used. Ms. Collins stated that the current NAH bus stops are currently in the top 25% of ridership in the system, and they do see robust employee passes being used there and people going to visit those in the hospital.
 
Councilmember Matthews stated that there are a lot of transfers at the NAH stops, she asked if there were true numbers for ridership to and from the hospital. Ms. Collins stated that based on pass holders it is about 5% of total trips to and from the hospital.
 
Councilmember Matthews asked how many employee passes are being used. Ms. Collins stated that there are 100 unique users per month making trips.
 
IMPROVE ACCESS TO THE BUS SYSTEM
TRANSIT VISION ACCESS FROM DCC IN 15 AND 30 MINUTES
TRANSIT ACCESS
TRANSIT-SUPPORTIVE ACTIONS
BUS RAPID TRANSIT (BRT)
NEXT STEPS
5 YEAR FINANCIAL OUTLOOK
 
Council briefly discussed bus stop shelters, Route 5, and student riders. They thanked Mountain Line for the presentation and discussion.
 
A break was held from 5:17 p.m. through 5:30 p.m.
             
13. Short-term Rentals License Update
  Public Affairs Director Sarah Langley, Management Services Director Rick Tadder, Community Director Dan Folke, Customer Service Manager Jessica Kittleson, and Senior Assistant City Attorney Anja Wendel provided a PowerPoint presentation that covered the following:
 
SHORT TERM RENTAL ORDINANCE
AGENDA
SHORT TERM RENTALS DEFINED
SCHEDULE OF EVENTS
STRS IN FLAGSTAFF
BACKGROUND – ZONING AND CITY CODE
BACKGROUND – A.R.S. 9-500.39
PUBLIC COMMENTS ON DRAFT ORDINANCE
DRAFT ORDINANCE
LICENSE REQUIRED
LICENSE FEE
LICENSE APPLICATION
APPLICATION PROCESS
LICENSE DENIAL
NEIGHBOR NOTIFICATION
EMERGENCY POINT OF CONTACT
 
Council discussed the use of the emergency hotline to field all calls and be the buffer between the complainant and the owner. Council expressed concern about access to emergency contact information being used to harass people.
 
ADVERTISEMENTS AND POSTING
SEX OFFENDER BACKGROUND CHECKS AND LIABILITY INSURANCE
VERIFIED VIOLATION
 
Councilmember House asked how it would be a prohibited use to house a sex offender if there is no requirement to screen occupants. Ms. Wendel stated that it would be complaint-driven.
 
Councilmember Matthews asked about registered sex offenders and if they would be required to notify when occupying a short-term rental. Police Chief Dan Musselman stated that sex offenders are required to register within 72 hours of moving to a new residence, he is not sure how that would translate to a short-term rental. He will research and report back to Council.
 
Mayor Daggett stated that one of the big complaints is sidewalks not being shoveled or trespassing. Those are more code violations rather than serious offenses; she asked if they would be included in the verified violation. Ms. Wendel stated that she believed that they would be.
 
VERIFIED VIOLATION – MUST BE “FINALLY ADJUDICATED”
LICENSE SUSPENSION
PENALTIES FOR VERIFIED VIOLATIONS
COMPLAINTS AND CODE COMPLIANCE
PUBLIC OUTREACH PLAN
STAY UP TO DATE
 
The following individuals addressed Council regarding short-term rental regulation:
  • Beth Knisely
  • Tim Trazaska
  • Ellie Blair
  • Mike Bland
  • George (no last name given)
  • Jake (no last name given)
  • Patrick Mowrer
  • Erik (no last name given)
The following comments were received:
  • Short-term rental hosts need to be accountable and be good stewards.
  • The most frequent violation seen is unattended fires.
  • Set a justifiable and equitable fee.
  • This is just another expense by the city, and I am not sure if it will land results.
  • Short-term rentals are not bad, I have paid over $30,000 in salaries, and I pay taxes to the city.
  • Are the penalties associated with short-term rental fines commensurate to fines for property owners?
  • There are vigilantes that try to harass short-term rental operators, there needs to be a buffer in place to prevent this from happening.
  • It would be more fair to regulate “Air bnb” and “VRBO” rather than hosts directly.
  • There are a lot of privacy concerns with this plan.
  • In the past there has been nowhere to go with complaints and concerns; this will help bridge that gap, especially with out-of-state owners.
  • Suggest charging a higher fee for hosts who are not residents of Arizona or Flagstaff.
Written comments concerning the regulation of short-term rentals were submitted by:
  • Eve Fiorucci
  • Mary Norton

Council discussed violations and penalties, ways to educate and address Flagstaff-specific issues, notification requirements, and the posting requirements for inside the unit.
             
14. 2023 Charter Amendment Discussion
  City Clerk Stacy Saltzburg, Purchasing Director Patrick Brown, Senior Assistant City Attorney Anja Wendel, Senior Deputy City Manager Shannon Anderson, Management Services Director Rick Tadder, Deputy City Clerk Stacy Fobar, City Attorney Sterling Solomon, Interim Deputy City Manager Heidi Hansen, and City Manager Greg Clifton provided a PowerPoint presentation that covered the following:
 
PROPOSED CHARTER AMENDMENTS
WHAT IS A CITY CHARTER?
FLAGSTAFF CITY CHARTER
INTERNAL CHARTER REVIEW COMMITTEE
NO. 1 – NOMINATION FOR PRIMARY ELECTION
NO. 1 – PROPOSED AMENDMENT
NO. 2 – PURCHASES AND CONTRACTS FOR CITY IMPROVEMENTS
NO. 2 – PROPOSED AMENDMENT
NO. 3 – ADMINISTRATIVE DEPARTMENTS AND OFFICES
NO. 3 – PROPOSED AMENDMENT
NO. 4 – BIDS
NO. 4 – PROPOSED AMENDMENT
NO. 5 – LEASES OF CITY PROPERTIES
NO. 5 – PROPOSED AMENDMENT
NO. 6 – CONTRACTS
NO. 6 – PROPOSED AMENDMENT
NO. 7. – PERSONNEL RULES AND REGULATIONS
NO. 7 – PROPOSED AMENDMENT
NO. 8 – WHEN ACTIONS ARE TO BE TAKEN BY ORDINANCE
NO. 8 – PROPOSED AMENDMENT
NO. 9 – APPOINTIVE BOARDS AND COMMISSIONS
NO. 9 – PROPOSED AMENDMENT
NO. 10 – AM. 2 – VOTE REQUIRED FOR CERTAIN TYPES OF FACILITIES COSTING IN EXCESS OF $1M
NO. 10 – PROPOSED AMENDMENT
NO. 11 – AM. 1 – VOTE REQUIRED FOR CERTAIN TYPES OF BOND ISSUES
NO. 11 – PROPOSED AMENDMENT
NO. 12 – ELECTIONS FOR APPROVAL OF FRANCHISES
NO. 12 – PROPOSED AMENDMENT
NO. 13 – READING AND PASSAGE OF ORDINANCES AND RESOLUTIONS
NO. 13 – PROPOSED AMENDMENT
NO. 14 – FISCAL
NO. 14 – PROPOSED AMENDMENT
NO. 15 – SALE OF CITY PROPERTY
NO. 15 – PROPOSED AMENDMENT
NO. 16 – ORDINANCES AND RESOLUTIONS
NO. 16 – PROPOSED AMENDMENT
NO. 17 – CASH FUND SET UP; TRANSFER OF SUMS FROM CASH BASIS FUND TO OTHER FUNDS
NO. 17 – PROPOSED AMENDMENT
NO. 18 – POLICE COURT
NO. 18 – PROPOSED AMENDMENTS
NO. 19 – FAILURE TO VOTE
NO. 19 – PROPOSED AMENDMENT
NO. 20 – QUALIFICATIONS OF ELECTORS; REGISTRATION
NO. 20 – PROPOSED AMENDMENT
NO. 21 – CITY TREASURER
NO. 21 – PROPOSED AMENDMENT
NEXT STEPS
DIRECTION REQUESTED
 
Following discussion, Council gave direction to move forward with advancing all questions with the exception of Question 21 to the voters in November.
 
Ms. Saltzburg explained that staff will refine the ballot language and will be back before Council for final approval and to call the election.
             
15. Public Participation

None
             
16. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Councilmember Matthews reported that she toured the Wildcat Facility; it was very educational, a great biology lesson, and it was very helpful to understanding operations.
 
Councilmember Harris reported that she attended the Boys and Girls Club Kentucky Derby last Saturday. It was a great event and a lot of money was raised for kids for scholarships. She also reported that NAU is doing all their convocations on Thursday, May 11, 2023 and she encouraged Council to attend if possible. She also mentioned that it would be really helpful to do some training for boards and commissions; they need to better understand their roles, responsibilities, and duties.
 
Vice Mayor Aslan stated that he also attended the wastewater treatment plant tour; it was a great tour, and it was fascinating to see the equipment and all the infrastructure that goes into the wastewater treatment process. He also reported that he facilitated a meeting between NAH and Blocklite and is excited to hear more about that when things get firmed up. He requested the following two FAIR items:
 
A resolution to recognize the Baaj Nwaavjo I'tah Kukveni Grand Canyon National Monument.
 
A discussion about a pond next to Ponderosa Trails neighborhood between Pulliam and I-17.
 
Councilmember Sweet offered congratulations to all NAU graduates, and she recognized mothers in honor of Mother’s Day on Sunday. She also mentioned that Flagstaff’s Habitat for Humanity Starter Home Model was recently featured in a national magazine.
 
Councilmember House reported that she met with some history classes at NPA to discuss the history of housing in Flagstaff. She was impressed and amazed at how well-informed and how well-versed the students were on the future development of the community. She also attended the mobile Consulate event at Coconino Community College to represent the City Council and welcome community members. She also attended the Boys and Girls Club Kentucky Derby Event. Lastly, she called attention to Mental Health Awareness Week.
 
Mayor Daggett reported that there is an upcoming community meeting for the Museum and Schultz Fire flooding areas. She also reported that the Stream Stewards team will be doing their clean-up along the Rio de Flag on June 3, 2023.
             
17. Adjournment

The Work Session held May 9, 2023, adjourned at 8: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 07:39 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
282 ms 282 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
235 ms 235 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
235 ms 235 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
297 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 19:39:54.054
			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 @ 19:39:54.054
				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 @ 19:39:54.054
			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 @ 19:39:54.054
				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 @ 19:39:54.054
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 19:39:54.054
	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 @ 19:39:54.054
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:39:54.054
		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 @ 19:39:54.054
	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 @ 19:39:54.054
		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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
		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 @ 19:39:54.054
		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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:39:54.054
	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=31ms, Records=18) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:39:54.054
		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 @ 19:39:54.054
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
		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 @ 19:39:54.054
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 = 3763 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 19:39:54.054
		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) = 3763

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:39:54.054
			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(3763 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 @ 19:39:54.054
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3762 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=19) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
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 = 3762 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 = 938 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=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
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 @ 19:39:54.054
	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 @ 19:39:54.054
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
		
	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 = 938 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 938 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 @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19861 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19863 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12624 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19862 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19864 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12625 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19865 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19873 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12626 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19874 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12627 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19876 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12628 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19875 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12629 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19871 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12630 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19870 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12631 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19877 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12632 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19872 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12633 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19878 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12634 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19866 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19867 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12635 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19868 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:39:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 19:39:54.054
	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 @ 19:39:54.054
	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 @ 19:39:54.054
		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 @ 19:39:54.054
		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=3763
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=3763
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=9569464
cftoken=c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
hitcount=4
lastvisit={ts '2024-05-06 19:39:54'}
timecreated={ts '2024-05-06 19:39:54'}
urltoken=CFID=9569464&CFTOKEN=c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
Cookie Variables:
CFID=9569464
CFTOKEN=c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3763
Session Variables:
cfid=9569464
cftoken=c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9569464_c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
subdir=/public/
tzoffset=0
urltoken=CFID=9569464&CFTOKEN=c42fe7cb3f8d2f1d-29013126-F34F-B294-3F2F5126BEDA4F71
URL Parameters:
dsp=min
get_month=5
get_year=2023
id=
mt=ALL
seq=3763
Debug Rendering Time: 0 ms