City Council Meeting - FINAL


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

Information
TITLE:
Consideration and Adoption of Ordinance No. 2014-07 and Resolution No. 2014-10:  Resolution No. 2014-10 Declaring the proposed amendments as a public record; and adoption of Ordinance No. 2014-07, Adopting Amendments to that certain document entitled “Division 8-03-002, Sidewalk Cafes, Sidewalk Vending Carts and Other Permitted Encroachments” (An ordinance deleting North Downtown Business District Encroachment Policy, and replacing it in its entirety with Sidewalk Cafes, Sidewalk Vending Carts, and Other Permitted Encroachments)
RECOMMENDED ACTION:
1) Read Resolution No. 2014-10 by title only
2) City Clerk reads Resolution No. 2014-10 (if approved above)
3) Read Ordinance No. 2014-07 for the first time by title only
4) City Clerk reads Ordinance No. 2014-07 for the first time by title only
 At the April 1, 2014 Council Meeting:
5) Adopt Resolution No. 2014-10
6) Read Ordinance No. 2014-07 for the final time by title only
7) City Clerk reads Ordinance No. 2014-07 by title only (if approved above)
8) Adopt Ordinance No. 2014-07.
Policy Decision or Reason for Action:
The proposed amendments to City Code Division 8-03-002, Sidewalk Cafes, Sidewalk Vending Carts and Other Permitted Encroachments establish updated standards and review procedures for sidewalk cafes and sidewalk vending carts in the downtown and other certain commercial zones.

Subsidiary Decisions Points: A key policy decision will concern the establishment of a defensible procedure for calculating an appropriate lease rate that is fair and reasonable to business owners and that also reasonably compensates the City for the use, by private individuals, of City sidewalks.
Financial Impact:
The proposed amendments establish a new uniform fee for processing the application for a sidewalk café, vending cart, or other encroachment, as well as a uniform methodology for establishing a lease rate for the use of public sidewalks by a business owner for a sidewalk café or vending cart.
Connection to Council Goal:
11. Effective governance

Has There Been Previous Council Decision on This:
At the October 8, 2013 Work Session, the Council reviewed and discussed suggested amendments to Division 8-03-002 developed by staff, received public comment, and provided staff with specific direction on an appropriate path forward.
Options and Alternatives:
Please refer to the Expanded Options and Alternatives below.
Background/History:
Sometime in the early 1970’s, the City Council adopted the North Downtown Business District Encroachment Policy as Division 8-03-002 of the Flagstaff City Code. This ordinance, which was updated in 1996 and 1997, established standards and procedures for the review and approval of commercial encroachments (including sidewalk cafes and vending carts) as well as for permitted encroachments by certain structures (including, for example, overhead encroachments, excavations, and basement access) and encroachments by other activities and objects such as construction, bicycle racks, newspaper vending machines, etc.
 
Division 8-03-002 was specifically written to allow sidewalk cafes and sidewalk vending carts in downtown Flagstaff only, and hence no such encroachments may be permitted in other areas of the City, including the Southside. Many existing Southside businesses have been frustrated because of their inability to establish sidewalk cafes in public right-of-way.
 
Following Council discussion of this issue in October last year, staff from the City Attorney’s office and the Community Development Division has developed amendments to this Division. The draft ordinance incorporates ideas for simplifying and clarifying an approach for the review and issuance of permits for sidewalk cafes and sidewalk vending carts in most commercial zones within the City.
Key Considerations:
Staff has completed amendments to Division 8-03-002 of the Flagstaff City Code. Currently this Division is called “North Downtown Business District Encroachment Policy”, and it will be renamed as “Sidewalk Cafes, Sidewalk Vending Carts, and Other Permitted Encroachments”.
 
The amendments to this Division are based on some of the provisions in Division 8-03-002 which have been kept, as well as ideas from a variety of other cities, including Portland, OR, Seattle, WA, Salt Lake City, UT, Minneapolis, MN, and Redwood City, CA. In the narrative below, staff will describe the principal sections and provisions of the proposed draft ordinance.

Reorganization of the Division. This Division has been reorganized so that, for example, the definitions and appeals sections have been consolidated and certain sections have been rearranged so that the document is more logically organized. The definitions are also arranged alphabetically.

  1. Illustrations. The Division includes illustrations to make it easier to understand key terms, such as “area of operation” and “clear pedestrian zone”.

  2. Applicability. The proposed standards apply to all commercial zones in the City except for the Suburban Commercial (SC) Zone. This is an important difference from the current standards which apply only to the downtown area, currently designated as the Commercial Business (CB) Zone. The proposed ordinance, therefore, would allow business owners in the Southside neighborhood or elsewhere in the City to apply for a sidewalk encroachment permit.

  3. Types of encroachments. The amendments provide standards for three types of encroachments. Permits for sidewalk cafes and sidewalk vending carts encroachments will be administered by Comprehensive Planning and Code Administration Program staff. Staff from the Development Engineering Program will continue to manage the encroachment permits required for work by public and private utilities in the right-of-way, driveway construction, and trash dumpsters placed in the right-of-way when there is no room on a property for them during construction.

  4. Application fee. The amendments contemplate that all applications for sidewalk cafes and sidewalk vending carts will be required to pay an “application fee” to cover the administrative costs of accepting, reviewing and issuing a permit by staff. As changes to the City’s fee schedule are required by Arizona law to be posted to the City’s website for a minimum of 60 days before Council action on the fee, Council consideration of this application fee will be scheduled at a later date.

  5. Annual lease rate: The amendments to Division 8-03-002 also contemplate an annual lease rate, the purpose of which is to compensate the City for use of public sidewalks for commercial purposes. The need for the lease rate arose when it was realized that sidewalk cafes located on Heritage Square were required to pay a license fee for the use of this public space as part of their lease agreements, whereas all other restaurants that had established seating areas on the sidewalks elsewhere in downtown were not required to pay for the use of the sidewalk.
Staff studied the methodology used by other US cities, including Seattle, WA and Corvallis, OR for establishing a defensible procedure for calculating an appropriate lease rate that is fair and reasonable to business owners and that reasonably compensates the City for the use by private individuals of its property. Staff recommends that a single aggregated lease rate should be applied City-wide rather than establish separate fees for different areas of the City. Staff created a matrix to analyze the property values of the parcels historically associated with applications for sidewalk cafes and sidewalk vending carts (see attached). Twelve such parcels were identified, including Heritage Square. Preliminary analysis suggests that the lease rate for use of a City sidewalk would be about $15 per sq. ft.; i.e., $1,800 annually for a 120 sq. ft. sidewalk café operating area. This is derived by taking the average full cash value established by the Coconino County Assessor’s Office for the 12 properties in the downtown and Southside areas, and dividing this value by the area of the parcel. The resultant average land value ($60 per sq. ft.) may then be multiplied by the operating area in sq. ft. and a rate of return value of 25% (i.e. 0.25 over 4 years). Similarly, the cost to the proprietor of a vending cart based on a maximum operating area of 24 sq. ft. would be $360 per year. Note that if the rate of return was calculated over a longer period of time, the annual lease rate would be lower. For example, if the rate of return was calculated over 6 years at 16.67%, then the lease rate for a 120 sq. ft. sidewalk café would be $1,195.

The lease rate proposed above, or as ultimately adopted by the Council, will be applied to business owners who lease sidewalk space for outdoor cafes or vending carts, and will also be applied to business owners who lease portions of Heritage Square for outdoor dining areas. This lease rate will not apply in addition to any established lease amounts (e.g., for Cuvee 928 or Monsoon's), and it would only apply once any current lease agreements terminate. 
  1. Permitting requirements and conditions of permits. The ordinance establishes the need for a permit for use of public sidewalks for sidewalk cafes and sidewalk vending carts, as well as other permitted encroachments consistent with existing City Code requirements. It also establishes minimum submittal requirements, including proof of liability and insurance, as well as procedures for review.

  2. Denial, revocation or suspension of permits, and permit renewal. This section provides a procedure and standards for the denial, revocation or suspension of permits for sidewalk cafes and sidewalk vending carts. Note that the time frame for the renewal of a sidewalk café or vending cart permit has been changed. As the permit fee is for an annual permit, staff realized that applications for renewals of existing permits should be received from September 1st through December 31st. All applications received after December 31st will be processed as a new application. Consistent with the existing ordinance, an appeal process to the City Manager is established.

  3. Location rules. Sidewalk cafes permitted under the current Division have been successful over the past years that staff has administered sidewalk café encroachment permits. Not only do the sidewalk cafés add to the ambiance and character of downtown Flagstaff, the standards in place have ensured that the encroachments do not constrict the sidewalk such that it is difficult for pedestrians to use them, especially those individuals who are mobility impaired. The proposed amendments to this Division are based on lessons learned through the application of the current standards, as well as best practices from other American cities that also permit sidewalk cafes and sidewalk vending carts. The new Division therefore, more clearly prescribes standards for minimum sidewalk width and a clear pedestrian zone relative to a defined area of operation for a sidewalk café. Allowances are also provided for pinch points around elements such as poles or posts supporting signs.

  4. Standards for barriers defining sidewalk cafes. Arizona liquor laws require that barriers are installed to define an area in which alcohol is served, and federal Americans with Disabilities Act (ADA) standards require that barriers in public places meet certain standards so that, for example, a blind person with a cane can reasonably locate and move around the barrier. There are no minimum standards in the current code regarding the design and placement of barriers. The amendments, therefore, include a provision that requires barriers to harmonize with adjacent building’s design, be moveable and not permanently attached to the sidewalk, and be constructed of high-quality durable materials. Appropriate standards to ensure compliance with ADA regulations are also included.

  5. Sidewalk vending carts. The location and permitting regulations for sidewalk vending carts remain essentially unchanged from the existing regulations consistent with the Council’s direction provided at the October 8, 2013 work session. The operating area for a sidewalk vending cart has been increased to 32 sq. ft. as staff realized that the area of 24 sq. ft. proposed in the October 8th draft was too small for a vending cart, operator, and trash receptacle.

  6. Other Permitted Encroachments. This section remains essentially unchanged from the current regulations in Division 8-03-002, except that it has been updated and text has been clarified. Encroachments by such elements as bicycle racks, newspaper vending machines, potted plants, and mail boxes continue to be permitted, as do overhead encroachments, columns, and basement access. Similarly, permits will continue to be issued by the Engineering Section to allow construction activities in public rights-of-way, and to allow for the placement of waste containers in the right-of-way where there is no other location on-site for them to be placed.

  7. Penalty for Violation and Abatement. Consistent with all City Code provisions, penalties are established for violations of Division 8-03-002, and authority is granted to the City to pursue summary abatement of a condition that creates “a risk of serious injury to persons or property”.
Expanded Financial Considerations:
As explained above, a key decision point for the Council will be the establishment of a defensible procedure for calculating an appropriate lease rate that is fair and reasonable to business owners and that also reasonably compensates the City for the use by private individuals of its property; i.e., sidewalks.
Community Benefits and Considerations:
The current standards in Division 8-03-002, North Downtown Business District Encroachment Policy, have allowed for the establishment of sidewalk cafes and sidewalk vending carts in the downtown area. Bars and restaurants who have taken advantage of these regulations to establish seating areas on the public sidewalk have reported that their sales have increased making their businesses more profitable. Owners of sidewalk vending carts have also reported similar results. While increased business activity is beneficial to individual business owners, it also results in increased sales tax revenues to the City. Perhaps more importantly, the character and ambiance of downtown is significantly enhanced by sidewalk cafes and sidewalk vending carts, a fact that has been noted by many downtown businesses and the Downtown Business Association. The proposed amendments to Division 8-03-002 are intended to continue to allow sidewalk cafes and sidewalk vending carts, so that the advantages described above may continue to be realized. However, other benefits result from these amendments, including the ability of business outside of the downtown area to also establish sidewalk cafes and sidewalk vending carts; the regulations have been clarified to eliminate confusing or contradictory regulations; enhanced protections for pedestrian use of sidewalks have been included; requirements for barriers around sidewalk cafes have been improved to assure architectural compatibility with buildings and to comply with ADA regulations; and, a mechanism to ensure the City is fairly compensated for private use of public rights-of-way is established. Furthermore, the existing regulations for other permitted encroachments that allow, for example, for the placement of a dumpster in public right-of-way when there is no space for it on a construction site, have been clarified.
Community Involvement:
INFORM, CONSULT, & INVOLVE - Prior to the October 8, 2013 Council work session, staff provided a letter to business owners in the downtown and Southside who have utilized a sidewalk café and vending cart, or who have expressed interest in applying for a permit for one. This letter was also provided to the Downtown Business Association (DBA) and the Flagstaff Chamber of Commerce. On February 18, 2014 an updated letter was hand delivered to 16 business owners in the downtown and Southside neighborhood, as well as to the DBA and Chamber of Commerce so that they would be informed of the proposed amendments and upcoming hearings/meetings with the Council.
 
City staff attended the DBA’s weekly meeting on February 24, 2014 to discuss the proposed amendments to Division 8-03-002. While the concept of permitting sidewalk cafes and sidewalk vending carts is supported by the DBA because, for example, they add to the ambiance and character of the downtown area, many members were concerned that the cost of the application fee and the permit fee was too high and that this would discourage businesses from applying for the permit. Staff explained why it was important and necessary to have a uniform fee for the use of public right-of-way by private businesses, and that ultimately the Council would decide on the amount of the fee (note the permit fee for a sidewalk café would apply to both Heritage Square and public sidewalks; however, no vending carts are permitted in Heritage Square).
 
City staff also presented the proposed amendments to a number of City Commissions and Committees, as summarized below:


Pedestrian Advisory Committee – December 12, 2013 and January 9, 2014. The Committee reviewed the proposed amendments to Division 8-03-002 and after some questions to staff and discussion the requirements for barriers around sidewalk cafes were supported, including the need for them to meet ADA standards. Further questions on potential obstructions, permitting requirements, and noise issues were answered by staff.
 
Transportation Commission – February 5, 2014. The Transportation Commission listened to staff’s presentation on the sidewalk encroachment amendments, and moved to support the ordinance and recommended approval to the Council.  The Commission reviewed the minutes of the Pedestrian Advisory Committee’s last meeting, and they concurred with each of their points.  The Commission also discussed the requirements for vending carts  and were concerned that they were onerous, specifically the 100% approval requirement. Staff mentioned that a similar discussion had already taken place with the Council last year, and that the Council had directed staff not to change the requirements and standards for vending carts.
 
Disability Awareness Commission – February 25, 2014. After some discussion, during which staff answered questions, the Commission unanimously moved to support the proposed amendments to Division 8-03-002, and recommended their adoption by Council.
 
The public hearing/first reading of the ordinance to adopt the proposed amendments to Division 8-03-002 has been scheduled for March 18, 2014 with the ordinance’s second reading and possible adoption now scheduled for April 1, 2014. The effective date will, therefore, be May 1, 2014. Owners of interested bars, restaurants, and sidewalk vending carts may apply for a Sidewalk Café and Sidewalk Vending Cart Permit on April 2nd, assuming Council adoption of the ordinance. However, permits will only be issued on April 30th in advance of the May 1st effective date.
Expanded Options and Alternatives:
  1. Adopt Resolution No. 2014-10 declaring that the document entitled “Division 8-03-002, Sidewalk Cafes, Sidewalk Vending Carts and Other Permitted Encroachments” to be a public record
  2. Do not adopt Resolution No. 2014-10 and, therefore, do not declare the proposed amendments to be a public record
  3. Adopt Ordinance No. 2014-07 adopting amendments to that certain document entitled “Division 8-03-002, Sidewalk Cafes, Sidewalk Vending Carts and Other Permitted Encroachments”
  4. Modify and adopt Ordinance No. 2014-07 adopting amendments to that certain document entitled “Division 8-03-002, Sidewalk Cafes, Sidewalk Vending Carts and Other Permitted Encroachments
  5. Do not adopt Ordinance No. 2014-07 and, therefore, make no changes to the existing text in Division 8-03-002.

Attachments
Ord. 2014-07
Res. 2014-10.Amended
Analysis


    

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 29-Apr-24 11:49 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
203 ms 203 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
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/Application.cfm
47 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(1128, 1, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/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
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:49:36.036
			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:49:36.036
				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:49:36.036
			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:49:36.036
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:49:36.036
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:49:36.036
	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:49:36.036
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:49:36.036
		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:49:36.036
	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:49:36.036
		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:49:36.036
	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:49:36.036
	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:49:36.036
		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:49:36.036
		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:49:36.036
	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:49:36.036
	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:49:36.036
	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:49:36.036
	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:49:36.036
	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:49:36.036
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=16ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:49:36.036
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:49:36.036
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:49:36.036
		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-03-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2014-03-31 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 11:49:37.037
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 241 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 11:49:37.037
 		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:49:37.037
 		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:49:37.037
		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:49:37.037
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 241 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:49:37.037
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 241 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
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 = 241 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 = 241 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:49:37.037
		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:49:37.037
		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:49:37.037
			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:49:37.037
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '21'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
			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 = 1128 AND
				      u.rev_num = 1 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
				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:49:37.037
					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-03-18

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
		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:49:37.037
		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:49:37.037
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 1128 AND
      rev_num = 1
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
	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 @ 11:49:37.037
	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:49:37.037
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 1128 AND ag_memo_dol.rev_num = 1
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
	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 = 1128 AND
		  ad.rev_num = 1 
		  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:49:37.037
		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:49:37.037
		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:49:37.037
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 1128 AND
		      rev_num = 1
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
	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 = 1128 AND form_rte.rev_num = 1 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:49:37.037
	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 = 1128 AND
		  rev_num = 1 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=32ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
		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 = 1128 AND
			  hist.rev_num = 1 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:49:37.037
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:49:37.037
		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) = 241

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:49:37.037
				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 = 241 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 = 5819 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:49:37.037
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 241
					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:49:37.037
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 241
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'B'
					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:49:37.037
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 241
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'B'
					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:49:37.037
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 11:49:37.037
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 1128 AND
					      rev_num = 1
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:49:37.037
	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:49:37.037
	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:49:37.037
		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:49:37.037
		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=3&get_year=2014&dsp=agm&seq=1128&rev=1&ag=241&ln=5819&nseq=1122&nrev=1&pseq=1020&prev=1
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=3&get_year=2014&dsp=agm&seq=1128&rev=1&ag=241&ln=5819&nseq=1122&nrev=1&pseq=1020&prev=1
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=9380559
cftoken=aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
hitcount=4
lastvisit={ts '2024-04-29 11:49:36'}
timecreated={ts '2024-04-29 11:49:36'}
urltoken=CFID=9380559&CFTOKEN=aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
Cookie Variables:
CFID=9380559
CFTOKEN=aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=241
DISPLAY_ID=1128
DISPLAY_REV=1
Session Variables:
cfid=9380559
cftoken=aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9380559_aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
subdir=/public/
tzoffset=0
urltoken=CFID=9380559&CFTOKEN=aee892491c5cbe8c-AFB8A091-C342-3A19-54619C204BAF159E
URL Parameters:
ag=241
dsp=agm
get_month=3
get_year=2014
id=
ln=5819
mt=ALL
nrev=1
nseq=1122
prev=1
pseq=1020
rev=1
seq=1128
Debug Rendering Time: 0 ms