Return
  SPECIAL COUNCIL MEETING
FRIDAY, JULY 7, 2017

COCONINO COUNTY BOARD OF SUPERVISORS CHAMBERS
219 EAST CHERRY
FLAGSTAFF, ARIZONA
 
             
1. Call to Order

Mayor Evans called the Special Meeting of July 7, 2017, to order at 10:00 a.m.
             
2. 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:

NONE






  Others present: City Manager Josh Copley and City Attorney Sterling Solomon
             
3. Discussion of City Properties to be Included in the Affordable Housing Request for Proposals (RFP).
  City Manager Josh Copley reviewed why they were meeting today, what they are meeting for, and a little about the petition.

He said they have been meeting on the affordable housing project, which came before Council previously on May 23, 2017, and June 27, 2017, regarding the scoping of that project. They have been working at a somewhat expedited pace in an attempt to beat the deadline of March 1, 2018, for the tax incentive program, to get it through the development process.  The project has to be substantial;y complete before it is submitted for the low-income tax incentive.

He said that the reason they are meeting today is because at the meeting on June 27, 2017, there was discussion on the status of the properties and today they wanted to discuss adding the Elden property. They put the prior process on hold at this time. They have learned that it can be put on hold while they look at different aspects.The question today is whether they want to add Elden property to the RFP (Request for Proposals). The reason for the rush, after the meeting adjourned on Tuesday evening, Council went on their Summer Break, and because of prior commitments, they did not want to put off consideration of the RFP process.

They are not here today to discuss the citizens petition submitted on July 5, 2017; that is scheduled for August 15, 2017. There is a conflict in that the City's Charter states that the petition must be acted upon within 31 days of submission, and at the Council's next regular meeting. Today is the Future Agenda Item Request (F.A.I.R.) to determine if this will move forward to August 15, 2017.

Councilmember Barotz said that the tax credits were referenced, and it sounded like it was the City to apply, but the developer does the actual submission. She said that it was stated a prior Council discussed what should be done with the property on Elden to benefit affordable housing, which could be placing affordable housing on that site, or selling the property and the proceeds would be used for affordable housing. There have been discussions on the southside regarding that parcel and concerns have been voiced. They would like to see something in the two-story range.

He said that by adding Elden into the mix, some may think they would then not need to include the Schultz Pass property. He said that it is too early to make that determination because they need to have an analysis done.

Councilmember Odegaard asked if they will be able to hear the history of what the RFP has looked like already. Mr. Copley said that due to proprietary reasons, the prior RFP's are not public at this time, but neither of the proposals are to put affordable housing on that parcel. Councilmember Odegaard then asked for an explanation of the low-income tax incentive and whether it had been used in the past.

Mr. Copley said that there has been a lot of talk and speculation on other City properties available, other than the three, that are available to insert into the mix in order to meet the March 2018 deadline. There is one property, and that is the Elden property. The work that it would take to prepare the other properties to go through the legal issues, makes them not viable at this time.

Mayor Evans said that on June 27, they had a presentation by Ms. Darr where they identified 60% of AMI and they had over 700 residents on a waiting list. Between 120 and 80% that qualified, there's a shortage of 3,000 housing units. Even if they took all of the City property  and it was available now, theystill would not have enough housing in Flagstaff. Mr. Copley said that without some extensive redevelopment that would be correct. If the developer meets the deadline, the 60 or so units is a drop in the bucket of the community's needs. There will be overlapping submittals with the next round starting before this round ends.

Councilmember Barotz reemphasized that the Council does not meet in private. All of their meetings are in public. Any suggestions that they are conspiring behind the scenes are not true. She ommended the Attorney and Manager for guiding them in meeting the Open Meeting Law.
  Housing Manager Justyna Costa then began a PowerPoint presentation to review the RFP process (Exhibit A attached hereto and made a part hereof), and Real Estate Manager Charity Lee reviewed the various property owned by the City included in this PowerPoint.

Councilmember Barotz, in referring to the Council direction received on May 23 and June 27, 2017, said that she hoped that they would set the bar higher than hat the surrounding landscaping. Councilmember Putzova added that she would like to see them use that higher level of standard for landscaping on all City projects, not just this one. Mr. Copley replied that when the City is the property owner, they hold themselves to a higher standard.

Councilmember Barotz asked what the process is for a piece of property being included in the Parks and Recreation Master Plan. Interim Parks and Recreation Director Rebecca Sayers, said that the Master Plan took a little over two years. They hired a consultant and held many, many public meetings. To include this, they would need to go out to the constituents and receive input.

Councilmember McCarthy said that they could consider that property in the future, but they would not be able to include it in the current RFP due to time constraints.

Ms. Costa then completed the presentation by reviewing the City Manager's Proposal and associated Timelines. 

Councilmember Barotz noted for the public that the developer applies for the low-income tax credits and, if received, they then sells them to large corporations who buys them with cash which the developer then uses to building the project. She also asked if this could be used for student housing. Ms. Costa said that the RFP would not be useable for student housing.

Ms. Costa said that the award would be contingent upon the success of the developer in obtaining the tax credits. This type of funding has been used in the past for developments, but not recently, which is why staff believes there is a good chance of the developer receiving them. She said that the applications are based on ranking criteria, one of which is the developer's readiness. This is why the timeline is so critical, and it is the City's role to help the developer be as ready as possible.

Discussion was held and Council directed staff to keep all of the properties in the RFP limited to a height of two stories, out of respect for the neighborhoods. Additionally, discussion was held on the difficulty in determining how many units could be provided on each of the parcels.

Mayor Evans said that they have been contacted by many residents asking why the deadline has come up so quickly, and if staff did not know. Ms. Costa said that they talk with developers all through the year. Councilmember Putzova said that it really became clear during the budget process that affordable housing was going to be a priority for the Council and they began focusing on it further. She said that this is one piece of the overall program.

Vice Mayor Whelan said that she believed there was a squeeze play in that when it came up that the Open Spaces Commission had looked at the Schultz Pass parcel, she was surprised to hear that, and it was only because she heard from the community.  Councilmember Barotz asked what all information was provided to the Commission as well. Sustainability Manager Nicole Woodman said that the Open Spaces Commission has been charged with reviewing all of the City-owned properties over the past few years. They have a specific system they use for analyzing the properties. They did not have a presentation from Housing. It is normally a recommendation by the Commission made to Council; they did not have the historical background on the parcel.

Vice Mayor Whelan asked when that information comes back to the Council. Ms. Woodman said that information was submitted from the Commission to her supervisor, but she could not speak to the chain of command from that point. Mr. Copley said that he and Ms. Lee did have some discussions on this, understanding that she is a one-man office, and they have agreed that in the future the City Manager's Office, including the Real Estate Manager, will be more involved in these discussions.

Sustainability Specialist Betsy Emery said that the Commission does not rubber stamp properties.  They consider the open space values as they related to potential development, etc.using a matrix criteria. Sometimes they approve them, and other times they do not.

Councilmember Putzova said that she understood that this particular parcel came forward because it was being considered as part of the affordable housing project. Ms. Woodman said that the Commission discussed this in April and the property was discussed in May during Property Committee. The Commission did not have information on the issues with this property related to the affordable housing aspect.

Mayor Evans said to Mr. Copley that the Council has set a goal for providing affordable housing. If they are going to have a commission reviewing property to decide on open space value, they need to get the affordable housing property and review it with the Commission. That way the next piece of property that comes forward, they are familiar with the background on each piece of property. Mr. Copley said that the message has been clearly heard. He said that it may be time to bring back the Redevelopment Program and review it as well.

Councilmember Odegaard asked Mr. Copley to share with the audience how much the Council approved for affordable housing. Mr. Copley said that it was communicated by Council that it was a priority. Mr. Copley said that the Council approved $300,000 in this year's budget and another $75,000 to further research the possibility of having a bond issue in the future for affordable housing.

A break was held from 11:30 a.m. to 11:45 a.m. Councilmember Putzova left the meeting during the break.

The following individuals addressed the Council:

•G. Shanahan
•Mary Goddard
•John DeGraff
•Emily Peppers
•Stephen Lenhart
•Kyle Anticevich
•Sofia Nicoletti, representing 52 homeowners in Mt. Elden Homeowners Association
•Thomas Chesterman
•David Nicoletti
•Joe Shannon
•Tina Caskey
•Kammi Ann
•Suzanne Motsinger
•General Greg Melikian
•Staci Foulks
•Laura Carter

Comments received included:

•Asked that Schultz Pass Road property be designated as Open Space
•Thanked them for all of the research
•Encouraged Council to rezone property on southside and limit to two-stories
•Many of the people that oppose that property being developed have volunteered in the City for years
•The people opposing Schultz Pass are not opposing it because of some hierarchy
•That piece of property could be the City's crown jewel
•Put housing where there are more amenities
•She was homeless at one time and raised two children for 14 years by herself; she's willing to volunteer where needed
•Bought two Flagstaff history books
•Thanks for putting their petition on the August 15, 2017 agenda
•Those that support this property are considering considerable fundraising efforts
•It has not been shown that this property is the best use for affordable housing
•Reasons for opposition: winter traffic congestion; was a plan for Ft. Valley Corridor addressing low usage; citizens' value natural beauty
•Council should require developers to include affordable housing
•Council has been elected as their representatives
•Have to make decisions based on their moral courage
•In favor of Option 3
•In public's discourse on social media, be respectful
•Preserve the views, but let's help find property for affordable housing
•Supports development of properties, but not Schultz Pass
•Was involved with the Buffalo Park Annex property initiative
•If they don't remember our history, they'll repeat it
•Am surprised that the Council included this in the affordable housing parcels with this recent history
have an opportunity to make a win/win situation out of this
•Has lived on the corner of Schultz Pass and 180
•Has watched over four million people stop and view the property
•There is no end to the difficulties
•He met two high officials of El Paso Gas; they have three 30" of pipes going through that property, and they said no one should agree to putting people on that property
•Believe they have set up a false dichotomy; they don't have to choose between preserving the view shed and affordable housing

Vice Mayor Whelan said that the reason they were elected was for their love of the property. The ability to put words behind their action is great. She asked them what they are to do when they have the love for open space, but also the love for the people of the community that need housing.

Councilmember Barotz clarified that the Council does not have the authority to require developers to include affordable housing in their developments.

The following individuals spoke in favor of including the Schultz Pass parcel in the RFP to provide for affordable house:

•Kristine Pavlik
•Devonna McLaughlin
•Emma McVeigh
•Anamaria Ortiz
•Deborah Harris
•David R. McCain, President of Friends of Flagstaff's Future
•Gloria Valencia
•Leslie Connell
•Emily Melhorn
•Susan Immel
•Rick Lopez

Comments received included:

•Grew up in Cheshire; now lives in Sunnyside
•Has had to make changes because it is hard to live in Flagstaff
•Open space is important, but not more important than housing families
•People of low-income have the right to live in a good neighborhood
•The community's opposition to this has made her feel very unwelcome in Flagstaff
•Works for Home Solutions
•After working with families for the past 13 years, the difficulty remains in housing
•She continues to hear "I support affordable housing, but..."
•This opposition is not new and it will not end
•Her family was here before the inception of Flagstaff
•She has seen many changes in Flagstaff
•As a teacher, working for 17 years, she cannot find affordable housing so she has to live with her parents with her three children
•Went to Housing Authority and was approved, but she is now on a waiting list
•Must have three times the rent salary to rent anything
•They need the housing
•Thanks for allowing community the opportunity to speak
•Years ago she was on the School Board and they were talking about what they were going to do about schools
•She is hearing the same hateful things now that she heard back then
•Everyone has to give up something
•Like the idea of including more properties in the RFP, including the Schultz Pass property
•At the grocery store heard two ladies talking about the property, stating "they don't need those kind of people here"
•They need affordable housing
•Don't like flowers
•Important to remember that affordable housing should be available in all of of the neighborhoods, but also retain their culture
•Be respectful of the neighbors
•Need to stop the white privilege
•55% of Flagstaff are renters
•The Council's only job as an elected official is to improve people's lives
•If not here, where?
•They could not find a piece a property that everyone would agree is a good place for affordable housing

Councilmember McCarthy said that he absolutely does support affordable housing and it should be throughout the City. He said that he also supports iconic view sheds. He would like to find a win/win solution. They should add the Elden property to the RFP, regardless of what they do with Schultz Pass. He believes they should remove the Schultz Pass property.

Mr. Copley recapped his understanding that they have received direction to stay with the direction given on June 27, but adding the Elden property.

Mayor Evans said that in understanding what Councilmember Overton is saying, she would agree to remove the Schultz Pass property. She said that the only reason she is doing that is because she hears the community and she wants to make sure that whatever RFP they put out is successful.
  Councilmember Odegaard said that the current Council puts the best of the community before the party. His recommendation, with no disrespect to anyone, is to remove Schultz Pass off the table and include Elden parcel on the RFP. In looking at the other neighborhoods, they should limit any of the property developments at two stories.

Councilmember Barotz said that she has wrestled with this issue. She supports Option 2 in its entirety including the "no development option" for Schultz Pass. This would allow the most consideration in the future. She thanked Mr. Shannon for his comments in trying to have respect in their discussions. Please be gentle and sensitive to one another.

Vice Mayor Whelan said that it is a great gift to serve everyone, and it is good to see what great staff they have in getting things put together so quickly. She supports Option 2. In agreeing to it, they must check the safety issue of the gas lines running across the property. They are in the beginning of this process and they owe it to every single person to get as much information as possible, and Option 2 does that. The decision as to whether or not they move forward within anything on Schultz Pass property is down the road.

Councilmember Overton said he felt the need to discuss this quickly was because of the timeline. He believes they gave direction to staff to move forward on affordable housing. He said that these three parcels are the most ready for development. He recalls that when the land was purchased on Schultz Pass and the development agreement was written to get utilities on the property, he is not sure that everyone understood what that meant. But, he did not want to include property in the RFP that was never going to be considered. He's disappointed that they are taking the Elden property out of the current RFP. He does not believe that the community has the political will to leave the Schultz Pass property in there. He wished they would. If they left it in, they would have the next three months of bitter discussions. He said they should pull the Schultz Pass property, but he also understands that the Elden piece is going to have limitations on the RFP. If the Schultz Pass property is pulled, they need to repay the funds used out of the affordable housing funds.

Councilmember McCarthy said that Councilmember Overton said much of what was going through his mind. If they did leave it in, they are making the RFP very complicated and he believes that will keep people from submitting on it, and they will go through this same battle six months from now.

Councilmember Overton said that they have not even seen the results of the current RFP that included the Elden parcel.

Mr. Solomon clarified that if they ended with a 3-3 vote, they would be settling with the June 27 direction, although they could further discuss it.

Mayor Evans said that she has been listening to all of this. One of the things that makes Flagstaff what it is, is the views. When she decided to become a single parent she decided to stay here to raise her daughter. When she made that decision it was not based on the views, but more on the people here. It takes the people and the place to make Flagstaff the place that people want to be. She has been on the Council for nine years. Every single time they talk about addressing the needs of the people, they run against this opposition. They heard with it the Schultz Y and the Buffalo Park Annex and McMillan Mesa. Open Space is extremely valuable, but she also wonders at what point they'll become Vail or Aspen, where they have a beautiful view but no one can afford to live here to see it.

Mayor Evans said that they made a decision on June 27, and she appreciated City staff for working on this. She would like to see Option 2 to move forward and take a look at it. It may come back with no development on Schultz Pass, which means the other parts of town will have to take a hit. The Elden property will have to be capped at two stories. They have heard from the community that said they would be happy to have several stories at the other property because they need affordable housing.

Councilmember Overton said he is fine with putting out the RFP, but there is a strong public contingent against the Schutz Pass parcel. They are not unified enough as a Council to include that parcel in the RFP.

She said that she has seen a lot of mean things from everyone, including a statement that if people cannot afford to live here, they should move to Winslow.

Mr. Copley said that they have heard that the Elden piece should be added, and capped at two stories, but they have not heard direction on Schultz Pass. At this time Mayor Evans said that she would break the tie and support removing the Schultz Pass property from the RFP. She said that she was not doing that because she agreed with it, but because she heard what Councilmember Overton was saying that if it remains, this discussion will continue for the next few months and it could have a negative impact on the overall RFP. She said that as a third generation resident, with a fourth generation daughter, she was very disappointed with the community. The City has preserved over 3,000 acres of open space, but have not addressed affordable housing. Mr. Copley summarized that they would include the Elden property, capped at two stories, but remove the Schultz Pass property in the RFP.
  Written comments in support of keeping Schultz Pass property open space were received from:

•Suzanne Motsinger
•Kathleen M. Ryan
•Rachel Bennett
•Stacy Krueger
•Eric Peppers
•Danielle Grimmett
•Jennifer Pritchard
•Sharan Winnicki
•Shelly Hess
•Maiah Jaskoski
•Paul J. Martinez
•Katharine Hawbaker
•Elisha Dorfsmith
•Cynthia Dorfsmith
•Wm. Michael Wilson
•Becky Weidinger
•Roberta Motter
•Nicolaus Hawbaker

The following individuals submitted written comments in support of leaving the Schultz Pass parcel in:

•Dawn Tucker
•Wendy Kozeastie
•Cheryl Blume

Kim Campbell submitted a written comment card in support of all parties sitting down and coming up with a solution.
             
4. FUTURE AGENDA ITEM REQUEST (F.A.I.R.)

After discussion and upon agreement by two members of the Council, an item will be moved to a regularly-scheduled Council meeting.
             
A. Future Agenda Item Request (F.A.I.R.): A Citizens' Petition Requesting Consideration of Council Action to Designate the Schultz Pass Property as Open Space (Cit. Pet. #2017-03).
  Two councilmembers agreed to move this item to a future agenda. Due to the citizens petition, it will be heard at the August 15, 2017, Council Meeting.
             
5. Adjournment


_______________________________________
MAYOR


__________________________________
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 08-May-24 02:55 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 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/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 02:55:26.026
			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 @ 02:55:26.026
				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 @ 02:55:26.026
			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 @ 02:55:26.026
				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 @ 02:55:26.026
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 02:55:26.026
	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 @ 02:55:26.026
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:55:26.026
		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 @ 02:55:26.026
	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 @ 02:55:26.026
		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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:55:26.026
		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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:55:26.026
	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=3) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 02:55:26.026
		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) = 2017-07-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-07-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:55:26.026
			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(604 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 @ 02:55:26.026
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 603 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
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 = 603 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 = 234 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=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
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 @ 02:55:26.026
	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 @ 02:55:26.026
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
		
	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 = 234 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 234 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 @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5832 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5831 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4472 
get_Minutes (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5835 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4437 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4466 
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4467 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4470 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5836 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5837 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4469 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5833 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:55:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:55:26.026
	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 @ 02:55:26.026
	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 @ 02:55:26.026
		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 @ 02:55:26.026
		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=7&get_year=2017&dsp=min&seq=604
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=7&get_year=2017&dsp=min&seq=604
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=9607555
cftoken=ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
hitcount=4
lastvisit={ts '2024-05-08 02:55:26'}
timecreated={ts '2024-05-08 02:55:26'}
urltoken=CFID=9607555&CFTOKEN=ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
Cookie Variables:
CFID=9607555
CFTOKEN=ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=604
Session Variables:
cfid=9607555
cftoken=ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9607555_ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
subdir=/public/
tzoffset=0
urltoken=CFID=9607555&CFTOKEN=ae328872b73fcd96-6C12BFF8-EF82-39D6-F9434B9AB141499D
URL Parameters:
dsp=min
get_month=7
get_year=2017
id=
mt=ALL
seq=604
Debug Rendering Time: 0 ms