Print Minutes Return
WORK SESSION
TUESDAY, JANUARY 13, 2015
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
 
             
1. Call to Order
  Mayor Nabours called the Flagstaff Work Session of January 13, 2015, to order at 6:01 p.m.
             
2. Pledge of Allegiance
             
3. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
PRESENT ABSENT
   
MAYOR NABOURS NONE
VICE MAYOR BAROTZ  
COUNCILMEMBER BREWSTER  
COUNCILMEMBER EVANS  
COUNCILMEMBER ORAVITS  
COUNCILMEMBER OVERTON  
COUNCILMEMBER PUTZOVA  

Others present:  Interim City Manager Jeff Meilback; City Attorney Michelle D’Andrea.
             
4.
Preliminary Review of Draft Agenda for the January 20, 2015, 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.
  None
             
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.
  Gabor Kovacs addressed Council with a recommendation of having the City of Flagstaff promote unity instead of diversity.
             
6. Plastic Bags in Flagstaff - A Community Conversation
  Mayor Nabours stated that staff will begin with a presentation on the topic followed by questions from the City Council after which the Council will take public comment. Mayor Nabours explained that there is nothing on the agenda tonight for a specific action and the Council will not be acting or deciding on an ordinance at tonight’s meeting. He explained that public comment will end at 9:00 p.m. and if there are still others who have not had the opportunity to speak there will be an additional meeting where they will have the opportunity to speak first.
 
Mayor Nabours introduced and welcomed Interim City Manager Jeff Meilback who will be filling Kevin Burke’s role as a new City Manager is recruited. Mr. Meilback thanked the Mayor and Council for the opportunity to serve as Interim City Manager. He stated that he is committed to professional objectivity; one of the most important responsibilities of staff is to give factual information and succinct options and alternatives. The community is very ready to have the plastic bag discussion and it is an important issue to Flagstaff.
 
Sustainability Manager Nicole Woodman provided a PowerPoint presentation that covered the following:

  • PLASTIC BAGS IN FLAGSTAFF
  • PRESENTATION OUTLINE
  • DEFINITIONS
  • BACKGROUND
  • FEES, TAXES AND BANS IN THE UNITED STATES
  • WHAT ARE PLASTIC BAG FEES, TAXES AND BANS
  • EXAMPLES OF LAWS
  • EXAMPLES OF IMPACTS OF LAWS
  • EXAMPLES OF ALTERNATIVES TO BANS
  • VOLUNTARY PROGRAMS HAVE MIXED RESULTS
  • PLASTIC BAGS IN FLAGSTAFF
  • PLASTIC BAGS IN FLAGSTAFF: CINDER LAKE LANDFILL
  • PLASTIC BAGS IN FLAGSTAFF: MATERIAL RECOVERY FACILITY
  • SUSTAINABILITY COMMISSION’S RECOMMENDATION FOR A PLASTIC BAG BAN
  • COMMUNITY DISCUSSION – QUESTIONS ASKED
  • QUESTIONS FOR COUNCIL TO CONSIDER
  • CONSIDERATIONS
Mayor Nabours asked if paper bags have a lesser impact on the environment than plastic bags and if staff has looked at other cities that ban plastic bags but allow paper bags. Ms. Woodman stated that the dialogue behind which bag form is more impactful is pretty extensive. Paper bags do have a high intensity for water and electricity use. Some communities have set standards for their paper bags. There are over 150 active ordinances and they have not been categorized but staff can follow up.
 
Mayor Nabours asked if staff is aware of any of the positions of local stores regarding a possible ban. Ms. Woodman stated that in speaking with a number of organizations there are mixed reviews. There are some that support a full ban on plastic and some that prefer a fee on plastics and paper and some that support a ban on plastic and a fee on paper.
 
Mayor Nabours asked if any cities treat stores differently based on the size of the store. Ms. Woodman stated that there are some ordinances that are specific to the square footage of an establishment.
 
Councilmember Brewster asked if staff has talked with the Downtown Business Alliance and other retail outlets to determine if they suggest a greater emphasis on recycling education and places to recycle. It would be a big plus to do more education from both the City and the retailers. Ms. Woodman explained that one of the biggest challenges with the Bag Central Station effort is that some stores are more enthusiastic about participating than others. Currently, the program is a voluntary effort and outreach began in 2008.
 
Councilmember Oravits asked if there are other City sponsored recycle options for plastic bags, besides the stores that collect them. Ms. Woodman stated that because plastic bags cannot be processed at the Materials Recovery Facility (MRF) the Bag Central Station is the only option available.
 
Councilmember Oravits asked for a description of the sorting process at the MRF. Solid Waste Director Pat Bourque stated that the City has a contract with the MRF to allow the dumping of recyclable material at their facility for sorting. Trash is dumped into a large holding area and is loaded onto a conveyer belt. It is raised to a second story level and there are several pickers that are responsible for picking out materials that can be recycled. It continues to the end and drops off to a residual pile that is run through the sorting process a second time. At the end of the second sort, the remaining material is hauled to the landfill.
 
Councilmember Oravits stated that plastic bags get jammed up in the machinery causing a loss of production. Mr. Bourque stated that as the material moves up the conveyer belt there are rollers along the side of the belts and the plastic bags get wrapped around the rollers. This causes the machinery to stop and the plastic has to be cleared.
 
Councilmember Oravits asked how many plastic bags are entering the landfill and how the City is measuring the intake of plastic bags. Mr. Bourque explained that staff has done several audits at the landfill that document the types and percentage of debris that is coming in. Landfill Engineer Matt Morales explained that the thin filmed plastics and plastics in general are categorized together; the broken and large pieces were somewhere in the range of 8-15% of the load in the 2012 audit. He stated that he will double check the numbers and report back to Council.
 
Mayor Nabours asked for further explanation on how the picking process works at the MRF. Mr. Bourque stated that there are nine recyclable products that are pulled out of the waste stream, anything that is not one of the nine items to recycle continues on the conveyor belt to be disposed. Mayor Nabours asked if plastic bags are disposed of because there is no market for recycling plastic bags. Mr. Bourque explained that there are certain entities that will take the plastic bag material and do something with them. In 1997 when the City entered into agreement with Norton there was no market for plastic bag recycling. The nine products that are recycled do have a market that allows for the materials to be resold. It is not currently economical to recycle the plastic bags. Mayor Nabours asked if the agreement could be modified to recycle plastic bags. Mr. Bourque stated that the agreement could be modified however, unless it makes economic sense for Norton to recycle the plastic bags they may not be interested. Ms. Woodman added that when speaking with representatives at the MRF they do not believe that it is economically viable at this time to recycle plastic bags.
 
Councilmember Putzova stated that she had understood that if a plastic bag is reused and subsequently contaminated it can no longer be used for recycling. Ms. Woodman stated that if the plastic bag is used for trash then it goes to the landfill as a single use after point of purchase. She went on to explain that contamination is very high in plastics in general; there are some restrictions on recycling and reuse due to food requirements from the FDA. Depending on what the bags are recycled into determines the contamination restrictions. For example, Trex will not accept plastic bags that are processed through a MRF that accepts trash and recycling that is sorted on site because of the contamination rate.
 
Councilmember Putzova asked for the annual cost of the Bag Central Station program as well as the cost of educational programs in Canada that were successful. Ms. Woodman explained that the Bag Central Station is completely voluntary and there should only be minimal costs; however she is not sure of the contract rates between the Arizona Food Marketing Association (AFMA) and Trex. Ms. Woodman added that she does not have examples of the Canadian voluntary programs but would be happy to research and provide that information back to the Council.
 
Councilmember Evans asked how much the City’s recycling program costs and if there is a budget for it. Ms. Woodman stated that the Sustainability Program has an operating budget of $89,000 and about a third of that is for the recycling program. Councilmember Evans stated that the City has had a program since 2008 to help educate people about recycling bags. She asked if additional funding has been budgeted or reduced. Ms. Woodman stated that the Sustainability budget has remained flat since 2009. A majority of the staff time is used for outreach to the community about proper recycling. Councilmember Evans asked for additional information about any private funds that have been used in the program.
 
Councilmember Evans asked about the $129,000 used last year to capture the trash that blew above the retention fences at the landfill and how much of the trash recovered were plastic bags. Mr. Morales stated that 80% of the recaptured material was in the form of plastic or plastic bags. Councilmember Evans asked where the funding came from for this operation. Mr. Morales explained that the funding is a part of the landfill operating budget which is established from the residential and commercial landfill tipping fees.
 
Councilmember Oravits asked the makeup of the plastics that are collected. Mr. Morales explained that much of the material is plastic bags but there is also air blown cardboard and when there are bigger wind events a lot of other materials will blow over the fencing. Often-times there are larger plastic bags such as the household trash bags and contractor size bags. Councilmember Oravits asked if there was some way to quantify the number and types of bags that are being collected. Landfill Manager Mike Gallegos explained that one thing that is consistently observed during the windy season is plastic bags that blow up and away from the landfill. The further away one gets from the landfill the higher the percentage of plastic bags collected. It is difficult to quantify without counting each individual bag that is collected. He stated that the average bag that is collected from these areas weigh approximately nine pounds each and 3,785 bags were collected in fiscal year 2014. The litter clean up staff cleans up over 700 acres of which 300 acres are outside the landfill.
 
Mayor Nabours asked the effect of imposing a fee on the use of plastic bags in general and if a fee on plastic bags would translate to a reduction in the number of plastic bags used. Ms. Woodman stated that research suggests that fees are more effective than a ban and as the fee increases the consumption reduces. Councilmember Oravits asked what happens to the monies that are collected from the fees and what the impacts or burdens are with collecting. Ms. Woodman explained that there is a wide variety of options when it comes to the fees and where they go once collected. The fees and where they go are determined by the legislating body; some cities retain the entire fee and some cities provide a percentage back to the retailer to cover administrative costs. Some examples of what the funds collected have been used for are river clean ups, obtaining reusable bags for distribution to the community, park restoration, updating recycling equipment and facilities, along with many other options.
 
Mayor Nabours asked if cities can just impose the fee for plastic bags or if it is a tax that would have to go to the voters. Assistant City Attorney David Womochil stated that the fee is not considered a tax and the authority for the City to impose fees is contained within the City Charter and requires a finding that it affects the health, safety, and well being of the community. Ms. D’Andrea explained that if the Council decides to enact a fee the dollars that are collected would have to be tied back to the problem that the Council is trying to solve with the fee. It would go into a segregated fund to support the goals laid out in the ordinance. There does have to be a nexus on what the fees are spent on.
 
A break was held from 7:38 p.m. through 7:48 p.m.
 
The following individuals addressed Council in favor of a ban or fee on plastic bags:

  • Naima Schuller
  • Roseana Cruz
  • Moran Henn
  • Eli Cohen
  • Ryan Ashley
  • Adam Dunstan
  • Dezi Acher
  • Jeff Nickell
  • Leah Manak
  • Alex Gaynor
  • Michaela Steiner
  • Sarah Ponticello
  • Al White
  • Madison Ledgerwood
  • Jeff Meilander
  • Kathy Flaccus
  • Ellen Vaughan
  • Jack Welch
The following individuals addressed Council in opposition of a ban or fee on plastic bags:

  • John Kistler
  • Ruben Abeyta
  • Rob Wilson
  • Michael Dugan
  • Jeff Knorr
  • Stuart McDaniel
  • John Paul Roccaforte
  • Joan Harris
  • Judy Sall
  • Ashley Heerding
The following comments were received:

  • These bags have been called single use bags and that is not correct, they are used for many other purposes after bringing them home from the store.
  • A ban or fee will increase my costs.
  • A ban should not be the focus, recycling should be.
  • Urge Council to ban or place a fee on plastic bags with recycling being the focus of monies collected.
  • A bag ban would not impact low income consumers.
  • The community is already supplementing the costs of others plastic bans.
  • Reusable bags are a great promotional opportunity.
  • Something like this may be small in terms of cost but every time the City adds something it adds another impact to the consumer.
  • If fees are imposed the businesses will pass it on to the consumers.
  • Would like to see an ordinance that includes a direct bag ban, a fee, or a combination of both.
  • Would like to see an ordinance that also addresses paper bags and recycling efforts.
  • To reduce the amount of bags given to consumers the City needs to take action soon.
  • Reducing plastic bag use is the purpose and an ordinance that supports this is needed.
  • These are not single use plastic bags and I believe the people of Flagstaff can and will recycle them.
  • Thousands of reusable bags have been distributed with little to no reduction in plastic bag use.
  • More educational programs are needed.
  • A ban will not achieve the desired results.
  • Grants are available to purchase the equipment necessary to bale material to send to Trex.
  • Personal freedom is one thing but it is our responsibility to promote the general welfare of the community and environment.
  • These are single use bags, even if reused they are reused once and they are still made out of fossil fuels and will be in our environment for thousands of years.
  • There are plastic bags but there are far more beer cans, plastic bottles, paper bags from fast food places that are left in the woods.
  • A recycling program would be a better solution.
  • Let the voters decide what kind of program they want.
  • In favor of a ban on plastic bags.
  • Promotional opportunities for businesses who provide bags.
  • Consumption of plastic and paper bags needs to be reduced.
  • Concerned that not all options have been considered.
  • Trex is willing to provide a baler on a payment program and is willing to pay ten to twenty cents for per pound for low grade plastic.
  • Do not believe that my grocery bill will go down as a result of a ban.
  • The first step is reducing the amount of plastic bags used.
  • Plastic bags make up less than 1% of litter.
  • The proposed ordinance is inconsistent.
  • Other communities have passed bag bans and they were repealed by the citizens.
  • Recent cleanup efforts have shown the impacts of plastics on the environment.
  • Oppose the ban on plastic bags.
  • Bans are not an ideal way of solving problems. The City needs to empower people to do the right thing.
  • Better effort is needed in recycling education rather than a ban.
  • Increased awareness is needed on the use of reusable bags.
  • If the purpose of recycling is to divert things from the landfill the City needs to take action.
  • The voluntary concept is not working.
  • Flagstaff does not need plastic bags and we can be an example to the state.
  • Urge the Council to phase out the use of plastic bags.
  • If plastic bags don’t exist they don’t create problems.
  • Need to educate on how to stop using plastic bags.
  • There are a lot of options and they all should be explored before making a decision for everyone.
  • Thank you to the local businesses that have offered the community alternatives to plastic bags and locations to recycle plastic bags.
  • There are many reasons to ban plastic bags.
  • The problem is a capitalist problem; there is a cost to society and when something is free it is not valued enough to take care of it.
  • There is a negative connotation to a ban.
  • Encourage Council to educate the community on alternatives to plastic bags.
  • Sodexho at NAU no longer uses plastic bags; urge the Council and staff to talk with them about the reasoning behind their decision.
  • Citywide bans have little to no impact on overall litter.
  • As city leaders you should not mandate but educate. Emphasizing the use of other types of bags and educating the community on the importance.
Mayor Nabours stated that the people that were unable to speak tonight due to time would be the first on the list at the follow up meeting.
 
Written comment cards in favor of a ban or fee on plastic bags were received from:

  • Rick Resnick
  • Brandon Clark
  • Donna Hanley
  • Lauren Figueroa
  • Michaela Steiner
  • Ann Brown
  • Jessie Anderson
  • Marissa Kulick
  • Darlene Ryan
  • Mary Ellen Arndorper
  • Eli Cohen
  • Jerry Jean-Louis
  • Chandra Hemminger
  • Tate Larrick
  • John D. Johnson
  • Susan J. Hueftle
  • Michael Caulkins
  • Rhea Nanni
  • Maria Jensen
  • Ana Manzano
  • Louie Herron
  • Therese Gribbins
  • Ellen Vaughan
  • Sofia Ramcke
  • Laurel Ellis
  • Danna Durney
  • Rosemary Logan & Brynn Aumack
  • Eva Rowe
  • Frankie Beesley
  • Eleanor Krueger
  • Michael Chizhov
  • Cora Braun
  • Lupita Salazar
  • Lauren Cain
  • Seth Cauman
  • Sara Leibold
  • Michael Back
  • Sara Sanford
  • Brian Leask
  • Leslie Owen
  • Jean Myers
  • John Lynch
  • Kristina Aksenova
  • Joseph August
  • Patricia L. Johnson
Written comment cards in opposition of a ban or fee on plastic bags were received from:

  • David Slipher
  • Cynthia Dorfsmith
  • Adrian Dorfsmith
  • Charlotte Hearne
  • Celestine Taieb
  • Michael Mijuskovic
Councilmember Brewster stated that she had received several emails concerning the environmental impact of making reusable bags. She requested information on the environmental impacts of making the reusable cloth bags; she asked specifically for the energy use and if there are any toxic byproducts as well as the impacts of washing the bags. Councilmember Oravits added that he has collected a lot of reusable bags and most of them are not cloth, not made in the USA and are generally made out of polypropylene. He asked for additional information on what types of reusable bags are being used most in other communities, what the cost is to create those bags and the cost difference between these bags and cloth bags. He also requested information about the point of sale bags, if they are made in the USA and what the impacts are for those.
 
Councilmember Oravits also asked for staff to look into the bags in a bag concept and whether there is any merit to it and if it would be helpful in the sorting process at the MRF. Additionally, he asked if the City can offer plastic bag recycling collection bins at City facilities.
 
Councilmember Evans asked how much it would cost to effectively educate the community on the recycling of plastic bags. She also asked for information on what other city recycling programs are out there and how they are funded and what they cost.
 
Mayor Nabours asked for information on the cost to a store for paper bags versus plastic bags. He noted that the City of Tucson addressed this issue and went with a voluntary education program; he requested an update on that program.
             
7.
Review of Draft Agenda Items for the January 20, 2015, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  Mayor Nabours stated that next week’s agenda includes appointments to the Planning and Zoning commission; he reminded Council that additional applicants were likely to appear in the final agenda packet.
             
8. Public Participation
  None
             
9. Informational Items To/From Mayor, Council, and City Manager.
  Councilmember Oravits reported that he and the Mayor went to the Capitol for the opening day of the Legislature. They had an opportunity to go around with the City’s delegation and met with a number of people. One thing that came out of the meetings was that the Veteran’s home issue was received very well and all were excited about the prospect of a VA home in Flagstaff.
 
Councilmember Brewster welcomed Mr. Meilbeck as the Interim City Manager.
 
Vice Mayor Barotz asked for an update on the efforts to have City Council votes recorded on the website through the agenda software.
 
Councilmember Evans stated that she will not be at the meetings on January 26th or 27th.
 
Councilmember Evans requested talking points for the VA home. It would be very helpful in talking with the City’s representatives and delegation.
 
Councilmember Overton stated that he spent an afternoon with the Department of Revenue discussing the tax simplification rules that have been implemented. Contracting is a significant line item in the City’s budget and he urged staff to be aware of the changes and prepare the budget with them in mind.
 
Mr. Meilbeck stated that this was a great first meeting and he enjoyed having the vast discussion. He reminded Council about the upcoming mini budget advances on January 22, January 28, and February 5 as well as the full budget retreat on February 11 and 12.
 
Vice Mayor Barotz stated that she and the Mayor met with Brian Jeffries of the Professional Firefighters Association of Arizona to listen to his proposal to address the Public Safety pension. The presentation was informative and she suggested having Mr. Jeffries give a presentation to the Council and community at a future work session.
             
10. Adjournment
  The Flagstaff City Council Work Session of January 13, 2015, adjourned at 9:28 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 06-May-24 03:34 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
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 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 @ 15:34:32.032
			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 @ 15:34:32.032
				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 @ 15:34:32.032
			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 @ 15:34:32.032
				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 @ 15:34:32.032
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:34:32.032
	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 @ 15:34:32.032
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:34:32.032
		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 @ 15:34:32.032
	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 @ 15:34:32.032
		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 @ 15:34:32.032
	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 @ 15:34:32.032
	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 @ 15:34:32.032
		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 @ 15:34:32.032
		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 @ 15:34:32.032
	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 @ 15:34:32.032
	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 @ 15:34:32.032
	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 @ 15:34:32.032
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:34:32.032
	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 @ 15:34:32.032
	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 @ 15:34:32.032
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:34:32.032
	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=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:34:32.032
		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) = 2015-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 15:34:32.032
			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(302 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 @ 15:34:32.032
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 302 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
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 = 302 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 = 39 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=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
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 @ 15:34:32.032
	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 @ 15:34:32.032
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
		
	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 = 39 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 39 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=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1444 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 876 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1450 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1442 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 879 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1445 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 882 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1443 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 885 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1452 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 888 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1446 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 891 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1448 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 894 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1447 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 897 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1449 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:34:32.032
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 900 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 15:34:32.032
	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 @ 15:34:32.032
	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 @ 15:34:32.032
		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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 15:34:32.032
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2015&dsp=min&seq=302
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=1&get_year=2015&dsp=min&seq=302
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=9564777
cftoken=1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
hitcount=4
lastvisit={ts '2024-05-06 15:34:32'}
timecreated={ts '2024-05-06 15:34:32'}
urltoken=CFID=9564777&CFTOKEN=1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
Cookie Variables:
CFID=9564777
CFTOKEN=1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=302
Session Variables:
cfid=9564777
cftoken=1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9564777_1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
subdir=/public/
tzoffset=0
urltoken=CFID=9564777&CFTOKEN=1ed8930321c54966-203AC5B5-C6D1-0F90-107FABA3D9F85532
URL Parameters:
dsp=min
get_month=1
get_year=2015
id=
mt=ALL
seq=302
Debug Rendering Time: 0 ms