DOWNLOAD PDF PACKET PRINT AGENDA

RETURN TO THE SEARCH PAGE

NOTICE AND AGENDA
 
SUSTAINABILITY COMMISSION

THURSDAY
August 24, 2023

 
  HYBRID MEETING
STAFF CONFERENCE ROOM
AND MICROSOFT TEAMS
211 WEST ASPEN AVENUE
             4:30 P.M.
 

Vision: The City of Flagstaff is a culture and community that thrives in response to the Climate Crisis. 

Mission: To advise Sustainability Division Staff on matters related to climate and sustainability, support community projects through Neighborhood Sustainability Grants, and provide feedback to the City Council on sustainability issues. 

Members of the public may join the meeting online, via Microsoft Teams. 

  • Click on this link to join the meeting, at 4:30 pm on 8/24/25: 
  • Join Microsoft Teams Meeting 
  • To comment on a discussion item, please use the Teams Chat function: simply type in ‘public comment’ to indicate to the Chair that you would like to comment. The Chair will then recognize you when it is time for public comment, and staff will unmute your microphone if needed. 
  • Public comments may be sent in advance of the meeting to tia.hatton@flagstaffaz.gov. Public comments should be limited to three minutes of reading time. 
 
             
1.   Call to Order
 
2.  
ROLL CALL
 
NOTE: One or more Commissioner may be in attendance through other technological means.
 
Chair Kevin White
Commissioner Priscilla Boateng
Commissioner Kristen Konkel
Commissioner Molly McCormick
 
Commissioner Mary Ellen Metzger
Commissioner Dorcas Naa Aku Shika Quarshie
Commissioner Amy Wolkowinsky

 
 
3.   Land Acknowledgment
The Sustainability 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.
 
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 use the Teams Chat function: simply type in "public comment" to indicate to the Chair that you would like to comment. The Chair will then recognize you when it is time for public comment, and staff will unmute your microphone if needed. 
 
5.   Approval of July Minutes (5 minutes) Click this link to view Agenda Item
 
6.   Business
 
a.   Welcome & Introductions (10 minutes) Click this link to view Agenda Item
 
 
All
Recommended Action: Informational
 
b.   Sustainability Division Updates (10 minutes) Click this link to view Agenda Item
 
 
Tia Hatton
Recommended Action: Informational
 
c.   Post-Fire Revegetation Efforts Presentation and Q&A (40 minutes) Click this link to view Agenda Item
 
 
Mark Nabel, Silviculturist - USFS Coconino National Forest
Recommended Action: Informational and Discussion
 
d.   Neighborhood Sustainability Grants: Overview of Staff/Division Updates, Review Timeline, & Q&A (30 minutes) Click this link to view Agenda Item
 
 
Tia Hatton and Chair White
Requested Action: Informational and Vote on Additional Updates
 
 
e.   Vice Chair Election (10 minutes) Click this link to view Agenda Item
 
 
Chair Kevin White
Requested Action: Vote
 
f.   Adopt-An-Avenue: Commission Avenue, Alternatives, & Schedule Clean-Up (10 minutes) Click this link to view Agenda Item
 
 
Chair Kevin White and Nicole Antonopoulos 
Requested Action: Discussion and Possible Vote (?)
 
7.   To and From (5 minutes) - All
 
8.   Future Agenda Item Requests
 
9.   Adjournment
 
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.


__________________________________________
Tia Hatton, Sustainability Coordinator                                          

    

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 22-Apr-24 10:19 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
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
162 ms 162 ms 1 D:/inetpub/PublicPages/public/publish/agpub_ag_dsp.cfm
162 ms 162 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
63 ms 9 ms 7 D:/inetpub/PublicPages/public/publish/print_agenda_ud_load.cfm
46 ms 3 ms 15 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
42 ms 42 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgLines(3829) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
6 ms 6 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgenda(3829, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | fGetAGPaddingOptions([complex value], YES, AGPad) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/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 14 D:/inetpub/PublicPages/public/publish/clean_subject.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 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 @ 22:19:38.038
			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 @ 22:19:38.038
				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 @ 22:19:38.038
			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 @ 22:19:38.038
				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 @ 22:19:38.038
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 22:19:38.038
	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 @ 22:19:38.038
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 22:19:38.038
		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 @ 22:19:38.038
	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 @ 22:19:38.038
		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 @ 22:19:38.038
	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 @ 22:19:38.038
	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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 22:19:38.038
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 22:19:38.038
		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 @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 22:19:38.038
	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=26ms, Records=14) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 22:19:38.038
		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-08-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-08-31 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 22:19:38.038
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=6ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:19:38.038
	SELECT fas.form_num fas_form_num, fas.rev_num fas_rev_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.final_stop fas_final_stop,
		   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date, fas.form_num ag_num,
		   ft.* ,
		   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id, mt.meeting_type,
		   agt.ag_template_name, agt.ag_template_id, agt.ag_item_rowid, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   form_hist.stat_date as bo_date,
	 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo,
	 	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold
	 	   
	 	   	, c1.misc_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, 
	 	   	  c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all
	 	   
	 	   ,c2.misc_alpha2 level_descriptor, c3.descr custom_print_routine_name
	FROM fas
	INNER JOIN agenda AS ft ON (ft.form_num = fas.form_num)
	INNER JOIN form_hist ON (form_hist.form_id = fas.form_id AND
				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 AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = m.meeting_id)	
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = m.the_meeting_type)
	LEFT OUTER JOIN codes AS c3 ON (c3._rowid = ft.custom_print_routine)
	WHERE fas.form_id = 'AGENDA' AND
		  fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3829

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:19:38.038
			select c.misc_alpha aHead_pad, c.misc_alpha2 aBody_pad, c.misc_alpha3 aAGItems_pad
			from codes c 
			where c.code_type = ? and 
			     c.valid_code = CAST(3830 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGPad

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 22:19:38.038
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3830

checkField (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:19:38.038
		SELECT * from agenda_ln WHERE _rowid > 1 and _rowid < 5
	
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:19:38.038
		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3829

qryResults (Datasource=frsRO, Time=16ms, Records=17) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:19:38.038
	SELECT al._rowid ln_rowid, al.form_num, al.seq_num,  al.alt_ai_num, 
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.header_ln, al.footer_ln, al.page_br,	
		   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level,
		   al.video_link,
		   ai.*,

		   am.ag_item_rowid, am.prt_exp_agenda, am.submitted_for, am.submitted_for_more, c1.descr ag_time_descr,
		   CASE WHEN al.header_ln = 'Y' THEN 1
		   		WHEN al.footer_ln = 'Y' THEN 3
		   		ELSE 2 END AS line_sort,
		   
		   as1.sort_seq sort_level1,
		   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
		   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
		   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,	
		   
		   CASE WHEN al.alt_ai_num IS NOT NULL then al.alt_ai_num 
		   		WHEN am.ainumber = '' then '-1'
				WHEN am.ainumber = '0' then '-1'
				WHEN am.ainumber IS NULL then '-1'
		   ELSE am.ainumber END AS sort_memo2,		   
		   
		   al.ag_size, al.ag_font, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
		   am.allow_comment, am.ainumber, al.ag_memo_id, al.ag_memo_rev, al.ag_line_status, c.descr status_desc, al.ag_subject, al.ag_title ag_heading,
		   al.left_justify, al.color_impact,
		   al.ag_area, aa.descr ag_area_desc, al.ag_subarea, asa.descr ag_subarea_desc, 
		   codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,	   
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_action ELSE al.ag_action END as ag_action,
		   fu1.text_value skipAIprint
	FROM agenda_ln al
	INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
	INNER JOIN meetings m ON (m.meeting_id = a.meeting_id)	
	LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
	
	LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = al.form_num AND ai._rowid = am.ag_item_rowid)
	
	LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = m.the_meeting_type AND aa.ag_area = al.ag_area and aa.obsolete <> 'Y')          
	LEFT OUTER JOIN area_subarea AS asa ON (asa.meeting_type = m.the_meeting_type AND asa.ag_area = al.ag_area and asa.ag_subarea = al.ag_subarea and asa.obsolete <> 'Y')
	LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = al.ag_line_status)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = al.ag_size)
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
	LEFT OUTER JOIN form_userdef AS fu1 ON (fu1.form_id = 'AG_MEMO' AND fu1.form_num = al.ag_memo_id AND fu1.rev_num = al.ag_memo_rev AND fu1.fld_label = 'Skip Printing AB#' and fu1.text_value = 'Y')
	
	LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = al.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(al.ag_level1 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = al.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(al.ag_level2 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = al.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(al.ag_level3 AS binary(8)))
	LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = al.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(al.ag_level4 AS binary(8)))
	WHERE al.form_num = ?
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3829

getAgHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
	select * from getAgLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgLines (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
	select * from getAgLines where header_ln <> 'Y' and footer_ln <> 'Y'
	order by line_sort, sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
getAILines (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
	select ln_rowid, ag_memo_id, ag_memo_rev, ag_item_rowid from getAgLines where ag_memo_id IS NOT NULL
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7411 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7411 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7412 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7412 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7413 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7413 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7414 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7414 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7416 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7416 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7417 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7417 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
			SELECT _rowid, seq_num, text_value
			FROM ag_memo_item
			WHERE form_num = 7418 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
			ORDER BY seq_num
			
getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:19:38.038
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 110 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 7418 AND
			rev_num = 0
		order by au.seq_num
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
getForm (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_ag_dsp.cfm @ 22:19:38.038
		SELECT * from getagenda
	
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:19:38.038
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 22:19:38.038
	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 @ 22:19:38.038
	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 @ 22:19:38.038
		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 @ 22:19:38.038
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=8&get_year=2023&dsp=ag&seq=3829
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=8&get_year=2023&dsp=ag&seq=3829
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=9219592
cftoken=69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
hitcount=4
lastvisit={ts '2024-04-22 22:19:38'}
timecreated={ts '2024-04-22 22:19:38'}
urltoken=CFID=9219592&CFTOKEN=69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
Cookie Variables:
CFID=9219592
CFTOKEN=69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=3829
Session Variables:
ailist=Query (7)
cfid=9219592
cftoken=69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9219592_69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
subdir=/public/
tzoffset=0
urltoken=CFID=9219592&CFTOKEN=69954e5d1dac6905-5DCB2A1B-93A9-7291-C890519339575EB7
URL Parameters:
dsp=ag
get_month=8
get_year=2023
id=
mt=ALL
seq=3829
Debug Rendering Time: 16 ms