Return
CITY COUNCIL SPECIAL WORK SESSION
FRIDAY, APRIL 28, 2017

FLAGSTAFF BUSINESS ACCELERATOR
2225 NORTH GEMINI ROAD
    FLAGSTAFF, ARIZONA
12:00 NOON
 
 
MINUTES
     
             
1.
Call to Order

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).
  Mayor Evans called the Special Work Session of April 28, 2017, to order at 12:01 p.m.
             
2. Pledge of Allegiance
  Vice Mayor Whelan led the audience and Flagstaff City Council in reciting the Pledge of Allegiance and Councilmember Odegaard read the Mission Statement of the City of Flagstaff.
             
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 PUTZOVA
ABSENT:

COUNCILMEMBER OVERTON





  Others present: City Manager Josh Copley and City Attorney Sterling Solomon. Guests present: State Representative Bob Thorpe and State Senator Sylvia Allen.
             
4. State Legislative Briefing
  City Manager Josh Copley welcomed the legislators to the luncheon meeting, stating that this was an informal opportunity for state legislators to have a conversation with the Council and referenced the handout which outlined the City's Intergovernmental Relations Program.

Senator Allen provided an update of what has been happening down at the state:

Think it is going to be a good budget; it is structurally balanced and education will come out well. She said that they were not in favor of the TPT (transaction privilege tax) for the universities because of the impact it would have on rural cities and counties. The money that the universities need to bond will come out of the general fund.

She said that as Chairman of the Education Committee, they have been focusing on education and have been able to do some good things for the teachers. They used to have to renew certificates every 6 years; they have put in some reforms that have moved that to 12 years. They did away with provisional certificates. Once they get through student teaching they should be able to get their certificate and move on.

She said that there are not a lot of teachers in the rural areas, so they are providing for an emergency certification that will provide a professional who has content knowledge and a bachelors degree or masters degree the ability to substitute at a school. Additionally, she said that they are in dire need of physics and chemistry teachers and they have set up $300,000 to allow for scholarships of $2,000 if they are teaching fifth grade math or biology. She said that if they are willing to get extra training, they will help pay for that education.

She said that they have a $250,000 student loan program to help those teachers willing to teach in rural Arizona for three years money toward their student loans. She concluded, noting that Snowflake Junior High School won a national Samsung grant for demonstrating how important STEM is, and they will be getting $240,000.
  Representative Thorpe provided an update of what has been happening down at the state:

Social service providers - Something they need more funding for and he has met with other members to make them aware of the need.

With regard to universities, there is $15 million in the Governor's proposal.

Dark Skies License Plates, he said that they get so many requests and they are normally approved, but it is difficult for ADOT stay on top of them. He said that there are a lot of up-front fees. He said that he is a big supporter of dark skies and has met with Lowell for a long time, and he supports the request.

He said that there are a number of members going to do another tour of the forests. He said that there are many different things in Northern Arizona taking place with regard to the forests. He has met numerous times with Dr. Covington who has told him that their forests should be around 50 trees per acre, but in most cases they exceed 300 an acre. When they have that density it is not healthy and is prone to fire.

He said that he met with Game and Fish re a $10 million bond which the Center for Biological Diversity was trying to stop because of the spotted owl.

He asked City staff to send him an outline of issues related to the state liquor licensing laws; he would be happy to help.

With regard to the Aviation Fund, he said that he was not sure he was that aware. He did meet with the manager at Pulliam.

He said that the HURF funds are always a concern.

He said that two years ago there was a $2 million hit to county juvenile corrections. This year their budget for the state is $250 million. He offered a bill for the smaller counties to eliminate the juvenile correction facilities and transfer them to larger facilities.

Additionally, he said that this last year he ran legislation to help correct a problem in Sedona to make zoning protests consistent with County language.

He said that most members at the Legislature do not want to go down the road of a TPT collection on universities going to them. He said that they recognize there is a need, but it not only impacts the state, but the local communities.

He said that the budget includes $55 million for new school construction K-12 which seems to be going through okay.

The budget also includes a 1% bonus for teachers, which equates to around $30 million.

Representative Thorpe said that he has a good relationship with the director of the Department of Housing and would be happy to talk with him about the housing issue.

With regard to SB 1487, he said that he is Vice Chairman of Government and he would have changed it to where nothing would occur as long as there was good communication happening between the legislator and the City. He said that he will bring back a bill next year. He feels that the State Legislature needs to be treating the local cities with respect and if there is a problem, to address it respectfully through communication.

Senator Allen said that she had not seen the City's list. With regard to the Senate Budget, they included a higher raise for teachers, and she believed they will win on that item.

She said that she also got involved with the mental illness issues and has been working with Jeff Taylor with Salvation Army. They are trying to make it to where when someone is arrested, instead of having them incarcerated, they are treated for their addiction. By treating them up front, it will save them money in the long run.

She briefly reviewed the listed items, noting that she supports the changes proposed by Representative Thorpe with regard to SB1487. She said that forest health is a priority for her and there is money in the budget for a State Forester. She said that she would like to learn more about the PACE program. She was not familiar with it, but would be happy to advocate.

Senator Allen said that she would like more information on the lowest responsible bidder issue, would be looking at state housing and noted that HURF is always a big deal. She said that Prop. 301 was important to education and they need to get back on the ballot.
  At this time the work session was opened up for comments from Councilmembers.

Councilmember McCarthy said that the gas tax has not been raised since the mid 1990's. Maintenance of the roads is of real concern to the public and an increase could provide funding for road widening and improvements. Representative Thorpe agreed that the tax has not not kept up with inflation, and they have seen a 500% increase in paving projects. He said that not sweeping those funds for DPS would be a benefit, but right now the tax is not keeping up.

Representative Thorpe continued, with regard to DPS, that at the remote stations around the state, the facilities in which the officers live are mobile homes built in the 1970's and they are starting to fall apart. They need $9 million to start replacing those facilities. He said that for someone traveling from Flagstaff to Page, through Gray Mountain, if they were to lose the DPS officers the only officers out there would be tribal and it is important to have a DPS presence.

Councilmember Odegaard thanked everyone for attending today. He said that he was glad to hear that it sounds like the TPT shift to the universities was dead.

He said that one of his concerns, with being a small business owner, is in sending his sales tax collection down to the state. He would like to see that come back to the local communities. He said that the local government can meet the needs and questions that businesses have faster and more responsively.

Senator Allen said that is an issue they are hearing a lot about now. She said that if they have a problem with the Department of Revenue, they should contact her office; they have ways to get through some of those barriers quicker.

Mayor Evans noted to the public in attendance that if they had written comment cards completed, they could hand them to Mr. Dille, to make sure they are included in the conversation.

Vice Mayor Whelan said that she shared in the appreciation for coming up and spending time with them. She also shares the passion for their state, community and education system. With that in mind, she wanted to reflect about the idea of one size fits all. She was concerned with lowering the standards required of teachers. She said that education is much more about dumping information. She said that they have moved toward the industrial model of everyone being taught the same, but the beauty is that they are all different and need different types of learning.

With regard to SB1487, Vice Mayor Whelan said that she looks at it as if she does her responsibilities, she gets her allowance; if she pushes up against some authority, she does not. She said that they are all invested in this; they are all elected officials.

Representative Thorpe said that he has had a great experience with the Flag Coconuts and has been a judge for there competitions. He said that he has toured the City's two high schools and was so impressed. He has told the principals that they need to share what they are doing around the state.

Representative Thorpe said that he and Senator Allen travel around the country in the off season and go to meetings where they get together with other legislators. He said that at the last meeting he met with a delegation from Utah where they are providing a tablet for one year, as a loan, to children that were pre-K. He said that it was costing the state $800 per child, but when they entered Kindergarten and first grade, they were one to two grades ahead of the others.

Councilmember Putzova asked if either legislators would be willing to entertain the idea of repealing SB1070 to keep their residents from living in fear. Representative Thorpe said that SB1070 occurred before he was down there, but his understanding is that after court challenges, 90% of the law was found constitutional. He said that the Feds typically see themselves as the final arbitrator re immigration and he doubts there is anyone in the Legislature interested in repealing it. He then reviewed some different meetings he has had with residents in the southern part of the state regarding illegal crossings.

Senator Allen said that she would not see any way of getting it repealed. She is more interested in putting more effort in the legal immigration path. She said that it used to be a lot easier and cheaper. In the 1970's her family sponsored a family to relocate. She said that for two to three years she has dealt with the Chairman of the Board of Security and it is a horrendous problem in southern Arizona. She said that their nation has a right to secure its border.

Councilmember Barotz asked the legislators to address local control. Representative Thorpe said that he appreciates local control, but he also appreciates uniformity with some items throughout the state. They try to have a balance of both. Senator Allen said that the cities are dependent on the state and the states are dependent on the Feds. In the state position, they have to look at what is good for the entire state. She said that she supports local control and tries to be careful in her votes, as they all depend on each other.

Councilmember Barotz urged the legislators to continue on the path to prohibit guns in public facilities. She said that she is terrified to sit in a chamber that would allow for guns. Representative Thorpe said that they just recently installed metal detectors at the House. He said that in a perfect world they would be able to have a police officer at each entrance.
             
5. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  None
             
6. Adjournment
  Mayor Evans presented each legislator with a token of appreciation. Mayor Evans invited the citizens to stay and interact with the legislators and the meeting was adjourned at 1:07 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 18-Apr-24 11:29 AM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
156 ms 156 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
125 ms 125 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/Application.cfm
62 ms 31 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.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
218 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=62ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:29:23.023
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:29:23.023
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:29:23.023
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 11:29:23.023
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:29:23.023
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 11:29:23.023
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 11:29:23.023
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=16ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=15ms, Records=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 11:29:23.023
		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-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 11:29:23.023
			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(580 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 @ 11:29:23.023
	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 @ 11:29:23.023
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 579 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
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 = 579 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 = 248 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=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
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 @ 11:29:23.023
	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 @ 11:29:23.023
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
		
	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 = 248 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 248 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=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6096 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4602 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6101 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4603 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6095 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4604 
get_Minutes (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6100 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4605 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4615 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4616 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6097 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4618 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6098 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 11:29:23.023
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4617 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:29:23.023
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:29:23.023
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:29:23.023
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 11:29:23.023
		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=4&get_year=2017&dsp=min&seq=580
HTTP_USER_AGENT=claudebot
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=4&get_year=2017&dsp=min&seq=580
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=9113130
cftoken=d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
hitcount=4
lastvisit={ts '2024-04-18 11:29:23'}
timecreated={ts '2024-04-18 11:29:23'}
urltoken=CFID=9113130&CFTOKEN=d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
Cookie Variables:
CFID=9113130
CFTOKEN=d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=580
Session Variables:
cfid=9113130
cftoken=d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9113130_d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
subdir=/public/
tzoffset=0
urltoken=CFID=9113130&CFTOKEN=d00e9c945696859c-78904511-DF13-D9E4-E3E98B03DD759030
URL Parameters:
dsp=min
get_month=4
get_year=2017
id=
mt=ALL
seq=580
Debug Rendering Time: 0 ms