Return
CITY COUNCIL WORK SESSION
TUESDAY, JUNE 11, 2019
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
 6:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Evans called the Work Session of the Flagstaff City Council held June 11, 2019, to order at 6:00 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 Whelan 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 EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
ABSENT:









  Others present:  City Manager Barbara Goodrich; City Attorney Sterling Solomon
             
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.
  Dennis Lavin addressed Council asking for them to consider electing City Councilmembers by district. He expressed concern about the parking situation at the airport. He also indicated that it is time to consider a pay raise for members of the City Council.
 
Christina Caldwell with the Arizona At Work Business Services Team addressed Council providing information about the organization and their work with public safety agencies.
 
Rick Lopez addressed Council about concerns with the building code adjustments and their impact on the cost of entry level and workforce housing.
             
5.
Review of Draft Agenda for the June 18, 2019 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.
  Vice Mayor Shimoni noted that the e-bike conversation is the last item on the agenda and he is concerned that it will be too late and many people in the public may not be able to stay that late. Mayor Evans stated that she requested the item be moved from the 4:30 p.m. agenda to the 6:00 p.m. agenda and apologizes that it is the last item.
             
6. Discussion of proposed Ordinance No. 2019-24 prohibiting the sale of tobacco to persons under the age of 21.
  Mr. Solomon addressed Council stating that the proposed ordinance will limit the sale of tobacco products to those over 21. He indicated that there are a number of enforcement elements within the ordinance and he is looking to Council for any direction on the proposed ordinance in advance of presenting it at a voting meeting.
 
Vice Mayor Shimoni asked about the incentives to enforce the measure to local businesses. Mr. Solomon stated that there would be fines for violations or infractions. Those fines would be civil in nature and would increase incrementally. Each time an infraction occurs in a period of time there will be higher fines and licensing repercussions. The ability to sell tobacco products will be dependent upon compliance and non-compliance could lead to a suspension of their license for up to 36 months.
 
Councilmember Aslan asked about recent bills at the state level that may supersede what the City is trying to do. Mr. Solomon stated that legislation was proposed and what passed did not preempt cities and towns from raising the age.
 
The following individuals addressed Council in favor of limiting sales of tobacco products to people over 21.
  • Emily Blink
  • Anastacia Dougi
  • Karime Arce-Romero
  • Hunter Owens
The following comments were received:
  • 84% of tobacco users began before the age of 18.
  • Most high school students aged 13-17 know an 18 year old who can purchase tobacco products for them; it is less likely that they would have friends over the age of 21.
  • T21 can prevent the initiation and lifelong addiction to nicotine.
  • The ordinance could have a significant impact on tobacco use among students.
  • Not a single store has gone out of business as a result of a T21 ordinance.
  • T21 can help tobacco retailers distinguish proper identification because vertical identification cards would not be permitted to purchase alcohol or tobacco.
  • The minimum age of military service does not equate to the readiness to enter into a lifetime of addiction.
  • We have raised the age of drinking to 21 and that contributed to a reduction in drunk driving accidents.
  • 14 states and 475 counties in 25 states have some sort of T21 legislation.
  • T21 has been established in Douglas and Cottonwood.
  • Many young people believe tobacco use is a significant issue in Flagstaff.
  • CATS and ASAP (youth organizations) both want to help provide training and services to any retailer.

The Council thanked the individuals who spoke and provided direction to bring forward the ordinance at a regular meeting for a vote.
             
7. Rio de Flag Flood Control Project - Update
  Project Manager Trevor Henry provided a PowerPoint presentation that covered the following:
 
CITY OF FLAGSTAFF RIO DE FLAG FLOOD CONTROL PROJECT
PRESENTATION
HISTORY
PURPOSE AND BENEFITS
RIO DE FLAG FOOD CONTROL PROJECT AREA
PROJECT COST
PROJECT SCHEDULE
CURRENT TOPICS
QUESTIONS
 
Councilmember Whelan asked how much longer until the project is completed. City Engineer Rick Barret stated that the City has yet to receive the funding needed to deliver the $106 million project. The City has the 35% match, the wait is for the other 65% from the federal government.
 
Councilmember Whelan expressed frustration with the timeline. There were benchmarks set and they have consistently been delayed, she asked if it is time to have the conversation about taking on the project without the federal government.
 
Deputy City Manager Shane Dille stated that the submittal for the 100% design did happen on schedule, however there is a lot of back and forth between the parties commenting on the plans and making adjustments. The critical benchmarks are moving forward as dictated in the project timeline and is the schedule that General Semonite is watching very carefully.
 
Councilmember Aslan asked what the alternative is. Councilmember Whelan stated that there is already a concept design of the construction to meet the FEMA 100 year flood requirements. It is time to stop waiting for the Army Corp. The City has done its due diligence but the final project is not here.
 
Councilmember McCarthy acknowledged that there may come a time that the City might have to cut ties with the Army Corp but now is not that time. He noted that there has been substantial progress of late and he is not concerned about a couple of weeks delay. In terms of a separate project, it only makes sense if the project carries more water through the city than what the Army Corp can provide.
 
Councilmember Aslan expressed his desire to incorporate some sort of amenity for the community with recreational opportunities. It is likely an issue of cost that has prevented that sort of addition to the project but he is interested in looking at an opportunity in some sections of the project. Mr. Dille offered that it is the Corp who is driving the project and it is their design standards that must be met. Staff has approached them with various ideas and they were not received well; there are restrictions on the input from the City in terms of amenities and design elements.
 
Councilmember Aslan asked about the elimination of the mandatory flood insurance once the project is complete. Mr. Barrett stated that in the conversations had with community members he has heard as high as $5,000 per year per household depending on the type of financing in place. It will still be an option for homeowners to have flood insurance but it would no longer be a requirement.
 
Mayor Evans stated that more and more flooding is being seen in the community and it is important to stay the course and not shift as it could further delay things. There has been significant movement recently and there is support not only from the Army Corp General but from state representatives to get this done.
 
Councilmember Odegaard acknowledged Councilmember Whelan’s frustration but stated that things are beginning to fall into place and more movement has happened recently than has happened throughout the project. It is important to keep going.
             
8. Board and Commission Interactions with City Council
  City Clerk Stacy Saltzburg provided a PowerPoint presentation that covered the following:
 
BOARD AND COMMISSION INTERACTION WITH COUNCIL
STAFF RECOMMENDATIONS
BOARD AND COMMISSION INTERACTION OPTIONS
1. COUNCIL REPRESENTATIVE ASSIGNED TO EACH BOARD OR COMMISSION
2. NO COUNCIL REPRESENTATIVE ASSIGNMENTS
3. FORMAL UPDATES FROM COMMISSIONS
 
Anthony Garcia addressed Council stating that there often seems to be a disconnect between Council and their commissions. He encouraged the selection of Options 1 and 3.
 
After discussion the Council provided direction to move forward with Options 1 and 3.
 
A break was held from 7:56 p.m. through 8:10 p.m.
             
9. Discussion and Direction: Possible Ballot Measure Committees for the November 2020 General Election
  Ms. Saltzburg provided a PowerPoint presentation that covered the following:
 
2020 ELECTION COMMITTEES
BALLOT QUESTION CONSIDERATIONS
OTHER CONSIDERATIONS
SALES TAX RENEWAL
FRANCHISE ELECTION
COMMITTEE VS. COMMISSION
CITIZEN COMMISSIONS/COMMITTEES
 
Council discussed the possible ballot questions for 2020 and expressed a desire to form a committee to review and provide recommendations on FWPP ongoing funding and Open Space and Parks and Recreation. The Council also wants the newly forming Housing Commission to review and provide recommendations on a possible affordable housing ballot measure.
             
10. Discussion: Affordable Housing ballot measure for 2020
  As discussed in the prior item, the City Council agreed that the newly forming Housing Commission review and provide recommendations on a possible affordable housing ballot measure.
             
11. Discussion/Direction: Establish/Create the Affordable Housing Commission discussed in Proposition 422
  Housing Director Sarah Darr provided a PowerPoint presentation that covered the following:
 
BACKGROUND
DURING THE FAIR CONVERSATION
BACKGROUND – EXISTING COMMISSION
BACKGROUND – SCOPE OF CFHA BOARD
WHAT WE THINK WE HEARD ON MARCH 19
OPTIONS
OPTION A
OPTION B
OPTION B POSSIBLE MEMBERSHIP
SEEKING DIRECTION
 
Rick Lopez addressed Council in support of forming the Housing Commission. He encouraged the Council to appoint various housing experts including engineers, developers, builders, realtors, and the like who can provide relevant and accurate input of the matters brought before the commission.
 
A majority of Council agreed that the commission should be formed, and their first priority should be to develop possible ballot measure recommendations to the Council. Following that action, the commission should be developing recommendations on various items to figure out how to get more housing in Flagstaff.
             
12. Discussion: Ways that the City and a developer could leverage something to create a public art space.
  Councilmember Odegaard stated that he would like for staff to look at ways to work with a private owner or developer to dedicate a space for public art. There have been developments around town with push back by the community and if there was a way to incorporate a public art element there might be a more positive reception.
 
Anthony Garcia addressed Council in support of the idea and mentioned a number of businesses in town that have already incorporated public art into their buildings.
 
A majority of Council was in favor of moving the item forward for future Council discussion and possible direction.
             
13. Discussion: Develop a plan with consideration of zoning changes and multi-modal development in advance of the work in the Fourth Street, Lone Tree, and I-40 corridors
  A majority of Council was in favor of moving the item forward for future Council discussion and possible direction.
             
14. Public Participation

None
             
15. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Councilmember Salas reported that she attended a meeting hosted by Senator Sylvia Allen on housing challenges. She noted that the comments provided by Clarkdale, Camp Verde, and other towns was impressive. She asked if staff could get information from Camp Verde on rental permits for short term rentals.
 
Councilmember Odegaard stated that he also attended the meeting with Senator Allen. He also reported that he met with local business owners and asked options for getting more housing into the zoning code. He attended the FMPO Executive Board Meeting where they discussed the renaming of the organization to the Greater Flagstaff Metro Plan.
 
Councilmember Aslan reported that he attended the Coconino Plateau Water Advisory Committee meeting where there was discussion about a resolution in support of the Grand Canyon Centennial Act. He requested a FAIR item to discuss reasonable restrictions on the use of potable water.
 
Councilmember McCarthy stated that he also attended the FMPO meeting and attended the meeting with Senator Allen. He reported that he attended a Forest Service meeting to discuss the ideas that Snowbowl has for the next few years. He indicated that there will be a public meeting on the matter in a few weeks.
 
Councilmember Whelan reported that she attended many of the same meetings already discussed. She indicated that there are some interesting perspectives on affordable housing and the need to incentivize builders to include more affordable units. She is looking forward to future discussions on how those incentives may be made more lucrative to developers. She also reported that she attended the Wear Orange event on the courthouse lawn, it was an event about gun safety put on by the Moms Demand Action group.
 
Vice Mayor Shimoni reported that he and Sustainability Manager Nicole Antonopoulos went to a sustainability conference in Los Angeles. It was a very interesting conference. He announced that Flagstaff Shelter Services is having a groundbreaking on Thursday and that Juneteenth is coming up.
 
Councilmember Whelan requested a FAIR item to discuss economic opportunities at Red Gap Ranch and the feasibility of bringing solar to Red Gap Ranch.
 
Ms. Goodrich reported that TerraBirds is utilizing a small section of the City Hall lawn for a xeriscape retrofit to show the planting and outdoor amenities that can be provided. They will be using it as a teaching tool for the community and visitors. She also announced that there will be the City Manager requirement process happening the following week and there is an opportunity for the public to stream and comment on the candidates.
 
Mayor Evans reported that she attended the Lowell Observatory 125th birthday party where the Secretary of State and Senator McSally also attended.
             
16. Adjournment

The Flagstaff City Council Work Session of June 11, 2019, adjourned at 9:25 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 18-May-24 01:13 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
188 ms 188 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/agpub_client_defines.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
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 @ 13:13:41.041
			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 @ 13:13:41.041
				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 @ 13:13:41.041
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 13:13:41.041
	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 @ 13:13:41.041
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:13:41.041
		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 @ 13:13:41.041
	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 @ 13:13:41.041
		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 @ 13:13:41.041
	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 @ 13:13:41.041
	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 @ 13:13:41.041
		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 @ 13:13:41.041
		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 @ 13:13:41.041
	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 @ 13:13:41.041
	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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:13:41.041
	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 @ 13:13:41.041
	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 @ 13:13:41.041
	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 @ 13:13:41.041
	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 @ 13:13:41.041
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:13:41.041
	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=15ms, Records=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:13:41.041
		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) = 2019-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2019-06-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 13:13:41.041
			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(862 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 @ 13:13:41.041
	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 @ 13:13:41.041
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 861 
getAllMnLines (Datasource=frsRO, Time=62ms, Records=18) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
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 = 861 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 = 534 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=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
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 @ 13:13:41.041
	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 @ 13:13:41.041
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
		
	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 = 534 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 534 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 @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12931 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12936 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12929 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8703 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12930 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8704 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12932 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8705 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12945 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8706 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12942 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8707 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12938 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8708 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12939 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8709 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12940 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8710 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12941 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8711 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12943 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8712 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12944 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8713 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12934 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12933 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8714 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12935 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:13:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=15ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 13:13:41.041
	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 @ 13:13:41.041
	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 @ 13:13:41.041
		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 @ 13:13:41.041
		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=CFTOKEN=cf2da0d2954da008%2D851B9B28%2DD298%2DE2C4%2D34D69849274C7B0E; CFID=9878966
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=0&mt=ALL&get_month=6&get_year=2019&dsp=min&seq=862
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=0&mt=ALL&get_month=6&get_year=2019&dsp=min&seq=862
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=9878966
cftoken=cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
hitcount=97
lastvisit={ts '2024-05-18 13:13:41'}
timecreated={ts '2024-05-18 13:13:21'}
urltoken=CFID=9878966&CFTOKEN=cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
Cookie Variables:
CFID=9878966
CFTOKEN=cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=862
Session Variables:
ailist=Query (25)
cfid=9878966
cftoken=cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9878966_cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
subdir=/public/
tzoffset=0
urltoken=CFID=9878966&CFTOKEN=cf2da0d2954da008-851B9B28-D298-E2C4-34D69849274C7B0E
URL Parameters:
dsp=min
get_month=6
get_year=2019
id=0
mt=ALL
seq=862
Debug Rendering Time: 0 ms