Return
 WORK SESSION
TUESDAY, FEBRUARY 28, 2017
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 



WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of February 28, 2017, to order at 6:11 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 and Councilmember Odegaard read the Mission Statement.
             
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 (arrived at 6:13 p.m.)
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA (telephonically)
ABSENT:

NONE







  Others present: City Manager Josh Copley and City Attorney Sterling Solomon.
             
4.
Preliminary Review of Draft Agenda for the March 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.
  Jeff Meilbeck, CEO of NAIPTA, addressed the Council and expressed his thanks and compliments to the Public Works department and the Streets Section for their work during the recent snowstorm. NAIPTA was able to keep their normal operations and maintain an 80% on-time schedule because the streets were well plowed and drivable.

Jeff Coker addressed Council about the traffic issues along Highway 180. He expressed that the problem is year-round and it impacts the neighborhoods in the area negatively. He urged the Council to find solutions to the problem and not put it off any longer.
             
6. Discussion and Direction on Reclaimed Water Rates and the Use of Reclaimed Water for Non-recreational Purposes.
  Utilities Engineer Ryan Roberts provided a PowerPoint presentation that covered the following:

RECLAIMED WATER RATES POLICY DIRECTION AND NON-RECREATIONAL USE OF
RECLAIMED WATER
QUICK REVIEW
SEVERAL OPTIONS FOR COUNCIL TO CONSIDER

Councilmember Overton asked if the past recommendation of the Water Commission of 3% can be correlated to the percentage of potable it was. Mr. Roberts stated that the reclaimed rates were set at 35% of the potable rate.

Vice Mayor Whelan asked if the rates are now at 35%. Mr. Roberts explained that the recommendation of the rate consultant was to keep the rate at 35% of potable. The rates have been at 35% except there was no adjustment to the rates in 2016 so it is now below 35%. Councilmember Overton asked if the City had gone with the 3% increase in 2016 what percentage it would be now. Mr. Roberts stated that during the last rate study the Council moved forward with the 7% increase. To maintain a 35% of potable rate it has to be based off of the approved water rate that was set in April 2016.

Mr. Roberts continued the presentation.

CITY OF FLAGSTAFF WATER AND SEWER RATES
OPTION 1 – COMPARISONS

Councilmember Overton asked if the comparison cities potable rates are different from Flagstaff. Mr. Roberts stated that they are different but they are not substantially higher or lower. Councilmember Overton requested information on what the other cities rates include and how the percentage equates with the cost per thousand.

Mayor Evans asked if the percentage was randomly selected or if it was determined through a rate study. Mr. Hill stated that Phoenix elected to do it by policy and many cities started off that way so they did not do a cost of service study. Mr. Solomon added that there is no requirement to do a study for reclaimed water rates.

Councilmember Barotz offered that the current focus is on the amount the City is going to charge for the water but it is necessary to discuss the rate structure and what the City’s policy objectives are. Mr. Roberts added that for many the reclaimed water structure mirrored the potable rate structure.

Vice Mayor Whelan stated that the structure was developed at a point where the City did not realize the worth or value of reclaimed water. It is the City’s obligation to offer reclaimed water to City customers and in the past two years that has not been possible. Reclaimed water is becoming more and more valuable for the City’s watering and replacing potable in some instances. As a Council she would like to move in a direction that provides better access to reclaimed water.

Councilmember Overton offered that while reclaimed water is a valuable water source the infrastructure is expensive especially compared to potable water infrastructure. The closer the reclaimed rate gets to the potable rate people may shy away from the expense of the infrastructure because there is no cost benefit to them. It is a delicate balance of encouraging reclaimed water use and covering costs.

Mr. Roberts continued the presentation.

OPTION 2 TREATMENT PROCESS EXPENSES
CURRENT BUDGETED 5-YEAR CAPITAL IMPROVEMENT PROGRAM

Councilmember Barotz asked if the idea is to move the line where the reclaimed customers would pick up some of the expenses. Mr. Roberts stated that the line may not be moving but it may be treated differently. It may be taking the percentage of water produced into the reclaimed system versus the total volume treated and change the percentage of expenses based on the total amount that goes out into the reclaimed system. It is more about how to justify shifting more of the expenses that are needed to produce and distribute reclaimed water.

Vice Mayor Whelan asked if the difference between wastewater and reclaimed water is the point where chlorine is added. Mr. Roberts stated that the point is where the water goes into the wet well for de-chlorination.

Mr. Roberts continued the presentation.

IF RATES ARE INCREASED ADDITIONAL CAPITAL PROJECTS
SUMMARY

The following individuals addressed Council with regard to reclaimed water rates:
  • Ward Davis
  • Robert Vane
  • Kathleen Nelson
  • Chris Shields
  • Vicki Duncan
  • John Norman
The following comments were received:
  • The rate should go up but there should be a stepped process that people can live with.
  • Flagstaff’s rate is right in the middle based on other cities, there are many above and many below.
  • Flagstaff is at 32.1% of potable; to get to 35% would require a 9.1% increase in the rate.
  • The cost of producing reclaimed water is $1.62; it is surprising that when looking at the reclaimed rate sheet every number is below $1.62.
  • The Flagstaff Water Group encourages Council to stick with the practice of setting reclaimed water rates by policy.
  • There is a strong historic precedent to get to 35% of potable; go at least that far and see if it covers the cost.
  • Prepare for the future and consider the rates proposed by staff or higher.
  • There is a fine line with the rates for encouraging or discouraging reclaimed water use but the evidence is that the City is not charging enough.
  • The previous rate study did not fully evaluate the cost of reclaimed water.
  • The rate structure needs to be effective and needs to pay for the cost of maintenance.
  • Some of the treatment costs to provide A+ water should be passed on to the reclaimed users.
  • Reclaimed water is very valuable and there is a high demand for it; there should be criteria on how the water gets used.
  • The entities that are purchasing reclaimed water are providing high paying jobs and are good partners in the community.
  • If the rates increased there would be an impact to the businesses that use it.
  • Make a decision about going back to pricing by policy and wait until the next full rate study to look at rates for potable and reclaimed.
  • The Country Club does use an exorbitant amount of water but that water is spread out over multiple locations; a high increase could jeopardize business.
  • Get the rates to 35% and raise additional income to look at other capital items.
A written comment card in support of reclaimed water tier rates was submitted by Dawn Dyer.

Councilmember Barotz stated that the declining tier rate structure is concerning for her.

Councilmember McCarthy stated that he is opposed to doing a rate study. He indicated that there should be some research on the feasibility of the reuse of reclaimed water.

Councilmember Putzova stated that Council needs to decide what the policy is for the use of reclaimed water. She feels that Flagstaff should be conserving reclaimed water as a valuable commodity. She would like to see a tiered rate structure for all reclaimed water and customer classes; the idea that the more you use the more you pay is reasonable.

Councilmember Odegaard offered that the City has made a policy that it wants the use of reclaimed water to be used more and so the rate is lower to incentivize use. The City needs to get back to the 35% of potable at some point but not all in one year.

Mayor Evans stated that the use of reclaimed water was incentivized in an effort to encourage use and conserve potable water; there are now other uses for that water. Council set the policy of reclaimed rates being 35% of potable and it is important to get back to that level. A majority of Council is in favor of setting the rate by policy.

Councilmember Overton suggested reviewing the previous rate study; the options included may or may not be appropriate but it ties the entire program together with some cost benefit analysis. The rate study gets the City to 35%; if that is the goal and policy, use the data as a starting point. He added that he does not want the rate to get to a point where there is no benefit to people to tap into the system.

Mr. Copley explained that the policy to get to the 35% is something that can be handled by staff but the tiered rate structure will need a rate study. Staff will come back to Council on what that study would look like and what things need to be justified to move into that rate structure.

Mr. Roberts continued the presentation.

NON-RECREATIONAL USE OF RECLAIMED WATER
CUSTOMERS REQUESTING RECLAIMED WATER SYSTEMS
RECLAIM DISTRIBUTION SYSTEM MAP
PROCESS TO INCREASE CUSTOMERS

Councilmember Putzova stated that she would like to understand what it would look like if more potable water users moved to reclaimed water. She asked what building code changes can be made to require future development to use reclaimed water. It is a policy decision if the Council wants to go in the direction of requiring future development to replace potable water. Mr. Copley offered that staff had some preliminary discussions about this and staff can spend more time looking at incentives and changes to the Building Code if that is the direction Council would like to go.

Councilmember Overton stated that the problem is that the ground infrastructure does not support putting reclaimed pipe into homes. Direct reuse and different treatment strategies may have a better cost benefit than converting every toilet in the community to reclaimed use.

Kathleen Nelson addressed Council stating that there is a lot that people can do within their own homes; people can reuse their water to flush their toilets. Laws would need to be changed to allow people to do that and the infrastructure would need to be available.

Councilmember Putzova stated that the cost of Red Gap Ranch is high and whatever the City can invest in to delay the use of Red Gap is going to help in the long run. It comes down to prioritizing uses for reclaimed water and potable water.

Vice Mayor Whelan asked Rich Bowen with NAU to speak about the system that they have in place. Mr. Bowen explained that NAU has been using reclaimed water systems in their new construction since 2008. In older facilities that could not be re-plumbed, they installed ultra-low flow shower heads and toilets and increased conservation education. NAU has reduced their potable water use quite significantly; it is a major investment and it helps when there is a financial benefit to offset the cost.

A break was held from 8:27 p.m. through 8:40 p.m.
             
7. Consideration of Tiered Rates for Non-Residential Potable Water Customers.
  Mr. Roberts provided a PowerPoint presentation that covered the following:

WATER RATES TIERED RATES FOR NON RESIDENTIAL POLICY DIRECTION
QUICK REVIEW
RATE SETTING PROCESS
PRIOR RATE CONSULTANT ADVISED COF
MOVING FORWARD: SUMMARY

The following individuals addressed Council regarding tiered rates for non-residential potable water customers:
  • Ward Davis
  • Robert Vane
  • John Viktora
The following comments were received:
  • Tiered rates are the strongest conservation tool a city has.
  • Tiered rates are a powerful incentive for businesses.
  • Businesses can often times save more effectively then residential users.
  • Two-thirds of Arizona cities used tiered rates for commercial users.
  • The Council should at least be willing to look at tiered rates with the next rate study.
  • Start with the fact that water is life and work from there.
Councilmember Barotz stated that she is willing to defer this issue and wrap it into the next rate study instead of doing a separate study. Councilmember Overton agreed stating that he feels it is a wise choice to include it with the next study. Councilmember Odegaard also agreed and stated that he would like to see more detail in the next study regarding tiered rates for commercial users. He does not want to penalize water use but the City needs to move its goal of water conservation forward. Vice Mayor Whelan and Councilmember McCarthy also agreed.

Mr. Copley stated that prior to going out to bid for the consultant, staff could come to Council with a scope of work so there is a clear understanding of what is wanted and needed to accomplish the study. Councilmember Barotz requested that one of the qualifications be experience evaluating tiered structures of commercial users in Arizona.
             
8. Discussion of "Ban the Box" - Fair Chance for Workers With Records.
  Mayor Evans stated that approximately 636,000 people are released from prisons every year. Inmates who are released from state prisons have a five-year recidivism rate of 76.6% and the number one reasons given is lack of employment and economic opportunity. Removing the conviction question from job applications is the best way to ease hiring barriers and create a fair chance to compete for a job. Removing the question would allow applicants to be judged on their qualifications first without the stigma of a prior criminal record. She is asking the City to ban criminal history questions prior to the job interview or before a conditional job offer if no interview occurs. She would like for that policy to be extended to all City contractors and sub-contractors and if that is not legal then extra points should be awarded to contractors that have a Ban the Box policy.

Councilmember Overton stated that he is not interested in the policy; the City has every right as an employer to ask those questions and an applicant has an opportunity to explain their history. He is not in favor of not having a clear picture of an applicant’s history up front; this is especially concerning for law enforcement and those positions that work with the youth in the community.

Mayor Evans further explained that criminal history can be asked during an interview and background investigations would still be conducted. This policy would eliminate any pre-screening based on criminal history; people are pre-disposed to automatically set aside people based on history. It would allow people to tell their story in the interview rather than being eliminated right away.

Councilmember McCarthy asked if staff from Human Resources has any comments.

Human Resources Director Shannon Anderson explained that the hesitation to change the application has been that there is a cost associated with modifying the application online as well as printing and that money has not been budgeted. As far as legality, eliminating the box is legal. She stated that background checks are done on all benefit eligible employees, not temporary employees. For temporary employees in Parks, Recreation, Library and some Housing Authority positions there is a fingerprint process for them.

Mr. Solomon added that he would like to look further into the legality of applying the policy to City contractors and sub-contractors.

Councilmember McCarthy stated that he would feel more comfortable awarding additional points to contractors and sub-contractors who have this policy in place rather than mandating it. Councilmember Barotz agreed stating that she would prefer not to impart the City’s value choice on this issue to its contractors.

Councilmember Barotz asked about Council’s involvement with administrative functions such as this. Ms. Anderson stated that this change would not be an update to the Employee Handbook and she does not believe that the change would rise to the level of coming back to Council for approval. Mr. Solomon explained that there is a fine line between administrative action and policy action; he would like to work with Human Resources to look further into the issue.

Councilmember McCarthy asked if there is a majority in favor of moving this forward, would the item come back to Council. Mr. Copley stated that he did not feel bringing it back to Council would be appropriate. Council has had the opportunity to express desire to the City Manager, now the decision is left to him and administration on if and how it will be enacted.

A majority of Council is in favor of forwarding the request to the City Manager for consideration.
             
9. Discussion of Reaffirmation of City's resolutions speaking to Flagstaff's commitment to diversity, community, and fairness.
  Mayor Evans stated that she requested this item because there is a lot of fear in the community with regards to the immigrant population, the LGBTQ population and others because of some of the things happening at a national level. She would like to look at the different resolutions that speak to the City’s values and come back with a strong reaffirmation of them. There are people in the community who are very fearful and doing something like this would go a long way.

A majority of Council is in favor of moving this forward.

Mr. Copley explained that his intent would be to work on this in the City Manager’s Office, send it to the City Attorney to make sure it meets legal requirements then bring it back to Council as soon as possible.
             
10. Discussion re Current Issues Before Arizona Legislature and Federal Issues.
  Assistant to the City Manager Gail Jackson provided a brief update on state and federal issues. At the federal level President Trump is addressing Congress and he is expected to talk about the budget, health care and tax reform.

Staff is planning and preparing for the upcoming legislative lobbying trip to Washington D.C. and more information will be provided soon.

Ms. Jackson provided a brief update on HB2121, HB2086, HB2213, HB2116, HB2179, SB1487 and SB1142.

Mr. Copley stated that he will be providing an overview of the lobbying trip and the briefing book at the March 21, 2017 meeting. After the trip he will come back with a wrap up report as well.
             
11.
Review of Draft Agenda Items for the March 7, 2017, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  Councilmember McCarthy stated that he may have some comments on item 9A regarding a preliminary plat for The Wedge. Mr. Copley explained that it is a consent item but he can pull it to ask questions.
             
12. Public Participation

None
             
13. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Barotz wished her father a happy 89th birthday.

Councilmember Odegaard stated that he attended the NAU briefing tour. He expressed disappointment with the presentation and is hopeful for a meeting with the Arizona Board of Regents in the future to discuss concerns and challenges NAU has put on the community.

Councilmember McCarthy reported that he also attended the NAU briefing tour; it was a positive first step and agreed that it would be good to have a meeting with the Board of Regents.

Mayor Evans expressed appreciation to NAU for hosting the City Council. She stated that the Board of Regents will be in Flagstaff in June and September and it would be nice to try and coordinate a meeting with them while they are here as there are a lot of issues and opportunities that can be discussed.

Mayor Evans requested a FAIR item for a resolution supporting the National Park Service; they are $12 million behind in maintenance and are asking for support to have the Federal government provide more funding for the repairs needed.
             
14. Adjournment

The Work Session of the Flagstaff City Council held February 28, 2017, adjourned at 9:35 p.m.


 
 
_______________________________
MAYOR
ATTEST:
 



_________________________________
CITY CLERK

    

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

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


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


Execution Time

Total Time Avg Time Count Template
203 ms 203 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 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 @ 13:20:29.029
			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 @ 13:20:29.029
				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 @ 13:20:29.029
			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 @ 13:20:29.029
				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 @ 13:20:29.029
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 13:20:29.029
	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 @ 13:20:29.029
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:20:29.029
		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 @ 13:20:29.029
	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 @ 13:20:29.029
		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 @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
		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 @ 13:20:29.029
		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 @ 13:20:29.029
	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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:20:29.029
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:20:29.029
		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-02-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-02-28 00:00:00.0

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 13:20:29.029
			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(538 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 @ 13:20:29.029
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 537 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
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 = 537 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 = 208 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=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
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 @ 13:20:29.029
	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 @ 13:20:29.029
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
		
	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 = 208 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 208 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 @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5214 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5220 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5212 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3975 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5215 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5213 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3976 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5222 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3977 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5223 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3978 
get_Minutes (Datasource=, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5225 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3979 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5226 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3980 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5224 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3981 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5216 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3982 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5218 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5217 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 3984 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5219 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 13:20:29.029
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 13:20:29.029
	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 @ 13:20:29.029
	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 @ 13:20:29.029
		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 @ 13:20:29.029
		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=2&get_year=2017&dsp=min&seq=538
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=2&get_year=2017&dsp=min&seq=538
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=9562330
cftoken=2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
hitcount=4
lastvisit={ts '2024-05-06 13:20:29'}
timecreated={ts '2024-05-06 13:20:29'}
urltoken=CFID=9562330&CFTOKEN=2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
Cookie Variables:
CFID=9562330
CFTOKEN=2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=538
Session Variables:
cfid=9562330
cftoken=2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9562330_2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
subdir=/public/
tzoffset=0
urltoken=CFID=9562330&CFTOKEN=2cb667b8728302b0-1B6FB2D7-A06C-A1C9-5EEB2BE22421CE48
URL Parameters:
dsp=min
get_month=2
get_year=2017
id=
mt=ALL
seq=538
Debug Rendering Time: 16 ms