Print Minutes Return
JOINT CITY/COUNTY WORK SESSION
MONDAY, JUNE 22, 2015
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
4:00 P.M.

MINUTES

             
1. Call to Order
  Chairman Babbott called the Joint City/County Work Session of June 22, 2015, to order at 4:02 p.m.
             
2. Pledge of Allegiance
  The audience, City Council and Board of Supervisors recited the Pledge of Allegiance.
             
3. Roll Call:

NOTE: One or more Councilmembers/Supervisors may be in attendance telephonically or by other technological means.

PRESENT

CHAIRMAN BABBOTT
SUPERVISOR FOWLER
SUPERVISOR METZGER
ABSENT

SUPERVISOR ARCHULETA
SUPERVISOR RYAN

PRESENT

MAYOR NABOURS
VICE MAYOR BAROTZ
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT

COUNCILMEMBER BREWSTER
COUNCILMEMBER EVANS
COUNCILMEMBER ORAVITS

Others present: Interim City Manager Jeff Meilbeck, County Manager Cynthia Seelhammer
             
4. Public Participation

Public Participation enables the public to address the Council/Board about items that are not on the 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 on an item that is on the agenda 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/Board 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 an opportunity to speak.
  None
  Chairman Babbott changed the order of the meeting to the following:

Item 2 – Update on Prop. 403 (County) and Prop. 406 (City) Road Improvements
Item 1 – Presentation on USFS Recreation Plan
Item 3 – Information on a Resolution passed by the Coconino County Board of Supervisors supporting the Stepping Up initiative in an effort to curb mental illness in our jails

The minutes are reflective of the original order of the agenda.
             
5. Presentation on USFS Recreation Plan
  Chairman Babbott stated that Don Muise was originally scheduled to present on wildland fire response but he is out working on the Camillo Fire. Crews are getting great results from the naturally occurring fire at this time. Additionally, the Board of Supervisors and the City Council will have Mr. Muise report out at a later time.
 
Interim Forest Supervisor for Coconino National Forest Scott Russell addressed the Board of Supervisors and City Council stating that they are working on a sustained recreation strategy initiative to increase collaboration and partners around forest recreation.
 
Recreation Program Manager for the Coconino National Forest Charlotte Minor provided a PowerPoint Presentation that covered the following:
 
NORTHERN ARIZONA SUSTAINABLE RECREATION – WHY NOW?
 
District Ranger from the Red Rock District Nicole Branton continued the presentation.
                                                                                               
NORTHERN ARIZONA SUSTAINABLE RECREATION – WHAT IS IT?
VERDE FRONT – STRING OF PEARLS
EXAMPLES OF SUSTAINABLE RECREATION COLLABORATION: FLAGSTAFF REGIONAL
TRAILS COORDINATION COMMITTEE
COLLABORATIVE TRAILS PLANNING/IMPLEMENTATION
COLLABORATIVE TRAILS PROJECTS: NATIONAL TRAILS DAY EVENTS
NORTHERN ARIZONA SUSTAINABLE RECREATION: HOW IT ALL FITS TOGETHER
 
Mr. Russell stated that the idea is to step back and try to organize at a collaborative level for recreation and take what is already happening with different projects and sustainability and organize opportunities around recreation.
 
Mayor Nabours asked if the concept is getting people more focused on the use of the forest in specific places as opposed to wandering out into the forest to create their own fun. Mr. Russell stated that the more people are engaged and understand and are connected to natural resources the more they own the stewardship of that. That is not the principal objective; the goal is to build a group to learn what can be done better. It is a part of the discussion but not a founding principle. Mayor Nabours asked if there is any plan to have more concessionaires within the national forest who do things such as snow play and cross country skiing. He stated that doing so may bring more organization to the various activities that are available in the forest. Mr. Russell stated that it is definitely part of the discussion and there is a role for business within the collaboration.
 
Councilmember Overton stated that it sounds like the approach is more proactive; he asked if the group sees themselves tackling more of the community issues such as snow play and traffic congestion and potential solutions to these challenges in the community. Mr. Russell offered that he does see that as part of the discussions and they are working on trying to bring all of the players together to look at solutions to the public need.
 
Supervisor Metzger noted that the collaborative is a great undertaking. She asked if there will be an effort to identify and manage expectations. There are many great ideas but without format or a foundation in place the product cannot be honored. Mr. Russell stated that it is a nationwide movement aimed at getting the public involved in defining their expectations of the forest and having conversations with the public in a productive way. In northern Arizona there are a lot of jurisdictions involved in the forest and people have voiced frustration about access and roads; this is the type of thing that the group is expecting will come out of the public input and instead of narrowly focusing on one agency to address the issue the group will look at the issues collectively to find solutions or alternatives. The process may not make the problems and restrictions go away but it will provide an environment where discussions can focus on the public interest.
 
Chairman Babbott asked if the Forest Service will be coming to the County and City individually asking for participation. Mr. Russell stated that they hope to be back before the City and County individually in the late summer or early fall. The facilitator will be compiling everything that has come out of the various public meetings and presenting that along with possible outcomes, solutions and a process forward.
 
Mr. Russell provided an update on the two managed fires that are currently active. The Horse Tank fire is down on the southern part of the forest by Fossil Creek. The fire is a unique opportunity to reduce fuels in the area and completion is anticipated over the next couple of days. The Camillo fire is just east of Mormon Lake. Crews are also letting that fire burn to reduce fuels west of the power line that runs through the area in an effort to reduce future fire risk to that power line. The Forest Service is working with Fish and Wildlife Services to understand and monitor the impacts of the fire on the Spotted Owl; this will help develop procedures on how to treat or not treat the area in the future.
 
Supervisor Metzger asked how many acres had been burned for each fire. Mr. Russell stated that approximately 11,000 acres had been burned for the Camillo fire and approximately 4,000 for the Horse Tank fire.
             
6. Update on Prop. 403 (County) and Prop. 406 (City) Road Improvements
  Mayor Nabours stated that last November the City and County proposed sales tax increases for road repair and maintenance and the voters approved both of those. There has been a lot of chip sealing activity around town and that is a result of the sales tax. This kind of activity will be continuing for some time as the city and county roads will be brought up to standard and maintained.
 
Capital Improvements Engineer Bret Peterson addressed the Board of Supervisors and City Council proving a PowerPoint presentation that covered the following:
 
ROAD REPAIR AND STREET SAFETY IMPROVEMENT PROGRAM UPDATE
ROADS MATTER TO FLAGSTAFF
KEY CONSIDERATIONS
PROP. 406 – FUNDING SUMMARY
 
There were questions from the City Council about the debt service line item and what that translated to over time. Assistant to the City Manager Stephanie Smith stated that the City has estimated about $53 million dollars in project work in the first seven years of the tax. The ballot language stated that City would issue debt up to $20 million for the project the remaining portion of the project is paid for as it goes along. The annual pavement preservation program is starting in year eight and is paid at about $2 million per year for the remainder of the 15 years.
 
Mr. Peterson continued the presentation.
 
COMMUNICATION PRIORITIES
PROJECT WEB PAGE
PROGRAM MANAGEMENT – PRIORITIZATION
 
Public Works Project Manager Adam Meile continued the presentation.
 
2015 STREET MAINTENANCE PROGRAM
COF STREET MAINTENANCE PROGRAM REVIEW
SURFACE OVERLAY – PRIOR TO JULY 1, 2015
SURFACE OVERLAY – JULY-OCTOBER 2015
 
Mr. Peterson continued the presentation.
 
DESIGN PHASE: SUMMER/FALL 2015
PAVE THE WAY EVENT – APRIL 1, 2015
DELIVERING OUR PROMISE – CHIP SEAL 2015
DELIVERING OUR PROMISE – MILLING 2015 (N. SAN FRANCISCO)
DELIVERING OUR PROMISE – OVERLAY 2015 (N. SAN FRANCISCO)
DELIVERING OUR PROMISE – MILL & OVERLAY 2015
 
Mayor Nabours asked if the millings generated are able to be reused. Mr. Peterson explained that on some occasions they are when they are not able to be immediately reused they are preserved for future applications.
 
County Public Works Director Andy Bertelsen addressed the Board of Supervisors and the City Council stating that the County too is in full swing with road construction. Proposition 403 has provided adequate funding to preserve the infrastructure and allows the County to respond appropriately should a natural disaster occur. The County currently has $6 million in road projects currently underway and $2 million in chip seal projects. They are in the process of purchasing maintenance equipment as well to help with maintaining County roads. The County has been able to work with the career center to hire three maintenance workers that had worked at Walgreens; they will be training them to be heavy equipment operators. He thanked the community and the Board of Supervisors for allowing them to move forward with the projects that so greatly benefit the community.
 
Engineering Manager for Coconino County Public Works Dustin Woodman addressed the Board of Supervisors and the City Council with a PowerPoint presentation that covered the following:
 
FY 2015 PROP. 403 FUNDED PROJECTS
HOW WE GOT HERE
10 YEAR ROADS CAPITAL IMPROVEMENT PLAN
2015 CIP PROJECT: KOCH FIELD ROAD PAVEMENT PRESERVATION PROJECT
2015 CIP PROJECT: MUNDS WASH BRIDGE REPAIR PROJECT (MUNDS PARK)
2015 CIP PROJECT: PINEWOOD BLVD RECONSTRUCTION PROJECT (MUNDS PARK)
2016 CIP PROJECT: TOWNSEND-WINONA ROAD
7 YEAR CHIP SEAL PLAN
2015 CHIP SEAL PROJECT: BLUE RIDGE
2015 CHIP SEAL PROJECT: DONEY PARK
2015 CHIP SEAL PROJECT: GREATER BELLEMONT/PARKS
PROJECT WEBSITE
 
Supervisor Metzger noted that she has observed a reluctance of the public to identify with the projects at some of the public meetings in the past. She has now seen a shift in that ownership with people now being quite proud to own the projects and they are happy with the work being done. There is great appreciation throughout the County for the work.
 
Chairman Babbott asked how much Proposition 403 is estimated to generate. Mr. Bertelsen stated that it is estimated to generate approximately $7 million over 20 years. Chairman Babbott suggested looking for opportunities to collaborate with the City in an effort to get a better return on investment for the two jurisdictions. Mr. Bertelsen stated that this first year staff from the City and County were able to get all the material producers in town to establish timelines on materials for everyone involved. There are only a few companies in the state that focus on this type of production and it is hoped that as the City and County move forward they can continue to partner together with the material producers to be sure everyone has what they need at the best price possible.
             
7. Information on a Resolution passed by the Coconino County Board of Supervisors supporting the Stepping Up initiative in an effort to curb mental illness in our jails.
  Toby Olvera addressed the Board of Supervisors and City Council about the Stepping Up Initiative, a national initiative that is sponsored by the National Association of Counties (NACO), the Council for State Governments and the American Psychiatric Foundation.  The purpose is to reduce the number of mentally ill incarcerated in county jails. They are working to bring other agencies, leaders, and professionals to the table to discuss and collaborate ideas on how to reduce this population within the jail system and save tax payer dollars. Coconino County passed a resolution to support this initiative. Next month at the National Association of Counties annual conference they will be holding a national summit on this program.
 
Sheriff Bill Pribil addressed the City Council and Board of Supervisors stating that mental health within the criminal justice system is a complex issue that impacts every community in the nation. Jails are now the de-facto mental health facilities for the mentally ill in communities. People who do not have adequate resources to get the assistance they need often become involved in the criminal system and it is cheaper to put someone in jail rather than a mental health facility. Society needs to come up with a better solution. He is hopeful that with NACO involved there will be more conversations and support behind the movement.
 
The Flagstaff Police Department has been working on various programs to help facilitate the issue locally and the City Mental Health Court was the first to step forward.
 
Mayor Nabours asked what the proposed alternative is. Sherriff Pribil explained that back in the 60s and 70s there was a movement to transition the mental health system out of the hands of mental health professionals and into the hands of the law. Treatment was left in the hands of the community without the adequate funding to do so. There are people who are in jail for months because the system cannot figure out what to do with them; there is a revolving door because the person is able to be stabilized while in custody but once adjudicated and released they are back on the streets and self medicating with drugs and alcohol. The Mental Health Court is a concept that keeps track of these individuals and helps them to continue to take their medication and continue with counseling; it has been a great step forward.
 
Vice Mayor Barotz asked if the plan with the resolution is to get other agencies to sign on. Sherriff Pribil stated that it would be great for every community to sign on and send the message that this is an important issue that needs attention; jails should not be the treatment facilities for those who do not have the support and resources to address their mental issues. Vice Mayor Barotz stated that she will be asking for an agenda item for City Council to consider signing onto the resolution.
 
Supervisor Metzger stated that one of the challenges is that staff is unable to qualify and quantify the mental illnesses within the jails. NACO has the ability to serve as a think tank and a platform for numerous agencies to partner. It is interesting to hear how other counties and agencies are dealing with this issue; it is very political but there is an opportunity to have input and having NACO at the ground level will be very helpful.
 
Chairman Babbott asked if there is opportunity for non-county jurisdictions to participate in the movement. Mr. Olivero responded yes stating that Flagstaff Police Department has been involved in discussions and other movements to help address the issues of mental health.
 
Supervisor Fowler stated one of the ideas of NACO is to get the educational awareness out to the public. The jails become the homestead for these individuals and it has a huge impact on the budget; this is a great opportunity for community awareness and bringing attention to a very serious issue.
             
8. Public Participation
  None
             
9. Informational Items To/From Chairman, Supervisors and County Manager/Mayor, Council and City Manager.
  Councilmember Putzova thanked the Board of Supervisors for meeting with the City Council.
 
Councilmember Overton offered congratulations to Chairman Babbott on his recent appointment as Chairman of the Board of Supervisors.
 
Supervisor Metzger stated that she is happy to see all the activity thoughout the County and believes that it will bring good economic activity to the area.
 
Vice Mayor Barotz thanked the Board of Supervisors for their participation in the meeting.
 
Mayor Nabours stated that the City and County should continue to look for opportunities to partner and pool resources on the road work that is being done. He added that both the City and County are also heavily involved and downtown and he hopes that they will continue to work together on downtown issues.
 
Chairman Babbott stated that the bike skills park at Fort Tuthill had its grand opening over the weekend; it is a fun park with great amenities and he encouraged everyone to check it out. He also introduced Todd Medeska as the new Government Relations Director for Coconino County. He also stated that the new Deputy County Manager Neil Young will be coming on board in the next few weeks.
 
County Manager Cynthia Seelhammer stated that Supervisor Ryan sent photos of his new grandbaby. She also stated that the Deputy County Manager retirement event is next Wednesday.
             
10. Adjournment
  The Flagstaff Joint City Council/County Board of Supervisors Work Session of June 22, 2015, adjourned at 5: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 03-May-24 04:19 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
204 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 04:19:19.019
			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(372 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 @ 04:19:19.019
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 372 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
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 = 372 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 = 78 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=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
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 @ 04:19:19.019
	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 @ 04:19:19.019
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
		
	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 = 78 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 78 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=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2260 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1622 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2263 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1625 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2258 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2259 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1631 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1632 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2267 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1634 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2268 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1637 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2266 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1640 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2261 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1643 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2264 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1646 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 2262 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:19:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1649 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:19:19.019
	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 @ 04:19:19.019
	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 @ 04:19:19.019
		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 @ 04:19:19.019
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=6&get_year=2015&dsp=min&seq=372
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=6&get_year=2015&dsp=min&seq=372
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=9474903
cftoken=ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
hitcount=4
lastvisit={ts '2024-05-03 04:19:18'}
timecreated={ts '2024-05-03 04:19:18'}
urltoken=CFID=9474903&CFTOKEN=ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
Cookie Variables:
CFID=9474903
CFTOKEN=ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=372
Session Variables:
cfid=9474903
cftoken=ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9474903_ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
subdir=/public/
tzoffset=0
urltoken=CFID=9474903&CFTOKEN=ee10ef77ea76c222-6D9A45C3-08F6-E46C-C594F3B21318840C
URL Parameters:
dsp=min
get_month=6
get_year=2015
id=
mt=ALL
seq=372
Debug Rendering Time: 0 ms