Print Minutes Return
CITY COUNCIL BUDGET ADVANCE
TUESDAY, APRIL 21, 2015 - WEDNESDAY, APRIL 22, 2015
CITY COUNCIL CONFERENCE ROOM
211 WEST ASPEN AVENUE
12:00 P.M.
 
MINUTES
             
1. Call to Order
  Mayor Nabours called the City Council Budget Advance of April 21, 2015, to order at 12:00 p.m.
             
2. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.

PRESENT:

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

NONE






Others present: Interim City Manager Jeff Meilbeck and City Attorney Michelle D'Andrea
             
3. FY16 Budget Hearings - City Council Advance
  Mr. Meilbeck stated that a budget of $163 million is a considerable amount of money to be entrusted with; he thanked staff for their hard work in getting the budget to where it is today. He stated that not everything was funded and there are some new investments because of additional resources. The presentations will focus on those elements as well as what is being done with the existing budget. He presented a Prezi presentation to Council that covered the following:
 
FISCAL MOUNT FLAGSTAFF FY 2016 AND BEYOND
WHERE DO WE WANT TO BE
TANGIBLE OBJECTIVES – WHAT WE DO
HOW DO WE GET THERE? WHAT DO WE AVOID?
SAFETY FIRST
GENERAL FUND CLOSE THE GAP
WHERE ARE WE NOW?
BASECAMP
MISSION AND VISION STATEMENT
 
Revenue Director Andy Wagemaker continued the presentation.
 
WHERE ARE WE NOW - SALES TAX REVENUES
 
Mayor Nabours clarified that the City has a total of $500,000 more than what was anticipated in February and that there may be another $150,000 that is not included in the presented budget package. Mr. Wagemaker stated that in addition to staff budgeting conservatively it is an indication of current growth; the possible $150,000 will not be included in the budget until all the numbers are solidified and confirmed.
 
WHERE ARE WE NOW - STATE SHARED REVENUES
WHERE ARE WE NOW - BBB AND HURF REVENUES
 
Finance Director Rick Tadder continued the Presentation.
 
WHERE ARE WE NOW?
 
Mayor Nabours asked where the yearend savings came from. Mr. Tadder explained that there were a few contracts that were not going to spend all of the allocated money and they were able to be applied back to the General Fund.
 
WHERE ARE WE NOW – DEPARTMENT REQUESTS
WHERE ARE WE NOW – GENERAL FUND AFTER BUDGET TEAM REVIEW
BASECAMP
 
Management Services Director Barbara Goodrich continued the presentation.
 
FUND OVERVIEWS: GOVERNMENTAL BUDGETING “THE COLOR OF MONEY”
“THE COLOR OF MONEY” – BUDGETING
“THE COLOR OF MONEY” – BUDGET PROCESS
“THE COLOR OF MONEY” – FISCAL POLICIES
“THE COLOR OF MONEY” – FUND ACCOUNTING
“THE COLOR OF MONEY” – CITY BUDGET BY FUND - $163.7 M
“THE COLOR OF MONEY” – ENTERPRISE FUNDS
“THE COLOR OF MONEY” – CAPITAL PROJECT FUNDS
“THE COLOR OF MONEY” – DEBT SERVICE FUNDS - $8.0 MILLION
“THE COLOR OF MONEY” – SPECIAL REVENUE FUNDS
“THE COLOR OF MONEY” – THE GENERAL FUND
“THE COLOR OF MONEY” – THE GENERAL FUND – REVENUES
“THE COLOR OF MONEY” – GENERAL FUND – EXPENSES
 
Mr. Meilbeck continued the presentation.
 
HOW DO WE GET THERE?
NEW 1X INVESTMENTS IN PROPOSED FY16 BUDGET GENERAL FUND
NEW ONGOING INVESTMENTS IN PROPOSED FY16 BUDGET GENERAL FUND
REVENUE OPPORTUNITIES AND PRIORITIES
 
Assistant to the City Manager Stephanie Smith continued the presentation.
 
OTHER REVENUE OPPORTUNITIES (YELLOW CARDS) AND UNFUNDED BUDGET
PRIORITIES (BLUE CARDS)
 
Mayor Nabours asked if the presented revenues had been incorporated into the budget. Ms. Smith explained that the potential revenues are not built into the recommended City Manager budget and that the idea is for Council to direct where those funds should be applied.
 
Vice Mayor Barotz asked if the wastewater tax is part of an enterprise fund. Ms. Smith stated that it is part of the general fund. She also clarified that the housing fund total is $734,000.
 
SOME GOOD…NEWS
 
Mr. Meilbeck stated that there are 11 goals that have been identified by the Council, each presentation by the department directors will touch on each of these goals and how their programs work in line with achieving them.
 
A break was held from 1:20 p.m. through 1:33 p.m.
 
Mr. Meilbeck explained that one of the things that have been added to the budget advance this year is to take a brief moment after each break to talk about a success. He introduced Interim Economic Vitality Director Heidi Hansen who provided a presentation that covered the following.
 
SUCCESS STORY #1:
CVB LEADWORKER AND COOL ZONE
 
Human Resources Director Shannon Anderson along with EAC representatives Amelia Mason and Jennilyn Watson continued the budget advance presentation.
 
GOAL #1 – EMPLOYEE INVESTMENTS ATTRACTION AND RETENTION
GOAL #1 – INVEST IN OUR EMPLOYEES AND IMPLEMENT RETENTION AND ATTRACTION
STRATEGIES
BENEFITS
 
Councilmember Putzova asked what the changes to benefits have been over the last few years. Ms. Anderson stated that for the last few years there have been little to no change in the premium to employees because NAPEBT has been using its reserves to offset the increases.
 
Vice Mayor Barotz stated that she has heard about the effort to provide a health clinic to employees and asked if emergency costs would apply to that service. Ms. Anderson explained that the healthcare clinic will be similar to an urgent care but without an x-ray machine. There will be no co-pay to utilize the clinic unless the employee uses the high deductible health plan.
 
Ms. Mason continued the presentation.
 
UNFUNDED BUDGET REQUESTS
 
Mayor Nabours asked if the Police Department pay increase includes Dispatchers. Ms. Anderson stated that Dispatchers are included in the overall 2% increase but are not included as part of the Police Department market based pay increase.
 
Mayor Nabours asked why shift differential funding is only one time. Ms. Anderson stated that the intent is to test it out to see if it is successful; if so staff will look to fund it ongoing next fiscal year.
 
Mayor Nabours asked what the snow operation stipend is. Ms. Anderson stated that Coconino County and ADOT pay higher rates of pay for snow removal operations; this stipend would allow the City to be more competitive in this area in attracting operators.
 
Councilmember Putzova stated that she would like to see the Dispatcher shift differential pay as an ongoing expense and if it is not successful adjustments can be made. Mr. Meilbeck stated that it is fair to say that pulling the funding next year would be difficult even knowing that the first year is a trial run.
 
Mr. Meilbeck stated that the EAC is very engaged in the budget process and he thanked them for their involvement and hard work.
 
Utilities Director Brad Hill continued the presentation.
 
GOAL #2 – ENSURE LONG TERM WATER SUPPLY
GOAL #2: ENSURE FLAGSTAFF HAS A LONG-TERM WATER SUPPLY FOR CURRENT AND
FUTURE NEEDS
 
Vice Mayor Barotz asked if staff is actively monitoring water usage for the ongoing water conservation efforts. Mr. Hill explained that staff bike and walk around town monitoring the usage; they use door hangers and talk to people about water conservation and the appropriate times to water their yards. Vice Mayor Barotz asked how success of the program is measured. Mr. Hill stated that it is not from a water use perspective but rather how much staff is engaging people that are not aware of the regulations contained in the City Code. Councilmember Oravits asked if the staff members have ticket writing authority to which Mr. Hill answered no; they are just able to provide education.
 
Councilmember Brewster asked for Mr. Hill to explain the collaboration with SRP. Mr. Hill stated that SRP is working with NAU to do two watersheds and the technology will be put into City’s watershed.
 
Vice Mayor Barotz asked for clarification on expanding the use of reclaimed water. Mr. Hill explained that there is a waiting list of businesses that want reclaimed water; the supply side is finishing the pump and lift stations that will allow additional supply that will feed some of that demand.
 
Public Works Director Erik Solberg continued the presentation.
 
GOAL #3 – FACILITIES AND INFRASTRUCTURE
GOAL #3 – PROVIDE SUSTAINABLE AND EQUITABLE PUBLIC FACILITIES, SERVICES,
AND INFRASTRUCTURE SYSTEMS IN AN EFFICIENT AND EFFECTIVE MANNER
TO SERVE ALL POPULATION AREAS AND DEMOGRAPHICS
 
Deputy Housing Director Sarah Darr continued the presentation.
 
GOAL #4 – AFFORDABLE HOUSING
GOAL #4: EXPLORE AND ADOPT POLICIES TO LOWER THE COSTS ASSOCIATED WITH
HOUSING TO THE END USER
 
Vice Mayor Barotz asked if there are any new Section 8 units planned for construction. Ms. Darr stated that no new ones are planned. Councilmember Overton asked for a description of the average Section 8 program. Ms. Darr explained that it is a voucher with a defined amount. The voucher covers the difference between one third of the renter’s income and the fair market rate of rent. Also included are water and electricity costs.
 
Mayor Nabours asked about the incentive policy for affordable housing. Ms. Darr stated that in 2009 the Council adopted the affordable housing policy that covers part of the building fees and/or permit fees based on the affordability of the units within a development. There are certain incentives for parking, density, and other attributes. It has been set up in a way that developers can pick and choose which options work best for their project. The number and types of incentives that are available are based on the number of affordable units included in the project.
 
Police Chief Treadway and Deputy City Attorney Sterling Solomon continued the presentation.
 
GOAL #5 - PUBLIC SAFETY STAFFING
GOAL #5: DEVELOP AND IMPLEMENT GUIDING PRINCIPLES THAT ADDRESS PUBLIC
SAFETY SERVICE LEVELS THROUGH APPROPRIATE STAFFING LEVELS
 
Flagstaff Metropolitan Planning Organization Manager Dave Wessell continued the presentation.
 
GOAL #6 – RELIEVE TRAFFIC CONGESTION
GOAL #6 – RELIEVE TRAFFIC CONGESTION THROUGHOUT FLAGSTAFF
 
Vice Mayor Barotz asked if the research for parking is intended to be citywide or for southside and downtown. Mr. Wessell stated that the intent is to partner with the student housing focus group and then push things out further from there. Councilmember Overton stressed the importance of attempting to get ADOT to the table to work with the student housing projects. Their participation is important and their feedback is vital; being a good partner and encouraging them to participate is a role the City should assume.
 
Mr. Meilbeck continued the presentation.
 
TRANSPORTATION PROJECTS
COST OF SOLUTION
REVENUE OPTIONS
BENEFITS
CONGESTION RELIEF SOLUTION
 
Councilmember Brewster asked if an alternative has been set into place should the initiative fail. Mr. Meilbeck stated that the timeline does not include a failure, if it does not succeed it would have to go again in 2021 at a general election.
 
Vice Mayor Barotz stated that this is the first time that the Council has seen the idea and she asked if it could be a work session item to discuss further; the more that is documented now the better. Mr. Meilbeck stated that a work session can certainly be arranged; the point of the presented solution is to show how a major project could be laid out over time. Mayor Nabours stated that he would like to see more focus on the Lone Tree area and the extension of John Wesley Powell. It will be important to identify how Juniper Point will impact the area as well.
 
A break was held from 3:07 p.m. through 3:19 p.m.
 
Fire Chief Mark Gaillard provided a success story on the CART program. CART is an alternative response to Flagstaff’s high incidence of non-emergency and public intoxicant calls for service. The smaller unit is staffed by part-time civilian members of the Fire Department who are trained as EMTs to provide basic life support. The objectives are to slow rising pension costs, find an alternative response model for public intoxicants, to lessen responses of larger emergency response trucks to non emergencies and connect clients to services. The greatest success is the partnerships that have been garnered with the Police Department, Guardian Medical Transport, Northern Arizona University, Catholic Charities, The Guidance Center, and Northern Arizona Regional Behavioral Health Authority.
 
Vice Mayor Barotz asked the definition of non-emergency. Chief Gaillard stated that it is determined through the emergency dispatch protocol. The dispatchers go through a series of questions to determine if an incident is non-emergency and is not anticipating a medical transport. Vice Mayor Barotz asked if an intoxicant call could possibly be an emergency based on the status of the intoxicant. Chief Gaillard responded that it is always possible and the emergency medical personnel on staff are available to address those situations as needed. He added that when a non-emergency call turns emergency the crew can initiate care right there.
 
Councilmember Putzova stated that 110 contacts in five months does not seem like a lot, she asked how many emergency contacts are made during that same time. Chief Gaillard stated that he does not have that information on hand but last year the department just approached 12,000 calls for service; depending on classification 70 or 80 percent of those calls are medical response and of that the estimate is that CART response can represent up to 20%. The idea is to keep the larger apparatus available for emergencies and the smaller vehicles can be used for CART response.
 
Councilmember Brewster asked if the alternative vehicles are at all the stations or just high call areas. Chief Gaillard stated that there is only one CART vehicle operating out of the Ponderosa station. It is a 40 hour a week operation that runs five days per week.
 
Chief Gaillard added that another tool available through the CART program are vouchers that allow people access to taxis, shelters, the Alcohol Stabilization Unit, etc. This is a tool that the City did not have before the CART program and staff is pleased that they have been able to reduce the impact for ambulance service.
 
Mayor Nabours thanked the Chief for the department’s work with the CART program and noted that three years ago there was a work session on this issue and alternatives to dispatching a full service crew to these smaller non-emergency issues. It is great to see a program put into place that addresses the issue.
 
Councilmember Putzova requested additional information with regard to the cost for calls using the CART program in comparison to calls for service with other equipment; she would like to understand the cost savings that is being realized with the program.
 
Deputy City Manager Josh Copley continued the presentation.
 
GOAL #7 – REGIONAL PLAN IMPLEMENTATION
GOAL #7 – ADDRESS KEY INSSUES AND PROCESSES RELATED TO THE
IMPLEMENTATION OF THE REGIONAL PLAN
 
Assistant to the City Manager for Communication Kimberly Ott and IT Director Ladd Vagen continued the presentation.
 
GOAL #8 – IMPROVED COMMUNICATION AND OUTREACH
GOAL #8 – IMPROVE EFFECTIVENESS OF NOTIFICATION, COMMUNICATION, AND
ENGAGEMENT WITH RESIDENTS, NEIGHBORHOODS AND BUSINESSES
AND ABOUT CITY SERVICES, PROGRAMS, POLICIES, PROJECTS AND DEVELOPMENTS
 
Interim Economic Vitality Director Heidi Hansen continued the presentation:
 
GOAL #9 – ECONOMIC DEVELOPMENT AND PARTNER COMMITMENTS
GOAL #9 – FOSTER RELATIONSHIPS AND MAINTAIN ECONOMIC DEVELOPMENT
COMMITMENT TO PARTNERS
 
Vice Mayor Barotz asked for further explanation on the need to have a Business Attraction Manager given the City’s involvement in ECONA. Ms. Hansen stated that she is not discounting the relationship with ECONA but they are more of a collaborative for all of northern Arizona. Staff feels the need to be focusing on Flagstaff individually and having someone dedicated to finding businesses for the City.
 
Councilmember Putzova stated that the types of businesses that were mentioned in the presentation are all retail. When people think about business attraction they think about different types of businesses. She asked how staff is introducing other businesses and what is done to reduce competition with existing businesses. Ms. Hansen stated that staff is looking at attracting all businesses and they are looking heavily at biosciences and medical devices. Flagstaff needs short and long term business and that is what this position will be focused on.
 
Councilmember Overton asked why the City cannot ask ECONA to look more locally; he is concerned that there will be a perception of the City going at attraction alone and losing the collaboration that is found with ECONA. Ms. Hansen stated that ECONA only has two staff members so they are limited as well. Simply put, more bodies are needed to do a better job of what is already being done. If the City does not have the bodies to produce the revenue it will remain stagnant. Ms. Watson added that ECONA is supportive of the City getting more capacity; there are things that the City can lose potential for without a dedicated person to go get it.
 
GOAL #10 – DECREASE THE NUMBER OF WORKING POOR
 
Councilmember Putzova expressed disappointment on how this portion of the presentation was done. She stated that it is ok to acknowledge that there is a goal that staff is not making progress on. There are people who are struggling to meet basic human needs; the intention was good but it is ok to say that the City needs to do better in this area. Ms. Hansen stated that what was presented was not everything that the City is doing however, staff missed the mark on this one and that has been noted.
 
Chief Gaillard continued the presentation:
 
GOAL #11 - PREPARE FOR EXTREME WINTER EVENTS
GOAL #11 – ENSURE THAT WE ARE AS PREPARED AS POSSIBLE FOR EXTREME
WEATHER EVENTS
 
Mayor Nabours asked if the Regional Training Coordinator position will be funded in part by the other agencies that are participating. Chief Gaillard stated that there a number of agencies that are coordinating efforts to fund the position.
 
The City Council offered thanks to Mr. Meilbeck and City staff for preparing the budget presentations. It has been an excellent way to educate the Council with just the right amount of detail. Mr. Meilbeck stated that it was a team effort and everyone in the room has been involved in the preparation.
 
Councilmember Overton suggested adding a blue item to the list that would allow room for negotiation on the City Manager salary. There will likely be some back and forth on salary and he would like to avoid an awkward position of the City not being able to attract the right candidate due to lack of funding.
             
4. Recess
  The April 21, 2015, portion of the City Council Budget Advance recessed at 4:56 p.m.
             
5. Reconvene
 
Mayor Nabours reconvened the City Council Budget Advance at 8:03 a.m. on April 22, 2015.
             
6. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.

PRESENT

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

NONE





Others present: Interim City Manager Jeff Meilbeck and City Attorney Michelle D'Andrea.
             
7. FY16 Budget Hearings - City Council Advance
 
Mayor Nabours recognized Finance Director Rick Tadder for his 20 years of service to the City of Flagstaff.
 
Mr. Meilbeck provided a PowerPoint presentation that covered the following:
 
STRATEGIES FOR OVERALL STABILIZATION AND GROWING OUR ECONOMY
 
Capital Improvements Engineer Bret Peterson continued the presentation.
 
CAPITAL IMPROVEMENT PROGRAM
FY 2016 CAPITAL BUDGET
FY17-FY20 CAPITAL PROGRAM
GENERAL GOVERNMENT – FY2016 BUDGET
GENERAL GOVERNMENT – FIVE YEAR CAPITAL PROGRAM
STREETS & TRANSPORTATION – FY2016 BUDGET
STREETS & TRANSPORTATION – FIVE YEAR CAPITAL PROGRAM
 
Mayor Nabours asked about the Fourth Street intersection reconstruction and its relation to Canyon Del Rio. Mr. Peterson explained that $3.2 million is a contribution to Canyon Del Rio for that project.
 
BBB FUNDS – FY16 BUDGET
 
Councilmember Overton asked if the work on the train station platform will bring it into ADA compliance for passengers. Mr. Peterson stated that there is some debate about how the platform needs to be raised or if there are other ways to mitigate the deficiency. Community Investment and Redevelopment Manager Karl Eberhard added that the concept is that the platform becomes accessible but staff is struggling to find an alternative method to the platform. Councilmember Overton stated that it is a large concern of many in the public and it could be a positive change for those who use the train. He urged staff to continue to work towards a solution; he stated that he would take ADA compliance over historical value.
 
BBB FUNDS – FIVE YEAR CAPITAL PROGRAM
FUTS – FY2016 BUDGET
FUTS – FIVE YEAR CAPITAL PROGRAM
WATER, WASTEWATER & RECLAIMED – FY16 BUDGET
 
Mayor Nabours asked if the capital improvement requests that are being asked for require a utility rate change. Utilities Director Brad Hill explained that what is before the Council now are projects that can be done within the City’s existing rates. Over the last several years outside consultants have been brought in to determine and prioritize what things need to be done and when. That information is then presented to the Water Commission for their approval prior to it coming before Council.
 
Councilmember Oravits asked if the meter replacement proposal is all meter replacements or just a portion. Mr. Hill explained that the request includes getting the older radios to the existing standard. In some cases meters have to be replaced, as of right now there are approximately 3500 old meters remaining.
 
WATER, WASTEWATER & RECLAIMED – FIVE YEAR CAPITAL PROGRAM
AIRPORT – FY2016 BUDGET
AIRPORT – FIVE YEAR CAPITAL PROGRAM
 
Mayor Nabours asked about the $600,000 Master Plan update. Airport Manager Barney Helmick stated that $600,000 is what has been advised as the average for this type of project; it takes about 24 months to complete the project in addition to doing a GIS update as part of the project. Mayor Nabours asked if the update will be paid for with general funds. Mr. Helmick explained that the project will be 91.6% grant funded and the remainder will be split between the City and the FAA.
 
Vice Mayor Barotz asked for the objective of the GIS update. Mr. Helmick explained that the GIS update will assist staff in identifying the airport property geographically; it will give the ability to pinpoint specifically with geographical points any changes in the Airport and will expedite getting information to the FAA.
 
Public Works Project Manager Matt Morales continued the presentation.
 
SOLID WASTE – FY2016 BUDGET
SOLID WASTE – FIVE YEAR CAPITAL PROGRAM
 
Mr. Peterson continued the presentation.
 
STORMWATER – FY2016 BUDGET
STORMWATER – FIVE YEAR CAPITAL
FY2016 – 2025 UN-FUNDED CAPITAL
 
A break was held from 9:21 a.m. through 9:41 a.m.
 
Risk Manager Dean Coughenour addressed Council with a presentation on a success story.
 
SUCCESS STORE #4: DECREASE IN EMPLOYEE INJURIES AND SERIOUS INJURIES
 
Assistant to the City Manager for Real Estate David McIntire continued the presentation.
 
REAL ESTATE UPDATE
 
After discussion regarding the possible new revenue opportunities and the other unfunded budget priorities the Council agreed to the following:
 
Ongoing revenue in the amount of $133,000 generated from an increase in cemetery fees and the revised revenue projections and onetime revenue in the amount of $250,000 from the revised revenue projections.
 
Ongoing expenses would include Heart Monitors in the amount of $40,000 per year, a $1 salary increase for Dispatchers, and a $32,000 salary contingency for the incoming City Manager. Onetime expenses would included two years of Paramedic Assignment pay and $50,000 to Dispatcher retention and attraction strategies.
 
A break was held from 11:27 a.m. through 11:55 a.m.
 
Community Development Director Mark Landsiedel addressed Council with a presentation on a success story.
 
SUCCESS STORY #3 – BUILDING PLAN REVIEW
 
Mr. Meilbeck thanked the budget team for all of the time and effort put into making the advance a success.
 
Mayor Nabours pointed out that a Council goal is to raise people out of poverty and one of the things that he thought would fit within that category would be the hiring of the Business Attraction Manager. In speaking with Rich Bowen at ECONA he understands that there are a lot of things going on and there are some strong possibilities of getting some high paying businesses into town. ECONA can use all the help they can get in attracting business to Flagstaff and the more good employers there are in town then the more high paying jobs there are available.
 
Councilmember Overton stated that this budget was presented at a much higher level than in the past and he feels that the result will be a good work program. He would like to make sure that there is some room in the Council schedule to allow demonstration of work programs. Because Council did not go into the level of detail as before he wants to make sure that the impacts to the work programs are not forgotten and Council needs to be aware of what goes into how the goals are met. He feels that the process is a good strategy but wants to make sure Council also gets connection with the organization work plan. Mr. Meilbeck agreed and stated that the leadership team has talked about an approach throughout the year that keeps Council connected to the organization with frequent reports. It is an ongoing process and staff will continue to fine tune.
 
Mr. Meilbeck stated that the budget discussion is completed but would like to have a conversation with Council to discuss possible approaches to some of the City problems related to economic development.
 
Ms. Goodrich stated that during the December and August retreats staff often gets requests that outpace the current resources. She would like to discuss how the City can grow itself out of the financial situation and what that looks like to the Council; specifically, what tools the Council like to use and what success looks like.
 
Mayor Nabours stated that he hopes to see Flagstaff get a reputation for being a niche community for something like the biomedical or medical products industry so that people and businesses in that industry want to be in Flagstaff because that is where the others in the industry are. Those are generally well paid jobs that are clean and not very demanding of the City.
 
Councilmember Brewster stated that there is a lot of focus on ECONA right now and their attempts to draw businesses with high paying positions; biosciences is that market. There are a lot of spin offs from biosciences that can work in as well; it is encouraging to know that there are things in the pipeline now at various stages of development. It is important to preplan to address traffic and negative consequences of growth.
 
Mayor Nabours added that he was encouraged by Mr. Meilbeck’s comments about looking at the overall transportation plan; it is one of Council’s goals and one that has been put off way too long.
 
Councilmember Overton stated that he feels that the City has done a pretty good job. The City has become more diversified and there are valuable resources that have been developed. A 2-3% growth rate is great but the challenge is that the City has done things above and beyond the core services and keeping those efforts moving forward may prove difficult. There is still the missing link for existing employers and micro-businesses in Flagstaff. He would like to see an effort to go back to the micro-businesses and check in on if they are getting all the resources they need to be successful in Flagstaff. How the City supports its existing businesses should be a bigger effort. It is important to continue to leverage grant opportunities for the community. He would like to continue looking at the positives such as water resources and forest management.
             
8. Adjournment
  The City Council Budget Advance of April 22, 2015, adjourned at 12:24 p.m.



  _______________________________
MAYOR
ATTEST:
 
 
_________________________________
CITY CLERK
 

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 29-Apr-24 06:55 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
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/Application.cfm
47 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.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/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=47ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 06:55:21.021
			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 @ 06:55:21.021
				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 @ 06:55:21.021
			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 @ 06:55:21.021
				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 @ 06:55:21.021
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 06:55:21.021
	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 @ 06:55:21.021
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:55:21.021
		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 @ 06:55:21.021
	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 @ 06:55:21.021
		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 @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
		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 @ 06:55:21.021
		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 @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=16ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:55:21.021
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:55:21.021
	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=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 06:55:21.021
		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 @ 06:55:21.021
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=63ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
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 = 351 
get_temp_vars (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 06:55:21.021
		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) = 351

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 06:55:21.021
			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(351 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 @ 06:55:21.021
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 351 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
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 = 351 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 = 79 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=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
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 @ 06:55:21.021
	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 @ 06:55:21.021
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
		
	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 = 79 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 79 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 @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2270 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1655 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2269 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2274 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1657 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2275 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1658 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2276 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1659 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2277 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2278 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1660 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2271 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 06:55:21.021
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1656 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 06:55:21.021
	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 @ 06:55:21.021
	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 @ 06:55:21.021
		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 @ 06:55:21.021
		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=351
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=351
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=9375431
cftoken=69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
hitcount=4
lastvisit={ts '2024-04-29 06:55:21'}
timecreated={ts '2024-04-29 06:55:21'}
urltoken=CFID=9375431&CFTOKEN=69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
Cookie Variables:
CFID=9375431
CFTOKEN=69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=351
Session Variables:
cfid=9375431
cftoken=69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9375431_69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
subdir=/public/
tzoffset=0
urltoken=CFID=9375431&CFTOKEN=69966206170a5242-A532E2F5-A659-0651-E721D0125B7EEAEE
URL Parameters:
dsp=min
get_month=4
get_year=2015
id=
mt=ALL
seq=351
Debug Rendering Time: 0 ms