Return
MINUTES
 
HERITAGE PRESERVATION COMMISSION
WEDNESDAY
AUGUST 17, 2022
  COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
             4:00 P.M.

In compliance with the Americans with Disabilities Act, if you need assistance to participate in this meeting, please contact Tammy Bishop 928-213-2611 (or 774-5281 TDD). 
Notification at least 48 hours in advance will enable the City to make reasonable arrangements.


PUBLIC COMMENT PROTOCOL

The meeting recording is available on the city's website
(
https://www.flagstaff.az.gov/1461/Streaming-City-Council-Meetings)


 
             
1.
Call to Order
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the Heritage Preservation Commission and to the general public that, at this regular meeting, the Heritage Preservation Commission may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).

Vice-Chair Emily Dale called the meeting to order at 4:01 PM
             
2. Roll Call
NOTE: One or more Commission Members may be in attendance telephonically or by other technological means.
PRESENT:
EMILY DALE, Vice-Chair
CAITLIN KELLY
CHARLIE WEBBER
SHELLI DEA
ABSENT-EXCUSED
AMY HORN
             
3. LAND ACKNOWLEDGEMENT

The Heritage Preservation Commission humbly acknowledges the ancestral homelands of this area’s Indigenous nations and original stewards. These lands, still inhabited by Native descendants, border mountains sacred to Indigenous peoples. We honor them, their legacies, their traditions, and their continued contributions. We celebrate their past, present, and future generations who will forever know this place as home.

Charlie Webber read land acknowledgement
             
4. Public Comment

At this time, any member of the public may address the Commission on any subject within their jurisdiction that is not scheduled before the Commission on that day. Due to Open Meeting Laws, the Commission cannot discuss or act on items presented during this portion of the agenda. To address the Commission on an item that is on the agenda, please wait for the Chair to call for Public Comment at the time the item is heard.

No public comments
             
5. APPROVAL OF MINUTES
             
A. June 15, 2022 HPC Minutes

Approve the Minutes of the June 15, 2022 Heritage Preservation Commission Meeting.
  Moved by Shelli Dea, seconded by Charlie Webber to approve the Minutes of the June 15, 2022 Heritage Preservation Commission Meeting 
  Vote: 5 - 0
             
B. July 20, 2022 HPC Special Meeting Minutes

Approve the Minutes of the July 20, 2022 Special Meeting of the Heritage Preservation Commission Meeting.
  Moved by Caitlin Kelly, seconded by Shelli Dea to approve the Minutes of the July 20, 2022 Special Meeting of the Heritage Preservation Commission Meeting.
  Vote: 5 - 0
             
6. PUBLIC HEARING
             
A. 309 S Verde Facade Improvement
Address: 309 S Verde St
Assessor's Parcel Number: 10314003B 
Property Owner:  Smith Ila - Scottsdale AZ
Applicant:  Mark Smith
City Staff:  Mark Reavis, Heritage Preservation Officer

Facade Matching Grant for up to $10,000 for continuation of work after removal of aluminum siding, so as to approximate original exterior finish when constructed.
Approve facade grant for up to $10,000 on 50/50 basis per program.


 
 

Mark Reavis: Introduced project and provided brief background. 

Applicant, Mark Smith: Gave additional information about the project 

Emily Dale: Asked whether there are any historic photos of the property? 

Mark Smith: Stated he was not able to find any historic photos of the property. 

Emily Dale: Asked whether there are other homes in the area that would have had a similar façade? 

Mark Reavis: Gave an explanation of what the original façade would have looked like. Stated that this home would have been slightly unique.  

Charlie Webber:  Asked whether the windows had already been replaced? 

Mark Reavis: Confirmed that they had been replaced already. 

  Moved by Shelli Dea, seconded by Caitlin Kelly to Approve a grant of up to a $10,000 to be awarded for façade work at 309 S Verde St with monitoring and approval by the HPO. 
  Vote: 5 - 0
             
B. Ponderosa Pawn & Trading Co Building Facade Grant
Address:  118 W Route 66
Assessor's Parcel Number:  10021005
Property Owner:  Berardi Investment, Joe Beraridi
Applicant:  Anthony Berardi
City Staff: Mark Reavis, Heritage Preservation Officer

Provide a Facade Grant of up to $10,000 for painting and the demolition of a framed awning and new lightweight replacement.
Recommended Motion: Approve a grant of up to a $10,000 to be awarded for façade work at 118 W Route 66 with monitoring and approval by the HPO.


 
 

Mark Reavis: Gave introduction and background on the project. 

Applicant, Anthony Berard: Gave a brief statement about the building and project. 

Mark Reavis: Clarified that the awning color will be earth toned and not the red that is shown in the staff report. 

Emily Dale: Asked whether there are any historic photos of the property? 

Mark Reavis: Stated that the building is largely unchanged since it was built. 

  Moved by Caitlin Kelly, seconded by Charlie Webber to approve a grant of up to a $10,000 to be awarded for façade work at 118 W Route 66 with monitoring and approval by the HPO. 
  Vote: 5 - 0
             
7. GENERAL BUSINESS
             
A. HPC Educational: Historic Home Progression w/ 1901-1948 Sanborn Fire Insurance Maps, example home in North End Historic Residential District.
Listen to HPO presentation, ask questions

Mark Reavis gave a presentation on historic home progression using Sanborn maps. 
             
B. Revisions to Historic Facade & Sign Grant Program
Discussion only
 

Mark Reavis: gave an overview of the grant program history. 

Jordan Hollinger: Provided information about inflation rates over the grant time period. 

Sara Dechter: Asked commission for clarity on desired timeline. 

Commissioners stated that a good timeframe for adjustments to the program would be by next fiscal year. 

Charlie Webber: Asked whether the commission would received an increase in total funding with an increase in grant amounts? 

Sara Dechter: Explained that they are separate and the total amount comes from a budget request. Thinks it would make sense to wait until the commission tries a new grant program and then request additional funds.  

             
C. Selection of new Chair and possibly Vice-Chair
  Commissioners discussed appointment of new Chair and Vice-Chair
  Moved by Shelli Dea, seconded by Caitlin Kelly to appoint Emily Dale as Chair of the Heritage Preservation Commission.
  Vote: 5 - 0
  Moved by Caitlin Kelly, seconded by Shelli Dea to appoint Charlie Webber as Vice-Chair of the Heritage Preservation Commission.
  Vote: 5 - 0
             
8. REPORTS
             
A. APPROVALS
             
1. Butler Ave Lofts
Permit Number(s):  PZ-21-00284-02
Address:  2950 E Butler Ave
Type of Approval: Site Plan Review
Approval Date:  7/27/2022
             
2. Tesla Charging Station - Highway 89
Permit Number(s): PZ-22-00106-01 
Address: 5650 N Highway 89  
Type of Approval: Site Plan Review
Approval Date:  7/27/2022
             
3. Canopy - Multi-tenant, corner Birch & Humphreys
Permit Number(s):  PZ-22-00160
Address:  123 W Birch Ave
Type of Approval: Site Plan Review & Downtown Design Review - Certificate of No Effect
Approval Date:  7/27/2022
             
4. Lake Mary Housing
Permit Number(s):  PZ-21-00213-02
Address:  4631 S Lake Mary Rd
Type of Approval:  Concept Plan Review
Approval Date:  7/7/2022
             
5. Sitgreaves Solar Installation
Permit Number(s):  BP-22-01567
Address:  408 N Sitgreaves St - Non-historic building
Type of Approval:  Townsite Overlay Review -  approved
Approval Date:  7/7/2022
             
6. S Beaver St back porch roof addition - Southside District
Permit Number(s):  BP-22-01566
Address:  316 S Beaver St
Type of Approval:  Historic District Review - no cultural resource study required
Approval Date:  7/7/2022
             
7. Residence by Marriott - Sign Permit - Logo change out
Permit Number(s):  CC-22-01734
Address:  100 N Humphreys St
Type of Approval: Downtown Overlay Review - Certificate of No Effect 
Approval Date:  7/20/2022
             
8. Little America - gas pump canopies
Permit Number(s):  PZ-22-00138-01
Address:  2515 E Butler
Type of Approval:  Site Plan Review
Approval Date:7/27/2022  
             
B. CONSULTATIONS
             
1. Schultz Creek/Pipeline Fire Run Off Basins
Address:  3620 Mt Elden Rd @ corner of Schultz Pass 
Date: 8/3/2022  
             
9. MISCELLANEOUS ITEMS TO/FROM COMMISSION MEMBERS
  Sara Dechter: Suggested a social event for commissioners to thank former Commission Chair, David Hayward for his service on the commission.

Commissioners agreed on a Sept 7 Date.

Sara Dechter: Asked the commission to help recruit for vacant commission seats.

Emily Dale: Asked whether their is a plan to return to in-person meetings.

Sara Dechter: Stated that most commissions have remained virtual.

Commissioners agreed to remain virtual for the time being.
             
10. ADJOURNMENT

Chair Dale adjourned the meeting at 5:09 PM.
CERTIFICATE OF POSTING OF NOTICE

The undersigned hereby certifies that a copy of the foregoing notice was duly posted at Flagstaff City Hall on                      , at                a.m./p.m. This notice has been posted on the City's website and can be downloaded at www.flagstaff.az.gov.

Dated this               day of                                       , 2022.



__________________________________________
Sara Dechter, Comprehensive Planning Manager                                            

    

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

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


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 01-Mar-24 02:02 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
234 ms 234 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
234 ms 234 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
265 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

codesFields (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 02:02:36.036
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=46ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
SELECT fas.form_num fas_form_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
	   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.date_final, fas.final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc,
	   agt.ag_template_name, agt.ag_template_id,
	   codes.long_descr px_size, codes.descr pdf_format, 
	   mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type,
 	   agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place
FROM minutes ft
INNER JOIN fas ON (fas.form_id = 'MINUTES' AND fas.form_num = ft.form_num AND fas.rev_num = ft.rev_num)
INNER JOIN form_hist ON (UPPER(form_hist.form_id) = fas.form_id AND
			UPPER(form_hist.stat_action) = 'ADD' AND
			form_hist.form_num = fas.form_num)
INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
LEFT OUTER JOIN codes crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE ft.meeting_id = 3574 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 02:02:36.036
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3574

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(3574 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3573 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=30) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
SELECT ml._rowid ln_rowid, ml.ln_rowid ml_rowid, ml.form_num, ml.rev_num, ml.seq_num,
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.footer_ln, ml.left_justify, ml.page_br,		
	   c.descr as status_desc,
	   
	   
	   ai.*,
	   
	   am.ag_item_rowid,
	   
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.left_justify,		
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)


LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 3573 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)
LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = 798 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=28) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
	       
				'Y' can_look, 'Y' can_link	
			
			,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid,
			min.minutes_published min_published,
			a.agenda_published ag_published
	FROM minutes min
	INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num)
	INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND
		  							   docs.rev_num = ml.rev_num AND
		  							   docs.ln_rowid = ml._rowid
		  							
		  								AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
		  							)
	LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num)
	WHERE min.form_num = 798 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 798 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
allMotions (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
			   motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 798 AND
			  motion.rev_num = 0 AND
		 	  motion.motion_status <> 'VERBIAGE'
			  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	
allVotes (Datasource=frsRO, Time=16ms, Records=42) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type, c3.long_descr vote_label,
			   v.seq_num sort1,	
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote)
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		WHERE v.form_num = 798 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1							
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17610 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17610 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17609 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17609 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17621 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17621 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17614 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17614 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17618 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17618 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17635 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17635 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3974 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17635 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17635 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17636 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17636 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3975 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17636 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17636 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17612 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17612 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17631 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17631 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11293 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3976 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17631 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17631 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17632 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17632 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11295 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3978 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17632 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17632 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17613 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17613 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17633 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17633 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17634 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17634 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11298 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17637 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17637 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11300 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3979 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17637 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17637 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3980 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 17637 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 17637 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 02:02:36.036
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17617 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17617 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17619 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17619 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17622 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17622 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17623 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17623 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17624 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17624 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17627 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17627 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17628 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17628 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17629 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17629 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17630 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17630 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17625 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17625 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17620 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17620 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17626 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17626 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17615 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17615 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11302 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 17616 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 17616 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 02:02:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:02:36.036
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:02:36.036
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:02:36.036
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 02:02:36.036
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=8&get_year=2022&dsp=min&min=3574&ln=17633
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=8&get_year=2022&dsp=min&min=3574&ln=17633
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=7969234
cftoken=e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
hitcount=4
lastvisit={ts '2024-03-01 02:02:36'}
timecreated={ts '2024-03-01 02:02:36'}
urltoken=CFID=7969234&CFTOKEN=e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
Cookie Variables:
CFID=7969234
CFTOKEN=e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3574
Session Variables:
cfid=7969234
cftoken=e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_7969234_e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
subdir=/public/
tzoffset=0
urltoken=CFID=7969234&CFTOKEN=e6615072d005a4ba-BBDA26F7-CDC6-4811-DC59FC74D9893B39
URL Parameters:
dsp=min
get_month=8
get_year=2022
id=
ln=17633
min=3574
mt=ALL
Debug Rendering Time: 0 ms