Print Minutes Return
WORK SESSION
TUESDAY, MARCH 29, 2016
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
             
1.
Call to Order

Mayor Nabours called the Work Session of the Flagstaff City Council held March 29, 2016, to order at 6:20 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 work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Pledge of Allegiance
  The Council and audience recited the pledge of allegiance.
             
3. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT

MAYOR NABOURS
VICE MAYOR BAROTZ
COUNCILMEMBER BREWSTER
COUNCILMEMBER EVANS
COUNCILMEMBER ORAVITS
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA

ABSENT








Others present: City Manager Josh Copley and City Attorney Michelle D'Andrea
             
4.
Preliminary Review of Draft Agenda for the April 5, 2016, 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.
  Councilmember Oravits asked about item 9-D regarding the grant agreement with the State Historic Preservation Office (SHPO); he asked if the City has an underlying ordinance regarding preservation issues and the need to have studies done. Community Design and Redevelopment Manager Karl Eberhard stated that the City has an obligation under federal law, because the City is using HUD money for the programs, to do a Section 106 review. This review is for the minor projects that Housing does and it is a consent process that allows City staff to approve rather than send the documentation to SHPO each time.
 
Councilmember Oravits stated that one of the things it says is that all projects funded or licensed by the federal government; he asked how that affects other historic projects and if it only relates to those that are federally funded or is there an ordinance that triggers the need for historic review. Mr. Eberhard explained that the agreement has no effect on other projects as SHPO does not review any other projects, however, the City does have a zoning ordinance that requires review of projects locally but they are unrelated.
 
Councilmember Oravits asked if the contract will push people to use this same process. Mr. Eberhard stated that the review and process is only for the work that the City does for its housing rehabilitation projects because the City is using federal funding for them. It has nothing to do with private development.
 
Councilmember Oravits stated that he will be requesting a FAIR regarding the historic studies required of people doing private historic projects in the city.
 
Mayor Nabours asked if a who person owns an old residence and wants to tear it down is able to do that. Mr. Eberhard explained that the zoning code requires a historic cultural study be done prior to demolition. This requirement would apply to commercial properties more than 50 years old and residential properties that were built prior to 1946.
 
Councilmember Oravits asked for an example of a project that would fall under the agreement. Mr. Eberhard offered that a HUD grant is used to replace the roof of someone who cannot afford to do it. The use of HUD funds trigger the need for the Section 106 review. This agreement authorizes staff to conduct this review and approve the project because SHPO trusts the City’s program. This allows projects to be done much more quickly as the review does not have to be sent to Phoenix and go through the SHPO process which can often take a few weeks. There is a standardized form that is used and if the project does not meet certain requirements the City would then send it to SHPO for further review. The only change to the contract is that the term changes from five years to indefinite.
             
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.
  Mayor Nabours came to the public podium and asked Council to join him. He announced that it is Ms. D’Andrea’s last Council meeting as she is moving on to Texas. Ms. D’Andrea has done a magnificent job as the City Attorney. He presented Ms. D’Andrea with a framed key to the
  City with a plaque inside thanking her for her service. Vice Mayor Barotz thanked Ms. D’Andrea for her dedicated service and wished her luck as she moves on with new endeavors.
 
Mr. Copley introduced the new Public Works Director Andy Bertelsen and welcomed him to Team Flagstaff.
             
6. Service Partner Presentations - 2016
  Management Services Director Rick Tadder stated that the Council will be hearing from ten service partners who will be giving an update on their recent work for the City. He provided a PowerPoint presentation that covered the following:
 
SERVICE PARTNER CONTRACTS
TODAY’S PRESENTATION
 
Executive Director of Coconino Humane Association Michelle Ryan continued the presentation.
 
COCONINO HUMANE SOCIETY
2015-2016 CITY OF FLAGSTAFF PRESENTATION
COMMUNITY BENEFITS FROM OUR PARTNERSHIP
ADVANCING COUNCIL GOALS
THE PEOPLE AND PETS IMPACT
AGENCIES THAT PROVIDE SIMILAR SERVICES
OVERVIEW OF FUNDING AND EXPENDITURES
THANK YOU
 
Councilmember Brewster asked if the Humane Association utilizes volunteers and how many they have. Ms. Ryan explained that they do not have a volunteer coordinator right now but do have a core set of 20 volunteers that are used for covering the Petsmart adoption centers and walking the animals so the kennels can be cleaned.
 
Diane Jarvis addressed Council and advocated for an increase to the yearly contract amount for Coconino Humane Association.
 
Anne Motteck on behalf of the Greater Flagstaff Forests Partnership continued the presentation.
 
GREATER FLAGSTAFF FORESTS PARTNERSHIPS 2015 ANNUAL REPORT
GFFP SERVES THE ENTIRE FLAGSTAFF COMMUNITY
GFFP ACTIVITIES/OUTCOMES
COUNCIL GOALS
GFFP PARTNERS (25+)
BUDGET
THANK YOU! QUESTIONS?
 
Jenn Runge on behalf of Northern Arizona Center Against Sexual Assault (NACASA) continued the presentation.
 
NORTHERN ARZIONA CENTER AGAINST SEXUAL ASSAULT
NACASA: MEDICAL AND FORENSIC RESPONSE PROGRAM FOR ADULT AND
ADOLESCENT VICTIMS OF SEXUAL ASSAULT IN NORTHERN ARIZONA
HISTORY OF NACASA
STATISTICS & INFO
REQUEST FOR FUNDING
OVERVIEW OF FUNDING
QUESTIONS?
 
Mayor Nabours asked if a victim could go to their private physician or the emergency room to get the same services. Ms. Runge explained that victims always have the option to go elsewhere but their doctor and the emergency room can only provide the medical program and not the forensic piece; additionally, they would have to pay out of pocket for the doctor or emergency room where NACASA has no charge.
 
Bill Harris on behalf of the Science Foundation of Arizona continued the presentation.
 
SCIENCE FOUNDATION OF ARIZONA
SFAZ’S INVESTMENT IN FLAGSTAFF K-12
SFAZ INVESTMENT TO COCONINO COUNTY COMMUNITY COLLEGE
SFAZ STEM MENTORING PROGRAM IN FLAGSTAFF
SFAZ CONTINUES TO SUPPORT THE FLAGSTAFF FESTIVAL OF SCIENCE
RETURN ON INVESTMENT
 
Vice Mayor Barotz asked what the City contribution pays for directly. Mr. Harris explained that it helps pay a portion of the salary for 15-20 people who develop the programs that are being used in the schools. These people also leverage funding to obtain grants and other funding.
 
Councilmember Evans asked what the Science Foundation of Arizona’s role was in the grant awarded to Killip School. Mr. Harris stated that the Science Foundation of Arizona wrote the grant proposal and is working directly with Killip School to carry out the plans that were laid out in the proposal as well as monitoring the progress of the project.
 
Steve Peru on behalf of the United Way of Northern Arizona continued the presentation.
 
Councilmember Evans excused herself from the dais for the presentation due to a conflict of interest.
 
UNITED WAY OF NORTHERN ARIZONA
UWNA MISSION
CITY OF FLAGSTAFF/UNITED WAY PARTNERSHIP
FY 15-16 COMMUNITY AGENCY PARTNERS
CITY OF FLAGSTAFF/UNITED WAY PARTNERSHIP PROVIDES RESULTS
CITY OF FLAGSTAFF/UNITED WAY PARTNERSHIP VOLUNTEER INCOME TAX
ASSISTANCE
UNITED WAY AND FLAGSTAFF COMMUNITY PARTNERS THANK THE CITY COUNCIL
FOR YOUR CONTINUED SUPPORT
 
Mayor Nabours asked why the VITA program was broken out specifically in the presentation. Mr. Peru explained that VITA is a distinct service that is provided for in the IGA and he wanted to bring the program to the Council’s attention. Mayor Nabours asked what the $27,000 contribution pays for. Mr. Peru explained that it pays for the one person to oversee the program. VITA also receives grant funding from the IRS to help offset the cost of the program.

Councilmember Evans returned to the Council dais.

Chief Executive Officer Jack Callaghan for the Guidance Center continued the presentation.
 
THE GUIDANCE CENTER
ALCOHOL STABILIZATION UNIT
BENEFITS TO THE COMMUNITY
ALCOHOL STABILIZATION UNIT FUNDING
ALCOHOL STABILIZATION UNIT DEMOGRAPHICS
 
Dr. Nathan Velez continued the presentation.
 
PERFORMANCE MEASURES AND IMPROVEMENTS
 
President of the Board of Directors for Coconino Coalition for Children and Youth Beya Thayer continued the presentation.
 
COCONINO COALITION FOR CHILDREN AND YOUTH (CCC&Y)
19,303 children and youth ages 0-19 in Flagstaff
BENEFITTING FLAGSTAFF COMMUNITIES
CONNECTIONS
COMMUNITY PARTNERS
FUNDING AND EXPENSES
 
Board Chair Tim Hansen of the Boys and Girls Club continued the presentation.
 
BOYS AND GIRLS CLUB OF FLAGSTAFF
MEMBERS
FIVE CORE PROGRAM AREAS
COMMUNITY PARTNERS
WHY WE REQUEST CONTINUED FUNDING FROM THE CITY OF FLAGSTAFF
 
Mayor Nabours asked where the Boys and Girls Club stands on the operation of the Cogdill Center; he asked if it is paying part of its way or running at a deficit. Mr. Hansen stated that there is very little cost to the Boys and Girls Club in relation to the building; they provide some maintenance but the City provides most of the maintenance to the building. In terms of fees and cost recovery the Club has not been able to expand the membership much beyond the adjacent neighborhood and because most of the attendees are on scholarship they are not collecting the level of fees they had hoped to offset the operating costs and therefore are running at a bit of a deficit. The program is working successfully, additional membership will help the financial side.
 
Director of Educational Enrichment Sylvia Johnson on behalf of Family And Community Teaming for Students (FACTS) continued the presentation.
 
FAMILY AND COMMUNITY TEAMING FOR STUDENTS (FACTS)
15 YEAR PARTNERSHIP WITH CITY OF FLAGSTAFF
BEFORE & AFTER SCHOOL PROGRAMMING/SUMMER CAMP IWANNAGO
ADVISORY COUNCIL/PARTNERSHIPS
ATTENDANCE/OUTCOMES
ANNUAL OPERATING BUDGET
INCOME SOURCES
THANK YOU CITY OF FLAGSTAFF FOR YOUR TREMENDOUS SUPPORT

Councilmember Putzova asked what proportion of the students enrolled are coming from outside the public school system. Ms. Johnson stated that it is a very small number, perhaps around 12 students. She indicated that the number does increase slightly for holidays and summer programs.
 
Councilmember Putzova asked how many of the enrollees come from low income families. Ms. Johnson explained that FACTS does not track that information specifically other than to identify those who are enrolled in the scholarship program.
 
Executive Director Myra Ferrel-Womochil of Victim Witness Services continued the presentation.
 
VICTIM WITNESS SERVICES
WE ADVANCE CITY GOALS
THE NUMBERS
FY 14-15 FLAGSTAFF COMMUNITY RECEIVED
COLLABORATION
 
Mayor Nabours thanked all of the presenters and stated that the information is important to the Council to help understand their programs, what they are doing and what the City’s funding goes to. He stated that the service partner contributions will be discussed during the budget conversations in April.
 
Councilmember Putzova asked why the City treats service contracts so differently from other contracts. The Council does not ask the various contractors to provide to them where their funding sources come and how they spend their money. Mr. Tadder explained that these are community services that are being contracted for rather than receiving goods and services. Deputy City Manager Barbara Goodrich added that in past years many of the organizations were contacting the Councilmembers individually to provide updates and request funding; staff felt that providing an open forum for the organizations to address the Council all together was a solution. She and Mr. Tadder both expressed a willingness to change the process should Council have the desire to do so.
             
7.
Review of Draft Agenda Items for the April 5, 2016, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  None
             
8. Public Participation
  Bill Ring addressed Council to offer appreciation to Ms. D’Andrea for her service. He also indicated that he worked with Mr. Bertelsen at the County the City is lucky to have him on staff now at the City.
             
9. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Oravits requested a FAIR item for a Work Session with possible future action regarding the requirements for the cultural resources studies and the duties and the authorities of the Historical Preservation Officer/Department. He would like a staff presentation on all of the authorities and duties given to the Historic Preservation Officer and Department. He would also like to discuss any related ordinance or language that regulates the position. He would like a staff presentation on the section of the Zoning Code that authorizes the requirement for Cultural Resource Studies and some examples.
 
Councilmember Oravits reported that it appears that there is some work to do at the Senate concerning the Veterans Home. He stated that if anyone has any contacts at the Senate level now is the time to push Senators to approve the $10 million in the budget. He requested that Council put pressure on the Governor and all the Senators they can to approve the allocation.
 
Mayor Nabours requested the following three FAIR items:
  1. Consider deleting any requirement that developers pay for a portion of the I-40 Lone Tree Interchange. This would be similar to the discussion about the I-40 Bridge.
  2. Consider using Pine Canyon transportation fees for the Lone Tree road improvements.
  3. Discussion, input and direction from Council concerning Old Walnut Canyon road. The road is used by Flagstaff citizens all day long. Part of the road is on Forest Service Land and part of it is on private property. He would like to get a better understanding of the issues and discuss the option of making it a City maintained road.
Councilmember Evans thanked Ms. D’Andrea for serving as the City Attorney and wished her the best of luck on her new endeavor.
 
Councilmember Evans requested a CCR with a possible FAIR item to follow on the local preference points that are awarded on Design Build and CMAR. She would like to know what the definition of local is, the difference between Design Build and CMAR and their uses. There is a feeling in the community that by using a Design Build the local architects are excluded. She would like to get a better understanding of the process before deciding if she would like to request a FAIR item.
 
Ms. D’Andrea stated that it has been a pleasure to work for the City of Flagstaff and she thanked the Council for the key to the City.
             
10. Adjournment
  The Flagstaff City Council Work Session of March 29, 2016, adjourned at 8:23 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 04-May-24 02:34 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

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

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

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

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
	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 @ 02:34:27.027
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 450 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
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 = 450 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 = 129 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 @ 02:34:27.027
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
		
	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 = 129 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 129 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3343 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3349 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2591 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3341 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3344 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2592 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3342 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2599 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2593 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3351 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2594 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3345 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2595 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3347 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2596 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3346 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2597 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 3348 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:34:27.027
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 2598 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:34:27.027
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:34:27.027
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:34:27.027
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:34:27.027
		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=3&get_year=2016&dsp=min&seq=451
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=3&get_year=2016&dsp=min&seq=451
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=9499445
cftoken=359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
hitcount=4
lastvisit={ts '2024-05-04 02:34:27'}
timecreated={ts '2024-05-04 02:34:27'}
urltoken=CFID=9499445&CFTOKEN=359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
Cookie Variables:
CFID=9499445
CFTOKEN=359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=451
Session Variables:
cfid=9499445
cftoken=359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9499445_359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
subdir=/public/
tzoffset=0
urltoken=CFID=9499445&CFTOKEN=359b72b80adcf707-9D58B9A9-C552-3F18-22DC90079AD0D83B
URL Parameters:
dsp=min
get_month=3
get_year=2016
id=
mt=ALL
seq=451
Debug Rendering Time: 0 ms