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


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).

Chair Hayward called the meeting to order at 4:03 PM
             
2. Roll Call
NOTE: One or more Commission Members may be in attendance telephonically or by other technological means.
 

PRESENT: 
DAVID HAYWARD, Chair 
EMILY DALE, Vice Chair 
AMY HORN 
CAITLIN KELLY 
SHELLI DEA 
 
ABSENT- EXCUSED: 
CHARLES WEBBER 

             
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.

Emily Dale 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.
  Duffie Westheimer – Resident of Townsite, offered the commission a historic tour of the Townsite neighborhood. 
             
5. APPROVAL OF MINUTES
Approve the Minutes of the May 18, 2022 Heritage Preservation Commission Meeting.
  Moved by Emily Dale, seconded by Caitlin Kelly to approve the Minutes of the May 18, 2022 Heritage Preservation Commission Meeting.
  Vote: 5 - 0
             
6. PUBLIC HEARING
             
A. 803 W Aspen Ave -Certificate of Appropriateness  
Address:  803 W Aspen Ave.
Assessor's Parcel Number:  100-24-019
Property Owner:  Greg & Robin Hadden
Applicant:  Karl Eberhard, Architect representing the Haddens
City Staff:  Mark Reavis, HPO

Certificate of Appropriateness of demolition of primary home and a new replacement primary home to meet Townsite Overlay design review requirements.
Approve a Certificate of Appropriateness with conditions per Recommended Motion (see Staff Report)
The commission may add additional requirements for design of the structure based on the Townsite design review compliance.
A Letter Report Cultural Resource Study for the property was prepared by Envirosystems and approved by the Heritage Preservation Officer in 2015 (see attached).
 
  Mark Reavis: Gave brief overview and introduction of the project. 

David Hayward: Clarified that comments are to be read by the commenter if they are present. 

Mark Reavis: Provided clarity on how the townsite standards and guidelines are to be used in decision making. 

Karl Eberhard, Project Architect: Gave a presentation about the project, including a 3d rendering model of the home. Stated that based on some of the concerns about privacy on the upper deck, they changed the railing to have less visibility. 

Emily Dale: Asked for clarity about the timeline for the project. 

Karl Eberhard: Stated that the project location initially came through in 2016 with a different proposal to do an addition to the existing building. 

Greg Hadden, Owner: Noted that he was on the call and could also answer questions. 

Mark Reavis: Clarified that the former submission included a cultural resource study that concluded the existing structure was non-contributing. 

Karl Eberhard: Stated that he believed the HPC even looked at some preliminary designs. 

Greg Hadden: Stated that they had a different idea at that time and did not move forward with it. 

David Hayward: Invited public comment. 

Duffie Westheimer: Provided public comment, raising concerns about the mass and scale of the proposed structure. 

Ellen Ryan, neighboring property owner: Provided public comment, raising concerns mass, scale of new building, and possible damage to their property. Also raised concerns about privacy related to the upper deck and patio area. 

David Ryan, neighboring property owner: provided public comment, raising concerns about the new structure. 

Mark Reavis: Clarified the design overlay guidelines and standards, and that the commission is not looking at the zoning elements outside of that overlay. 

David Hayward: Echoed Mark’s comment and stated that the commission does not make decisions based on the zoning elements outside of the overlay. 

Asked Mark to clarify the massing and scal requirements. 

Mark Reavis: Stated that the standards include height and open space. 

Amy Horn: Asked whether the project would come back to the commission if city planning asks for changes? 

Mark Reavis: Noted that it would not come back unless there were substantive changes to the design. 

Emily Dale: Asked Mark to clarify the requested action. 

Mark Reavis: The motion is general but relying on commission for specifics to add to the motion. 

Karl Eberhard: Noted that they have already made several privacy considerations and that privacy is also context specific and that this is an urban setting where buildings are closer together. 

Caitlin Kelly: Was the second floor porch considered for the front. 

Karl Eberhard: Yes, but it was too far out into the street. 

Caitlin Kelly: Noted that some other homes on street have front facing porches. Also noted that privacy in urban lots is limited. 

David Hayward: Specified that the only actionable item in terms of massing and size is the height and open space requirements. This property meets the specified guidelines. 

Stated that the second story porch is potentially problematic in terms of privacy, but there is no standard in the overlay that regulates that. 

Reticent to impose condition that architect continues to work with Mark. 

Karl Eberhard: Offered three concessions 

Remove upper window 

Stained or translucent glass 

Upper deck has been addressed with less transparent railing type. 

David Hayward: Asked Mark about condition to increase fence height. 

Karl Eberhard: Stated that the patio is elevated slightly, but unsure of exact height at this time. Open to pulling back retaining wall or raising fence height. 
  Moved by David Hayward, seconded by Amy Horn To approve the certificate of appropriateness with the conditions: 
  • Smaller window on the west elevation will be removed or replaced with opaque glass or something similar. 
  • The window in the stairwell will also be made opaque or some other similar treatment. 
  • The slats on the second story deck will be designed as shown in this presentation. 
  • Request to planning and zoning to allow a taller fence in the side patio. 
  Vote: 5 - 0
             
B. Nativity of Blessed Virgin Mary Chapel
Address:  16 W Cherry
Assessor's Parcel Number:  101-13-008A
Property Owner:  Bishop of the Roman Catholic Church of the Diocese of Phoenix
Applicant:  Roberta Wallace
City Staff:  Mark Reavis, HPO

A Facade Grant request of $10,000 match for a $26,816 historic preservation project consisting of stained glass restoration and critical tower inspection of exterior.
Approve a $10,000 grant for stained glass restoration and protection of the tower.
 
  Mark Reavis: Gave a brief introduction to project. 

Roberta Wallace, applicant: gave presentation about the project, including recent findings about decorative stone replacement. 

David Hayward: Expressed gratitude for the hard work on this project and will happily vote for the grant. 

Amy Horn: What is the limit to the grant and what is the typical amount? 

Mark Reavis: Limit is $10,000 and it is a matching grant with $100,000 annual budget allocation. 
  Moved by Shelli Dea, seconded by Caitlin Kelly To approve the $10,000 grant for stained glass restoration and protection of the tower. 
  Vote: 5 - 0
             
C. Cortland Lofts - Phase 3 Cultural Resource Study 
Address:  5531 E Cortland Blv.
Assessor's Parcel Number:  113-37-001E
Property Owner:  Mongini & Selna Childrens Irrevocable Living Trust - Miramonte, Developer.
Applicant:  Mogollon Engineering - Cornerstone Environmental, consultant.
City Staff: Mark Reavis, HPO  

Acceptance of a Phase 3 Cultural Resource Survey with full artifact recovery as performed, with pending dating test to be included later as an addendum. 
Accept Phase 3 Cultural Resource Survey with conditions of:
  • recommended excavator training and periodic site monitoring by consultant
  • Pending test results and evaluation of data to be added as an addendum.
Finding: Current submissions, data recovery with excavator training and monitoring is sufficient for the issuance of a construction permit.

The Commission has been kept up to date on this process through the Consultations section of previous agendas.
 
  Mark Reavis: Gave brief background on the project. 

Caitlin Stewart, Cornerstone Environmental: Gave a presentation on the project and phase 3 findings. 

Shell Dea: Asked whether structures like those found would typically be found alone? 

Caitlin Stewart: Explained that they are often found alone if it was used as a fieldhouse. 

David Hayward: Asked for clarity on what a fieldhouse is and whether there is evidence that the area was used for agriculture. 

Caitlin Steward: Explained that a fieldhouse would have been a structure close to agricultural activity and that this area was known to house agriculture activities. 

Emily Dale: Asked whether the recommendation is to follow Phoenix monitoring protocols because flagstaff does not have their own. 

Caitlin Steward: Confirmed that is the case. 

David Hayward: Asked whether the commission is permitted to condition acceptance on continual monitoring. 

Mark Reavis: Stated that yes, the commission has that authority. 

Amy Horn: Complemented cornerstone on their treatment of the site. 

Shelli Dea: Asked for clarity on implementing the Phoenix Protocols. 

Caitlin Steward: Explained that the monitoring plan provides process for inadvertent discoveries. 
  Moved by Shelli Dea, seconded by Emily Dale to accept the phase 3 cultural resource survey with the conditions that: 
  • there is an addendum to the report once additional dendrochronology, pollen wash, and artifact analysis are complete. 
  • Cultural resource and awareness training for all construction personnel. 
  • Once a week spot monitoring of the construction to assess and document any additional cultural material that may be present. 
    • Application of the city of Phoenix Monitoring and Discovery Plan for inadvertent discoveries. 
  Vote: 5 - 0
             
7. REPORTS
             
A. APPROVALS
             
1. Re-stucco 7 N San Francisco
Permit Number(s):  PZ-22-00090
Address:  7 N San Francisco
Type of Approval:  Certificate of No Effect
Approval Date:  5/18/2022
             
2. E Butler Ave Multi Family Development
Permit Number(s):  PZ-21-00284-01 
Address:  2950 E Butler Ave
Type of Approval:  Cultural Resource Letter report
Approval Date:  5/18/2022
             
3. 9 N Leroux
Permit Number(s):  PZ-22-00088-01
Address:  9 N Leroux  
Type of Approval:  Concept Plan
Approval Date:  5/24/2022
             
4. Home 2 Suites - Motel Development
Permit Number(s):  PZ-22-00043-02
Address:  3451 S Lake Mary Rd 
Type of Approval:  Cultural Resource Letter report
Approval Date:  5/24/2022
             
8. MISCELLANEOUS ITEMS TO/FROM COMMISSION MEMBERS
  Amy Horn: Asked about the return to hybrid meeting format. 

Mark Reavis: Stated that we will be following the advice of the city managers office. 

David Hayward: Added that the ability to attend remotely will remain regardless. 

David Hayward: Requested that Mark look into the $10,000 grant limit and what inflation has looked like since then. Would it be possible to increase the amount at some point. 

Mark Reavis: Agreed to look into it. 

Shelli Dea: How does overlay language get changed? 

David Hayward: There is some allocation to work on overlay code sections, but it requires a lot of work and public outreach. 

Mark Reavis: Expressed that it would be helpful to have a townsite overlay cheat sheet. 

David Hayward: Agreed that something like that would be helpful. 
             
9. ADJOURNMENT
  Chair Hayward adjourned the meeting at 5:46PM
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 29-Feb-24 11:44 PM
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
287 ms 287 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
255 ms 255 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
255 ms 255 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.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
302 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 @ 23:44:26.026
			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 @ 23:44:26.026
				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 @ 23:44:26.026
			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 @ 23:44:26.026
				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 @ 23:44:26.026
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 23:44:26.026
	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 @ 23:44:26.026
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:44:26.026
		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 @ 23:44:26.026
	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 @ 23:44:26.026
		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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
		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=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:44:26.026
		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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:44:26.026
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=22) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 23:44:26.026
		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-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2022-06-30 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:44:26.026
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=82ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
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 = 3558 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:44:26.026
		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) = 3558

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:44:26.026
			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(3558 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 @ 23:44:26.026
	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 @ 23:44:26.026
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3557 
getAllMnLines (Datasource=frsRO, Time=48ms, Records=19) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
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 = 3557 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 = 767 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
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 @ 23:44:26.026
	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 @ 23:44:26.026
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
		
	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 = 767 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 @ 23:44:26.026
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 767 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=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
		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 = 767 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=28) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
		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 = 767 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 @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16864 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16864 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16863 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16863 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10921 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16873 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16873 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16867 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16867 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10923 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16871 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16871 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			    	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 = 3736 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16871 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16871 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:44:26.026
	
		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 @ 23:44:26.026
				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 @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16866 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16866 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16874 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16874 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10926 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			    	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 = 3737 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16874 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16874 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:44:26.026
	
		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 @ 23:44:26.026
				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 @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16875 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16875 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10928 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			    	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 = 3738 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16875 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16875 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:44:26.026
	
		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 @ 23:44:26.026
				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 @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16880 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16880 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10930 
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			    	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 = 3739 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16880 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16880 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 23:44:26.026
	
		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 @ 23:44:26.026
				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 @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16870 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16870 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16872 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16872 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16876 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16876 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16877 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16877 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16878 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16878 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16879 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16879 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16868 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16868 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10932 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16869 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16869 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 23:44:26.026
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10934 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 23:44:26.026
	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 @ 23:44:26.026
	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 @ 23:44:26.026
		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 @ 23:44:26.026
		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=6&get_year=2022&dsp=min&seq=3558
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=6&get_year=2022&dsp=min&seq=3558
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=7966797
cftoken=eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
hitcount=4
lastvisit={ts '2024-02-29 23:44:26'}
timecreated={ts '2024-02-29 23:44:26'}
urltoken=CFID=7966797&CFTOKEN=eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
Cookie Variables:
CFID=7966797
CFTOKEN=eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3558
Session Variables:
cfid=7966797
cftoken=eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_7966797_eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
subdir=/public/
tzoffset=0
urltoken=CFID=7966797&CFTOKEN=eef86a85082eb051-B6E93DBA-C37B-513D-2A7EAF7EF3E6EA01
URL Parameters:
dsp=min
get_month=6
get_year=2022
id=
mt=ALL
seq=3558
Debug Rendering Time: 0 ms