Print Minutes Return
CITY COUNCIL WORK SESSION
APRIL 28, 2015
COUNCIL CHAMBER
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
             
1. Call to Order
   Mayor Nabours called the Flagstaff Work Session of April 28, 2015, to order at 6:02 p.m.
             
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 ABSENT
   
MAYOR NABOURS NONE
VICE MAYOR BAROTZ  
COUNCILMEMBER BREWSTER  
COUNCILMEMBER EVANS  
COUNCILMEMBER ORAVITS (telephonically)  
COUNCILMEMBER OVERTON  
COUNCILMEMBER PUTZOVA  

Others present: Interim City Manager Jeff Meilbeck and City Attorney Michelle D'Andrea.
             
4.
Preliminary Review of Draft Agenda for the May 5, 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.
  Mayor Nabours asked, with regard to Items 9-D, E and F of next week's agenda, if staff could report to the Council the average account balance of the write-offs. The numbers in the staff summary are large so breaking it down by the number of accounts may add perspective to the discussion. Additionally, he would like information on the efforts made to collect once they are written off.
 
With regard to Item 15-B, Mayor Nabours also asked for information regarding the red stickers Tucson uses for their party ordinance enforcement. Police Chief Kevin Treadway stated that suggestions are welcome but staff felt that the red sticker was too much for Flagstaff so they eliminated the placarding element from the proposed ordinance. 
 
Councilmember Putzova stated that the title of item 17-A is incorrect; she sent corrected language to the City Clerk who will include it in the final agenda. Mr. Meilbeck stated that the Clerk did receive the corrected language and he has discussed it with the City Attorney; the final agenda will reflect an updated title for the item.
             
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.
  Adam Shimoni addressed Council about working to minimize the use of plastic bags. He also voiced concern about the State overreaching into City matters.

Mayor Nabours changed the order of the meeting to the following:

Item 6 - Visitor Intercept Survey Results/National Travel & Tourism Week
Item 10 - US 180 Winter Congestion Report
Item 8 - Plastic Bag Focus Group Final Report
Item 7 - 2015 Legislative Session Report from Richard Travis, Triadvocates, and Discussion of
 Potential 2016 League Resolutions
Item 9 - Discussion of Procurement Preferences Regarding Carbon Footprint and
 Disadvantaged Businesses
Item 11 - FY 2016 Budget Confirmation

The minutes are reflective of the original order of the agenda.
             
6. Visitor Intercept Survey Results/National Travel & Tourism Week  (Survey result about visitors to Flagstaff)
  Flagstaff Convention and Visitor's Bureau Director Heidi Hansen, introduced Dr. Cheryl Cothran of the Arizona Hospitality Research and Resource Center who provided a PowerPoint presentation that covered the following:
 
FLAGSTAFF VISITOR AND ECONOMIC IMPACT STUDY
SURVEY METHODS
 
Mayor Nabours asked how the survey was administered and how it was determined that the people taking the survey were visitors. Dr. Cothran stated that researchers went to places that they knew they would find visitors and they would personally ask if they were visiting Flagstaff. Mayor Nabours asked how many questions were in the survey. Dr. Cothran stated that it was a two page survey packed with information on various things. She continued the presentation.
 
COMPARISON: 2009 VS. 2014
VISITOR ORIGINS
ECONOMIC IMPACT
FLAGSTAFF…A TOURISM STAR
 
Councilmember Brewster asked how long the survey was distributed. Dr. Cothran stated that they typically survey for twelve months and they typically single out one week a month to really focus their attention on getting surveys.

Councilmember Overton asked if they found anything in the data that suggests Flagstaff should change or adjust anything. Dr. Cothran stated that the results were all pretty positive and the recommendation would be to continue on that path.
 
Councilmember Putzova asked if any of the data targeted the participants' specific reason for visiting Flagstaff. Dr. Cothran explained that many visitors come to ski and for special events and most come for vacation and leisure.
 
Ms. Hansen stated that National Travel and Tourism week begins on May 2, 2015 and this year’s theme is “Travel is blank“ allowing people to fill in their own definition of travel so that it is unique and personal to them.
             
7. 2015 Legislative Session Report from Richard Travis, Triadvocates, and Discussion of Potential 2016 League Resolutions
  Deputy City Manager Jerene Watson introduced State Lobbyist from Triadvocates Richard Travis who provided Council with an update on the 2015 Legislative session. Mr. Travis explained that the Legislature and the Governor were very efficient this session with the shortest session since 1968. There was only one major issue that could not be agreed upon and that was the appointment of the Inspector General. Common Core and implementation repeal took a lot of time and energy at the Legislature. Other big topics included microbreweries, Real ID and the elimination of the Department of Weights and Measures.
 
Flagstaff did not push any bills this year and because of that it was difficult to keep up with the legislature. The bills that Flagstaff was involved in were bills that were introduced through other means.
 
Key bills for Flagstaff that will likely be seen next session or in special session include sales tax and pension reform. The sales tax reform was supposed to come online in January of 2015; the audit is extremely important to Flagstaff so it is important that it is done right. In regards to the pension reform the reason it was pulled was because the City of Phoenix had a pension issue on their ballot.
 
There were two bills Flagstaff worked on this year. The first was the Waste Collection Bill that would have taxed the City for out of city collections. By working with the League and Representatives an amendment was crafted that would limit City exposure; the amendment passed.
 
The other bill was guns in public places. This was very contentious and it did not pass the Senate by one vote. Staff had exhausted all of its ability to get votes and came up short so they reached out to partners in the private sector who were willing to talk about the impacts to them.
 
Councilmember Putzova asked for additional information on what activities the City was involved in with regards to the plastic bag issue. Mr. Travis stated that the League handled that bill because it was so clearly preempting city and town control. The issue had such tremendous support from the business community and was not something that was introduced at the beginning of the session. It was a strike everything bill and it was introduced at the last minute. It made it extremely difficult to lobby against due to how late in the session and how quickly it was introduced. Vice Mayor Barotz asked who provided the strike everything amendment to which Mr. Travis responded Warren Peterson.
 
Councilmember Evans stated that there have been a lot of recent bills that minimize the power that local governments have to dictate policy; she asked if Mr. Travis sees this trend continuing. Mr. Travis stated that it is likely to continue in next session with the current Legislature and Governor.
 
Mayor Nabours asked for the bills that passed that will have an impact of the City. Mr. Travis stated that the two primary bills were the waste bills. The first bill is the bill that will give multi-housing owners the ability to chose a private hauler or municipal hauler. He explained that it is not a level playing field; in the waste hauling world the trash only component is a good money maker, the bulk trash and hazardous products are money losers. The cities will be left to cover the fixed costs of waste management and will still have the obligation to pick up bulk and hazardous products. There has been discussion about an ordinance that dictates that bulk trash and hazardous materials must be picked up by the private hauler in the event that they are selected for trash service.
 
Mr. Travis stated that the other bill is the one that charges cities in-lieu tax for land and equipment used for trash services. There will have to be calculations done to determine what impacts there will be but it is highly likely there will be a significant impact on cities.
 
Mr. Travis stated that the Veteran’s Home is a big topic and he recommends setting priorities now in that regard so that there is the ability and time to make modifications if needed. The narrower and more specific the agenda the more chance at success; getting $10 million next session will be tough and it will require a united mission and a united voice and bringing in people from the community to support the effort.
 
Mayor Nabours stated that he has noticed that resolutions can be sent to the League and before the League will champion the issue other cities have to come on with support. He noted that it will be important to remember this as they work on possible resolutions to bring forward. Mr. Travis explained that the League does also consider the varying degrees of impact when choosing which resolutions to bring forward.
 
Mr. Travis stated that higher education funding is also another big topic. The Governor and Legislature have set universities on a path to wean higher education off the general fund. Councilmember Brewster asked for the reasoning behind the action. Mr. Travis stated that every member has a different answer; what they rely on is that the funding is such a small percentage of the university’s overall budget and because of that it should not be seen as a drastic cut. However, the money received from the state has a lot of flexibility associated with it and it can be applied to many areas. The concern is that most of the federal money that comes into the universities as well as grant money cannot be used for things such as personnel or overhead facility costs. While it may only be 2% of their overall budget removing that funding has a vast effect on how the universities fund their operations. Councilmember Putzova stated that she would appreciate it if people would stop referring to the 2% because it has been misused completely for political benefit. It is not actually 2% of the institution's real budget but a political spin and the sooner people stop repeating the figure the sooner the community will realize that something needs to be done in 2016.
 
Councilmember Evans stated that she would like to see a resolution regarding local control. Ms. Watson explained that local control is one of the guiding principles of the League. Councilmember Evans stated that there needs to be a stronger statement. Ms. Watson stated that something can be put into writing to see if the League feels that there is a bill that can be brought forward to that effect. Vice Mayor Barotz added that a resolution could be a very powerful statement to the state. It should include a statement that powerfully reflects that dissatisfaction with a list of bills that are overreaching into local control. This approach may be more impactful then the language that is currently being used as a guiding principle. Ms. Watson asked for Councilmembers to send specific ideas and language to her for drafting. Councilmember Overton expressed concern about the reception the resolution will have and he is not sure that it will be as effective as it is hoped. The Legislature may respond negatively and he cautions against stirring a hornet’s nest. Mayor Nabours reminded Council that the resolutions that are being proposed are draft resolutions to the League. The League will filter them and vote on which will be pushed forward for consideration and tweaking. Mr. Travis stated that there is a natural tension between the Legislature and cities and towns. It used to be that in the 70s and 80s there was a lot more deference paid; there were a lot of people who came to the Legislature from cities and towns that had practical experience as town Mayors or Councilmembers. The Legislature today does not have that history and it is something that has to be re-taught every two years with the new legislature. If the resolution is worded correctly it could be a good tool, but what will be done with that tool needs to be defined.
 
Councilmember Putzova suggested putting forward a resolution to repeal SB1241. There will likely be other cities who would be interested in joining that effort. She added that resolutions are important for communicating with the public and it is important for the public to know how unfriendly the Legislature is to the cities and towns.
             
8. Plastic Bag Focus Group Final Report
  Mr. Meilbeck addressed Council stating that the purpose of this item is to thank the Sustainability Commission and the Plastic Bag Focus Group for their work. The commission was very supportive of the focus group. He offered thanks to the focus group and officially relieved them of their duties. With the passage of SB1241 there are some changes that will need to be made in the approach taken by the City and more time is needed before staff can return to Council with a recommendation. Mr. Meilbeck asked the committee to come to the podium to be recognized. He thanked Kathy Flaccus, Moran Henn, Madison Ledgerwood, Stuart McDaniel, Rick Resnick, Judy Sal, and Rob Wilson for their work on the committee.
 
Stuart McDaniel addressed Council thanking them for allowing such a diverse group to meet. It was gratifying to come together in good faith and trust to work together and find some common ground on an issue that is important.
 
Moran Henn addressed Council and thanked the Sustainability Program for all the work they did on the issue and being 100% available to the group. She thanked the Commission for being gracious in allowing another group to take a stab at what they had already put so much work into. This is an issue that was very important to a lot of people in Flagstaff and it is frustrating to have it trampled by the State. This is a passionate issue and there is still a lot of work to be done to identify options.
 
Rob Wilson addressed Council and thanked Kari Blume who was the facilitator of the group and played a very vital role. The group was a great success; despite having a diverse group of people there was more in common than originally thought. The group succeeded in putting together a plan and that has since been overcome by State issues. He suggested that additional funding be directed to the Sustainability Department for further work, research and education about plastic bags. There are still things that can and should be done.
 
Cathy Flaccus addressed Council and thanked them for the opportunity to be a part of the group. She was not sure how it would go as one of the conservative voices in the group but they worked very well together. She stated that in talking to some people at the state level she found that they were not aware of the budget issues that exist in Flagstaff with regards to Flagstaff’s effort to reduce plastic bags. There are great ideas out there and it would be great for Flagstaff to increase its education to help people further understand what is recyclable. Education works and getting stronger information and better alternatives out to people is key.
 
Mayor Nabours thanked the committee again for their work and stated that Council will be having future discussions about plastic bag use.
             
9. Discussion of Procurement Preferences Regarding Carbon Footprint and Disadvantaged Businesses 
  Purchasing Director Rick Compau provided a PowerPoint presentation that covered the following:
 
PROCUREMENT PREFERENCES
CARBON FOOTPRINT
 
Mayor Nabours stated that the intent of the request was not how to measure one company's footprint versus another but rather if a company has to mobilize from out of town there is a presumption that there will be repeated travelling and burning of gasoline compared to a local company that is not traveling as much or moving equipment as far. Mr. Compau agreed that the wording could be simplified but more research is still needed to determine how that can be applied in a fair and equitable way and within the purchasing statutes. Mr. Meilbeck stated that one of the concerns is presumption; this is something that is very hard to quantify legally. Staff must have a measure to quantitatively make the assessment. There is a significant need to protect the interest of the City in its procurement practices. Mr. Solomon added that the concern is that it must be quantified at some point legally, it has to be measured some way. Legal can look into simple ways to measure that but it has to be made in a way that is legally defensible. Mayor Nabours stated that if a simple step can be identified that is what the intent of Council was when they agreed to look at this issue further.
 
Mr. Compau continued the presentation.
 
BUSINESSES WHO SERVE OR EMPLOY DISABLED PERSONS
 
Councilmember Overton stated that it is great for employers to take on disabled persons. This section limits these employers to three categories; he asked if there is any legal room to expand the categories to include deserving employers, such as those who employ deaf or physically handicap persons. Mr. Compau explained that a lot of the public sector agencies that have adopted this kind of language have limited their preference to these three categories. It would require further research to determine if other options exist. Councilmember Overton noted that is seems odd to call out only one disability. He would be very interested in determining if the City is able to broaden that category. Councilmember Brewster stated that there are a number of agencies that employ disabled persons but are for profit and would not qualify. Mr. Compau offered that in order to be certified as a non-profit agency in Arizona the disabled workforce has to be a minimum of 65%.

Written comment cards in favor of a procurement preference related to carbon footprint were received from the following:

Jesse Anderson
Rhea Nanni
Kristen Ross
Brinnan Black
Lucas Klein
Brian Leash
Jane O'Donnell
J. Kendall Perkinson
Kristin A. Miller
Moran Henn
Sallie Kladnik
Claire Herrica
Kelly Staszkow
Tom Scheel
Sarah Ponticello
 
A majority of Council is in favor of moving forward with further research on carbon footprint as well as the development of an ordinance for the businesses that serve or employ disabled persons.
             
10. US 180 Winter Congestion Report
  Flagstaff Metropolitan Planning Organization Manager Dave Wessell provided a PowerPoint presentation that covered the following:

US 180 WINTER TRAFFIC STUDY
BACKGROUND
  PROBLEM IDENTIFICATION
MINDMIXER RESULTS
IMPLEMENTATION PLAN
POSSIBLE SOLUTIONS
ALTERNATE ROUTE SIGNAGE
MANAGED LANE CONCEPT
 
Mr. Wessel introduced Kent Lane who represents ADOT as the Regional Transportation Engineer.
 
Mayor Nabours asked if it is possible to have three lanes on US 180 and with use of cones or other traffic devices dedicate two lanes inbound and one lane outbound during peak times. Mr. Lane stated that the issue would be that there would be no left turn capabilities for people travelling northbound; additionally, the equipment used would cost around $12,000 per day which is a budget impact that ADOT is unable to accommodate. It is a complex production that would have a few days of planning for each instance. ADOT is not in the business of trying to accommodate fluctuating traffic that is recreational based. What was presented was a much smaller concept and would require consistent traffic movement on Milton to be of any success. To that accord, an alternative timing plan has been in production since 2011 and it adds ten additional seconds to green lights along Milton; the downfall is that it takes timing away from side streets and people have to wait through numerous cycles to get to the main road, if at all. There is little benefit to further adjusting the signal timing at this time.
 
With regards to the alternate routes that have been signed and advertised, people are not utilizing them. Milton has the eateries, gasoline, the ski rental returns, and other amenities. People do not see the benefit of taking alternative routes. It comes down to determining how big of a problem it truly is and how much the City and State are willing to spend on addressing it.
 
Councilmember Overton stated that the root cause of the traffic issue is snow play. The ski resort has been here for decades but once the snow play areas moved out to the same relative vicinity it created a severe bottleneck. If the snow players can be moved to another area of Flagstaff it may help with the problem. Mr. Lane stated that Wing Mountain opened up as a permitted area to address safety problems and concerns along US 180; they have been open about being willing to look at other locations. There may be some need to restrict activity there to drive down the demand in the corridor because the mountain is the magnet.
 
JR Murray addressed Council stating that in a strange way Flagstaff has a success story that cannot be labeled as such. Flagstaff has always been the winter capital of Arizona and it is a novelty and everyone wants to play in the snow. This is the community history and now with growth there is a traffic problem. Flagstaff wants people to come but it does not do a good job of welcoming them. Citizens in that corridor are concerned about emergency response. The County had a meeting last week to talk about this situation and the solution is to disperse snow play. Flagstaff needs eight snow play areas; it needs parking, utilities, restroom facilities, and private industries. He suggested making the snow and getting the snow play visitors off of US 180 and get them into the City where facilities and infrastructure exist. Every City park could be a snow play area. He stated that Snowbowl is part of the solution and now is time to make changes happen.
 
Councilmember Putzova asked for additional information on transit being a possible solution. She also asked for ideas on possible public/private partnerships. Mr. Wessel explained that the key to making transit successful is to replace cars with transit. This may work well for skiers but the issue is snow players who have a lot of equipment with them. There would need to be some incentives or decentives to utilize transit or shuttles otherwise there will be the same amount of cars plus the buses. Another suggestion has been for shoulder widening on US 180 which would allow for lane passing and provide emergency service access but that is a long distance with a heavy expense.
 
Councilmember Evans stated that she would like more information on those types of suggestions. The Council and public are aware of the history and what needs to be done; cost estimates and possible funding sources is what is needed to further the conversation and make decisions. Mr. Wessel stated that there are a number of funding sources that can be researched; BBB revenues might be a possibility along with cost recovery from users. Additionally, a transportation tax or other sales tax may be an option for larger capital improvements. In terms of the actual costs there are costs that came out of the study that can be provided. NAIPTA also did some analysis on costs for running a shuttle system. One of the concerns is that without a predictable season there may be capital with limited funding.
             
11. FY 2016 Budget Confirmation
  Mr. Meilbeck explained that Council had a great budget advance but staff would like to clarify the direction and conclusion before moving forward. He asked if the spreadsheet was what Council was approving.
 
Councilmember Putzova stated that among the first items discussed as investments is merit based pay and the Council was supportive of that then but moved on to different items to discuss. After they discussed the other items the issue was brought up again and the conversation went back and forth between merit based pay and market based pay. At the end of the day the Council did not come to a consensus to support merit based pay or move to market based pay. She does not think that there was a consensus at the end of the session.
 
Mayor Nabours stated that there were several more revenue sources that were up for discussion and none of them passed with a majority of Council who wanted to enact them.
 
Councilmember Oravits stated that he felt that there was a clear consensus and Council went through all the expense and revenue options.
 
Vice Mayor Barotz stated that when she read the email to City staff from Mr. Meilbeck she felt that there was some confusion on the direction and did not think that the spreadsheet was the final accepted proposal.
 
A majority of Council agreed that the spreadsheet was the approved summary of the budget direction.
             
12.
Review of Draft Agenda Items for the May 5, 2015, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  None
             
13. Public Participation
  None
             
14. Informational Items To/From Mayor, Council, and City Manager; and requests for possible future agenda items.
  Councilmember Putzova stated that at the special work session regarding Police Department
  staffing issues it was suggested that a roundtable discussion be had with other employers in the City to discuss employee housing. She asked for staff to work on getting major employers together for the discussion. Councilmember Evans added that it would be a great topic for Council to be involved in to get a sense of what can be done and what other employers may be willing to do.
 
Councilmember Evans asked for a status on a future discussion item request for SB1241; she would like to know what the City can do legally and the public is interested as well. Mr. Meilbeck explained that he is unsure when it will come back for Council discussion as the City Attorney is researching possible options. Councilmember Evans stated that she would like to know all of the options available including a challenge or referendum of the bill. She asked for information on any deadlines for bringing forward a challenge.
 
Vice Mayor Barotz requested a Possible Future Agenda Item on a possible ordinance that would require multi-family landlords to continue to provide for the removal of bulk and hazardous materials even if they chose to move to a private trash hauler. Mr. Solomon stated that the Legal Department is already working on the issue and will have more information to the Council soon.
 
Mr. Meilbeck stated that in terms of employer housing this is something that staff is currently working on. Vice Mayor Barotz asked if it would be coming back to Council for further discussion. Mr. Meilbeck explained that he feels that the item falls under the goals Council has set and he will be bringing it back for full discussion outside of the Possible Future Agenda Item request process. Councilmember Oravits asked for the information to include what the City is doing that is causing the cost of land and housing to be higher. He also would like information on what the City is doing in terms of resource protection. He would like the perspective of staff and what the costs are in terms of this discussion. Mayor Nabours stated that he would like to have that information as well but feels that it is a separate issue from asking other employers if they would be interested in getting together to discuss and possibly devise solutions related to employee housing. Vice Mayor Barotz agreed that it is two different issues and should be handled as such. Councilmember Evans stated that when the conversation occurs about the regulatory piece that Councilmember Oravits is referring to she would like to know what the true cost of development is; the true prices and why things are priced a certain way. She would also like to know what the City controls and what is driven by the private market.
             
15. Adjournment
  The Flagstaff City Council Work Session of April 28, 2015, adjourned at 8:37 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 29-Apr-24 01:51 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
125 ms 125 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
78 ms 78 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
63 ms 63 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/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
140 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 @ 01:51:13.013
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:51:13.013
				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 @ 01:51:13.013
			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 @ 01:51:13.013
				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 @ 01:51:13.013
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 01:51:13.013
	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 @ 01:51:13.013
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:51:13.013
		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 @ 01:51:13.013
	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 @ 01:51:13.013
		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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
		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=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:51:13.013
		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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
	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 @ 01:51:13.013
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:51:13.013
	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=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:51:13.013
		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-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:51:13.013
			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(349 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 @ 01:51:13.013
	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 @ 01:51:13.013
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 349 
getAllMnLines (Datasource=frsRO, Time=16ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
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 = 349 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 = 75 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
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 @ 01:51:13.013
	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 @ 01:51:13.013
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
		
	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 = 75 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 75 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 @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2224 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1598 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2230 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1599 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2222 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1600 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2225 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1601 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2223 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1602 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2232 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1603 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2233 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1604 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2234 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1605 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2236 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1606 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2235 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1607 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1616 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2237 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1608 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2226 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1609 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2228 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1610 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2227 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1611 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1620 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2229 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:51:13.013
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1612 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:51:13.013
	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 @ 01:51:13.013
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:51:13.013
		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 @ 01:51:13.013
		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=4&get_year=2015&dsp=min&seq=349
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=4&get_year=2015&dsp=min&seq=349
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=9370031
cftoken=94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
hitcount=4
lastvisit={ts '2024-04-29 01:51:13'}
timecreated={ts '2024-04-29 01:51:13'}
urltoken=CFID=9370031&CFTOKEN=94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
Cookie Variables:
CFID=9370031
CFTOKEN=94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=349
Session Variables:
cfid=9370031
cftoken=94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9370031_94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
subdir=/public/
tzoffset=0
urltoken=CFID=9370031&CFTOKEN=94f4dbc4c33c0cd-9A52A81F-99D3-75D3-55C2D12E3699C416
URL Parameters:
dsp=min
get_month=4
get_year=2015
id=
mt=ALL
seq=349
Debug Rendering Time: 0 ms