Return
MINUTES
 
HERITAGE PRESERVATION COMMISSION
WEDNESDAY
JANUARY 18, 2023
  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.


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 Emily Dale 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.
EMILY DALE,Chair
SHELLI DEA, Vice Chair
DUFFIE WESTHEIMER
AMY HORN
ABBEY BUCKHAM
CAITLIN KELLY
BERNADETTE BURCHAM
  PRESENT:
EMILY DALE, Chair
SHELLI DEA, Vice-Chair
DUFFIE WESTHEIMER
AMY HORN
ABBEY BUCKHAM

ABSENT-EXCUSED
CAITLIN KELLY
BERNADETTE BURCHAM
             
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.
  Commissioner Westheimer read the City of Flagstaff 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 comment
             
5. APPROVAL OF MINUTES
Approve the Minutes of the December 21, 2022, Heritage Preservation Commission Meeting.
  Moved by Duffie Westheimer, seconded by Shelli Dea to approve the Minutes of the December 21, 2022, Heritage Preservation Commission Meeting
  Vote: 5 - 0
             
A. Attachments to the Minutes
NA
             
6. PUBLIC HEARING
             
A. 3 E Aspen Facade Rehabilitation - Yogaert Shop
Address:  3 E Aspen (Building Addresses: 1.3.5,9, 11 & Suites 7 Upstairs 1-12 
Assessor's Parcel Number:  10020013
Property Owner:  Mary Velasco
Applicant: Samantha DeWarf 
City Staff:  MR HPO

Approve a Facade Grant for a maximum participation of up to $10,000 in our 50/50 Grant Program for Facade rehabilitation at 3 E Aspen only, a historic building with multiple addressed storefronts.
Approve the allocation of up to a $10,000 Facade Grant 50/50 match for Facade restoration work at 3 E Aspen that fully meets the US Secretary of the Interior Standards for Rehabilitation and accompanying guidelines, confirming all work prior to commencing with Flagstaff's HPO in reviewing the work as a Certificate of No Effect. The 3 E Aspen facade retains an rare example of Luxfer prizm glass 4"x4" leaded/zinc came storefront transom in significant need of repair and preservation. Only a few examples remain in place in Flagstaff.
Request a more complete and detailed architectural submission for review by the Commission or the Heritage Preservation Officer.
With the exception of some sign permits no HPC reviews.
 
  Mark Reavis: gave a brief overview of the project and the unique qualities of the glass that the project would preserve. Mark also explained that he and the applicant had worked quickly to put together an application but that the application ended up being incomplete and a vote on the grant would have to be postponed.

Sara Dechter: asked Mark to clarify whether the project is being continued or not.

Mark Reavis: clarified that the grant application will come back to the commission at a later date.

Duffie Westheimer: asked Mark to explain how the project came about and ended up coming before the Heritage Preservation Commission - did they request a grant or did Mark do outreach to the owners?

Mark Reavis: explained that the owners applied for a sign permit and, through that process, let the owners know about the grant.

Emily Dale: asked for clarification on whether the commission needs to vote on postponing the item.

Sara Dechter: clarified that the commission could either vote to postpone the item to a date certain or postpone the item to an uncertain future date with a condition.

 
  Moved by Amy Horn, seconded by Abbey Buckham to postpone agenda item 6A, 3 E Aspen Façade Rehab Grant, until the Heritage Preservation Officer is ready to re-agendize the item.
  Vote: 5 - 0
             
7. GENERAL BUSINESS
             
A. Resumption of Hybrid Commission Meetings
Discussion of when and how to resume in-person elements of the Commission Meetings, including location, public protocols, and any logistics.
  Sara Dechter: explained that the commission is now able to revert to hybrid meetings with in-person and online attendance. There are two options for meeting locations, including the conference room and council chambers. A few questions that the commission should answer:
  • How do you want to resume?
  • How many commissioners want to attend in person?
  • Which room would commission members like to use?
Commissioners indicating that they would like to attend in person when possible:
Emily Dale
Amy Horn
Duffie Westheimer
Abbey Buckham
Caitlin Kelly - Although absent, notified Sara Dechter, that she is in favor of being able to attend meetings in person.

Shelli Dea noted that she is unable to attend in person.

Commissioners indicated that they would like to move forward with using the conference room for meetings with a desire to reassess should public attendance increase and make space an issue.
 
             
B. Facade and Sign Grant - Proposed Revisions
The Heritage Preservation Officer recommends a 2-tier approach in revising the Historic Facade and Sign Grant Program. Tier 1 would be to retain the $10,000 participation cap as the incentive for small preservation projects intended for use in reversing non-historic modification and general preservation and improvement work. Tier 2 would be to provide an additional $10,000 match for exceptional preservation projects that are in full compliance with the US Secretary of the Interior's Standards for Rehabilitation and accompanying Guidelines.  
  Mark Reavis: Gave a presentation that outlined the various components of the grant program and possible changes that could be made. During the presentation, Mark referenced the inflation memo (attached to the agenda item) that used three indices to show the diminishing value of $10,000 over time as a rationale for considering a change to the grant amount.

Mark Reavis: Outlined options for changing and potentially increasing the grant amount using a tiered grant approach.

Sara Dechter: Gave some examples of where a tiered approach could help with more significant projects.

Duffie Westheimer: Asked whether the money that isn’t spent on projects is carried forward to the following year.

Sara Dechter: Explained that unspent money goes back to the general fund.

Duffie Westheimer: Expressed that she would prefer that changes to the grant program not be too onerous for general residents. The commission shouldn't turn people off of the grant.

Emily Dale: Asked for clarification on whether properties or residents that have already received a grant can get another one.

Mark Reavis and Sara Dechter: Explained that the grant application states that the commission will not consider properties that have already received a grant.

Emily Dale: Expressed that it felt a little strange to allow a single resident/entity to get grants for multiple properties but that a new property owner couldn't get a grant for their property if it had received one under a different owner.

Sara Dechter: Explained that the important thing to do during the meeting is to determine the direction for the grant amount so that she can take an updated BBB funding request to Economic Vitality during the current budget cycle.

Commissioners agreed that regardless of the change that they would like to ensure the capacity to still fund a minimum of 10 projects each year.

Sara Dechter: Explained the three options that the commission could move forward with:

1) Mark's tiered grant approach, 2) Lowering the applicant match percentage, 3) Raise the amount for all projects

Emily Dale: Asked how the tiers would be determined and who would ensure a project met a certain tier.

Mark Reavis: Suggested that higher tier projects would have to have strict adherence to the Secretary of Interior standards.

Sara Dechter: Clarified that the commission just needs to give staff a general direction and that the detail of the program changes can be determined at a later date.

Commissioners generally agreed that it would be advantageous to increase the potential grant funds that an applicant could apply for.

Commissioners gave staff the direction to proceed with a tiered approach and to request additional funds for the program.

Sara Dechter: Stated that she would request $160,000 for the program.
 
  Mark Reavis: Continued his presentation, focusing on the grant application and possible changes that the commission could make.

Application/Program Title
Commissioners agreed to change the name of the application from Historic Facades and Signs to Historic Signs and Facades.

Images on the application
Commissioners agreed that it would be better to include images that reflect actual projects that the grant program has funded.

Eligibility Criteria Language
  • Who may apply: Mark Reavis asked if the commission would like to see a clarification to "Other." Commissioners generally felt that it was okay and beneficial to have something that captured uncertainty in potential applicants.
  • Commission Will Consider: Mark Reavis asked if the commission would like to have more formal process for evaluating whether applicants have met the considerations. 
  • Commission Will Not Consider: Mark Reavis asked whether the commission would like to clarify any of the language.
    • Emily Dale: Expressed that it feels strange that a property can’t have more than one grant but a person could get grants for more than one property. Asked whether the statement "as determined by the commission" could be added to "extraordinary circumstances."
    • Sara Dechter: Explained that once a property gets a grant it is not eligible for 10 years, but a person or org could get one for another property.
    • Commissioners discussed whether it would be beneficial to reduce the eligibility time frame for properties that have previously received a grant, generally settling on 5 years.
    • Shelli Dea: Asked for clarification on the circumstances that would lead to multiple grants.
    • Emily Dale: Suggested that multiple facade elements, such as windows then a porch, could fall under this category.
  • BBB Funding language
    • Mark Reavis asked if the commission would like to see some additional explanation about the funding mechanism and the purpose of BBB tax.
    • Abbey Buckham: Asked whether it is a tourism tax.
    • Sara Dechter: Explained that it is, in part, a tourism tax, but that residents also pay it when they go out to eat etc.
    • Amy Horn: Asked if staff could look at the Beautification and Public Art Commission grant language and see how they have explained the purpose of BBB funds.


 
             
8. REPORTS
             
A. APPROVALS
  Mark Reavis: Briefly covered the four signs that were brought to the commission and asked whether the commission would like to see all signs that come to him that are in the Central Sign District or just those that are in the Central Sign District and the Downtown Historic District.

Duffie Westheimer: Asked that the commission still get to see sign approvals in the Historic District but also asked that Mark include pictures in the agenda items.
             
1. Wee Scotty Sign
Permit Number(s):  CC-23-00051
Address: 13 N San Francisco St STE 204 
Type of Approval:  Permanent Sign - Central Sign District Design Review
Approval Date:  1/10/2023
             
2. Beaver Street Liquor Sign
Permit Number(s):  CC-22-03530
Address:  824 N Beaver Street
Type of Approval: Permanent Sign - Central Sign District Sign Review 
Approval Date:  1/10/2023
             
3. Foram (bar) Sign
Permit Number(s):  CC-23-00026
Address:  30 S San Francisco
Type of Approval: Permanent Sign - Central Sign District Design Review
Approval Date:  1/10/2023
             
4. Arizona Community Foundation Sign
Permit Number(s):  CC-23-00022
Address:  225 N Leroux Street
Type of Approval:  Permanent Sign - Central Sign District Design Review
Approval Date:  1/10/2023
             
B. CONSULTATIONS
             
9. MISCELLANEOUS ITEMS TO/FROM COMMISSION MEMBERS
  Duffie Westheimer: Asked whether the commission is able to do a review of minutes prior to the commission meeting, noting some grammatical errors in the prior meeting's minutes.

Sara Dechter: Stated that the meeting video and minutes are usually posted within 24 hours of the meeting and are available on the city's agenda publishing website. Commissioners can review and send edits to staff up until the following meeting's agenda has been published. 

Link to agenda platform: https://agenda.flagstaffaz.gov/agenda_publish.cfm
             
10. ADJOURNMENT
  Chair Emily Dale adjourned the meeting at 5:55 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                                       , 2023.



__________________________________________
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 18-Apr-24 01:07 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
141 ms 141 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
94 ms 94 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
94 ms 94 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/Application.cfm
32 ms 16 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
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
188 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:07:57.057
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:07:57.057
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:07:57.057
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:07:57.057
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 01:07:57.057
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 01:07:57.057
	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 @ 01:07:57.057
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=31ms, Records=18) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:07:57.057
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2023-01-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-01-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:07:57.057
			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(3676 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 @ 01:07:57.057
	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 @ 01:07:57.057
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3675 
getAllMnLines (Datasource=frsRO, Time=16ms, Records=22) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
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 = 3675 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 = 849 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=20) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
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 @ 01:07:57.057
	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 @ 01:07:57.057
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
		
	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 = 849 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=22) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 849 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=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
		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 = 849 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=0ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
		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 = 849 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1							
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18454 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18454 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11770 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18453 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18453 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11772 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18465 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18465 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11774 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18458 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18458 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11776 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18462 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18462 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			    	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 = 4105 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 18462 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 18462 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:07:57.057
	
		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 @ 01:07:57.057
				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 @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18473 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18473 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18456 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18456 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18471 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18471 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11779 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			    	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 = 4106 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 18471 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 18471 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:07:57.057
	
		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 @ 01:07:57.057
				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 @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18457 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18457 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18472 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18472 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11781 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18470 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18470 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11783 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11784 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18461 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18461 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18463 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18463 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11786 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18466 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18466 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18467 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18467 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18468 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18468 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18469 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18469 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18464 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18464 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18459 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18459 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11788 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18460 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 18460 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:07:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11790 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:07:57.057
	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 @ 01:07:57.057
	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 @ 01:07:57.057
		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 @ 01:07:57.057
		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=1&get_year=2023&dsp=min&min=3676&ln=18469
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=1&get_year=2023&dsp=min&min=3676&ln=18469
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=9102614
cftoken=a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
hitcount=4
lastvisit={ts '2024-04-18 01:07:57'}
timecreated={ts '2024-04-18 01:07:57'}
urltoken=CFID=9102614&CFTOKEN=a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
Cookie Variables:
CFID=9102614
CFTOKEN=a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3676
Session Variables:
cfid=9102614
cftoken=a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9102614_a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
subdir=/public/
tzoffset=0
urltoken=CFID=9102614&CFTOKEN=a3c273b52b12751f-6257645F-D0E5-1298-5D890793732128C5
URL Parameters:
dsp=min
get_month=1
get_year=2023
id=
ln=18469
min=3676
mt=ALL
Debug Rendering Time: 16 ms