Return
 SPECIAL WORK SESSION
TUESDAY, JANUARY 23, 2018

COUNCIL CHAMBERS
211 WEST ASPEN AVE.

6:00 P.M.
 
 


SPECIAL WORK SESSION
             
             
1.
Call to Order

Mayor Evans called the Special Work Session of the Flagstaff City Council held January 23, 2018, to order at 6:04 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 and Mission Statement

The Council and audience recited the Pledge of Allegiance and Councilmember Barotz 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
ABSENT:

COUNCILMEMBER PUTZOVA





  Others present: City Manager Josh Copley; City Attorney Sterling Solomon.
             
4. PUBLIC PARTICIPATION

Public Participation enables the public to address the Council about an item that is not on the agenda. Comments relating to items that are on the agenda will be taken at the time that the item is discussed. If you wish to address the Council at tonight's meeting, please complete a comment card and submit it to the recording clerk as soon as possible. Your name will be called when it is your turn to speak. 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 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.
  John Viktora addressed Council about the recent border wall resolution and freedom of speech.
 
Carrie Heinonen addressed Council in support of NAU and their contributions to the Museum of Northern Arizona.
 
Jeff Hall addressed Council also in support of NAU and the relationship and collaboration that they have with Lowell Observatory.
 
Scott Hathcock addressed Council in support of NAU and their partnership with NACET. Half of the interns at NACET come from NAU and they offer exceptional work.
 
Goia Woods addressed Council in support of the resolution against the border wall and offered appreciation for the words spoken at the Women’s March.
             
5.
Special Work Session with Dr. Rita Cheng, President of Northern Arizona University
  Northern Arizona University President Dr. Rita Cheng joined the Mayor and Council at the dais.
             
A. Recognition of NAU Men's Cross Country Team
  The NAU Men’s Cross Country team came forward to be recognized by the City Council and President Cheng.
 
President Cheng thanked the City for the invitation to join the Council for a joint meeting. She introduced Coach Mike Smith who was honored as the National Men’s Coach of the Year. She stated that the team won it’s second National Championship last November and their success is due to the exceptional students and team members as well as training. She recognized High Altitude Training and their partnership with NAU to aid in the necessary training for the team.
 
Coach Smith offered that the team is very fortunate to have the opportunity to train directly in the community on the FUTs trails and there are no athletes more prepared than those who train here. In addition to being a great team, the men do a great job in the classroom as well with an average GPA above 3.0.
 
Coach Smith then introduced Assistant Coaches Becca Deloache and Jarred Cornfield and the Men’s Cross Country team members.
 
Matt Baxter, Geordie Beamish, Cade Burks, Tyler Day, Joey Defeo, Blaise Ferro, James Fitzgerald, Elliot Gindi, Cory Glines, Luis Grijalva, Kyle Havriliak, Soren Knudsen, Ryan Lanley, Peter Lomong, Harvey Nelson, Beau Prince, Jack Shea, Andrew Trouard and Ryan Wolff.
 
Mayor Evans thanked the team and offered that the City is proud of how they represent the City of Flagstaff.
             
B. Opening Remarks
             
i. Mayor Evans
  Mayor Evans welcomed President Cheng and staff for attending the meeting. She stated that she would like the meeting to be an annual event for the City of Flagstaff and NAU. She then offered a PowerPoint presentation that highlighted the great work and partnerships the City and NAU have.
 
NAU HOMECOMING WEEK PARADE
RIO DE FLAG FLOOD CONTROL PROJECT
MEXICAN CONSULATE GENERAL
OFF-CAMPUS LIFE AND NEIGHBORHOOD LIAISON
ARIZONA MEXICO COMMISSION 2018 SUMMIT
OTHER CITY OF FLAGSTAFF PARTNERSHIPS
             
ii. President Cheng
  President Cheng thanked the City for inviting them to come. NAU has the pleasure of working with the City on many issues and the staff has always been very collaborative and dedicated to problem solving and problem recognition. President Cheng introduced Executive Vice President and Chief of Staff Joanne Keene, Vice President for Capital Planning and Campus Operation Dan Okoli, Vice President for Enrollment Management and Student Affairs Jane Kuhn, Assistant to the President for Executive Communication and Media Relations Kim Ott and Director of Alumni Engagement Stephanie Smith.
 
President Cheng provided a PowerPoint presentation that covered the following:
 
NATIONALLY RECOGNIZED & LOCALLY VITAL
ONE OF THE BEST COLLEGE TOWNS IN THE NATION
BEST OF…
NEIGHBORS AND PARTNERS
TOGETHER
LOOKING BACK
LOOKING FORWARD
THANK YOU
             
C. Neighborhood Liaison Work Program Update
  Assistant to the City Manager Caleb Blaschke introduced City of Flagstaff/NAU Neighborhood Liaison Valeria Chase and Director of Student Life Kevin Gemoets.

Ms. Chase introduced herself and provided a PowerPoint Presentation that covered the
 
following:

6-MONTH WORK PLAN
KEY PRIORITIES
OPEN LINES OF COMMUNICATION
ESTABLISH COLLABORATIVE RELATIONSHIPS
BUILD STUDENT-NEIGHBOR CONNECTIONS
CONTACT INFORMATION
             
D. Rio de Flag Storm Water Project Update
  Capital Improvements Manager James Duval provided a PowerPoint Presentation that covered the following:
 
RIO DE FLAG STORM WATER PROJECT UPDATE
100-YEAR FLOOD IMPACT
PROJECT AREA
RECENT EVENTS
PATH FORWARD
 
Councilmember Barotz asked about the RSOQ and what it is for. Mr. Duval stated that it is part of a public relations campaign; the goal is to find a firm to help with the message to the community about why the project is needed, why it is important and the funding needs.
 
Councilmember Barotz offered that the earlier meeting discussed the options for paying for the project. President Cheng offered that NAU appreciated the opportunity to go out into the field and see the areas that would be impacted with a 100 year flood. NAU is a large water user and a large partner with the City. They are included in the recent stormwater fee increases and they do have sales tax revenues from some of their business operations. If the City chooses a sales tax option for funding then NAU will be a partner in that aspect as well. She added that if there are opportunities for NAU to voice support outside the financial piece they will use their government relations to do that.
 
Councilmember Odegaard indicated that 25% of the university would be affected by a flood and asked if there could be any chance of funding from the Board of Regents to assist in the project. President Cheng stated that she does not have any answers at this time, but indicated that the state funds that go to the university are to support the education efforts of the community. NAU is self-insured so the Risk Management Department may be an option to pursue.
 
Councilmember McCarthy stated that there will come a time where the City will need some help lobbying for the project. The City has been successful thus far but would appreciate NAU contributing in the lobbying efforts to help get the funding and support from the federal government.
             
E. Agency Capital Improvement Program Update
             
i. City of Flagstaff
  Capital Improvements Engineer Bret Peterson provided a PowerPoint presentation
 
that covered the following:
 
COF CAPITAL IMPROVEMENT PROJECTS
A – ADVANCED TRAFFIC MANAGEMENT SYSTEM
B – FOUNTAINE WATER AND SEWER
C – FRANKLIN & SAN FRANCISCO TRAFFIC SIGNAL
D – LONE TREE FUTS TRAIL – NAU ACCESS TRAIL
E – MILL TOWN (P3)
 
President Cheng asked if it has been determined when ADOT will be moving. Mr. Peterson stated that there is no date set yet. The developer needs to accommodate the reconstruction of the Harkins building in order for ADOT to be moved.
 
Councilmember Barotz asked about the pedestrian tunnel. City Engineer Rick Barrett stated that the pedestrian tunnel is part of the zoning case, the traffic impact analysis and the site plan review. Depending on the outcome of the zoning case there will be a better understanding of the timeline.
 
F – LONE TREE PEDESTRIAN PATH AND WATERLINE
 
Vice Mayor Whelan stated that at one point there was concern about the safety of the kids walking to Kinsey School because there are no sidewalks. She asked if the pedestrian path would provide that safety for students. Mr. Copley explained that one of the reasons the City did the delineation for the parking was because there are no sidewalks on the west side and the students did not want to cross the street and it meant that they had to walk into the roadway to go around the cars. There is a lot of use in that field so the City will have to work with NAU and Kinsey School about the kinds of parking amenities that might be needed for weekend users.
 
G – PINE KNOLL FUTS TRAIL
 
President Cheng thanked the City for the work on the trail. The south side of the Pine Knoll entrance was completed last year because parents and students were having to walk in cinders, snow, ice and puddles and the trail further aids those efforts. She added that NAU is looking at improving the walkability of the rest of Pine Knoll by expanding sidewalks.
 
H – MCCONNELL SIDEWALK (ADOT)
I – ZUNI
 
Councilmember Odegaard noted that the staging area on Lake Mary Road was cleaned up beautifully and it looks great.
 
J – JOHN WESLEY POWELL – SPECIFIC PLAN
             
ii. Northern Arizona University
  Mr. Okoli provided a PowerPoint presentation that covered the following:
 
CURRENT CAPITAL PROJECTS
HONORS HALL
RECITAL HALL
DUBOIS SOUTH DINING RENOVATION
SCIENCE ANNEX
SKYVIEW RESIDENCE APARTMENTS
 
Vice Mayor Whelan asked if there is any plan for family housing on campus. Ms. Kuhn stated that there is family housing on south campus and the demand has really ebbed and flowed over the last few years. The priority always goes to families seeking residence but currently the majority of residents in those areas are upper classman. There are currently no plans to add additional family housing because the demand has been low over the last 10 years.
 
Councilmember Odegaard asked how NAU ranks in terms of housing students. Ms. Kuhn explained that NAU ranks in the top 1% by the International Association of College and University Housing. NAU currently houses about 47% of the students that come to the Flagstaff campus. President Cheng added that the housing has been fairly consistent over time and it is at a high now at 47%.
 
Vice Mayor Whelan asked if the new developments on campus have to go through the City development process. Mr. Okoli stated that NAU does not go through the City process; they do their own inspections through the campus but they always work with City staff on all projects. President Cheng offered that NAU guidelines are state guidelines and the collaboration between the City and NAU is to understand and address the impacts on sewer and electricity. Mr. Copley added that NAU also pays sales tax and construction tax.
             
6. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Odegaard thanked President Cheng and the staff from NAU for attending stating that the joint meeting is all about creating transparency in the community.
 
Vice Mayor Whelan stated that it is an honor to have NAU at the dais. She offered appreciation for the willingness that the City and NAU have to work through some misconceptions and great ideas. NAU and the City rely heavily on each other and to have this kind of communication is great.
 
Councilmember Barotz also thanked NAU for coming and being a part of the meeting. She also reported that she and Vice Mayor Whelan attended the Commission on Disability Awareness meeting and had a good conversation about their efforts to rename the Commission.
 
Councilmember Overton thanked NAU for coming. He stated that the things that are happening on campus are great for the community. He offered thanks on behalf of transit and the improvements that have been made with Route 10 and moving the community and students efficiently through campus. As the City tries to tackle all the transportation challenges, the university will be an important piece to those efforts.
 
Mr. Copley stated that almost every City staff person that presented tonight is a proud alum of NAU; there are many NAU colors flowing in the City of Flagstaff.
 
President Cheng thanked the City for the invitation to participate in the meeting and she is pleased to be here and take part. She also thanked the City for its support and recognition of NAU’s contribution to the community. She looks forward to addressing the issues that a large campus means to the community.
 
Mayor Evans stated that she, Vice Mayor Whelan, Mr. Copley and Mr. Blaschke attended the Governors Budget Overview which was very informative. Today she met with the Greater Flagstaff Chamber of Commerce Board of Directors to provide an overview of the City’s state and legislative priorities.
 
Mayor Evans thanked President Cheng and her staff for attending and participating in the meeting. She also offered thanks to Rich Bowen for his partnership with the City.
             
7. Adjournment

The Flagstaff City Council Special Work Session of January 23, 2018, adjourned at 7:52 p.m.

   
_______________________________
MAYOR
ATTEST:
 

 
 
_________________________________
CITY CLERK

    

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

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


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 06-May-24 05:29 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
266 ms 266 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
203 ms 203 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 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/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/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
266 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 @ 05:29:02.002
			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 @ 05:29:02.002
				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=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 05:29:02.002
			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 @ 05:29:02.002
				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 @ 05:29:02.002
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 05:29:02.002
	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 @ 05:29:02.002
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 05:29:02.002
		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 @ 05:29:02.002
	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 @ 05:29:02.002
		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 @ 05:29:02.002
	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 @ 05:29:02.002
	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 @ 05:29:02.002
		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 @ 05:29:02.002
		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 @ 05:29:02.002
	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 @ 05:29:02.002
	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 @ 05:29:02.002
	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 @ 05:29:02.002
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 05:29:02.002
	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 @ 05:29:02.002
	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 @ 05:29:02.002
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 05:29:02.002
	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=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 05:29:03.003
		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) = 2018-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 05:29:03.003
			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(671 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 @ 05:29:03.003
	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 @ 05:29:03.003
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 670 
getAllMnLines (Datasource=frsRO, Time=62ms, Records=19) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
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 = 670 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 = 285 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=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
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 @ 05:29:03.003
	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 @ 05:29:03.003
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=32ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
		
	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 = 285 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 285 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 @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6736 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6729 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6733 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6728 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5025 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6735 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5026 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6730 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5027 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6737 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5029 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6738 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6739 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5031 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6740 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5032 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6741 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5041 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6742 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5034 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6743 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6744 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5036 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6745 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5037 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6731 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5038 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6732 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 05:29:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 05:29:03.003
	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 @ 05:29:03.003
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 05:29:03.003
		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 @ 05:29:03.003
		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=1&get_year=2018&dsp=min&seq=671
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=1&get_year=2018&dsp=min&seq=671
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=9553875
cftoken=dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
hitcount=4
lastvisit={ts '2024-05-06 05:29:02'}
timecreated={ts '2024-05-06 05:29:02'}
urltoken=CFID=9553875&CFTOKEN=dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
Cookie Variables:
CFID=9553875
CFTOKEN=dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=671
Session Variables:
cfid=9553875
cftoken=dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9553875_dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
subdir=/public/
tzoffset=0
urltoken=CFID=9553875&CFTOKEN=dbfcad46b19409ed-0A93E161-014C-FAA4-D51E3F6A7DC9C889
URL Parameters:
dsp=min
get_month=1
get_year=2018
id=
mt=ALL
seq=671
Debug Rendering Time: 0 ms