Return
CITY COUNCIL SPECIAL MEETING
MONDAY, APRIL 26, 2021
CITY HALL STAFF CONFERENCE ROOM
211 WEST ASPEN
 5:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Deasy called the Special Meeting of the Flagstaff City Council held April 26, 2021, to order at 5: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. Pledge of Allegiance and Mission Statement

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

MAYOR DEASY (virtually)
VICE MAYOR DAGGETT (virtually)
COUNCILMEMBER ASLAN (virtually)
COUNCILMEMBER MCCARTHY (virtually)
COUNCILMEMBER SALAS (virtually)
COUNCILMEMBER SHIMONI (virtually)
COUNCILMEMBER SWEET (virtually)
ABSENT:









  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
             
4. Consider and approve this Special Meeting agenda as posted.
  Moved by Councilmember Adam Shimoni, seconded by Mayor Paul Deasy to approve the Special Meeting agenda as posted.
  Vote: 7 - 0 - Unanimously
             
5. Budgeting and Operational Considerations for Policing and Social Service Alternatives
  Mayor Deasy thanked Council for the opportunity to have the discussion. He stated that there is no formal presentation for the topic, rather it is a way to open the dialogue with the community for them to voice their opinion.
 
Mr. Clifton stated that staff included materials in the agenda packet that provide a timeline presentations from last year, along with the presentation materials that were provided by staff in response to the FAIR items.
 
The following individuals addressed Council asking for the Police Department budget to be reduced or defunded:
  • Victoria Monsaint–Queeney
  • Harper Rowan
  • Joanna Wheaton
  • Steve Eberly
  • Sarah Andrews
  • Jasmine Mueller-Hsia
  • Whitney Holeva-Eklund
  • Kyle Nitschke
  • Erin Hiebert
  • Emily Davalos
  • Mandy Gebler
  • Lydia Bailey
  • Summer White
  • Kelly Wilson
  • Hannah Lee
  • John Viktora
  • Rachel Russ
  • Jessi Quizar
  • Yisha Ng
  • Nina Porter
  • Dr. Michael Caulkins
  • Barry Bertani
  • Sarah-Grace Crocco
  • Deirdre Conroy
  • Darrell Marks
  • Morgan Murray
  • Nora Timmerman
  • Carmenlita Chief
  • Linda Bianciotto
  • Christi Weigand
The following comments were received:
  • The police harass unsheltered people.
  • Only 3.5% of arrests are related to violent crimes.
  • Support defunding the police budget by 55%.
  • Reallocate funds to affordable housing and education.
  • Flagstaff citizens can govern themselves.
  • Allocate funding to other priorities.
  • Flagstaff is not immune from negative police experiences.
  • Flagstaff needs housing, not handcuffs.
  • There is a nationwide pattern of violence against black and brown people.
  • Flagstaff has a shoot and kill rate two times higher than the national average.
  • Community centers could be developed with funding from the police department.
  • Reduce the budget a move toward alternate response models.
  • Funding of the police department does not solve the underlying issues.
  • Homelessness and social inequities suppress the most vulnerable in the community; fund social services instead of pushing them into the criminal justice system.
  • Flagstaff criminalizes homelessness.
  • The police have the impression that there will be less support if defunded, that is not true, it means they would have less calls to attend to.
  • Police do not stop crime, they only respond.
  • Reallocate funding to better housing options, mental health intervention, and substance abuse support.
  • Tyler Stewart would still be alive if there had been a defunding because there would have been a mental health intervention.
  • Defund and consider models in other cities that use unarmed social workers.
  • There are better models to take pressure off police who are not trained to respond to mental health emergencies.
  • People armed with fatal weapons does not make the community safer.
  • Invest in prevention instead of punishment.
A break was held from 7:20 p.m. through 7:30 p.m.
 
The following individuals addressed Council in opposition to defunding or reducing the Police Department budget:
  • Jennifer Brown
  • Thomas Bianciotto
  • Michael Oliver
  • George Holberg
  • Steve Finch
  • Justin Youngman
  • Destiney Evans
  • Dixie Callan
  • Gwin Filleman
  • Laryssa George
  • Anthony Garcia
  • Sheena White
  • Susana Tovalin
  • Rachel Bellar
  • Michael Rhodes
  • Morgan Mo
  • Erin Marostica
  • Jerry Whalen
  • Ann Ingram
  • Debbie Eberhardt
  • Tyson Oliver
The following comments were received:
  • Flag Stats provides skewed and inaccurate information.
  • Reduced funding jeopardizes citizen safety.
  • By defunding, we would destroy all we have worked for to have a professional department.
  • Defunding will drive away good cops who truly love our community; they deserve way more.
  • There is more work to do but dismantling police funding is a misguided concept that has been hoisted upon our society.
  • Nearly all incidents are a result of non-compliance, perhaps more public outreach that emphasizes compliance.
  • The department is already severely limited, there is no need to defund, if anything give more funding for training and recruiting quality officers.
  • Defunding will take back up response away from officers.
  • Officers will quit and the community will suffer even more.
  • The Flagstaff Police Department has nothing but the utmost respect for their community.
  • Without officers we would have complete chaos.
  • This is the worst time ever to even consider defunding.
  • Things can be done better on both sides, defunding is not the answer.
  • Increase funding to for competitive pay, increased training, and more tools and resources to keep them and the community safe.
  • The police use discretion and it is the type of discretion that is needed.
  • More resources for mental health and alternate response is great, just not at the expense of the police department.
  • The Flagstaff Police Department is an asset to the community.
Written comments in support of defunding or reducing the Police Department budget were submitted by the following:
  • Deirdre Conroy
  • Meredith Brown
  • Kurt Eklund
  • Abigail Gripman
  • Mandy Gebler
  • Ben Rosenstein
  • Eric Dovigi
  • Matthew DuPont
  • Claire Hardi
  • Nicole Cuaz
Written comments in opposition of defunding or reducing the Police Department budget were submitted by the following:
  • Lisa Fozz
  • Amber Abbott-Farr
  • Jamie Bellar
  • Bill and Pamela Ashland
  • Nik Christian
  • Alan St. Germain
  • Mike Dunn
  • Sharon Sifling
  • Nicole Rupe
  • Heather Valenzuela
  • Kris Dee Faith
  • Dave and Linda Seitz
  • Matt Hill
  • Patrick Ahern
  • Karen Butterfield
  • Janet Wessels
  • Tanner Callan
  • Ann Ingram
  • Michael Hays
  • Jo OConnell
  • Barbara and John Church
  • Carolyn Potter
  • Shalome Almueti
  • Beau Wilson
  • Elizabeth Mccassalin
  • Brenda Silveus
  • Gail Van Deurzen
  • Joshua Wear
  • Rebecca Cullum
  • Marilyn Overend
  • Rick Lopez
  • Patty Williams
  • Alfredo Villa
  • Lori
  • Kortney Stock
  • Clint and Gillian Bleeker
  • Rebekah Zink
  • Julie Smith
  • Doug Townsend
  • Kaylee Sandall
  • Dr. Sarica Cernohous
  • Ben Heap
  • Jennifer Prior
  • Stephen Randazzo
  • Jana Hester
  • Larry and Patty Gibbs
  • Kellianne Fox
  • Michelle Boyer
  • Dr. Jay Laura
  • Rachel Williams
  • Neal Kenmore
  • Manuel Martinez
  • Levi and Elizabeth Brooks
  • Steven and Lindsey Strum
  • Cooper Heap
  • Kathryn Heap
  • Rylie Hatch
  • Kristi Hatch
  • Eric Carlson
  • Sherry Phillips
  • Jennifer Graff
  • Kevin Plotz
  • Rachel Worley
  • Dave and Linda Seitz
  • Scot and Anita Porter
  • John Tewes
  • Jennifer Frank
  • Doug Hatch
  • Kevin Treadway
  • Andy Caird
  • Todd Martinet
Mayor Deasy stated that police are overworked, and he would like to see police responding to less calls. The Council took the first step in funding an alternate response model, but it is not enough to reduce the calls to the police department. He would like to see a system created where behavioral health specialists respond to behavioral health calls.
 
Councilmember Aslan stated the police will continue to be on hand and available nearby even when there is an alternate response model up and running. Officers will also continue to be on hand during fire and medical department calls so they can focus on the patient and not on the surrounding scene. He is supportive of continuing the conversation about alternate response models, but it is an evolution that needs a local focus. There needs to be an evaluation of the success of these programs in the community before any drastic measures are taken. The Flagstaff Police Department is already understaffed, under paid, and they are losing officers to other higher paying municipalities. Better resources are needed for the department and he is not interested in defunding.
 
Councilmember Salas stated that the purpose of law enforcement is to promote public safety and uphold the rule of law so individual liberty can flourish. She is opposed to any reduction in funding or services from the police department. She believes that community policing programs such as Block Watch and Weed and Seed should be reinstated and properly funded. Reducing funding for the Police Department is not the solution to achieving the change that is sought by concerned and frustrated members of the community in response to their concerns over rogue police actions outside Flagstaff.
 
She stated that the issues in the criminal justice system extend beyond the behavior of police officers. Over the years, reductions in state and federal budgets have slashed funding for mental health services, homelessness, substance abuse and recovery services; offender re-entry programs; educational and vocational training opportunities; and programs that promote economic improvement. Police officers have had to fill this void placing them in difficult situations. There is a need to provide additional resources to social services, education, housing, and mental health services. Fulfilling these needs should not come at the expense of police funding, but rather, provide additional resources given to these areas, and seek funding support from state and federal agencies.
 
Councilmember Shimoni stated that there is a large population who are disenfranchised from government and it is Council’s responsibility to represent them too. The relationship with Flagstaff’s indigenous neighbors and people of color has been damaged. There have been promising discussions about funding the alternative response model but there is just not enough funding available and the police budget is not immune to the conversation. Housing is a big issue and it is a better investment to put people into housing rather than spending so much on responding to their crimes time after time. More tools are needed to address community issues.
 
One of the things he would like to see addressed is the level of service. There are a lot of calls that officers are responding to that are not high priority and other agencies do not respond to similar types of calls. For the wellbeing of officers there needs to be a discussion about reducing the level of service on non-emergency calls. He would also like to address issues at their core rather than continuing to invest in more policing. He feels that having a community response team that can respond to calls rather than police can get people connected to services rather than putting them into the criminal justice system. He is open to a diversion and reallocation of funds; 10% could go a long way in funding solutions.
 
Councilmember Sweet stated that the Police Department needs additional resources and an alternate response model; they also need a morale boost and help bridging the staffing gap. Funding for those things does not come at the expense of the police, funding should be provided but it needs to be found elsewhere.
 
Vice Mayor Daggett stated that she is eager to see what an alternate response model can accomplish; responding to calls with compassion, providing access to social services and housing, and keeping people out of the criminal justice system are all good things. Working to address the housing issue is critical, as is mental health care. Not everyone is treated with the same level of respect or equity and that is a community wide problem that needs to be addressed. She stated that she would like to have staff come forward with funding options to consider and discuss.
 
Councilmember McCarthy stated that it is a polarized issue. He supports the alternate response model and providing funding, but he does not support defunding the Police Department as a mechanism to do so. He is not comfortable with reducing levels of service.
 
Mr. Clifton stated that the alternate response model has been evaluated, discussed, and vetted by many groups. The pursuit of this was prompted by a well-articulated need independent of the defunding the police discussion. A program will take time to mature and many things cannot be implemented on day one. Things will evolve over time and it will take time, growth, and revision. The funding resources are proposed to be derived from multiple sources including the general fund, the recreational marijuana tax revenues, as well as some COVID relief funding.
 
Management Services Director Rick Tadder presented a brief PowerPoint presentation on the budget proposal for the alternate response model.
 
ALTERNATE RESPONSE FOLLOW-UP
FUNDING OF ALTERNATE RESPONSE UNIT
 
Mayor Deasy stated that even with the identified funding they are still not taking the weight off police officers nor taking any calls away from them. Right now, the department is understaffed by 13 positions and ten officers are interviewing in other districts which could present a 20-plus position shortfall. There are not enough recruits to fill those positions, yet the department is allocating dollars to positions that cannot be filled. He suggested that the vacant positions be filled with social workers and behavioral health specialists instead of officers.
 
Chief Musselman stated that he is optimistic that alternative response can help reduce some of the call volume but not by a lot. The police were called to respond to 855 medical call assists, 145 calls from crisis lines, and over 600 calls for service at the shelter. Terros came on board in November to help with low level mental health calls and there were 1,300 calls but they were only able to respond to 27 alone with the others requiring a police response due to safety concerns. He is concerned about putting social workers and behavioral health specialists in situations where they could get hurt.
 
Councilmember Shimoni asked if calls for service decreased with the unsheltered populations being housed in hotels during COVID. Chief Musselman stated that arrests did go down. Councilmember Shimoni stated that getting people into housing is key and even though there is not Council support for utilizing the police budget there needs to be continued movement to find solutions to housing unsheltered people.
 
Mayor Deasy stated that many of the models implemented elsewhere show a 20% decrease in call volume when fully funded. Not every call will become violent and he has a hard time believing that police need to respond to all calls because something might happen. He stated that a consultant or policy expert is needed to evaluate what it would take in Flagstaff, how to get there, and the dollars needed.
 
Councilmembers Aslan and McCarthy stated that they cannot make a decision on something like a consultant until they have an understanding on cost and scope. Councilmember Shimoni stated that NAU’s Criminal Justice Department could look at it and fund solutions.
 
Mr. Clifton noted that a request for proposals (RFP) was submitted and proposals are currently being evaluated. Mayor Deasy stated that the RFP was unspecific and did not include a desire to reduce call volume. Deputy City Manager Shannon Anderson stated that call volume was addressed in the RFP and it included a reduction in both police and fire calls. The RFP and scope of work was written in general terms because each responder has their own model and staffing components; they did not want to discourage any sort of response to the RFP. The responders have provided measurements, reporting, and other statistical data so while the scope was broad, the responses have been very specific and addressed how they would help the city response to law enforcement and fire related calls.
 
Mayor Deasy stated that he was informed that the responses from the RFP would not decrease the call volume. Ms. Anderson offered that what they have seen from other models is that it takes time for the systems to be put into place and for people to know that they can call them, rather than the police, for service.
 
Vice Mayor Daggett asked when it is expected that the committee will select a response and bring it forward to Council. Ms. Anderson stated that the team is scheduled to have interviews with the respondents on May 12, 2021 and May 14, 2021. The goal of the interviews is to clarify information in the responses, so the team accurately understands what they are reading and evaluating. If they are able to select a respondent after those interviews, they could come back to Council with a contract soon after knowing that funding has been identified.
 
Councilmember Shimoni stated that more information about Ithaca’s efforts can be found at https://www2.tompkinscountyny.gov/ctyadmin/reimaginepublicsafety. He encouraged the Council, staff, and the public to look at the information.
 
Councilmember Aslan stated that it is evident that it will be very hard to reduce the number of situations where police are not showing up to a scene and that should not be the goal. The goal is that while they are there, they are in a background keeping a low profile to allow the experts to do the work they need to do while ensuring scene safety. The goal is to create a new interface for community situations to avoid escalation that can happen. This is something that will change slowly over time. Looking at other places like Ithaca or Eugene, the programs take years to develop with a lot of trial and error involved. Taking police funding to hire social workers is not going to change the number of calls police must respond to.
 
Mayor Deasy stated that only incremental changes will happen when that is all that is believed to be able to happen. After all this time they are doing nothing more than what they were doing before.
 
Mr. Clifton acknowledged that the process moves slowly but to remember that they are building an institution and a change in how things are done. A year ago there was not a single dollar allocated toward alternative response and now a year later significant resources have been allocated. It will take time and they will have to learn and adapt from the successes and failures that will come along the way.
 
Mr. Solomon expressed appreciation for the discussion and noted that the Council should be aware that there will need to be a significant amount of legal research, vetting, and training to go along with implementation and as the program progresses. As has been discussed, things take time but staff is ready to take on the work as directed by Council.
 
Mayor Deasy thanked the public, Council, and staff for their participation in the meeting. He stated that it was good discussion with good commentary from the public.
             
6. Adjournment

The City Council Special Meeting held April 26, 2021, adjourned at 9:44 p.m.
   
  _______________________________
MAYOR
ATTEST:
 
 

_________________________________
CITY CLERK
 


CERTIFICATION

I, STACY SALTZBURG, do hereby certify that I am the City Clerk of the City of Flagstaff, County of Coconino, State of Arizona, and that the above Minutes are a true and correct summary of the Meeting of the Council of the City of Flagstaff held on April 26, 2021. I further certify that the Meeting was duly called and held and that a quorum was present.
 
DATED this 7th day of September, 2021.           
 
________________________________
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 03-May-24 09:58 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
265 ms 265 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
204 ms 204 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
46 ms 46 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
265 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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58:54.054
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 21:58: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 @ 21:58:54.054
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=15ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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 @ 21:58: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) = 2021-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2021-04-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 21:58:54.054
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
		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 @ 21:58: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 = 1261 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 21:58: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) = 1261

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 21:58: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(1261 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 @ 21:58:54.054
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1260 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 = 1260 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 = 642 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=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 @ 21:58: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 @ 21:58:54.054
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 = 642 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 = 642 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
allMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
			   motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 642 AND
			  motion.rev_num = 0 AND
		 	  motion.motion_status <> 'VERBIAGE'
			  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	
allVotes (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type, c3.long_descr vote_label,
			   v.seq_num sort1,	
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote)
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		WHERE v.form_num = 642 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1							
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14672 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14672 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14675 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14675 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14671 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14671 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 @ 21:58:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9741 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14677 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14677 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3396 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 14677 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 14677 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 21:58:54.054
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 21:58:54.054
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14673 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14673 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 @ 21:58:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9910 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14674 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58:54.054
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 14674 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 21:58: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 @ 21:58: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 @ 21:58:54.054
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 21:58: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 @ 21:58: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=4&get_year=2021&dsp=min&seq=1261
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=4&get_year=2021&dsp=min&seq=1261
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=9494774
cftoken=cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
hitcount=4
lastvisit={ts '2024-05-03 21:58:54'}
timecreated={ts '2024-05-03 21:58:54'}
urltoken=CFID=9494774&CFTOKEN=cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
Cookie Variables:
CFID=9494774
CFTOKEN=cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1261
Session Variables:
cfid=9494774
cftoken=cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9494774_cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
subdir=/public/
tzoffset=0
urltoken=CFID=9494774&CFTOKEN=cb15b2ed382fbbf0-937E261E-AE96-2429-152F55BA69B7A9DA
URL Parameters:
dsp=min
get_month=4
get_year=2021
id=
mt=ALL
seq=1261
Debug Rendering Time: 0 ms