WORK SESSION AGENDA
 
CITY COUNCIL WORK SESSION
TUESDAY
AUGUST 29, 2017
  COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
             
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 City Council and to the general public that, at this work session, the City Council 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).
 
2. Pledge of Allegiance and Mission Statement
 
MISSION STATEMENT
 
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
 
3. Roll Call
 
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
 
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
 
4.
Preliminary Review of Draft Agenda for the September 5, 2017, City Council Meeting.*
 
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.
 
5. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.
 
6.   Brief updates from area professionals regarding the Flagstaff business community. These updates will happen quarterly and this is the first quarterly update for the year.
 
7.   Consideration and Discussion of the City's Rethink Waste Plan (Resolution 2017-30)
 
8.
Review of Draft Agenda Items for the September 5, 2017, City Council Meeting.*
 
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
 
9. Public Participation
 
10.

Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.

 
11. 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. in accordance with the statement filed by the City Council with the City Clerk.

Dated this               day of                                       , 2017.



_________________________________________
Elizabeth A. Burke, MMC, City Clerk                                 
 
6.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: David McIntire, Community Investment Director
Date: 08/14/2017
Meeting Date: 08/29/2017

TITLE:
Brief updates from area professionals regarding the Flagstaff business community. These updates will happen quarterly and this is the first quarterly update for the year.
DESIRED OUTCOME:
Council will receive information regarding the business activities that have been happening in our community.
EXECUTIVE SUMMARY:
The City of Flagstaff Economic Development Program works with several business providers, both in Flagstaff and regionally.  As the economy grows and shifts over the next year there will be a series of quarterly updates in which these partners, and various business leaders or groups, will have the opportunity to provide brief updates about their efforts, successes, observations, and challenges in the business sector.  The intention is to provide Council, and the public, an opportunity to hear more about what is happening in the community on a regular basis.
INFORMATION:
The Flagstaff economy is complex and always shifting.  It, like all economies in our system, adapts to new influences ranging from the international stage to individual consumer trends and preferences.  As markets, behaviors, rules, regulations, technology and infrastructure change; Flagstaff's economy adjusts as well. This has been a year where change has been apparent in a number of ways.  Growth is visible throughout the community in new construction of healthcare facilities, housing, and with new businesses opening, but a number of business closures also remind us that cycles are constantly in flux. 

To help inform the Council, staff, and the public there will be quarterly work session updates from various community partners.  In this first update, mainly economic development organizations and institutions will present, but the future updates on November 28, 2017; February 27, 2018; and May 22, 2018, will allow for more diverse representation throughout our business community.  Out of respect for the number of organizations working on these issues , and the Council's working calendar, each presenter has been asked to keep their presentations three to five minutes.  Obviously this time will only allow them to discuss specific items, but it is hoped that through these brief presentations, and any additional dialogue, that a picture of what is happening in our business  community will continue to enhance everyone's knowledge and awareness.
 

Attachments:
 
7.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From:
Date: 08/18/2017
Meeting Date: 08/29/2017

TITLE:
Consideration and Discussion of the City's Rethink Waste Plan (Resolution 2017-30)
DESIRED OUTCOME:
Obtain feedback on Resolution No. 2017-30
EXECUTIVE SUMMARY:
In an effort to better prepare for changes in the waste and recycling landscape in the City of Flagstaff, as well as most effectively reduce the impact of the community’s waste and material consumption, City staff have created the Rethink Waste Plan (“Plan”) to guide future efforts. The Plan establishes a framework for institutionalizing a new approach to managing the City’s waste and materials, known as materials management. Additionally, the Plan establishes a vision and goals to evaluate future success, as well as a near term plan for setting a foundation to be built upon in future planning. Resolution 2017-30 adopts the Rethink Waste Plan and establishes an effective date. The goal of the presentation is to obtain feedback in hopes of bringing the Resolution back to City Council in October for approval.
INFORMATION:
As part of the FY 2017 budget, Council approved a Request for Service Level increase for recycling outreach in an effort to increase the recycling rate, currently at 13%. Many Flagstaff residents, businesses, and institutions lack the knowledge and access to services needed to reduce the impact of their waste and material consumption. The Plan outlines the barriers that prevent these actions and guides City staff over the next three (3) years in implementing the most cost-effective initiatives that will empower the community to be resourceful, reduce waste, and make recycling more efficient. Additionally, the Plan provides the public with a clear long-term vision and goals to understand how the City is working to reduce the impact of the community’s material consumption and waste.
 
COUNCIL GOALS:
CLIMATE CHANGE: Take meaningful climate change action. Actively manage and protect all environmental and natural resources.
ENVIRONMENTAL AND NATURAL RESOURCES: Actively manage and protect all environmental and natural resources.
  • Further develop sustainability and waste removal policies and programs.
ECONOMIC DEVELOPMENT: Grow and strengthen a more equitable and resilient economy.
 
REGIONAL PLAN:
Policy E&C.1.4. Maintain air quality through pursuit of non-polluting industry and commercial enterprises.
Policy E&C.2.1. Encourage the reduction of all energy consumption, especially fossil-fuel generated energy, in public, commercial, industrial, and residential sectors.
Policy E.1.3. Empower all community members to make smarter energy choices through education and incentives.
Goals CD.1. Improve the City and County financial systems to provide for needed infrastructure development and rehabilitation, including maintenance and enhancement of existing infrastructure.
Goal PF.2. Provide sustainable and equitable public facilities, services, and infrastructure systems in an efficient and effective manner to serve all population areas and demographics.

Attachments: Rethink Waste Presentation
Resolution 2017-30
Rethink Waste Plan


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /print_all.cfm
Time Stamp 15-May-24 05:23 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
437 ms 437 ms 1 D:/inetpub/PublicPages/print_all.cfm
327 ms 164 ms 2 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
109 ms 55 ms 2 D:/inetpub/PublicPages/public/publish/include_levels.cfm
32 ms 32 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2922, 0) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
32 ms 16 ms 2 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/print_agenda_dsp.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2938, 0) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgenda(607, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 5 ms 3 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/public/publish/print_agenda_ud_load.cfm
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 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgLines(607) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
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 2 D:/inetpub/PublicPages/public/publish/flagstaff.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/public/publish/print_agenda_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
437 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 @ 05:23:55.055
			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 @ 05:23:55.055
				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 @ 05:23:55.055
			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 @ 05:23:55.055
				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'
			
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_all.cfm @ 05:23:55.055
	SELECT user_defined FROM fasinfo
all_codes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\print_all.cfm @ 05:23:55.055
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, dataSortOrder as sort_order,

		   c.misc_alpha2,
		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 05:23:55.055
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 05:23:55.055
	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) = 607

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 05:23:55.055
		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) = 608

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 05:23:55.055
 		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 @ 05:23:55.055
 		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 @ 05:23:55.055
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
checkField (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 05:23:55.055
		SELECT * from agenda_ln WHERE _rowid > 1 and _rowid < 5
	
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 05:23:55.055
		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 607

qryResults (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 05:23:55.055
	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) = 607

getAgHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_all.cfm @ 05:23:55.055
	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\print_all.cfm @ 05:23:55.055
	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgLines (Datasource=, Time=0ms, Records=11) in D:\inetpub\PublicPages\print_all.cfm @ 05:23:55.055
	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
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 05:23:55.055
			select top 1 * from codes
		
qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 05:23:55.055
			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(608 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGPad

AQLogo (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 05:23:55.055
		SELECT printed_logo, logo_plcmnt FROM getform
	
items (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 05:23:55.055
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2922 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = '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 @ 05:23:55.055
		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 = 70 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 = 2922 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 05:23:55.055
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2938 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = '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 @ 05:23:55.055
		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 = 70 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 = 2938 AND
			rev_num = 0
		order by au.seq_num
	
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 05:23:55.055
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, 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, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   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.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' left_justify_all,
	 	   	 
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (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 AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2922
Parameter #2(cf_sql_integer) = 0

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 05:23:55.055
 		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 @ 05:23:55.055
 		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 @ 05:23:55.055
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 608 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 608 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 607 AND agi._rowid = 70)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 608 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 70 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 70)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '70')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi13')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '70'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 2922 AND
				      u.rev_num = 0 
getfi13 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi13'
			
fi13q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi13' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2017-08-29

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'dmcintire'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2922 AND
      rev_num = 0
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2922 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 2922 AND
		  ad.rev_num = 0 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT * from codes where code_type ='asdfasdfasfa'
	
form_rte_stops (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 2922 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 2922 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = 'AI70')
		LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by)
		LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
		WHERE UPPER(hist.form_id) = 'AG_MEMO' AND
			  hist.form_num = 2922 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 05:23:55.055
		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) = 608

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   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, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   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.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 607 AND ai._rowid = 70)
				
				LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
				LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = 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)))
				LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
				LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
				WHERE al._rowid = 14958 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '6'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '6'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 05:23:55.055
		SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
			   ud.form_label, codes.descr, codes.large_misc_alpha
		FROM form_userdef AS u
		INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
		LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
		WHERE u.form_id = 'AG_MEMO' AND
			  u.form_num = 2922 AND
			  u.rev_num = 0 and
			  ud.form_label LIKE '%submitter%'
	
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 05:23:55.055
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, 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, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   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.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' left_justify_all,
	 	   	 
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (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 AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2938
Parameter #2(cf_sql_integer) = 0

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 05:23:55.055
 		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 @ 05:23:55.055
 		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 @ 05:23:55.055
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 608 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 608 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 607 AND agi._rowid = 70)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 608 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 70 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 70)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '70')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi13')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '70'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 2938 AND
				      u.rev_num = 0 
getfi13 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi13'
			
fi13q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi13' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2017-08-29

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
submittor (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'mjones'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2938 AND
      rev_num = 0
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2938 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 2938 AND
		  ad.rev_num = 0 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT * from codes where code_type ='asdfasdfasfa'
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 2938 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 2938 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = 'AI70')
		LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by)
		LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
		WHERE UPPER(hist.form_id) = 'AG_MEMO' AND
			  hist.form_num = 2938 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 05:23:55.055
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 05:23:55.055
		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) = 608

GetThisLine (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   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, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   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.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 607 AND ai._rowid = 70)
				
				LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
				LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = 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)))
				LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
				LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
				WHERE al._rowid = 14945 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '7'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 05:23:55.055
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 607
					AND a.ag_level1 = '7'
					AND a.ag_level2 = ''
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 05:23:55.055
		SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
			   ud.form_label, codes.descr, codes.large_misc_alpha
		FROM form_userdef AS u
		INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
		LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
		WHERE u.form_id = 'AG_MEMO' AND
			  u.form_num = 2938 AND
			  u.rev_num = 0 and
			  ud.form_label LIKE '%submitter%'
	


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\print_all.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//print_all.cfm?seq=607&reloaded=true&id=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\print_all.cfm
QUERY_STRING=seq=607&reloaded=true&id=
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/print_all.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=9794529
cftoken=11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
hitcount=3
lastvisit={ts '2024-05-15 05:23:55'}
timecreated={ts '2024-05-15 05:23:55'}
urltoken=CFID=9794529&CFTOKEN=11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
Cookie Variables:
CFID=9794529
CFTOKEN=11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
Session Variables:
cfid=9794529
cftoken=11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9794529_11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
subdir=/public/
tzoffset=0
urltoken=CFID=9794529&CFTOKEN=11b5d68ae1c764c-D9D6EC69-E95E-EE83-A2C7DDE4A4464A93
URL Parameters:
id=
reloaded=true
seq=607
Debug Rendering Time: 16 ms