Return
 WORK SESSION
TUESDAY, NOVEMBER 14, 2017
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 



WORK SESSION
             
1.
Call to Order

Mayor Evans called the meeting of November 14, 2017, 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 Odegaard read the Mission Statement of the City of Flagstaff.

A moment of silence was held in reflection of the mass shooting at the Rancho Tehama Elementary School in California.
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 WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA (arrived at 6:25 p.m.)
ABSENT:

NONE





  Others present: Deputy City Manager Shane Dille and 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.
  Glenn Tamblingson addressed Council regarding the proposed increase in fees for entrance into the Grand Canyon. He urged the City Council to discuss the upcoming fee increase as it will have an impact on local revenues.
 
Roabie Johnson addressed Council with concerns about possibly lifting the ban on camping in city limits. She expressed concern about campfires and the increased possibility of a catastrophic fire.
 
Charlie Silver addressed Council thanking them for their work in preserving HURF funds.
             
5.
Preliminary Review of Draft Agenda for the November 21, 2017, City Council Meeting.*
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.
  Councilmember McCarthy stated that he would like to withdraw his request for the item 13C FAIR request, e.g., a" request to discuss the possibility of creating a written communication to the Arizona Board of Regents re Council's concerns." 

Councilmember Barotz requested a change to the placement of an item in Item 8B; under Tribal Priorities, the remaining text should be moved under State and Federal Priorities.
 
Councilmember Odegaard requested that in Item 8B, NAU be listed first in the list of state agencies.
 
Mayor Evans stated that there are several commission appointments happening and she briefly reviewed the appointment assignments.
             
6. Recognition of Wildland Fuels Crew 1
  The City Council recognized the Flagstaff Fire Department Wildland Fuels Crew 1 for their service and assistance in locating a missing woman. Recognition and thanks were offered to the following members of Crew 1:
  • Skyler Lofgren
  • Pablo Esquivel
  • Brett Hall
  • Mike Walker
  • Justin Roederer
  • Payson Oberly
  • Charles Sliger
  • Rachel Deans
  • Chad Cavender
  • Jose Martinez-Ramirez
  • Matthew Landis
  • Kyle Daugherty
  • Dakota McNeal
             
7. Future of the Mogollon Public Works Yard
  Public Works Director Andy Bertelsen addressed Council and provided a PowerPoint presentation that covered the following:
 
FUTURE OF THE MOGOLLON PUBLIC WORKS YARD
HISTORY AND CURRENT STATUS OF PROPERTY
MAP OF CURRENT PUBLIC WORKS YARD
AERIAL VIEW OF THE PROPERTY
CONSTRUCTION STATUS
FUTURE OF MOGOLLON PROPERTY
CONCEPT PLAN AERIAL
 
Vice Mayor Whelan asked if the community garden across Bonito would remain. Sustainability Specialist McKenzie Jones stated that the garden will continue and there is a proposal for an urban farm incubator. The proposal would be for a long-term lease to allow local farmers to lease the land for economic purposes.
 
Mr. Bertelsen continued the presentation.
 
PARKS AND RECREATION APPROVAL
PASSIVE RECREATION CONCEPT
HISTORIC ROCK STRUCTURE
FUTURE DISCUSSIONS
 
Councilmember Odegaard asked if the current yard would be vacated by July 2018. Mr. Bertelsen stated that they are hoping to be completely moved by July 1, 2018 but it is a big facility with many years of stuff.
 
Councilmember McCarthy asked if the Parks and Recreation Commission discussed multiple options for the area. Mr. Bertelsen stated that the comments from the community and the Commission were for passive recreational use. There were concerns about increased traffic with a more active recreation approach and Francis Short Pond being so close.
 
Mayor Evans requested that the Parks and Recreation Commission look at options for an appropriate use of the stone building.
 
Vice Mayor Whelan stated that she would like to allow for the possibility that there be a passive park open to the community but also five to eight units of affordable housing.
 
Councilmember Barotz offered her support of the Vice Mayor’s comments and added that she likes the idea of different values being supported in the development of the parcel.
 
Councilmember Overton also agreed but offered that when Council started to get into some different options for the parcel before, there was significant push back from the community. He is willing to entertain those ideas again but he is not willing to go down the road if there is no possibility of moving forward. There are ways to have shared space but he is concerned about the pushback from the neighborhood.
 
Councilmember Putzova suggested involving the neighborhood in developing a plan that accommodates a number of values and addresses a number of challenges. The challenge will be figuring out a way that the potential affordable housing can fit the neighborhood and the park.
 
The following individuals addressed Council with regard to the use of the Mogollon property:
  • Dawn Tucker
  • Roabie Johnson
The following comments were received:
  • The rock structure could be used as a visual art studio or an option for the Indigenous Circle community center.
  • Affordable housing would be ideal because it is walking distance from an elementary and high school.
  • A draft plan would be helpful showing where housing would go and how high.
  • More affordable housing is needed.
  • There is fear and distrust because of the Hub and the Standard; small housing would be appropriate in this area.
  • A combination of passive park and affordable housing would be great.
  • Any new buildings need to be sure to be protected as affordable and not for use as a second home or Air BnB.

Mayor Evans stated that the direction from Council is to add a use for the stone building and an element of affordable housing. Additionally, the community should be involved in the design and redevelopment of the area.
             
8. Discussion of Water Services Temporary Stormwater Rate Increase to Fund Large Capital Projects
  Stormwater Manager Chris Kirkendall addressed Council and provided a PowerPoint presentation that covered the following:
 
STORMWATER RATES
OVERVIEW
BACKGROUND
CAPITAL IMPROVEMENT PRIORITIES
STAFF RECOMMENDATIONS
 
Management Services Director Rick Tadder continued the presentation.
 
3-YEAR RATE TEMPORARY INCREASE: CAPITAL PLAN
3-YEAR RATE TEMPORARY INCREASE: FINANCIAL PLAN
 
Councilmember Overton asked why staff is recommending shifting the funding from the General Fund to stormwater fees. Mr. Tadder explained that it is a capacity issue; the General Fund does not have the capacity to continue funding the Rio de Flag project and stormwater fees should pay for some of the project.
 
3-YEAR RATE TEMPORARY INCREASE: PER ERU
3-YEAR RATE TEMPORARY INCREASE: RESIDENTIAL
3-YEAR TEMPORARY RATE INCREASE: COMMERCIAL
TIMELINE
 
Council offered support for the staff recommendation.
             
9. Discussion of the 2017 Zoning Code Amendments - Transect Code
  Zoning Code Manager Brian Kulina addressed Council and provided a PowerPoint presentation that covered the following:
 
ZONING CODE AMENDMENTS TRANSECT ZONING
WHY ARE WE HERE?
HOW DID WE GET HERE?
DOWNTOWN REGULATING PLAN MAP
COUNCIL SCOPED AMENDMENTS
PLANNING COMMISSION RECOMMENDATIONS
APPROVAL
DENIAL
PHYSICAL & ARCHITECTURAL BREAK
MODIFY LIVE/WORK
10-50.110 (BUILDING TYPES)
10-40 (BUILDING TYPES)
10-50.120 (FRONTAGE TYPES)
10-40 (FRONTAGE TYPES)
DENIAL
NEIGHBORHOOD BUILDING
MAIN STREET BUILDING
DOWNTOWN BUILDING
PHYSICAL SEPARATION
10-40 (BUILDING TYPES)
10-40 (FRONTAGE TYPES)
ANTICIPATED SCHEDULE
 
The following individuals addressed Council regarding Transect Code amendments:
  • Nancy Branhan
  • Dawn Tucker
The following comments were received:
  • These amendments still allow for bulk and mass.
  • Alleyways are not civic spaces; if an alleyway breaks up a building it will not provide a good space.
  • There seems to be a disconnect in the way things are zoned and how things have grown in the neighborhoods.
Council requested a table that shows the staff recommendations next to the Planning and Zoning recommendations for the next discussion.
 
Mr. Kulina stated that the Planning and Zoning Commission focused on T4 and its compatibility as well as trying to visually decrease the bulk in T5 and T6. The result was a limit of 36 feet in T4 and the requirement of façade variations and structural jogs in T5 and T6 to break up the mass.
 
A break was held from 8:19 p.m. through 8:31 p.m.
 
Councilmember Odegaard asked what the vote was for the Planning and Zoning Commission. Mr. Kulina explained that it was a four to one vote; two members were absent and the Chair issued the dissenting vote. Councilmember Odegaard asked what the rationale was for the dissenting vote. Mr. Kulina stated that it was the removal of Commercial Block from T4.
             
10. Discussion on Amendments to/Repeal of the Zoning Code
  Mr. Kulina addressed Council and provided a PowerPoint Presentation that covered the following:
 
DISCUSSION ON AMENDMENTS TO/REPEAL OF PORTIONS OF THE ZONING CODE
SECTIONS OF ZONING CODE
TRANSECT STANDARDS IN CONVENTIONAL ZONING
 
Councilmember Barotz stated that given the previous conversation she is not supportive of a repeal of the Transect Zone; she feels that the amendments will do what is necessary to address some of the challenges.
 
Councilmember McCarthy stated that his highest priority is to get the Zoning Code changes done and he is concerned that repealing the code will take time away from making the necessary changes. He would like to continue moving forward with the staff proposed amendments.
 
Charlie Silver addressed Council stating that it is important to work through the issues of the Transect Code and get it right. It is a mixing and matching of the staff recommended amendments and the Planning and Zoning Commission recommendations.
 
Councilmember Putzova stated that she supports continuing to work intensely on the amendments discussed earlier rather than repeal.
 
Councilmember Overton offered that he is supportive of transect zoning and believes that seeing the amendments through is the best option.
 
Councilmember Odegaard stated that he is not interested in a repeal.
 
Mayor Evans stated that she originally brought the item up for consideration. It is important to get the Code fixed and if it is unable to be fixed then it needs to be suspended until it is right. Fixing something here and there will not address the issue; it should be a holistic approach.
 
A majority of Council would like to move forward with the amendment process rather than a repeal.
             
11.  2017 Intergovernmental Priorities Discussion
  Assistant to the City Manager Caleb Blaschke reviewed the Intergovernmental Priorities and Council proposed the attached changes (Exhibit A).
 
Mr. Blaschke explained that the Council would review and adopt the priorities at the meeting of November 21, 2017.
             
12.
Review of Draft Agenda Items for the November 21, 2017, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.

None
             
13. Public Participation

None
             
14. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Odegaard requested a FAIR item to discuss the increase in fees at the Grand Canyon and its impact to Flagstaff.
 
Councilmember Barotz requested that the Energy Code be added to the Working Calendar.
 
Councilmember Barotz also offered thanks to Lieutenant Colonel Ray Garcia, the Joint Land Use Study Committee and other stakeholders for the tour of the Camp Navajo area. It was a fascinating tour that offered some history of the area.
 
Councilmember Putzova stated that the tour of Flagstaff Shelter Service was excellent and informative.
 
Councilmember Putzova also attended an event hosted by Arizona Planned Parenthood that discussed the various healthcare services Planned Parenthood provides. It was an excellent and illuminating discussion and she appreciates Planned Parenthood providing services in the community and throughout Arizona.
 
Mr. Dille thanked Council for their time and effort during last week’s numerous meetings. He reminded the Council that the Executive Session on November 28, 2017 has been moved to 3:30 p.m. due to the number of items on the agenda. Additionally, the Havasupai trip has been rescheduled to December 4, 2017.
 
Mayor Evans stated that the Council and Leadership attended a tour of the Rio de Flag with NAU President Cheng. It was a good tour and a good start to a dialogue about a possible partnership.
 
Mayor Evans attended the Veterans Day ceremony at the Veterans Cemetery in Bellemont. Police Chief Kevin Treadway was there along with Mr. and Mrs. Lindstrom whose son was killed in the line of duty to present an award in his name. Mayor Evans also received a beautiful afghan from Billie Weldon with the Purple Heart Association.
 
Additionally, she attended the Girls on the Run 5K at the Coconino County Fair Grounds; it was awesome to see all the girls and their supporters.
 
Mayor Evans also reported that the Council visited Flagstaff Shelter Services. It was an interesting visit and they were able to talk about Front Door, what it is and how it works.
             
15. Adjournment

The Work Session of the Flagstaff City Council held November 14, 2017, adjourned at 9:24 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 19-Apr-24 01:14 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
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
122 ms 122 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
122 ms 122 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
35 ms 35 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/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
172 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 13:14:39.039
			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:14:39.039
				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 @ 13:14:39.039
			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:14:39.039
				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:14:39.039
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 13:14:39.039
	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:14:39.039
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:14:39.039
		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:14:39.039
	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:14:39.039
		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:14:39.039
	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:14:39.039
	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:14:39.039
		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:14:39.039
		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:14:39.039
	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:14:39.039
	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:14:39.039
	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:14:39.039
	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:14:39.039
	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:14:39.039
	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:14:39.039
	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:14:39.039
	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=19ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:14:39.039
		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) = 2017-11-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-11-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 13:14:39.039
			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(631 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:14:39.039
	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:14:39.039
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 630 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
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 = 630 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 = 277 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 @ 13:14:39.039
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:14:39.039
	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:14:39.039
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
		
	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 = 277 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 277 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:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6569 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6575 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6567 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4917 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6568 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4919 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6570 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4920 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6582 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4921 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6579 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4918 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6577 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4922 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6578 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4923 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6581 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4924 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6580 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4925 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6571 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6573 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6572 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4927 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6574 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:14:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 13:14:39.039
	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:14:39.039
	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:14:39.039
		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:14:39.039
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=11&get_year=2017&dsp=min&seq=631
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=11&get_year=2017&dsp=min&seq=631
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=9138823
cftoken=802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
hitcount=4
lastvisit={ts '2024-04-19 13:14:39'}
timecreated={ts '2024-04-19 13:14:39'}
urltoken=CFID=9138823&CFTOKEN=802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
Cookie Variables:
CFID=9138823
CFTOKEN=802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=631
Session Variables:
cfid=9138823
cftoken=802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9138823_802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
subdir=/public/
tzoffset=0
urltoken=CFID=9138823&CFTOKEN=802d5a3fb5603b02-AFD25531-DDDC-AC40-8F2B713E86C211E7
URL Parameters:
dsp=min
get_month=11
get_year=2017
id=
mt=ALL
seq=631
Debug Rendering Time: 0 ms