City Council Meeting - FINAL (AMENDED)


Return to the Search Page Return to the Agenda
  15.B.       
Meeting Date: 12/17/2019  
From: James Janecek, Project Manager

Information
TITLE
Discussion: Coconino County Flood Control District Potential Project Funding Options.
STAFF RECOMMENDED ACTION:
The Stormwater Staff recommends that the City of Flagstaff Council draft a resolution that expresses support for a direct allocation approach of distributing collected Coconino County Flood Control District (CCFCD) tax revenue to municipalities for their flood control projects.
EXECUTIVE SUMMARY:
Coconino County (County) has requested feedback from elected officials of municipalities within the County regarding project funding options through the Coconino County Flood Control District (CCFCD). These requests were made at a meeting held on October 1, 2019. Two basic strategies are presented on how collected property taxes would be distributed to stakeholders in the County, including the County itself, for flood control projects: 1) Direct Allocation and 2) Competitive Grant. The direct allocation concept consists of the CCFCD distributing a percentage of the total CCFCD collected tax revenue to municipalities based on municipality's percentage of the total CCFCD property taxes contributed. The competitive grant process consists of the distribution of the CCFCD tax revenue to those applying to receive funding based on projects competing on their merits using a pre-defined and objective project ranking criteria. There has been some informal discussion among other municipalities on a hybrid of these 2 approaches, however, the Flagstaff Stormwater Section has not received any definitive proposal yet.

The competitive grant approach has the benefit of funding larger projects, but invites a more complex and potentially subjective process.

The direct allocation approach has the benefit of a simplified process, but annual funding might be less than what could be obtained through a fair competitive grant approach.
INFORMATION:
The information in this staff summary uses the best knowledge available by staff, but is not guaranteed to be error free.
 
During the last year, Coconino County has begun collecting property taxes assessed on properties located within the City of Flagstaff jurisdiction for the purposes of funding the Coconino County Flood Control District (CCFCD) as allowed by the Arizona Revised Statutes (ARS) Section 48-3602. Per ARS section 48-3603 and 48-3620, one of the primary functions of any flood control district in Arizona is to “implement flood control enhancement solutions” for the “common benefit” of the district.
 
State statues that govern flood control districts do not define common benefit, however the Arizona Revised Statutes (ARS) section 48-3604 does outline a process where a County flood control district may decide to divide itself into zones, presumably for the purpose of demonstrating common benefit of taxes collected in that zone versus flood control district expenditures in that same zone.
 
CCFCD held a stakeholder meeting on October 17, 2018 to discuss different approaches for the expenditure of CCFCD funds, primarily direct allocation versus open competitive grants.  The term “direct allocation” is a term coined by Coconino County in those presentations, however Arizona Revised Statues uses the term “zones” for essentially the same process.
 
A meeting was held on November 2, 2018 in the City management offices to discuss the information that was presented by the County. Staff made a recommendation at this meeting that the City proceed forward with a direct allocation approach with a hypothetical CCFCD zone map that I had prepared the week prior (attached as Exhibit A). It was determined at this meeting that additional research was needed to explain how other County flood control districts were using direct allocation and competitive grant processes. Staff completed this research in December 18, 2018 and this information was emailed by the Stormwater Section manager to Brad Hill, the Water Services division director. The results of this research are included below:
 
Example of Direct Allocation Process Used by Mohave County Flood Control District (or “Mohave County FCD”)
Based on staff research and phone conversations, Mohave County uses a direct allocation approach where property taxes collected from properties within municipalities is essentially returned to the municipality through Intergovernmental Agreements (IGA’s) based on that municipality’s percentage of total property taxes collected for Mohave County, however, the Mohave County FCD will keep a percentage of the tax revenue for their overhead and management costs, as allowed by ARS. Unincorporated areas receive funding for drainage improvement projects in their area based simply on the Mohave County’s FCD’s internal Capital Improvement Projects (CIP) program. Unincorporated area projects are reviewed for inclusion into Mohave County’s FCD CIP program once they are identified by flooding complaints or maintenance crews. To staff's knowledge, there is not a separate “small project” funding set-aside category of their CIP program.   If any of the municipalities needed more Mohave County FCD project funding that what was available from their annual allocation for a particularly large project in that jurisdiction, they would simply bank their allocation over several years until they were able to fund the project. As allowed by ARS, Mohave County’s Board of Supervisors also act as the Mohave County FCD Board. Direct allocation funding sent to municipalities is not a guarantee; Mohave County FCD will track and review projects for appropriateness and qualification for Mohave County FCD expenditures. 
 
Example of Competitive Grant Process Used by the Maricopa County Flood Control District (or “Maricopa County FCD”) 
The Maricopa County FCD has an advisory board that presents its recommendations to the Maricopa County FCD board for CIP funding. The advisory board receives recommendations from the Maricopa County FCD staff who rate projects submitted for review. According to a comprehensive report published on the Maricopa County FCD website, the report appears to publish all of the projects submitted by agencies for review and consideration, as the total list of needed projects is about $1.5B for an annual CIP budget of approximately $50M. The report also presumably lists all Maricopa County FCD projects completed since the Maricopa County FCD’s inception.
 
Per ARS, the advisory board consists of seven members: five members will be appointed residents with one from each district and qualified to vote, one ex-officio member will be the City engineer from the largest city, and the last ex-officio member will be a representative from the largest irrigation district. Of the five appointed members, three must be residents of cities in Maricopa County. ARS states that advisory boards are optional, but if a FCD wants to set one up, the rules are specific. As an interesting side-note, some counties in Arizona only have three districts and would not be able to fulfill this advisory board requirement if they in fact wanted an advisory board. Pima County actually has a 12-member committee that serves an advisory role. The Flagstaff city limits intersect four districts, and ARS does not specifically state that the three residents who must be City residents must come from different cities. Conceivably, a hypothetical seven-member Coconino County FCD advisory board might have four City of Flagstaff residents.
 
Budget and Project Ranking:
The Maricopa County FCD receives requests for funding and they process these requests based on a standardized process. The request is initially reviewed by Maricopa County FCD staff for completeness and administrative standards. City of Flagstaff staff has not confirmed what these administrative standards are in this particular context, but it is presumed that the project must meet Maricopa County project development standards and floodplain regulations, and must contain all information requested in their funding application. The Maricopa County FCD staff can deny the project from moving forward through the process. All projects are then ranked and sent to the advisory board for consideration, with the highest ranked projects recommended for approval. The projects are then ranked based on the following criteria with Stormwater Section Staff comments in parenthesis:
  1. Funding Commitment/Agency Priority (20 points)
(Interpretation: Is the applicant ready to go and ready to fund their share?)
  1. Flood Control/Drainage Master Plans (8 points)
(Interpretation: Did the applicant plan their project appropriately to consider regional impacts even though the project met all FCD standards?)
  1. Flooding Threat (15 points)
(Interpretation: How serious is the flooding?)
  1. Level of Protection (10 points)
(Interpretation: How much will the project improve the situation?)
  1. Area Protected (25 points)
(Interpretation: Tell the Maricopa County FCD more about the flood reduction benefits of the project?)
  1. Ancillary Benefits (12 points)
(Interpretation: Extra points are awarded for economic benefits, water quality improvements, wildlife enhancements, etc.)
  1. Level of Partner Participation (12 points)
(Interpretation: Is the applicant ready to spend more than the required minimum percentage, or provide other means of cost share, such as in-kind services or dedications of land? Is there a third party funding addition?)
  1. Operations and Maintenance (O&M) Costs to FCD (6 points)
(Interpretation: Will the applicant operate and maintain the project after its built?)
 
It appears that the Maricopa County FCD is trying to set up a means where benefits and costs are defined as points instead of a more formal benefit cost ratio (BCR).
 
The Maricopa County FCD Comprehensive Report from 2015 suggests that the largest projects selected for funding constituted about 20% of their total Capital Improvement Projects budget. All projects funded by the Maricopa County FCD will require an Intergovernmental Agreement (IGA). The Maricopa County FCD CIP budget has a portion of it allocated for small projects to reduce “red tape” and get small projects built relatively quickly. This “small project fund” is called the Small Project Assistance Program (SPAP) and typically constitutes about 6% of the total Maricopa County FCD CIP budget on average. Project costs are construction only, and typically cannot exceed approximately 10% of the SPAP budget. The Maricopa County FCD pays up to 75% of construction costs only; No operations and maintenance (O&M), property acquisition, permitting or project design/planning costs are paid by the Maricopa County FCD. Funding is meant for a single project (not phased), and typically more focused on the prevention of flooding of structures rather than including considerations of ancillary benefits.
 
Requests for SPAP funding will be reviewed by the Maricopa County FCD staff using a simplified project scoring matrix but the SPAP project may be referred to the more comprehensive general CIP project ranking process.
 
The SPAP project ranking criteria is as follows:
  1. Smallest storm event flooding the structure(s)?
(Interpretation: This is a measure of how severe the flooding is.)
  1. Number of structures being flooded?
(Interpretation: How widespread is the flooding?)
  1. Number of times the structure(s) have been flooded?
(Interpretation: This determines whether the structure(s) actually flooded or flooding is theoretical?)
  1. Does project incorporate water conservation, alternative stormwater management or 3rd party funding?
(Interpretation: Extra credit for ancillary benefits.)
  1. Smallest storm flooding roadway or access?
(Interpretation: Flooding of transportation infrastructure is also a problem of flooding.)
  1. Design plans complete?
(Interpretation: Is the applicant ready?)
  1. Does project have all right-of-way and/or easements in place?
(Interpretation: is the applicant ready?)
  1. Is the project one of the applicant’s top priorities?
(Interpretation: Self explanatory.)
 
The following project ranking criteria were proposed by Coconino County at their October 17, 2018 stakeholder meeting:
  1. Level of mitigation.
  2. Structures mitigated (number and to what degree).
  3. Mitigation to critical infrastructure.
  4. Is project in a FEMA recognized floodplain?
  5. Historic flooding issues.
  6. Alignment with applicant’s Drainage or Floodplain Master Plans.
  7. Simple Benefit Cost Analysis.
  8. Applicant’s financial contribution.
City of Flagstaff Stormwater CIP Current Project Ranking Criteria
The City of Flagstaff’s current Stormwater Section CIP Project Ranking Criteria is the following (each with a maximum 10 points)
  1. Urgency – Is there a bridge about to crumble?
  2. Severity of Hazard – Is the structure subjected to 1 foot of water or 8 feet of water?
  3. Feasibility – Does project have community support and property rights in place?
  4. Cost – What are the benefits relative to cost?
  5. O&M – What positive or negative impact does project have on the City’s O&M costs?
  6. Regulatory Compliance – Does project correct a regulatory deficiency such as non-code-compliant structures?
  7. Environmental and Sustainability – does project promote/benefit the City’s environmental and sustainability goals?
  8. Other Community Benefits – does project promote/benefit other City goals?
The Staff research report concludes with a recommendation that the City pursue a direct allocation approach.

On November 16, 2018 a letter from the Flagstaff City Attorney to the Coconino County Attorney and the CCFCD states “…plans presented by the County officials raise several concerns. The County’s plans demonstrate the County has already made conclusions about projects and priorities for the expenditures of tax payer dollars.”

The CCFCD held a stakeholder meeting with staff from municipalities in March 2019. On April 9, 2019, the City of Flagstaff sent a letter to the CCFCD on behalf of the municipalities stating, “Based on the information provided by the County over the past several months, it is clear that the CCFCD has not changed their priorities for projects and thus plans to move forward with them as previously defined, and without the benefit of a master plan which would identify drainage and flood control needs within the District as a whole. As the City of Flagstaff has expressed numerous times in various formats, this is not acceptable as it provides no opportunity for the cities/towns taxed by the County to fairly compete for projects funded by tax dollars taken from their own residents. The Flood Control District has picked specific projects without an equitable process.”  
Information received from the CCFCD indicates that the City of Flagstaff residents contribute approximately 50% of the current $2.5M to $3M tax revenue, and the total CCFCD budget is anticipated to increase in the future from increased property taxes.

In April of 2019, the CCFCD staff presented to the CCFCD Board of Directors several options for the expenditure of CCFCD revenues, and none of the options presented follow either a direct allocation or competitive grant process. The City of Flagstaff received an email from the CCFCD staff with a copy of the presentation that is assumed to be the same as what was presented to the CCFCD Board of Directors. Option 1 highlights the highest CCFCD priorities as it represents the leanest proposed CCFCD budget. Option 1 lists the following categories:

Salary/ERE’s – $380,500
Operations –  $575,000  (Itemized forest restoration and plan implementation of $185,000 for Mormon Mountain, Sedona/Oak Creek and Munds presumed to be included in $575,000)
Capital: Forest Restoration for Bill Williams Mountain  - $650,000
Capital: Air Curtain – $130,000 (this is smoke reduction equipment for waste biomass burning)
Mountain Dell – $1,980,000
Total = $3,715,500 (this is added here but not listed in the presentation)

The April-CCFCD presentation does show details for a hypothetical direct allocation program, and includes a line item for direct allocation within proposed larger CCFCD budgets created through tax increases, however the amount of direct allocation ranges from 6% to 10% of the total CCFCD proposed budgets.

Concerns from staff that have not yet been addressed:

1. How has the CCFCD determined that the proposed costs for Salary/ERE’s and Operations complies with state law? For example, does the preparation of forest restoration studies count as “operations”, or should they be defined as “projects”?

2. How were projects listed by the CCFCD as highest priority objectively ranked through a transparent process to show common benefit to the district? There are no City of Flagstaff projects listed in Option 1 of the April 2019 CCFCD presentation. The City of Flagstaff Rio de Flag project, that represents a flood control project affecting most of downtown and NAU, is not listed. Bill Williams Mountain forest restoration is listed, but nothing from the Flagstaff Watershed Protection Project within the City of Flagstaff.

3. How will emergency response expenditures be defined? For example, IF emergency response is defined as ALL costs associated with flood emergency response/flood damage correction/flood threat mitigation/infrastructure improvements needed for all downstream areas from the burned watershed conditions from the Schultz Fire, would that that same definition be applied to the Museum Fire response? 

4. ARS Section 48-3616 D. states, “After a flood control district has been established in a county with a population of fewer than three hundred thousand persons, the chief engineer may conduct a survey of flood control problems, prepare a comprehensive program for flood control and a five-year capital improvement program pursuant to this section. He shall at least make an assessment of flood control problems in the area of jurisdiction and make an annual report of his findings and recommendations for dealing with them to the board.” Where is this assessment that includes the City of Flagstaff? If the City of Flagstaff is not represented in this assessment, how can City of Flagstaff residents be taxed?

Conclusion
The Stormwater Section staff interpret the actions by the CCFCD thus far as a negative bias against the City of Flagstaff, and therefore direct allocation is recommended. However, direct allocation as thus far proposed by the CCFCD, is unacceptable as the allocation is being defined as a small percentage of the CCFCD budget, and the direct allocation is being defined exclusive of budget allocations for CCFCD projects.

The Stormwater section staff recommends that the City of Flagstaff draft a resolution that expresses support for a direct allocation approach of distributing collected CCFCD tax revenue to the City of Flagstaff and other interested municipalities for their flood control projects however, the such a resolution should include conditions that the allocation is defined after reasonable subtractions needed from the CCFCD for their administrative and operations costs as allowed by state law. The resolution could also include conditions for the competitive grant approach as an alternate approach.

The Stormwater Section is examining other alternatives for CCFCD accountability including transfer of floodplain management responsibilities from the City to the CCFCD to ensure that the City of Flagstaff is unquestionably part of their area of jurisdiction, and as such, search for construction funding for the Rio de Flag project and forest restoration in the City of Flagstaff for the Flagstaff Watershed Protection project. ARS does allow the CCFCD to refuse to fund municipal projects that have already been initiated, however ARS does not define the term "initiated" in the statutes that govern flood control districts as applied to the aforementioned City projects. For example, many projects in other flood control districts in Arizona are defined as construction, and therefore the project was indeed not initiated if only design has been completed.

 
Attachments
Presentation
Hypothetical CCFCD Zones
Letter from jurisdictions to the CCFCD 4-9-19
CCFCD presentation to the Board of Directors 4-16-19


    

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 01-May-24 11:03 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
203 ms 203 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(4392, 1, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/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
203 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

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

final_check (Datasource=frsRO, Time=0ms, Records=18) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 11:03:40.040
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 971 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 11:03: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 @ 11:03: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 @ 11:03:40.040
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03:40.040
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 972 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=18) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03:40.040
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 972 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03: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 = 971 AND agi._rowid = 82)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 972 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 82 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03: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 @ 11:03: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 = 82)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '82')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03: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_fi8')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03: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 = '82'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03: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 = 4392 AND
				      u.rev_num = 1 
getfi8 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03:40.040
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi8'
			
fi8q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 11:03:40.040
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi8' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2019-12-17

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

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:03: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 = 971 AND ai._rowid = 82)
				
				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 = 22871 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:03:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 971
					AND a.ag_level1 = '17'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:03:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 971
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'B'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 11:03:40.040
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 971
					AND a.ag_level1 = '17'
					AND a.ag_level2 = 'B'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:03: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 @ 11:03: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 @ 11:03: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 @ 11:03: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=12&get_year=2019&dsp=agm&seq=4392&rev=1&ag=971&ln=22871&nseq=4384&nrev=1&pseq=4404&prev=0
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=12&get_year=2019&dsp=agm&seq=4392&rev=1&ag=971&ln=22871&nseq=4384&nrev=1&pseq=4404&prev=0
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9431030
cftoken=a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
hitcount=4
lastvisit={ts '2024-05-01 11:03:40'}
timecreated={ts '2024-05-01 11:03:40'}
urltoken=CFID=9431030&CFTOKEN=a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
Cookie Variables:
CFID=9431030
CFTOKEN=a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=971
DISPLAY_ID=4392
DISPLAY_REV=1
Session Variables:
cfid=9431030
cftoken=a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9431030_a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
subdir=/public/
tzoffset=0
urltoken=CFID=9431030&CFTOKEN=a356ce5914c4526b-1512DCE8-A3DB-29B6-6E0ACB7BB81FCC9B
URL Parameters:
ag=971
dsp=agm
get_month=12
get_year=2019
id=
ln=22871
mt=ALL
nrev=1
nseq=4384
prev=0
pseq=4404
rev=1
seq=4392
Debug Rendering Time: 16 ms