Return
 WORK SESSION
TUESDAY, JUNE 13, 2017
FLAGSTAFF HIGH SCHOOL
HURLEY THEATRE
400 WEST ELM
5:00 P.M.
 
WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of June 13, 2017, to order at 5: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 regular meeting, 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 Vice Mayor Whelan 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: City Manager Josh Copley and City Attorney Sterling Solomon.
             
4.
Preliminary Review of Draft Agenda for the June 20, 2017, 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.
  Councilmember Barotz requested a correction to item 16-B by changing the word after support from with" to "for."
 
Councilmember Putzova requested historical data regarding liquor licenses and a map of the licenses throughout the City. Deputy City Manager Shane Dille stated that staff provided a map to Council a little while back and since then staff has been providing updates about the total number of licenses with each application that comes before Council.
 
Councilmember Putzova also asked about item 10-E regarding an office for the parking program; she asked for the reasoning behind moving the office out of City Hall. Mr. Copley explained that staff analyzed the existing space and it was determined that in order to accommodate the parking office the training lab would have to be discontinued. It is not feasible to have a space in City Hall that would not unduly burden City operations.
 
Vice Mayor Whelan asked about item 10-A and if Phase One is completed and moving to Phase Two. Capital Improvements Project Manager Eli Reisner stated that with Council’s approval Phase Two will begin in July. Vice Mayor Whelan asked how much of the contingency has been used for Phase One to which Mr. Reisner answered none.
             
5. 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.
  Rose Houk addressed Council regarding the traffic caused by the construction on Beaver as well as the safety concerns for pedestrians trying to get across Humphreys. She suggested traffic calming measures or flashing lights to assist with bike and pedestrian crossings.
 
Susan Thomas addressed Council requesting that they remember to include lot combinations when discussing the transect zones.
             
6. Discussion/Presentation: Flagstaff Regional Plan 2030: 2016 Annual Report
  Comprehensive Planning Manager Sara Dechter provided a PowerPoint presentation that covered the following:
 
WHY IS THERE A REGIONAL PLAN ANNUAL REPORT?
WHERE CAN YOU FIND THE REPORT?
ANNUAL REPORT OBJECTIVES
 
Associate Planner Carlton Johnston continued the presentation.
 
ANNUAL REPORT ORGANIZATION
KEY INSIGHTS
            NATURAL ENVIRONMENT
            BUILT ENVIRONMENT
            HUMAN ENVIRONMENT
NATURAL ENVIRONMENT
BUILD ENVIRONMENT
BUILT ENVIRONMENT
HUMAN ENVIRONMENT
WHAT METRICS ARE NEW, WITHDRAWN, OR MISSING?
MOST CITED GOALS IN STAFF MEMOS TO COUNCIL
 
Ms. Dechter continued the presentation.
 
REGIONAL PLAN ACCOMPLISHMENTS
            MCMILLAN MESA VILLAGE
            PARKS AND OPEN SPACE DESIGNATIONS
            REGIONAL PLAN CHAPTER 3
            HIGH OCCUPANCY HOUSING
            PUBLIC OUTREACH
FUTURE PROJECTS
UPCOMING SPECIFIC PLANS
             
7. Discussion and Direction: Wheeler Park Design AND USE*
  Interim Parks and Recreation Director Rebecca Sayers provided a PowerPoint presentation that covered the following:
 
WHEELER PARK DISCUSSION
BACKGROUND/HISTORY
CONCEPT PLAN
SPECIAL EVENTS
MAINTENANCE/REVENUES
 
The following individuals addressed Council in favor of a redesign of Wheeler Park:
  • Matt Ziegler
  • Joe Cornett
The following comments were received:
  • The discussion is really good and includes a forward thinking plan.
  • Some of the improvements can help event producers, event attendees and the general public.
  • The concept could provide some permanent spaces for events.
  • Public spaces are for people to come and enjoy.
  • Making improvements to Wheeler Park could attract more people to come and participate.
  • Advocate that the City continue to use Wheeler Park for festivals and events.
  • The events have such a positive impact and moving them has caused a loss of luster.
  • I live downtown and if I had to drive to other locations I do not know how often I would attend.
The following individuals addressed Council in favor of keeping Wheeler Park the way it is currently:
  • Jennifer Grogan
  • Debbi Grogan
The following comments were received:
  • Wheeler Park is only used 23 days out of the year for events.
  • Keep the park the way that it is; keep the events that currently utilize the park.
  • The grass and drainage problems should be addressed but a formal stage is not needed.
Two written comment cards in favor of leaving Wheeler Park the way it currently is were submitted by:
  • Dawn Dyer
  • Tina and Robert Caskey
Vice Mayor Whelan stated that she feels that it is time to look at the park with community, neighborhood and event planner input and develop some possible ideas. What is difficult to understand is that the City is spending $65,000 per year to hold on to Wheeler Park and the return is only $7,000. If the hope is to cultivate a walking venue downtown perhaps some of the City parking is moved out of Wheeler Park. It is time to look for solutions for all parties.
 
Mayor Evans suggested getting the Parks and Recreation classes at NAU involved and provide a class project opportunity to design something that gives the park maximum use. If there was some kind of stage with electricity it could reduce the amount of equipment needed by event producers. There are also smaller groups that would like to utilize the park for smaller events but do not have the money for the resources needed to have an event.
 
Councilmember Odegaard agreed, stating that having NAU as a partner could be very helpful; he also recommended taking the issue to the various commissions for their input an ideas.
 
Councilmember Putzova stated that she is conflicted about the situation; constantly repairing the park after events is not the best use of resources but it is nice to have a not so developed area. She is open to discussing the matter further and seeing what ideas might come forward.
 
Mayor Evans stated that a majority of Council is interested in moving the item forward to see what a possible redesign would look like. She requested that staff make sure that all stakeholders are included in the discussion along with any other resources such as NAU and the Parks and Recreation Commission.
 
A break was held from 6:22 p.m. through 6:33 p.m.
             
8. Discussion: An ordinance adopting revisions to Title 13  of Flagstaff City Code entitled "Engineering Design and Construction Standards and Specifications for New Infrastructure."
  Development Engineer Gary Miller addressed Council with the proposed revisions to Chapters 10-23 of the Engineering Standards. The summary sheet includes information on why staff is making the change and the impacts the change will have to businesses and residents as well as developers and the City for ongoing maintenance.
 
Mr. Miller reviewed the 2016 Engineering Standards Revision Summary spreadsheet that was included in the agenda packet and attached hereto as Exhibit A.
 
Councilmember Overton expressed some concerns about making the standards so narrow that in the right situations the exceptions cannot even be considered. He encouraged staff to try to be open minded about the specs and standards. More and more parcels are becoming a challenge and the specs and standards may not fit every project.
 
Mr. Miller explained that there is a provision that allows applicants to apply for a variance. The City can and does grant variances when it makes sense to grant them; there is that flexibility. City Engineer Rick Barrett added that customers are almost always aware of the ability to request a variance and if they are not staff can get them there; staff has and continues to be very creative in helping applicants be successful.
             
9. Discussion: Form-Based Code (Transect Zones) Amendments
  Planning Director Dan Folke introduced Zoning Code Manager Brian Kulina who provided a PowerPoint presentation that covered the following:
 
TRANSECT ZONE AMENDMENTS
HISTORY
EXPECTATIONS/TAKEAWAYS
PROP 207 (PRIVATE PROPERTY RIGHTS PROTECTION ACT)
ZONING MAP
CONVENTIONAL ZONING
MARRIOTT
FREMONT STATION
VILLAGE AT ASPEN PLACE
SUNWEST BANK
FEDERAL BUILDING
DOWNTOWN REGULATING PLAN
SCALE OF TRANSECTS
CONVENTIONAL VS. TRANSECT
SHORT TERM
MEDIUM TERM
LONG TERM
 
Councilmember Putzova asked for the timeline on the short, medium and long term fixes. Mr. Kulina stated that staff hopes to have the short term back in front of Council after the break; medium is possibly the first part of next year and long term is summer or fall of 2018.
 
Mr. Kulina continued.
 
BUILDING TYPES
NEIGHBORHOOD FLEX
 
Mayor Evans asked if the long time line is because of the community outreach, the changes, or the amount of staff. Mr. Kulina explained that it is the amount of work that has to be done in analyzing if the original calibrations were correct and making the necessary adjustments. It is a long and lengthy process of back and forth review.
 
Councilmember Putzova asked if an option could be to pause transect zoning and allow staff to go through all the updates at one time. Mr. Solomon explained that a pause in the transect zoning would be equated to a moratorium that requires a lack of public facilities and that is something that does not exist right now. It is a high standard to achieve and if Council wants more specific information an Executive Session would be needed.
 
Mr. Kulina continued.
 
MEDIUM BUILDING TYPE
MAIN STREET FLEX
DOWNTOWN FLEX
ALLOWED BUILDING TYPES
BUILDING TYPES TABLE
10-50.110 (BUILDING TYPES)
ALLOWED PRIVATE FRONTAGE TYPES
PRIVATE FRONTAGE TABLE
10-50.120 (PRIVATE FRONTAGES)
NEW FRONTAGE TYPE
DOWNTOWN SHOPFRONT
WHAT’S NEXT?
 
The following individuals addressed Council regarding Form Based Code:
  • Maury Hermann
  • Marie Jones
The following comments were received:
  • Traffic is important and the City needs to address how traffic studies are done.
  • Eliminating small commercial block from the T4N1 zone is progress.
  • The apartment building provision should be deleted.
  • Some sort of open space requirement should be included.
  • The recommendations that are being proposed by staff are good.
  • The neighborhood mixed use is removed from T4N1 and T4N2, it should be also be removed from T4N1O.
  • Language in the code needs to be strengthened and it needs to be enforceable and unambiguous.
  • There are good examples from other communities; use them to help speed up the process.
  • The process needs to move forward quickly.
A written comment card in support of a review of the Zoning Code was submitted by Nancy Helin.
 
Councilmember McCarthy stated that he believes that the best place to resolve the issues is within a public process. He would like staff to expedite the process of getting a consultant on board. People in the community are scared about what might come next and they want resolution. He is open minded on the short term text amendments on parking or clarifying one building per parcel. Flagstaff has a lot of development pressure and it is imperative that the Code is ready for that pressure.
 
Councilmember Overton offered that there is fine line between creating a code that preserves private property rights and instilling the City’s values. He does not want to leave the public with the idea that the transect zone will go away or be completely revised. There is value in transect zoning. He understands the issue about the mass of the structure and the relationship to the neighborhood. He is concerned that by using the one lot one building approach the development community will be more creative in their approach and the result may be higher building costs and higher rent in addition to a big building anyway.
 
With regards to parking, Councilmember Overton offered that every visionary document of Flagstaff talks about walkability in the most urban core and he is not interested in equating one bed to one vehicle. Encouraging mode use and walkability in the most urban areas is not a bad thing. He is encouraged by the conversation and would be willing to slow the process down to ensure a good public process is achieved. He would like to see the development community engaged in the process; they can help solve the problems and should be seen as partners.
 
Councilmember Odegaard stated that while it might take longer it is important to take the time and make sure that things are done right the first time so there is no need to have to go back and fix things later. Everyone has a certain right to develop with whatever zoning exists on their property and he does not want to make transect zoning so complicated that it is not used. He would like to find a way to encourage the use of transect zoning more while also preserving community character.
 
Vice Mayor Whelan thanked staff for their work and willingness to work with the Council and the community. She would like to see things move forward as quickly as possible. The community piece is very important and she is supportive of the collaboration. She is also supportive of some kind of stop gap measure in the meantime.
 
Mayor Evans stated that the City needs to move forward as soon as possible with staff’s recommendations. The current Zoning Code took three to four years to redo and the result still does not work for the community. Parking is an issue and until basic resources such as grocery stores and more frequent buses are in place to accommodate other modes of transportation it will continue to be an issue. Size, mass and lot consolidation need to be addressed.
             
10. Discussion: Potential Improvements to How Council Appoints New Members to City Boards and Commissions.
  Deputy City Clerk Stacy Saltzburg provided a PowerPoint presentation that covered the following:
 
BOARDS AND COMMISSIONS APPOINTMENT PROCESS
PAST MEMBERSHIP SELECTION
CURRENT PROCESS
 
Councilmember Barotz stated that when she brought the item up back in February she was transitioning from the last Council; since that time she feels that the process is working well.
 
Vice Mayor Whelan requested that the applicant packet that is sent to Council be sent out as early as possible. She believes the process is working well and she appreciates the randomness.
 
Councilmember Barotz suggested that the Mayor could briefly introduce the process before appointments are done at the Council meeting so the public can understand the process as well.
 
Councilmember Odegaard asked if there is a date certain for applicants to submit their applications to the Clerk’s office. Ms. Saltzburg explained that the date she uses for the application deadline is the first and third Wednesday of the month, whichever falls before the scheduled Council meeting where the appointments will occur. This date allows enough time for the Councilmembers assigned to have enough time to reach out and make contact with the applicants. Council requested that the application deadline be posted on the website so the public is aware of that date.
 
Mayor Evans stated that she would like to see more outreach done in the community to make the public aware of the various boards and commissions and which are seeking applicants. She suggested a banner on the website, advertisement on all the different Facebook pages and information in Cityscape. Ms. Saltzburg agreed stating that the Clerk's office has been making a concerted effort to better advertise openings throughout the community through the use of the City's social media outlets and website.
             
11. Public Participation

None
             
12.
Review of Draft Agenda Items for the June 20, 2017, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  Mr. Copley stated that staff will be bringing forward some amendments to the Council Rules of Procedure and one of the amendments will be to remove the second review of the draft agenda. This section of the agenda is no longer used and in an effort to make meetings more efficient staff is recommending removing it. He stated that the amendments will be coming to the Council at a later time.
             
13. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember McCarthy reported that he made a trip to the Hopi Reservation to watch a Kachina Dance; he had good conversations and it was a great trip.
 
Councilmember Odegaard asked about possibly getting a left turn signal at the intersection at Highway 180 and Fremont St.
 
Councilmember Odegaard also requested a FAIR item to consider doing a listening tour with the business community.
 
Mayor Evans requested information on Marriott’s use of one lane of Aspen and if they are paying for that use.
 
Mayor Evans requested a FAIR item to discuss a policy for the use of the temporary flagpole outside City Hall.
 
Mayor Evans was a keynote speaker for the STAND Summer Conference in Phoenix; she addressed about 200 students about addressing tobacco use throughout Arizona. Flagstaff’s Hunter Owens was named Youth Advocate of the Year and the CATS team was named Youth Organization Advocate of the Year.
 
Mayor Evans participated in the National Mayor’s Challenge for Water Conservation Winning Cities Announcement and drawing for a Toyota Prius.
 
Mayor Evans offered thanks to the Flagstaff Unified School District and Flagstaff High School for accommodating the City of Flagstaff Council Meeting.
             
14. Adjournment

The Work Session of the Flagstaff City Council held June 13, 2017, adjourned at 9:12 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 03:03 PM
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
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/Application.cfm
47 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
15 ms 15 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/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
235 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 15:03:53.053
			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 @ 15:03:53.053
				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 @ 15:03:53.053
			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 @ 15:03:53.053
				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=16ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:03:53.053
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:03:53.053
	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 @ 15:03:53.053
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:03:53.053
		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 @ 15:03:53.053
	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 @ 15:03:53.053
		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 @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
		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 @ 15:03:53.053
		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 @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=15ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:03:53.053
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:03:53.053
	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=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:03:53.053
		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-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-06-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 15:03:53.053
			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(586 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 @ 15:03:53.053
	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 @ 15:03:53.053
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 585 
getAllMnLines (Datasource=frsRO, Time=32ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
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 = 585 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 = 245 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 @ 15:03:53.053
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 @ 15:03:53.053
	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 @ 15:03:53.053
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
		
	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 = 245 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=15ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 245 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 @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6060 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6066 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6058 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4576 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6061 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4577 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6059 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4578 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6069 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4579 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6068 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4580 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6072 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4581 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6070 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4582 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6071 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4583 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6064 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6062 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4585 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6063 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4586 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6065 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:03:53.053
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 15:03:53.053
	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 @ 15:03:53.053
	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 @ 15:03:53.053
		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 @ 15:03:53.053
		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=6&get_year=2017&dsp=min&seq=586
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=6&get_year=2017&dsp=min&seq=586
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=9116680
cftoken=c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
hitcount=4
lastvisit={ts '2024-04-18 15:03:53'}
timecreated={ts '2024-04-18 15:03:53'}
urltoken=CFID=9116680&CFTOKEN=c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
Cookie Variables:
CFID=9116680
CFTOKEN=c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=586
Session Variables:
cfid=9116680
cftoken=c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9116680_c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
subdir=/public/
tzoffset=0
urltoken=CFID=9116680&CFTOKEN=c8f6d1f822f274c-803BDC90-F70B-E8FF-560923E4532FBBEA
URL Parameters:
dsp=min
get_month=6
get_year=2017
id=
mt=ALL
seq=586
Debug Rendering Time: 15 ms