City Council Joint Work Session


Return to the Search Page Return to the Agenda
  6.       
Meeting Date: 03/06/2023  
From: Sara Dechter, AICP, Comprehensive Planning Manager
Department: Community Development  
Co-Submitter: Melissa Shaw, AICP Coconino County Long Range Planner

Information
TITLE:
Regional Plan Update and Direction on Plan Creation and Adoption
DESIRED OUTCOME:
Staff will provide an update on the project status and review the public participation and scenario planning process that are underway and continuing through the calendar.  The Board and Council may provide feedback. 

Staff is seeking direction on two major points:
  1. How would the Board of Supervisors and City Council like to form a committee to oversee the selection of a scenario, creation of a Future Growth Illustration, and plan translation to goals and policies?
  2. In what order would the Board and Council like to carry out the joint review and adoption of the Flagstaff Regional Plan 2045?
EXECUTIVE SUMMARY:
The Flagstaff Regional Plan is the General Plan for the City and a comprehensive plan amendment for Coconino County.  The planning area encompasses the City of Flagstaff and unincorporated areas within the Metroplan boundary for Greater Flagstaff jurisdiction.  This intergovernmental approach creates a stronger foundation for land, transportation, water, and natural resources management and planning.  As a shared policy guide for the region, it influences future land use, infrastructure, and social and economic conditions for generations.  It is therefore critical that the process for creating and adopting the plan is inclusive and endorsed by the elected officials.  
INFORMATION:
BACKGROUND

Staff provides regular updates and check in on the Regional Plan process with the City Council, Board of supervisors and the Planning and Zoning commissions. For new City Council members, we recommend reviewing the Regional Plan 101 video for background information on the plan’s requirements.

In March 2021, City Council and the Board of Supervisors separately reviewed and provided feedback on the Public Participation Outline for the update process, and since then, have had regular updates jointly and separately with opportunities to review and provide feedback on the efforts planned and underway.  In October 2022, City Council approved a contract with Cascadia Partners to assist with the Phase 2 Scenario Planning and Collaborative Process. 

Phase 2 Public Participation Update

Phase 2 is the exploratory phase of the Regional Plan process. Throughout Phase 2, there are multiple public engagement opportunities that will culminate in the choosing of a future scenario that will be the basis for the creation of the Future Growth Illustration and related goals and policies. There are three tracts of engagement to ensure a diverse and inclusive process using the project’s guiding principles. Some engagement activities are tailored to one tract and others engage more than one simultaneously. The three tracts are: 

  • General public engagement, which includes traditional workshops, webinars and meetings advertised using notices in the paper, social media, radio, flyers, and other methods. 

  • Technical reviews, which include government and invited experts reviewing material that ends up being an element of the modeling or of public workshops. 

  • Targeted population outreach, which includes bringing the Regional Plan outreach to populations that are heavily impacted by community decisions but have limited resources or history of engagement with community planning and development.  

Visioning workshops

To start the visioning process, between April and November 2022, the project team published a visioning survey on the Flagstaff Community Forum. From August to November, the Regional Plan team held 11 visioning workshops across the regional planning area. At each workshop, a member of the update team gave a brief presentation about the Regional Plan, after which attendees were invited to participate in breakout activities where community members could talk, listen, share, and think about the future of our community. Staff compiled and summarized the feedback received in the attached report. 

Scenario Planning 

Scenario Planning was a successful component of the last Regional Plan update that we are replicating and better integrating into the process for the 2045 update. Scenario planning is an approach to long range planning for cities and regions that enables communities to create and analyze multiple plausible versions of the future. It is increasingly being used in urban planning projects because of its usefulness in times of uncertainty and complexity. Scenario planning encourages strategic thinking around how and why places change, and allows us to imagine multiple futures to meet some of the most pressing challenges of our time related to climate change, transportation, infrastructure, technology, economic development, and housing. It is also a unique opportunity for community stakeholders to help shape the future through collaboration and consensus building around planning.

For Flagstaff's Regional Plan Update, a consultant team led by Cascadia Partners and made up of land use planners, data analysts, and engagement specialists, will use scenarios as a technique to help City and County staff and the Flagstaff community envision a more sustainable and equitable future for the region. Scenarios will use both community feedback and data modeling to help us understand the potential challenges the region might face in the future, and how we can shape policy that is resilient no matter what the future might hold. Based on feedback from staff, technical experts, and stakeholders, a set of alternative land use scenarios will be developed by the consultants and these scenarios will be presented to the public with an evaluation "report card" for each scenario detailing their unique benefits and tradeoffs. Through this process, a preferred scenario will be chosen with input from the Flagstaff community. The preferred scenario will help shape the region's future land use map and will help inform policy recommendations in the Regional Plan Update. 

The Technical Advisory Group 

Starting in February 2023, Cascadia Partners and the Regional Plan Update team engaged a group of 18 subject matter experts in the exploratory scenario planning process. The group's expertise ranges from natural resources and housing to economics and development.  The group was selected based on stakeholder outreach to identify the people in the community with the most depth in particular types of knowledge.  They were invited to advise staff and Cascadia partners on various assumptions and points of uncertainty that are inherent in planning for long range futures. It is important to note that the TAG is not advising on policy or making recommendations beyond how to incorporate feedback and new information into the scenario planning process and modeling efforts.

The first two TAG meetings occurred on Monday, February 6, and Monday, February 27 from 11:00 AM to 1:00 PM. The meetings were recorded and posted to the Regional Plan website under the Scenario Planning tab with the opportunity for the public to watch and provide feedback to the project team and TAG members. At the first two meetings, the TAG is tasked with identifying and evaluating drivers of change in the Flagstaff Region and reviewing work that will end up informing broader public participation opportunities. This group will meet throughout 2023 to think through different facets of future scenarios and strategies for achieving a future vision of the Flagstaff region. 

Public workshops 

Starting in March 2023, Cascadia Partners and the Regional Plan team will begin hosting a series of public workshops to disseminate and discuss items coming out of the TAG meetings. These workshops will be one of the first opportunities for the public to think strategically through uncertainties, trade-offs, and external factors, and how different ways of growing affect community goals. The workshops will explore different ways of planning for future uncertainties through policy choices - exploring the tradeoffs that might come with these choices.  All will be held at the Flagstaff Aquaplex and childcare will be made available.  The schedule of meetings allows for a variety of times to attend: 

  • Tuesday, March 28, 8:00am to 9:30am 

  • Tuesday, March 28, 10:30am to 12:00pm 

  • Thursday, March 30, 6:00pm to 7:30pm 

  • Saturday, April 1, 10:00am to 11:30am 


Collaborative Process with Community Based Organizations 

One of the challenges of a plan covering a large area is that some populations will come and represent their interests readily and with fervor, while others will be faced with more barriers that make them harder to reach and harder to connect with.  To overcome this imbalance in the traditional approach to public participation, the Cascadia Partners team is reaching out to 8-10 Community Based Organizations with established relationships with those who may be most affected by changes in our community’s future and who would not find it easy to attend public workshops and other traditional means of public participation.  This process will include three touchpoints tied to the Scenario Planning Process and will bring new voices to the engagement. The meetings will include 8-10 organization recruited individuals co-led by a facilitator from within their organization. City staff and our consultant will collaborate with these organizations to overcome barriers to participation unique to each of these groups. In addition, staff and the consultant will pull together groups for neighborhood representatives, youth, and elders through existing relationships and services.

Invitations to this process are currently being sent out based on a stakeholder analysis prepared with the Communication and Outreach team that includes staff from planning, communications, and diversity and inclusion roles at the City and County. This brainstorm was vetted by our local subconsultants and via several short stakeholder interviews before organizations were contacted.  The invitations for most groups are still pending. 

Formation of a Regional Plan Committee

In Fall 2023, Phase 3 will begin centered on choosing a preferred scenario, developing a Future Growth Illustration, writing goals and policies, and developing implementation strategies. Advisory committees are a well-established tool for building consensus and ensuring a diverse set of voices are heard in the development of a plan’s goals and policies. Council and the Board of Supervisors has expressed the desire to continue using this technique at the appropriate time in the process.

Based on past feedback from former committee members, staff, members of the public and elected officials, staff recommends that the model used recently in the City of Flagstaff Bond development process for convening a committee to oversee the creation of the plan. To replicate this method, each Council and Board member will provide two nominations to the City and County Manager, who would then meet and review the nominations together.  The managers would then invite 12-15 members to the Committee to advise staff. The benefits of this method are that is it a swifter way to convene the committee and still allows input of all the Board and Council members. It eliminates the step that the City’s formal appointment process uses of making formal applications a requirement and allows nominations to be considered and made in a way that considers the overall diversity of the committee and its representativeness. It also removes the barrier of having an appointment discussed publicly, which may dissuade some people from applying.

While this less formal appointment method does not require Open Meeting Law adherence, staff would still recommend that the meetings be advertised and agendas made public, that the meeting be recorded and made available, and that the public be allowed to address the committee.  This may require that a set of rules of order unique to this group be created.

The more traditional formal appointment method is an option for Council and the Board to consider.  However, staff would recommend a blended approach to address some of the obstacles and issues that arose when this method was used in the last update process. First, rather than having each member select and appoint individuals to the committee, staff would recommend a group of 2 Board members and 2 Council members meet to review all applications together and discuss the diversity and makeup of the group as a whole. They can then create options to present to a Joint Meeting of Council and the Board that they believe will best support the process of building consensus.  Staff would also recommend that the group be limited to no more than 15 members and that the City Council and Board create a joint resolution outlining the committee’s authorities. Establishing the process in this way would mean that over the next 6 months, Council and the Board would need to have 4-6 joint meetings to address this process so that there is a committee in place when the scenario choosing step is brought forward.

A third option would follow the model of the Housing Commission’s working group for the 10-Year Housing Plan. While this process was successful for the City of Flagstaff 10-Year Housing Plan, the complexity of organizing and running an extensive number of working group meetings may be beyond the capacity of current resources for the project. It would also place the burden of recruiting and overseeing the committee on the Planning and Zoning Commissions, which both have vacancies that have been unfilled for some time and have important ongoing development review responsibilities.  

Sequence of Plan Adoption

Phase 4 of the Regional Plan process is plan adoption.  Once the Regional Plan Committee, has reviewed and made recommendations on the content of the Regional Plan, the City and County need a coordinated process that allows both government entities to meet all the legal requirements for adopting a Comprehensive Plan Update (City) and a major Comprehensive Plan Amendment (County). In the 2013-2014 process, the hearings for the plan began at the City and County at the same time with a Public Hearing Draft.  The County adopted this document as written in October 2013, while the City made edits for three months over a series of meetings, finally adopting a slightly different version in January 2014.  Therefore, despite a lengthy shared public engagement process, the County and City adopted similar but not identical plans.

To avoid this same misalignment, the City and County need to set up a clear path with clear shared endorsement and review expectations that meet all the legal requirements for the State, City and County.

First in this section, we will lay out the requirements of each process and then provide staff’s initial recommendation for how to proceed. The intent is to start this conversation and it may be continued to the next joint meeting if needed.

The City process for initiating and adopting a Comprehensive Plan Update (City Code 11-10.20.010): 

  1. At least a 60-day review by required government agencies, utilities, and the general public prior to hearings. 

  1. A Citizen Review Session 

  1. Two public hearings of the Planning and Zoning Commission 

  1. One Public hearing with the City Council and approved by an affirmative vote of at least two-thirds (2/3) of the members of the Council. 

  1. Ratification at the next regularly scheduled municipal election or at a special election scheduled at least one hundred twenty (120) days after the governing body adopted the General Plan 

County process for adopting a Comprehensive Plan Major Amendment (County Zoning Ordinance Section 5.13) 

  1. Major Amendments are heard once per calendar year by the Planning and Zoning Commission at its regular meeting in October of that year. 

  1. At least sixty days prior to the comprehensive plan update notification for Planning and Zoning Commission consideration the draft will be transmitted for review and comment to municipalities within the county, contiguous counties, NACOG, military airport, the attorney general, the Arizona Department of Commerce, Arizona Department of Water Resources, and any person interested in reviewing planning documents. 

  1. At least one public hearing by the Planning and Zoning Commission who will forward its recommendation for a Major or Minor Amendment to the Board of Supervisors. 

  1. The Board of Supervisors will hold at least one public hearing within 90 days after the Planning and Zoning Commission hearing. Minor Amendments are subject to a simple majority vote of the Board of Supervisors. Major Amendments require a four-fifths majority vote of the Board of Supervisors. 

Staff recommends that the combined process focus on reviewing the final draft together and adopting separately, through the following steps: 

  1. 60-day public review 

  1. Incorporation of Public Comments 

  1. Final Regional Plan Committee Review and Recommendations 

  1. Joint retreat with the City Council, Board of Supervisors, Planning and Zoning Commissioners (advertised as Citizen Review session for the City) 

  1. City of Flagstaff Public Hearings with the Planning and Zoning Commission and City Council 

  1. City of Flagstaff Voter Ratification 

  1. Coconino County Public Hearings with the Planning and Zoning Commission and Board of Supervisors 


Attachments
Presentation
Regional Plan 101 Handout from Workshops
Visiong Summary Report
CBO Partner Description


    

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

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


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


Execution Time

Total Time Avg Time Count Template
156 ms 156 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
109 ms 109 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(7070, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
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 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_expincl.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
156 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 @ 00:25:48.048
			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 @ 00:25:48.048
				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 @ 00:25:48.048
			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 @ 00:25:48.048
				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 @ 00:25:48.048
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 00:25:48.048
	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 @ 00:25:48.048
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:25:48.048
		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 @ 00:25:48.048
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:25:48.048
		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 @ 00:25:48.048
	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 @ 00:25:48.048
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:25:48.048
		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 @ 00:25:48.048
		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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:25:48.048
	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=15ms, Records=16) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 00:25:48.048
		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-03-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-03-31 00:00:00.0

chk_aiDisplay (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_content.cfm @ 00:25:48.048
		select case when ss_agi._rowid is null then agi.display_routine else ss_agi.display_routine end as display_routine
		from ag_memo am
		inner join agenda_ln as atl on (atl.ag_memo_id = am.form_num and atl.ag_memo_rev = am.rev_num)
		inner join agenda as a on (a.form_num = atl.form_num)
		left outer join ag_item as agi on (agi._rowid = am.ag_item_rowid)
		left outer join ss_ag_item as ss_agi on (ss_agi.form_num = a.form_num and ss_agi._rowid = am.ag_item_rowid)
		where am.form_num = ?
		  and am.rev_num  = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7070
Parameter #2(cf_sql_integer) = 0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:25:48.048
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 00:25:48.048
	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,
	 	   	 
	 	   		c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 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) = 7070
Parameter #2(cf_sql_integer) = 0

final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 00:25:48.048
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3714 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 00:25:48.048
 		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 @ 00:25:48.048
 		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 @ 00:25:48.048
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 3715 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 3715 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
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 = 3714 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 = 3715 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 @ 00:25:48.048
		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 @ 00:25:48.048
		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 @ 00:25:48.048
			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 @ 00:25:48.048
			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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
			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 = 7070 AND
				      u.rev_num = 0 
getfi13 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
				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 @ 00:25:48.048
					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) = 2023-03-06

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
		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 = 'sdechter'
	
items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 7070 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 @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 7070 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 00:25:48.048
	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 = 7070 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 @ 00:25:48.048
		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 @ 00:25:48.048
	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 = 7070 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 @ 00:25:48.048
	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 = 7070 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 @ 00:25:48.048
		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 = 7070 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 @ 00:25:48.048
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 00:25:48.048
		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) = 3715

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 00:25:48.048
				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 = 3714 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 = 45054 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 00:25:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3714
					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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 00:25:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3714
					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 @ 00:25:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3714
					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'
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 00:25:48.048
	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 @ 00:25:48.048
	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 @ 00:25:48.048
		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 @ 00:25:48.048
		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=3&get_year=2023&dsp=agm&seq=7070&rev=0&ag=3714&ln=45054&nseq=7086&nrev=0&pseq=7085&prev=0
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=3&get_year=2023&dsp=agm&seq=7070&rev=0&ag=3714&ln=45054&nseq=7086&nrev=0&pseq=7085&prev=0
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=7967528
cftoken=6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
hitcount=4
lastvisit={ts '2024-03-01 00:25:48'}
timecreated={ts '2024-03-01 00:25:48'}
urltoken=CFID=7967528&CFTOKEN=6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
Cookie Variables:
CFID=7967528
CFTOKEN=6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=3714
DISPLAY_ID=7070
DISPLAY_REV=0
Session Variables:
cfid=7967528
cftoken=6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_7967528_6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
subdir=/public/
tzoffset=0
urltoken=CFID=7967528&CFTOKEN=6c473ef18e50b42c-B863FEF9-E2C7-D4C0-432F494D01D206EC
URL Parameters:
ag=3714
dsp=agm
get_month=3
get_year=2023
id=
ln=45054
mt=ALL
nrev=0
nseq=7086
prev=0
pseq=7085
rev=0
seq=7070
Debug Rendering Time: 0 ms