City Council Meeting


Return to the Search Page Return to the Agenda
  13.A.       
Meeting Date: 10/15/2013  
From: Roger Eastman, Zoning Code Administrator

Information
TITLE:
Public Hearing, Consideration and Adoption of Ordinance No. 2013-21 and Resolution No. 2013-22:  An Ordinance Adopting That Certain Document Entitled “2013 Amendments to Chapter 10-20, Administration, Procedures and Enforcement,” By Reference; and Thereby Amending Division 10-20.50, Amendments to the Zoning Code Text and the Zoning Map, and Division 10-80.20, Definition of Specialized Terms, Phrases and Building Functions; and a Resolution of the Council of the City of Flagstaff, Arizona, Declaring as a Public Record That Certain Document Filed with the City Clerk and Entitled “2013 Amendments To Chapter 10-20, Administration, Procedures And Enforcement.”
RECOMMENDED ACTION:

1) Open and close the public hearing
2) Read Resolution No. 2013-22 by title only
3) City Clerk reads Resolution No. 2013-22 (if approved above)
4) Read Ordinance No. 2013-21 for the first time by title only
5) City Clerk reads Ordinance No. 2013-21 for the first time by title only
At the November 5, 2013, Council Meeting:
6) Adopt Resolution No. 2013-22 declaring the “2013 Amendments to Chapter 10-20, Administration, Procedures and Enforcement” as a public record.
7) Read Ordinance No. 2013-21 for the final time by title only
8) City Clerk reads Ordinance No. 2013-21 by title only (if approved above)
9) Adopt Ordinance No. 2013-21

Policy Decision or Reason for Action:
The Council together with community stakeholders held a number of special work sessions from April through July 2013 to discuss the need for, and provide direction on, possible amendments to the zone change process. These amendments are now presented to the Council for review and adoption.
Financial Impact:
There is no direct financial impact to the City of Flagstaff by adopting this ordinance. However, many supporters of the proposed amendments have suggested that if they are adopted, more development supported by the Regional Plan may result.
Connection to Council Goal:
1.   Zoning Code check in and analysis of the process and implementation
2.   Effective governance

Has There Been Previous Council Decision on This:
Yes, in early 2013 the Council agreed to a work session with invited community stakeholders participating in the discussion. Ultimately, three special work sessions were held on April 8th, May 20th, and July 15, 2013, and specific direction to staff on an appropriate path forward was provided.
Options and Alternatives:
Please refer to the Expanded Options and Alternatives below.
Background/History:
On April 8, 2013, the Council held a special work session with selected members of the public to initiate a discussion on the City’s current zone change process as defined in the Flagstaff Zoning Code, Division 10-20.50 (Amendments to the Zoning Code Text and the Zoning Map). The stakeholders participating in the discussion with the Council included;
  • Richard Bowen – ECONA ;
  • David Carpenter – as chair of the Planning and Zoning Commission;
  • Maury Herman – Flagstaff 40;
  • Kent Hotsenpiller – local surveyor/engineer;
  • Julie Pastrick – Flagstaff Chamber of Commerce;
  • Keri Silvyn – representing Mr. Michael Manson, local property owner/developer;
  • Don Walters – NABA and NAAR;
  • Marilyn Weismann – Friends of Flagstaff’s Future; and
  • Nat White – interested citizen and former City councilor.
This public meeting enabled the participants to work with staff to identify issues, acknowledge many perspectives on this topic, and establish a starting point for future discussion. It concluded with the agreement that staff would bring back suggestions for a possible path forward at the next meeting.
 
On May 20, 2013, the Council held a second special work session following the same format as the April 8th meeting. Staff presented ideas on how to a find a solution to the issues identified by the group, including for example:
  • An introduction to the principle of a concept zoning plan;
  • Clarification and redefinition of submittal requirements for zone change applications;
  • A review of process diagrams for the small, medium, and large scale zoning applications;
  • Introduction of a fourth category, previously named “master plans,” and now called “multi-phase” projects;
  • An explanation of conditional zoning;
  • An explanation of a new process idea that gives a developer a choice for the process to be followed for a zone change application based on the nature of the request; and
  • A brief discussion of a new idea (called “correctional zoning”).

Staff also presented six options for a path forward. After some discussion a majority of the Council agreed on an appropriate path forward as described in the following paragraph.
 
The July 15, 2013, special work session concluded with the Council agreeing that the appropriate path forward would include the need to: 

  • Establish minimum submittal requirements to decouple details associated with site plan review from a concept zoning plan;
  • Maintain the small, medium, and large scales and add a new “multi-phase” scale;
  • Add a new process to give a developer choice;
  • Expand the number of conditions applied to a zone change application; and
  • Enable an additional public meeting hosted by the developer after final Council action and before site plan review.
Key Considerations:
When the City of Flagstaff Zoning Code was adopted in November 2011, a revised procedure was supported by the Council at that time for the City’s zone change process. As noted previously, in early 2013 the Council agreed that a work session(s) on the City’s zone change process were appropriate to review, discuss, and consider possible amendments to this Division of the Zoning Code. These special work sessions provided a forum for Flagstaff residents to provide their perspectives and opinions on this issue. The narrative in the “Community Benefits and Considerations” section below summarizes the pros and cons made by the participants in these work sessions, as well as comments made during the Planning and Zoning Commission’s August 21st work session and September 11, 2013 public hearing.
 
The proposed amendments to the Zoning Code reflecting the City Council’s direction on the City’s zone change process are attached to Resolution No. 2013-22. New text is identified in underline, and text proposed to be deleted is shown as strikeout. A summary of the more significant amendments that warrant an explanation is provided in the narrative below:

Chapter 10-20            Administration, Procedures, and Enforcement
Division 10-20.50      (Amendments to the Zoning Code Text and the Zoning Map)
 
10-20.50.020   Applicability

Minor revisions are proposed to this paragraph to simplify and clarify the text.

10-20.50.030   Initiation of Amendments
  1. Owner Initiation
    Minor revisions are proposed to this paragraph to simplify and clarify the text.

10-20.50.040   Procedures

  1. Pre-application Review
    Minor revisions are proposed to this paragraph to simplify and clarify the text.
     
  2. Citizen Review
Sub-paragraph 2.b: A minor revision to this sub-paragraph clarifies that at least one of the forms of notice described in i., ii., and iii. is required, and that iv. is optional.
  1. Application Requirements
    Paragraph 2:
    a.Small-scale Zoning Map Amendments: Minor revisions are proposed to this paragraph to clarify its intent and to introduce a concept zoning plan, if required.
     
    b.Medium-scale Zoning Map Amendments: Amendments in this paragraph clarify the thresholds for medium-scale amendments and introduce the concept zoning plan in lieu of a concept site plan.
     
    c.Large-scale Zoning Map Amendments: Amendments in this paragraph introduce the concept zoning plan as a submittal requirement, and text that is no longer necessary is proposed for deletion.
     
    d.Multi-phase Scale Zoning Map Amendments: This is a new paragraph inserted to provide a new scale of Zoning Map amendments for large and often complex projects that for example, may include multiple zoning designations, multiple ownership, multiple subdivisions, and complex utility or street infrastructure issues.
     
  2. Application Procedures – A Two-Pronged Approach: This is a new paragraph that provides an applicant with two options when considering a zone change. 
1. Direct Ordinance with a Site Plan:
    This option allows a developer to submit an application for site plan review and zone change approval concurrently.
 
2. Authorization to Rezone with a Concept Zoning Plan:
    This option is much the same as the zone change process in place today in that the zone change application is reviewed in advance of the site plan review. An important distinction, however, is that the zone change application is based on  reduced submittal requirements (concept zoning plan) and the site and development details of the project are reviewed at the site plan stage of the project’s review.

    H. Planning Commission Public Hearing
A new sub-paragraph 2. has been added to clarify that the Planning and Zoning Commission may request additional information relevant to assist in their review of the zone change application.

    I.  Council Public Hearing
A new sub-paragraph 2. has been added to clarify that the City Council may request additional information relevant to assist in their review of the zone change application.
 
    L.  Ordinance Effective Date
This new paragraph clarifies and includes a state law requirement that all zone change approvals are subject to referendum and shall not become effective until 30 days after adoption of the adopting ordinance, or the date the final ordinance is available from the City Clerk, whichever is later.
 
    N. Conditions of Approval
The amendments proposed in this section comprehensively expand the Commission and the Council’s ability to impose conditions of approval on a zone change application.  The purposes of conditions of approval have been expanded, and some examples of conditions of approval are included.
 
Chapter 10-80            Definitions
Division 10-80.20 (Definitions of Specialized Terms, Phrases, and Building Functions)
 
10-80.20.030   Definitions, “C.”
A minor amendment is proposed to the definition of “concept plan”, and a new definition for “concept zoning plan” is proposed.
 
10-80.20.050   Definitions, “E.”
A new definition for “enhanced concept zoning plan” to be submitted with a multi-phase scale application is proposed.
 
Consistent with the direction provided by the Council, staff has developed revised submittal requirements in support of a concept zoning plan. The attached document reflects suggestions from a variety of City Divisions who are involved in the review of zone change applications. Additional recommendations from the Planning and Zoning Commission on submittal requirements are described later in this report.

 
Expanded Financial Considerations:
None.
Community Benefits and Considerations:
The amendments proposed to the City’s zone change process attached to Resolution No. 2013-22 are based on direction from the Council at their last work session supported by a majority of the stakeholders who participated in the discussion with the Council. In the narrative below a brief assessment of the City’s current zone change procedure compared to the proposed amendments to this section of the Zoning Code is provided using the arguments “for” or “against” made by the participants at the April 8th, May 20th and July 15th special work sessions, as well as comments made during the Planning and Zoning Commission’s August 21st work session and September 11, 2013 public hearing.
 
Existing Zoning Code – Division 10-20.50
In general the group noted that “timing” and “uncertainty” are the two underlying issues; citizens are concerned with what will happen with the rezoning of property near them and how they may be impacted, whereas developers are concerned with the requirement for more concrete requirements at the beginning of the process, which while providing more certainty, in return provides them with less flexibility (adapted from the minutes of the April 8, 2013 work session).
  • The existing zone change process is relatively untested since its adoption in November 2011 and, therefore, should be left intact.
  • Requiring details up-front with the zone change application provides certainty to appointed and elected officials and Flagstaff residents.
  • It is important to communicate as much detail about a project with Flagstaff residents as possible. 
     
  • The existing zone change process discourages new development and capital investment in the City because of the uncertainty of the process.
  • The existing process discourages zone change applications because full knowledge of the intended use is needed to determine the zoning, and it is too costly to develop detailed site plans, floor plans, elevations, etc. when the final user may not be known.
  • Flagstaff has a low inventory of land suitable for development, and the current process tends to drive development to other communities.
Proposed Amendments to Division 10-20.50
  • The proposed amendments will result in “speculative rezoning” within the City.
  • Flagstaff residents and property owners will not be provided with sufficient information for them to be fully informed about the proposed rezoning application, including for example, the final use of the property. Removing details from the zone change application is the antithesis to public input and will hinder the Planning and Zoning Commission’s decision-making ability.
  • Amendments to this division are unnecessary as the current process has not been tested sufficiently and it appears to be working.
  • Speculative rezoning will be enabled by the proposed new process which will be beneficial to developers at the expense of Flagstaff residents as, for example, public participation will be reduced.
  • The momentum for the proposed changes to the zone change process is coming from a small percentage of Flagstaff residents. This issue is not important to the general public.
  • Concern for the amount of detail still required for impact analyses at the rezoning stage of a project given that the zone change application is based on a concept zoning plan.
  • There should be more consideration given to a bulk and massing analysis as a requirement of a concept zoning plan. 
  • The revised zone change process decouples the details associated with site plan approval from the minimum information necessary to entitle a property through the zone change application, yet it still provides City staff, appointed and elected officials and Flagstaff residents with sufficient information to make an informed decision.
  • The existing three scales of development (small, medium, and large) have been retained and a new scale for multi-phase developments has been added.
  • The proposed amendments establish a new process (Direct Ordinance with Site Plan) that enables a developer to pursue a potentially faster approval of both site plan and rezoning applications.
  • Support for the idea of enhanced conditions associated with a zone change request, especially to allow for an additional informational public meeting between a developer and surrounding neighbors.
  • Support for the amendment that clarifies that the Planning and Zoning Commission and Council may ask for additional information to assist them in their review of a rezoning application.
Community Involvement:
INFORM, CONSULT, & INVOLVE - In a work session at the beginning of the year, the Council discussed how to move forward with proposed amendments to the Zoning Code and a discussion of “policy” versus “technical” amendments ensued.  The Council also supported the idea of a special work session to discuss the merits of amending the City’s zone change process with community stakeholders selected by the Council as participants in the discussion. Eventually three special work sessions were scheduled (April 8, May 20, and July 15, 2013) with active participation by the Council and invited community stakeholders. Other members of the public participated in these work sessions and provided comment to the Council when invited to do so.
 
Staff has also discussed the proposed amendments with, and provided frequent updates to, such organizations as Northern Arizona Builders Association, Northern Arizona Association of Realtors, Friends of Flagstaff’s Future, etc.
 
An 1/8 page display advertisement was printed in the August 16, 2013 Arizona Daily Sun in advance of the August 21st Planning and Zoning Commission work session, and a similar legal notice advertisement was printed in the August 23, 2013 Arizona Daily Sun at least 15 days in advance of the Planning and Zoning Commission’s September 11, 2013 public hearing and the Council’s October 15, 2013 public hearing as required by the Zoning Code.
 
At the August 21st Planning and Zoning Commission work session four citizens addressed the Commission, all of whom were not supportive of  the proposed amendments to Division 10-20.50 of the Flagstaff Zoning Code. The commissioners also commented on the proposed amendments and provided their own perspectives.
 
At the Planning and Zoning Commission’s September 11, 2013 public hearing six members of the public spoke, three of whom encouraged the Commission to recommend approval of the amendments, and three who opposed the amendments. A copy of the Planning and Zoning Commission minutes for the September 11, 2013 meeting is attached with a summary of the public comments. After extensive discussion, the Commission moved to recommend that the City Council approve the proposed amendments to Division 10-20.50 (Amendments to the Zoning Code Text and the Zoning Map) and Division 10-80.20 (Definitions of Specialized Terms, Phrases, and Building Functions) with the inclusion of the following additional submittal requirements that would be applicable to all zone change applications, i.e. small, medium, large, and multi-phase scale projects:

(1) a three-dimensional bulk and mass analysis/visualization of the project;
(2) a maximum building envelope shall be defined for all proposed uses; and,
(3) a minimum boundary of protected natural resources shall be defined based on preliminary resource calculations.
Expanded Options and Alternatives:
  1. Adopt Resolution No. 2013-22 declaring that the document entitled “Amendments to Chapter 10-20, Administration, Procedures and Enforcement” be a public record
  2. Do not adopt Resolution No. 2013-22 and, therefore, do not declare the proposed amendments to be a public record
  3. Adopt Ordinance No. 2013-21 to amend Flagstaff Zoning Code Division 10-20.50 (Amendments to the Zoning Code Text and the Zoning Map) and Division 10-80.20 (Definitions of Specialized Terms, Phrases, and Building Functions)
  4. Modify and adopt Ordinance No. 2013-21 to amend Division 10-20.50 (Amendments to the Zoning Code Text and the Zoning Map) and Division 10-80.20 (Definitions of Specialized Terms, Phrases, and Building Functions)
  5. Do not adopt Ordinance No. 2013-21 and, therefore, make no changes to the existing text in the Zoning Code regarding the zone change process.

Attachments
Ord. 2013-21
Res 2013-22
Submittal Requirements
P&Z Commission Drft Minutes 09/11/2013

<
Form Review
Inbox Reviewed By Date
City Clerk lburke 10/01/2013 02:37 PM
Legal Assistant Vicki Baker 10/01/2013 03:42 PM
Form Started By: reastman Started On: 09/09/2013 03:17 PM
Final Approval Date: 10/04/2013

    

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

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


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 18-May-24 09:40 PM
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
359 ms 359 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
265 ms 265 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
250 ms 250 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(848, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.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 1 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/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
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
375 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 @ 21:40:44.044
			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 @ 21:40:44.044
				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=16ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 21:40:44.044
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 21:40:44.044
	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 @ 21:40:44.044
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 21:40:44.044
		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 @ 21:40:44.044
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 21:40:44.044
		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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
		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 @ 21:40:44.044
		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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
	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 @ 21:40:44.044
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 21:40:44.044
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 21:40:44.044
		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) = 2013-10-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2013-10-31 00:00:00.0

chk_aiDisplay (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_content.cfm @ 21:40:44.044
		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) = 848
Parameter #2(cf_sql_integer) = 0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 21:40:44.044
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 21:40:44.044
	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) = 848
Parameter #2(cf_sql_integer) = 0

getAIList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 21:40:44.044
		SELECT * from Session.AIList
		WHERE ag_memo_id = 848 AND
		      ag_memo_rev = 0 
final_check (Datasource=frsRO, Time=0ms, Records=20) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 21:40:44.044
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 176 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 21:40:44.044
 		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 @ 21:40:44.044
 		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 @ 21:40:44.044
		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 @ 21:40:44.044
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 176 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=20) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:44.044
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 176 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 @ 21:40:44.044
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 = 176 AND agi._rowid = 21)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 176 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 21 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:44.044
		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 @ 21:40:44.044
		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 = 21)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '21')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:44.044
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi14')
			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 @ 21:40:44.044
			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 = '21'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
			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 = 848 AND
				      u.rev_num = 0 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi14'
			
fi14q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi14' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2013-10-15

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
		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 = 'reastman'
	
items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 848 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 @ 21:40:45.045
	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 @ 21:40:45.045
	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 @ 21:40:45.045
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 848 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
	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 = 848 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 @ 21:40:45.045
		SELECT * from codes where code_type ='asdfasdfasfa'
	
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 848 AND
		      rev_num = 0
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
	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 = 848 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
	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 = 848 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=32ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
		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 = 'AI21')
		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 = 848 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 21:40:45.045
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 21:40:45.045
		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) = 176

GetThisLine (Datasource=frsRO, Time=62ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 21:40:45.045
				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 = 176 AND ai._rowid = 21)
				
				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 = 4552 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 21:40:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 176
					AND a.ag_level1 = '15'
					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 @ 21:40:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 176
					AND a.ag_level1 = '15'
					AND a.ag_level2 = 'A'
					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 @ 21:40:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 176
					AND a.ag_level1 = '15'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 21:40:45.045
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 21:40:45.045
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 848 AND
					      rev_num = 0
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=15ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 21:40:45.045
	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 @ 21:40:45.045
	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 @ 21:40:45.045
		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 @ 21:40:45.045
		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=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFTOKEN=bd4c1bf308549171%2D973F9075%2DFC6A%2DEEE5%2D0134BB0F3F91094B; CFID=9887560
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=10&get_year=2013&dsp=agm&seq=848&rev=0&ag=176&ln=4552&nseq=847&nrev=0&pseq=&prev=
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\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=10&get_year=2013&dsp=agm&seq=848&rev=0&ag=176&ln=4552&nseq=847&nrev=0&pseq=&prev=
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=9887560
cftoken=bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
hitcount=50
lastvisit={ts '2024-05-18 21:40:44'}
timecreated={ts '2024-05-18 21:40:38'}
urltoken=CFID=9887560&CFTOKEN=bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
Cookie Variables:
CFID=9887560
CFTOKEN=bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=176
DISPLAY_ID=848
DISPLAY_REV=0
Session Variables:
ailist=Query (15)
cfid=9887560
cftoken=bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9887560_bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
subdir=/public/
tzoffset=0
urltoken=CFID=9887560&CFTOKEN=bd4c1bf308549171-973F9075-FC6A-EEE5-0134BB0F3F91094B
URL Parameters:
ag=176
dsp=agm
get_month=10
get_year=2013
id=
ln=4552
mt=ALL
nrev=0
nseq=847
prev=
pseq=
rev=0
seq=848
Debug Rendering Time: 0 ms