City Council Meeting - DRAFT


Return to the Search Page Return to the Agenda
  14.A.       
Meeting Date: 06/07/2016  
From: Roger Eastman, Zoning Code Administrator

Information
TITLE:
Public Hearing, Consideration and Possible Adoption of Resolution Nos. 2016-21 and 2016-13, and Ordinance No. 2016-22: Public hearing to consider proposed amendments to Flagstaff Zoning Code, Chapter 10-50 (Supplemental to Zones), Division 10-50.100 (Sign Standards), and other related amendments in Chapter 10-20 (Administration, Procedures and Enforcement), Chapter 10-80 (Definitions) and Chapter 10-90 (Maps); consideration of Resolution No. 2016-13 declaring the proposed amendments as a public record; and adoption of Ordinance No. 2016-22, adopting amendments to Flagstaff Zoning Code Chapter 10-50 (Supplemental to Zones), Division 10-50.100 (Sign Standards), and other related amendments in Chapter 10-20 (Administration, Procedures and Enforcement), Chapter 10-80 (Definitions) and Chapter 10-90 (Maps), by reference, and consideration of Resolution No. 2016-21 to adopt the Flagstaff Sign Free Zone (Zoning Code Amendments - Sign Standards; adopting the Flagstaff Sign Free Zone)
RECOMMENDED ACTION:
At the June 7, 2016, Council Meeting:
  1) Continue holding Public Hearing
  2) Read Resolution No. 2016-21 by title only
  3) City Clerk reads Resolution No. 2016-21 by title only (if approved above)
  4) Adopt Resolution No. 2016-21
  5) Read Resolution No. 2016-13 by title only
  6) City Clerk reads Resolution No. 2016-13 by title only (if approved above)
  7) Read Ordinance No. 2016-22 by title only for the first time
  8) City Clerk reads Ordinance No. 2016-22 by title only (if approved above)
At the June 21, 2016, Council Meeting:
  9) Adopt Resolution No. 2016-13
10) Read Ordinance No. 2016-22 by title only for the final time
11) City Clerk reads Ordinance No. 2016-22 by title only (if approved above)
12) Adopt Ordinance No. 2016-22
Executive Summary:
Amendments to Flagstaff Zoning Code Division 10-50.100 (Sign Standards) are needed in response to the US Supreme Court's decision last year in the Reed v. Town of Gilbert sign case. At a work session with the Council on December 8, 2015 the reason for these amendments was discussed and an overview of them was presented by staff. Council provided direction to staff on these amendments which has been included in the amendments, which were reviewed and recommended for approval by the Planning and Zoning Commission on February 24, 2016, attached to Resolution 2016-13. Recent revisions proposed after further legal review have been inserted in Track Changes format. Resolution No. 2016-21 is also attached if the Council agrees to the adoption of the Flagstaff Sign Free Zone.
Financial Impact:
Council's possible adoption of the proposed amendments to the City's sign standards will not have a financial or budgetary impact on the Comprehensive Planning and Code Administration Program's budget.
Connection to Council Goal and/or Regional Plan:

COUNCIL GOALS:
7) Address key issues and processes related to the implementation of the Regional Plan.

REGIONAL PLAN:
The Flagstaff Regional Plan 2030 supports the amendments to Division 10-50.100 (Sign Standards) with the following goals and policies:

Goal CC.1.       Reflect and respect the region’s natural setting and dramatic views in the built environment. The proposed amendments support this goal by ensuring the aesthetic beauty of the City’s natural and built environment is protected (Purpose statement B.5).
 
Policy ED.7.1.    Support planning, design, and development that positively, creatively, and flexibly contribute to the community image.”

Has There Been Previous Council Decision on This:
The Council held an executive session and work session on December 8, 2015 to discuss the proposed amendments to Division 10-50.100 (Sign Standards) and an additional executive session on April 12, 2016.
Options and Alternatives:
Please refer to the Expanded Options and Alternatives below.


 
Background/History:
In June this year the US Supreme Court rendered its decision in the Reed v. Town of Gilbert sign code case which clarified when government regulation of speech is content based. Content-based laws are presumptively unconstitutional. The Supreme Court's decision in the Reed case has wide-ranging implications for sign ordinances in cities across the nation.
  1. The key takeaway from the Reed case is that cities cannot categorize signs based on the topic or message being conveyed and then impose restrictions within each content-based category. For example, the current sign code provides different standards for different types of temporary signs such as real estate signs, new development construction signs, political signs, and commercial advertising signs. Subjecting each category of signs to different restrictions is no longer permissible under Reed.

  2. As a result of the Reed decision, every sign code needs to be carefully scrutinized to ensure that it does not contain content-based regulations. Planning staff has worked closely with the City's Attorney's office to understand the implications of the Reed decision on the City's sign code and over the past few months has developed many ideas for amendments to the sign regulations. Staff also participated in a professional development workshop hosted by the Arizona Planning Association in August 2015 on the implications of the Reed case, and was a presenter at professional conferences in October and November (Quad States Conference in Kansas City in October and the Arizona Planning Association annual conference in November), and most recently the New Jersey Planning Association conference in January 2016, in which the principles behind the City's draft amendments were presented to the attendees. Staff took advantage of being at these conferences to talk with planners and attorneys familiar with the Reed case to solicit their input and ideas on the City's ideas. The response was very supportive and favorable.
     
    A summary of this important case is provided in the first attachment, "An Overview of Reed v. Town of Gilbert, US Supreme Court No. 135 S.CT. 2218, 2015."
Key Considerations:
The proposed amendments to Division 10-50.100 (Sign Standards) are intended to ensure consistency with the US Supreme Court’s decision, and to streamline, simplify, and improve the standards to provide flexibility and maintain a positive community image, while supporting the needs of business owners.
 
Resolution 2016-13 (2016 Amendments to City Code Title 10, Zoning Code, Division 10-50.100 (Sign Standards) and Other Related Divisions) is attached. This is a “Clean” version of the amendments to the sign standards and other related Sections of the Zoning Code with all changes accepted to assist in the Council's review, except that recent revisions proposed after further legal review have been inserted in Track Changes format. This version has been reorganized into a more logical structure, cross references and formatting are completed, and it is a final version. A “Track Changes” version of the draft amendments that shows new text in underline and text to be deleted in strikeout is also attached, as is Ordinance 2016-22.
 
The majority of the amendments included within this Division, especially in the Portable Signs Section (formerly Temporary Signs), are proposed in response to the US Supreme Court’s decision in the Reed v. Town of Gilbert sign code case to ensure that the City’s sign provisions are content neutral. The Planning and Zoning Commission as part of their review of the entire Zoning Code in June 2015 recommended approval of a few minor amendments within the Permanent Sign Section of the Code (Section 10-50.100.060), and these, together with additional amendments, especially in the Portable Signs Section (10-50.100.090) are included in the attached amendments documents. The narrative below provides an overview of the more substantive amendments organized by Section and Subsection.
 
10-50.100.010  Purpose
  • B.   Includes minor amendments to remove redundant language and improve readability.
  • C.  Table 10-50.100.010.A (Sign Types) has been deleted as it provided information of little value to readers and users of the Code.
10-50.100.020  Applicability
  • A.4 The text describing how the sign standards are applied for permanent signs across the whole City and within the Flagstaff Central District and Historic Downtown District has been moved to the permanent sign Section (10-50.100.060). The provision allowing for speech in a traditional public forum has been moved from Section 10-50.100.040.A (Location Restrictions) to this Section where it is more appropriately placed.
  • B.   Interpretations. Includes additional language to provide that non-commercial speech may be substituted for commercial speech on a sign without the need for a permit.
  • C.  Exemptions.
    • The following Subsections have been deleted or removed from this Subsection:
      • Display Board for Daily Specials
      • Political Signs
      • Neighborhood or District Signs (now included within Section 10-50.100.100.A (Flagstaff Central District)
      • Non-Structural Modifications and Maintenance (moved to the Section 10-50.100.030 (Sign Permit Requirements)
      • Real Estate Signs
      • Signs Required by Law (now included within governmental signs)
      • Vehicle Signs (Moved to Table 10-50.100.060.P (Standards for Other Sign Types))
      • Yard and Garage Sale Signs
    • The following Subsections have been updated to clarify standards and improve readability:
      • Flags: The former text concerning flags has been deleted to ensure consistency with the Reed case.
      • Governmental Signs (includes property address signs)
      • Internal Signs and Signs within City Recreation Facilities.
 10-50.100.030  Sign Permit Requirements
  • A.  The requirement for Temporary Sign Permits for all temporary signs has been modified to only require a permit for Temporary Wall Banner Signs. The draft amendments contemplate that all other temporary signs (i.e. Portable Signs) will not be subject to a permitting requirement.
  • C.  The standards for Non-Structural Modifications and Maintenance have been moved from Subsection C. (Exemptions) to this Section where they more appropriately should be placed.
10-50.100.040  General Restrictions for All Signs
  • A.  Location Restrictions Prohibited Signs. Includes minor amendments to remove redundant language and improve readability. Former section name accepted so that a new Prohibited Sign Section can be added see B. below.

    Included in the proposed amendments (Page 50.100-11 of the attachment to Resolution 2016-13) is an alternative to the prohibition of all signs (other than government signs for public safety purposes) in the current Sign Code. This alternative would allow for the following:
    1. Prohibit permanent signs within, on or projecting into the City right-of-way;
    2. Prohibit the placement of signs containing a commercial message within City rights-of-way; and
    3. Prohibit portable signs within the Flagstaff Sign Free Zone.
The provision allowing for speech in a traditional public forum has been moved to Section 10-50.100.020.A (Applicability), and the standards for signs on vehicles have been moved to Table 10-50.100.060.P (Standards for Other Sign Types). The standards prohibiting a vehicle from being used as an advertising sign have been deleted from this Subsection as they are included in Table P. Also, an amendment to this Section clarifies that no signs may be placed on the roof of a building except as permitted in the Roof Sign Subsection (10-50.100.060.C.4.b.(11).
  • B.   Prohibited Signs. This is a new section to include billboards, bandit signs and stuffed or inflated animal signs.
  • C.   Display Restrictions. Includes minor amendments to remove redundant language and improve readability.
10-50.100.050  General Requirements for All Signs
  • No significant amendments are proposed in this Section except to include an additional photograph to better illustrate how to calculate sign area.
10-50.100.060  Permanent Signs
  • C.4.b.(2) Building Mounted Signs. Includes minor amendments and an illustration to clarify and better explain the standards for sign placement.
  • C.4.b.(5) Driveway Signs (formerly Directional Signs). Includes minor amendments to remove the requirement that these signs may only be approved as part of a Comprehensive Sign Program.
  • C.4.b.(7) Freestanding Signs. Includes a new standard to allow for a freestanding sign to be mounted on two or more posts. A new standard specific to the post signs typically used to advertise a property or building for sale, rent or lease is also included.
  • C.4.b.(14) Window Signs. Includes an amendment to accommodate open signs. Also, the combined area of permanent and temporary window signs has been increased from 25 to 40 percent of the window area.
  • C.4.b.(15) Vehicle Signs (formerly Other Sign Types). This Subsection now only applies to vehicle signs. The standards for fuel pump topper signs have been deleted as these are portable signs not permanent signs; the standards for open signs have been removed (inserted into Window Signs – see above); the standards for vehicle signs have been moved from the Exemptions Subsection into this table and a statement regarding the intent of the regulations has been inserted; and, the standards for vending machines have been deleted as they were hard to apply and enforce.
10-50.100.070  Comprehensive Sign Programs
  • C.  Review. Includes a minor amendment to also allow this Section to also apply to building mounted signs.
10-50.100.080  Sign Design Performance Standards
  • B.   Cumulative Adjustments. Includes a minor amendment to correct an error to ensure consistency with other applicable standards.
10-50.100.090  Portable Signs
  • In order to ensure that the City’s temporary sign regulations are consistent with the US Supreme Court’s decision in the Reed v Town of Gilbert sign case, numerous and significant amendments are proposed in this Section to ensure that the City’s sign provisions are content neutral.
  • The Council directed staff to draft revisions to the Temporary Sign Section to allow temporary signs to be displayed for an indefinite period of time without the need for a permit, subject to various standards that, for example, limited the total area of the signs, their placement on private property, etc. This means that the signs are hardly “temporary”, and staff has suggested instead that they be called “portable signs”.
             Key decision points – Portable Signs:
  • No portable signs will be permitted in public right-of-way (both City and ADOT).
  • No permit will be required for portable signs, except temporary wall banner signs.
  • It was agreed that all portable signs may be displayed for an unlimited period of time and will not be required to be removed at the close of business as originally proposed by staff. An exception is that temporary wall banner signs may only be displayed for 30 days. For this reason as these signs could be in place for extended periods of time and, therefore, are not really “temporary”, they have been called “portable signs”.
  • An area limitation will be established to determine the maximum area of portable signs permitted in residential zones (16 sq. ft.) and non-residential zones (originally proposed as 32 sq. ft. and reduced to 24 sq. ft.). Staff has proposed that the area of temporary wall banners (max. 24 sq. ft.) should not be included in this area limitation
  • Temporary window signs will also not be included in the area allowance for portable signs.
  • The Flagstaff Sign Free Zone as authorized under ARS § 16.1019 is included in the proposed amendments.

  • A.  Purpose. A minor amendment is proposed to eliminate redundant language.
  • B.   General to All.
    • Clarifies that a temporary sign permit is only required for a temporary wall banner sign. It has been renamed as a Temporary Wall Banner Sign Permit.
    • The redundant provisions stating that portable signs may not be illuminated (this standard may be found in Table 10-50.100.090.A) and the sign standard for events on City property approved under a Special Event Permit have been eliminated (See Section 10-50.100.090.B.3).
    • The provision allowing for speech in a traditional public forum has been moved to Section 10-50.100.020.A.4 (Applicability) where it is more appropriately placed.
    • The provision that allows the removal of portable signs in public right-of-way and in clear view zones by City code enforcement staff when a hazard to pedestrian or vehicle traffic is present has been moved to Section 10-50.100.120 (Enforcement).
    • A new standard is proposed that establishes no limitations on the length of time that portable signs may be displayed except for temporary wall banners.
  • C.  Standards for Portable Signs. This Subsection has been significantly shortened and most of the former standards have been eliminated because they were content-based. This includes for example, the standards for various signs (e.g. temporary construction signs, signs for temporary uses, new occupancy or use signs, grand opening signs, directional signs, promotional signs, going-out-of-business signs, etc.). Furthermore, the standards for different sign types (e.g. A-frame or upright signs, feather or vertical banners, and wall banners) have been consolidated into one table (Table 10-50.100.090.B) to eliminate redundancy and to simplify the Code. This Section has also been reorganized as summarized below:
    • 1.   Time, Place and Manner Restrictions for Portable Signs.
      A new Table 10-50.100.090.A provides all the standards applicable to the placement of portable signs. It is divided into three sections: Applicable to All Zones (e.g. includes standards on what elements are prohibited on a portable sign and design and construction standards); Commercial, Industrial and Other Non-Residential Zones; and All Residential Zones (each of these subsections includes standards on period of use, hours of use, allowable sign area and number of signs). A content neutral standard is assured because the sign message is not regulated. However, the total area of portable signs in commercial zones is limited to 24 sq. ft. per business while the total area of portable signs in residential zones is limited to 16 sq. ft. per lot or parcel. This maximum sign area limitation allows for multiple portable signs to be displayed with a variety of messages (may be political, business advertising, or ideological) provided they do not exceed the area limitation. Consistent with Council’s direction provided in the October 8th work session, the area of temporary window signs and temporary wall banners is not included in the total sign area for portable signs.
    • 2.   Standards for Specific Portable Sign types.
      Table 10-50.100.090.B consolidates the area, height, width, and number of signs, etc. standards for various portable sign types, including A-frame or upright signs, feather or vertical banner signs, wall banner signs, and a new sign type, yard signs. End Note #1 allows for various other types of portable signs such as fuel pump topper signs or balloon bobbers. Balloon bobbers are preformed into the shape of a balloon but are not inflated with pressurized air and are typically attached to a short pole or stick. End Note 2 is also proposed to be deleted.
    • 3.   Civic and Non-Profit Events Signs on City Approved Sign Support Structures.
      The standards in this Subsection are unchanged except that a purpose statement has been added that clarifies that signs advertising a community event may be placed on these sign structures rather than the current standard which requires them to be located on the sign structures.
    • 4.   Sign Walkers.
      The existing standards have been simplified to make them easier to apply, and updated to be consistent with Arizona law.
In the alternative, the following options may be considered by the Council (Note that after discussing these options the Planning and Zoning Commission agreed to recommend approval of the approach to sign regulation presented in the attached amendments):
  • OPTION 1: Require a permit for all temporary signs and limit the display time that temporary signs may be displayed (may be anywhere from 60 days to 5 months). Under this option there would be no need for the proposed “portable sign” amendments as the length of time that they would be displayed will be limited. Enforcement and permitting of this option will be challenging and may be burdensome on staff. All temporary signs (except wall banners) could be required to be removed at the close of business (current code standard) or permitted to remain in place overnight (staff’s preferred approach). Note that as all temporary signs would require a permit, this would include political, ideological, real estate, commercial advertising signs, etc.
  • OPTION 2: Do not require a permit for all temporary signs and limit the display time that temporary signs may be displayed (may be anywhere from 60 days to 5 months), Under this option there would also be no need for the proposed “portable sign” amendments. However, it would rely on an honor system with business owners and others placing signs on their property, similar to the approach used for civic/non-profit event banner signs on the City’s sign structures to inform the City when a temporary sign would be displayed and removed within the time frame determined by the Council. Enforcement and management of this option will be challenging and may be burdensome on staff. All temporary signs (except wall banners) could be required to be removed at the close of business (current code standard) or permitted to remain in place overnight (staff’s preferred approach).
 10-50.100.100  Sign Districts of Special Designation
  • A.  Flagstaff Central District. The standards for Neighborhood or District Signs have been moved into the freestanding sign section.
  • B.   Downtown Historic District. The standards for stanchion signs in former Table 10-50.100.090.E (Standards for Temporary Stanchion Signs) have been deleted consistent with the principle of prohibiting all temporary (portable) signs in the public right-of-way. Also, the former prohibition on A-frame and Upright Signs in this Downtown District has been removed, and only feather vertical banners are now proposed to be prohibited in this District.
  • E.   Flagstaff Sign Free Zone. This is a new Subsection included into the Zoning Code pursuant to A.R.S. §16-1019 which enables a municipality to establish a zone based on City rights-of-way in which no portable signs are permitted. Additional amendments have been added to this Subsection to clarify its purpose. This statutory provision further requires that should the Council agree to the establishment of a Flagstaff Sign Free Zone it must be adopted by resolution, in this case, Resolution No. 2016-21, attached.
 10-50.100.110  Nonconforming Signs
  • No amendments proposed.
 10-50.100.120  Enforcement
  • The provisions allowing for the removal of portable signs in public right-of-way and in clear view zones by City code enforcement staff when a hazard to pedestrian or vehicle traffic is present has been moved from the Portable Signs Section.
 10-50.100.130  Appeals
  • No amendments proposed.
 10-50.100.140  Severability
  • No amendments proposed.
Needed Amendments to Other Related Chapters of the Zoning Code
 
Chapter 10-20 Administration, Procedures, and Enforcement:
Division 10-20.40 Permits and Approvals
Section 10-20.40.130 Sign Permits – Temporary Wall Banner Sign Permits
  • B.   Sign Permit Requirement. Includes minor amendments to state that a sign permit is only required for a temporary wall banner.
Chapter 10-80 Definitions:
Division 10-80.20 Definition of Specialized Terms, Phrases, and Building Functions
  • Includes minor amendments to the following definitions:
    • Sign – includes signs for ideological and political purposes
    • Sign, Balloon Bobber – includes a new definition for this sign type
    • Sign, Portable – includes a new definition for this sign type
    • Sign, Post – includes a new definition for this sign type
    • Sign, Temporary – clarifies and simplifies the definition
    • Sign, Temporary A-frame – clarifies and simplifies the definition
    • Sign, Temporary Upright – clarifies and simplifies the definition
    • Sign, Temporary Feather or Vertical Banner – clarifies and simplifies the definition
    • Sign, Temporary Wall Banner – clarifies and simplifies the definition
    • Sign, Temporary Yard – includes a new definition for this sign type.
    • Sign Walker - expands the definition to also allow non-commercial messages.
  • The following definitions are proposed to be deleted:
    • Sign, Menu Display Board
    • Sign, Real Estate
    • Sign, Real Estate Directional
    • Sign, Stanchion
    • Sign Temporary
    • Sign, Temporary Directional
    • Sign, Temporary Event
    • Sign, Temporary New Development/Construction

Section 10-20.50.100.F of the Zoning Code establishes findings for the approval of text amendments. It is staff's recommendation that the Council may find that the proposed amendments to Division 10-50.100 (Sign Standards) and other related Divisions meets the following findings:

Findings for Text Amendments:
  1. The proposed amendment is consistent with and conforms to the objectives and policies of the General Plan and any applicable specific plan;
  2. The proposed amendment will not be detrimental to the public interest, health, safety, convenience or welfare of the City; and
  3. The proposed amendment is internally consistent with other applicable provisions of this Zoning Code.
Expanded Financial Considerations:
None.
Community Benefits and Considerations:
Flagstaff residents and business owners, users of the City's sign standards, and City staff will benefit from the adoption of these proposed amendments as they will fix known deficiencies and redundancies in the standards, simplify the permitting processes for temporary (portable) signs, clarify and simplify standards and procedures, and importantly, provide consistency with the US Supreme Court's decision in the Reed v. Town of Gilbert sign case by ensuring that the sign standards do no contain content-based regulations.
Community Involvement:
INFORM, CONSULT, and INVOLVE
Once a preliminary draft of the proposed amendments to the Sign Standards was completed, staff has engaged with members of such local organizations as Friends of Flagstaff’s Future, Northern Arizona Builders Association, Northern Arizona Association of Realtors, and the Flagstaff Chamber of Commerce Economic Development Committee to solicit their comments and reaction to the amendments. Also, a number of articles were published in the Flagstaff Business News and Cityscape, and staff has participated in frequent interviews on KAFF Radio.
 
Consistent with state law and the requirements of the Zoning Code the Planning and Zoning Commission held a work session on the proposed sign code amendments on February 10, 2016. No residents were in attendance and no comments were provided to the Commission. The Council also held a work session on December 8, 2015 on the proposed amendments at which time general policy direction was provided to staff. No residents spoke to the Council at that work session.
 
In advance of all Council and Planning and Zoning Commission work sessions as well as the Commission’s February 24th public hearing, staff has sent out an email to local stakeholder organizations such as Friends of Flagstaff’s Future, Northern Arizona Builders Association, Northern Arizona Association of Realtors, and the Flagstaff Chamber of Commerce Economic Development Committee. These groups were requested to forward the email to their members. Interviews with KAFF radio have also been scheduled regularly, and posts to the City’s Facebook accounts have been posted. Further, in compliance with state law and the Zoning Code’s noticing requirements, a ¼ page display advertisement (larger than the minimum required 1/8 page ad) was printed in the Arizona Daily Sun in advance of all public meetings and public hearings of the Planning and Zoning Commission and the City Council.

About six members of the public attended the Planning Commission's February 24th public hearing, but none chose to speak to the Commission. At this meeting the Commission unanimously recommended that the Council approve the amendments to Division 10-50.100 (Sign Standards) attached to Resolution 2016-13.
Expanded Options and Alternatives:
  1. Adopt Resolution 2016-21 designating a sign free zone within the City pursuant to A.R.S. § 16-1019(F).
  2. Do not adopt Resolution 2016-21, and therefore, do not designate a sign free zone within the City pursuant to A.R.S. § 16-1019(F).
  3. Adopt Resolution 2016-13 declaring that document entitled “2016 Amendments to City Code Title 10, Zoning Code, Division 10-50.100 (Sign Standards) and Other Related Amendments”  to be a public record.
  4. Do not adopt Resolution 2016-13 and, therefore, do not declare that document entitled “2016 Amendments to City Code Title 10, Zoning Code, Division 10-50.100 (Sign Standards) and Other Related Amendments”  to be a public record.
  5. Adopt Ordinance 2016-22 to amend the Zoning Code's sign standards (Division 10-50.100 (Signs Standards)) and other related chapters of the Zoning Code.
  6. Modify and adopt Ordinance 2016-22 to amend the Zoning Code's sign standards (Division 10-50.100 (Signs Standards)) and other related chapters of the Zoning Code.
  7. Do not adopt Ordinance 2016-22 and, therefore, do not amend the Zoning Code's sign standards (Division 10-50.100 (Signs Standards)) and other related chapters of the Zoning Code.

Attachments
Overview - Reed v. Town of Gilbert
Res. 2016-21
Res. 2016-13
Sign Standards Amendments TrackChanges Version
Ord. 2016-22
PowerPoint Presentation


    

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 27-Apr-24 07:09 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2251, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
15 ms 15 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/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
203 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 @ 07:09:35.035
			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 @ 07:09:35.035
				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 @ 07:09:35.035
			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 @ 07:09:35.035
				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 @ 07:09:35.035
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 07:09:35.035
	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 @ 07:09:35.035
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:09:35.035
		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 @ 07:09:35.035
	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 @ 07:09:35.035
		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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
		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 @ 07:09:35.035
		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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:09:35.035
	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=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:09:35.035
		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) = 2016-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2016-06-30 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 07:09:35.035
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 474 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 07:09:35.035
 		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 @ 07:09:35.035
 		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 @ 07:09:35.035
		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 @ 07:09:35.035
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 475 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=16ms, Records=21) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 475 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
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 = 474 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 = 475 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 @ 07:09:35.035
		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 @ 07:09:35.035
		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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
			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 @ 07:09:35.035
			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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
			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 = 2251 AND
				      u.rev_num = 0 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
				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 @ 07:09:35.035
					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) = 2016-06-07

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
		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 @ 07:09:35.035
		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=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2251 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 @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2251 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=15ms, Records=6) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
	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 = 2251 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 @ 07:09:35.035
		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 @ 07:09:35.035
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 2251 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 @ 07:09:35.035
	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 = 2251 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 @ 07:09:35.035
	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 = 2251 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=8) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
		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 = 2251 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:09:35.035
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 07:09:35.035
		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) = 475

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 07:09:35.035
				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 = 474 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 = 11617 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 07:09:35.035
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 474
					AND a.ag_level1 = '16'
					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 @ 07:09:35.035
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 474
					AND a.ag_level1 = '16'
					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 @ 07:09:35.035
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 474
					AND a.ag_level1 = '16'
					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 @ 07:09:35.035
					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 @ 07:09:35.035
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 2251 AND
					      rev_num = 0
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 07:09:35.035
	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 @ 07:09:35.035
	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 @ 07:09:35.035
		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 @ 07:09:35.035
		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=
HTTP_ACCEPT_LANGUAGE=
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=6&get_year=2016&dsp=agm&seq=2251&rev=0&ag=474&ln=11617&nseq=&nrev=&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=6&get_year=2016&dsp=agm&seq=2251&rev=0&ag=474&ln=11617&nseq=&nrev=&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=9325760
cftoken=d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
hitcount=4
lastvisit={ts '2024-04-27 07:09:35'}
timecreated={ts '2024-04-27 07:09:35'}
urltoken=CFID=9325760&CFTOKEN=d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
Cookie Variables:
CFID=9325760
CFTOKEN=d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=474
DISPLAY_ID=2251
DISPLAY_REV=0
Session Variables:
cfid=9325760
cftoken=d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9325760_d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
subdir=/public/
tzoffset=0
urltoken=CFID=9325760&CFTOKEN=d07b9aecee7da8d9-3EB83218-B3A8-2355-63A29D438FF6940C
URL Parameters:
ag=474
dsp=agm
get_month=6
get_year=2016
id=
ln=11617
mt=ALL
nrev=
nseq=
prev=
pseq=
rev=0
seq=2251
Debug Rendering Time: 16 ms