Return
CITY COUNCIL BUDGET RETREAT
MONDAY - TUESDAY
FEBRUARY 3 - 4, 2020
FLAGSTAFF AQUAPLEX
1702 NORTH FOURTH ST.
 8:00 A.M.

 
MINUTES
             
1.
Call to Order

Vice Mayor Shimoni called the Budget Retreat of the Flagstaff City Council held February 3, 2020, to order at 8:31 a.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS (arrived at 11:08 a.m.)
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
ABSENT:









  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
             
3. Priority Based Budgeting Online Tools & Roadmap
  Mr. Clifton introduced Chris Fabian and Kathie Novak with Resource X who provided a PowerPoint presentation that covered the following:
 
PRIORITY BASED BUDGETING PROJECT RECAP AND NEXT STEPS
TODAY’S AGENDA: 3 KEY POINTS
            PROJECT RECAP
            HOW TO EXPLORE YOUR DATA
            LOOK TOWARD THE FUTURE
GENERIC LINE ITEM DATA VISUAL
            WHY PBB?
MEASURE INVESTMENT IN RESULTS
CREATE BASIC PROGRAMMATIC INSIGHT
IDENTIFY OPPORTUNITIES FOR FUTURE ACTION
NEARLY 300 IMPLEMENTATIONS OF PRIORITY BASED BUDGETING (PBB)
RECOMMENDED BEST PRACTICE – ICMA, GFOA, NLC, ALLIANCE FOR INNOVATION
PROJECT RECAP
IMPLEMENTING PRIORITY BASED BUDGET
            CREATE PROGRAM INVENTORY
            PROGRAM COSTING
            PROGRAM SCORING
            BUDGET ADOPTION
DATA LAYERS
            INPUTS/OUTPUTS
            RESULTS/BPA’S
            FINANCIALS/PERSONNEL/HR
            PROGRAM INVENTORY
PROCESS TECHNIQUES
PROGRAM INVENTORY EXERCISE
            402 PROGRAMS OFFERED BY COF
PROGRAM COSTING
            ALLOCATION SUMMARY
            PLANNING TOOL
PROGRAM SCORES
MEASURE INFLUENCE ON RESULTS
BASIC PROGRAM ATTRIBUTES
FLAGSTAFF PROGRAM
ALIGNMENT OF RESOURCES
            The darker the color the higher degree of influence on the result areas
 
A break was held from 9:45 a.m. through 10:00 a.m.
 
Mr. Fabien and Ms. Novak provided a demonstration on how to utilize the tools and interpret the data.
 
HOW TO EXPLORE YOUR DATA
PROGRAM ATTRIBUTES
 
Mayor Evans arrived 11:08 a.m. and took over the management of the meeting.
 
LOOKING TOWARD THE FUTURE
DATA CREATION
INSIGHT OPPORTUNITIES
            IDENTIFY OPPORTUNITY
ACTION
            TAKE ACTION
1ST CYCLE
            FOCUS ON DATA CREATION
            FIRST ATTEMPTS AT DATA DRIVEN RESOURCE ALLOCATION
            USING PBB AS A GUIDE IN BUDGET RECOMMENDATIONS
2ND CYCLE
            FOCUS ON RESOURCE OPTIMIZATION
            APPLYING THE PBB BLUE PRINT
            RECOMMENDATIONS FOR RESOURCE REALLOCATION, AND REVENUE GENERATION
3RD CYCLE
            CONTINUED FOCUS ON RESOURCE OPTIMIZATION
            INTRODUCE FOCUS ON PERFORMANCE AND RESULTS ACHIEVEMENT
            KEY PERFORMANCE INDICATORS
 
Mr. Clifton asked how PBB has been implemented in other jurisdictions over time. Mr. Fabian stated that it is about creating the programs and scoring to better understand resource allocation. Starting with gathering data helps to define the areas of business then in subsequent years focus on maximizing discussions based on scoring. Ms. Novak added that during the budget cycle there are new initiatives that come forward and being able to see where those new initiatives may conflict or compliment existing programs is helpful. PBB offers the ability to determine how relevant an existing or new program aligns with the things that are important to Flagstaff.
 
IT’S 3-5 YEARS DOWN THE ROAD…
            WHAT FUTURE ARE YOU TRYING TO PREPARE FOR?
            WHAT PROGRAMS NEED TO START
            WHAT PROGRAMS NEED TO GROW
            WHAT PROGRAMS WILL NEED TO UNDERGO TRANSFORMATION
HOW DOES IT GET FUNDED?
BLUEPRINT FOR ACTION TO FUND THE FUTURE
            FREE-UP AND REALLOCATE RESOURCES
            GENERATE NEW REVENUE
 
Economic Vitality Director Heidi Hansen asked how many organizations lost staff with the implementation of PBB. Mr. Fabian stated that he does not have a statistic, but each community is different and each has their own unique financial situations. Ms. Novak added that it is unlikely that a staff member has all of their time allocated to a single program so if a program is eliminated, it frees that person up for more attention to a more relevant program. From a human resources perspective, it becomes a question of if the right people are in the right programs and the PBB tool helps to change the conversation about resource allocation and priority programs.
 
Vice Mayor Shimoni asked what they expect to be the biggest hurdles for implementation. Ms. Novak stated that a big hurdle will be for the Council to be patient through the first part; there is a lot of data gathering and sorting that has to be done before analysis can really happen by the Council. It takes time but roll out will come. Mr. Fabian added that from the staff perspective there is a lot of uncertainty about how things will score out and there is a tendency to ask how the tool will be used against them rather than how can it benefit. It is an education process to teach departments how to be empowered and use the tool to make good decisions and push things forward; once staff is able to see how this will benefit them then a culture of trust and acceptance can be built. The whole thing takes time and that can be frustrating at the beginning.
 
A break was held from 11:53 a.m. through 12:35 p.m.
             
4. City Council Fiscal Year 20-21 Budget Retreat
  Management Services Director Rick Tadder provided an PowerPoint presentation that covered the following:
 
REVENUE UPDATE
  CITY SALES TAX – GENERAL FUND (excluding Use Tax Increase)
STATE SHARED SALES TAX
STATE SHARED INCOME TAX/URBAN REVENUE
AUTO LIEU TAX (SHARED REVENUE)
FRANCHISE FEES
BUILDING PERMITS
BBB REVENUE
HIGHWAY USER REVENUE (HURF)
 
Vice Mayor Shimoni asked about internal operations to identify and close gaps in how the state is handling sales tax collection for the city. Mr. Tadder stated that they are working closely with the Department of Revenue to understand their processes and how to look at and present the data differently, so the city is able to identify and understand its trends. An external auditor is also being used to watch activity and make sure businesses are reporting activity correctly. They work with the county to identify when property changes hands and makes sure those taxes are collected. They also watch the sales tax revenues and provide collection services when necessary.
 
Mayor Evans stated that the city has hired an external auditor but those services are supposed to be provided by the state. Mr. Tadder agreed but added that the state is auditing and bring in revenues but they are not focusing directly on Flagstaff’s local businesses like the city’s auditor can.
 
Councilmember Whelan expressed a desire to discuss BBB allocations and the possibility of making adjustments to those allocations.
 
Finance Director Brandi Suda continued the presentation.
 
FIXED COSTS AND AVAILABLE REVENUES
PENSION CONTRIBUTION RATES
PENSION EXPENDITURES
 
Mr. Tadder Rick continued the presentation.
 
PUBLIC SAFETY PENSIONS
WHERE DOES FLAGSTAFF’S PLANS MEASURE UP?
UNFUNDED LIABILITY
UNFUNDED LIABILITY (DEBT)
PENSION FUNDING EQUATION
COMPONENTS OF CONTRIBUTIONS
WHERE DOES THE MONEY COME FROM?
IS THE PSPRS FUNDING POLICY WORKING?
PENSION TRENDS
WHY DOES IT SEEM TO BE GETTING WORSE?
WHAT IS POLITICAL WILL?
WHAT OTHER CITIES/COUNTIES HAVE DONE
SOME OPTIONS FOR REDUCING OUR UNFUNDED LIABILITY
 
Council and staff discussed the frustration associated with how the unfunded liability has increased each year despite the 20-year plan to pay down. It is difficult to add new initiatives or implement new services when there is so much uncertainty coupled with the significant impact on the general fund. Council discussed possible options to address the issue such as a bond, increased sales tax, impact fees, and the like. They indicated that they would like to continue looking at options and the need to make some hard decisions to address the situation.
 
Ms. Suda continued the presentation.
 
FIXED COST SUMMARY – GENERAL FUND
REVENUE UPDATE SUMMARY – GENERAL FUND
CITY EMPLOYER MINIMUM WAGE IMPACT
 
Management Analyst Jack Fitchett continued the presentation.
 
STATE MINIMUM WAGE ASSESSMENT UPDATE
TABLE OF ESTIMATES
 
Council discussed the need to be prepared for the invoice from the state. Mr. Clifton explained that funding will be set aside in the budget to accommodate the payment should it come to fruition.
 
Council requested a future executive session to discuss the response to the new law.
 
A break was held from 3:09 p.m. through 3:17 p.m.
 
Human Resources Director Jeanie Gallagher and Co-Chair of the EAC Jared Wotasik continued the presentation.
 
COMPENSATION UPDATE
BENEFITS - PENSION
BENEFITS – HEALTH
COMPENSATION
CITY-WIDE PAY HISTORY 2009-2019
EAC BUDGET RECOMMENDATIONS
SAMPLE EMPLOYEE PAY CHECK 1
SAMPLE EMPLOYEE PAY CHECK 2
 
Councilmember Whelan left the meeting at 3:34 p.m.
             
5. Public Participation

None
             
6. Adjournment

The Budget Retreat of the Flagstaff City Council held February 3, 2020, adjourned at 3:37 p.m. and reconvened at 8:30 a.m. on February 4, 2020.
             
7.
Call to Order

Mayor Evans called the Budget Retreat of the Flagstaff City Council held February 4, 2020, to order at 8:30 a.m.

NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
8. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD (arrived at 8:39 a.m.)
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN (arrived at 9:09 a.m.)
ABSENT:









  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
             
9. City Council Fiscal Year 20-21 Budget Retreat (continued)
 
Wildland Fire Manager Paul Summerfelt provided a PowerPoint presentation that covered the following:
 
WILDLAND FIRE MANAGEMENT
CONTINUITY OF PROGRAM
THE CYCLE OF SUCCESS
BACKGROUND
THE PROGRESS
THE NEED
COMMUNITY SUPPORT
THE URGENCY
THE REALITY
SUCCESSFUL WFM - $1.12 M
 
Management Services Director Rick Tadder continued the presentation.
 
FUNDING THE PROGRAM
MUNICIPAL BILL RATES – EQUAL RATES
 
Mayor Evans asked why the focus is on funding just the gap and not the full program. Mr. Tadder explained that they were looking to keep the fee low, the proposed fee would be what is needed to maintain the current program.
 
Council discussed the fee and expressed support for a tiered fee structure that over time would increase to cover the cost of the entire program.
 
Mr. Tadder continued.
 
MUNICIPAL BILL RATES – COMMERCIAL AT 50% OF RESIDENTIAL
ENVIRONMENTAL MANAGEMENT FEE (EMF)
 
Council discussed the Environmental Management Fee (EMF) and how it is applied to the municipal services bill. There was discussion about setting equal rates for commercial and residential users. The recommendation from staff is that instead of a set dollar amount per bill it is a percentage based upon total municipal use. Council did express concern about placing additional burden on residential users.
 
Mr. Summerfelt continued the presentation.
 
FWPP – A PROJECT
 
Mayor Evans noted that Mormon Mountain is not in city limits and the county has not contributed any direct funding to the project. She indicated that the project should be included in the Coconino County Flood Control District projects related to forest management. Mr. Summerfelt indicated that the city has made that request to the District but have not had any response. Fire Chief Mark Gaillard added that the city is not optimistic that the District will include the project as they have already identified Bill Williams Mountain as their priority.
 
Council expressed frustration with the Coconino County Board of Supervisors and the Flood Control District for how the process of identifying projects and allocation of funding has transpired.
 
Councilmember McCarthy asked what the financial need is. Mr. Summerfelt stated that $7 million is needed to complete Mormon Mountain and then ongoing funding for the ongoing maintenance.
 
Council requested an Executive Session to discuss the legalities surrounding the Coconino County Flood Control District and their assignment of project funding.
 
A break was held from 10:13 a.m. through 10:28 a.m.
 
Mr. Tadder continued the presentation
 
COMMUNITY SHARE AND SERVICE PARTNERS
CURRENT SERVICE PARTNER CONTRACTS
CURRENT SERVICE PARTNER CONTRACTS – BUDGET
POTENTIAL FY 2020-2021 REQUESTS
 
Vice Mayor Shimoni stated that he would like to have all the requests funded. Mr. Tadder acknowledged that all the programs are important for the community, but it is important to remember that there are significant demands on city resources; there is a strain on the general fund and that is where the funding for these contracts come from.
 
Councilmember Whelan asked if it would be possible to redirect some of the user tax to the service partner requests. Mr. Tadder stated that Council has the ability to redirect those funds.
 
After discussion of the contracts a majority of Council agreed to maintaining current service levels, continue with the new allocations to the United Way and the LAUNCH program, and not to move forward with the additional funding requests.
 
Mr. Tadder continued the presentation.
 
PROCESS FOR REQUESTING FUNDING
DISCRETIONARY FUND BUDGET CONSIDERATION
 
Mr. Clifton explained that the fund is a small allocation of money for various Council matters that come up through the course of the year. Use of the fund would require Council authorization. Council was supportive of the development of a Council Initiative Fund.
 
Public Works Streets Section Director Scott Overton continued the presentation.
 
SNOW MANAGEMENT
SNOW OPERATIONS – OVERVIEW
STREETS STATISTICS
SNOW OPERATIONS
THANKSGIVING EVENT
SNOW OPERATIONS – OVERVIEW
            STORM MONITORING
            EQUIPMENT PREPARATION
            OPERATOR AVAILABILITY
SNOW POLICY
BEST PRACTICES AND OPERATIONS
            PLOWING PROCEDURES
            SNOW PLACEMENT
            ICE TRACTION CONTROL
            SIDEWALKS
            FUTS AND ALLEYS
            SWEEPING AND CLEANUP
URBAN SNOW OPERATIONS CHALLENGES
2020-2021 STREETS BUDGET
ADDITIONAL CONSIDERATIONS
ALTERNATIVE OR ADVANCED EQUIPMENT
ROAD GRADER WITH GATE
 
Council inquired about a possible pilot project to test out the effectiveness of the gates. Mr. Overton explained that a pilot is possible but there are significant considerations as to where the use of the method would be possible. Driveway placement is key, and the gates work well for homes that are and spaced further out from each other; residential areas where homes are closer together may prove problematic.
 
Mr. Overton continued.
 
ALTERNATIVE OR ADVANCED EQUIPMENT
LOADER WITH PLOW AND WING
            ADDITIONAL FLEET EQUIPMENT
            SKID STEER
STAFFING LEVELS
            CHEMICAL DE-ICER PROGRAMS
            CONTRACTING AND INTERGOVERNMENTAL AGREEMENTS
 
Mayor Evans suggested that it may be time to revisit the possibility of using de-icer in Flagstaff. There are constant issues about cinders and ice in bike lanes as well as the time it takes to clean cinders from streets following snow events. Mr. Overton stated that he is happy to entertain a community conversation; he noted that there have been improvements to de-icer but there has not yet been a way to move away from the calcium chlorides.
 
Council discussed a need for stronger enforcement on parked cars and clearing of snow and cinders from sidewalks. A majority of Council expressed the desire to see a pilot program for the use of grader gates.
 
A break was held from 12:44 p.m. through 12:53 p.m.
 
Economic Vitality Director Heidi Hansen, Public Works Project Manager Adam Miele, and Airport Director Barney Helmick continued the presentation.
 
AIRPORT IMPROVEMENTS
TEMPORARY OVERFLOW PARKING
ADDITIONAL PERMANENT PARKING
FUTURE IMPROVEMENTS
AIRPORT 32-ACRE PARCEL
OTHER AIRPORT PLANS
 
Mr. Tadder concluded the presentation thanking staff for their participation and opened the floor for Council discussion.
 
Councilmember McCarthy requested more information and a possible discussion about other funding sources available for the Flagstaff Watershed Protection Project such as a stormwater fee.
 
Councilmember Odegaard requested funding for a literacy enrichment program for after school programing at the libraries. He also requested that there be consideration for hiring at least one more Police Aide.
 
Councilmember Whelan asked to look at the housing down payment program and ways to grow the fund. She does not want to see social programs cut and asked that other funding options be identified; she would also like to see these programs funded on an ongoing basis rather than one-time. She asked for consideration to use Prop 419 monies to fully fund JW Powell.
 
Vice Mayor Shimoni expressed excitement about the use of PBB in future years. He stated that he would like to see the budget include funding to revamp the website, an app for the community to engage with Council, and an opportunity for citizens to participate in the budget process through participatory budgeting. He requested funding to hire a part-time videographer.
 
Councilmember Salas indicated that she is also excited to see how PBB impacts future budget cycles to evaluate existing resources and how things may be able to be reallocated.
 
Councilmember Aslan stated that there needs to be an aggressive approach to paying down the unfunded pension liability. There are many things that the Council and community would like to see done, such as the Climate Action and Adaptation Plan, but the liability is severely limiting available resources to do so.
 
Mayor Evans stated that she has come a long way in understanding the budget process over her last twelve cycles. She encouraged Council to really think about wants versus needs when trying to balance the allocation of resources. She stated that she is interested in a budget that reflects Flagstaff and makes sure everyone is moving forward at the same rate.
 
Ms. Clifton concluded the retreat by offering thanks to the Council and staff for their preparation and input. He stated that there is much more work to be done and the information gathered from the retreat will help guide the next steps in the budget process.
             
10. Public Participation

None
             
11. Adjournment

The Budget Retreat of the Flagstaff City Council held February 4, 2020, adjourned at 2:04 p.m.
 
                  
___________________________________
MAYOR
  ATTEST:

 
 
  _________________________________
CITY CLERK
 

    

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

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


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


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
110 ms 110 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.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/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/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
172 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 @ 12:38:36.036
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 12:38:36.036
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 12:38:36.036
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 12:38:36.036
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 12:38:36.036
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 12:38:36.036
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:38:36.036
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	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 @ 12:38:36.036
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=31ms, Records=14) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 12:38:36.036
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2020-02-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2020-02-29 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:38:36.036
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=63ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
SELECT fas.form_num fas_form_num, 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,
	   ft.* ,
	   m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc,
	   agt.ag_template_name, agt.ag_template_id,
	   codes.long_descr px_size, codes.descr pdf_format, 
	   mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type,
 	   agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place
FROM minutes ft
INNER JOIN fas ON (fas.form_id = 'MINUTES' AND 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)
INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
LEFT OUTER JOIN codes crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE ft.meeting_id = 988 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 12:38:36.036
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 988

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 12:38:36.036
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(988 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 987 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
SELECT ml._rowid ln_rowid, ml.ln_rowid ml_rowid, ml.form_num, ml.rev_num, ml.seq_num,
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.footer_ln, ml.left_justify, ml.page_br,		
	   c.descr as status_desc,
	   
	   
	   ai.*,
	   
	   am.ag_item_rowid,
	   
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.left_justify,		
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)


LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 987 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)
LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = 637 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
	       
				'Y' can_look, 'Y' can_link	
			
			,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid,
			min.minutes_published min_published,
			a.agenda_published ag_published
	FROM minutes min
	INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num)
	INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND
		  							   docs.rev_num = ml.rev_num AND
		  							   docs.ln_rowid = ml._rowid
		  							
		  								AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
		  							)
	LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num)
	WHERE min.form_num = 637 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 637 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14553 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14552 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9672 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14557 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9673 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14558 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9674 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9678 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14563 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14559 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14560 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14561 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9676 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14562 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 9677 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14554 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 14555 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 12:38:36.036
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 12:38:36.036
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 12:38:36.036
	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 @ 12:38:36.036
		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 @ 12:38:36.036
		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=2&get_year=2020&dsp=min&seq=988
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=2&get_year=2020&dsp=min&seq=988
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=9331238
cftoken=242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
hitcount=4
lastvisit={ts '2024-04-27 12:38:36'}
timecreated={ts '2024-04-27 12:38:36'}
urltoken=CFID=9331238&CFTOKEN=242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
Cookie Variables:
CFID=9331238
CFTOKEN=242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=988
Session Variables:
cfid=9331238
cftoken=242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9331238_242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
subdir=/public/
tzoffset=0
urltoken=CFID=9331238&CFTOKEN=242043b1a1c65c09-4A7C27A3-C533-97FE-689818AACD4C6514
URL Parameters:
dsp=min
get_month=2
get_year=2020
id=
mt=ALL
seq=988
Debug Rendering Time: 0 ms