Return
CITY COUNCIL WORK SESSION
TUESDAY, JUNE 12, 2018
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
 6:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Evans called the Work Session of the Flagstaff City Council held June 12, 2018, to order at 6:00 p.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Pledge of Allegiance and Mission Statement

The Council and audience recited the pledge of allegiance and Councilmember Barotz read the Mission Statement of the City of Flagstaff.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON

COUNCILMEMBER PUTZOVA
ABSENT:









  Others present: Interim City Manager Barbara Goodrich; Deputy City Attorney Kevin Fincel.
             
4. 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.

None
             
5.
Review of Draft Agenda for the June 19, 2018, City Council Meeting.
  Councilmember Barotz inquired about item 16B and whether it was possible to provide a separate resolution for the affordable housing bond instead of having all of the ballot questions in the same resolution. She thought having only one resolution would require Council to vote no on all of the questions if they wanted to vote no on one of them. Mayor Evans reminded Council that what was sent to the ballot was not an indication of Council’s support of an item; that was just the way they formally send things forward to the voters.
 
Councilmember Barotz then asked what would happen if the resolution did not get a majority vote. Mr. Fincel indicated that the resolution was not required. The items would still be sent forward, but the resolution just officially documented what was being sent to the voters. Councilmember Barotz then indicated that she did not need a separate resolution for each in light of that information. Mayor Evans reiterated that it was just formalizing Council’s previous direction.
 
Councilmember Barotz stated that for item 16C, she had asked the City Attorney’s office to provide some clarifications in the staff report. The date in the Executive Summary was not correct; it should be December 7, 2017. The staff report also needed to incorporate the proposal of changing the date from April 1 to August 1. The proposed ordinance included the date of August 1, but there was no explanation in the staff report regarding the proposed change.
 
Vice Mayor Whelan added that some of the contracts that were attached to the packets were old contracts and mentioned a 2014 contract she saw in the packet. She questioned whether the contracts attached needed to be the actual contracts they were approving. As an example, she referenced the contract for the purchase of the utility water meters, which was blank, and asked, as a general rule, if the actual contract should be attached.
 
Senior Procurement Specialist DiAnn Butkay explained that the contract is blank until Council approves it, then the blanks would be filled in and the contract would then be routed for signature. The 2014 contract was a cooperative contract that was approved by another agency in 2014, and the City would join in on that contract.
             
6. ParkFlag Implementation Update.
  Parking Manager John Portillo provided a PowerPoint presentation that covered the following:
 
PARKFLAG IMPLEMENTATION
PARKFLAG UPDATE
 
Mr. Portillo indicated that Community Design and Redevelopment Manager Karl Eberhard, who implemented the program last year, and Flagstaff Downtown Business Alliance representative Terry Madeksza were both on hand to answer any questions.
 
RESPONSIBILITIES
PARKING AIDES PROVIDE
TRAFFIC CODE ENFORCEMENT
PARKFLAG MANAGEMENT
PROGRAM IMPROVEMENTS
PARTNERSHIPS DEVELOPED
RESIDENTIAL PERMIT PROGRAM
FINANCIALS
 
Councilmember Barotz asked what working with the developers of the Hub to understand their parking needs meant. She wondered if the City was taking on more than it had anticipated. Mr. Portillo responded that the developers had sold out of parking in their facility and were looking for parking options outside their facility. They were looking into options of purchasing parking downtown. Mr. Eberhard indicated that from ParkFlag’s point of view, if they worked with the Hub, they could head off the parking going into the surrounding neighborhoods. Working with them now would be proactive versus reactive. Staff was working on a proposal that would work for any downtown residential parking and would bring that back to Council for discussion.
 
Councilmember Barotz stated she was disappointed because arguments were made about how much parking was needed and why providing limited spaces was okay. The parking overflow from the HUB would have an impact on the downtown area, even if they paid for the parking. She did not think that was what they anticipated when Council made certain decisions going through the planning process.
 
Councilmember Putzova was worried that by accommodating those additional needs and trying to solve the parking problems so neighborhoods would not have to deal with them, that the City might be working against the policies they were putting forward elsewhere. She understood there should not be neighborhoods flooded with cars, and the thought behind working with the developer for more parking, but wondered if it was worth considering what the alternative would be.
 
Mayor Evans commented that she thought there was already a deficiency of approximately 700 parking spaces downtown. Rather than trying to figure out where additional cars were going to go, especially for a development that said they did not need any more parking than they had, she suggested implementing a resident parking permit district in the southside with two-hour parking for non-residents and parking permits for residents. Any excess cars in that neighborhood would then be ticketed. Finding a place for those additional cars would just exacerbate the issue. She questioned why they need more parking once they had sold out.
 
Economic Vitality Director Heidi Hansen clarified that there is currently no agreement with the Hub; the City was approached by them and staff wanted to make sure the Council knew that the contact had been made.
 
Mr. Portillo continued.
 
PENDING CHANGES
CHALLENGES
OUTCOMES
POLICY REVIEWS
 
Ms. Madeksza addressed Council in support of Park Flag. She indicated that the Downtown Business Alliance conducted a short survey of 280 businesses and residents with a good response rate. 73% of the respondents stated that ParkFlag is doing what it intended to do and 70% knew the revenues are going into an account that is set aside for parking improvements.

Terry O’Neal addressed Council in opposition of ParkFlag.
 
Councilmember McCarthy stated that it is good that staff is being proactive about helping with the parking problems at the Hub. He wants to make sure that whatever is proposed will not disadvantage local residents and businesses. The Hub assured the City that most students would not have cars and that they would have excess parking.
 
Councilmember Odegaard indicated that he is hearing things about the locals not coming downtown and suggested some kind of local's day to encourage local citizens to come downtown.
             
7. Direction on solicitation for Urban Farm Incubator.
  Public Works Director Andy Bertelsen introduced Sustainability Specialist McKenzie Jones who provided a PowerPoint presentation that covered the following:
 
URBAN FARM INCUBATOR
WHAT IS AN URBAN FARM INCUBATOR PROGRAM?
WHY IS THIS PROGRAM BENEFICIAL?
PROGRAM GOALS
PROPOSED PROGRAM
BACKGROUND
ARIAL MAP
CURRENT STATE OF LAND
PROGRAM DETAILS
PROGRAM REQUIREMENTS
NEXT STEPS
 
Vice Mayor Whelan asked if there would be any stipulations on the use of fertilizers because of the location. Ms. Jones stated that one of the elements of the license is that they use organic farming practices.
 
The Council was in support of moving forward with the program.
             
8. Update on Rethink Waste Plan Implementation.
  Ms. Jones provided a PowerPoint presentation that covered the following:
 
RETHINK WASTE UPDATE
OVERVIEW
RECYCLING IN FLAGSTAFF HAS CHANGED
WHY IS THIS HAPPENING?
WHAT DOES THIS MEAN FOR FLAGSTAFF?
WHAT IS OUR STRATEGY?
WHICH PLASTICS CAN WE RECYCLE?
WHY ARE WE SORTING BY SHAPE?
THE PROBLEM WITH PLASTIC
HOW ARE WE COMMUNICATING PROGRAM CHANGES?
WHAT CAN RESIDENTS DO?
WHAT CAN THE CITY DO?
 
Vice Mayor Whelan asked about composting. Ms. Jones stated that the City provides individual composting education. Traditionally, the focus has been on what individuals can do. Staff has spent time looking at other municipal composting sites and that is something it could come about with the next phase of the Rethink Waste Plan.
 
Councilmember Overton indicated that it will be a challenging discussion on the language in the contract for the recycling vendor. It will also be a challenge for the community to move away from recycling all plastics. This is an opportunity to renegotiate and find a vendor who will provide a good level of service and it is important to handle the contracts in a way that is not detrimental to the public.
 
Ms. Jones continued.
 
VOLUMETRIC PRICING
WHAT IS VOLUMETRIC PRICING?
BENEFITS OF VOLUMETRIC PRICING
PROGRAMMATIC CONSIDERATIONS
FINANCIAL CONSIDERATIONS
SEEKING COUNCIL DIRECTION
 
A majority of Council is in favor of moving forward with developing a volumetric pricing proposal.
             
9. Future Agenda Item Request (F.A.I.R.): A request by Councilmember McCarthy to place on a future agenda a discussion about the possibility of amending the investment policy to further pursue socially responsible investment.
  Management Services Director Rick Tadder addressed Council stating that the staff summary contains the proposed amendments to the City’s Investment Policy. Currently, there is about $100 million in an investment account to manage the treasuries, corporate bonds, and the like. 90% of the investments are related treasuries and federal government. This is a discussion about what corporations and companies that the City can purchase notes and commercial papers for. In the current policy there is a limit of 20% investment into commercial paper. The City does not invest in commercial paper because they are short term investments.
 
The next item is a 10% cap on investment in corporate bonds or notes. Currently, the City is investing about 8% in corporate notes. The City buys debt that they are offering on the open market to include in its portfolio, the City becomes who they pay interest to on those debt obligations.
 
The other item in the draft language relates to a resolution Council passed related to the border wall that indicates that the City will not invest in companies that design, construct, or maintain the border wall.
 
A written comment card in support of moving the F.A.I.R. item forward was submitted by Dawn Dyer.
 
Councilmember Putzova stated that she would like to see the item move forward and would like a presentation from an expert in socially responsible investing.
 
A majority of Council was supportive of moving the item forward and receiving information from an expert in socially responsible investing.
             
10.  2018 Ballot Discussion: Potential Housing Measure.
  Ms. Goodrich stated that the purpose of the presentation is to get Council direction on whether or not a bond question should be placed on the upcoming election ballot. Ms. Goodrich introduced bond consultant Alan McGuire who provided a PowerPoint presentation that covered the following:
 
UPCOMING DATES
HOUSING – SECONDARY PROPERTY TAX
PROPOSED BALLOT LANGUAGE
 
The following individuals addressed Council in favor of placing a housing bond question on the upcoming election ballot:
  • Emily Melhorn
  • Tad Moore
  • Terry White
  • Rick Lopez
  • Steve Peru
  • John Stigmon
  • Devonna McLaughlin
  • Regina Salas
The following comments were received:
  • The scarcity of housing one can afford is a big issue in Flagstaff.
  • Middle class people with stable jobs are lifetime renters.
  • People with full time jobs are staying in shelters and older individuals are living with roommates.
  • Flagstaff trains employees who then leave the community in seek of better housing opportunities.
  • Putting this on the ballot is something the Council can do; it will not solve everything, but it will be a meaningful step in the right direction.
  • Housing is a systematic problem.
  • The housing issue affects middle income residents too; nurses, teachers, and police officers are unable to afford housing in Flagstaff.
  • Businesses are losing highly qualified employees every day.
  • 38% of employees are driving over 50 miles to Flagstaff to work.
  • A housing bond would go a long way towards making Flagstaff more attractive to existing and new residents.
  • The public deserves the opportunity to decide.
  • This is an opportunity to create options and opportunities.
  • The housing situation is critical and anything that can be done to mitigate this is important.
  • The jobs that are leaving the community are public safety and service jobs.
  • The proposed bond could really help the workforce population at 80% AMI and above.
  • Many people who are able to qualify for a loan are unable to qualify for the amount needed to purchase in Flagstaff.
  • It is important to get more information out to the public in terms of how much property taxes will increase and what the implementing mechanism and guidelines are.
The following individuals addressed Council in opposition of placing a housing bond question on the upcoming election ballot:
  • Charlie Silver
  • Terry O’Neal
The following comments were received:
  • There are too many unanswered questions; is there a residency requirement, an income eligibility range, resale formulas, and permanent affordability?
  • $35 million is a large percentage of the City’s bonding capacity.
  • Perhaps a smaller bond directed toward non-profit developers is a better option.
  • The question is not addressing the issue of land and development.
  • If passed, it will create another bureaucracy.
  • Look at other means, primarily land to develop.
Councilmember Putzova stated that the question does not specify if funding could go toward acquiring housing units that are at market rate. She would like to see language about increasing the number of housing units below market rate.
 
Councilmember Barotz stated that there is no certainty in the language about how the program would be structured and there is a considerable lack of clarity around the issue. Mr. McGuire stated that the language was purposefully general to provide for flexibility as the conditions around housing change.
 
Vice Mayor Whelan offered that the Flagstaff Watershed Protection Project question that was brought forward was also very general because all the knowns were not known at that time. This question is meant to address an affordability gap and there are just a lot of unknowns right now that can be addressed as thing move forward.
 
Mayor Evans stated that housing has been a community concern for decades and it is time for a road to resolution. Things change over time and they will continue to change over the 20-year period of this bond. The question is written in a way that acknowledges those changes and allows for adaptability.
 
Councilmember McCarthy expressed concern about the $35 million amount when looking at the bonding capacity and other things that the City may need to bond for in the future. He recommended a bond amount of $25 million instead.
 
Councilmember Barotz expressed support about moving the concept forward but she is concerned about the language. She is willing to support the question but would like for the amount to be reduced to $10 million and the language changed to create and appoint a committee. She expressed concern about the consequences of the full $35 million. Housing is important but so is water and there would only be $15 million left in bonding capacity to address other important issues.
 
Councilmember Odegaard indicated that he is supportive of the $10 million suggestion with the stipulation that bullet point number two be removed.
 
Mayor Evans stated that perhaps there is a middle ground on the bond total, somewhere between $35 million and $10 million. She is not supportive of removing bullet number two because it addresses the issue of getting people into units through homebuyer assistance. The issue is not that people cannot pay the mortgage; the issue is that they cannot save for a down payment because the rent is too high. Removing item two would eliminate the homebuyer assistance opportunity. She is supportive of adding language that allows the Council to appoint the committee members.
 
Councilmember Odegaard offered that his issue with item two is that bonds are intended to help the community as a whole and not just a specific group of people. His concern is about wealth redistribution.
 
Vice Mayor Whelan indicated that the City had a Homebuyer Assistance Program that was eliminated during the downturn. This type of program helps elders and middle-income earners in the community. It helps keep people in Flagstaff contributing to the vibrancy of the community.
 
Councilmember Overton stated that he is not supportive of the question because the timing is bad, and the question is not well crafted leaving a lot of unanswered questions.
 
A majority of Council was supportive of reducing the amount to $25 million and forwarding the item to the ballot.
             
11. Public Participation
  Terry O’Neal addressed Council with concerns about a major accident with the railroad and the impacts that would have on the city.
             
12. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Odegaard reported that his mother-in-law is doing very well and will be going home tomorrow.
 
Councilmember Barotz expressed appreciation to the Flagstaff Police Department and their work in identifying the person who hit the cyclist and drove away.
 
Councilmember Putzova requested a F.A.I.R. item to discuss what kind of policies the City can create to designate certain areas for people without shelter to park or set up temporary shelter.
             
13. Adjournment

The Flagstaff City Council Work Session of June 12, 2018, adjourned at 8:07 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 04-May-24 11:31 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
266 ms 266 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/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
282 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 23:31:46.046
			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 @ 23:31:46.046
				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 @ 23:31:46.046
			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 @ 23:31:46.046
				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 @ 23:31:46.046
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 23:31:46.046
	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 @ 23:31:46.046
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:31:46.046
		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 @ 23:31:46.046
	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 @ 23:31:46.046
		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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
		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 @ 23:31:46.046
		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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
	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 @ 23:31:46.046
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:31:46.046
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:31:46.046
		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) = 2018-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-06-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:31:46.046
			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(727 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 @ 23:31:46.046
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 726 
getAllMnLines (Datasource=frsRO, Time=63ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
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 = 726 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 = 403 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=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
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 @ 23:31:46.046
	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 @ 23:31:46.046
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
		
	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 = 403 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 403 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8945 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8950 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8943 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6317 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8944 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8946 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6319 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8954 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6320 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8953 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6321 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8952 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6322 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8955 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6323 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8956 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6324 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8948 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6325 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8947 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6326 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8949 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:31:46.046
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 23:31:46.046
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 23:31:46.046
	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 @ 23:31:46.046
		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 @ 23:31:46.046
		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=6&get_year=2018&dsp=min&seq=727
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=6&get_year=2018&dsp=min&seq=727
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=9521677
cftoken=70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
hitcount=4
lastvisit={ts '2024-05-04 23:31:46'}
timecreated={ts '2024-05-04 23:31:46'}
urltoken=CFID=9521677&CFTOKEN=70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
Cookie Variables:
CFID=9521677
CFTOKEN=70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=727
Session Variables:
cfid=9521677
cftoken=70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9521677_70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
subdir=/public/
tzoffset=0
urltoken=CFID=9521677&CFTOKEN=70613d8f320662c3-CA4EB8C8-96FD-0AD1-BC61BF5635DA9BDB
URL Parameters:
dsp=min
get_month=6
get_year=2018
id=
mt=ALL
seq=727
Debug Rendering Time: 15 ms