Return
FLAGSTAFF CITY COUNCIL BUDGET RETREAT
FLAGSTAFF CITY COUNCIL CHAMBERS
211 WEST ASPEN
FLAGSTAFF, ARIZONA
THURSDAY, FEBRUARY 16, 2017
8:00 A.M.
MINUTES
             
1.
Call to Order

Mayor Evans called the Budget Retreat to order at 8:03 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
  The audience and City Council recited the Pledge of Allegiance.
             
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 (arrived at 8:35 a.m.)
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA (arrived at 8:08 A.M.)
ABSENT:

NONE






  Others present: City Manager Josh Copley and City Attorney Sterling Solomon
             
4. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone to have an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak.

None
             
5. City Council FY 2018 Budget Retreat  - February 16, 2017
 
  Mr. Copley began the introduction of the meeting, asking each Councilmember to share their objectives for the Retreat.

INTRO AND RETREAT OBJECTIVES

Councilmember Barotz said that she would like to weave into the conversation the e-mail regarding the total revenues they get from the state so they understand that in the context of all the other decisions they are making.

Mayor Evans said that she would like to have a conversation about the property tax levy, what it is and what it is not.

Vice Mayor Whelan said that they should be mindful of their goals and as they speak about items to keep in mind their growth and how quickly that is happening. Also, the current large stress and pressure that the community is feeling.

Councilmember Barotz said that she has some comments about issues that came up the other night with the state funding and the organizations that care for those who cannot care for themselves. She would like to see more engagement in the legislative issues that concern the City and possibly add that to the Legislative agenda.

Management Services Director Rick Tadder then continued the presentation:

REVENUE OUTLOOK
CITY SALES TAX - GENERAL FUND
STATE SHARED SALES
STATE SHARED INCOME TAX
FRANCHISE TAXES
BUILDING PERMITS
BBB SALES TAX
HIGHWAY USER REVENUES
REVENUES AND FIXED COSTS
REVENUE UPDATE SUMMARY - GENERAL FUND
EXPENDITURE UPDATE - FIXED COST SUMMARY - GENERAL FUND
REVENUE AND EXPENDITURE UPDATE - OTHER CONSIDERATIONS
PERSONNEL COSTS IN 1X
REVIEW REVENUE OPPORTUNITIES - COUNCIL DIRECTION
REVENUE OPPORTUNITIES - PROPERTY TAX LEVY

Discussion was held on the need to define the terminology in discussing the tax levy and using the actual percentage rate rather than the percentage increase. Council discussed the need to use wording that is easy for the public to understand when discussing the tax levy and tax rate. It was noted that the final determination by Council with regard to the property tax will take place at the April Budget Retreat.

REVENUE OPPORTUNITIES - SALES TAX

Discussion was held on a potential sales tax on water that has not been taxed before. This is one item, similar to groceries, that the City can charge tax on but selects not to. It was noted that this was separate from the water/wastewater funds which are operated as enterprise funds. This tax is a general sales tax that would go into the General Fund and could offset increased costs and inflation. Consensus of Council was to not increase the sales tax. Some members stated that if it did move forward it would be best to have it go toward a specific project.

SALES TAX INFORMATION
TOTAL TAX BY TYPE BASE RATE
CURRENT SALES TAX RATES FOR CITIES IN NORTHERN ARIZONA
REVENUE OPPORTUNITIES - USER FEES AND OTHER FEES
RIO DE FLAG - COUNCIL DIRECTION
RIO DE FLAG FUNDING
UTILITY RELOCATION CONTRIBUTION
STORMWATER FUND

Interested was voiced by the Council to research stormwater fees paid by Northern Arizona University.

GENERAL OBLIGATION BOND

Discussion was held on the possibility of including a question on the 2018 ballot regarding a general obligation bond for the Rio de Flag project. Many Councilmembers agreed with researching this further. It was emphasized that information pamphlets need to be clear about what the impact to a family would be with such an approval. It was noted that the Council needs to continue working with Washington D.C. to have the project funded, but this would assist with needed funding. When they go to D.C. they need to go with a plan. Consensus of Council was to keep this option in the toolbox for further consideration.

SALES TAX

A majority on Council was in favor of keeping this option in the toolbox.

ADDITIONAL CONSIDERATIONS

USER FEE DISCUSSION
USER FEES 2017
COUNCIL DIRECTION
KEY CONCEPTS TO DISTINGUISH
WHAT IS THE TIMETABLE FROM THIS TIME FORWARD?
OVERVIEW
DIRECTOR AND SECTION HEAD PRESENTATIONS
  Planning Director Dan Folke continued the presentation:

PLANNING & DEVELOPMENT SERVICES SECTION USER FEE DISCUSSION
PLANNING & DEVELOPMENT SERVICES FEES
USER FEE RECOMMENDATIONS

A break was held between 11:00 a.m. and 1:30 p.m. at which time the Mayor reconvened the Budget Retreat.

USER FEE RECOMMENDATIONS

Discussion was held regarding the User Fees in Community Development. It was noted that legally such fees may not be waived, but they may be reimbursed through various programs, such as if the Council wished to focus on affordable housing. That reimbursement would come from a housing fund to offset the expenses.

Mr. Folke noted that currently there are nine applications for which they do not collect a fee.

Mr. Tadder noted that the current policy of past Council was to have a recovery rate of 71%; however, they are currently collecting at 37%. By going to a recommended 53% they would actually be increasing revenues. Discussion was held on why they were not meeting the 71% policy. It was noted that if they stayed with the 71%, it will need to be framed that they are implementing what a former council put into place. The messaging will be important.

After further discussion, majority of Council recommended moving forward with staff's recommendation of 53%.

City Engineer Rick Barrett then continued the presentation:

ENGINEERING
Development
Transportation
Inspection/Testing
CIP

Mr. Barrett noted that payroll constitutes 95% of the budget he covers. Currently Engineering is on a 50% policy recovery, based on prior direction, except when they were asked to eliminate the Materials Testing Lab and go with private sector providers, that went to 100%.

He said that his staff recommendation is to go to 100% cost recovery for most of the work done in Engineering. He said that once a project gets to Site Plan Approval and they move forward to construction plan review and the engineering reviews, they should be at 100%.

Mr. Barrett said that he has identified some new services for which they currently do not charge a free.

ENGINEERING SECTION RECOVERY

He said that their overall actual cost recovery at this time is 36%, while the current policy is 50%. His recommendation is 100%.

Mr. Copley said that they receive a lot of complaints about customer service, but they are actually running on the lean side. They have been trying to recruit a traffic engineer, but they could not get adequate applicants with the amount the City is willing to pay.

Discussion was held on a third and subsequent TIA (Traffic Impact Analysis). Mr. Barrett said that they have found over and over that at the end of twp reviews they are not ready to approve a TIA. The bottom line is they do not believe they have really uncovered, or properly identified, the impacts of these developments. Mr. Copley said that they are not proposing a new service, but rather a fee for a current service.

ENGINEERING SECTION RECOVERY

Discussion was held on the reasoning for having Planning at 53% recovery and engineering at 100%. Mr. Barrett said that the Planning Fees are on the front-end of the project, concept through site plan approval. Once they get to construction and permitting issues must be addressed more closely.

Staff was told that a question they are going to get is why they are increasing the fees if they are subsidizing at over 60% right now, and they need to be prepared to address that issue with the building community.

Community Development Director Mark Landsiedel said that Engineering is very lean. During the construction bubble they had 95 people in Planning; today they are at 60 with 2/3 staffing.

Mr. Landsiedel said that when they get to Engineering, it feels more black and white; however, Mr. Barrett's section looks at variances on virtually every project. They do not just say "no," they try to work with them. That takes time to provide that level of service.

DIRECTION

Consensus of Council was to move forward as recommended by staff.

Mr. Barrett noted that they do have a TIA discussion on the working calendar to discuss that issue further.

Fire Chief Mark Gaillard then continued the presentation:

FIRE DEPARTMENT
Development Permits (Construction)
Operational Permits
Special Event Permits
Wildfire Management

OPPORTUNITIES - POLICY DISCUSSION
Risk vs. Frequency
One-time Fee vs. Repeat Fee
City Sponsored Event vs. Non-City Sponsored Event
Development (Cost Recovery)
Operational (Cost Recovery)

NEW CONSTRUCTION - COMPARISON

STAFF RECOMMENDED CHANGES
Expansion of Fee System of 15-80 Permits
     Development Permits - 5-54 - 100% cost recovery
     Operational Permits - from 6-24 based on risk and new/expanded permits - 40% cost recovery
     Special Event - from 1-5 based on increased demand and scope/size of event - 100% cost
          recovery

SUMMARY
FY15
     Current Actual - 24%
     Current Policy - 28%
     Recommendation - 73%

PUBLIC OUTREACH
     Chamber of Commerce
     NABA
     Local Fire Protection Contractors
     Local Special Event Vendors

COUNCIL DIRECTION

Move forward with staff's recommendations.

Parks and Recreation Director Rebecca Sayers continued the presentation:

RECREATION SERVICES
Current Policy on Direct Costs Recovery
     50% youth enrichment events and activities
     100% adult enrichment/special programs

BASED ON DIRECT COSTS

Aquaplex - 70% cost recovery

RECOMMENDATION

Staff's recommendation is to keep the current fee schedule.

MINIMUM WAGE
     $10 - $75,000 increase
     $12.25 - $260,000 increase

To maintain the existing revenue, it means their cost recovery will go down further.

OUTREACH EFFORTS
     Parks and Recreation Commission
     Affected User Groups

Discussion was held on publicizing the services more and working through the schools.

A break was taken from 3:06 p.m. to 3:22 p.m.

Deputy City Manager Shane Dille then continued the presentation:

OBJECTIVES

ECONOMIC DEVELOPMENT
AFFORDABLE HOUSING
SOCIAL JUSTICE
TRANSPORTATION AND OTHER PUBLIC INFRASTRUCTURE
BUILDING AND ZONING/REGIONAL PLAN
CLIMATE CHANGE
WATER CONSERVATION
ENVIRONMENT AND NATURAL RESOURCES

He then reviewed the Administrative Goals

COMMUNITY OUTREACH
SOCIAL MEDIA
TOWN & GOWN
CODE COMPLIANCE

Council agreed with the objectives presented.
             
6. Informational Items To/From Mayor, Council, and City Manager.
  Councilmember Odegaard said that the Council's travel expense budget is split seven ways equally, but he does not think it is fair that the Mayor's funding is the same as Council's. He would like a F.A.I.R. item on this issue.

Councilmember Barotz said that they used to have the State delegation come and meet with the Council to review the Council's legislative agenda. Mr. Copley said that he would put that on the agenda.

Councilmember McCarthy said that he felt it would be appropriate, as well, to meet with the Board of Regents.

Vice Mayor Whelan asked if there was any way to speak with the Chamber of Commerce Board. Mr. Copley said that as a Council they would have to schedule a special meeting, but any individual Council member, or two, could do that on their own.

Vice Mayor Evans said that there is a bill going through the House, SB14532, regarding immigration enforcement and repeal of SB1070 ,and  she would like additional information on that and a resolution of support.
             
7. Adjournment
  The Budget Retreat of February 16, 2017, adjourned at 4:54 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 06-May-24 06:11 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/agpub_min_dsp.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 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 @ 18:11:04.004
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 18:11:04.004
				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 @ 18:11:04.004
			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 @ 18:11:04.004
				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 @ 18:11:04.004
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 18:11:04.004
	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=16ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:11:04.004
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:04.004
		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 @ 18:11:04.004
	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 @ 18:11:04.004
		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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
		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 @ 18:11:04.004
		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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:04.004
	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=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:04.004
		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) = 2017-02-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-02-28 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:11:04.004
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
		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 @ 18:11:04.004
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 = 537 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:11:04.004
		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) = 537

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 18:11:04.004
			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(537 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 @ 18:11:04.004
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 536 
getAllMnLines (Datasource=frsRO, Time=46ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
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 = 536 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 = 255 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=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
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 @ 18:11:04.004
	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 @ 18:11:04.004
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
		
	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 = 255 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 255 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 @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6197 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6200 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4663 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6195 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4664 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6196 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6202 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4665 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4666 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6198 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4667 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6199 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 18:11:04.004
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4668 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 18:11:04.004
	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 @ 18:11:04.004
	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 @ 18:11:04.004
		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 @ 18:11:04.004
		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=2017&dsp=min&seq=537
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=2017&dsp=min&seq=537
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=9567714
cftoken=9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
hitcount=4
lastvisit={ts '2024-05-06 18:11:04'}
timecreated={ts '2024-05-06 18:11:04'}
urltoken=CFID=9567714&CFTOKEN=9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
Cookie Variables:
CFID=9567714
CFTOKEN=9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=537
Session Variables:
cfid=9567714
cftoken=9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9567714_9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
subdir=/public/
tzoffset=0
urltoken=CFID=9567714&CFTOKEN=9bde06d659e80f2f-25D3E201-F4F5-5C4E-434EA2C6CF8406ED
URL Parameters:
dsp=min
get_month=2
get_year=2017
id=
mt=ALL
seq=537
Debug Rendering Time: 0 ms