Return
 WORK SESSION
TUESDAY, APRIL 11, 2017
COCONINO COUNTY BOARD OF
SUPERVISORS CHAMBERS
219 EAST CHERRY AVENUE
6:00 P.M.
 
WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of April 11, 2017, to order at 6:00 p.m.
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this 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 and Mission Statement

The Council and audience recited the Pledge of Allegiance and Vice Mayor Whelan read the Mission Statement of the City of Flagstaff.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

NONE







  Others present: City Manager Josh Copley and City Attorney Sterling Solomon.
             
4.
Preliminary Review of Draft Agenda for the April 18, 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.
  Robert Vane addressed Council requesting that they advance the next water rate study by one year to address errors in the previous study, evaluate tiered rates for all users and resolve inequities and disputes relating to reclaimed water.

John Viktora addressed Council with concerns about the name of the Kit Carson mobile home park and how it is offensive to Native Americans.

Library Outreach Services Manager Judy Finney addressed Council to announce National Library Worker’s Day along with National Library Week.
             
6. Presentation2017 National Travel and Tourism Week.
  Convention and Visitor’s Bureau Director Trace Ward provided a PowerPoint presentation that covered the following:

NATIONAL TRAVEL & TOURISM WEEK
VIDEO
TOURISM MATTERS FOR FLAGSTAFF
PROMOTION 1
PROMOTION 2
PROMOTION 3
PROMOTION 4
PROMOTION 5

Councilmember Barotz stated that many in Flagstaff are struggling with the impacts from all the tourists that are attracted to Flagstaff. It is the City’s responsibility to consider impacts as more and more people are brought into Flagstaff and allocate resources to protect the quality of life of the citizens.

Councilmember Odegaard stated that tourism success is causing impacts on other departments and he wants to make sure that where there is success there are funds to support other departments that are affected such as Solid Waste and Parks and Recreation. Mr. Ward shared that the Convention and Visitor’s Bureau (CVB) is sensitive to the issue and they have taken measures to try and mitigate the impacts. He stated that there is a request in the FY18 budget to help with that mitigation.

Councilmember Putzova asked how the City can start directing more BBB funds to mitigating the impacts of tourism and what the legal capacity is for doing so. Mr. Copley explained that BBB fund distribution is statutorily and budget driven and the Council can further discuss using them during the Budget Retreat.

Economic Vitality Director Heidi Hansen stated that when the ordinance did go in place for the BBB tax much of it was allocated for tourism; since then the allocation has been reduced from 48% to 33%.

Councilmember Barotz as appreciative as she was that staff is looking at efforts to mitigate the impacts of tourism, she expressed a need to make sure that the public recognizes that the City understands their concerns.

Mayor Evans offered that she is excited for the promotion and thanked staff for all they have done. She stated that there is a disconnect with the permanent residents and the City needs to do a better job of telling the story. There needs to be bigger conversations about the benefits of tourism to the economy of Flagstaff. She suggested that some showcases and community outreach meetings be held to make sure the community knows how much tourism helps the community.
             
7. Discussion: An ordinance adopting amendments to Title 13 of Flagstaff City Code entitled "Engineering Design and Construction Standards and Specifications for New Infrastructure."
  Development Engineer Gary Miller explained that he will be giving some background on what the Engineering Standards are for, how they are used and why staff is asking for changes.

The Engineering Standards are the main guiding document for public improvements in public right of way. The standards are there to ensure public safety and to make sure streets, sewers, drainage and other things operate well. Additionally, they ensure that the City has compliance with state and federal requirements.

Staff would like to correct some errors in missions in the past, incorporate new technologies and make the standards easier to use. The amendment process began about two years ago when a committee was created that included internal employees and external experts in various areas of the standards. Over a series of meetings, revisions were developed and submitted; most were for public safety and maintenance in the future.

Mr. Miller briefly reviewed the timeline for discussion and consideration of the amendments to the standards.

Vice Mayor Whelan asked if the standards are created by the City. Mr. Miller stated that the standards are developed by and for the City.

Vice Mayor Whelan stated that her questions will be framed from the perspective of how the changes will impact community members and developers.

Councilmember Putzova stated that she will want to understand what the problem is and how to fix it. Additionally, if it is a new standard she would like to understand why the City needs it.

Councilmember Odegaard stated that he would like to see the financial impact on the citizens and the City and what those costs would generally look like.
             
8. Discussion and Possible Direction: Current Issues Before the Arizona Legislature, Federal Issues and Administrative Items Before State Agencies.
  Interim Assistant to the City Manager Gail Jackson introduced the City’s Federal Lobbyist Bob Holmes who was present by telephone.

Mr. Holmes reported that the Washington D.C. trip was really good; many issues were discussed and there was good progress on all of them.

Forest health went very well with the Acting Deputy Secretary promising to try and get the Secretary to visit and tour the Flagstaff area.

He reported that he is still trying to get updates on the Veteran's Home. The challenge is that priority is given to states that have more than 2,000 veterans. Senator McCain will be looking at that priority and trying to change the regulations of the law so it is based on need rather than number.

Vice Mayor Whelan stated that it appears that the programs Flagstaff holds dear are on the chopping block at the federal level and she would like to know how that is dealt with in Washington. Mr. Holmes explained that it is a concern of many people; the President’s budget is only a political document and would likely not come close to passing if it was put to a vote in Congress. It is something that is done every year but Congress has the ultimate power and usually the cuts do not happen at all.

Mayor Evans offered that there has been some historic underfunding of HUD which has caused issues with the City’s Housing Authority. While on par for the units, the administrative costs are only being recouped at around 75%. She suggested that the Council work with the Housing Department to get a clear understanding of the exact needs. She stated that it is concerning to see such deep cuts to CDBG funding in a political document. Mr. Holmes stated that if the Council puts something together he will visit with the people at HUD to make sure the City’s concerns and needs are being heard. He also indicated that he has and is continuing to work with Housing Director Sarah Darr on the issues surrounding the formula for fair market rents.

Mayor Evans also expressed a need for the City to get involved with regards to the funding for the Veteran’s Home. Giving priority based on numbers rather than need is problematic and the law should be changed. Senator McCain seemed very interested and she thinks a letter to Senator McCain that is specific to that change may be advantageous because he said he was willing to look at it. Mr. Holmes agreed but added that there will likely be opposition from the larger states. He suggested including Congressman Gosar on the letter as well.

Councilmember Odegaard added that recognizing the Native American communities that will be accessing the facility is important as well. Mr. Holmes agreed and offered that the facility in Flagstaff will likely be the only facility they could come to and it is an important element to the strategy as well. Mayor Evans suggested inviting the Tribes to accompany the City to Washington D.C. next year to further advocate and coordinate efforts.

Ms. Jackson provided a few updates from State lobbyist Richard Travis. She also reported that the trip to the Hopi Reservation was successful and asked the Council to sign a thank you letter to that effect.

Ms. Jackson then moved to a discussion regarding the Arizona Corporation Commission (ACC).

Mayor Evans declared a conflict and recused herself from the dais at 7:14 p.m.

Ms. Jackson stated that the ACC held their public comment period in Flagstaff on April 3, 2017. She asked if the Council wants to take a formal action with regard to the APS rate hike.

Councilmember Barotz stated that she would like to see the Council send a formal letter to the ACC taking a position against the proposed rate hike. Parties that have been interveners have come to a settlement but she still thinks the City should voice opposition.

Councilmember Overton offered that he is not always comfortable telling other governing bodies what to do. He asked if other municipalities weigh in often and if the affect was beneficial or detrimental to them.

Councilmember Barotz stated that she attended the meeting and all the comments were in opposition to the rate hike and she feels uncomfortable looking at the decision to weigh in on the matter based on ramifications from APS. The Coconino County Board of Supervisors did send a letter and they outlined in detail the areas they were most concerned about.

Councilmember McCarthy indicated that if there are specific things the City does not like about the case he would supportive of a letter to communicate those points; unless there are specifics, he is disinclined to sign on.

Councilmember Barotz offered that she would also like the letter to identify very specific reasons why the City is opposed. The fixed charge and its impact is a big reason. There is a greater impact if letter is specific.

Vice Mayor Whelan stated that another point of opposition is the 90-day clause that everyone goes in without choice. Another area the letter should highlight are the trends of utilities and that it seems like APS is stuck in fossil fuel which experts say it is not going to last. She feels that it is the Council’s responsibility to let the ACC and APS know that certain points of the rate hike will impact Flagstaff’s citizens greatly. She expressed gratitude for all APS does at the local level for Flagstaff.

Councilmember Putzova stated that she is supportive of the letter and feels it is the Council’s responsibility to reflect the points of its constituents. APS is a publicly traded company and is set up to create profit for its stakeholder; the proposal they put forward is to create revenue not to provide better or greater service.

Mr. Copley suggested having staff draft a letter and put it out for discussion. He asked Council to forward any specific points they would like included in the letter to Ms. Jackson.

Mayor Evans returned to the dais at 7:27 pm.
             
9.
Review of Draft Agenda Items for the April 18, 2017 City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  Councilmember Overton offered compliments to Public Works Project Manager Adam Miele for his excellent work on his staff summaries. The projects are a big deal for the community to understand what is coming up.
             
10. Public Participation

None
             
11. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Putzova stated that she did not see the item she had requested during the reclaimed water discussion regarding infrastructure to bring reclaim water to new development on the working calendar. Mr. Copley explained that a discussion is scheduled for June 27, 2017 relative to reclaimed water in general; he will work with staff on how that can be folded into the discussion. She clarified that she wants Council to discuss the policy, and if it is the desire of the Council to expand the use of reclaimed water what is needed to change to further that policy.

Councilmember Barotz requested a FAIR item for the consideration of adopting a more current version of the energy code.

Councilmember Barotz also requested a FAIR item for the consideration of pulling ahead the timeline for the next rate study by one year.

Councilmember Barotz thanked staff for all of the work that went into the trip to the Hopi Council.

Vice Mayor Whelan also thanked staff for their work on the Hopi trip; it was a wonderful event. She also attended the kick off to Water Conservation Month and the Mayor’s pledge; it was a great event with an art show to celebrate.

Vice Mayor Whelan stated that she will be requesting a FAIR item at the meeting next week in regard to issues of bullying, safety, asking for a place to be safe. There is a lot the City can do that does not cost much money.

Councilmember Odegaard thanked staff for their work to make the invitation from the Hopi Tribe successful; he is hopeful that there can be more things like that in the future. He also attended the Indigenous Circle meeting; it was a good meeting and he is looking forward to the meeting next month. He also attended the Field of Hope event that was put on by the Exchange Club; the event brought attention to the 87 children that lost their lives because of abuse or neglect in 2016.

Councilmember Odegaard thanked staff for their work with his church for an add-on to their building. He also wished everyone a happy Easter.

Councilmember McCarthy requested a FAIR item to consider minor changes to the Building Code that will facilitate the conservation of potable water.

Mayor Evans reported that the City of Flagstaff is currently in first place with the National Water Pledge. She also thanked Ms. Jackson for her work in coordinating the trip to Hopi; she is looking forward to the upcoming meeting with the Navajo Nation.

Mayor Evans participated on a panel regarding economic development with the Alpha Kappa Alpha Sorority.

She and Vice Mayor Whelan met with Keeping Flagstaff Together Coalition; it was a great conversation. She also met with Karin Eberhard with the Flagstaff Unified School District regarding a STEM City anniversary event.

Mayor Evans met with Rabbi Mindy. She also visited the STEM Space Makers club at Sinagua Middle school; she got to visit with the students and learn about their hover craft.

Mayor Evans reported that the second Mayors Community Policy Trust meeting went very well. She also attended the NACOG Economic Development Council meeting and learned about the efforts of the City of Prescott and Prescott Valley with regard to forest health.

Mayor Evans attend the ATHENA International lunch celebration and met the new CEO of ATHENA International. She also met with Chris Scully, the owner of the Orpheum, about their upcoming 100th anniversary celebration.

Mayor Evans met with St. Mary’s Food Bank and the Hunger Free Alliance of Flagstaff; they are getting ready to roll out their marketing campaign about the Summer Food Program to make sure that everyone under the age of 18 knows how and where to access hot food. She also attended the Housing Authority Board meeting.

Mayor Evans had the opportunity to be a part of the Dancing with the Stars Fundraiser and she and her dance partner Scott Hancock, President and CEO of NACET, took first place and helped raise the most money with their dance routine.

Lastly, Mayor Evans reported that she has been nominated for one of six awards nationally for the Gabby Gifford Rising Star award through Emily’s List. She is the only nominee coming from the State of Arizona.

Mr. Copley stated that invitations were extended to the Council from the Hopi Tribe staff will be working with the Tribe to coordinate the attendance. He reported that the Joint City/County Work Session will be held next Tuesday at the County Board of Supervisors Chambers and the Council Meeting on April 18, 2017 will be held at Flagstaff High School.

Mr. Copley also reported that staff is arranging a ground breaking ceremony for the Core Services Maintenance Facility and also an Arbor Day celebration to plan a couple of trees in Wheeler Park.

Mayor Evans added that the dedication of the Officer Stewart Memorial is on April 30, 2017 at 1:00 p.m. at Clay and Globe; it would be great to have Council there to show respect for Officer Stewart and his family.
             
12. Adjournment

The Work Session of the Flagstaff City Council held April 11, 2017, adjourned at 7:45 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 02-May-24 05:38 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
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:38:34.034
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:38:34.034
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:38:34.034
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:38:34.034
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 17:38:34.034
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 17:38:34.034
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:38:34.034
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
	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=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 17:38:34.034
		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-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:38:34.034
			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(556 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
	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 @ 17:38:34.034
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 555 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
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 = 555 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 = 218 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=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
	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 @ 17:38:34.034
		
	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 = 218 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 218 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 @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5432 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5438 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5430 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4172 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5433 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5431 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4173 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5440 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4174 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5441 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4175 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5442 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4176 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5434 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4177 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5436 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5435 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4179 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 5437 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 17:38:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:38:34.034
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:38:34.034
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:38:34.034
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 17:38:34.034
		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=4&get_year=2017&dsp=min&seq=556
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=4&get_year=2017&dsp=min&seq=556
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=9464401
cftoken=ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
hitcount=4
lastvisit={ts '2024-05-02 17:38:34'}
timecreated={ts '2024-05-02 17:38:34'}
urltoken=CFID=9464401&CFTOKEN=ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
Cookie Variables:
CFID=9464401
CFTOKEN=ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=556
Session Variables:
cfid=9464401
cftoken=ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9464401_ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
subdir=/public/
tzoffset=0
urltoken=CFID=9464401&CFTOKEN=ead8d4bb6f2f1b01-56B0CE73-C543-274C-FDDBA9EA036B8C7F
URL Parameters:
dsp=min
get_month=4
get_year=2017
id=
mt=ALL
seq=556
Debug Rendering Time: 0 ms