Return
 WORK SESSION
TUESDAY, FEBRUARY 13, 2018
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 



WORK SESSION
             
1.
Call to Order

Mayor Evans called the meeting of February 13, 2018, to order at 6:01 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. Pledge of Allegiance and Mission Statement

The Council and audience recited the Pledge of Allegiance and Ms. Goodrich read the Mission Statement of the City of Flagstaff.
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 (telephonically 6:28 p.m.-7:23 p.m.)
ABSENT:

NONE






  Others present: Interim City Manager Barbara Goodrich 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.
Preliminary Review of Draft Agenda for the February 20, 2018, City Council Meeting.*
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.

None
             
A. Review of the Proposed High Occupancy Housing (HOH) Specific Plan and Related General Plan Amendments. (SEE ITEM 13-A ON THE DRAFT AGENDA FOR THE REGULAR MEETING OF FEBRUARY 20, 2018, FOR INFORMATION)
  Comprehensive Planning Manager Sarah Dechter provided a PowerPoint Presentation that covered the following:
 
WHAT IS BEING ADOPTED/AMENDED?
ORDER OF COUNCIL ACTIONS
PLANNING & ZONING RECOMMENDATION
             
6. Discussion: Current Issues Before Arizona Legislature and Federal Issues
  Assistant to the City Manager Caleb Blaschke introduced the City’s State Lobbyist Richard Travis who was present via telephone. Mr. Blaschke provided a PowerPoint presentation that covered the following:
 
FLAGSTAFF INTERGOVERNMENTAL UPDATES – FEBRUARY 6, 2018
HB2266 DARK SKY LIGHTING SPECIAL PLATES
 
Mr. Travis stated that the bill passed both the democratic and republican caucus.
 
SCR 1016 REPEAL THE MINIMUM WAGE AND RESTRICT LOCAL GOVERNMENTS
FROM PASSING A MINIMUM WAGE HIGHER THAN THE STATE AS WELL AS REPEAL
THE MINIMUM WAGE
SB1146 AND HB2166 VEHICLE FEES; ALTERNATIVE FUEL VLT
 
Mr. Travis stated that polarity on the issue is expected; the most important bills are those that would give the Department of Transportation the authority to impose VLT fees to fund the Department of Public Safety (DPS).
 
Councilmember Odegaard stated that he thinks the City should support the bills because it would help with the sweep of HURF funds and help fund DPS. There has been disparity between regular fuel vehicles and alternative fuel vehicles but at the end of the day they are using the same roads.
 
Councilmember Overton offered that it seems odd that DPS was picked for the funding. He asked if there was any discussion about just putting the funding into the larger pot and distributing from there. Mr. Travis explained that DPS used to be a part of the Arizona Department of Transportation (ADOT) and eligible for HURF dollars; when DPS became their own agency they remained eligible for HURF funding but they were primarily funded by the general fund. When the economy dipped and general fund dollars became scarce, funding reverted back to HURF. That is why there is a link between DPS and HURF.
 
Councilmember McCarthy stated that the money should go to HURF for road construction and repair rather than DPS who do a lot more than protect the highways. DPS should be fully funded by the general fund.
 
Council agreed to stay neutral.
 
HB2461 ZONING REGULATIONS; PRIVATE SCHOOLS
 
Mr. Travis explained that this bill would prohibit a municipality from adopting land use regulations on a private school. He also stated that the League is opposed to this bill.
 
HB 2500 REAL ESTATE SIGNS; CITIES; COUNTIES
HB2371 MOBILE FOOD VENDORS; STATE LICENSURE
HB2480 URANIUM, RADIOACTIVE MATERIALS; TRANSPORTATION
             
7. Discussion/Direction: Ballot Measure for Rio de Flag Project on the November 2018 Election
  Councilmember Putzova joined the meeting telephonically at 6:28 p.m.
 
Management Services Director Rick Tadder addressed Council with a PowerPoint presentation that covered the following:
 
RIO DE FLAG PROJECT
SALES TAX CLARIFICATION
 
Councilmember Barotz stated that she has heard from constituents about the concern that the increase will also affect those local people who eat here but do not stay overnight. Councilmember McCarthy added that Flagstaff is in the ballpark for hotel tax but is substantially higher for food tax.
 
SALES TAX COMPARISON
FUNDING CONSIDERATIONS
0.25% SALES TAX – 7 YEARS NO STORMWATER FEE
0.20% SALES TAX – 7 YEARS AND STORMWATER FEE
0.15% SALES TAX – 7 YEARS AND STORMWATER FEE
0.20% SALES TAX – 5 YEARS AND STORMWATER FEE
0.15% SALES TAX – 5 YEARS AND STORMWATER FEE
NO SALES TAX AND 100% STORMWATER FEE
 
Councilmember McCarthy pointed out that the tax relies on people who do not live in Flagstaff. All the options raise the same amount of money; when the sales tax rate is lowered the stormwater fee increases.
 
Councilmember Odegaard asked the status of the design process for Rio de Flag. Senior Project Manager James Duval stated that the Army Corp has reached a settlement with the contractor and it is within the budget they have for this fiscal year’s work program. It is estimated that the design will be complete in about 12 months.
 
Mayor Evans stated that she has been pushing the project for the last ten years. She understands that the project needs to get done but does not feel that a sales tax is appropriate. There is a large percentage of the community who do not understand the magnitude and ramifications of a 100-year flood. She would like to see the City spend the next 18 months educating the public. She believes that a stormwater fee should be collected and built up so when it comes time to ask the voters to match the funds there is something to show for the progress made.
 
Councilmember Odegaard agreed stating that he is not supportive of a sales tax right now but rather putting money aside for the project. It will show the Army Corp that the City is still serious about the project. He is supportive of a stormwater fee adjustment to start saving.
 
Councilmember McCarthy stated that if the City does not come up with some funding, it will not look good when the Army Corps goes through their funding process. He is not in favor of a sales tax but is supportive on an increase to the stormwater fee.
 
Councilmember Odegaard offered that he is supportive of the $.92 per ERU stormwater fee; it will generate $1 million per year and in year two there may be a better understanding of where the project is with the Army Corp.
 
Mayor Evans stated that she could support that direction.
 
Councilmember Overton stated that the fee will only be captured from the property owners with a water meter and $1 million per year does show progress but it is still really short. The City will have to quadruple the fee midway through the increase to cover the cost. Additionally, not all people will pay the fee unlike a sales tax. Putting all the funding in the stormwater fee will have a big impact; rent and the cost of living will increase. The City has raised this fee once before and it was not well received.
 
Councilmember Putzova stated that the Rio de Flag is a stormwater infrastructure project and she is supportive of increasing the stormwater fee.
 
Councilmember Barotz stated that she does not support going out for a sales tax. From a policy standpoint there is a direct relationship between the stormwater fee and the stormwater project.
 
A majority of Council is not interested in a sales tax.
 
Council asked for staff to look at other time options, maybe 7, 10, and 12 years with no debt.
 
Mr. Solomon stated that the purpose of the stormwater fee is to fund all stormwater projects, the first of which is the Rio Project.
 
Vice Mayor Whelan suggested that as the City prepares for doing the projects itself that a working group be organized that includes City staff, hydrologists, Friends of the Rio, and other experts to look at the different options and ideas for the project.
 
Councilmember Barotz suggested the possibility of tying the Rio de Flag project to the Flagstaff Watershed Protection Project and taking advantage of the resources, they offer.

Councilmember Putzova left the meeting at 7:23 p.m.
             
8. Presentation on City Efforts to Address Litter Accumulation
  Public Works Director Andy Bertelsen introduced Volunteer and Event Coordinator Maggie Twomey and Code Enforcement Manager Reggie Eccelston.
 
Ms. Twomey provided a PowerPoint presentation that covered the following:
 
CITY OF FLAGSTAFF LITTER PREVENTION PROGRAMS
LITTER PREVENTION
COMMUNITY STEWARDS PROGRAM
 
Mr. Eccelston continued the presentation.
 
COMMUNITY CODE COMPLIANCE
CHALLENGES WITH LITTER ABATEMENT
 
Mayor Evans stated that often larger or additional trash bins are needed and asked if that is something that could be addressed. She also suggested possibly increasing the number of service days for pickup in those areas.
 
Mr. Bertelsen stated that Public Works has looked at some of problem areas and they are getting larger bins but in many cases the areas do not have the room necessary to get the bins and equipment in and out. Many property owners have been working with Mr. Eccelston and his crew to try to mediate the issue as well.
 
Ms. Twomey continued.
 
IMMEDIATE OPPORTUNITIES
OPPORTUNITIES FOR CONSIDERATION
QUESTIONS
 
Mayor Evans stated that she did not know about the program in Denver and she would like to see something like that in Flagstaff. There needs to be a tool in place to address repeat offenders. More attention is needed in areas and properties that need additional bins. The City used to have a beautification program where every quarter an award was given for the best kept house, apartment and business; the winners would get a plaque and a posting in the newspaper. She is interested in reinvigorating the program.
 
Councilmember Odegaard stated that it is important to have consistency in the trash and recycle containers. Right now, there are different and opposite colors for businesses and residential containers. Mr. Bertelsen stated that they are aware of the issue and they are working on getting the bins switched out across the City to have consistent coloring.
 
Councilmember Barotz suggested that there should be training with the collectors on how to avoid windblown litter. Additionally, the NAU Liaison can assist with education in the neighborhoods. She also suggested increasing the number of community cleanups if there is support from the volunteers.
             
9.  Discussion of a Resolution of the Flagstaff City Calling for the Federal Government to Adequately Fund National Parks.
  Mr. Blashke presented Council with a draft resolution calling for the Federal Government to adequately fund National Parks. He also provided a brief background on the issue.
 
Council was supportive of moving the resolution forward to a future meeting for consideration and possible adoption.
             
10.
Review of Draft Agenda Items for the February 20, 2018, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.

None
             
11. Public Participation

None
             
12. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember McCarthy reported that he recently went to the library and saw that they have a new automated system for sorting materials; it automatically checks things back in and sorts them. He stated that it is a pretty neat system and encouraged the Council to go and take a look.
 
Councilmember Odegaard stated that the ADOT Board will be coming to Flagstaff in April. He suggested that Council attend the meeting so they can hear the challenges with funding.
 
Councilmember Odegaard requested that the Council and County Board of Supervisors get together for dinner to get to know each other and build relationships.
 
Vice Mayor Whelan shared that she is very proud of how hard the Council worked over the last couple of days.
 
Councilmember Barotz requested that her FAIR item on March 6, 2018 be considered for removal at the next meeting.
 
Ms. Goodrich thanked the Council for all their hard work at the recent budget retreat.
 
Mayor Evans thanked Ms. Goodrich for leading the Council through the budget process and added that the Council is excited for her to join them at the dais.
             
13. Adjournment

The Work Session of the Flagstaff City Council held February 13, 2018, adjourned at 7: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 02-May-24 08:09 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
125 ms 125 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
94 ms 94 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
78 ms 78 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
31 ms 31 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
141 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 @ 08:09:56.056
			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 @ 08:09:56.056
				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 @ 08:09:56.056
			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 @ 08:09:56.056
				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 @ 08:09:56.056
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:09:56.056
	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 @ 08:09:56.056
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:09:56.056
		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 @ 08:09:56.056
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:09:56.056
		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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
		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 @ 08:09:56.056
		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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:09:56.056
	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=12) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:09:56.056
		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 @ 08:09:56.056
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
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 = 673 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:09:56.056
		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) = 673

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:09:56.056
			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(673 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 @ 08:09:56.056
	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 @ 08:09:56.056
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 672 
getAllMnLines (Datasource=frsRO, Time=16ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
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 = 672 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 = 299 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=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
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 @ 08:09:56.056
	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 @ 08:09:56.056
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
		
	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 = 299 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 299 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 @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6984 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6990 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6982 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5191 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6983 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6985 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6996 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5192 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6994 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5193 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6995 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5194 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6992 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5195 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6993 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5196 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6986 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6988 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6987 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5197 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6989 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:09:56.056
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:09:56.056
	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 @ 08:09:56.056
	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 @ 08:09:56.056
		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 @ 08:09:56.056
		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=673
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=673
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=9453696
cftoken=3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
hitcount=4
lastvisit={ts '2024-05-02 08:09:56'}
timecreated={ts '2024-05-02 08:09:56'}
urltoken=CFID=9453696&CFTOKEN=3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
Cookie Variables:
CFID=9453696
CFTOKEN=3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=673
Session Variables:
cfid=9453696
cftoken=3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9453696_3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
subdir=/public/
tzoffset=0
urltoken=CFID=9453696&CFTOKEN=3d3b4932109d87e3-425B3E02-FBF4-D621-380836248F2341A5
URL Parameters:
dsp=min
get_month=2
get_year=2018
id=
mt=ALL
seq=673
Debug Rendering Time: 16 ms