Return
CITY COUNCIL WORK SESSION
TUESDAY, JANUARY 26, 2021
STAFF CONFERENCE ROOM AND MICROSOFT TEAMS
211 WEST ASPEN
3:00 P.M.

 

MINUTES
             
1.
Call to Order

Mayor Deasy called the Work Session of January 26, 2021, to order at 3:03 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
VICE MAYOR DAGGETT
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SALAS
COUNCILMEMBER SHIMONI
COUNCILMEMBER SWEET
ABSENT:












             
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.
  None. 
             
5.
Review of Draft Agenda for the February 2, 2021 City Council Meeting
Citizens wishing to speak on agenda items not specifically called out by the City Council may submit a speaker card for their items of interest to the recording clerk.
  None. 
             
6. Commission on Diversity Awareness Survey Presentation
  Human Resource Analyst Jessica Foos introduced Commissioners Dr. Jean Toner and Ms. DeAnn Wegwert who gave a detailed presentation to Mayor and Council on the findings of the survey done by the Commission on Diversity Awareness.
 
Mayor Deasy asked a few questions to Dr. Toner and Ms. Wegwert including if there were there any questions or commentary regarding any hard of hearing/deaf or blind individuals. Dr. Toner replied that there was at least one comment on the need of interpreters, and she added that most of the respondents focused on physical accessibility. Ms. Wegwert stated that there were comments on interpreters for ASL and in other languages for languages other than English and Spanish. Mayor Deasy asked why crosstab analysis was not available for the survey. Dr. Toner addressed the cost issues and stated that the commission will readdress the crosstab analysis cost. She added that the raw data is available and can be addressed at any time. Mayor Deasy offered his assistance on analyzing the data.
 
Vice Mayor Daggett expressed her appreciation for taking on the task of the survey and for presenting to Council on this issue.
 
Councilmember Sweet thanked the commission members for all their hard work and pointed out that housing is one of the major issues identified. She added that the Downtown Business Alliance is working on several cultural festivals and she was glad to hear that social media is an effective form of communication. She asked that the data be turned into actionable items for Council in the future.
 
Councilmember Shimoni thanked the commissioners for their work. He addressed that housing is the largest topic. He added that the city needs dense infill and combat the "not in my backyard (NIMBY) attitude.” He addressed the idea of Flagstaff becoming the new Aspen. He also addressed racism, the anti-racism committee (ARC), and having the committee bring their findings to the Commission. He would like to have another survey done on the City’s homepage. He asked City Manager Clifton if the ARC can work with the commission. City Manager Clifton stated that he will follow up.
 
Councilmember Salas expressed her gratitude to the commission and stated that the survey is very useful in terms of forming collaboration with other commissions and public entities. She added that Discover Flagstaff is working on a Green Book historical guide and that the survey could be applied to the Indigenous initiatives and the Indigenous Commission. She also stated that the survey could be shared with the County. She also volunteered to initiate an Asian-American cultural event once COVID has passed.    
 
Mayor Deasy stated his agreement with Councilmember Salas’ comments and expanded on his support of a food and cultural festival. He again offered his assistance with further analysis.
             
7. Community Development Division Introduction
  Community Development Director Dan Folke presented a high-level introduction to the Community Development division and introduced himself. His presentation included the following slides:
 
  • Mission Statement – they hope to refresh the mission statement this spring
  • Community Development departments and staff overview
  • Organizational chart
  • 2020-2021 Approved Budget
  • Division Accomplishments
  • Upcoming Initiatives 2021
 
Mr. Folke introduced Real Estate Manager Bryce Doty. Mr. Doty introduced himself and continued the presentation. Slides included:
  • Program Summary
  • 2021 Highlighting Current Projects
  • Mapping tool
  • Display of GIS information
 
Mr. Doty introduced Planning Director Tiffany Antol who continued the presentation to cover the Planning and Development Services. Slides included:
 
  • Four programs – introduced Building Official Amy Palmer, Comprehensive & Neighborhood Planning Manager Sara Dechter, Current Planning Manager Alaxandra Pucciarelli, and Zoning Code Manager Dan Symer.
  • Building Safety & Code Compliance
  • Code Compliance Enforcement Cases by Type and Origin
  • Code Compliance Lighting Standards Enforcement Impact Analysis
  • Building Safety by the Numbers 2020
  • Comprehensive and Neighborhood Planning
  • Comprehensive Planning
  • Census 2020 Outreach
  • Heritage Preservation
  • Neighborhood Planning
  • Current Planning Program
  • Current Planning Cases graph
  • Zoning and Subdivision Code Program
  • Zoning and Subdivision Code Work Program
 
Ms. Antol introduced Housing Director Sara Darr who continued the presentation. Slides included:
 
  • Housing Vocabulary
  • Area Median Income
  • City of Flagstaff Housing Programs
  • Housing Commissions
    • Housing Authority Board
    • Housing Commission
  • Budget – Housing Authority
  • Housing Authority
    • Three offices
    • Public Housing
    • Voucher Programs
  • Budget – Housing Section
  • Housing Section
  • Coming Attractions
 
Councilmember Shimoni asked about the funding for affordable housing. Ms. Darr stated that affordable housing is funded through internal funding. Dan Folke addressed the Incentive Policy Work and stated that it will be before Council this calendar year.
 
Vice Mayor Daggett asked Ms. Darr about vouchers, if the number of vouchers are set by HUD, and how a community gets additional vouchers. Ms. Darr stated that the number of vouchers is established by HUD and that it is rare for additional vouchers to be issued. Ms. Darr addressed special population vouchers and the mainstream vouchers but addressed that general Section 8 vouchers are rare and that there are currently 333 vouchers for the city.
 
Councilmember Shimoni asked Mr. Folke about NIMBYism and balancing it with dense infill. Mr. Folke stated that Community Development deals with NIMBYism regardless of the project and stated that Flagstaff has changed greatly in recent years. He spoke about the changes in zoning and gave his thoughts on how to change the views of people and the upcoming public education measures. Ms. Darr added her thoughts on successful "yes in my back yard (YIMBY)" campaigns on affordable housing and housing as community infrastructure. Councilmember Shimoni asked Mr. Folke about the outreach plan and shared thoughts on how to get more participation in public meetings. Mr. Folke stated that staff would welcome Councilmember Shimoni’s assistance and he addressed the success with the virtual neighborhood meetings.

Mayor Deasy called a fifteen minute break at 5:22 p.m. 
             
8. Update to the Comprehensive and Neighborhood Planning and Zoning and Subdivision Code Work Programs
  Mayor Deasy reconvened the meeting at 5:37 p.m.
 
Comprehensive and Neighborhood Planning Manager Sara Dechter and Zoning Code Manager Dan Symer gave a presentation for their annual update to Mayor and Council. Slides included:
 
  • 2021 Program Updates
    • Work session objectives
    • Order of Presentation
  • Comprehensive Planning Work Program
    • 2021-2022 Work Allocation
    • How are the recommended work priorities established?
    • Recommended Work Plan priorities
    • City Council Direction
 
Ms. Dechter pointed out that there will be a much more in-depth discussion about the regional plan at the March 16, 2021 meeting.
 
Tyler Denham addressed Mayor and Council and stated that the plan seems like a good opportunity for the City Council to honor its commitments from the affordable housing emergency resolution and climate emergency declaration. City Council should prioritize projects that increase the stock of dense, affordable housing in the city close to amenities, and deprioritize anti-housing projects.
 
Sat Best, representing the Conservation Study Forum, addressed Mayor and Council to speak about aspects of the regional plan. In 2017, they identified four conservation assets that were not well represented in the zoning code: seep and springs, wildlife corridors, rock outcroppings, and prairie dog colonies. Mr. Best stated that they feel that balancing the conservation aspects in the regional plan in the zoning code is important and they ask that the aspects in the work program make it through this year and incorporated into the zoning ordinance.
 
David Hayward, speaking as a private citizen, addressed Mayor and Council regarding the loss of the David Babbitt house and the historic districts. He asked that heritage preservation be prioritized.
 
Councilmember Shimoni asked Mr. Hayward about the communication regarding the demolition of the Babbitt House and if it was delivered late to the commission. Mr. Hayward stated that he did feel the information was received late in the process, but that communication is improving. Mr. Hayward stated that it is a new issue and it is not necessarily shown in the product by staff, but that many of the certified local governments have some prohibitions on demolition on historic properties, but that Flagstaff is lacking in that and that he would like to see reforms in the heritage preservation code. He added that the State Heritage Preservation Office provides grants to local governments to update their local code and to preserve and rehabilitate properties.
 
Councilmember Aslan asked Mr. Hayward if there was anything else he would like to see happen to prevent the loss of structures like the Babbitt house. Mr. Hayward replied that it is a difficult question but that the simplest answer is that priorities for staff are set now. He added that in the past, affordable housing was seen as a priority regardless of historical meaning. He stated that it is a matter of balance and that historic preservation needs to be considered when setting priorities. Councilmember Aslan also asked Mr. Hayward what his views on historic preservation when climate goals are taken into consideration. Mr. Hayward responded that the reuse of structures is a part of climate goals and that there is a balance needed between the high-density issue and historic preservation.
 
Mr. Symer resumed the presentation. Slides included:
 
  • 2021 Zoning Code Program Update
  • Zoning and Subdivision Code Work Program
    • 2020-2021 Work Allocations
    • Recommended Work Plan Priorities
    • City Council Direction
 
Councilmember Aslan asked Mr. Symer to maintain the joint land use study and the outdoor lighting amendment in Tier 1.
 
Councilmember McCarthy asked Mr. Folke if more manpower/staff is needed to get the priorities accomplished. Mr. Folke added that there was a reorganization a few years ago to process more amendments in smaller batches and spoke about the history of the positions. He added that he feels very supported by the budget planning team and the City Manager’s office.
 
Vice Mayor Daggett asked where Mr. Hayward’s comments would fit in with the priorities and how to ensure that code changes regarding historic preservation are incorporated as soon as possible. Mr. Symer stated that incorporating historic preservation would depend on how complicated Mr. Hayward’s amendment is and that he would need to do some more research to figure out what is needed.
 
Councilmember Shimoni spoke about student specific housing communities and asked how they are limited. Mr. Symer explained the activity centers that they are now limited to and the conditional use permits that are now required for them.
 
Ms. Dechter added some information about the opt-out system in the Southside neighborhood and how the opt-out plan is not the neighborhood’s preference.
 
Mayor Deasy echoed the Historic Preservation Commission sentiment regarding priorities and stated he supported moving historic preservation into Tier 2.
 
Councilmember McCarthy stated his preferences as well. .
 
Councilmember Sweet stated she should like to keep item D where it is and move item M over to Tier 2.
 
Councilmember Salas stated she supported moving item D to Tier 2 and item M to Tier 2.
 
Councilmember Shimoni asked Mr. Symer about the 45-foot building height and what the process would look like. Mr. Symer spoke about door-to-door public outreach and presenting at neighborhood meetings.
 
Councilmember stated that he supported moving heritage preservation is Tier 2 as did Vice Mayor Daggett and Mayor Deasy.
             
9. Fiscal Year 2021/2022 Budget Orientation for the Engineering & Capital Improvements Division and Active Capital Projects presentation featuring the Rio de Flag Flood Control Project
  City Engineer Rick Barrett gave a presentation to Mayor and Council to introduce the division. Slides included:
 
  • Organization Chart
  • Director’s Overview (4:31:27)
 
Councilmember Shimoni asked about community communication and public trust. He wanted to know if it was possible to set aside monies within projects to produce informative videos. City Manager Clifton spoke about adding videography in the budget that would cross all divisions in the City.  
 
Traffic Engineer Jeff Bauman introduced the Transportation and Engineering Section. Slides included:
 
  • Transportation Commission
    • Projects
    • Other projects
    • Bicycle and Pedestrian Advisory Committees
  • Transportation Engineering Studies
  • Transportation Operations
  • Transportation Engineering Development Review
 
Development Engineer Gary Miller gave an overview on the Development Engineering Section. Slides included:
  • Development Engineering
Construction Manager Angel Baca addressed Mayor and Council regarding Construction Inspecting & Testing.
 
Capital Improvement Engineer Bret Peterson addressed Mayor and Council regarding the Capital Improvement Section.
 
Senior Project Manager Christine Cameron presented a Rio de Flag update to Mayor and Council.
 
Mayor Deasy thanked the group for their presentation and their work on the Rio de Flag project.
 
Councilmember Shimoni asked Mr. Barrett about design standards and having a conversation about traffic mitigation and implementing them into the newly built roads. Mr. Barrett explained that the standards, funding sources, and the internal design review process.  
 
Councilmember McCarthy asked if the Lone Tree bridge will have pedestrian lanes and bike lanes and added that new projects should always have bike and pedestrian lanes in mind. Mr. Barrett stated that there will be bike and pedestrian lanes and that times have changed and led to the newest example like the Fourth Street Bridge. Councilmember McCarthy also addressed dedicated bus lanes.
             
10. Public Participation
  None.
             
11. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Vice Mayor Daggett thanked staff for their great work clearing snow and added a reminder to the public to clear sidewalks. She requested a quick presentation in the future on procedures on plowing streets and berms.
 
Councilmember Salas expressed her thanks to all staff, especially the police and fire departments, streets, and parks & recreation. She addressed Arizona Beer Month in February and requested staff look into HB 2418 filed by Tim Dunn on Economic Development Improvement Programs on how to attract capital investment to rural areas.
 
Councilmember Shimoni announced that the Indigenous Commission met and appointed two chairs: Joe Washington and Cora Phillips. He acknowledged Scott Overton, Andy Bertelsen, and streets staff for their work. He spoke about the Mountain Line Board meeting and thanked Councilmember Sweet for being a member. The then spoke about upcoming meetings.
 
Councilmember Sweet expressed her gratitude to the streets team.
 
Mayor Deasy thanked staff for their hard work and requested a FAIR item to hold a discussion regarding Mayor and Council compensation. He stated he would like to get pulse in regard of increasing or decreasing council salaries in light of current conditions.
 
City Manager Clifton responded to the request regarding residential snow plowing operations and said there will be a quick update in City Manager report. He added that he can also ask Streets Director Scott Overton to address item during that report.
             
12. Adjournment
  The Work Session of the Flagstaff City Council held January 26, 2021, adjourned at 9:21 pm.
   
_______________________________
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 18-Apr-24 04:37 PM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
150 ms 150 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
60 ms 60 ms 1 D:/inetpub/PublicPages/Application.cfm
60 ms 30 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
25 ms 25 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.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
210 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=60ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:37:46.046
			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 @ 16:37:46.046
				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 @ 16:37:46.046
			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 @ 16:37:46.046
				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 @ 16:37:46.046
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 16:37:46.046
	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 @ 16:37:46.046
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:37:46.046
		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 @ 16:37:46.046
	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 @ 16:37:46.046
		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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
		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 @ 16:37:46.046
		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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:37:46.046
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:37:46.046
		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-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2021-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 16:37:46.046
			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(1192 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 @ 16:37:46.046
	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 @ 16:37:46.046
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1191 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
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 = 1191 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 = 603 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
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 @ 16:37:46.046
	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 @ 16:37:46.046
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
		
	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 = 603 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 603 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 @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13912 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13917 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13910 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13911 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9206 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13913 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9207 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13921 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9208 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13920 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9209 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13919 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9210 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13922 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9276 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13915 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9255 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13914 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9256 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 13916 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:37:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9257 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 16:37:46.046
	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 @ 16:37:46.046
	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 @ 16:37:46.046
		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 @ 16:37:46.046
		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=1&get_year=2021&dsp=min&min=1192&ln=13921
HTTP_USER_AGENT=claudebot
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=1&get_year=2021&dsp=min&min=1192&ln=13921
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=9118218
cftoken=233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
hitcount=4
lastvisit={ts '2024-04-18 16:37:46'}
timecreated={ts '2024-04-18 16:37:45'}
urltoken=CFID=9118218&CFTOKEN=233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
Cookie Variables:
CFID=9118218
CFTOKEN=233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1192
Session Variables:
cfid=9118218
cftoken=233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9118218_233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
subdir=/public/
tzoffset=0
urltoken=CFID=9118218&CFTOKEN=233f5536da08b3d0-8397447E-C7C0-1E6B-B908913A3C843AB3
URL Parameters:
dsp=min
get_month=1
get_year=2021
id=
ln=13921
min=1192
mt=ALL
Debug Rendering Time: 16 ms