Untitled


Voting Record
It is recommended that you set your printer to Landscape format when printing this report.
Voting Summary for Meeting Official Regina Salas
05/19/2020 - City Council Meeting - FINAL
AYE, AYE, AYE 5.A.  Consideration of Appointments:  Beautification and Public Art Commission.
AYE 5.B.  Consideration of Appointment:  Sustainability Commission.
AYE 6.A.  Consideration and Approval: Insurance Renewals
AYE 6.B.  Consideration and Approval of Grant Agreement:  Grant Agreement between the City of Flagstaff and the U.S. Department of Transportation, Federal Aviation Administration (FAA) for CARES Act funding for operational and maintenance expenses directly related to the Flagstaff Pulliam Airport.
AYE 6.C.  Consideration and Approval of Lease Amendments:  Amendment of Flagstaff Airport Leases to abate rent for at least six (6) months, due to the COVID-19 pandemic.
AYE, AYE 6.D.  Consideration and Adoption of Ordinance No. 2020-12: An ordinance of the City Council of the City of Flagstaff, temporarily suspending Section 8-01-001-0002 of the City Code pertaining to sidewalks; providing for severability, authority for clerical corrections, and establishing an effective date.
AYE 6.E.  Consideration and Approval of a Construction Manager at Risk (CMAR) Construction Services Contract: for the Annual Street Maintenance and Overlay and Chip Seal Program 2020 to C and E Paving & Grading, LLC in the amount of $5,627,422.10
AYE 6.F.  Consideration and Approval of Grant Award: Department of Justice, Bureau of Justice Assistance Coronavirus Emergency Supplemental Funding Program.
AYE, AYE 7.A.  Consideration and Adoption of Resolution No. 2020-22:  A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement between the Flagstaff Metropolitan Planning Organization, DBA MetroPlan, and the City of Flagstaff to transition administrative and financial services from the City to MetroPlan.
AYE, AYE 7.B.  Consideration and Adoption of Resolution No. 2020-23:  A resolution approving the Intergovernmental Agreement between the City of Flagstaff and Coconino County for election services for the August 4, 2020 Primary Election and November 3, 2020 General Election
AYE 7.C.  Consideration and Approval: City of Flagstaff and APS Clean Energy Future Memorandum of Understanding
AYE, AYE 7.D.  Consideration and Adoption of Resolution No. 2020-27:  A resolution of the City of Flagstaff City Council, approving an Intergovernmental Agreement between the State of Arizona and the City of Flagstaff for the design and construction of a roundabout at the signalized intersection of Fourth Street and Cedar Avenue/Lockett Road.
AYE, AYE 7.E.  Consideration and Adoption of Resolution No. 2020-28:  A resolution of the Flagstaff City Council adopting a Flagstaff Business  Retention and Expansion Incentive program support small businesses and other targeted industries; and establishing an effective date.
AYE, AYE, AYE, AYE, AYE 7.F.  Consideration and Adoption of Resolution No. 2020-25: A Resolution amending the 2019/2020 Annual Action Plan to reallocate 2019/2020 Owner-Occupied Housing Rehabilitation Program funds and allocate Community Development Block Grant Program COVID-19 (CDBG-CV) funds and authorizing submission of the amended 2019/2020 Annual Action Plan to the U.S. Department of Housing and Urban Development (HUD).

Consideration and Adoption of Resolution No. 2020-26:  A Resolution approving the City of Flagstaff 2020/2021 Annual Action Plan and authorizing its submission to the U.S. Department of Housing and Urban Development (HUD).

Consideration and Action on Reallocation of General Funds to Coconino County Health and Human Services Eviction Prevention Program: Approval of the transfer of one-time general fund dollars in the amount of $59,000 currently reserved for the Mobile Home Assistance for Displaced Residents Program to the Coconino County Health and Human Services Eviction Prevention and Housing Stabilization Program.
AYE, AYE 7.G.  Consideration and Adoption of Resolution No. 2020-24: A resolution of the Flagstaff City Council, authorizing the acquisition of real property interests necessary for the Rio De Flag Flood Control Project, confirming that the project is a public use for the benefit of the residents of the City of Flagstaff; providing for delegation of authority, condemnation authority, prior approval of purchases; and establishing an effective date
TOTALS: AYE:   27 NAY:   0 Other:    0    ABSENT:   0


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /officials.cfm
Time Stamp 28-Mar-24 12:27 PM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
328 ms 328 ms 1 D:/inetpub/PublicPages/officials.cfm
281 ms 281 ms 1 D:/inetpub/PublicPages/meetingOfficials.cfm
156 ms 10 ms 15 D:/inetpub/PublicPages/public/publish/include_levels.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/blueMenu.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/menu_tabs.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.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 15 D:/inetpub/PublicPages/public/publish/clean_subject.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  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
328 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 @ 12:27:57.057
			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 @ 12:27:57.057
				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 @ 12:27:57.057
			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 @ 12:27:57.057
				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\officials.cfm @ 12:27:57.057
		SELECT dist_name FROM fasinfo
	
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:27:57.057
		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 @ 12:27:57.057
	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 @ 12:27:57.057
		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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
		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 @ 12:27:57.057
		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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
	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 @ 12:27:57.057
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:27:57.057
	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=7) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:27:57.057
		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) = 2020-08-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2020-08-31 00:00:00.0

pageTitle (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT * FROM fasinfo
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT use_minutes, use_agendaquick, term_remind_days, c.misc_alpha4 hosted
	FROM fasinfo
	LEFT OUTER JOIN codes c ON (c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup')
checkCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT * from codes WHERE code_type = 'FORM_ID' AND valid_code = 'AG_MEMO'
OfficialsMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT mt.meeting_type, mt.descr, c.long_descr notify_public, c.misc_alpha15 meetingOfficials
	FROM meeting_type mt
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
	WHERE mt.show_public = 'Y' and c.misc_alpha15 = 'Y'
		
	ORDER BY mt.descr
getRecs (Datasource=frsRO, Time=15ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.descr
	from codes, term_tracker tt
	
		INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y')
	
	INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = tt.meeting_type AND c.misc_alpha15 = 'Y')
	where codes._rowid = tt.code_rowid and	
		  codes.code_type = 'AG_OFF'

	
	      and (tt.term_end >= ? )

	

	order by 
			tt.meeting_type, tt.lname, tt.fname
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2024-03-28 12:27:57.082

getRecsCount (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT * from getRecs
getRecs2 (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
	SELECT * from getRecs
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
		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' and c.misc_alpha15 = 'Y'
		AND CAST(mt.pdf_header as varchar) <> 'N'
		
	ORDER BY mt.descr
getOfficial (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
			select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.meeting_type, mt.descr
				from codes, term_tracker tt
			INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type AND mt.obsolete <> 'Y')
			INNER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = tt.meeting_type AND c.misc_alpha15 = 'Y')
			where codes._rowid = 5539 and
				  codes.code_type = 'AG_OFF' AND
				  tt.code_rowid = codes._rowid
		
getAllOfficialRecs (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
			select tt._rowid tt_rowid, tt.*, codes.valid_code, codes.long_descr, codes.dataSortOrder, mt.descr
			FROM codes, term_tracker tt
			INNER JOIN meeting_type mt ON (mt.meeting_type = tt.meeting_type)
			where codes._rowid = tt.code_rowid  AND
				  codes.code_type = 'AG_OFF' AND
				  tt.fname = 'Regina' AND
				  tt.lname = 'Salas'
		
getMinrecs (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
			SELECT min.form_num, m.meeting_dt, m.meeting_name
			from minutes min, meetings m
			where min.meeting_id = m.meeting_id
				AND m.the_meeting_type = 'CCMTGF'
				AND min.minutes_published = 'Y'
			
				AND min.form_num = 487 
			ORDER BY meeting_dt DESC, meeting_name
		
getVoteTypes (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
		SELECT valid_code, descr, long_descr vote_type, misc_alpha absent FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND obsolete <> 'Y'
		order by datasortorder
	
getOfficial (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
						SELECT valid_code, fname, lname, term_start, term_end from codes, term_tracker
						WHERE code_type = 'AG_OFF' AND
							  valid_code = 'RS5539' AND
							  code_rowid = codes._rowid
					
getMinrecs (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
							SELECT min.form_num, m.meeting_dt, m.meeting_name
							from minutes min, meetings m
							where min.meeting_id = m.meeting_id
						
							AND min.form_num = 487 
							ORDER BY meeting_dt DESC, meeting_name
						
getMinLines (Datasource=frsRO, Time=47ms, Records=37) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
								SELECT a.cont_numbering, a.form_num minutes_form_num, am.form_num fas_form_num, am.ag_item_rowid,
									   ml._rowid ln_rowid, ml._rowid min_ln_rowid, ml.form_num, ml.seq_num,
									   am.ag_item_rowid, ml.ag_level1 chk_level1, ml.ag_level2 chk_level2, ml.ag_level3 chk_level3,
									   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.disp_level, am.ainumber,
									   as1.sort_seq sort_level1, ml.ag_memo_id, ml.ag_memo_rev, c1.descr ag_time_descr,
									   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
									   aa.item_type, aa.ag_area, ml.ag_subject,
									   c4.misc_alpha2 level_descriptor,
									   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
											mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
									   CASE WHEN am.ainumber = '' then '-1'
										WHEN am.ainumber = '0' then '-1'
										WHEN am.ainumber IS NULL then '-1'
								        ELSE am.ainumber END AS sort_memo2,
									    am.ag_item_rowid,
									   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,
									   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time
								FROM minutes_ln ml
								INNER JOIN minutes a ON (a.form_num = ml.form_num AND a.rev_num = ml.rev_num)

								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 ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
								LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
								LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
								
								LEFT OUTER JOIN ag_item AS ai ON (ai._rowid = am.ag_item_rowid)
								
								LEFT OUTER JOIN agenda_ln AS al ON (al.ag_memo_id = am.form_num AND al.ag_memo_rev = am.rev_num)
								LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = agt.meeting_type AND aa.ag_area = ml.ag_area)          
								LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
								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)))
								LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
								LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
								LEFT OUTER JOIN codes AS c4 ON (c4.code_type = 'MTG_MSG' and c4.valid_code = mt.meeting_type)
								WHERE ml.form_num = 487
								ORDER BY sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
							
checkVoteParent (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						
getAllVotes (Datasource=frsRO, Time=31ms, Records=27) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
							SELECT mlv.form_num, ml.form_num minutes_form_num, ml._rowid min_ln_rowid,
									mlv.valid_code, mlv.motion_seq, mlv.seq_num, mlv.motion_rowid,
									ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, mlm.motion_status, mlm.ln_rowid,
									c1.descr voteDescr, vote, c.descr, c1.long_descr vote_type, c1.misc_alpha abs_vote, tt.lname
							from minutes_ln_vote mlv
							INNER JOIN minutes_ln ml ON (ml._rowid = mlv.ln_rowid)
							INNER JOIN minutes_ln_motion mlm ON (mlm.ln_rowid = mlv.ln_rowid AND mlm.motion_seq = mlv.motion_seq)
							INNER JOIN codes c1 ON (c1.code_type = 'AG_VOTEOTHER' AND c1.valid_code = mlv.vote)
						
							INNER JOIN codes c ON (c.code_type = 'AG_OFF' AND c._rowid = 5539)
							INNER JOIN term_tracker tt ON (tt.code_rowid = c._rowid)
							LEFT OUTER JOIN codes c2 ON (c2.code_type = 'AG_OFF' AND c2.descr = tt.fname + ' ' + tt.lname and
									c2.valid_code = mlv.valid_code AND
									c2.large_misc_alpha = tt.meeting_type)
						    INNER JOIN minutes_roll mr ON (mr.form_num = mlv.form_num AND mr.name = c2.descr AND c2.large_misc_alpha = tt.meeting_type)
						
							WHERE mlv.form_num = 487 
								AND mlv.valid_code = 'RS5539'
							
							order by mlv.form_num, mlv.ln_rowid, mlv.motion_seq, mlv.seq_num, mlv.valid_code
						
totalVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					
getType (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'AYE'
	
getMeetingVoters (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 487
							order by lname
						
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10818
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10822
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10829
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10819
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10824
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10820
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10821
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10833
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10833 
chkLevel1 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10834
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10834 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10823
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10852
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10852 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10835
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10835 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10849
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10849 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'C'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'C'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10836
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10836 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'D'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'D'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10837
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10837 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'E'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'E'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10838
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10838 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'F'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '6'
					AND a.ag_level2 = 'F'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10825
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10839
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10839 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10840
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10840 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10841
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10841 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'C'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'C'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10842
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10842 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'D'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'D'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10850
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10850 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'E'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'E'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10851
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10851 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'F'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'F'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10843
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
		SELECT meeting_id FROM minutes WHERE form_num = 487 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:27:57.057
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1058

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT * from getMinLines
					WHERE ln_rowid = 10843 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'G'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:27:57.057
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 487
					AND a.ag_level1 = '7'
					AND a.ag_level2 = 'G'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10826
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10844
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10845
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10846
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10831
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10830
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10847
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10832
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10853
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10854
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10848
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10827
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:27:57.057
											SELECT * from getAllVotes WHERE ln_rowid = 10828
											order by motion_seq, seq_num, valid_code
										


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\officials.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=//officials.cfm?seq=487&report=OFFICIAL&rowid=5539&off=RS5539&LOC=&LOGIN=&GET_MONTH=8&GET_YEAR=2020&FP=&DSP=&ln=0&SUB=&SSTR=&MT=ALL&id=&StartRow=1
HTTP_USER_AGENT=claudebot
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\officials.cfm
QUERY_STRING=seq=487&report=OFFICIAL&rowid=5539&off=RS5539&LOC=&LOGIN=&GET_MONTH=8&GET_YEAR=2020&FP=&DSP=&ln=0&SUB=&SSTR=&MT=ALL&id=&StartRow=1
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/officials.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=8629879
cftoken=9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
hitcount=4
lastvisit={ts '2024-03-28 12:27:57'}
timecreated={ts '2024-03-28 12:27:57'}
urltoken=CFID=8629879&CFTOKEN=9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
Cookie Variables:
CFID=8629879
CFTOKEN=9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
Form Fields:
FROMDATE=2018-12-18 00:00:00.0
FROMVOTEDATE={ts '2023-03-28 12:27:57'}
FROMVOTEYEAR=2023
MODE=
TODATE=2022-12-18 00:00:00.0
TOVOTEDATE={ts '2024-03-28 12:27:57'}
Session Variables:
cfid=8629879
cftoken=9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8629879_9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
subdir=/public/
tzoffset=0
urltoken=CFID=8629879&CFTOKEN=9f264f90a55ecd9-4145794A-CE8C-54C2-F37BC6E950469BE0
URL Parameters:
DSP=
FP=
GET_MONTH=8
GET_YEAR=2020
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
id=
ln=0
off=RS5539
report=OFFICIAL
rowid=5539
seq=487
Debug Rendering Time: 0 ms