Untitled


Voting Record
It is recommended that you set your printer to Landscape format when printing this report.
Voting Summary for Meeting Official Austin Aslan
10/01/2019 - City Council Meeting - FINAL (AMENDED)
AYE 4.A.  Consideration and Approval of Minutes: City Council Special Work Session of January 23, 2018; Work Session of June 12, 2018; Work Session of September 11, 2018; Work Session of November 13, 2018; Special Meeting (Executive Session) of June 25, 2019; Special Meeting (Executive Session) of July 2, 2019; Special Meeting (Executive Session) of August 27, 2019; Special Meeting (Executive Session) of September 10, 2019; Special Meeting (Executive Session) of September 17, 2019; and Special Meeting (Executive Session) of September 24, 2019
AYE, AYE 7.A.  Consideration of Appointments:  Beautification and Public Art Commission.
AYE, AYE, AYE 7.B.  Consideration of Appointments:  Commission on Diversity Awareness.
AYE 8.  
CONSENT ITEMS

All matters under Consent Agenda are considered by the City Council to be routine and will be enacted by one motion approving the recommendations listed on the agenda. Unless otherwise indicated, expenditures approved by Council are budgeted items.

Councilmember Whelan asked to pull Items 8A and 8E.
AYE 8.A.  Consideration and Approval of (Confirming) Payment:  Reimbursement payment to Vintage Partners (VP) & Woody Mountain LLC for the installation of new public sewer line. (Sewer line reimbursement as agreed to in the 2016 Council approved Development Agreement with Vintage Partners).
AYE 8.E.  Consideration and Approval of Cooperative Purchase Contract: Contract for various professional level consulting with Interim Public Management, LLC utilizing a cooperative purchasing contract through the City of Maricopa.
AYE, AYE 9.A.  Consideration and Adoption of Ordinance No. 2019-29:  A Zoning Map Amendment, requested by San Francisco de Asis Parish and the Planning Director, of approximately 0.62 acres located at 244 S. Kendrick Street to add Landmarks Overlay (LO) Zone to the existing zoning classification of High Density Residential (HR) Zone.
AYE 9.B.  Consideration and Approval of Grant Application and Acceptance Upon Award: U.S. Department of Justice, 2019 Edward Byrne Memorial Justice Assistance Grant in the amount of $20,458.00.
AYE, AYE 9.C.  Consideration and Adoption of Resolution No. 2019-46: A resolution approving an Intergovernmental Agreement (IGA) Grant Application between the City of Flagstaff and Coconino County the U.S. Department of Justice, Fiscal Year 2019 Edward Byrne Memorial Justice Assistance (JAG) Grant.
AYE 9.E.  Consideration and Approval of a Cooperative Purchase Contract:  For a new Pierce Manufacturing, Inc. Velocity Fire Engine in the amount of $693,148.75 from Hughes Fire Equipment, Inc.
AYE 9.F.  Consideration and Approval of Cooperative Purchase Contract:  Purchase of new turnout/personal protective equipment for all operational fire personnel from L.N. Curtis and Sons in the amount of $238,455.89 through a cooperative purchase contract with the General Service Administration.
AYE 9.G.  Consideration and Approval of Lease of City-Owned Property:  Amendment to extend the Flagstaff Railroad Passenger Station Facility Lease with National Railroad Passenger Corporation (Amtrak) for a term of five (5) years, with options for renewal.
AYE 9.D.  Consideration and Approval of Contract: Award of a Professional Services Contract with Brown and Caldwell, Inc. for the Lake Mary Water Treatment Plant Sedimentation Basin Design.
TOTALS: AYE:   18 NAY:   0 Other:    0    ABSENT:   0


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /officials.cfm
Time Stamp 28-Mar-24 01:36 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
313 ms 313 ms 1 D:/inetpub/PublicPages/officials.cfm
281 ms 281 ms 1 D:/inetpub/PublicPages/meetingOfficials.cfm
125 ms 10 ms 13 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 13 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
313 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 @ 13:36:11.011
			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 @ 13:36:11.011
				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 @ 13:36:11.011
			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 @ 13:36:11.011
				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 @ 13:36:11.011
		SELECT dist_name FROM fasinfo
	
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:11.011
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:36:11.011
		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 @ 13:36:11.011
	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 @ 13:36:11.011
		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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
		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 @ 13:36:11.011
		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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 13:36:11.011
	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 @ 13:36:11.011
		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 @ 13:36:11.011
	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 @ 13:36:11.011
	SELECT * FROM fasinfo
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:11.011
	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 @ 13:36:11.011
	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 @ 13:36:11.011
	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=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
	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 13:36:11.991

getRecsCount (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
	SELECT * from getRecs
getRecs2 (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
	SELECT * from getRecs
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
		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=16ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
			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 = 5535 and
				  codes.code_type = 'AG_OFF' AND
				  tt.code_rowid = codes._rowid
		
getAllOfficialRecs (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
			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 = 'Austin' AND
				  tt.lname = 'Aslan'
		
getMinrecs (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
			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 = 437 
			ORDER BY meeting_dt DESC, meeting_name
		
getVoteTypes (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
		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=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
						SELECT valid_code, fname, lname, term_start, term_end from codes, term_tracker
						WHERE code_type = 'AG_OFF' AND
							  valid_code = 'AA5535' AND
							  code_rowid = codes._rowid
					
getMinrecs (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
							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 = 437 
							ORDER BY meeting_dt DESC, meeting_name
						
getMinLines (Datasource=frsRO, Time=63ms, Records=45) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
								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 = 437
								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 @ 13:36:12.012
							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						
getAllVotes (Datasource=frsRO, Time=31ms, Records=18) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
							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 = 5535)
							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 = 437 
								AND mlv.valid_code = 'AA5535'
							
							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 @ 13:36:12.012
						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					
getType (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'AYE'
	
getMeetingVoters (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 437
							order by lname
						
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9770
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9774
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9788
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9771
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9780
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9787
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9813
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9813 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '4'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '4'
					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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '4'
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9772
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9777
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9811
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9812
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9773
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9793
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9793 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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=3) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9794
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9794 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9775
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9775 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					AND a.ag_level2 = ''
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9795
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9795 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9797
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9798
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9799
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9796
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9796 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '8'
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9776
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9800
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9800 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9801
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9801 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9802
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9802 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 14402
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9804
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9804 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9805
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9805 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9806
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9806 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '9'
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9778
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9779
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9781
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9792
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9790
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9782
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9803
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
		SELECT meeting_id FROM minutes WHERE form_num = 437 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 13:36:12.012
		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) = 927

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT * from getMinLines
					WHERE ln_rowid = 9803 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '15'
					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=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '15'
					AND a.ag_level2 = '9'
					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 @ 13:36:12.012
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 437
					AND a.ag_level1 = '15'
					AND a.ag_level2 = '9'
					AND a.ag_level3 = 'D'
					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 @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9783
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9807
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9784
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9808
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9791
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9789
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9810
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9809
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9785
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 13:36:12.012
											SELECT * from getAllVotes WHERE ln_rowid = 9786
											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=437&report=OFFICIAL&rowid=5535&off=AA5535&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=437&report=OFFICIAL&rowid=5535&off=AA5535&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=8630993
cftoken=5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
hitcount=4
lastvisit={ts '2024-03-28 13:36:11'}
timecreated={ts '2024-03-28 13:36:11'}
urltoken=CFID=8630993&CFTOKEN=5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
Cookie Variables:
CFID=8630993
CFTOKEN=5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
Form Fields:
FROMDATE=2022-12-20 00:00:00.0
FROMVOTEDATE={ts '2023-03-28 13:36:11'}
FROMVOTEYEAR=2023
MODE=
TODATE=2026-12-20 00:00:00.0
TOVOTEDATE={ts '2024-03-28 13:36:11'}
Session Variables:
cfid=8630993
cftoken=5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8630993_5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
subdir=/public/
tzoffset=0
urltoken=CFID=8630993&CFTOKEN=5b13c7ceb57e932e-43B64183-EE6A-E3A0-5C819D703A5D552B
URL Parameters:
DSP=
FP=
GET_MONTH=8
GET_YEAR=2020
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
id=
ln=0
off=AA5535
report=OFFICIAL
rowid=5535
seq=437
Debug Rendering Time: 15 ms