Untitled


Voting Record
It is recommended that you set your printer to Landscape format when printing this report.
Voting Summary for Meeting Official Adam Shimoni
10/15/2019 - City Council Meeting - FINAL (AMENDED)
AYE 4.A.  Consideration and Approval of Minutes: City Council Work Session of October 30, 2018; Work Session of November 27, 2018; Regular Meeting of December 18, 2018; Special Meeting (Executive Session) of September 3, 2019; Special Meeting (Executive Session) of September 30, 2019; and Special Meeting (Executive Session) of October 1, 2019
AYE, AYE 7.A.  Consideration of Appointments:  Parks and Recreation Commission.
AYE 8.A.  Consideration and Action on Liquor License Application: Lynda Apple "Single Speed Coffee Cafe," 2 S. Beaver Street #170, Series 12 (restaurant), New License.
AYE 9.  
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.
AYE 10.A.  Consideration and Adoption of Ordinance No. 2019-34:  An ordinance of the City Council of the City of Flagstaff, relating to the financing of certain projects, specifically approving publication of notice of proposed lease of land and buildings from, and lease-purchase back of such land and buildings to, the City and request for bids in connection therewith; authorizing the acceptance of a bid with respect thereto; approving the sale and execution and delivery of Certificates of Participation in a lease-purchase agreement to provide the necessary financing therefor; approving the form and authorization the execution and delivery of necessary agreements, instruments and documents related to the sale and issuance of the certificates; delegating authority to the Management Services Director of the City to determine certain matters and terms with respect to the foregoing; and authorizing the taking of all other actions necessary to the consummation of the transactions contemplated by this ordinance and ratifying all actions taken to further this ordinance; providing for severability, authority for clerical corrections, and establishing an effective date (Certificate of Participation Debt Authorization - Municipal Court Facilities)
AYE 10.B.  Consideration and Adoption of Ordinance No. 2019-35:  An ordinance of the City Council of the City of Flagstaff, (1) providing for the sale and issuance of City of Flagstaff, Arizona General Obligation Bonds, Series 2019 and for the annual levy of a tax for the payment of the bond; (2) approving the form and authorizing the execution and delivery of necessary agreements, instruments and documents related to the sale and issuance of the bonds; (3) delegating authority to the Management Services Director of the City to determine certain matters and terms with the respect to the foregoing; (4) adopting continuing disclosure procedures in connection with issuance of obligations of the City; and (5) authorizing the taking of all other actions necessary to the consummation of the transactions contemplated by this ordinance and ratifying all actions taken to further this; providing for severability, authority for clerical corrections, and establishing an effective date (General Obligation Debt Authorization - Public Safety Communication Equipment and Municipal Court Facilities)
AYE 10.C.  Consideration and Adoption of Ordinance No. 2019-33:  An ordinance of the City Council of the City of Flagstaff, approving the form and authorizing the execution and delivery of a loan agreement with the Water Infrastructure Financing Authority of Arizona from its Clean Water Revolving Fund program; delegating the determination of certain matters relating thereto to the Management Services Director of the City; providing the transfer of certain moneys and making certain covenants and agreements with respect thereto and authorizing the taking of all other actions necessary to the consummation of the transactions contemplated by such loan agreement; providing for severability, authority for clerical corrections, and establishing an effective date (Water Infrastructure Loan Authorization - Flagstaff Watershed Protection Project)
AYE 10.D.  Consideration and Adoption of Ordinance No. 2019-30: An ordinance of the City Council of the City of Flagstaff, dedicating certain City property as public right-of-way within the area of John Wesley Powell Boulevard and Shamrell Boulevard; delegating authority to complete the transactions and establishing an effective date.
AYE, AYE 10.E.  Consideration and Adoption of Resolution No. 2019-47:  A resolution of the Flagstaff City Council, approving an intergovernmental agreement between the Arizona Board of Regents, for and on behalf of Northern Arizona University, and the City of Flagstaff for the processing of organic material produced within City limits at the University’s processing facility.
AYE, AYE 10.F.  Consideration and Adoption of Resolution No. 2019-51: A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement between the State of Arizona, Department of Transportation, and the City of Flagstaff for the advertising, bid, award, excavation and backfill of the channel under the Rio de Flag Bridge on the Interstate 40 Business Route.
AYE, AYE 15.A.  Consideration and Adoption of Resolution No. 2019-49 and Ordinance No. 2019-32:  A Resolution of the City Council of the City of Flagstaff, Coconino County, Arizona, declaring as a public record that certain document filed with the City Clerk and entitled "Case No. PZ-19-00094 Updates to Zoning Code 2019 –Miscellaneous Part 1" "Case No. PZ-19-00095 Updates to Zoning Code 2019 - Accessory Dwelling Units"; and, an Ordinance of the City Council of the City of Flagstaff, Coconino County, Arizona, amending the Flagstaff City Code, Title 10, Flagstaff Zoning Code (Ordinance No. 2011-20), for the purpose of modifying chapters, divisions, and sections of Title 10, Flagstaff Zoning Code, including the sections of Division 10-20.30: Common Procedures, Division 10-20.40: Permits and Approvals, Division 10-30.60: Site Planning Design Standards,  Division 10-40.30: Non-Transect Zones, Division 10-40.40: Transect Zones, Division 10-40.60: Specific to Uses, Division 10-50.30: Building Height, Division 10-50.40: Encroachments, Division 10-50.50: Fences and Screening, Division 10-50.60: Landscaping Standards, Division 10-50.100: Sign Standards, Division 10-50.90: Resource Protection Standards, and Division 10-80.20: Definition of Specialized Terms, Phrases, and Building Functions, to resolve conflicts, incorporate technical corrections and clarity, and to add new, and modify existing, requirements, provisions, and definitions.
AYE, AYE 15.B.  Consideration and Adoption of Resolution No. 2019-48 and Ordinance No. 2019-31:  A Resolution of the City Council of the City of Flagstaff, Coconino County, Arizona, declaring as a public record that certain document filed with the City Clerk and entitled "Case No. PZ-19-00095 Updates to Zoning Code 2019 - Accessory Dwelling Units"; and, an Ordinance of the City Council of the City of Flagstaff, Coconino County, Arizona, amending the Flagstaff City Code, Title 10, Flagstaff Zoning Code (Ordinance No. 2011-20), for the purpose of modifying chapters, divisions, and sections of Title 10, Flagstaff Zoning Code, including the sections of Division 10-40.60: Specific to Uses, and Division 10-80.20: Definition of Specialized Terms, Phrases, and Building Functions, to resolve conflicts, incorporate technical corrections and clarity, and to add new and modify existing  requirements, provisions, and definitions.
AYE, AYE 16.A.  Consideration and Adoption of Resolution No. 2019-45: A resolution approving an Intergovernmental Agreement (IGA) between the Arizona Department of Economic Security and the City of Flagstaff to provide up to $150,000 in voluntary city funding to qualified developmental disability service providers within the city limits of Flagstaff, Arizona; and establishing an effective date.
AYE, AYE, AYE 16.B.  Consideration and Adoption of Resolution No. 2019-50:  A resolution of the Flagstaff City Council urging the United States Congress to ratify the United States-Mexico Agreement (USMCA).
AYE 17.A.  Rio de Flag Flood Control Project - Update
TOTALS: AYE:   23 NAY:   0 Other:    0    ABSENT:   0


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /officials.cfm
Time Stamp 28-Mar-24 12:54 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
297 ms 297 ms 1 D:/inetpub/PublicPages/meetingOfficials.cfm
157 ms 10 ms 15 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 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:54:52.052
			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:54:52.052
				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:54:52.052
			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:54:52.052
				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=15ms, Records=1) in D:\inetpub\PublicPages\officials.cfm @ 12:54:52.052
		SELECT dist_name FROM fasinfo
	
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:54:52.052
		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:54:52.052
	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:54:52.052
		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:54:52.052
	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:54:52.052
	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:54:52.052
		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:54:52.052
		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:54:52.052
	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:54:52.052
	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:54:52.052
	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:54:52.052
	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:54:52.052
	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:54:52.052
	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:54:52.052
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:54:52.052
	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=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:54:52.052
		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:54:52.052
	SELECT menu_label FROM fas_menu WHERE web_page = '../fas/term_report.cfm'
fasinfo (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
	SELECT * FROM fasinfo
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
	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:54:52.052
	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:54:52.052
	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 @ 12:54:52.052
	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:54:52.113

getRecsCount (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
	SELECT * from getRecs
getRecs2 (Datasource=, Time=0ms, Records=54) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
	SELECT * from getRecs
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
		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=15ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
			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 = 5543 and
				  codes.code_type = 'AG_OFF' AND
				  tt.code_rowid = codes._rowid
		
getAllOfficialRecs (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
			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 = 'Adam' AND
				  tt.lname = 'Shimoni'
		
getMinrecs (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
			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 = 439 
			ORDER BY meeting_dt DESC, meeting_name
		
getVoteTypes (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
		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 @ 12:54:52.052
						SELECT valid_code, fname, lname, term_start, term_end from codes, term_tracker
						WHERE code_type = 'AG_OFF' AND
							  valid_code = 'AS5543' AND
							  code_rowid = codes._rowid
					
getMinrecs (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
							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 = 439 
							ORDER BY meeting_dt DESC, meeting_name
						
getMinLines (Datasource=frsRO, Time=62ms, Records=45) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
								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 = 439
								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:54:52.052
							SELECT DISTINCT ag_area, item_type FROM getMinLines WHERE item_type = 'Y'
						
getAllVotes (Datasource=frsRO, Time=16ms, Records=23) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
							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 = 5543)
							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 = 439 
								AND mlv.valid_code = 'AS5543'
							
							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:54:52.052
						SELECT voteDescr, count(voteDescr) voteCount
						FROM getAllVotes group by voteDescr
					
getType (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
		SELECT * from getVoteTypes WHERE getVoteTypes.descr = 'AYE'
	
getMeetingVoters (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
							SELECT DISTINCT lname, valid_code, descr from getAllVotes
							WHERE form_num = 439
							order by lname
						
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9826
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9830
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9846
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9827
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9837
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9845
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9868
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9868 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9828
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9834
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9869
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9870
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9829
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9851
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9851 
chkLevel1 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9831
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9852
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9852 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9832
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9832 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '9'
					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 @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '9'
					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=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9853
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9833
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9854
											order by motion_seq, seq_num, valid_code
										
getform (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9854 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9855
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9855 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9856
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9856 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9857
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9857 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9858
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9858 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9859
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9859 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '10'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9835
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9836
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9838
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9850
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9848
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9839
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9840
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9860
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9860 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9861
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9861 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '17'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9841
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9867
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9867 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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 @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9862
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9862 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '18'
					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:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9842
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9863
											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:54:52.052
		SELECT meeting_id FROM minutes WHERE form_num = 439 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:54:52.052
		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) = 939

getThisLine (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT * from getMinLines
					WHERE ln_rowid = 9863 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 12:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '19'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '19'
					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:54:52.052
					SELECT a.disp_level
					FROM minutes_ln a
					WHERE a.form_num = 439
					AND a.ag_level1 = '19'
					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 @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9849
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9847
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9864
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9865
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9866
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9843
											order by motion_seq, seq_num, valid_code
										
getMyVotes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\meetingOfficials.cfm @ 12:54:52.052
											SELECT * from getAllVotes WHERE ln_rowid = 9844
											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=439&report=OFFICIAL&rowid=5543&off=AS5543&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=439&report=OFFICIAL&rowid=5543&off=AS5543&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=8630325
cftoken=fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
hitcount=4
lastvisit={ts '2024-03-28 12:54:52'}
timecreated={ts '2024-03-28 12:54:52'}
urltoken=CFID=8630325&CFTOKEN=fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
Cookie Variables:
CFID=8630325
CFTOKEN=fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
Form Fields:
FROMDATE=2018-12-18 00:00:00.0
FROMVOTEDATE={ts '2023-03-28 12:54:52'}
FROMVOTEYEAR=2023
MODE=
TODATE=2022-12-18 00:00:00.0
TOVOTEDATE={ts '2024-03-28 12:54:52'}
Session Variables:
cfid=8630325
cftoken=fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8630325_fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
subdir=/public/
tzoffset=0
urltoken=CFID=8630325&CFTOKEN=fad4fdf1c58adb43-423BE2F0-A4AF-76CB-11699692B8B2E1A3
URL Parameters:
DSP=
FP=
GET_MONTH=8
GET_YEAR=2020
LOC=
LOGIN=
MT=ALL
SSTR=
SUB=
StartRow=1
id=
ln=0
off=AS5543
report=OFFICIAL
rowid=5543
seq=439
Debug Rendering Time: 0 ms