City Council Meeting - FINAL


Return to the Search Page Return to the Agenda
  9.B.       
Meeting Date: 11/15/2022  
From: Tiffany Antol, Senior Planner

Information
TITLE:
Consideration and Adoption of Ordinance No. 2022-28: An Ordinance of the City Council of the City of Flagstaff, Coconino County, Arizona, amending the Flagstaff City Code, Title 10, Flagstaff Zoning Code, Section 10-90.40.030 Rural Floodplain Map, to change the map designation of approximately 7.76 acres of real property from Rural Floodplain to Urban Floodplain on eight parcels of land (APNs 101-01-020A, 101-01-020B, 101-28-005G, 101-28-005H, 101-28-005K, 101-28-013A, 101-28-013B, and 101-28-013D) located generally between W Forest Avenue and N San Francisco Street; providing for severability and establishing an effective date.
STAFF RECOMMENDED ACTION:
1) Read Ordinance No. 2022-28 by title only for the final time
2) City Clerk reads Ordinance No. 2022-28 by title only (if approved above)
3) Adopt Ordinance No. 2022-28
Executive Summary:
This request is for a Zoning Code Text Amendment to amend Section 10-90.40.030 of the Zoning Code, the Rural Floodplain Map, to change the map designation of approximately 7.76 acres from Rural Floodplain to Urban Floodplain on eight parcels of land (APNs 101-01-020A, 101-01-020B, 101-28-005G, 101-28-005H, 101-28-005K, 101-28-013A, 101-28-013B, and 101-28-013D) located generally between W Forest Avenue and N San Francisco Street.
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 PBB Priorities/Objectives, Carbon Neutrality Plan & Regional Plan:
Priority Based Budget Key Community Priorities and Objectives
Promote, protect & enhance a healthy, sustainable environment & its natural resources.
Ensure the built environment is safe through the use of consistent standards, rules & regulations, & land use practices.

Carbon Neutrality Plan
Ensure all mitigation actions improve Flagstaff's ability to adapt to the future.
 
Regional Plan
Staff's analysis of the Regional Plan's goals and policies is included below under Key Considerations under the Zoning Code Text Amendment Criteria hearing, Finding #1 of this report.
Has There Been Previous Council Decision on This:
There has not been a previous City Council decision on this ordinance.
Options and Alternatives:
The City Council may adopt, modify, or deny the proposed amendment.
Background and History:
The Zoning Code includes a Resource Protection Overlay (RPO) that was originally adopted in June 1999 and applied to vacant parcels greater than five acres at the time of adoption.  The purpose of the RPO is to provide standards for the protection of natural resources, including floodplains, steep slopes, and forest.  The requirements are meant to ensure that proposed development is consistent with the character of its natural surroundings.  Floodplains (both Rural and Urban) are the highest priority resource to be protected on a site.  Floodplains are categorized as either urban or rural based on the descriptions below.

1.  Urban Floodplains. All watercourses and associated floodplains not defined as rural floodplains are urban floodplains. Urban floodplains are typically located in urbanized areas and have typically been altered from their natural state by channelization. Urban floodplains may be altered to address conveyance and erosion concerns, provided that all necessary requirements of the City’s Stormwater Regulations as administered by the Stormwater Manager are addressed. However, certain urban floodplains that have characteristics conducive to water quality, wildlife habitat, and stream ecology should be preserved. Proposals for any disturbance of these watercourses shall be reviewed by the Stormwater Manager and must address these attributes and provide for mitigation if necessary. Undergrounding of urban floodplains is strongly discouraged, and a justification must be provided prior to any approval of undergrounding.

2.  Rural Floodplains. Rural floodplains are natural undisturbed open spaces that are unsuitable for development purposes due to periodic flood inundation and the need to preserve the stream corridor for beneficial uses such as the preservation of important ecological resources. Rural floodplains are delineated in Section 10-90.40.030, Rural Floodplain Map, and defined as areas of delineated 100-year floodplain that cannot be disturbed or developed except for roadway and utility crossings. Rural floodplains cannot be altered through a floodplain map amendment or revision and must remain undisturbed (i.e., 100 percent protection). The extension of rural floodplains beyond the limits of the delineated floodplains, both upstream and laterally, may be required based on more current or extended floodplain studies, master plan documents or other studies or documents related to hydrology, hydraulics, stream geomorphology, wildlife habitat, or wildlife corridors.

The proposed amendment is to change the map designation of approximately 7.76 acres from Rural Floodplain to Urban Floodplain.  The applicant’s request is specific to their parcel APN 101-28-005H.  The Rural Floodplain encumbers approximately 1.96 acres of the applicant’s 3.35-acre parcel.  The applicant contends that the existing floodplain has been altered by adjacent development making the Rural Floodplain designation incongruent with the description provided in the Zoning Code.  The applicant states that the correct designation is Urban Floodplain.  The applicant is only requesting this designation be changed on their property.  Staff believes that if the adjacent floodplain areas have been altered as is described in this application, they also no longer meet the description of Rural Floodplain and have included these areas as part of the Zoning Code Text Amendment.

This area of Rural Floodplain is bounded on the north by W Forest Avenue.  The floodplain bisects two parcels of land owned by Northern Arizona Healthcare (NAH).  The floodplain is primarily located on land owned by the City of Flagstaff running in between the NAH properties, however, portions of the floodplain still overlap one of the parcels owned by NAH.  As the floodplain moves further south it encumbers another parcel owned by NAH.  NAH has provided written support to join this application (see attachment).  Beyond the NAH parcels is a parcel that is occupied by the Flagstaff YMCA.  A portion of this parcel (most of which is encumbered by the floodplain) has been dedicated to the City of Flagstaff as right-of-way.  The applicant’s parcel is directly south of the YMCA and the City right-of-way.  There are two additional vacant properties (owner has also submitted a letter to be included in this application) and the Northland Hospice site at the southern extent of this floodplain. 

The applicant states as part of their concept plan narrative that the project site is challenging due to constraints across the entire parcel including man-made slopes from the Switzer Canyon Road fill slope as well as moderate to dense tree coverage and 1.96 acres of the total site are within the Rural Floodplain.  This leaves approximately 1.39 acres to hit a minimum density of 34 units.  The applicant’s property is currently zoned High Density Residential and is located within the RPO.  The minimum density required is 10 units per acre (3.35 x 10 = 33.5 or 34 units).  The maximum density allowed for a parcel outside of an activity center and within the RPO is 22 units per acre (3.35 x 22 = 73.7 or 74 units).  The applicant is proposing to develop approximately 0.36 acres of the designated Flood Fringe (within the 100-year floodplain outside of the floodway) leaving the remaining 1.37 acres as undisturbed open space.  Residential development within the 100-year floodplain is required to be constructed so that the finished floor of livable space is a minimum of one foot above the 100-year floodplain as determined by the FEMA flood maps.  The applicant’s proposed residential design includes two floors of livable space above a bottom floor garage which would assist with these elevation requirements.
             
Existing and potential development on the surrounding parcels based on existing zoning includes the following:
  • APN 101-01-020A – Owned by Northern Arizona Healthcare (NAH), zoned Highway Commercial (HC), currently vacant; this site could allow either commercial or residential development.  This zoning category allows one of the highest density and intensity of development. 
  • APN 101-28-005G – Owned by NAH, zoned High Density Residential (HR), currently vacant, 4.86 acres; could be developed with 107 residential units or medical offices with a conditional use permit.
  • APN 101-28-005K – Owned by Valley of the Sun Young Men’s Christian Association; has been developed with the current Flagstaff YMCA facility.
  • APN 101-28-013A – Owned by Testan Properties LLC, zoned Single-Family Residential (R1), currently vacant, .72 acres; could have four residential units.
  • APN 101-28-013B – Owned by Testan Properties LLC, zoned Single-Family Residential (R1), currently vacant, .71 acres; could have four residential units.
  • APN 101-28-013D – Owned by Northland Hospice, zoned Single-Family Residential (R1), currently developed with Northland Hospice facilities. 
Key Considerations:
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 Planning and Zoning Commission 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 amendment is to resolve a conflict in the Rural Floodplain Map.  The existing Switzer Wash within the subject area has been significantly altered through various development projects over time and no longer meets the intent and purpose of the Rural Floodplain.  This amendment will change the designation from Rural Floodplain to Urban Floodplain.  The Regional Plan does not specifically address Rural versus Urban Floodplain as described in the Zoning Code.

Floodplains in general are considered environmentally sensitive lands which are covered in the Regional Plan on page IV-16.  The plan states, “These areas contain critical resources and require special consideration in the development design and review process.”  The following goals and policies apply to this application:

Goal E&C.7 Give special consideration to environmentally sensitive lands in the development and review process.
  • Policy E&C.7.1. Design development proposals and other land management activities to minimize the alteration of natural landforms and maximize conservation of distinctive natural features.
  • Policy E&C.7.2. Favor the use of available mechanisms at the City and County level for the preservation of environmentally sensitive lands, including but not limited to public acquisition, conservation easements, transfer of development rights, or clustered development with open space designations.
Development in Floodplains is regulated by Title 12 of the Flagstaff City Code entitled Floodplains, which is managed through our Stormwater Program as part of the Water Services Division.  No new structure or development is permitted to be constructed without full compliance with these regulations.  Development standards in the flood fringe include proper anchoring (if necessary), flood resistant materials and construction methods, and elevation and flood proofing requirements. If the applicant’s proposed development moves forward, they will be required to comply with all portions of these standards which are intended to protect the public health, safety, and general welfare, and to minimize public and private losses due to flood conditions. The applicant’s development proposal is also in alignment with the above referenced policies as they attempt to avoid most of the floodplain by clustering the development outside the Flood Fringe.  This causes an additional burden on the applicant with the remainder of this site outside the Flood Fringe impacted by slopes and forest resources.

The Environmental Planning & Conservation Chapter of the Regional Plan includes two maps that help identify concentration of natural resources in Flagstaff.  Map 7: Significant Natural Resource: Wildlife, Vegetation, Hydrology and Geology identifies the subject areas as a potential site for Riparian Vegetation.  A visit to this site shows only Ponderosa Pine and native grasses and typical riparian vegetation.  Map 8: Concentration of Natural Resources shows the subject area in the moderate range of resource concentration without further indication of the resource identified in this area.  The area is not identified as a Watchable Wildlife Area.  Both maps include notes that the indication of natural resources does not preclude private development entitlements.

Other provisions of the Regional Plan that apply to this application are found in the Stormwater and Watershed Management section covered on page VI-14.  This section identifies that watercourse preservation and restoration is a critical and necessary part of stormwater and watershed management.  The following goals and policies apply to this application:
 
Goal WR.5. Manage watersheds and stormwater to address flooding concerns, water quality, environmental protections, and rainwater harvesting.
  • Policy WR.5.1. Preserve and restore existing natural watercourse corridors, including the 100-year floodplain, escarpments, wildlife corridors, natural vegetation, and other natural features using methods that result in a clear legal obligation to preserve corridors in perpetuity, where feasible.
  • Policy WR.5.3. Identify downstream impacts as the result of development and provide for mitigation measures to address impacts.  When possible, mitigations should be non-structural in nature.
If this floodplain’s watershed were impacted by fire in the future increasingly the likelihood of flooding in the area, beyond what has already been identified, the City would be limited in managing this floodplain area because of the Rural Floodplain designation.  Staff believes the best possible result for this area would be to see the existing floodplain restored and preserved.  The possibility of making that a reality due to land ownership, parcel configuration, and existing development is limited.  Lastly, any new construction will be required to comply with existing Floodplain regulations that would address the issues with downstream impacts.

The proposed amendment can be found consistent and conforms to the objectives and policies of the Regional Plan.  There are no specific plans that cover this area.

B.  Finding #2: The proposed amendment will not be detrimental to the public interest, health, safety, convenience or welfare of the City.

The proposed amendment is not anticipated to be detrimental to the public interest, health, safety, convenience, or welfare of the City.  This amendment will resolve a conflict in the Rural Floodplain Map.

C.  Finding #3: The proposed amendment is internally consistent with other applicable provisions of this Zoning Code.

The current indicated area is inconsistent with the description of Rural Floodplains. Rural floodplains are described as “…natural undisturbed open spaces that are unsuitable for development purposes due to periodic flood inundation and the need to preserve the stream corridor for beneficial uses such as the preservation of important ecological resources.” The Zoning Code describes the Urban Floodplain as watercourses “…in urbanized areas [that] have typically been altered from their natural state by channelization.” The applicant has provided a biological evaluation of the Switzer Wash in the subject area prepared by Natural Channel Design, Inc. in 2003. The report states the following: “The primary limiting factors to the biological and physical functions of Switzer Creek are direct manipulations of the channel and floodplain during past construction of surrounding roads, utility pipelines, and other infrastructure.  In several places the channel and floodplain have been significantly narrowed and/or completely realigned.  Large rock has been added to the banks and channel presumably to minimize erosion.  Extensive spoil piles limit access to the active floodplain.  Steep road embankments contribute to increases sediment supplies.  Channel realignments have pushed the channel into dense thickets of Ponderosa pine.  The cumulative impact of these modifications limits the function of the riparian system.” The proposed amendments enhance the Zoning Code’s internal consistency by resolving a conflict on the Rural Floodplain Map pertaining to the subject property.
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 was advertised in the Arizona Daily Sun on September 10, 2022. Also, persons of interest that are on file with the Planning and Development Services Section were notified of the work sessions and hearings via first class mail.  The applicant also held a neighborhood meeting inviting all property owners within 300 feet.  The meeting was held on August 25th from 10:00 a.m. to noon on the parcel.  Approximately 24 members of the public attended the meeting but only 11 attendees signed in.  Concerns presented included the following:
  • Concerns that a change from Rural to Urban would open the possibility of further channelization of water through the area and prevent it from soaking into the water table that provides our drinking water. 
  • Concerns that a change from Rural to Urban would create flooding concerns for businesses and residencies downstream from the location. 
  • Concerns that a change from Rural to Urban would impact wildlife that uses the area as a corridor. 
Staff was contacted by several community members requesting additional information about the application.  As of the preparation of this report, staff has received eight public comments via email, which are attached to this report.
Attachments
Application
Zoning Code Text Amendment Narrative
Letter from Northern Arizona Healthcare
Letter from Testan Properties LLC
Regional Plan Map 7
Regional Plan Map 8
Citizen Participation Plan
Public Comments
Ord. 2022-28
Exhibit A
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 22-Apr-24 10:46 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
203 ms 203 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
140 ms 140 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
140 ms 140 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
0 ms 0 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(6878, 2, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/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/print_agm_ud.cfm
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
219 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

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

final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 22:46:48.048
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3649 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 22:46:48.048
 		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 @ 22:46:48.048
 		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 @ 22:46:48.048
		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 @ 22:46:48.048
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 3650 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 @ 22:46:48.048
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 3650 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 @ 22:46:48.048
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 = 3649 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 = 3650 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 @ 22:46:48.048
		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 @ 22:46:48.048
		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 @ 22:46:48.048
			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 @ 22:46:48.048
			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 @ 22:46:48.048
			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 = 6878 AND
				      u.rev_num = 2 
getfi14 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 22:46:48.048
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi14'
			
fi14q (Datasource=, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 22:46:48.048
					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) = 2022-11-15

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

GetThisLine (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 22:46:48.048
				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 = 3649 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 = 43740 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 22:46:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3649
					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 @ 22:46:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3649
					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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 22:46:48.048
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3649
					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 @ 22:46:48.048
					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 @ 22:46:48.048
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 6878 AND
					      rev_num = 2
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 22:46:48.048
	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 @ 22:46:48.048
	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 @ 22:46:48.048
		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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 22:46:48.048
		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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
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=11&get_year=2022&dsp=agm&seq=6878&rev=2&ag=3649&ln=43740&nseq=6881&nrev=2&pseq=6879&prev=2
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=11&get_year=2022&dsp=agm&seq=6878&rev=2&ag=3649&ln=43740&nseq=6881&nrev=2&pseq=6879&prev=2
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=9220044
cftoken=fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
hitcount=4
lastvisit={ts '2024-04-22 22:46:48'}
timecreated={ts '2024-04-22 22:46:48'}
urltoken=CFID=9220044&CFTOKEN=fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
Cookie Variables:
CFID=9220044
CFTOKEN=fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=3649
DISPLAY_ID=6878
DISPLAY_REV=2
Session Variables:
cfid=9220044
cftoken=fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9220044_fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
subdir=/public/
tzoffset=0
urltoken=CFID=9220044&CFTOKEN=fa8e4e70e572317d-5EC3D9D1-A6E6-E1F0-84EBCD38B901B551
URL Parameters:
ag=3649
dsp=agm
get_month=11
get_year=2022
id=
ln=43740
mt=ALL
nrev=2
nseq=6881
prev=2
pseq=6879
rev=2
seq=6878
Debug Rendering Time: 0 ms