Print Minutes Return

WORK SESSION
TUESDAY, JANUARY 27, 2015
COUNCIL CHAMBERS
211 WEST APEN AVE.
6:00 P.M.
 

MINUTES

             
1. Call to Order
  Mayor Nabours called the Flagstaff Work Session of January 27, 2015, to order at 6:01 p.m.
             
2. Pledge of Allegiance
             
3. Roll Call

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

Others present:  Interim City Manager Jeff Meilbeck; City Attorney Michelle D’Andrea.
             
4.
Preliminary Review of Draft Agenda for the February 3, 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 Councilmember Evans if item 17-A was worded in the way she intended. Councilmember Evans stated that it is not worded quite right and that she is looking for an opportunity for the City Clerk to give a presentation on how staff selects the two City Council liaisons to appoint commission members as well as some history on the process.
             
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.
  Recreation Manager Brian Grube was asked by Mayor Nabours to provide a report on the Dew Downtown event. Mr. Grube thanked the Mayor and Council for their support of the event. There was a lot of work put in by staff and public private partners. One of the goals is to bring more people to town. In the past it has been difficult to capture how many people come to the event. This year a Go Pro was mounted at the event to capture a time lapse view of the amount of people that attended. Mr. Grube played the video for the Council. Mayor Nabours thanked Mr. Grube and Special Event Coordinator Glorice Pavey for their work on the event. He stated that it was well organized and well done and it made a good showing for the City of Flagstaff.
             
6. Northern Arizona University (NAU) High Country Conference Center Update
  Flagstaff Convention and Visitors Bureau Director Heidi Hansen reported that the High Country Conference Center opened in 2008 and currently NAU contracts with Sodexho for their services. She introduced Jane Kuhn and Rudy Gutierrez with High Country Conference Center who provided a PowerPoint presentation that covered the following:

  • OVERVIEW OF THE CONFERENCE CENTER
  • MEETING & EVENT ACTIVITIES
  • MONTHLY FLOW OF ACTIVITY
  • CURRENT MIX OF BUSINESS
  • WHERE IS THE BUSINESS COMING FROM?
  • BUSINESS TRENDS
  • TOP LINE GROWTH
  • RECOGNITION TO OUR COMMUNITY
Councilmember Brewster asked how the City and conference center markets international conventions. Ms. Hansen stated that the City partners with the conference center on marketing efforts. The City uses a sales kit that shows all of the amenities that the conference center provides.
 
Ms. Kuhn explained that the conference center is in the process of conducting a net impact study and will be bringing those findings back to the City Council once the study is complete.
             
7. Flagstaff Arts Council Annual Report
  Community Design and Redevelopment Manager Karl Eberhard stated that the City contracts out to the Flagstaff Arts Council who provide arts and science grants to the community and administer those grant on behalf of the City of Flagstaff. He introduced JT Tannous who provided a PowerPoint presentation that covered the following:

  • ANNUAL REPORT – FISCAL YEAR 13-14
  • NAME CHANGE
  • CITY OF FLAGSTAFF – ARTS & SCIENCES
  • ARTS COUNCIL/CITY CONTRACT
  • THE ARTBOX INSTITUTE
  • ARTBOX INSTITUTE – CLASS OF 2014
  • FIRST FRIDAY ART WALK
  • ART WALK - INTERACTIVE ONLINE MAP
  • FIRST FRIDAY ART WALK
  • ARTS COUNCIL/CITY CONTRACT
  • FLAGSTAFF365.COM
  • FLAGSTAFF365 – USER ACTIVITY
  • COCONINO CENTER FOR THE ARTS
  • VIOLA AWARDS
  • ARTS COUNCIL/CITY CONTRACT
  • INCREASE OPPORTUNITIES
  • YOUTH ACCESS TO THE ARTS
  • ARTS AND SCIENCE FUND GRANTS
  • RETURN ON INVESTMENT
  • ROI: LOCAL TAX REVENUES
  • ROI: TOURISM REVENUE
  • RETURN ON INVESTMENT
  • COMING IN 2015
  • 2015 VIOLA AWARDS
  • THANK YOU!
Mayor Nabours stated that he feels that this is what BBB money was designed to be used for. He thanked Mr. Tannous and his staff for the fine job they have done and continue to do.
 
Councilmember Putzova stated that it is exciting to see the first graduates of the Art Box Institute. She asked Mr. Tannous to tell the Council about the next idea that is being explored. Mr. Tannous stated that they are looking at other organizations within the community that they can partner up with to strengthen the current programs.
 
Vice Mayor Barotz thanked Mr. Tannous for the annual report and stated that the things this group is able to do on such a small commission is impressive.
             
8. Community Development Block Grant (CDBG) Overview and Priority Setting
  Deputy Housing Director Sarah Darr provided a PowerPoint presentation that covered the following:

  • CITY OF FLAGSTAFF 2014/2015 COMMUNITY DEVELOPMENT BLOCK GRANTS (CDBG)
  • WHY ARE WE HERE TONIGHT?
Ms. Darr introduced Housing and Grants Administrator Leah Bloom who continued the presentation.

  • CDBG
  • WHY DOES THE CITY OF FLAGSTAFF RECEIVE CDBG MONEY?
  • WHAT HAS CHANGED IN RECENT YEARS?
  • ALLOCATIONS OVER THE YEARS
  • HOW DOES THE CITY ACCESS THE FUNDS?
  • HOW CAN THE CITY SPEND THE MONEY?
  • CDBG PRIMARY AND NATIONAL OBJECTIVE
  • BENEFITING LOW AND MODERATE INCOME PERSONS
  • 1. LIMITED CLIENTELE
  • 2. HOUSING ACTIVITY
  • 3. AREA BENEFIT
  • 4. JOB CREATION/RETENTION ACTIVITIES
  • HUD ANNUAL FUNDING CAPS
  • PUBLIC SERVICE – 15% CAP
  • CRITERIA FOR USE OF CDBG FUNDS
Ms. Darr continued the presentation.

  • HOW ARE THE FUNDS DISTRIBUTED?
  • PROPOSAL PROCESS
  • CITY CONTRACT REQUIREMENTS
  • FEDERAL OVERLAY STATUTES
  • 2013-2015 CDBG AWARDS
  • 2013/2014 CDBG BENEFIT
  • WHAT HAS CHANGED IN RECENT YEARS?
  • REQUESTED DIRECTION
  • NEXT STEPS
Councilmember Overton stated that there is a rigorous process in granting funds to the applicant in the beginning; he asked what backstops are in place to protect the City and how it distributes the funds. Ms. Darr stated that Flagstaff’s process is one that other communities have asked for Flagstaff staff to teach. The process is so strong because there are such limited funds. Staff has a meeting with each agency, most of which report on a monthly basis and any request for reimbursement must be accompanied by a progress report. Staff also monitors the agencies and their files. If there is something that they should not be doing, it is caught early and rectified. If an agency is not in compliance staff is onsite every two or three months until they are back into full compliance. There have been a couple of instances where funds have had to be returned not due to misuse of funds but rather not spending the money in a timely manner. There are a number of backstops including a final monitoring from HUD.
 
Councilmember Overton asked if there is concern on behalf of the applicant that it may be months before they know the award amount and the timing of the project. Ms. Darr stated that she feels that as long as the City is up front with where they are in the process the applicants will be good with it. Councilmember Overton stated that with a 60-90 day delay is there some leverage opportunities that could be missed. Ms. Darr agreed that it is a valid risk as far as the leverage piece.
 
Councilmember Barotz asked how the community leverage dollars are calculated. Ms. Darr explained that staff calculates the number based on the information reported back to the City by each agency in their close out reports.
 
Mayor Nabours asked if the Council needed to set broad categories or specific allocations for funding. Ms. Darr explained that staff needs categories that the Council is interested in allocating funds to, this will help staff in determining which projects come before Council for approval.
 
Councilmember Putzova asked how effective past organizations were at addressing the priorities set out by Council. She stated that she would like a community measure that measures success so it can be identified that a difference is being made over time with these projects. Ms. Darr stated that a good example is Catholic Charities and the rehabilitation of a family shelter. Another good example from Catholic Charities is the PATH program that went out and tried to get services to homeless individuals and help them transition. Ms. Darr added that staff actively participates in the community initiatives and work with the continuum of care.
 
Devonna McLaughlin addressed Council on behalf of Housing Solutions of Northern Arizona, and stated that Housing Solutions has applied for and received funding in previous years and that funding was leveraged for local, state and federal dollars. She urged the Council to set a priority of affordable housing and economic development. Mayor Nabours asked for Ms. McLaughlin to clarify what an economic development priority would look like. Ms. McLaughlin stated that while she does not have an economic proposal yet this year, last year the proposal was for Sharon’s Attic which has been a great success.
 
Councilmember Overton stated that this is the City’s only HUD allocation and federal funding for housing. He indicated that he would not be interested in using this fund to shore up any other funds. He stated that he is more interested in the housing and homelessness priorities.
 
Vice Mayor Barotz stated that she would support keeping all of the prior year’s categories for the coming two years.
 
Councilmember Putzova stated that housing and homelessness deserve attention and being more targeted and focused with the Council priorities would be helpful to organizations. She added that defining a more focused scope in relation to housing would be helpful in soliciting projects that are more specific.
 
Mayor Nabours stated he too would like to see all four previous categories stay but suggested adding neighborhood revitalization to the list.
 
The City Council agreed to move forward with the previous four categories that were established.
 
Ms. Darr stated that the Council will also need to provide direction on when they would like to make funding decisions.
 
Council agreed that staff should assume the same amount of funding that was allocated last year and adjust proportionately when hard numbers are received. Ms. Darr stated that staff will return to Council in April with recommendations based on estimated funding amounts from HUD.
 
A break was held from 7:35 p.m. through 7:45 p.m.
             
9. Discussion of possible changes to the City Code regarding Subdivision Assurances.
  Ms. D’Andrea provided a PowerPoint presentation that covered the following:

  • SUBDIVISION ASSURANCES
  • PROPOSED CLARIFICATIONS AND CHANGES
Ms. D’Andrea stated that language has been written in that when a successor developer takes possession through sale a new assurance must be obtained. The intent is to cover the City in all instances and require successors to always post new assurances.
 
Councilmember Overton asked if this is required prior to the sale how the City would require this without interfering with the sale. Ms. D’Andrea stated that it would have to be part of the parties' sales agreement that new assurances are required or they can transfer the old one. Councilmember Overton stated that the intent is not to create a fight between the buyer and the seller; the City is just looking for the one assurance.
 
Mayor Nabours stated that he did not think that the City required a bond amount for franchise utilities. City Engineer Rick Barrett stated that the Department of Real Estate is very clear that all infrastructures necessary for a subdivision is promised to the end user. Prior to the zoning code when the City was operating under ordinance 1925 it did not include franchise utilities and it is one of the mistakes made in the past in making sure the end user is protected should there be a bankruptcy.
 
Mayor Nabours asked if a letter from the utility company stating they will service that subdivision is needed in order to get the public report. Mr. Barrett explained that the utility company has to say that they will be able to serve the site. The Department of Real Estate will also confirm with the City that it is in possession of the assurances that are needed to protect the end user. Only then will a public report be issued. There are costs associated with putting the utilities into the ground. The utility companies will require that a trench be dug for them by the contractor and when the trench is dug then the utility will show up and put a pipe in and then the contractor will back fill it in accordance with City standards. Mayor Nabours stated that he believes that there may be some resistance from the developer or bonding companies. Mr. Barrett stated that it has been working thus far; the assurances are to require that the contractor is doing what it said it would do. A utility will provide service but they will not provide the installation.
 
Ms. D’Andrea explained that there is language that allows the City to correct the amount of the assurance required should it be needed. The estimates for that are more difficult to get the first time. Mr. Barrett added that it is a timing issue for the developers. When the City is getting assurances it is completing its review of the construction plans. The consultant’s ability to get accurate estimates from the utility companies have been difficult.
 
Ms. D’Andrea continued the presentation.

  • THIRD PARTY TRUST AGREEMENT
  • QUESTIONS FOR COUNCIL
  • PROS and CONS
Councilmember Overton agreed that there is going to be a cost concern but there has only been one case in Flagstaff history and he is concerned that the result is discouraging a successor. Ms. D’Andrea agreed that there is a risk, when the new developer comes on the City will have some flexibility on how much of an assurance to post.
 
Mayor Nabours stated that by calling the existing bond and getting the infrastructure in place may help it be more marketable to be sold to another developer. Ms. D’Andrea agreed but stated that there may be times when it is not necessary to call upon the bond which is why that discretion is important.
 
The consensus of Council is to move forward with requiring successor assurances and third-party trust agreements.
 
Ms. D’Andrea explained that she will work through a few changes and bring the ordinance back to the Council for approval at a later meeting.
             
10. Discussion of Relocation Ordinance
  Planning Director Dan Folke stated that there are two policies that relate to this in the Regional Plan. The State of Arizona has an existing law on mobile home relocation and cities are preempted in legislating in that manner. Rather than see an ordinance right now staff is recommending adding to the City’s legislative agenda to allow cities and towns to do this kind of relocation program.
 
Additionally, with rezoning requests that would potentially displace residents the applicant would be required to address the relocation plan within the General Plan. It could be addressed by including affordable housing units in the project, but it is up to the discretion of Council on whether or not the developer is meeting that policy. Staff is trying to include regional plan goals and policies earlier in the processes. At the concept level Comprehensive Planning Manager Sara Dechter will look at the concept plan and see what regional plan policies will have to be addressed in the plan. There is a requirement that the applicant provide a written analysis on how they will comply with the plan.
 
Mr. Folke explained that with regards to notification, there is currently a notification requirement to surrounding owners of a pending application. If the subject property is a mobile home park then notification to residents and tenants of a pending application will also be required. In regards to notifying residents when a mobile home park is for sale, staff is seeking input from the City Attorney on the feasibility of notifying not only current residents but future residents as well.
 
Mayor Nabours stated that he would like to see that a rezone applicant include what impacts there are in relation to relocation and how they are going to address them in their application. Mr. Folke explained that the proposed ordinance would have addressed that; however, staff is not recommending moving forward with that ordinance due to the issues with the current state laws regarding relocation. Staff’s recommendation is that this issue be added to the City’s legislative agenda. Ms. D’Andrea stated that a change to the Mobile Home Tenant Act is needed to allow local government to legislate in the area of mobile home owners in mobile home parks.
 
Councilmember Evans indicated that there are three different things that the City has control over; the first being that the City needs to go to its representatives stating that the current state law is inadequate and there needs to be changes. Second is that the City can utilize the current regional plan to make sure that when people come to the Council with rezoning requests and there is relocation involved that they are meeting the spirit of the policy. And third is the notification component to residents and potential residents that a mobile home park is up for sale.
 
Vice Mayor Barotz stated that in regards to the notification piece it is really a disclosure issue and asked if the zoning ordinance is the best place to address that. Ms. D’Andrea agreed and stated that staff will look at alternative locations and the best place to house the notification requirements.
 
Councilmember Overton clarified that if the City were to legislate locally it would give up the right to the state compensation options. Ms. D’Andrea stated that he is correct and that some states have concurrent legislation that allows the cities to provide additional support to relocation efforts.
 
Councilmember Putzova asked if staff can ask applicants through the application process how many affordable housing units they would be creating. Mr. Folke explained that the application can be revised and questions can be asked in that regard.
 
Councilmember Evans stated that she feels that adding this issue to the legislative agenda is important. The City should engage all the stakeholders and have a community discussion on what the issues are and where the gaps are. Councilmember Putzova added that the City cannot apply its regional plan policies effectively because of the existing state law. The City should take a position on this issue. Vice Mayor Barotz stated that it would be helpful to understand how the City would propose filling the gaps and what solutions are being suggested. She requested this information be included when staff returns to Council for further action.
             
11. Discussion of City Manager Recruitment Process
  Human Resources Director Shannon Anderson addressed Council asking for direction on the type of process they would like to conduct for the recruitment of a new City Manager.
 
Mayor Nabours stated that Council has a list of the different considerations and asked if there is anything that they would like to add or eliminate.
 
Councilmember Evans asked why a Masters degree is required for Department Heads but not the City Manager. Ms. Anderson explained that when the City originally recruited in 2007 it was not required and the broadband changed after that. The Council agreed that the two should be aligned and a Masters degree be required for the City Manager.
 
Vice Mayor Barotz suggested requiring a specific number of year experience instead of using the word extensive. Ms. Anderson stated that Division Directors require five to ten years experience. Councilmember Overton stated that he liked the broadness of the existing language stating that sometimes the best candidates do not have the most years of experience. Councilmember Putzova also added that instead of requiring public service experience that it be broadened to just management experience. This would be more open to those that may come from an organization outside of public service.
 
The City Council agreed that the recruitment should be nationwide.
 
Mayor Nabours stated that the next item is what the City Council wants from the recruitment agency. Councilmember Overton requested that the recruitment firm meet with the Council prior to the recruitment so that Council can give their preferences on who and what they are trying to find. Councilmember Putzova asked that they brief the Council on the entire applicant pool and that Council review all of the applications received.
 
Mayor Nabours stated that the next section relates to the in-person interviews. Councilmember Brewster stated that she would like for EAC to have an opportunity to weigh in on the candidates. Councilmember Putzova stated that during the community wide process she feels that it will be important for people to have a way to provide feedback to the Council.
 
Vice Mayor Barotz stated that when Chief Gaillard was brought in the process was very rigorous and the fire staff was thankful for the input they were able to give. There were various exercises that the finalists did that included a lot of fire personnel. She asked if it was possible to replicate some of that type of interaction that is more meaningful than a meet and greet for the employees. Ms. Anderson stated that often times the role play and presentations will include Leadership and Extended Leadership to listen and rate the individual and a larger group could be involved in the process.
 
Councilmember Overton stated that it would be nice, if practical, to visit the communities of the finalists.
             
12.
Review of Draft Agenda Items for the February 3, 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; requests for possible future agenda items.
  Councilmember Overton stated that he will be attending the Planning and Zoning Commission on behalf of himself personally for a project that he is working on. He will not be there in his capacity as a City Councilmember.
 
Vice Mayor Barotz reported that she went to the Arizona Association of Economic Developers legislative update in Phoenix. All of the Economic Development agencies of the state were there and it was very interesting to hear what everyone is doing.
 
Councilmember Oravits reported that he spent the weekend in Phoenix and met with Congressman Gosar and Congressman Schweikert, Treasury Dewitt and a number of people from the House. He had the opportunity to talk about TBT issue on the state side and there is legislation being pushed through to try and fix it. He reported that he took part in a conference call with Speaker Gowan and the Chamber where that was also a topic of conversation.
 
Councilmember Oravits requested two Future Agenda Items the first being clarification on the sign code in regard to window lettering at car dealerships. He would also like to clarify elements of the code and how it pertains to the dealerships in regards to balloon attachments. The second item is to discuss the retention rate in the Police Department and what strategies can decrease the amount 0f officers the City loses each year.
             
15. Adjournment
  The Flagstaff City Council Work Session of January 27, 2015, adjourned at 9:10 p.m.
  _______________________________
MAYOR
ATTEST:

 
 
_________________________________
CITY CLERK
 

    

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

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


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 06-May-24 05:59 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
252 ms 252 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
206 ms 206 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
206 ms 206 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
252 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 @ 17:59:42.042
			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 @ 17:59:42.042
				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 @ 17:59:42.042
			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 @ 17:59:42.042
				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 @ 17:59:42.042
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 17:59:42.042
	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 @ 17:59:42.042
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:59:42.042
		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 @ 17:59:42.042
	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 @ 17:59:42.042
		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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
		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 @ 17:59:42.042
		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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:59:42.042
	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=15ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:59:42.042
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2015-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:59:42.042
			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(304 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 @ 17:59:42.042
	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 @ 17:59:42.042
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 304 
getAllMnLines (Datasource=frsRO, Time=49ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
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 = 304 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 = 41 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 @ 17:59:42.042
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 @ 17:59:42.042
	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 @ 17:59:42.042
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
		
	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 = 41 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 41 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 @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1493 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 959 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1499 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1491 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 956 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1494 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 962 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1492 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 965 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1501 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 968 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1502 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 971 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1506 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 974 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1505 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 977 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1504 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 980 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1503 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 983 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1495 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 986 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1497 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 989 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1496 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 992 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1498 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:59:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 995 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:59:42.042
	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 @ 17:59:42.042
	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 @ 17:59:42.042
		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 @ 17:59:42.042
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2015&dsp=min&seq=304
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=1&get_year=2015&dsp=min&seq=304
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=9567516
cftoken=54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
hitcount=4
lastvisit={ts '2024-05-06 17:59:42'}
timecreated={ts '2024-05-06 17:59:42'}
urltoken=CFID=9567516&CFTOKEN=54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
Cookie Variables:
CFID=9567516
CFTOKEN=54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=304
Session Variables:
cfid=9567516
cftoken=54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9567516_54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
subdir=/public/
tzoffset=0
urltoken=CFID=9567516&CFTOKEN=54f18421d5fdce7f-256BDA55-C190-5B2C-B3066CCC66CC03D7
URL Parameters:
dsp=min
get_month=1
get_year=2015
id=
mt=ALL
seq=304
Debug Rendering Time: 15 ms