City Council Meeting - FINAL


Return to the Search Page Return to the Agenda
  9.B.       
Meeting Date: 05/05/2020  
From: Dan Symer, Zoning Code Manager

Information
TITLE:
Consideration and Adoption of Resolution No. 2020-17 and Ordinance No. No. 2020-11:  A Resolution of the City Council of the City of Flagstaff, Coconino County, Arizona, declaring as a public record that certain document filed with the City Clerk and entitled "Case No. PZ-19-00125 Updates to Zoning Code 2020 – Miscellaneous Part 1"; and, an Ordinance of the City Council of the City of Flagstaff, Coconino County, Arizona, amending the Flagstaff City Code, Title 10, Flagstaff Zoning Code, to resolve conflicts, incorporate technical corrections and clarity, and modify existing and add new requirements, provisions, and definitions.
STAFF RECOMMENDED ACTION:
1) Adopt Resolution No. 2020-17
2) Read Ordinance No. 2020-11 by title only for the final time
3) City Clerk reads Ordinance No. 2020-11 by title only (if approved above)
4) Adopt Ordinance No. 2020-11
Executive Summary:
The proposed amendment (Case No. PZ-19-00125) includes changes to the Zoning Code to resolve conflicts, incorporate technical corrections and clarity, and add new, and modify existing, requirements, provisions, and definitions.

On February 26, 2020, the Planning and Zoning Commission recommended approval of the proposed amendment to the City Council with a vote of 5-0.
Financial Impact:
There are no anticipated financial impacts affiliated with the proposed Zoning Code Text Amendment.
Policy Impact:
There are no anticipated policy impacts affiliated with the proposed Zoning Code Text Amendment.
Connection to Council Goal, Regional Plan, CAAP, and/or Strategic Plan:
Council Goals:
Revise the Zoning Code to remove ambiguities, and ensure it is consistent with the community values and the Regional Plan.

Team Flagstaff Strategic Plan:
Work in partnership with to enhance a safe and livable community.

Regional Plan:
Please refer to letter A of the Key Considerations section of this report.
Has There Been Previous Council Decision on This:
The Zoning Code was adopted by the City Council on November 1, 2011, to replace the former Land Development Code.  Since its adoption, the Code has been amended several times to address procedures, add clarity, resolve conflicts, address planning initiatives, incorporate private amendments, and to address changes in state law and U.S. Supreme Court decisions.  As of the date of this report, the most recent amendments to the Zoning Code were approved by the City Council on November 5, 2019.  The November amendments addressed accessory dwelling units and a series of miscellaneous modifications.
Options and Alternatives:
The City Council may adopt, modify, or deny the amendment.
Background and History:
The Zoning Code was adopted by the City Council on November 1, 2011, to replace the former Land Development Code.  Since its adoption, the Code has been amended several times to address procedures, add clarity and new provisions, resolve conflicts, incorporate accessory dwelling units and applicant amendments, and to address changes in state law and U.S. Supreme Court decisions.

On March 10, 2020, the City Council held a work session on the proposed amendment. A majority of the comments and questions were general clarifications and editorial. Specific questions regarding the amendment included the following:
  • Triplex lot size in the Transect Zones.  The proposed amendment is to increase the lot size requirements for new and existing lots of a triplex development.  The current triplex requirement is the same as the duplex standard in the Transect Zones, which is opined to be too small for a three-unit development. The purpose of the modification is to require additional lot width and depth to accommodate designs that may be more compatible with the existing context of a neighborhood.  In addition, the modification to the lot area requirement is consistent with the requirements for a three-unit development in the non-transect zones.
  • Density.  The proposed amendment is to increase the maximum allowed density for properties in a pedestrian shed of an Activity Center (per the Regional Plan) that have a Commercial Zone designation and that are also located in a Resource Protection Overlay Zone.  The existing allowance is 22 dwelling units per acre, and the proposed allowance is 29 dwelling units per acre. The proposed 29 dwelling units per acre is the current allowance of the Commercial Zones without the Resource Protection Overlay Zone. 
  • Gross Floor Area Ratio.  The proposed amendment eliminates the multiple conflicting terms (Floor Area Ratio (FAR) Net Floor Area Ratio (net FAR), and Gross Floor Area Ratio (GFAR) and replaces all uses of these terms with Gross Floor Area Ratio.  The proposed definition of Gross Floor Area Ratio is, “An intensity measured as a ratio derived by dividing the total floor area in square feet of all buildings or structures on a development site by the development site area in square feet.” In accordance with the Zoning Code definition of Floor Area, the floor area used to calculate the Gross Floor Area Ratio is the “…sum of the gross floor area for each of a building’s stories measured from the exterior limits of the faces of the structure.”
  • Screening.  The existing roof-mounted screening provision in the Zoning Code includes the phrase “electrical services,” which can be interpreted to require the screening of antennas, satellite dishes, solar panels, and similar electrical devices.  This provision applies to all zones and structure types, including single-family and duplex residential structures. To eliminate confusion and interpretation issues, it is proposed to delete the phrase "electrical services".
Proposed Amendment:
The proposed amendment includes multiple changes to the Zoning Code to resolve conflicts, incorporate technical corrections, add clarity, and to simplify the existing requirements.  New provisions are being added, and several sections and divisions are being modified, relocated, or deleted.

The most significant of the modifications include:
  • Clarifying when a Concept Plan application is required;
  • Adding expiration time frames for Concept Plan and Site Plan applications and approvals;
  • Clarifying when a property owner may submit a Zoning Map Amendment or Zoning Code Text Amendment;
  • Allowing 29 dwelling units per acre in the Commercial Zones with the Resource Protection Overlay Zone that are also located in a pedestrian shed of an activity center per the Regional Plan (General Plan);
  • Allowing the Heritage Preservation Commission to approve less restrictive standards or exceptions to the standards in order to maintain the historic integrity of a historic property in a Transect Zone;
  • Increasing the lot width and depth requirements for new and existing lots of a triplex development a Transect Zone;
  • Modifying the equipment screening requirements to require a parapet or roof feature be no shorter than the tallest object being screened, and to require wall-mounted equipment to be screened from surrounding properties, alleys and streets, or to be integrated into the architecture of the building;
  • Clarifying and modifying the landscape buffer requirements, including the addition of new criteria to allow modifications to the required landscape street buffer; and
  • Incorporating the building location requirements of the transect private street frontage types when these standards are used in the non-transect zones.
Summary of the Staff Revisions to the Zoning Code
The proposed amendment includes:
  1. Concept Plan Review (Section 10-20.30.050): The Concept Plan Review submittal requirements have been limited to structural modifications. Also, expiration timeframes of Concept Plan applications have been incorporated.
  2. Minor Improvement Permits (Section 10-20.40.080):  Changes have been incorporated to exempt animal keeping shelters that are less than 50 square feet from the Minor Improvement Permit application process.
  3. Site Plan Review and Approval (Section 10-20.40.140): Expiration timeframes for Site Plan Review applications and associated approvals have been incorporated.
  4. Initiation of Amendments (Section 10-20.50.030): Changes have been incorporated clarifying when a property owner may submit a Zoning Map Amendment or Zoning Code Text Amendment.
  5. Public Improvements Defined (Section 10-30.50.030): Changes have been incorporated for parkways to be included as a public improvement requirement.
  6. Open Spaces, Civic Spaces, and Outdoor Public Spaces (Section 10-30.60.090): Clarification has been incorporated that the area requirements of open spaces, civic spaces, and outdoor public spaces are based on the defined term of Development Site Area.
  7. Commercial Zones (Section 10-40.30.040): The land use Kennel, Animal Keeping has been added to the list of allowed uses in the Highway Commercial (HC) zone with a Conditional Use Permit.
  8. Building Form and Property Development Standards (Table 10-40.30.040.C.): The density allowance in a pedestrian shed of an activity center with a Commercial Zone and a Resource Protection Overlay Zone designation has been increased from 22 dwelling units per acre to 29 dwelling units per acre.
  9. Building Form and Property Development Standards (Tables 10-40.30.030.C., 10-40.30.040.C., and 10-40.30.050.C. and Section 10-40.30.060.C.): The building height allowances for pitched roofs, elevator and stairwell bulkheads, and architectural features have been incorporated into the property development standard tables.  Currently, these provisions are in Section 10-50.30.030, How Building Height is Measured.
  10. Applicability (Section 10-40.40.020): Provisions have been incorporated into the Transect Zone standards pertaining to conflicts with an overlay zone.  These provisions specify that the more restrictive standards shall apply unless the overlay specifically indicates which standards govern.  In addition, provisions have been incorporated that allow the Heritage Preservation Commission to determine if a less restrictive standard is necessary to maintain the historic nature or context of the property, structure, or area within a Historic Overlay Zone.
  11. Specific to Uses (Division 10-40.60): Provisions have been incorporated for the Kennel, Animal Boarding land use.
  12. Supplemental to Zones, Divisions (Chapter 10-50): Division 10-50.25: Basements, Basement Garages, Building Stem Walls, Crawl Spaces, and Podium Parking Structure Walls, including sections therein, have been incorporated.  Currently, these provisions are located in Section 10-50.30.030, How Building Height is Measured. Also, new provisions have been incorporated to accommodate floodplain requirements and walls of a podium parking structure. These provisions require the exterior of the podium parking structure wall to have an architectural finish that is consistent with the rest of the building’s architectural finishes.  Also, the changes allow for greater wall heights when they are needed to raise a residential first floor above the lowest floor requirement in a floodplain.
  13. Applicability (Section 10-50.20.020): Clarification has been incorporated pertaining to building and structure elevations that are subject to Section 10-20.40.140, Site Plan Review and Approval. These elevations shall comply with Section 10-50.20, Architectural Design Standards.
  14. How Building Height Is Measured (Section 10-50.30.030): The methodology to measure building height has been modified. Also, several standards of this section are being modified and relocated.
  15. General Fencing and Screening Standards (Section 10-50.50.040): The equipment screening requirements have been modified to require a parapet or roof feature be no shorter than the tallest object being screened, and to require wall-mounted equipment to be screened from surrounding properties, alleys and streets, or to be integrated into the architecture of the building.
  16. Landscape Location Requirements (Section 10-50.60.040): The landscape buffer requirements have been clarified and modified.  The modifications include the addition of criteria to allow the modification of the required landscape street buffer.
  17. Number of Motor Vehicle Parking Spaces Required (Table 10-50.80.040.A): Parking requirements for a Tap Room have been incorporated.
  18. Specific to Building Types (Division 10-50.110): The location requirements of the transect private street frontage have been clarified when the Forecourt, Shopfront, Terrace Shopfront, and Gallery are used in the non-transect zones.
  19. Stacked Triplex (Section 10-50.110.120): The triplex development minimum lot width (existing: 50 feet, proposed: 75 feet) and depth (existing: 75 feet, proposed: 100 feet) requirements have been increased for new and existing lots. 
  20. Definition of Specialized Terms, Phrases, and Building Functions (Division 10-80.20): This division includes modifications, deletions, and the addition of various definitions of the Zoning Code, including: Acreage, Gross; Acreage, Net; Density; Density, Gross; Development, Multiple-Family; Development Site; Development Site Area; Duplex; Finished Grade; Floor Area Ratio; Gross (GFAR); Industrial, Heavy – General; Key Lot; Micro-brewery or Micro-distillery; Natural Grade; Outdoor Storage or Display; and Yard, Railroad Shop.
  21. Additional Enforcement, Technical, Figure and Term Modifications (Division 10-50.110 and Sections: 10-20.40.090, 10-20.50.040, 10-40.30.030, 10-40.30.050, 10-40.50.030, 10-50.50.030, 10-50.60.010, 10-50.80.040, 10-50.100.050, 10-50.100.100, 10-50.90.060, and Appendix 2):  Various technical, enforcement, and cross reference corrections, clarifications, and modifications have been incorporated.
Key Considerations:
Zoning Code Text Amendment
An application for a Zoning Text Amendment shall be submitted to the Planning Director and shall be reviewed and a recommendation prepared.  The Planning Director’s recommendation shall be transmitted to the City Council in the form of a Staff Report prior to a scheduled public hearing.  The recommendation shall include: an evaluation of the consistency and conformance of the proposed amendment with the goals and policies of the General Plan and any applicable specific plans; the grounds for the recommendation based on the standards and purposes of the zones set forth in Section 10-40.20 (Establishment of Zones) of the Zoning Code; and, whether the amendment should be granted, or denied. 

A Zoning Code Text Amendment shall be evaluated based on the following findings:
A.    Finding #1:
  • The proposed amendment is consistent with and conforms to the objectives and policies of the General Plan and any applicable specific plan;
The proposed amendments are primarily to resolve conflicts, incorporate technical corrections, and add clarity to the Zoning Code. Mainly clerical in nature, the amendments do not substantively modify the existing provisions of the Zoning Code and maintain consistency and conformance with the objectives and policies of the Regional Plan (General Plan) and applicable specific plans.

In addition to the modifications summarized above, the proposed amendment includes:
  • Adding the Kennel, Animal Keeping land use to the High Commercial (HC) zone as a permitted use with a Conditional Use Permit.  The addition of the proposed land use is at the request of a local business owner to allow a café concept that would have pets living at the establishment.  Any business with more than four dogs, cats, or other small animals that are kept, maintained, trained, or boarded is considered a Kennel, Animal Keeping land use.  Due to the broad nature of the definition of Kennel, Animal Keeping and the accessory use provisions of the Zoning Code, some existing businesses in Highway Commercial (HC) would not be allowed (Petsmart, etc.).
Upon review of the land uses allowed in the High Commercial (HC) zone, and the zone’s existing locations, it has been determined that the use could be allowed with reasonable restrictions.  These restrictions include:
 
a. A maximum floor area size of 10,000 square feet. For reference purposes, the old Arizona Department of Transportation building located directly north of the intersection of South Milton Road and West University Avenue is approximately 10,000 square feet.
 
b. There shall be no outdoor activities allowed.
 
c. The walls and ceiling shall include reasonable sound transmission attenuation.

The proposed addition of the Kennel, Animal Keeping land use to the Highway Commercial (HC) zone is consistent with and conforms to the objectives and policies of the Regional Plan (General Plan) and applicable specific plans. This modification will incorporate additional variety and flexibility in the allowed mix of uses that are near neighborhoods and within commercial developments (RP Policies ED.4.2., LU.13.6., and LU.15.3.).  Also, the addition of the Kennel, Animal Keeping land use to the Highway Commercial (HC) zone allows for additional locations of the use, which may assist in protecting industrial zoned properties from uses that would otherwise need to be located in an industrial zone (ED.3.8., and LU.16.1.).
  • Increasing the maximum allowed density of Commercial Zones located in a pedestrian shed of an activity center that also has a Resource Protection Overlay Zone designation. The existing allowance is 22 dwelling units per acre, and the proposed allowance is 29 dwelling units per acre. The proposed amendment would allow a density that is consistent with the Commercial Zones (Community Commercial (CC), Highway Commercial (HC), Commercial Service (CS), and Central Business (CB)) without the Resource Protection Overlay Zone.
The proposed increase in density is consistent with and conforms to the objectives and policies of the Regional Plan (General Plan) and applicable specific plans. This modification will allow increased densities within an activity center’s pedestrian shed, provide for greater flexibility, assist in promoting infill development with densities that could assist in the conservation of environmental resources, reduce the cost of providing infrastructure and services, and contribute to economic investments (RP Policies LU 1.6, LU 5.2, LU18.6, and LU 18.8.).  Furthermore, the increase of the density in an activity center’s pedestrian shed promotes the efficient use of existing roads, public and private utilities, facilities and services, alternative transportation options, and reduced vehicle trips and energy consumption (RP Policy LU 7.1.). 
  • Increasing the triplex development minimum lot width (existing: 50 feet, proposed: 75 feet) and depth (existing: 75 feet, proposed: 100 feet) requirements for new and existing lots. 
The proposed increase in the triplex minimum lot size is consistent with and conforms to the objectives and policies of the Regional Plan (General Plan) and applicable specific plans. The proposed increase in the triplex minimum lot size requirement is to provide contextually proportional development relationships that respect the existing development patterns of neighborhoods where the triplex development type is allowed (RP CC.3.1., NH.1.2, NH.6.1).
 

B.    Finding #2

  • The proposed amendment will not be detrimental to the public interest, health, safety, convenience or welfare of the City;
The proposed amendments are not anticipated to be detrimental to the public interest, health, safety, convenience, or welfare of the City.  These amendments are primarily to resolve conflicts, incorporate technical corrections, add clarity, and incorporate public comments and considerations to the Zoning Code. 

C.    Finding #3
  • The proposed amendment is internally consistent with other applicable provisions of this Zoning Code.
The proposed amendments enhance the Zoning Code’s internal consistency by resolving conflicts, adding clarity, addressing public comments and considerations, and incorporating new consistent provisions and technical corrections.  Furthermore, the proposed amendments are intended to maintain the Zoning Code’s purpose as a comprehensive contemporary set of land uses and requirements that are straightforward, usable, and easily understood.
Community Involvement:
Please refer to letter A of the Key Considerations section of this report.
Expanded Options and Alternatives:
In accordance with State Statute and the Zoning Code, the Planning and Zoning Commission work session and public hearing for this amendment were advertised in the Arizona Daily Sun on December 21, 2019; and, the City Council public hearing was advertised on April 4, 2020. Persons of interest that are on file with the Planning and Development Services Department were notified of the work sessions and hearings via first class mail.

As of the date of this report, the City Staff has received a set of public comments and considerations. These are included as, Attachment 4.  To address these comments, several revisions to the proposed amendment have been incorporated.  These include:
  1. Clarification pertaining to the density allowance for commercially zoned properties in the Resource Protection Overlay and inside of a pedestrian shed of an activity center delineated in the Regional Plan (General Plan) was added to Section 14. (Table 10-40.30.040.C. Gross Density) of Attachment #2.
  2. Clarification pertaining to the building height exceptions for stairwells and elevators were relocated from the method of measuring building height and added to Section 12 (Table 10-40.30.030.C., End Notes 8 and 9), Section 14 (Table 10-40.30.040.C., End Notes 9 and 10), Section 16 (Table 10-40.30.050.C., End Notes 8 and 9), and Section 17 (Section 10-40.30.060.C., End Notes 4 and 5) of Attachment #2.
  3. A modification has been made in Section 24 (Section 10-50.25.020. A.) of Attachment #1 to change the maximum height of an exposed basement and basement garage wall from nine feet to ten feet.  Ten feet allows for an eight-foot floor-to-ceiling height and a two-foot floor depth.  Additional heights would be inconsistent with the Zoning Code’s Site Planning Design Standards and Architectural Design Guidelines that require a building to be stepped to follow the natural terrain.
  4. A modification has been made in Section 24 (Section 10-50.25.020. A. and C.) of Attachment #2 to include provisions for materials and colors used on an exposed basement or basement garage wall and a podium parking structure exterior wall. The requirement for “consistent” materials and colors has been changed to allow the Planning Director to approve alternative materials and colors that are compatible with the design of the building, provided that the alternative materials and colors maintain a consistent design theme. This modification allows for additional flexibility in the designer’s choice of materials and colors near street grade to address weather and similar environmental considerations while maintaining a consistent design theme.
  5. Provisions that allow the Planning Director to approve additional stem wall and crawl space heights for residential buildings in a floodplain have been incorporated into Section 24 (Section 10-50.25.020. B.) of Attachment #2.  In accordance with Title 12 Floodplains of the City Code, the lowest finished floor of a residential area is required to be elevated above the regulatory floodplain elevation.  The addition of this provision will allow compliance with Title 12.
As it pertains to the comments received regarding the landscape buffer widths, with minimal exceptions adjacent to Route 66 in the Downtown, the City Staff opines that the proposed landscape buffer requirements are consistent with the suggested modifications.  It is anticipated that the Zoning Code requirements pertaining to the Downtown, and adjacent to Route 66 will be reviewed as part of a future amendment.

In addition, the proposed modification to the triplex lot width and length requirement is in response to public comments that Staff has received during the Southside specific plan and the High Occupancy Housing text amendment public outreach meetings. Also, some members of the Planning and Zoning Commission and City Council have requested that the referenced requirements be reviewed. The existing lot size requirements for a triplex and duplex are the same. Due to having the same standards for different intensity developments, the general consensus among the public comments received during the outreach for the High Occupancy Housing Text Amendment, Southside Specific Plan, and City Staff is that the existing provisions have resulted in developments that are inconsistent and out of scale with the existing development patterns.  The proposed modification to the lot width (from 50 feet to 75 feet) and length (from 75 feet to 100 feet) will result in a lot area requirement that is consistent with other three-unit developments on a property with non-transect zoning.  Based on public comments, the additional area would allow for a greater proportional lot width to height ratio that is perceived to be more compatible.

Finally, the Zoning Code currently requires all rooftop equipment to be screened. The public comments indicate that this requirement has caused existing roofs to be reconstructed to accommodate the wind loads on the screening. City Staff familiar with the methodology to accommodate the wind loads of the screening does agree with the public comment that there is a wind load transferred to the roof; but, Staff opines that the wind loads are insignificant. Wind loads need to be accommodated either on the equipment or the screen wall. When a screen wall is provided, and depending on the placement of the wall, the wind loads on the equipment are usually substantially less since the screen wall bears the wind load. The most common cause for a roof to be reconstructed in accordance with the current Building Code is to accommodate new or larger equipment that the roof was not designed for.

 
Attachments
Res. 2020-17
2. Exhibit A to Resolution 2020-17
Ord. 2020-11
4. Public Comments
Staff Presentation


    

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

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


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 29-Apr-24 06:47 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
219 ms 219 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
171 ms 171 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(4584, 3, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
11 ms 11 ms 1 D:/inetpub/PublicPages/Application.cfm
11 ms 6 ms 2 D:/inetpub/PublicPages/agpub_client_defines.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_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
230 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=11ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 18:47:08.008
			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 @ 18:47:08.008
				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 @ 18:47:08.008
			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 @ 18:47:08.008
				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 @ 18:47:08.008
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 18:47:08.008
	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 @ 18:47:08.008
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:47:08.008
		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 @ 18:47:08.008
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:47:08.008
		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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
		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 @ 18:47:08.008
		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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:47:08.008
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:47:08.008
		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) = 2020-05-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2020-05-31 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 18:47:08.008
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1056 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 18:47:08.008
 		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 @ 18:47:08.008
 		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 @ 18:47:08.008
		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 @ 18:47:08.008
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 1057 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 1057 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 @ 18:47:08.008
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 = 1056 AND agi._rowid = 86)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 1057 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 86 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
		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 @ 18:47:08.008
		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 = 86)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '86')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
			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 @ 18:47:08.008
			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 = '86'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
			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 = 4584 AND
				      u.rev_num = 3 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
				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 @ 18:47:08.008
					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) = 2020-05-05

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
		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 @ 18:47:08.008
		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 = 'dsymer'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 4584 AND
      rev_num = 3
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 4584 AND ag_memo_dol.rev_num = 3
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=16ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
	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 = 4584 AND
		  ad.rev_num = 3 
		  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 @ 18:47:08.008
		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 @ 18:47:08.008
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 4584 AND
		      rev_num = 3
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
	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 = 4584 AND form_rte.rev_num = 3 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 @ 18:47:08.008
	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 = 4584 AND
		  rev_num = 3 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
		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 = 'AI86')
		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 = 4584 AND
			  hist.rev_num = 3 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:47:08.008
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:47:08.008
		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) = 1057

GetThisLine (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:47:08.008
				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 = 1056 AND ai._rowid = 86)
				
				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 = 24601 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:47:08.008
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 1056
					AND a.ag_level1 = '9'
					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 @ 18:47:08.008
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 1056
					AND a.ag_level1 = '9'
					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=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:47:08.008
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 1056
					AND a.ag_level1 = '9'
					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 @ 18:47:08.008
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 18:47:08.008
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 4584 AND
					      rev_num = 3
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 18:47:08.008
	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 @ 18:47:08.008
	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 @ 18:47:08.008
		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 @ 18:47:08.008
		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=5&get_year=2020&dsp=agm&seq=4584&rev=3&ag=1056&ln=24601&nseq=4552&nrev=5&pseq=4530&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=5&get_year=2020&dsp=agm&seq=4584&rev=3&ag=1056&ln=24601&nseq=4552&nrev=5&pseq=4530&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=9387878
cftoken=1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
hitcount=4
lastvisit={ts '2024-04-29 18:47:08'}
timecreated={ts '2024-04-29 18:47:08'}
urltoken=CFID=9387878&CFTOKEN=1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
Cookie Variables:
CFID=9387878
CFTOKEN=1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=1056
DISPLAY_ID=4584
DISPLAY_REV=3
Session Variables:
cfid=9387878
cftoken=1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9387878_1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
subdir=/public/
tzoffset=0
urltoken=CFID=9387878&CFTOKEN=1a342bc2bf24a390-BEA6D914-FE96-43CF-D2A0D6D6E6849CAE
URL Parameters:
ag=1056
dsp=agm
get_month=5
get_year=2020
id=
ln=24601
mt=ALL
nrev=5
nseq=4552
prev=1
pseq=4530
rev=3
seq=4584
Debug Rendering Time: 0 ms