Print Minutes Return
WORK SESSION
TUESDAY, MAY 10, 2016
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
             
1.
Call to Order

Mayor Nabours called the Work Session of the Flagstaff City Council held May 10, 2016, to order at 6:02 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
  The Council and audience recited the Pledge of Allegiance.
             
3. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT

MAYOR NABOURS
VICE MAYOR BAROTZ
COUNCILMEMBER BREWSTER
COUNCILMEMBER EVANS
COUNCILMEMBER ORAVITS
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA

ABSENT








Others present: City Manager Josh Copley and Interim City Attorney Sterling Solomon
             
4.
Preliminary Review of Draft Agenda for the May 17, 2016, 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.
  Mayor Nabours stated that Council will be briefed on item 14-B on next week’s agenda regarding the Municipal Solid Waste Code.
             
5. 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.
  Charlie Silver addressed Council regarding the Heritage Preservation Ordinance; he is glad that there was an explanation and a scope put around the item and hopes that it will go onto a future agenda.

Sherry Wood addressed Council requesting that they not allow the lot split to occur on Silver Spruce as it does not align with the Zoning Code.

 

             
6. 2016 Wildfire Preparedness Briefing
  Wildland Fire Manager Paul Summerfelt introduced Corporal Brad Conway with the Flagstaff Police Department, Coconino County Emergency Management Director Robert Rowley, Duane Tewa and Laura Jo West with the United States Forest Service.

Mr. Summerfelt provided a PowerPoint presentation that covered the following:

WILDLAND PREPAREDNESS BRIEFING
U.S. DROUGHT MONITOR
JUNE AND JULY OUTLOOK
FLAGSTAFF AREA ERC VALUE
2016 FOCUS AREAS
Prevention
Preparedness
Hazard
Mitigation
Response
Recovery
COLLABORATION & PARTNERSHIPS
2015 AZ STATE RISK REPORT
 
Corporal Conway continued the presentation.

LAW ENFORCEMENT FIRE PREVENTION PATROLS
PATROL EFFORTS
WOODS WATCH VOLUNTEERS

Councilmember Brewster asked how many people are involved with the Woods Watch crews. Corporal Conway stated that he does not have that information currently but could provide it later. Mr. Rowley stated that last year the Woods Watch training room was full with standing room only. There is a very active community that is focused on wildfire prevention so when the call goes out for volunteers there are many that come forward.

Mr. Rowley continued the presentation.

ANNUAL PONDEROSA FIRE ADVISORY COUNCIL (PFAC) EXERCISE
COUNTY WILDFIRE DEFENSE ORDINANCE
EMERGENCY MANAGEMENT WEBSITE
FIREWORKS EMERGENCY OPERATIONS PLAN
CODE RED

Mayor Nabours asked if there is a plan in place for evacuations within the City of Flagstaff. Mr. Rowley stated that the County plans for the process of evacuation but cannot plan for the specifics. He added that there are shelters already identified for use and the Red Cross is one of the first contacts the County makes when there is a fire.

Mr. Tewa continued the presentation.

COCONINO NATIONAL FOREST FIRE AND AVIATION MANAGEMENT PROGRAM
2016 CHIEF’S LETTER OF INTENT
COCONINO NATIONAL FOREST
WILDLAND FIRE DISPATCH
FIRE PREVENTION STRATEGIES
WILDFIRE DETECTION
ENGINES AND CREWS (USFS)
NATIONAL GROUND RESOURCES
NATIONAL AIR RESOURCES

Councilmember Oravits asked how many fire towers are manned. Mr. Tewa explained that there are 12 towers total; two are old and not in a condition to staff, they try to get staffing for the remaining 10 and this year received funding for eight.

Councilmember Oravits asked about fireworks and fire restrictions. Mr. Tewa explained that fireworks are not allowed in the National Forest. If additional restrictions are put into place then education also increases in an attempt to get the word out to the public.

Vice Mayor Barotz asked about the budget situation at the federal level and if anything has changed. Mr. Tewa explained that there have been many discussions but there has been nothing set at this point. From a regional and national level there is no commitment to reduce the current capacity levels so they will continue to maintain what they have.
             
7. Presentation on Flooding and Low Impact Development In Flagstaff
  Stormwater Manager Chris Kirkendall provided a PowerPoint presentation that covered the following:
 
STORMWATER PROGRAMS
STORMWATER RESPONSIBILITY
LID IMPLEMENTAITON HISTORY
LID GOALS
VOLUMETRIC FLOODING
BATHTUB EFFECT
 
Mayor Nabours asked if the floods shown in the presentation were caused because Flagstaff did not have Low Impact Development (LID). Mr. Kirkendall explained that there are two types of volumetric flooding; one is caused by the inability of the downstream infrastructure to move water away from the areas and the second is like a bathtub, in that the drain is not capable of removing the water quickly enough. LID will reduce this type of flooding. Mayor Nabours stated that he understood that Lake Continental flooding was caused because a culvert was blocked downstream. Mr. Kirkendall explained that blocked or significantly undersized the infrastructure downstream will not move the amount of water that hits this area. Similarly, in this area the culverts underneath the freeway are box culverts, under the railroad is a small culvert and then there is another set of small culverts under Route 66; those culverts will not move the volume of water depicted in the photos.
 
Mayor Nabours asked if the detention basins play a role in volumetric flooding. Mr. Kirkendall explained that detention basins play a very small role in volumetric flooding. Essentially, it is a pipe that will pass a certain amount of cubic feet per second. Retention, on the other hand, is holding volume onsite so the volume of water never gets to Lake Continental to increase the flooding because it is held in the developments upstream.
 
Mr. Kirkendall continued the presentation.
 
BENEFIT OF LID WATER QUALITY
BENEFIT OF LID FLOOD REDUCTION
DEVELOPMENT REQUIREMENTS
STORMWATER IMPACTS WITHOUT LID
 
Mayor Nabours asked about the change from half inch in 2010 to one inch in 2011 and why it doubled in that year. Mr. Kirkendall stated that it was phased in through the ordinance. Half inch is usually referred to as the first flush of a storm; during that first half inch of rainfall is where the water quality component comes in. The Arizona Department of Transportation and other communities require a half inch mainly to address water quality. When it goes to the next level of one inch of LID it really impacts the volumetric flooding component by doubling the volume retained onsite. Councilmember Oravits added that he was on the Stormwater Advisory Committee back in 2008 and the committee debated the issue for quite a while. There was a push to go from zero to one inch in one shot and ultimately it was decided to stage it in phases.
 
Councilmember Overton stated that the half inch and one inch requirements are the detention or retention quantities; LID is just a tool to mitigate that capture. Mr. Kirkendall agreed stating that LID is a retention tool, there are many options or tools to create those from open ponds to underground systems. Councilmember Oravits asked what tools are commonly used. Mr. Kirkendall stated that he is seeing a variety of options used. He has seen open retention basins and extended detention basins that are providing both retention and detention in the same pond. He has also seen a lot of underground chamber systems that are providing both retention and detention in the same system.
 
Councilmember Oravits asked how the detention process works. Mr. Kirkendall explained that detention is handled in a different way because it is releasing water at the same rate as the pre-development condition. If there is a piece of property that was forested and was releasing 10 cubic feet per second and after development it would have released 20 cubic feet per second there are systems designed to release at 10 cubic feet per second. However, they release all of the volume on the property when they do just detention. The problem is that the release eventually reaches a location downstream and that increases the volumetric flooding component.
 
The following individuals addressed Council in support of the LID Ordinance: 
  • Malcolm Alter
  • Hannah Griscom 
The following comments were received: 
  • Keep the LID Ordinance in tact with the one inch requirement.
  • LID is well documented and is commonplace throughout the United States.
  • LID is cost effective and staff prepared several retrofit examples of development types that clearly showed costs were generally cheaper with LID.
  • LID aids in the reduction of flooding.
  • The one inch threshold was selected to reduce the need to replace undersized infrastructure.
  • Friends of the Rio is in strong support of the current LID ordinance.
  • The ordinance is important to preserve the integrity of the Rio.
  • It is much more cost effective to have the water handled onsite rather than push it downstream where taxpayers have to foot the bill.
  • It provides enhanced green space, less concrete and promotes groundwater recharge.
  • The City cannot manage its current flooding issues, if there is not some type of stop gap measure there will continue to be increased flooding. 
Mayor Nabours asked if every project since March, 2011, has included the one inch retention and if the standards are applied to all residential and commercial structures. Mr. Kirkendall stated that there is an exemption for single family homes, but all commercial and large developments have met the requirements.
 
Mayor Nabours asked if the City has seen a noticeable decrease in the rate of flooding since the standards were implemented in 2011. Mr. Kirkendall explained that the City is only requiring one inch of LID, in order to stop all flooding there would have to be a capture of the volume of much larger events. If the 100 year storm event was five inches of rain and the City is only retaining one inch, it would reduce the amount of flooding but not stop it. Mayor Nabours indicated that he would like to see indication that LID is making a difference. Mr. Kirkendall stated that LID most definitely reduces the amount of flooding.
 
Mayor Nabours asked Guillermo Cortez with SWI Engineering to address Council with regards to the impacts of LID from an engineering perspective. Mr. Cortez stated that from the private development side there is an agreement for a form of LID. What they have seen from an engineering perspective is that it takes a lot of work and adds additional land if it is being done on the surface. In general, the engineering community would agree that LID is a good thing; but it does cost additional property and construction costs but that is something that the City Council, Stormwater and the community have decided they want to do.
 
Mayor Nabours asked the difference in land and cost from a half inch to one inch and if it is double. Mr. Cortez stated that if doing surface LID he has heard that the general rule of thumb is about 10% additional property is needed to do the one inch. The engineering community would like to set up a consortium to look at how things are done and maybe find better ways to handle LID. Even if LID is applied to all current projects or new developments there would still be flooding, unless five or six inches is held back. Councilmember Oravits asked what bumping up the retention to two, three or four inches would look like from a practical standpoint. Mr. Cortez stated that it is impractical as there would be a lot of additional cost.
 
Vice Mayor Barotz stated that in order to make any decisions there needs to be verifiable numbers with relation to LID. Mr. Cortez agreed stating that now that it has been in place for a little while it can be seen what it can fix and what it cannot.
 
Ken Hotsenpiller with Mogollon Engineering stated that he agrees with the LID objectives and he has not had a client or engineer that wants to see it go away. He feels that a group of people who design these every day should be put together to discuss the different ways of doing things. There are ways of looking at the system as a whole; it is difficult to put the one inch requirement on the whole city because the whole city is different. There are different ways of accomplishing the goals of LID and he feels that the system and process could be improved.
 
Mayor Nabours suggested that the different groups and staff work together to develop a plan that can be brought back to Council. Councilmember Oravits added that he would like to hear more about the ideas of better ways to accomplish the goals of LID.
 
Mr. Solomon asked if there is a majority of Council in favor of having staff move this forward. Mayor Nabours, Councilmember Oravits and Councilmember Overton indicated that they were in favor.
 
Vice Mayor Barotz stated that it is an issue of staff time; there are other issues that have been waiting and are not moving forward due to limited resources, she will not be in support of moving forward at this time.
 
Councilmember Evans asked what Council has staff time for; she has heard that staff does not have time to look at certain items and then later there are resources for other items. She asked who is in the current consortium and if others would have perspectives to offer. She asked if there is a sub-committee to a commission that the consortium can start with. She suggested having the consortium do the work and bring it back to a commission for input.
 
Mr. Copley explained that at this time there are more questions regarding LID. What he is looking for is direction from the City Council and based on that direction he would have staff look at the best way of addressing the direction. Staff would likely work with the Water Commission to determine the most appropriate strategy. If there is a majority in favor of having staff do this work then staff will accommodate that request. There are always finite resources and staff available, given direction from Council the executive team will determine how best to move forward. There are not unlimited resources; any time there is something else added, it take more time for other things.
 
Councilmember Evans asked if the Water Commission is the commission that would look at LID. Utilities Director Brad Hill stated that in 2009 the Stormwater Commission and Water Commission were combined so the Water Commission would be the most appropriate commission to have an LID discussion. He stated that a member of the public or the consortium could approach staff or the Water Commission directly and ask that the commission discuss LID. Councilmember Evans stated that she would suggest that the consortium work through Brad to have the Water Commission take the item up for discussion.
 
Councilmember Putzova stated that she is not supportive of having staff do work on this item at this time.
 
Councilmember Brewster stated that she feels the City Manager can find a way to work this into staff’s time.
 
A majority of Council is in favor of having the item move forward and having staff work with the consortium.
 
Vice Mayor Barotz suggested that the Friends of the Rio should have a seat at the table and not just have the engineers.
 
Councilmember Putzova left the meeting at 7:57 p.m.
 
A break was held from 7:57 p.m. through 8:10 p.m.
             
8. Discussion: Revisions to Title 7-04, Municipal Solid Waste Collection Service, of the Flagstaff City Code. (SEE ITEM 14-B ON THE MAY 17, 2016, DRAFT AGENDA FOR BACKGROUND INFORMATION)
  Public Works Director Andy Bertelsen addressed Council with a PowerPoint presentation that covered the following:

SOLID WASTE CODE PROPOSED REVISIONS
DISCUSSION
PROPOSED REVISIONS – MULTI-FAMILY RESIDENTIAL
BACKGROUND ON MULTI-FAMILY RESIDENTIAL
MULTIFAMILY RESIDENTIAL COLLECTIONS CONSIDERATIONS
MULTIFAMILY RESIDENTIAL LANDFILL CONSIDERATIONS
MULTIFAMILY RESIDENTIAL DEFINITION

Public Works Section Director Pat Bourque continued the presentation.

MULTIFAMILY RESIDENTIAL RATE CONSIDERATIONS

Mayor Nabours asked if the proposed rates are less than the competition rates. Mr. Bertelsen stated that the solid waste fund is an enterprise fund; it is self-supporting and the rates are set to maintain the self-supported fund. They may or may not be lower then the competition. The City has a level of service, a consistency of service and a consistency of rates.

Mr. Bertelsen continued the presentation.

PROPOSED REVISIONS - GENERAL GENERAL REVISIONS

Sustainability Manager Nicole Woodman continued the presentation.

EXAMPLES GENERAL REVISIONS

Mr. Bertelsen continued the presentation.

RESEARCH ON SOLID WASTE OPERATIONS
OPERATIONS RESEARCH LICENSE/TRUCK FEES

Councilmember Overton asked if staff is proposing no license fee. Mr. Bertelsen stated that staff is not proposing that at this time; the goal right now is to meet the demands of the legislation. Councilmember Overton indicated that a few dozen trucks may generate a couple thousand dollars and he wonders if it would be worth it to do so; the issue would warrant a lot more discussion.

Mayor Nabours stated that part of the legislation was if a city landfill accepted county trash then the city would have to pay on the equivalent of property taxes that private landfills would have to pay. Mr. Bourque stated that there was legislation proposed that would essentially level the playing field so a municipality does not have an advantage by using tax dollars and not paying the same fees. That legislation did pass. The landfill keeps track of the county trash that is collected and the City will be paying a fee based on property taxes. Mayor Nabours asked if the City could charge more to those haulers to cover those costs. Mr. Bourque explained that the City could charge more and that is up to the Council to decide; the percentage of the county waste that is going into the landfill is roughly two percent. The property tax on the landfill is $12,000 per year so the City will be paying roughly $4,100 per year in lieu of taxes.
             
9.
Review of Draft Agenda Items for the May 17, 2016,City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  None
             
10. Public Participation
  None
             
11. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Brewster stated that NAU is having their graduation this weekend so anticipate for higher traffic.

Councilmember Oravits stated that he was in Kingman driving around old Route 66 and came across an area where they have old train cars, engines and a caboose that could be walked around in. He wanted to throw that out for consideration of a possible future project with tourism or beautification monies.

Councilmember Evans requested legal clarification on a lot split for 401 Silver Spruce; she would like to better understand the administration review public participation policy. In this case she was told that the administrative notifications were put on the City website; she would like to know how that meets the intent of the law, what the legal standard is for notification that the City is required to meet. Additionally, she would like to know how it relates to the City public participation policy and what level of participation would have been required for that action.

Councilmember Evans also requested a F.A.I.R. item to discuss the lot split section of the Development Code that is within Zoning Code and anything related to the administrative review section.

Councilmember Evans stated that she had the opportunity to meet with representatives of the hotel and restaurant group and they had an idea of a project that would place old cars along traditional Route 66 in Flagstaff every quarter mile and perhaps the car could be sponsored by local businesses with opportunity for the public to learn about the history of Route 66. She is not sure if she should go to the Tourism Commission or request a F.A.I.R item.

Councilmember Evans stated that she had received several call regarding two properties, 262 E. Franklin and 812 N. Kendrick, where people are throwing their trash on the street because there is not enough trash receptacles for the amount of trash they are producing. She would like to get some more information on the situation and how the issue might be resolved.

Mr. Copley reported that there is a community meeting May 17, 2016 from 5:30 p.m. to 7:30 p.m. at the Joe C. Montoya Senior Center to discuss the future of the Mogollon Public Works Yard. This is in advance of the City Council Work Session on June 14, 2016 where the yard will be discussed.

Mr. Copley also reported that on May 19, 2016 from 5:00 p.m. to 7:00 p.m. the Municipal Court will be hosting an open house for the public to come in and see some of the challenges that are being faced in the facility and provide information and receive comments.
             
12. Adjournment
  The Flagstaff City Council Work Session of May 10, 2016, adjourned at 8:43 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 05-May-24 07:35 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
235 ms 235 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
173 ms 173 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
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
235 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 @ 07:35:37.037
			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 @ 07:35:37.037
				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 @ 07:35:37.037
			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 @ 07:35:37.037
				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 @ 07:35:37.037
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 07:35:37.037
	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 @ 07:35:37.037
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:35:37.037
		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 @ 07:35:37.037
	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 @ 07:35:37.037
		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 @ 07:35:37.037
	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 @ 07:35:37.037
	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 @ 07:35:37.037
		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 @ 07:35:37.037
		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 @ 07:35:37.037
	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 @ 07:35:37.037
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:35:37.037
	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 @ 07:35:37.037
	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 @ 07:35:37.037
	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 @ 07:35:37.037
	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 @ 07:35:37.037
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=15ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:35:37.037
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:35:38.038
		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) = 2016-05-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2016-05-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 07:35:38.038
			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(467 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 @ 07:35:38.038
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 466 
getAllMnLines (Datasource=frsRO, Time=48ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
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 = 466 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 = 157 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
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 @ 07:35:38.038
	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 @ 07:35:38.038
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
		
	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 = 157 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 @ 07:35:38.038
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 157 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 @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3994 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 4000 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3087 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3992 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3995 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3088 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3993 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3089 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 4003 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3090 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 4002 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3092 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 4004 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3093 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3996 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3091 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3998 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3094 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3997 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3095 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3999 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 07:35:38.038
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3096 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 07:35:38.038
	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 @ 07:35:38.038
	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 @ 07:35:38.038
		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 @ 07:35:38.038
		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=5&get_year=2016&dsp=min&seq=467
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=5&get_year=2016&dsp=min&seq=467
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=9530392
cftoken=157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
hitcount=4
lastvisit={ts '2024-05-05 07:35:37'}
timecreated={ts '2024-05-05 07:35:37'}
urltoken=CFID=9530392&CFTOKEN=157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
Cookie Variables:
CFID=9530392
CFTOKEN=157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=467
Session Variables:
cfid=9530392
cftoken=157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9530392_157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
subdir=/public/
tzoffset=0
urltoken=CFID=9530392&CFTOKEN=157f7bb9c6df9d4c-DB9C3EF1-B7D2-A8C3-9B22011E7DECEAE7
URL Parameters:
dsp=min
get_month=5
get_year=2016
id=
mt=ALL
seq=467
Debug Rendering Time: 0 ms