Return
CITY COUNCIL WORK SESSION
TUESDAY, APRIL 10, 2018
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
6:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Evans called the Work Session of April 10, 2018, to order at 6:00 p.m.
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Pledge of Allegiance and Mission Statement

Interim Deputy City Manager Kevin Treadway led the Council and audience in the Pledge of Allegiance and Councilmember McCarthy 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
ABSENT:

NONE







  Others present: Interim Deputy City Manager Kevin Treadway 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.
  The following individuals addressed the Council:

Tamara Lawless, Water Conservation Manager, said that this month was Water Awareness Month and they had kicked off the month starting with First Friday Art Walk with tours of the Rio de Flag. She said that they would be having activities throughout the month and she encouraged everyone to Take the Pledge.
             
5.
Preliminary Review of Draft Agenda for the April 17, 2018, City Council Meeting.*
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items”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 Review section may submit a speaker card for their items of interest to the recording clerk.

None
             
6.  2018 Wildfire Preparedness and Outlook Briefing
  Wildland Fire Manager Paul Summerfelt began the presentation by introducing members of their team: Sgt. Coons with the Police Department, Todd Whitney with Coconino County Emergency Management and Duane Tewa with the USFS, and then started the PowerPoint presentation which addressed:

TOTAL ACRES BURNED - 80's 90's 2000's
FIRE SEASON FACTORS
BOTTOM LINE
FLAGSTAFF PRECIPITATION
NATIONAL SIGNIFICANT WILDLAND FIRE POTENTIAL OUTLOOK
OUR STATUS & READINESS POSTURE
SURPRISES TO WATCH FOR IN 2018

2018 FOCUS AREAS
Prevention
Preparedness
Hazard Mitigation
Response
Recovery

COLLABORATION AND PARTNERSHIPS
FOREST TREATMENT MAP
WILDLAND FIRE OCCURRENCE
WILDLAND FIRE SIZE IN TREATED AND UNTREATED AREAS
LAW ENFORCEMENT

St. Coons then continued the presentation:

LAW ENFORCEMENT FIRE PREVENTION PATROLS
PATROL EFFORTS
WOODS WATCH VOLUNTEERS

Mr. Whitney then continued the presentation:

STATEWIDE PREPAREDNESS
READY, SET, GO
EMERGENCY NOTIFICATION SYSTEM
CALL CENTER
COMMUNITY INFORMATION

Mr. Tewa finished up the presentation with:

RESTORATION EFFORTS
Flagship Targets
4FRI
FWPP
Cragin Reservoir

WILDLAND FIRE DISPATCH
Coconino National Forest
BIA Navajo and Hopi Agencies
Flagstaff and Verde Valley Monuments
PFAC and the Greater Flagstaff Area

FIRE PREVENTION STRATEGIES
Education
Patrols
Severity
Restrictions

WILDLAND DETECTION
Lookout Towers
Aerial Detection
Public

ENGINES AND CREWS
Engines - 12
Crews - 3
Water Tenders - 4
Dozers - 2
Miscellaneous Overhead
178 Total Firefighters

NATIONAL GROUND RESOURCES
60 Interagency Incident Management Teams (IMT)
113 Interagency Hotshot Crews
10,000 Firefighters
900 Engines
Partners
International - Canada, Australia, New Zealand

NATIONAL AIR RESOURCES
18 Large/Very Large Fixed Winged air Tankers
5-7 SEAT's in the southwest in 2018  (Single Engine Air Tankers)
28 Type 1 Helicopters, 34 Type 2 Helicopters
13 Exclusive User Helicopters in the southwest
Fixed Winged Fleet
             
7. Discussion/Direction: Current Issues Before Arizona Legislature and Federal Issues
  Mr. Blaschke presented the most recent copy of te letter being prepared by the City and County. He said that they have incorporated quite a few of the comments and feedback, but it is difficult to agree on everything.

Councilmembers agreed that they were fine with moving forward with sending the letter.

Mayor Evans asked, with regard to the Food Truck Bill, if it is possible to change the ordinance to create a commercial fee structure or if it would be preempted by the state. Mr. Solomon said that he has made note of it and would find out.
             
8. 2018 Ballot Discussion: Discussion of potential measures to be placed on the the 2018 ballot by Council including Transportation Tax, Affordable Housing, and a measure related to the Citizen's Petition from Flagstaff Open Space, Parks, and Recreation (FOSPR).
  Mr. Blaschke gave an overview of the meeting, noting that they would be discussing: the CTTC recommendation, housing related to a secondary property tax and the FOSPR proposal. He said that after each of the discussion points listed, they will have opportunity for public comment.

FURTHER DISCUSSION OF 2018 ELECTION
Calendar
CTTC

TRANSPORTATION/TRANSIT

At the previous meeting one of the questions raised was, "what was the purpose of the CTTC, and what goals were established?" He said that the previous city manager attended the opening of the first meeting. He felt that the commission was a diverse representation chosen by the Council. He had asked them to think of the most important projects moving forward, and what Flagstaff's most pressing needs were and then prioritize them. He asked them, should they call a ballot question, what it should look like. Their direction was to meet with Staff staff and relative boards and commission, discuss the Regional Transportation Plan and other transportation related policy documents, and then make recommendations.

He said that there are two documents, approved by the voters, that guide City staff: the City Charter and the Regional Plan. As the Council changes every two years, so to those priorities.

Planning Director Dan Folke then reviewed the FLAGSTAFF REGIONAL PLAN 2030, ratified by the voters on May 20, 2014:

MAP
RTP FUTURE ROAD NETWORK
FUTURE GROWTH ILLUSTRATION
URBAN GROWTH BOUNDARY
ACTIVITY CENTERS
ROAD NETWORK ILLUSTRATION
     Identifies road network
     Regional transportation
     Circulation Roads
     Local Roads - Access Roads
FUTS

Comprehensive Planning Manager Sara Dechter then continued the presentation:

REGIONAL PLAN
SPECIFIC PLANS
IMPLEMENTATION

REGIONAL PLAN THEMES
     Infill over sprawl
     Better urban form
     Affordability
     Sustainability
     Housing Choices
     Multimodal Transportation

SAFE AND EFFICIENT MULTIMODAL TRANSPORTATION
Mobility and Access connectivity
Environmental Considerations
Quality Design
Economic Development

URBAN, SUBURBAN, AND RURAL CONTEXT, COSTS AND STANDARDS
SCENARIO PLANNING AND MODEL
GROWTH AND LAND USE
TRANSPORTATION
NAIPTA
FUTS

Martin Ince said that they looked at a few different varieties--sidewalks, FUTS, bike lanes, crossings, and then inventoried them. They have existing and what is missing, and what is missing, they ended up with a recommendation of shirt, medium and long-term projects. He said that they have about 60 miles of sidewalks missing; that is $37 million and there is nothing in the tax proposals. They are trying to get to the point of prioritizing the most important.

Vice Mayor Whelan said that individuals have the impression that they have forgotten things, but she is hearing that they have not been forgotten, it just has not been done yet.

Mr. Folke continued the presentation.

NATIONAL HOUSING CRISIS

FORM BASED CODE - DOWNTOWN REGULATING PLAN
     Transect Zones
     Conventional zones

Alan Maguire, facilitator for the CTTC, said that many of the previous questions can be answered. If they go back to 2000 the City went forward with a 20 year sales tax because the national transportation funding had changed. They have not had a major increase since 1982 in Arizona and cities and counties have had to adapt.

He said that since 2000, they have done remarkable things--put in a bridge over the railroad and built a bunch of missing links, provided sidewalks around the schools and they have the first real bus system. The voters approved all of those projects. They are now coming to the end of that 20 year tax. What is being proposed is consistent with what they have done in the past. They appointed the CTTC and put them through the ringer. Everyone participated.

Mr. Maguire said that some of the things the CTTC looked at included:

DOCUMENTS REVIEWED
Flagstaff Regional Plan
Regional Transportation Plan
FMPO Blueprint
NAIPTA Five year and Long range Plan
Active Transportation Plan
ADOT State Freight Plan

OUTREACH

The original list came in at over $900 million. This commission brought together their unique perspectives and engaged citizens. They were always respectful, were quite meritorious, and they should be proud of the work they did. He said that there are a lot of transportation needs in the City and they were mindful of the challenges of all the different modes. He said that they received public comments at every meeting.

CTTC Chairman Nick Kraft said that after their last meeting the commission held one more meeting and discussed whether they wanted to continue. He said that after a discussion, they voted 11-2 to hold no further meetings and have their recommendations stand.

BALLOT QUESTIONS AND RATE:

Package A (3 questions)
Package B (2 Questions)

JWP / 4th STREET CORRIDOR
WEST ROUTE 66 IMPROVEMENTS
LONE TREE
BUTLER AVENUE (i-40 TO SINAGUA HEIGHTS)

BALANCING NEEDS

KEY PROJECTS TO MEET GOALS
Emphasized Ped/Bike/FUTS - over $29 million
Improve transit - $50 million
Traffic Management System - $3.5 million
Route 66 - $10.8 million
Planning $1.25 million
Dark Sky Lighting Funds - $8 million

After lengthy discussion Councilmember Putzova said that she sees the shortcoming of not integrating their planning. to her this is one of the opportunities to pause and ask if they should do it differently. Vice Mayor Whelan said that what she has heard is that these considerations were made in each project and now we can open up these recommendations. She is excited in creating the routes to get people out of the center of town and creating areas where people want to go and create communities. She did not think they have passed by anything.

A break was taken from 9:03 p.m. to 9:14 p.m..
  Mr. Maguire continued the presentation, noting that voters generally prefer multiple questions and voters are comfortable in approving an extension of an existing tax.

Brief discussion was held on recommendations made by the Sustainability Commission and Transportation Commission and letters were presented to convey their recommendations.

The following individuals addressed the Council:

•Mark Spinti
•Emily Melhorn
•Rick Moore
•Amanda Shankland
•Mark Haughwout

Comments received included:

•Voters want governments that work
•Felt that the CTTC was a well-functioning commission
•Recommendations are something that voters could support
•38% of Flagstaff's work force drive more than 50 miles to work; most can't live closer
•Some are telling them 'if we build it they will come; if we don't build it, they still come"
•The tourists will continue to come and they should be providing them with a good experience
•To postpone placing this on the ballot this year may mean a six-month gap of no new projects and furloughs for CIP staff, it may be unfortunate, but would encourage Council to not approve a less than ideal plan
•Respect Sustainability Commission's decision to not give any proposals
•Appreciates the work done by the CTTC, but believes they should wait to allow for a more integrated approach

A written comment card was also submitted by Erik Nielsen.

After a lengthy discussion, Council gave direction to move forward with the separate questions on the ballot for 2018 with regard to transportation and transit.
  HOUSING

Housing Director Sarah Darr reviewed a PowerPoint presentation which addressed:

POTENTIAL BOND MEASURE FOR AFFORDABLE HOUSING
If direction is to move forward, then staff has some discussion points.

CITY COUNCIL GOAL

Mr. Tadder continued the presentation to address the financial aspects.

FINANCIAL INFORMATION
GENERAL OBLIGATION BONDS
.8366 - Current rate They have been proposing issuance based on keep that rate
Staying with the capacity of that rate, $50 million

LEGAL LIMITATIONS
20% Limitation
6% Limitation

IMPACTS

Ms. Darr then continued the presentation.

STAFF RECOMMENDATION
 
PROCESS
Research
Brainstorming
Review of Council Direction
Met with citizen-established group
 
Worked on “what could we do to work within the caps but would make a difference?”
 
2018 AREA MEDIAN INCOME LIMITS
 
80% - bulk of the funding sources are limited 
 
Local bond funds would not be restricted to those numbers – they could use those monies that are above 80% but still struggle.
 
CREATION OF HOUSING BOND OVERSIGHT COMMITTEE
HOUSING DEVELOPMENT ASSISTANCE FOR CREATION AND PRESERVATION OF AFFORDABLE HOUSING UNITS
HOMEBUYER ASSISTANCE
 
How Many Units?
 
PUBLIC FEEDBACK
 
They were supportive, but thought she was being cautious. They would recommend a higher amount.
 
WOULD CITY COUNCIL LIKE TO PLACE A BOND MEASURE?
 
If yes – will need further direction
 
The following individuals then addressed the Council:

•Ross Altenbaugh
•Tammara Prager
•Rick Lopez
•Davonna McLaughlin, Housing Solutions
•Sandy Flores
•Mark Hauleck
•Brian Rhoton

Comments received included:

•Her job is to provide a voice to those who aren't able
•20% of those in shelter tonight do not need to be there, but are there because they cannot find housing to actually get into
•A measure like this can feed into helping them.
•Asking the Council to consider being inclusive to those voices
•Housing chain is very clogged up
•Stands ready to support this measure
•Time for talking is over
•This goes hand in hand with the transportation aspect
•Don't put this on the ballot, stop making their cost of living go higher
•They have people leaving the community because they cannot afford to live there
•As an employer and builder, they support this ballot measure

Written comment cards of support were also submitted by:

•Amanda Gray
•Dawn Tucker
•Erik Nielsen

After further discussion, a majority on Council agreed to move this item forward to the ballot and agreed to: creation of a housing bond oversight committee, use funding for housing development assistance, use funding for homebuyers assistance and emergency housing. There was not majority agreement on the amount of the bond question; somewhere between $25 and $35 million. To be decided at a later date.
  FOSPR

Public Works Director Andy Bertelsen began a PowerPoint presentation that addressed some of the previous concerns related to maintenance.

ITEMS TO CONSIDER:
50% cost recovery
Total operation

CONNECTION WITH 2013 PARKS AND RECREATION PLAN
PRIORITIES

After brief discussion by Council, the following individuals addressed the Council:

•Adam Kaupisch
•Dr. Charles Hammersley
•Erik Nierlsen
•Mark Haughwout
•Jan Blackman
•Chloe Pozar

Comments received included:

•There are not a lot of areas that have the acreage they need for fields
•There are a lot of ways to make it work
•If they are concerned about maintenance fees, raise their fees
•They had many more meetings and public comments than CTTC
•They met with Open Spaces Commission, Sustainability Commission, Bicycle Advisory Committee, Pedestrian Advisory Committee, Transportation commission and Parks and Recreation Commission
•They received votes of support from every one except Open Space and they asked for a legal opinion
•Professor at NAU; has two kids that participate in soccer and swimming
•Fundamentally the partnership between NAU and the City is not good
•NAU has swimming facilities, world class tennis courts, and he never sees anyone playing on th outside courts
•Should not be competition between the various ballot questions
•What is important is the quality of life in Flagstaff
•There are no dedicated fields for softball

Written comment cards in support of the question were submitted by:

•Clare Aslan
•Jessica Robertson
•Austin Aslan

Vice Mayor Whelan asked for a CCR on the equity that is offered to the girls and to the boys in the way of recreational facilities.

After further discussion the majority of Council did not want to place this question on the ballot in 2018; however, it was noted that the petition would be coming back for discussion in August to consider for a future election.
             
9. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.

None
             
10. Adjournment
  The Work Session of the Flagstaff City Council held April 10, 2018, adjourned at 11:47 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 28-Apr-24 03:05 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
171 ms 171 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
140 ms 140 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
125 ms 125 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
15 ms 15 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
187 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 03:05:14.014
			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 @ 03:05:14.014
				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 @ 03:05:14.014
			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 @ 03:05:14.014
				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 @ 03:05:14.014
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 03:05:14.014
	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 @ 03:05:14.014
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:05:14.014
		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 @ 03:05:14.014
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:05:14.014
		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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
		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 @ 03:05:14.014
		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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:05:14.014
	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=9) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 03:05:14.014
		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-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 03:05:14.014
			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(693 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 @ 03:05:14.014
	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 @ 03:05:14.014
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 692 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
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 = 692 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 = 322 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=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
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 @ 03:05:14.014
	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 @ 03:05:14.014
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
		
	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 = 322 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 322 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 @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7433 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7437 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7431 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5502 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7432 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5503 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7434 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7440 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5504 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7441 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5505 
get_Minutes (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7439 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5506 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5507 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5508 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5509 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7435 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7436 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 03:05:14.014
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5510 
Departments (Datasource=frsRO, Time=15ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 03:05:14.014
	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 @ 03:05:14.014
	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 @ 03:05:14.014
		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 @ 03:05:14.014
		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=2018&dsp=min&seq=693
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=4&get_year=2018&dsp=min&seq=693
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=9346043
cftoken=4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
hitcount=4
lastvisit={ts '2024-04-28 03:05:14'}
timecreated={ts '2024-04-28 03:05:14'}
urltoken=CFID=9346043&CFTOKEN=4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
Cookie Variables:
CFID=9346043
CFTOKEN=4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=693
Session Variables:
cfid=9346043
cftoken=4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9346043_4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
subdir=/public/
tzoffset=0
urltoken=CFID=9346043&CFTOKEN=4e3282529d0361a1-6979CCD7-D4E7-0FE6-D1F8D7F2ECC0D7CC
URL Parameters:
dsp=min
get_month=4
get_year=2018
id=
mt=ALL
seq=693
Debug Rendering Time: 0 ms