City Council Meeting - DRAFT


Return to the Search Page Return to the Agenda
  15.D.       
Meeting Date: 11/03/2014  
From: Roger Eastman, Zoning Code Administrator

Information
TITLE:
Consideration and Adoption of Resolution No. 2014-35 and Ordinance No. 2014-27:  Proposed amendments to Flagstaff Zoning Code Chapter 10-50 (Supplemental to Zones), specifically Division 10-50.100 (Sign Standards), and related amendments to Chapter 10-20 (Administration, Procedures and Enforcement), Chapter 10-80 (Definitions), and Chapter 10-90 (Maps); consideration of Resolution No. 2014-35 declaring the proposed amendments as a public record; and adoption of Ordinance No. 2014-27, adopting amendments to Flagstaff Zoning Code Chapter 10-20 (Administration, Procedures and Enforcement), Chapter 10-50 (Supplemental to Zones), specifically Division 10-50.100 (Sign Standards), Chapter 10-80 (Definitions), and Chapter 10-90 (Maps), by reference. 
RECOMMENDED ACTION:

At the Council Meeting of November 3, 2014
1) Adopt Resolution No. 2014-35 (declaring a public record)
2) Read Ordinance No. 2014-27 for the final time by title only
3) City Clerk reads Ordinance No. 2014-27 by title only (if approved above)
4) Adopt Ordinance No. 2014-27

Policy Decision or Reason for Action:
The Council held three work sessions in 2014 to discuss the need for, and provide direction on, possible amendments to the Sign Standards (Division 10-50.100) of the Flagstaff Zoning Code. These amendments are now presented to the Council for review and adoption.
Financial Impact:
Council's possible adoption of the proposed amendments to the Sign Standards will not have a financial or budgetary impact on the Comprehensive Planning and Code Administration Program's budget. Later this year a proposal to amend the City's fee schedule will be presented to the Council for review and possible adoption. Proposed amendments to the fee schedule will establish a sliding fee for sign permits based on the area and complexity of the sign, rather than the flat fee charged now regardless of sign area and the time required for the permit's review.
Connection to Council Goal and/or Regional Plan:
COUNCIL GOALS:
11. Effective governance

REGIONAL PLAN:
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.”
The proposed amendments to the sign standards streamline, simplify, and improve the standards to provide flexibility and maintain a positive community image, while supporting the needs of business owners.
Has There Been Previous Council Decision on This:
The Council has held three work sessions to provide direction to staff on proposed amendments to the Sign Standards - April 11th, May 12th, and July 8th. Council also held a meeting/work session on October 14th, and the Resolution was read by title only and first read of the Ordinance was held at the October 21, 2014, Council meeting.
Options and Alternatives:
Please refer to the Expanded Options and Alternatives below.
Background/History:
Since the adoption on November 1, 2011 of the Flagstaff Zoning Code by the City Council, planning staff, as well as staff that work with the Zoning Code on a regular basis (i.e. from the engineering, traffic, stormwater, housing, or legal sections/divisions), have documented sections of the Code where possible amendments would be required. Ideas for amendments submitted by Flagstaff residents have also been received and are being compiled with staff’s suggested revisions into a comprehensive document of suggested revisions to the Code.
 
In a work session on April 11, 2014 the Council prioritized amendments to Division 10-50.100 (Sign Standards) over other needed changes to the Zoning Code. All other proposed amendments to the Zoning Code will be forwarded to the Planning and Zoning Commission and Council later this year or in early 2015. At a subsequent work session held on May 12, 2014 the Council provided specific suggestions and direction on where amendments were needed. Ultimately in a work session on July 8, 2014 the Council confirmed that draft amendments prepared by staff were consistent with their direction, and requested that the final amendments were to be presented for review and adoption as soon as possible.
Key Considerations:
The amendments proposed to the City’s sign standards attached to Resolution No. 2014-35 are based on direction from the Council at the work sessions on July 8, 2014 and October 14, 2014.

A report describing the proposed amendments as recommended for approval by the Planning and Zoning Commission is attached. This report provides a detailed overview of the more significant amendments warranting further explanation.

The memo to Council dated October 8, 2014 and the Track Changes version of most of the draft amendments that shows the majority of new text in underline and text to be deleted in strikeout have not been included with this Staff Summary as they were previously provided to the Council for the October 14th meeting.
 
Also attached to this report is an updated table that summarizes the more significant changes to Division 10-50.100 (Sign Standards) based on whether a proposed change is more restrictive or less restrictive, or if it is proposed for deletion. A new column to the far right of the table describes the intention behind the proposed amendment and its source, i.e. Council or staff. The table also includes more detail on standards that are proposed to be increased or decreased, and any subjective statements have been removed. All changes are made in Track Changes format.

Follow-up from October 14th Meeting
During the October 14th public meeting the Council provided direction to staff on where certain changes to the amendments to City's Sign Standards were necessary. Also, additional supporting information in the form of tables, photographs, and/or illustrations was requested. A summary and description of these changes follows (note that the page number referred to below is the page number in the Amendments attached to Resolution No. 2014-27):

Page 50.100-8: Section 10-50.100.020 (Applicability), D (Exemptions) #11, Nonstructural Modifications and Maintenance: Amend paragraph b. so that face changes for all existing non-illuminated signs are exempt, regardless of whether they are conforming or nonconforming signs.

Page 50.100-18: Section 10-50.100.050 (General Requirements for All Signs), C (Sign Illumination) #2, Internally Illuminated Sign Standards: Amend paragraph a. to also include yellow as a background color that is not permitted.

Page 50.100-33: Table 10-50.100.060.H (Standards for Freestanding Signs): Under the section the "Street Type" sub-heading of this table add an End Note #3 which refers to the Nonconforming Signs Section (Section 10-20.60.110).

Page 50.100-63: Table 10-50.100.100.A (Standards for Building Mounted Signs in Flagstaff Central District): Correct the third row "Number of Signs" to read as "Number of Building Entries + 1" to be consistent with the current standard for number of signs per business in the Central District (i.e. two signs) and the approach established in this table for determining the total amount of sign area for a building.

Page 50.100-86: Section 10-80.20.020 (Definitions, "B."): Correct the definition of "building entry zone" to include a route between the primary building entrance and an associated parking area on a walkway.

Page 50.100-91: Section 10-20.40.130 (Sign Permits – Temporary Signs), D (Review and Approval) #1, Application: The alternate text originally suggested by staff under which the responsibility for applying for a temporary sign permit by a business owner has been deleted. After discussing this issue, staff agrees with the Council that there are benefits to having a landlord or property manager act as the agent on behalf of his/her tenants/business owners.

Page 50.100-100: Section 10-20.60.110 (Nonconforming Signs), B. Maintenance, Repairs, Alterations, and Removal. Two significant amendments are proposed in this Section in response to Council's discussion on how best to incentivize the reduction in height and area of existing nonconforming signs. In paragraph 3, staff and the Planning and Zoning Commission suggested that a new freestanding sign may replace an existing nonconforming sign if it is no more than 75% the height and area of the existing nonconforming sign. During the Council discussion on October 14th it was realized that this idea still did not work that well, and it was suggested that staff should explore whether it made sense to apply the percentage to the standard for a new freestanding sign, i.e. 10 feet in height and 40 square feet in area. Staff has conducted this testing, and realized that this solution still did not produce a good result. After thinking about it further, staff suggests that a better solution would be simply create the incentive by allowing an existing nonconforming sign to be replaced with one that is 25% lower and smaller in area than the existing sign. For example, an existing nonconforming Type A freestanding sign has an area of 120 sq. ft. and a height of 22 feet. The Zoning Code only allows a Type A freestanding sign to have an area of 40 sq. ft. and a height of 10 feet. The new sign, therefore, may be 120 x 25% = 30 sq. ft.; 120 – 30 = 90 sq. ft. in area. The height of the new sign would be determined as 22 x25% = 5.5 feet; 22 – 5.5 = 16.5 feet high. If this approach is accepted by Council, then staff recommends that the text in the previous draft that established a sunset date of five years for this provision is no longer necessary because it is beneficial to allow a property owner to use this regulation at any time. The new text inserted into this paragraph also clarifies that any existing nonconforming sign modified in accordance with the provisions of this Subsection will still be considered a nonconforming sign until full compliance with the area and height standards of Section 10-50.100.060 (Permanent Signs) has been achieved.

Staff has also inserted a new paragraph 4 in this Section to clarify what a property owner may do if they have an existing nonconforming freestanding sign. The current sign standards require a property frontage of min. 500 feet on a major arterial to allow the placement of a Type A and a Type B freestanding sign. The proposed code amendments reduce the frontage requirement from 500 feet to 400 feet to make it easier for property owners to erect a Type B sign if they choose to. Staff suggests that new text should be added in this paragraph to clarify a property owners right to remove and or modify an existing nonconforming Type A freestanding sign with a conforming Type A sign so that a new Type B freestanding sign may be erected to the full height and area allowed in Table 10-50.100.060.A (Standards for Permanent Signs by Use). On the other hand, if the property owner chooses to keep the existing nonconforming sign, they are fully entitled to do so, and they could reduce the height and area by 25% to modernize and improve the sign as allowed in paragraph 3 of this Section.

How do the proposed amendments help small business owners?
During the discussion at the October 14th public meeting, some members of the public suggested that the sign code amendments favored corporations over small business owners in the community. Staff has not conducted an exhaustive review of the proposed amendments to determine if they support or hinder small business owners in the City, but offers the following as examples of some of the changes proposed that will make it easier for small business owners to advertise their businesses.
  • Painted building mounted signs offer an affordable alternative to individual letter or cabinet signs.
  • Standards are provided to allow for more tenant space on freestanding signs.
  • The number of signs and the amount of total sign area for a building and an individual business in a multi-tenant building in the Central District has been increased.
  • A new standard allows business owners in the Downtown Historic District to place stanchion signs in the furniture zone on the sidewalk to advertise promotional or seasonal sales. Under the current regulations these are prohibited.
  • A new standard incentivizes the installation of a corner sign on the corner of a building.
  • If a simple face change is proposed in a non-illuminated sign as a result of a change of tenants, no permit and review is necessary.
  • The proposed amendments to the Sign Standards are intended to make them simpler, easier to read and understand, and apply.
  • Businesses permitted under a Temporary Use Permit have enhanced signage opportunities, including the ability to install directional signs.
  • Display boards to advertise daily specials (not limited to bars or restaurants) may be placed outside a business.
  • Revised standards for temporary signs ensure greater equity for all businesses.
  • Changes to the fee schedule will be proposed (this will be presented to the Council separately) to establish fees based on a sign’s size and the complexity of its review, rather than the flat fee in use today.
  • Enhanced opportunities for advertising civic and non-profit events are included.
Illustrate how the Sign Code applies to signs facing a freeway (Interstate 17 or 40)
An illustration will be presented to the Council in advance of the October 21st meeting to show the conditions under which building mounted signs may face an interstate freeway.

Update and provide clarification on the signs associated with Dunkin Donuts and Chick-Fil-A.
An update and clarification of the review process for the signs now associated with the building in which Dunkin Donuts is located and Chick-Fil-A located at 1000 S. Milton Road was requested. This property was formerly developed as a gas station (Varsity Gasser) on the northeast corner of S. Milton Road and Riordan Road, and a building most recently used by New Frontiers. After New Frontiers moved to their new location, the building remained vacant for an extended period of time. When the property was redeveloped as the two buildings that exist today (one for Chick-Fil-A and the other for three separate restaurants including Dunkin Donuts) with site plan approval granted on March 12, 2012, staff also processed requests for sign permits. Staff determined that the former freestanding sign used to advertise the New Frontiers store had lost its nonconforming rights as established in Section 10-20.60.110 (Nonconforming Signs) and that it needed to be removed and a new sign erected in its place. The property owner agreed with this determination, and a new sign for Chick-Fil-A was erected in compliance with current sign code standards. Staff also determined that the former Varsity Gasser sign located on the east side of S. Milton Road was a legal nonconforming sign, and that it was entitled to remain in place. This was because the property was never abandoned, and the use was not discontinued for longer than 180 days. Staff nonetheless met with the property owner to determine if she would be interested in removing the existing nonconforming sign structure and to build a new sign that was closer aligned to the architecture of the project. After considering the proposal, she declined arguing that she had the legal right to continue to use the existing sign structure for the tenants in her building. She did agree to add stone to the base of the sign to match the stone work in the building. It is for this reason that the existing nonconforming sign structure was retained and incorporated into the project.

Summary of height and area changes
A summary in more detail of where the increases and reductions in sign standards are proposed was also requested. Staff has included this detail in the updated Summary of Changes to Division 10-50.100 (Sign Standards) - see attached.

Explain enforcement issues with vehicles parked as signs
Section 10-50.100.040.A (Location Restrictions) – Page 50.100-11 – provides revised standards that apply to vehicles intentionally parked to advertise a business. This concept is common in most sign codes in effect across the country, and indeed was included as a prohibition in the former Land Development and is included in the current Zoning Code. However, as written this standard is difficult to enforce as it is not as precise and clear as it could be. For this reason staff researched many other sign codes in effect in Arizona and in the US to determine how the section could be improved. Note that this section of the sign standards is not intended to prohibit the placement of advertising on a vehicle, and neither does it restrict the vehicle’s use during the normal daily conduct of the business. However, it does preclude a business owner from intentionally parking a truck or other vehicle as a sign to advertise their business. With this in mind, the amendment requires that when a vehicle is not being used to conduct daily business, it must be parked so as not to be visible from the public right-of-way, or if this is impractical, then it must be parked as far back from the public right-of-way as possible. Examples of vehicles parked intentionally as signs in the City (all of which have received notice from the City that they are in violation) will be provided to the Council in advance of the October 21st meeting.
Expanded Financial Considerations:
Not applicable.

Community Benefits and Considerations:
The sign standards incorporated within the City's former Land Development Code generally worked reasonably well, although they were poorly written. At the time of the rewrite of the Land Development Code prior to adoption of the current Zoning Code adopted in November 2011, the sign standards were reformatted (e.g. paragraphs of text were consolidated into tables) but the standards themselves were not significantly changed, except with regard to building mounted signs where new placement standards were included, freestanding signs where standards for height and area have been moderately increased, and temporary signs. While Council and staff have heard some criticism of the proposal to moderately increase the height and area of freestanding signs, the intention behind this proposed increase is to reduce the clutter caused by the prevalence of many temporary signs in the City (many of which are semi-permanent) by allowing better signage opportunities for business owners in a more manageable way on a freestanding sign.

Staff, business owners, Flagstaff residents, and members of the Council soon realized that the sign standards were not effective as they could be, and they still presented issues by being complex in certain areas, hard to read and understand, and prone to inconsistency in interpretation.

The proposed amendments to the Sign Standards attempt to resolve these problems. Standards have been simplified, and unnecessary or duplicative standards have been removed (e.g. Building Mounted Signs). New standards to allow sign types not previously allowed in the current code have been included (e.g. Interpretative Signs). Further the standards have been reformatted so they are more logically organized, text has been simplified, tables have been consolidated, improved illustrations will be inserted, and a document that will be easier to read, interpret, and apply will result. 

The amendments to the Sign Standards are, therefore, a benefit to the community as they provide for and support the needs of business owners by establishing simpler, clearer, and more understandable standards that will allow them greater opportunities for advertising and promoting their businesses. Consistent with the Flagstaff Regional Plan though, the proposed amendments will also ensure that the aesthetic beauty of the City's natural and built environment is protected.
Community Involvement:
INFORM, CONSULT, and INVOLVE In a work session on April 11, 2014, the Council directed staff to complete amendments to Division 10-50.100 (Sign Standards) of the Zoning Code as a priority over other amendments to the Zoning Code. In two subsequent work sessions (May 12th and July 8th), Council confirmed that draft amendments prepared by staff were consistent with their direction, and requested that the final amendments were to be presented for review and adoption as soon as possible. Some members of the public participated in these work sessions and provided comment to the Council when invited to do so.
 
Staff has invited representatives from local sign companies to be involved in the development of the proposed amendments, some of whom participated in meetings with staff at City Hall. The proposed amendments were also presented to 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. Staff was also interviewed by KAFF radio on the proposed sign amendments on two occasions before and after the Planning and Zoning Commission's public meeting and public hearing, and on October 15th following the Council's last meeting.
 
A ¼ page display advertisement was printed in the August 8th and 10th Arizona Daily Sun in advance of an open public meeting at City Hall on August 11th as well as the August 13th Planning and Zoning Commission work session. The open public meeting at City Hall on August 11th was attended by five City residents who provided useful ideas on the proposed amendments, some of which were included in the amendments later presented to the Commission on August 27th. 


At the August 13th Planning and Zoning Commission work session three citizens addressed the Commission and provided their perspective on the proposed amendments to the Flagstaff Zoning Code. The commissioners also provided their own opinions on the proposed amendments. As a result of these suggestions, further refinements were made and presented to the Commission on August 27th.

A legal notice was printed in the August 12, 2014 Arizona Daily Sun at least 15 days in advance of the Planning and Zoning Commission’s August 27th public hearing as required by the Zoning Code. Three members of the public addressed the Planning and Zoning Commission at their August 27th public hearing. Following the public comment period and some discussion, the Commission moved to recommend approval of the proposed amendments to the Sign Standards subject to three amendments as listed below:
  • Section 10-50.100.020.D. (Exemptions) - Subsection 9; Also include banner signs posted at City recreation facilities.
  • Section 10-50.100.060 (Permanent Signs) - Subsection(11); Reinsert the standards to allow for roof mounted signs.
  • Section 10-20.60.100 (Nonconforming Signs) - Paragraph B.3 (Maintenance, Repairs, Alterations, and Removal); Change the incentive value from 50 to 75 percent as the threshold to bring an existing nonconforming sign into closer compliance with the sign standards.
In mid/late August staff was able to insert a flyer into a mailing that was delivered to over 8,000 Flagstaff business owners who report sales tax to the City. This flyer was designed to inform recipients of the proposed amendments to the sign standards, tell them about the upcoming City Council public hearing, provide contact information if they had questions or comments on the amendments, and provide a link to the proposed amendments at the Zoning Code webpage - www.flagstaff.az.gov/zoningcode.

The City Council's October 21st public hearing was advertised with a legal notice in the Arizona Daily Sun on October 3rd.

When discussing the proposed amendments to the City's sign standards with stakeholder groups or individuals, staff has been upfront and clear on the scope of the amendments, and has explained when sign height and area increases are proposed or will be reduced, and has also clearly described the proposed changes as they affect the Downtown Historic and Central Districts, and especially, temporary signs. While admittedly turnout has often been low at meetings, staff has gathered useful ideas and suggestions from meeting participants that have been included in the proposed amendments.
Expanded Options and Alternatives:
  1. Adopt Resolution No. 2014-35 declaring that the document entitled “2014 Amendments to Chapter 10-50, Supplemental to Zones, Specifically Division 10-50.100, Sign Standards” to be a public record
  2. Do not adopt Resolution No. 2014-35 and, therefore, do not declare the proposed amendments to be a public record
  3. Adopt Ordinance No. 2014-27 to amend Flagstaff Zoning Code Division 10-50.100 (Sign Standards) with related amendments in Chapter 10-20 (Administration, Procedures, and Enforcement), Chapter 10-80 (Definitions), and Chapter 10-90 (Maps).
  4. Modify and adopt Ordinance No. 2014-27 to amend  Division 10-50.100 (Sign Standards) with related amendments in Chapter 10-20 (Administration, Procedures, and Enforcement), Chapter 10-80 (Definitions), and Chapter 10-90 (Maps).
  5. Do not adopt Ordinance No. 2014-27 and, therefore, make no changes to the existing text in the Zoning Code regarding the sign standards.

Attachments
Res. 2014-35
Ord. 2014-27
Updated Summary of Changes

<
Form Review
Inbox Reviewed By Date
City Clerk lburke 09/10/2014 08:44 AM
Legal Assistant Vicki Baker 10/10/2014 11:41 AM
Deputy City Attorney Kevin Fincel 10/10/2014 12:04 PM
Form Started By: reastman Started On: 09/08/2014 02:16 PM
Final Approval Date: 10/24/2014

    

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 03-May-24 11:52 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
235 ms 235 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
188 ms 188 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(1413, 2, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.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
235 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 @ 11:52:42.042
			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 @ 11:52:42.042
				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 @ 11:52:42.042
			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 @ 11:52:42.042
				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 @ 11:52:42.042
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:52:42.042
	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 @ 11:52:42.042
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:52:42.042
		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 @ 11:52:42.042
	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 @ 11:52:42.042
		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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
		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 @ 11:52:42.042
		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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:52:42.042
	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=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:52:42.042
		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) = 2014-10-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2014-10-31 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=16ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 11:52:42.042
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 287 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 11:52:42.042
 		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 @ 11:52:42.042
 		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 @ 11:52:42.042
		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 @ 11:52:42.042
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 287 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 287 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 @ 11:52:42.042
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 = 287 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 = 287 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 @ 11:52:42.042
		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 @ 11:52:42.042
		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 @ 11:52:42.042
			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 @ 11:52:42.042
			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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
			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 = 1413 AND
				      u.rev_num = 2 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
				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 @ 11:52:42.042
					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) = 2014-11-03

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
		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 @ 11:52:42.042
		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 @ 11:52:42.042
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 1413 AND
      rev_num = 2
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	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 @ 11:52:42.042
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 1413 AND ag_memo_dol.rev_num = 2
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	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 = 1413 AND
		  ad.rev_num = 2 
		  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 @ 11:52:42.042
		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 @ 11:52:42.042
		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 @ 11:52:42.042
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 1413 AND
		      rev_num = 2
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	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 = 1413 AND form_rte.rev_num = 2 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	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 = 1413 AND
		  rev_num = 2 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=32ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
		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 = 1413 AND
			  hist.rev_num = 2 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:52:42.042
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:52:42.042
		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) = 287

GetThisLine (Datasource=frsRO, Time=46ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:52:42.042
				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 = 287 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 = 7308 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:52:42.042
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 287
					AND a.ag_level1 = '17'
					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 @ 11:52:42.042
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 287
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'D'
					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 @ 11:52:42.042
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 287
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'D'
					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 @ 11:52:42.042
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 11:52:42.042
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 1413 AND
					      rev_num = 2
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:52:42.042
	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 @ 11:52:42.042
	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 @ 11:52:42.042
		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 @ 11:52:42.042
		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=10&get_year=2014&dsp=agm&seq=1413&rev=2&ag=287&ln=7308&nseq=1462&nrev=0&pseq=1450&prev=0
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=2014&dsp=agm&seq=1413&rev=2&ag=287&ln=7308&nseq=1462&nrev=0&pseq=1450&prev=0
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9484017
cftoken=3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
hitcount=4
lastvisit={ts '2024-05-03 11:52:42'}
timecreated={ts '2024-05-03 11:52:42'}
urltoken=CFID=9484017&CFTOKEN=3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
Cookie Variables:
CFID=9484017
CFTOKEN=3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=287
DISPLAY_ID=1413
DISPLAY_REV=2
Session Variables:
cfid=9484017
cftoken=3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9484017_3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
subdir=/public/
tzoffset=0
urltoken=CFID=9484017&CFTOKEN=3dd43501ee366e9a-7DD0DB9E-B0F5-0330-22244C85D20508E6
URL Parameters:
ag=287
dsp=agm
get_month=10
get_year=2014
id=
ln=7308
mt=ALL
nrev=0
nseq=1462
prev=0
pseq=1450
rev=2
seq=1413
Debug Rendering Time: 0 ms