Return
 WORK SESSION
TUESDAY, JANUARY 31, 2017
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of January 31, 2017, to order at 6:01 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 regular meeting, 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

The Council and audience recited the Pledge of Allegiance.
             
3. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

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.
             
4.
Preliminary Review of Draft Agenda for the February 7, 2017, City Council Meeting.*
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.

None
             
5. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
  The following individuals addressed Council in opposition of the increased minimum wage:
 
  • Jesse McGirl
  • Lisa Korokiewicz
  • Frank Branham
  • Nancy Branham
  • Laurie Bosse
  • Stuart McDaniel
  • Monica Attridge
The following comments were received:
  • Urge Council to call a special election in May.
  • Give businesses a chance to adjust and give the City time to develop their enforcement.
  • Most Flagstaff restaurants pay well, it is difficult if they have to pay more to the tipped employees.
  • The passage of 206 and 414 is not sustainable.
  • Think about the small family-owned businesses in town.
  • The City alone will have a $75,000 to $100,000 cost for the increase not to mention the funding needed for the department to regulate and monitor.
  • The impacts of the increase in minimum wage to the disabled community is vast.
  • Individuals with disabilities have built relationships in the community, have jobs in the community and a sense of belonging in the community; many of them will have to leave Flagstaff and the things they have worked so hard to achieve.
  • 76% of Flagstaff supports a special election to amend the wage increase.
  • Many people voted for 414 but are now very concerned about the outcome.
  • Assistive services cannot reduce staffing ratios because they are mandated by the State as are most of the costs; this increase will shut those services down and leave a vulnerable population without resources.
Written comment cards in opposition to the minimum wage increase were submitted by the following:
  • Anthea Hajjar
  • Gus Miller
  • Valerie Langin
Gabor Kovacs addressed Council and expressed a need to unify the City and the country and focus on things that hold communities together.

David Cole addressed Council to object to a parking ticket he recently received.
             
6. Recognition of the NAU Men's Cross Country Team.
  Mayor Evans explained that former City Councilman Nat White brought this item to the attention of the Council. There are some amazing athletes in Flagstaff. She asked for the NAU Men's Cross Country Team to stand and be recognized. The team secured the first victory of the NCAA Division I National Championship which is the first national title for NAU as a cross country program and the first NCAA Championship for a Big Sky Conference school outside of football.

Mayor Evans and the Council came to the podium to read and present the team with a proclamation.
             
7. Discussion of Resolution Opposing Dakota Access Pipeline.
  Mr. Copley explained that there is no formal presentation on this item, it is a time for Council to discuss and provide direction to staff if desired.

The following individuals addressed Council in favor of a resolution opposing the Dakota Access Pipeline:
  • Dawn Tucker
  • Susan Wesley
  • Tyler Barnard
  • Marlena Garcia
  • Adam Shimoni
The following comments were received:
  • This issue is extremely relevant today since President Trump has issued an Executive Order to advance the approval of the pipeline.
  • A resolution would demonstrate that Flagstaff stands with those water protectors and indigenous communities.
  • Friends of Flagstaff's Future urges the Council to support a resolution opposing the Dakota Access Pipeline.
  • Mainstream media is not giving the full picture; the protests are mostly beautiful and cohesive.
  • It is important to stand with the City's indigenous brothers and sisters.
  • This issue is inter-connected with issues happening in Flagstaff.
  • Flagstaff needs to acknowledge that the pipeline is not just a native issue, it affects everyone in every single way with what it will do to the water.
  • Flagstaff must send a very strong message of support for the indigenous communities.
  • Government and society needs to prioritize the needs of the people over the needs of money.
  • Council is an extension of the people and the people are asking the Council to represent them in opposing the pipeline.
Gabor Kovacs addressed the Council in opposition of a resolution opposing the Dakota Access Pipeline stating that it is an issue that is political in nature and not relevant to Flagstaff.

Written comment cards in favor of a resolution opposing the Dakota Access Pipeline were submitted by the following:
  • Claire Silvernale
  • Angela Espinoza
  • Frankie Beesley
  • Stefano Cualva
  • Elea Ziegelbaum
Councilmember Putzova offered that she had brought this item forward in the past and a majority of Council at the time was not interested in moving it forward. She explained that it is important for Flagstaff to take a stance on this issue that the community asked for. The issue is broad; it is environmental, it is human, it is about respecting treaties. She would like for the Council to bring forward a resolution and she requested that it includes meaningful and actionable steps the City can take. She requested that the closing clause include the severing of ties with institutions that finance the pipeline for as long as they finance the pipeline.

Vice Mayor Whelan stated that she is in support of a resolution; it is a meaningful way to make a clear statement with strength and compassion. Councilmember McCarthy stated that he, too, is supportive of a resolution that opposes the pipeline. He would like further discussion on the content.

Councilmember Barotz offered that there is a large contingent of people who have and continue to urge Council to provide a resolution in opposition of the pipeline. Mayor Evans offered that she is looking forward to the Council moving forward with the resolution and crafting the language. It is about respecting the rights of treaties and sovereign nations.

A majority of Council is in favor of moving this item forward and request staff to bring back a draft resolution.
             
8. Discussion/presentation regarding a proposed 2017 Arizona Public Service Rate Case to the Arizona Corporation Commission.
  Mayor Evans declared a conflict of interest and left the dais at 7:03 p.m.

Sustainability Manager Nicole Woodman provided a PowerPoint presentation that covered the following:

DISCUSSION
RATE CASE OVERVIEW
IMPACTS OF RATE CASE
COMMERCIAL
RESIDENTIAL
RESIDENTIAL SOLAR
SUSTAINABILITY PROGRAMMING

Councilmember Overton asked how the rates would affect the City's public, private partnerships. Ms. Woodman explained that those agreements and partnerships are locked and are not affected by a rate change.

Director of State Affairs and Compliance for APS Greg Bernosky continued the presentation.

APS RATE REVIEW: ENSURING A SUSTAINABLE ENERGY FUTURE FOR ARIZONA
RATE REVIEW OBJECTIVES
KEY DATES IN REGULATORY PROCESS

Councilmember Putzova asked Mr. Bernosky to focus on some of the key concepts; she would like to understand the mandatory demand charges and the issue with the net metering charges. Mr. Bernosky stated that there was a separate proceeding related to solar policy that was recently resolved that is somewhat related to the APS case. The APS case focused on rate design and revenue needs but had a placeholder for the solar proceedings. Now that the solar proceeding has concluded, those policies will be incorporated into the case.

Councilmember McCarthy asked if the existing policy is if a solar customer sells APS a unit of electricity they do so at the same rate that they pay when they buy the electricity. Mr. Bernosky agreed stating that the electricity is compensated at the retail rate. Councilmember McCarthy then asked if the new policy is that the solar customer will pay a certain dollar amount per kilowatt hour and when they sell it back to APS they will no longer get that dollar amount back but rather a percentage of it. Mr. Bernosky explained that the decision created a methodology so each utility now has to take all the numbers they have to create that compensation rate and the commission has to make a decision to agree with the number and that will set the price going forward. It is a percentage but it has not been set yet. When APS filed their testimony that rate came out to about 11.5 cents for the export rate.

Councilmember Barotz asked for Mr. Bernosky to describe the APS proposal in his own words. Mr. Bernosky stated that APS is asking for a rate increase based on residential and commercial rates that are on average about a 5.74% increase. APS has to balance the cost of all investments with rates that are fair and equitable for all customers. There is still a portion of solar users energy needs that have to be met by the grid, so the infrastructure, generation, transmission and distribution and everything that goes into that home is still necessary because that system will stop producing at some point. The gird and resources have to be there; APS recognizes the value that those systems bring but also have to recognize the other costs as well.

Councilmember Barotz stated that the proposal includes rate demand and rate charge; she asked for a basic understanding of those terms and how that will change with the proposal and why is that good for the customer. Mr. Bernosky stated that there are already 120,000 customers who are voluntarily on the rates just mentioned. Councilmember Barotz confirmed that the proposal would make it mandatory for all customers. Mr. Bernosky confirmed and stated that time of use is part of the demand rate that is important. The time of use window has a higher cost during on-peak times and lower cost during off-peak times. APS has proposed a time of use proposal of 3:00 p.m. to 8:00 p.m. The demand rate is the billing component for how much energy a customer is using for a one hour period during on-peak times. The demand charge is the charge associated with the rate.

Councilmember McCarthy asked if he is correct in understanding that with demand rate billing APS charges less for energy used but the added demand fee is a separate charge. Mr. Bernosky stated that he is correct in that the per kilowatt rate is lower, the demand rate is based on the total maximum kilowatts used during that peak time. Councilmember McCarthy asked if there is a fee or a change in the charge per kilowatt hour. Community Affairs Manager for APS Jenna Rowell stated that the bill would have a fixed service charge based on the rate plan, then there is the usage; the proposal is that the unit cost for that energy would actually be lower and the bill would include a demand charge. There is a rate set that is dependent on usage between the 3:00 p.m. and 8:00 p.m time period for a one hour interval that will determine the demand charge.

Senior Attorney with the Arizona Corporation Commission Maureen Scott stated that there is a wealth of information on the APS rate case on the Arizona Corporation Commission website and it will provide up to date information on the status of the case. APS filed their original application and direct testimony in June 2016. The staff and interveners in the case filed direct testimony on revenue requirements in December 2016. There is another filing coming up the end of the week on rate design and staff and interveners will be filing their direct testimony responding to the APS proposed rate design. Staff will then come back and give their views on what the rate design should look like.

Councilmember Barotz stated that there was an article in the Arizona Republic on January 13, 2017, that indicated that the staff at the Arizona Corporation Commission and the Residential Utility Consumer Office both recommended no increase. Ms. Scott stated that it was part of the testimony in the revenue requirement case and was based upon the review of the application. She added that it is likely to change because other parties have filed on the issue and all the filings are taken into consideration and may have an impact on the staff recommendation. The rate design phase is the later part of the case. The parties have entered into settlement discussions and they are open to all the interveners to discuss. During the settlement process the original numbers could be subject to change.

Ms. Scott offered that the Commission invites residents to submit public comment; it can be submitted verbally or in writing. The Commission reviews those comments and they are part of the record. Deputy City Manager Shane Dille stated that Commissioner Burns had suggested the possibility of holding a public forum in Flagstaff; he asked if there has been any response to that idea. Ms. Scott stated that she is not aware but it is likely when a Commissioner requests a public comment period to be held in a particular location that it is carried out. Mr. Dille offered that Flagstaff would be willing to host the event should it be amenable to the Commission.

The following individuals addressed Council in opposition to the APS rate case proposal:
  • Larry Holland
  • Bobby Ecclestan
  • Derek Turner
  • Hadassah Ziegler
  • Brian Siebert
  • Seth Holland
  • Adam Bruce
  • Lucy Mason
  • Tom Chabin
  • Janet Regner
  • David Carlile
  • Alan Francis
  • John Viktora
  • Paul Wagner
The following comments were received:
  • If APS has their way businesses like Rooftop Solar will be a thing of the past.
  • The APS proposal will affect rooftop solar companies negatively.
  • Rooftop solar has become more affordable and more people are able to install them; new people will not want to come on if the APS case goes through.
  • Rooftop Solar has expanded to California because there is so much uncertainty in Arizona and it is unknown if the business will continue to be viable in Arizona.
  • Solar is good for the environment and it is good for the economy, do not change that.
  • APS is a partner and the grid is important, this is simply about profits.
  • The net metering charges will put a halt to rooftop solar growth.
  • The proposed changes will affect businesses and the opportunities for homeowners to be more sustainable.
  • If APS gets rid of net metering it takes away all incentive for customers to go solar.
  • Flagstaff should take a stand at the Arizona Corporation Commission in opposition of the APS rate change.
  • APS recently paid $4 million to the campaigns of now seated Corporation Commission members.
  • The proposal is confusing and there are so many layers, it is impossible to understand.
  • APS is failing to adapt to the needs of the customers.
  • New solar businesses are hesitant to come to Arizona because of the legislative decisions and the attitude of the utilities.
  • Support the solar companies that want to be in Arizona.
  • Council needs to take a position on the rate case.
  • Solar customers have paid for the investment on their home and when they produce an extra kilowatt APS takes that and sells it to their neighbor at retail price; the proposal will now make the solar customer pay for that extra kilowatt when they need it back.
  • Net metering and no demand charges make solar viable for users at the residential level.
  • There is a concern about the impacts of the changes on low income users in Coconino County.
  • The question to ask is if the rate case is an incentive or disincentive for solar.
  • These changes have a direct impact on the feasibility of a solar system and the ability for a customer to recoup their investment.
  • Go slow and see what happens with the investigation.
  • Had the proposed rate design been in place when previous systems were installed it would be far less likely that a customer would move forward.
  • Oppose any fundamental change that would make solar less feasible for residential customers.
A written comment card in opposition of the rate case was submitted by Andy Fernandez.

Councilmember Putzova expressed disappointment in the presentation and stated that the City should engage and oppose the rate case. APS is comfortable buying Commissioners because it is legal and that is a problem.

Councilmember McCarthy stated that he is still confused about the proposal and asked that APS better define the terms so they can be easily understood by the public. He stated that he is open to engaging with the Corporation Commission but does not want to support a broad statement of opposition but rather specific things that the City is opposed to. He feels that more information is needed before a resolution could be drafted.

Councilmember Overton stated that if the Corporation Commission could hold a hearing in Flagstaff there would be good interest and participation from the public. The complexities make it difficult to formulate language for a resolution. It would not be unreasonable for the City to present the thoughts of the community at the hearing.

Councilmember Odegaard offered that if the Corporation Commission could hold a meeting in Flagstaff the Council and the community could voice their concerns and have more of a direct impact. It is always challenging when rates have to be increased and it is not an easy thing to do but is often times necessary. He would be interested in a policy that allows solar to be used more readily in the community.

Councilmember Putzova requested that staff very succinctly explain the demand charge and get to the core of what the proposal is requesting.

Mr. Dille offered that it would be good to understand what the community should expect if a hearing comes to Flagstaff. Ms. Scott offered that when the Commission holds a public comment at a location they invite members of the public and invite them to make comments. The Commission would listen to what is said and may ask questions. Additionally, there may be someone there who can speak more technically to questions. Another option for participation is called intervention. The deadline has passed but the Commission will often entertain a late intervention request. Intervention allows the City to participate as a party in the case. Mr. Solomon stated that if intervention is something the Council would like to consider it would be a discussion for executive session.

Vice Mayor Whelan stated that the Council would like to engage with the Corporation Commission and they look forward to a possible hearing in Flagstaff.

A break was held from 9:17 p.m. through 9:25 p.m. at which time Mayor Evans returned to the dais.
             
9. Discussion of Current Issues Before the Arizona Legislature and Federal Issues.
  Interim Assistant to the City Manager Gail Jackson stated that Federal Lobbyist Bob Holmes and State Lobbyist Richard Travis are on the phone and are available for any questions. Ms. Jackson provided a PowerPoint presentation that covered the following:

STATE & FEDERAL LEGISLATIVE UPDATE
FEDERAL EXECUTIVE ORDERS

Councilmember Overton stated that there is a lot of momentum with some of the Executive Orders recently and asked if there are ways the City might capitalize on them with capital improvement projects. Mr. Holmes stated that one of the things President Trump has proposed is a trillion dollar infrastructure plan to work on roads, bridges and airports. It is definitely an opportunity for the City. He does not think Crongress will approve a trillion dollar plan but there will be an opportunity for infrastructure and is something the City should be watching for. Councilmember Overton stated that the City is well prepared to have things in order to move forward and there may be projects in the que and ready if and when the time is right. It will be important to watch this closely and lobby hard for the City.

Councilmember Odegaard stated that it is important for the Council to pick one project that is ready to go other than the funding. Mr. Copley has identified the Fourth Street Bridge as a priority. He asked if there is anything that should be done to this regard in preparation for the lobbying trip in March. Mr. Holmes stated that it is a great idea to pick one project and focus on that. On the federal level, the one thing that holds things up is environmental reviews. The other thing that is very important is getting on the State's five-year plan; that will help when the City is lobbying for federal funds.

Ms. Jackson continued.

HOUSE BILLS
SENATE BILLS
ADDITIONAL ITEMS

Mr. Travis stated that a series of RICO bills dropped and more are anticipated. If property is seized from a defendant upon conviction the property is sold for cash, the victims are made whole and the balance goes to the arresting and prosecuting agencies. Flagstaff receives funds every year from this fund. There has been a movement to take a look at those practices on how that money is distributed. The bills run from stopping those funds to more reporting and more oversight. Most jurisdictions have a board that oversees the allocation of these funds. Cities have not been singled out as being part of the problem but whatever solution is being discussed will be universal state wide and would have an impact locally.

Councilmember Barotz asked about the bill that would allow candidates to collect petition signatures electronically through an online portal. Mr. Travis stated that he believes this bill is included with a series of other election bills; more and more electronic signature bills are coming through as technology advances.

Councilmember Odegaard asked about the minimum wage bill and if it has any traction. Mr. Travis explained that the bill will probably move through but there will not be any final action until the Supreme Court decision and opinion are issued.
             
10.
Review of Draft Agenda Items for the February 7, 2017, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.

None
             
11. Public Participation

None
             
12. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Putzova reported that she attended the ECONA and NAIPTA meetings last week. The ECONA staff heard Council and future meetings will be more policy focused. NAIPTA has a lot going on and they are in the process of updating their five year plan.

Councilmember Putzova requested a FAIR item for a discussion about expanding the use of reclaimed water for non-recreational purposes where potable water is being used.

Mayor Evans extended thanks to the snow plow drivers that did a phenomenal job of keeping the streets clear and open. Councilmember Odegaard added that the downtown area looks great.

Coucilmember Barotz clarified the FAIR item she requested is a review of the board and commission member Council appointment process.
             
13. Adjournment

The Work Session of the Flagstaff City Council held January 31, 2017, adjourned at 9:51 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 19-May-24 08:25 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
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
265 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 @ 08:25:48.048
			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 @ 08:25:48.048
				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 @ 08:25:48.048
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:25:48.048
	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 @ 08:25:48.048
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:25:48.048
		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 @ 08:25:48.048
	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 @ 08:25:48.048
		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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
		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 @ 08:25:48.048
		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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:25:48.048
	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=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:25:48.048
		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-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-01-31 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:25:48.048
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
		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 @ 08:25:48.048
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 = 533 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:25:48.048
		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) = 533

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:25:48.048
			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(533 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 @ 08:25:48.048
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 532 
getAllMnLines (Datasource=frsRO, Time=62ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
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 = 532 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 = 199 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 @ 08:25:48.048
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 @ 08:25:48.048
	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 @ 08:25:48.048
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
		
	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 = 199 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 @ 08:25:48.048
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 199 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 @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5085 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5091 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5083 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3879 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5086 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5084 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3881 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5094 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3882 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5095 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3883 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5093 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3884 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5096 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3894 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5087 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5089 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5088 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3893 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5090 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:25:48.048
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:25:48.048
	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 @ 08:25:48.048
	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 @ 08:25:48.048
		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 @ 08:25:48.048
		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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=9898838; CFTOKEN=c727ba0470f76c05%2DAE51778A%2DADD0%2D2E8C%2D957A04B6706FDBC0
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2017&dsp=min&seq=533
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=1&get_year=2017&dsp=min&seq=533
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=9898838
cftoken=c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
hitcount=26
lastvisit={ts '2024-05-19 08:25:48'}
timecreated={ts '2024-05-19 08:25:45'}
urltoken=CFID=9898838&CFTOKEN=c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
Cookie Variables:
CFID=9898838
CFTOKEN=c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=533
Session Variables:
ailist=Query (11)
cfid=9898838
cftoken=c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9898838_c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
subdir=/public/
tzoffset=0
urltoken=CFID=9898838&CFTOKEN=c727ba0470f76c05-AE51778A-ADD0-2E8C-957A04B6706FDBC0
URL Parameters:
dsp=min
get_month=1
get_year=2017
id=
mt=ALL
seq=533
Debug Rendering Time: 0 ms