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

 
MINUTES
             
1.
Call to Order

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

MAYOR DEASY
VICE MAYOR SWEET
COUNCILMEMBER ASLAN
COUNCILMEMBER HOUSE
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SALAS
COUNCILMEMBER SHIMONI (virtually until 4:14 p.m.)
ABSENT:









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

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

LAND ACKNOWLEDGEMENT
The Flagstaff City Council humbly acknowledges the ancestral homelands of this area’s Indigenous nations and original stewards. These lands, still inhabited by Native descendants, border mountains sacred to Indigenous peoples. We honor them, their legacies, their traditions, and their continued contributions. We celebrate their past, present, and future generations who will forever know this place as home.
             
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
  Eric Wolverton, on behalf of Habitat for Humanity, spoke about their work and efforts toward housing attainability.
             
5.
Review of Draft Agenda for the June 7, 2022 City Council Meeting

None
             
6. Proclamation: National Gun Violence Awareness Day
  Council approached the podium and Mayor Deasy read and presented the proclamation to representatives from Moms Demand Action.
             
7. Proclamation: PRIDE Month
  Mayor Deasy read and presented the proclamation to representatives from the Commission on Diversity Awareness.
             
8. The Annual Update from Moonshot at the Northern Arizona Center for Entrepreneurship and Technology (NACET)
  Community Investment Director David McIntire provided a brief introduction and introduced Executive Director of Moonshot at NACET Diana White who provided a PowerPoint presentation that covered the following:
 
MOONSHOT AT NACET
A LOOK AT THE NUMBERS
MOONSHOT AT NACET CAMPUS TOTAL INVESTMENT FUNDS
MOONSHOT AT NACET CAMPUS TOTAL REVENUE GENERATED
JOBS
MOONSHOT AT NACET CAMPUS OCCUPANCY RATES AND NEW TENANTS
A LOOK AT A FEW MOONSHOT AT NACET EVENTS
3RD ANNUAL AZ PIONEER PITCH COMPETITION
THE 2ND ANNUAL SHOEMAKER
ENTREPRENEURSHIP INTERN CERTIFICATION
WE MEAN BUSINESS
 
Vice Mayor Sweet asked about the move down to the valley. Ms. White stated that during the pandemic, they realized Moonshot had a lot to offer other cities and communities for economic development. They acquired a number of new contracts, and it was imperative to expand their operations. They did not want to lose sight of their flagship community and felt it important to establish an Executive Director position to oversee the Flagstaff campus.
             
9. Regional Plan 2045 Collaborative Process Discussion
  Comprehensive Planning Manager Sara Dechter provided a PowerPoint presentation that covered the following:
 
FLAGSTAFF REGIONAL PLAN COLLABORATIVE PROCESS
TODAY’S PRESENTATION
OVERVIEW OF CURRENT PLAN
FLAGSTAFF REGIONAL PLAN 2030
PROCESS FOR UPDATING THE PLAN
THE NEXT REGIONAL PLAN
OUTREACH AUGUST 2021-APRIL 2022
UPCOMING PLANNING EFFORTS
FALL WORKSHOPS
SCENARIO PLANNING
COLLABORATIVE PROCESS OPTIONS
 
Councilmember McCarthy stated that the consultant should have an understanding of transportation and land use along with carbon emission implications. The biggest thing the Council can do to address carbon emissions is to lay things out correctly now for the future.
 
Councilmember House stated that the consultant should also have a history of outreach and communication with indigenous communities and all different groups that Flagstaff represents.
 
Mayor Deasy stated that Flagstaff is unique demographically and culturally and it will be important that all those elements are considered and attended to.
 
Ms. Dechter continued the presentation.
 
PLANNING FOR EQUITY
COMPENSATION FOR PARTICIPANTS
WAYS TO PARTICIPATE
 
Mayor Deasy stated that he would like to see the research and better understand the science on the efficacy of compensation on participation.
 
Councilmember McCarthy stated that he would like to have a cost estimate for participant compensation, he suggested that a better use of money might be being efficient in the meetings and quality facilitation.
 
Councilmember Shimoni stated that he finds the study circle approach interesting and looks forward to seeing what comes from them. He also stated that involvement and participation is a privilege and if they want to have a variety of involvement they should offer a compensation option.
             
10. Case No. PZ-22-00074: Request for a work session to discuss the Noble Herb’s proposed amendment to the Zoning Code to revise the existing hours of operation for Marijuana Dispensaries (Section 10-40.60.220.C).

Case No. PZ-22-00089: Request for a work session to discuss the City’s proposed amendment to the Zoning Code to address Marijuana Operations in the City of Flagstaff by updating terms and definitions to include recreation-only retail establishments (Section 10-80.20.130) and potentially revise the separation requirements for all Marijuana Operations (Section 10-40.60.220.F)
  Zoning Code Manager Tiffany Antol provided a PowerPoint presentation that covered the following:
 
AMENDMENTS TO THE ZONING CODE MARIJUANA OPERATIONS
MARIJUANA OPERATIONS
PZ-22-00074 MARIJUANA DISPENSARY HOURS OF OPERATION
PZ-22-00089 SINGLE RECREATIONAL SALES ESTABLISHMENT
CITY’S PROPOSED ZONING CODE TEXT AMENDMENT
QUESTIONS ASKED OF THE PLANNING & ZONING COMMISSION
 
Councilmember Shimoni asked if the separation distance was increased, how many facilities could be built within the city. Ms. Antol stated that it is difficult to pin down the exact number and it would also depend on how much further out they went from 2,000 feet.
 
Councilmember McCarthy stated that he is open to changing the hours of operation. He stated that a person with a marijuana conviction should not have an advantage over another person and he would support keeping things the way they are currently. He would also support some increase in the distance but not much.
 
Councilmember Shimoni stated that he has no concern with the change in hours, that he is okay with the current separations, and he is okay with the recreation equity license.
 
Mayor Deasy stated that he has no issues with the hours of operation, he is open to social equity licenses, and he would like a visual representation of the distances.
  A break was held from 4:27 p.m. through 4:42 p.m.
             
11. Fourth Street-Lockett Road-Cedar Avenue Roundabout Discussion
  Engineering Project Manager Jeremy DeGeyter provided a PowerPoint presentation that covered the following:
 
FOURTH STREET-CEDAR AVENUE-LOCKETT ROAD-ROUNDABOUT
PRESENTATION OUTLINE
PROJECT LOCATION
HIGHWAY SAFETY IMPROVEMENT PROGRAM (HSIP)
FINANCIAL IMPACT
PUBLIC OUTREACH
FOURTH/CEDAR/LOCKETT ROUNDABOUT
DECISION MATRIX SUMMARY
MULTILANE ROUNDABOUT
TURBO ROUNDABOUT
DUTCH BICYCLE PRIORITY ROUNDABOUT
TRAFFIC CIRCLE
PROTECTED INTERSECTION
MODERN ROUNDABOUT
8 MODERN ROUNDABOUT MYTHS
COMMON SITE APPLICATIONS
BENEFITS OF ROUNDABOUTS
SAFETY – REDUCE THE CONFLICTS
EXISTING CONDITIONS
PEDESTRIAN SAFETY
BICYCLE USE – THE BASICS
BICYCLE RAMPS
BICYCLE PAVEMENT MARKINGS
CONCEPTUAL BICYCLE PAVEMENT MARKINGS
BIKES AND PEDESTRIANS
AUTO/BUS/TRUCK OPERATIONS
DESIGN VEHICLES – BUSES AND TRUCKS
SCHOOLS AND ROUNDABOUTS
EDUCATIONAL ENGAGEMENT
NEXT STEPS
 
The following individuals addressed Council regarding the project:
  • Erica Martin
  • Adrianne Rhode
  • Johanna Payton
  • Cindy Roe
  • Bernadette Whistler
  • Delaney Williams
  • Michelle James
The following comments were received:
  • The intersection can be made safe but a roundabout is not the solution.
  • The project is way over budget and can be done in a less expensive way.
  • The intersection needs to be reduced in speed.
  • The roundabout will back up traffic even more.
  • Citizens need more time to review the project.
  • The lower right turn lane should be removed because the students at Pine Forest school will be negatively impacted.
  • A single lane, circular roundabout is more appropriate.
  • The kids will get confused with the multiple islands they need to use to cross.
  • Kids will have to stop three times to get across Cedar.
  • There is a lot of foot traffic in this area that needs to be considered.
  • Pine Forest school should get to keep their playground.
  • Construction of this project will have a negative impact on enrollment for Pine Forest school.
  • Traffic flow should come second to walking children.
  • The roundabout is not safe for students, improvements should be made to what is already there.
  • Vehicles should be forced to slow down.
  • The design must consider pedestrian and cyclist safety, they need the higher priority.
The following individuals submitted written comments concerning safety of the roundabout:
  • Mar-Elise Hill
  • Brandon Cruickshank
  • Rachel Williams
Vice Mayor Sweet stated that the traffic engineers have put in countless hours with the project and to assume that staff would not have the best interest of everyone at mind, especially kids is offensive. These individuals are professionals with the knowledge and expertise necessary to design and build these types of projects. The city has the funding and the opportunity to make the intersection safer.
 
Councilmember McCarthy stated that the intersection in its current design is not safe and needs to be changed. He supports the current design but suggested making all of the crosswalks z-crossings. He also suggested a signalized crossing on all crossings where the pedestrian will trigger a light that warns drivers that pedestrians want to cross.
 
Mr. DeGeyter stated that they are a little constrained on the Lockett entrance and exit. The center island would have to be increased which would straighten the lane which speeds up traffic. They were able to accomplish the Z crossings at the other three crossings. The footprint is the important part, if they change any of the things that impact the footprint, there will be a redesign which will impact legal descriptions and negotiations with property owners.
 
Councilmember Shimoni asked about the cost for beacons at the four intersections. Traffic Engineer Jeff Bauman stated that they have not evaluated the cost for all the legs, but they are estimating a quarter million for each leg.
 
Councilmember Shimoni stated that there are a number of schools in the area and in reviewing roundabouts around schools all were one lane and easy to navigate, he asked why a single roundabout was not used and suggested that the engineers adjust the angles from Lockett to Cedar and make the curves sharper. Mr. Bauman stated that they have gone through an extensive process with the design. It starts with a circle and moves from there based on the types of vehicles passing through like buses, semis, etcetera and the speed reductions desired. It is not as simple as bumping a curb out in one section because that may impact the ability for a truck or bus to get through. They feel very good about the design and the speeds. They have heard from cyclists that they did not like the z-crossings so they are trying to balance all the needs. It is a complex system of curves and modifications are challenging.
 
Mayor Deasy asked about the grading of roads and what City Code requires. Mr. Bauman explained that a grade D or better is what is required. This is the same standard that ADOT requires as well.
 
Councilmember Aslan expressed support of the modern roundabout concept and the z-crossings where possible. He is satisfied that the entire intersection will be wired for beacons should there be a need for them in the future.
 
Councilmember House voiced her support for the z-crossings and beacon lights.
 
Councilmember Shimoni stated that he would support installing the beacons now rather than waiting to see if they are needed in the future. He still has concerns about safety and will not support moving forward with the project.
 
Councilmember Salas stated that the main essence of the roundabout is the safety of children and residents. The roundabout is meant to improve safety, slow speeds, and reduce accidents. The project has been supported and identified in the MetroPlan improvement project. There were experts from the city, the state, and Metroplan who have been the backbone of the project. She supports the beacons for the crosswalks and would advocate for additional state and federal funding to help support those additions.
 
Vice Mayor Sweet expressed support for the project moving forward.
 
Mayor Deasy asked why elevated cross walks were not considered. Mr. Bauman stated that they are not preferred in the area due to snow removal and drainage impacts.
 
Mayor Deasy stated that he was supportive of the z-crossings. He believes that as designed, the new crossing will be safer than what is existing currently.
 
Mr. Clifton stated that a follow up discussion will be forthcoming to discuss the cost feasibility of the z-crossing and the beacons at the four legs of the intersection. Mr. DeGeyter added that staff needs to go back to the design consultants to determine if they can incorporate these things and what the impacts are. This could trigger a needed amendment to the IGA which includes another discussion with Council.
  A break was held from 6:30 p.m. through 6:41 p.m.
 
Councilmember Shimoni left the meeting and rejoined virtually for the remainder of the meeting.
             
12. Museum Flooding and Spruce Wash updates
  Public Works Director Scott Overton, Parks Manager and Interim Recreation Director Amy Hagin, Management Services Director Rick Tadder, Water Services Engineering Director Gary Miller, Stormwater Manager Ed Schenk, Lucinda Andreani, on behalf of the County Flood Control District, and Public Affairs Director Sarah Langley collectively provided a PowerPoint presentation that covered the following:
 
FLOOD MITIGATION UPDATES
AGENDA
COMMUNITY VOLUNTEER EVENT
MUSEUM FLOOD FINANCIAL FOCUS GROUP
DFFM-FUNDED RESOURCES
CEDAR TO DORTHA CHANNEL AND INLET
KILLIP SCHOOL REGIONAL DETENTION BASIN
KILLIP INLET AT PONDEROSA PARK
PONDEROSA PARK BARRIERS
2021 RESPONSE UPDATE
ON FOREST MITIGATION
NRCS MOUNT ELDEN ESTATES FAN
SIREN ALERTING SYSTEM
SPRING 2022 SANDBAG REFRESH
VOLUNTEER/SERVICE COORDINATION
 
Mr. Clifton gave a few comments about the City Manager Volunteer Challenge for city staff.
 
EMERGENCY OPERATIONS RESPONSE
COMMUNICATIONS
 
Dawn Rodriguez addressed Council about flooding concerns.
 
Mayor Deasy stated that while he was at Ponderosa Park he wondered if there might be a way for kids to use the barriers there for artwork to brighten things up. Parks Director Amy Hagin stated that it is a great concept that they will look into.
             
13. Public Participation
  Raymond Kim addressed Council about the housing situation in Flagstaff. Short term rentals are causing a lot of problems and because people cannot live in Flagstaff they live farther out and commute in. This commuting contributes to the negative impacts on the environment.
             
14. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Vice Mayor Sweet reported that she toured the Carpenters Union training facility in Phoenix which was informative. She reminded everyone that Saturday is the annual Hullabaloo event in Wheeler Park.
 
Councilmember Aslan requested a FAIR item to receive an update from the Police Department about protocols and training and to make the public aware of those efforts.
 
Councilmember House reported that she toured High Country Humane last week to see all the great work they are doing. She also attended the Housing Commission meeting; they are struggling to fill three seats on the commission so if there are people who want to serve on the commission please encourage them to apply.
 
Councilmember McCarthy stated that he attended a very moving Memorial Day celebration on Monday.
 
Councilmember Shimoni reported that there is a Recovery Court graduation ceremony that week. The Transportation Commission will be meeting on Wednesday. He also noted that it has been one year since the crash and fatality of the bike party, he reminded everyone that there is still a lot to do to become a bike friendly community.
 
Mayor Deasy recommended that Council attend a Recovery Court graduation, they are a great event to see. He also reported that there is a two-spirit day conference at Twin Arrows later that week. He will also be visiting the Assistant Secretary of Economic Development.
             
15. Adjournment

The Work Session of the Flagstaff City Council held May 31, 2022, adjourned at 7:47 p.m.
 
                  
___________________________________
MAYOR
  ATTEST:

 
 
  _________________________________
CITY CLERK
 

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 14-May-24 02:17 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
234 ms 234 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 02:17:48.048
			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 @ 02:17:48.048
				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 @ 02:17:48.048
			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 @ 02:17:48.048
				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 @ 02:17:48.048
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 02:17:48.048
	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 @ 02:17:48.048
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:17:48.048
		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 @ 02:17:48.048
	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 @ 02:17:48.048
		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 @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
		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 @ 02:17:48.048
		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 @ 02:17:48.048
	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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:17:48.048
	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=16) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:17:48.048
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2022-05-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2022-05-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:17:48.048
			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(3489 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 @ 02:17:48.048
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3488 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
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 = 3488 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 = 934 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
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 @ 02:17:48.048
	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 @ 02:17:48.048
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=32ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
		
	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 = 934 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 934 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 @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19787 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19785 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12575 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19792 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19786 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12576 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19788 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19799 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12577 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19800 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12578 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19796 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12579 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19794 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12580 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19795 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12581 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12582 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19797 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12583 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12584 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19798 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12585 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19790 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12586 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19789 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12587 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 19791 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:17:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:17:48.048
	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 @ 02:17:48.048
	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 @ 02:17:48.048
		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 @ 02:17:48.048
		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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=5&get_year=2022&dsp=min&seq=3489
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=5&get_year=2022&dsp=min&seq=3489
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=9764781
cftoken=a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
hitcount=4
lastvisit={ts '2024-05-14 02:17:48'}
timecreated={ts '2024-05-14 02:17:48'}
urltoken=CFID=9764781&CFTOKEN=a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
Cookie Variables:
CFID=9764781
CFTOKEN=a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3489
Session Variables:
cfid=9764781
cftoken=a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9764781_a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
subdir=/public/
tzoffset=0
urltoken=CFID=9764781&CFTOKEN=a3f87be2ba2df171-9FB0A39E-F95D-2821-C3EF686793F4B5C5
URL Parameters:
dsp=min
get_month=5
get_year=2022
id=
mt=ALL
seq=3489
Debug Rendering Time: 0 ms