Return
CITY COUNCIL BUDGET RETREAT
MONDAY, FEBRUARY 12, 2018
AND TUESDAY, FEBRUARY 13, 2018
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
9:00 A.M. & 1:00 P.M.
             
1.
Call to Order

Mayor Evans called the Budget Retreat of the Flagstaff City Council held February 12, 2018, to order at 9:00 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. Pledge of Allegiance and Mission Statement

The Council and audience recited the pledge of allegiance.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

NONE






  Others Present: Interim City Manager Barbara Goodrich; City Attorney Sterling Solomon
             
4. City Council Fiscal Year 2019 Budget Retreat
  Ms. Goodrich began a PowerPoint Presentation that covered the following:
 
RETREAT OBJECTIVES AND OUTLINE
COUNCIL GOALS AND OBJECTIVES CHECK IN
 
Deputy City Manager Shane Dille continued the presentation.

AGENDA
HOW DID WE GET HERE?
WHY THE MATRIX WORKS
HOW IS IT WORKING FOR YOU?
 
Council briefly discussed how the matrix is working for them and requested quarterly updates to the document. It was also suggested that an overview of the goals and accomplishments be published in CityScape.
 
Management Services Director Rick Tadder continued the presentation.
 
REVENUE UPDATES
CITY SALES TAX – GENERAL FUND
 
Mr. Tadder explained that the revenue team has put significant effort into updating the website and providing as much information as they can regarding the transition to the State collecting sales taxes.
 
Mr. Tadder also reported that construction has seen the largest growth in sales tax revenues. It is unsure how long that will continue so staff is documenting those as more of a one-time bump.
 
Mr. Tadder continued.
 
STATE SHARED SALES TAX
STATE SHARED INCOME TAX/URBAN REVENUE
FRANCHISE FEES
BUILDING PERMITS
BED, BOARD AND BEVERAGE (BBB)
HIGHWAY USER REVENUE (HURF)
 
Finance Director Brandi Suda continued the presentation.
 
AVAILABLE REVENUES AND FIXED COSTS
FIXED COSTS – PENSION
 
Councilmember Whelan asked how the pension fund became so underfunded. Ms. Goodrich offered that it was a combination of things; what has mostly impacted the situation is the under-realized investment earnings. When the anticipated interest earning estimates were not realized it increased contributions to compensate. Another factor was the result of two lawsuits that determined that moving the employee share from 7.65% to 11.65% was not permissible and then rolled back to 7.65% with cities and towns having to refund those contributions.
 
Mr. Tadder continued.
 
FIXED COSTS – HEALTH BENEFITS
REVENUE UPDATE SUMMARY – GENERAL FUND
FIXED COSTS SUMMARY – GENERAL FUND
 
A break was held from 10:32 a.m. through 10:44 p.m.
 
At this time public comment was received from the following individuals regarding the budget:
  • Armando Bernasconi, Quality Connections
Human Resources Director Shannon Anderson continued the presentation:
 
BENEFITS
NAPEBT
HEALTH BENEFITS
NATIONAL TRENDS
NATIONAL TRENDS UTILIZATION VS. INFLATION
NATIONAL TRENDS COST MANAGEMENT STRATEGIES 2016 & 2017
NATIONAL TRENDS REGIONAL VARIATIONS
ARIZONA TRENDS
ARIZONA TREND MEDICAL PREMIUM COST SHARING FOR EMPLOYEE-ONLY
ARIZONA TREND MEDICAL PREMIUM COST SHARING FOR EMPLOYEE PLUS FAMILY
ARIZONA TREND MEDICAL PREMIUM COST SHARING
ARIZONA TREND ANNUAL MEDICAL PLAN DEDUCTIBLES
ARIZONA TREND OFFICE VISIT COPAYMENTS
ARIZONA TREND OUT OF POCKET MAXIMUMS
ARIZONA TREND PRESCRIPTION DRUG COPAYMENTS
NAPEBT TRENDS
NAPEBT RENEWAL
NAPEBT RENEWAL ADDITIONAL BENEFITS
WELLNESS
INCENTIVE PROGRAM
INCENTIVE PROGRAM SUCCESSES
NEAR SITE CLINIC
NEAR SITE CLINIC 2017 INITIATIVES
NEAR SITE CLINIC SUCCESSES
NEAR SITE CLINIC YEAR 2 ADDITIONS
BENEFITS – MATERNITY/PATERNITY LEAVE
PUBLIC SAFETY PERSONNEL RETIREMENT SYSTEM (PSPRS)
UNFUNDED LIABILITY STATUS
FY 2019 RATES AND COSTS
CONSIDERATION OF CHANGING AMORTIZATION PERIOD
PENSION POLICY DEVELOPMENT
WHAT ARE OTHER CITIES DOING
CONSIDERATION OF CHANGING AMORTIZATION PERIOD
STAFF RECOMMENDATION
 
Councilmember McCarthy asked what the amortization period is. Mr. Tadder stated that the expectation is to pay it off in a 20-year period.
 
Ms. Goodrich explained that the normal cost to support someone is about 15% versus the 85% the City has been paying to try and catch up.
 
Councilmember Overton stated that he would like to see the City be more aggressive in paying down the liability. He indicated that the City is currently maintaining and if another downturn hits this would be a $15 million budget item that is not negotiable.
 
A break was held from 12:22 p.m. through 1:00 p.m.
 
Mr. Tadder continued the presentation.
 
GENERAL OBLIGATION BONDS
HISTORY OF GO BONDS AUTHORIZED – 20 YEARS
GENERAL OBLIGATION BONDS
LEGAL LIMITS
SECONDARY PROPERTY TAX RATE
CAPACITY BASED ON CURRENT POLICY
 
At this time the following people addressed Council concerning the budget:
  • Janet Regner, Coconino County Community Services
Housing Manager Sarah Darr continued the presentation.
 
AFFORDABLE HOUSING
SEVERAL TASKS, ALL RELATED SOMEHOW
AFFORDABLE HOUSING
COUNCIL GOALS
COUNCIL OBJECTIVES
COUNCIL PRIORITIES
USE OF CITY OWNED LAND
PLAN MOVING FORWARD
FUNDING
HISTORY – STUDIES/REPORTS
CONSISTENT RECOMMENDATIONS:
ECONA STUDY AND RECOMMENDATIONS
WHAT CAN YOU DO WITH A BOND FOR AFFORDABLE HOUSING?
 
After discussion a majority of Council agreed to have staff do further research concerning an Affordable Housing bond question on the November 2018 ballot.
 
Human Resources Benefits Analyst Jennifer Caputo continued the presentation.
 
2017 EMPLOYEE SURVEY
2017 RESULTS
AREAS OF SIGNIFICANT INCREASE
AREAS OF SIGNIFICANT DECREASE
AREAS OF NO SIGNIFICANT CHANGE
SUMMARY OF WRITTEN COMMENTS
NEXT STEPS
 
Ms. Goodrich provided the following wrap up of the conversations:
  • Council would like to find better ways to use the Council Priorities and incorporate them into the budget process.
  • A majority of Council is interested in moving maternity/paternity leave forward for consideration.
  • Council would like to continue with a 20-year amortization on the PSPRS unfunded liability.
             
5. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.

None
             
6. Adjournment
  The City Council Budget Retreat of February 12, 2018, recessed at 2:27 p.m.
             
City Council Fiscal Year 2019 Budget Retreat - Day Two
             
1.
Call to Order

Mayor Evans called the Budget Retreat of the Flagstaff City Council held February 13, 2018, to order at 1:00 p.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
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

NONE






  Others present: Interim City Manager Barbara Goodrich and City Attorney Sterling Solomon.
             
3. City Council Fiscal Year 2019 Budget Retreat
  Interim Police Chief Dan Musselman began a PowerPoint presentation that covered the following:
 
PUBLIC SAFETY OPERATIONS UPDATE
FPD PUBLIC SAFETY STAFFING CONCERNS
STAFFING LEVELS ARE NO LONGER ADEQUATE
RETENTION AND RECRUITMENT
INCENTIVES AND INVESTMENTS
 
Deputy Fire Chief Mark Wilson continued the presentation.
 
COUNCIL QUESTIONS FROM DECEMBER RETREAT
CALL VOLUME VS FTE
COMPARISON TO OTHER CITIES
JULY 2016-JULY 2017 CALL VOLUME DENSITY MAP
NUMBER OF PARAMEDICS – COMPENSATION FACTORS
TYPES OF EMERGENCY MEDICAL SERVICE (EMS) CALLS 2016
IMPACTS TO SERVICE DEMANDS
 
Councilmember McCarthy asked what types of calls are being responded to at NAU. Deputy Chief Wilson stated that they range from alcoholism, drugs, broken limbs, assaults and other disputes. He stated that they will often see a spike in service when the new school year begins and then it levels out; the same is true when a new facility comes online.
 
Deputy Chief Wilson continued the presentation.
 
FEASIBILITY OF REOPENING FIRE STATION 32
WHAT IS ALL OF THIS TELLING US?
SUMMARY
 
Deputy Chief Wilson stated that there is a need for at least nine new firefighters as well as additional staff in wildland firefighting.
 
Councilmember Overton asked if the reorganization from a few years ago is working or if there is one station carrying more of a call load than others. Deputy Chief Wilson stated that the stations that have lower call volumes are being utilized as needed for other areas; the intent is to get as many of them out responding to calls. The crews are rotated to slower stations because they are getting so burned out. The use of CART has helped in the response.
 
Councilmember Overton asked where the new firefighters that are being requested would go. Deputy Chief Wilson stated that the biggest impact with bringing them on would be the reduction in overtime costs and burnout because they are currently so understaffed.
 
Police Chief Kevin Treadway added that there is a different model for policing; they do not respond from quadrants but rather assign officers in the field to different beats. Those beats have not been expanded in the last 15 years and as the city continues to expand the need directly equates to officers. During the graveyard shift there is only one supervisor and five officers covering the entire city. The minimum staffing level has not changed but additional officers would allow them to add a squad during the high-volume times.
 
Chief Treadway added that they have tried everything keep officers in Flagstaff; he is not aware of any other police department that has not reinstated merit and the merit issue comes up again and again when officers leave. Councilmember Overton stated that if merit is the need then City Council needs to find ongoing money for merit. Those ongoing dollars are difficult to find and merit takes a large portion of that. He would like to see public safety as a priority for merits.
 
Wildland Fire Manager Paul Summerfelt continued the presentation.
 
WILDLAND FIRE MANAGEMENT (WFM) FLAGSTAFF WATERSHED PROTECTION PROJECT (FWPP) COMPLETION AND PROGRAM SUSTAINABILITY
THE SETTING
OUR INVESTMENT: THE CYCLE OF SUCCESS
THE GOOD NEWS
FWPP STATUS AND NEEDS
WFM SUSTAINABILITY
SUMMARY
 
Mr. Tadder continued the presentation.
 
WILDLAND FIRE MANAGEMENT FUNDING CONSIDERATION
POSSIBLE FUNDING
 
Fire Chief Mark Gaillard continued.
 
SUMMIT INTERGOVERNMENTAL AGREEMENT (IGA)
FLAGSTAFF FIRE DEPARTMENT (FFD) SITUATION STATUS
FEATURES OF THE IGA
OPERATIONAL BENEFITS OF THE ENHANCED SUMMIT IGA
FISCAL IMPACTS
SUPPORT FOR IGA
RECOMMENDATION:
 
A break was held from 3:03 p.m. through 3:12 p.m.
 
Chief Gaillard continued the presentation.
 
PUBLIC SAFETY RESEARCH GROUP (PSRG) RESEARCH
CONCLUSIONS
RISK MANAGEMENT WAS ADDRESSED
EXAMPLES OF BOTH AGENCIES SHARING RESOURCES
FISCAL ANALYSIS
QUID PRO QUO
 
Council briefly discussed the cost savings associated with partnering with Summit Fire and the benefits that it could provide.
 
Assistant to the City Manager Caleb Blaschke continued the presentation.
 
NATIVE AMERICAN STRATEGIC INITIATIVES
NATIVE AMERICAN AFFAIRS LIAISON
INDIGENOUS CIRCLE OF FLAGSTAFF
 
Mayor Evans stated that she recently met with the Indigenous Circle of Flagstaff (ICF) and one thing that they shared concerns that if the Liaison position had other duties as assigned that the meaning and purpose would be lost. They also expressed a need for a leader or Executive Director to focus on establishing an organization that could overlook and direct the implementation of a strategic plan.
 
Rose Tsosie addressed Council as a member of ICF and offered that they believe there is a better way to do this; they need the ability to establish a foundation or organization through a 501(c)3 who can move the plan forward and operate
 
Chris Jocks, also with ICF, addressed Council stating that the process needs to be community driven. The first objective is to make sure there is adequate representation in the community. ICF does support the City having a liaison to spearhead the program forward. He stated that the community needs to be involved in developing the job description as well as be represented through the selection process.
 
Councilmember Putzova left the meeting at 3:50 p.m.
 
Council had further discussion about the need for ICF to develop a non-profit agency to help with the collection and distribution of funds.
 
Ms. Goodrich continued the presentation.
 
SERVICE PARTNER CONTRACTS
DISABILITY PROVIDERS
 
Quality Connections CEO Armando Bernasconi addressed Council requesting that the Council direct staff to do research for short-term and long-term funding.
 
The Council discussed the chronic underfunding of the disability service providers by the State, and how the increase in minimum wage is further impacting their operations. They also discussed the need to treat the community fair and how singling out one specific service may present a challenge. Council discussed the possibility of the State to provide a funding match if the City were to provide the base funding and how they need to be cautious of dedicating financial resources before having all the proper information. Additionally, finding a revenue source for this direction will be important to ensure that the City’s base services continue to operate. The Council agreed to send a letter to the State seeking more information.
 
Ms. Goodrich continued the presentation.
 
RELOCATION ASSISTANCE FOR TRAILER PARK CLOSURES
 
Council discussed the possibility of the City establishing its own fund to provide this type of assistance for trailer park closures Council gave direction for staff to look at establishing a program and the legal aspects of doing so.
 
Code Enforcement Manager Reggie Eccelston continued the presentation
 
GRAFFITI ABATEMENT
GRAFFITI BUSTERS PROGRAM
            COMMUNITY BENEFITS
            FUTURE CONSIDERATIONS
 
A break was held from 4:55 p.m. through 5:03 p.m.

Human Resources Director Shannon Anderson continued the presentation.
 
COMPENSATION
MARKET BASED PLAY
PAY EQUITY STUDY
BACKGROUND
OBJECTIVE
METHODOLOGY
ANALYSIS
FINDINGS BY DBM JOB VALUE
FINDINGS BY MIDPOINT
FINDINGS BY COMPA-RATIO
ORGANIZATION WIDE STATISTICAL FINDINGS BY DBM JOB VALUE
ORGANIZATION WIDE STATISTICAL FINDINGS BY PAY GRADE MIDPOINT
STATISTICAL FINDINGS BY DIVISION
RECOMMENDATIONS
NEXT STEPS
 
Ms. Goodrich reviewed the areas she heard from Council that need to be brought forward during the next budget retreats.
  • Police – increase personnel and stabilize retention.
  • Fire – address service level concerns with the Fire Department
  • Wildland Fire Management – leverage money the City has and engage community partners
  • Native American Affairs – development of a one-year strategic plan and development of a group to accept funding from the City or outside organizations.
  • Service Partner Contracts – provide a letter of support on the grant application to State for relocation of trailer assistance.
  • Graffiti Abatement – provide additional funding to enhance the program.
             
4. Adjournment
  The City Council Budget Retreat of February 13, 2018, adjourned at 5:27 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 02-May-24 07:18 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
234 ms 234 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
171 ms 171 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 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
234 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 @ 19:18:44.044
			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 @ 19:18:44.044
				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 @ 19:18:44.044
			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 @ 19:18:44.044
				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 @ 19:18:44.044
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 19:18:44.044
	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 @ 19:18:44.044
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:18:44.044
		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 @ 19:18:44.044
	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 @ 19:18:44.044
		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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
		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 @ 19:18:44.044
		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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
	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 @ 19:18:44.044
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:18:44.044
	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=32ms, Records=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:18:44.044
		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) = 2018-02-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-02-28 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 19:18:44.044
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=78ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
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 = 676 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 19:18:44.044
		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) = 676

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:18:44.044
			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(676 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 @ 19:18:44.044
	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 @ 19:18:44.044
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 675 
getAllMnLines (Datasource=frsRO, Time=62ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
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 = 675 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 = 399 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 @ 19:18:44.044
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 @ 19:18:44.044
	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 @ 19:18:44.044
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
		
	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 = 399 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 399 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 @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8726 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8729 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8725 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6245 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8731 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6246 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8727 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8728 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6247 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8732 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8733 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8734 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6249 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8735 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6250 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8736 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:18:44.044
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6251 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 19:18:44.044
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 19:18:44.044
	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 @ 19:18:44.044
		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 @ 19:18:44.044
		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=2018&dsp=min&seq=676
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=2018&dsp=min&seq=676
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=9466271
cftoken=15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
hitcount=4
lastvisit={ts '2024-05-02 19:18:44'}
timecreated={ts '2024-05-02 19:18:44'}
urltoken=CFID=9466271&CFTOKEN=15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
Cookie Variables:
CFID=9466271
CFTOKEN=15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=676
Session Variables:
cfid=9466271
cftoken=15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9466271_15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
subdir=/public/
tzoffset=0
urltoken=CFID=9466271&CFTOKEN=15a76d1285c0237e-5A45A5D7-0462-3FE4-2AC74C672B20914B
URL Parameters:
dsp=min
get_month=2
get_year=2018
id=
mt=ALL
seq=676
Debug Rendering Time: 0 ms