City Council Combined Special Meeting/Work Session


Return to the Search Page Return to the Agenda
  5.A.       
Meeting Date: 06/25/2019  
From: Dan Symer, Zoning Code Manager

TITLE:
Consideration and Adoption of Resolution No. 2019-31 and Ordinance No. 2019-22:  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 “2019 Zoning Code Amendments Industrial Zones and Miscellaneous Revisions (PZ-19-00087 AND PZ-19-00093)”; 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 (Ordinance No. 2011-20), Chapters 10-20, 10-40, 10-50, 10-60, and 10-80, as provided in that certain document entitled “2019 Zoning Code Amendments Industrial Zones and Miscellaneous Revisions (PZ-19-00087 and PZ-19-00093)” Declared to be a Public record by Resolution No. 2019-31; providing for repeal of conflicting ordinances, severability, and establishing an effective date.
STAFF RECOMMENDED ACTION:
At the June 25, 2019 Council Meeting:
1) Hold public hearing
2) Read Resolution No. 2019-31 by title only
3) City Clerk reads Resolution No.2019-31 by title only (if approved above)
4) Read Ordinance No. 2019-22 by title only for the first time
5) City Clerk reads Ordinance No. 2019-22 by title only (if approved above)
At the July 2, 2019 Council Meeting:
6) Adopt Resolution No. 2019-31
7) Read Ordinance No. 2019-22 by title only for the final time
8) City Clerk reads Ordinance No. 2019-22 by title only (if approved above)
9) Adopt Ordinance No. 2019-22
Executive Summary:
The proposed amendment contains two parts.  The first part of the proposed amendment is the City’s continued effort to resolve conflicts, make technical corrections, and incorporate clarity into the Zoning Code. The second part (Case No.: PZ-19-00082) is a proposed amendment by the property owner (Pacific Prime Properties) to amend the list of land uses for the Light Industrial (LI) zone to add the Seasonal Amusement/Entertainment and Sales, Indoor (SAESI) land use as an allowed use subject to the approval of a Conditional Use Permit.

On June 12, 2019, the Planning and Zoning Commission recommended approval of the proposed amendment to the City Council with a vote of 4-0.
Financial Impact:
There are no anticipated financial impacts affiliated with the proposed Zoning Code Text Amendments.
Policy Impact:
There are no anticipated policy impacts affiliated with the proposed Zoning Code Text Amendments.
Connection to Council Goal, Regional Plan and/or Team Flagstaff 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 the attached Planning and Zoning Commission staff 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 (accessory dwelling units), incorporate applicant’s requests (West University Drive Entrance Sign District), and to address changes in state law and U.S. Supreme Court decisions (i.e. Reed vs the Town of Gilbert).
Options and Alternatives:
The City Council may adopt, modify, or deny the amendments.
Background and History:
Proposed Amendment
 
Part 1 – City’s Proposed Amendments

Organized primarily by section number and topic, below is a summary of staff’s proposed Zoning Code Text Amendment (Attachment 1 - excluding sections 17, 24, and the SAESI land use of Section 5).  The most significant modification is the correction to the adoption of the Industrial Zones (10-40.30.050), including scriveners and table errors pertaining to the allowed uses and the building form provisions. Even though the codified version of the zoning code includes the intended allowed uses and the building form provisions of the Industrial Zones, the City Council adopted ordinance and resolution (Ordinance No. O2011-20 and Resolution No. R2011-35) references the residential zone provisions in place of the industrial zone provisions.  Incorporated into these changes is the land use term modification from “Lodging” to “Travel Accommodations”. The purpose of this change is to utilize an industry and North American Industry Classification System (NAICS) term for the land use.

To clarify that the proposed land use of Travel Accommodations does not include short term rentals and vacation retails, staff has included the following definition into the proposed amendment:
 
Travel Accommodations: is a one or more structures, with or without related services and facilities, that is provided and offered to transient guests for stays of less than thirty (30) days.   A travel accommodation may include accessory commercial uses, such as retail, restaurant, banquet space, event center or other similar use. Travel accommodation does not include bed and breakfast, short-term rental or vacation rental, and includes hostels, hotel, Inns, lodges/lodging, motels/motor or auto courts, resorts, time-shares, and similar uses as determined by the Zoning Administrator. 

A vast majority of the remainder of the proposed modifications are intended to resolve discrepancies between the originally adopted ordinance, subsequent amendments and the codified version of the zoning code.  In addition to these modifications, the proposed text amendment includes corrections to section cross-references, technical modifications, and table formatting.  Also, the amendment includes a term change from “horse fencing” to “corral fencing”.  The purpose of this modification is to eliminate the need for a decision/interpretation to allow fencing of this type for other animals that are kept in corrals of similar nature.  Finally, a definition for a Fuel Pump Sign has been included.  Currently, this sign type is not defined.  The proposed definition, “A sign mounted above, and integrated into the structure of, an operable fuel dispensing pump” is to eliminate the need for an interpretation of the zoning code as it pertains to what a fuel pump sign is.
 
Part 1 – Summary of the Staff Revisions to Zoning Code
 
  1. Temporary Use Permits (Section 10-20.40.150.D): Change the term Temporary Signs to Portable Signs.
  2. Industrial Zones – Allowed Uses (Section 10-40.30.050.B):  Delete and adopt the list of land uses allowed in the Industrial Zones to correct the adoption, scrivener's and table errors in Ordinance No. O2011-20 and Resolution No. R2011-35.  In addition, the land use term Lodging has been changed to Travel Accommodations.
  3. Industrial Zones – Building Form Standards (Section 10-40.30.050.C):  Delete and adopt the building form standards of the Industrial Zones to correct the adoption, scrivener's and table errors in Ordinance No. O2011-20 and Resolution No. R2011-35.
  4. Sustainability Features of All Non–Transect Zones (Section 10-40.30.070.A): Incorporate technical corrections to the Sustainability Features table.
  5. T1 Natural (T1) Standards (Section 10-40.40.030): Add Wind Energy Production Facility as an allowed sustainable feature.
  6. T3 Neighborhood I (T3N.1) Standards, and T3 Neighborhood 2 (T3N.2) (Sections 10-40.40.050, and 10-40.40.060): Correct the Dormitories and Fraternities/Sororities Land use in the Allowed Uses to require a Conditional Use Permit.
  7. T6 Downtown (T6) (Section 10-40.40.100) add Bed and Breakfast as a permitted use
  8. Thoroughfare Assemblies (Section 10-60.10.090): Add the provisions of thoroughfare assemblies into this section.
  9. Additional Technical and Term (Sections 10-40.30.050, 10-40.40.100, 10-40.60.280, 10-40.60.310, 10-50.50.040, 10-50.100.060, 10-50.100.100, 10-50.110.080): Incorporate various technical modifications and cross references errors.
  10. Definitions, “S” (Sections 10-80.20.190) Add the term Sign, Fuel Pump to the list of definitions.
  11. Definitions, “T” (Sections 10-80.20.200) Add the term Travel Accommodations to the list of definitions.
Part 2 – Applicant’s Proposed Amendments
 
The applicant’s request is to add a new land use, SAESI, to the Light Industrial (LI) zone.  The proposed amendment defines (Attachment 1 - Section 24) the new land use as:
 
Seasonal Amusement, Entertainment and Sales, Indoor: is an indoor annual reoccurring seasonal commercial amusement, entertainment or festival event (e.g. art festivals/performances/workshops, Christmas fair, haunted house, or similar activity approved by the Zoning Administrator), including the seasonal sales of merchandise, that occurs only once in a calendar year for a specified timeframe, which is generally less than 4 months.

The applicant’s narrative (Attachment 2) includes a summary of the proposed Zoning Code Text Amendment, and a Regional Plan and required Zoning Text Amendment findings analysis. 

Primarily to facilitate the relocation of a local business (the North Pole Experience (NPEX)) to the property owner’s property, the proposed use would supplement the allowed and conditional uses of the zone that this business would utilize (warehousing and office land uses) as part of the functions of its operations.  Therefore, the proposed modification would allow all business activities of the NPEX to operate in one location.  As a larger zone wide benefit, the proposed uses would allow greater flexibility for the existing allowed uses, such as trade schools and a Light Industrial, General uses, to utilize the proposed use for seasonal activities, such as a product and trade fairs, promotional activities, performances, etc.

To ensure compatibility between existing uses on a property and nearby uses on other properties, to utilize the SAESI use, a property owner will be required to obtain the approval of a Conditional Use Permit.  Included in the proposed amendment are use specific criteria and development standards for the SAESI use.  These standards and criteria are intended to mitigate pedestrian and vehicle conflicts, and to preclude locations that have existing businesses on the property or nearby that are functionally inconsistent, or may have the potential of causing undue harm to the SAESI users (Attachment 1, Section 17).
Key Considerations:
 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 City’s proposed amendments are primarily to resolve conflicts, incorporate technical corrections and add clarity to the zoning code. Clerical in nature, the amendments do not substantively modify the existing provisions of the Zoning Code and maintains consistency and conformance with the objectives and policies of the Regional Plan (General Plan) and applicable specific plans.

The most significant modifications include the adoption of the industrial zone land uses and building form requirements. These zones and related provisions are primarily intended to implement the Regional Plan’s land use designation of Employment Center “Employment.”  Supported by several goals and policies of the Regional Plan, these zones are intended to increase employment, promote new and re-development, establish land use and development flexibility, ensure development of industrial area are compactable with surrounding areas, and protect existing and encourage new business and industrial growth (LU 1.1, LU 1.6, LU 6.2, LU 16.2, LU 16.3, ED3.8, ED 4.5 of the Regional Plan).

The applicant’s proposed amendment is to modify the land use of the Light Industrial (LI) zone. Intended to provide a transitional zone between commercial and heavy industrial land uses, the Light Industrial (LI) zone also assists with the Employment land use’s purpose of providing “… for the continued growth of the existing employment centers and encouraging the reuse of underutilized, vacant or obsolete commercial and industrial spaces…”

The addition of the proposed SAESI use has the potential of assisting to implement the Regional Plan’s Employment and land use policy objectives to encourage the reuse of underutilized, vacant or obsolete commercial and industrial spaces.  As proposed, the use would allow property owners additional flexibility to partner with businesses and tenants to use indoor areas for art festivals, including performances and workshops, fairs, and other holiday and seasonal events (LU 1.6 of the Regional Plan) that require large indoor volumes for a limited time period (A total of 98 days in any one calendar year, and no more than 98 consecutive days.) Also, the use would allow businesses and event operators to co-locate their operations in a single location, adding to the flexibility of the Light Industrial (LI) zone. Some potential uses require the warehousing (an allowed use in the Light Industrial) of operational materials in the off-season and sale merchandise in preparation for an upcoming seasonal event.  Also providing the property owners and tenants greater flexibility (LU 1.6 of the Regional Plan), other uses in the zone, such as trade schools and a Light Industrial, General uses could utilize the proposed use for seasonal activities such as a product and trade fairs, promotional activities, etc. that could occur within or near its operational facilities.

Recognizing the purpose of the zone, the Employment land use, and Regional Plan policies to protect existing more intensive businesses and land use operations from uses that may not be appropriate or have conflicting characteristics, the applicant’s request is to allow the SAESI subject to the approval of a Conditional Use Permit.  In addition to the standard Conditional Use Permit findings, the proposed amendment incorporates two additional findings to ensure compatibility with existing uses of development, and the uses on adjacent property ((ED 3.8) of the Regional Plan).  These additional findings are intended to evaluate the proposed and existing uses on the property and on adjacent properties to ensure that there are:
  1. no functional conflicts between the uses; and
  2. to ensure that there are no undue risks to the proposed use’s customers due to being located near more intensive land uses.
B.    Finding #2
  • The proposed amendment will not be detrimental to the public interest, health, safety, convenience or welfare of the City;
The City’s 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 and add clarity to the zoning code.  Incorporated in the proposed amendment are additional allowances for sustainable features (wind energy production, riffle pools, swales, etc.) that could assist with mitigating the adverse impacts that the City’s populous has on the environment.

The applicant’s proposed amendment to add the SAESI land use and related provisions to the Light Industrial (LI) is not anticipated to be detrimental to the public interest, health, safety, convenience or welfare of the City.  To assist with mitigating adverse impacts from adjoining and existing uses, the proposed use is required to obtain a Conditional Use Permit, and comply with specific use criteria.  These criteria are intended to mitigate potential conflicts between the SAESI’s pedestrians and passenger vehicles and large trucks and the operations of loading bays, service areas or truck yard facilities that may occur on a property.  These development standards include requiring the:
  1. Access to the building area and customer parking for the use, not be located on the same façade or side of the building that has loading bays, service areas or truck yard facilities;
  2. Customer parking for the use is to be clustered together, located nearest to the uses primary public entry/exit, and signed for customer’s exclusive use during the user's operations; and
  3. A pedestrian route from the customer parking to the primary public entry/exit that crosses any drive aisle to be signed and marked to notify the pedestrians and vehicle traffic of the crosswalk.
As indicated above in Finding 1, which is also applicable to Finding 2, the proposed amendment incorporates two additional findings to ensure compatibility with existing uses of a development, and the uses on adjacent property.  These additional findings are intended to evaluate the proposed and existing uses on the property and on adjacent properties so that there are:
  1. no operational characteristic conflicts between the uses; and
  2. to ensure that there are no undue risks to the proposed use’s customers due to being located near more intensive land uses.
C.    Finding #3
  • The proposed amendment is internally consistent with other applicable provisions of this Zoning Code.
The City’s proposed amendments enhance the zoning code’s internal consistency by resolving conflicts, incorporating technical corrections and adding clarity.  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.
 
The applicant’s proposed amendment to add the SAESI land use and related provisions to the Light Industrial (LI) zone achieves internal consistency through the zoning code’s intent of encouraging the evolution of zones to include the most appropriate uses that enhance the viability of existing buildings. Furthermore, the proposed use specific criteria assists in maintaining consistency with the zoning code’s intent to protect businesses from adverse impacts of adjoining uses, and protecting the health, safety, and general welfare of the public. Finally, the proposed amendment aids with maintaining a comprehensive contemporary set of requirements that are straightforward, usable and easily understood.
Community Involvement:
Please refer the key considerations included in this report.
Expanded Options and Alternatives:
In accordance with State Statute and the Zoning Code, the Planning and Zoning Commission work session for the amendments was advertised in the Arizona Daily Sun on May 4, 2019; and, the Planning and Zoning Commission work session was advertised Arizona Daily Sun on May 25, 2019.  In addition, the City Council held a work session on these amendments on May 28, 2019. Also, 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, staff has not received any comments from the public.
Attachments
Res. 2019-31
Exhibit A
Ord. 2019-22
Planning and Zoning Commission Report, June 12, 2019
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 27-Apr-24 03:49 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
206 ms 206 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
159 ms 159 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
159 ms 159 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
143 ms 143 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
47 ms 47 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(4111, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 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
221 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 15:49:40.040
			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 @ 15:49:40.040
				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 @ 15:49:40.040
			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 @ 15:49:40.040
				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 @ 15:49:40.040
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:49:40.040
	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 @ 15:49:40.040
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:49:40.040
		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 @ 15:49:40.040
	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 @ 15:49:40.040
		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 @ 15:49:40.040
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:49:40.040
	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 @ 15:49:40.040
		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 @ 15:49:40.040
		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 @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:49:40.040
	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=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:49:40.040
		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) = 2019-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2019-06-30 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 15:49:40.040
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 893 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 15:49:40.040
 		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 @ 15:49:40.040
 		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 @ 15:49:40.040
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 894 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 @ 15:49:40.040
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 894 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
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 = 893 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 = 894 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 @ 15:49:40.040
		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 @ 15:49:40.040
		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 @ 15:49:40.040
			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 @ 15:49:40.040
			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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
			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 = 4111 AND
				      u.rev_num = 0 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
				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 @ 15:49:40.040
					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) = 2019-06-25

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
		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=2ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 4111 AND
      rev_num = 0
ORDER BY seq_num
committees (Datasource=frsRO, Time=1ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 4111 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
	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 = 4111 AND
		  ad.rev_num = 0 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
		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 @ 15:49:40.040
		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 @ 15:49:40.040
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 4111 AND
		      rev_num = 0
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
	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 = 4111 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
	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 = 4111 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=15ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
		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 = 4111 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 15:49:40.040
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 15:49:40.040
		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) = 894

GetThisLine (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 15:49:40.040
				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 = 893 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 = 21145 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 15:49:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 893
					AND a.ag_level1 = '1'
					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 @ 15:49:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 893
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '5'
					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 @ 15:49:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 893
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '5'
					AND a.ag_level3 = 'A'
					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 @ 15:49:40.040
					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 @ 15:49:40.040
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 4111 AND
					      rev_num = 0
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 15:49:40.040
	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 @ 15:49:40.040
	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 @ 15:49:40.040
		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 @ 15:49:40.040
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=6&get_year=2019&dsp=agm&seq=4111&rev=0&ag=893&ln=21145&nseq=&nrev=&pseq=&prev=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=6&get_year=2019&dsp=agm&seq=4111&rev=0&ag=893&ln=21145&nseq=&nrev=&pseq=&prev=
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9334434
cftoken=86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
hitcount=4
lastvisit={ts '2024-04-27 15:49:40'}
timecreated={ts '2024-04-27 15:49:40'}
urltoken=CFID=9334434&CFTOKEN=86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
Cookie Variables:
CFID=9334434
CFTOKEN=86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=893
DISPLAY_ID=4111
DISPLAY_REV=0
Session Variables:
cfid=9334434
cftoken=86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9334434_86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
subdir=/public/
tzoffset=0
urltoken=CFID=9334434&CFTOKEN=86c7bcc0e092d5c5-51513EBF-0036-F230-7E168B99FFB50F66
URL Parameters:
ag=893
dsp=agm
get_month=6
get_year=2019
id=
ln=21145
mt=ALL
nrev=
nseq=
prev=
pseq=
rev=0
seq=4111
Debug Rendering Time: 16 ms