Return
 WORK SESSION
TUESDAY, SEPTEMBER 26, 2017
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 



WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of September 26, 2017, to order at 6:02 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. Public Participation

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

None
             
5.
Preliminary Review of Draft Agenda for the October 3, 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 Putzova stated that she would like to see statistics on the effectiveness of the camping ordinance; specifically she would like to know the numbers prior to the camping ordinance going into effect and how those relate to the current numbers.
 
Councilmember Putzova also asked about a map of all the liquor licenses in the City. She would like to see the map with each new application that comes before Council to understand where the location of the licenses are in relation to the new request. Mr. Copley explained that the agreement was to bring the map back bi-annually due to the staff work required to generate and update the map. If the direction is changed there will need to be consideration given to what other work programs may need adjustment to accommodate. An ongoing map will potentially redirect the work program of the GIS team and he needs to understand what resources are needed and what time commitments are involved.
 
Councilmember Barotz stated that she is supportive of moving forward with an ongoing map.
 
Mayor Evans asked that information be provided to Council that outlines what would need to be redirected to accommodate the request.
 
Councilmember Odegaard requested a brief presentation on why the City cannot consider local bids differently that non-local. He would like to understand how the purchasing process works and why the City has to go with the cheapest bid. Mr. Copley stated that purchasing staff will be available to answer those questions at the meeting.
             
6. Presentation by National Association of Railroad Passengers.
  All Aboard Arizona President Chuck Mott addressed Council stating that All Aboard Arizona is an advocacy organization supported by membership dues who are dedicated to bringing more passenger rail service to Arizona.
 
Mr. Mott provided a written report to the Council which included recommendations for the Flagstaff Train Station which include improving the station platform, improved signage for the station and improvements to the station waiting room. The report is attached as Exhibit A.
 
Roger Clark addressed Council and encouraged them to promote passenger rail travel to the federal government and to encourage travelers to use rail service.
 
Councilmember McCarthy thanked Mr. Mott and Mr. Clark for their comments. He would like Council to consider a resolution in support of long range rail service. He stated that rail travel is more efficient than planes and cars.
             
7. Discussion of a possible resolution urging the United States Congress to support long-distance train service.*
  Councilmember McCarthy stated that he sent a draft resolution to City staff and his request is that Council consider a resolution that urges Congress to support long-distance train travel.
 
Councilmember Barotz stated that she is supportive of bringing a resolution to Council for consideration. She would like to see broader language in the enactments section that is supportive of rail travel in general, adequate funding for a robust system and encouragement to keep the Chicago to Los Angeles route open.
 
Councilmember Putzova asked how the Flagstaff train station is managed; there were many suggestions for improvement and she would like to understand how the station is funded and how it is run. Councilmember Barotz added that she would like to understand who is responsible for the platform and the other specifics called out in the report.
             
8. High Occupancy Housing Draft Specific Plan - 60 Day Public Review Period.
  Comprehensive Planning Manager Sara Dechter provided a PowerPoint Presentation that covered the following:
 
HIGH OCCUPANCY HOUSING PLAN PUBLIC REVIEW DRAFT
TONIGHT’S OBJECTIVES
HIGH OCCUPANCY HOUSING PROCESS
TENTATIVE ADOPTION SCHEDULE
TOOLS FOR HOH PLANNING
HISTORY OF DENSITY IN FLAGSTAFF
REGIONAL PLAN MAP
TRADE-OFFS
HOW WERE POLICIES DEVELOPED?
FLAGSTAFF IS CURRENTLY A LOW DENSITY COMMUNITY COMPARED TO PEER CITIES
FLAGSTAFF IS MOST COST BURDENED RELATIVE TO PEER CITIES
WHERE IS HOH PERMITTED?
WHERE IS HOH PROPOSED OR APPROVED?
 
Councilmember Barotz questioned the NAU statistics contained on page 15 of the report. She suggested verifying the information through something in writing from the President’s office.
 
Councilmember Overton stated that the map is important for people to look at and understand; it really shows where the City may be seeing HOH types of development. He asked if there has been any further analysis to see specifically where in those areas HOH development is likely to occur. Ms. Dechter stated that staff has not analyzed parcel by parcel but that analysis is likely to occur with the neighborhood specific plans. Councilmember Overton offered that it may be helpful to make some general predictions so the community can better prepare for what may come.
 
Councilmember Odegaard offered that he would like to see this information be presented to the Citizens’ Transportation Tax Commission as it can assist them with their recommendations to Council on where new roads could be built.
 
Ms. Dechter continued the presentation.
 
CH. 2: SITE AND AREA ANALYSIS
CH. 3: CONCEPT PLAN
CH 4: GOALS, POLICIES, AND IMPLEMENTATION STRATEGIES
GOALS, POLICIES, AND IMPLEMENTATION STRATEGIES
CONNECT AND ENHANCE URBAN PATTERNS
COMPLETE AND CONNECTOR ACTIVITY CENTERS
WHERE SHOULD HOH GO IN THE FUTURE
WHAT ABOUT WHERE HOH IS ALREADY PERMITTED?
 
Councilmember McCarthy suggested that the Conditional Use Permits (CUP) come to the City Council for approval rather than the Planning and Zoning Commission. He also suggested that the threshold for requiring a CUP be lowered to 30 units per acre. Ms. Dechter stated that the smaller threshold was not chosen because there are a lot of smaller projects in a suburban center where the community is more comfortable with the development; the controversy has been seen with the larger developments such as the Hub, the Standard and Village at Aspen Place.
 
Planning Director Dan Folke added that it is something that can be considered but it is important to keep in mind that every development with over 29 units per acre would be coming before Council.
 
Councilmember Overton stated that he has concerns with the CUP because it creates a mechanism to take away a zoning right through a permitting process. If the CUP is denied then there is no longer that buildable right. I would rather change the zoning rule than apply another level of regulation.
 
Mr. Folke offered that with regard to CUPs there are some uses allowed in the Code; however there may be impacts generated by that use that need closer consideration. The CUP application is taken to the Planning and Zoning Commission for review of the impacts of the proposal and if the impacts can be reasonably mitigated the CUP is approved.
 
Councilmember Barotz stated that she likes the idea of some sort of process that allows for an evaluation of impact and she also likes the idea of the request coming to Council for consideration.
 
Councilmember McCarthy asked if there are legal concerns with instituting some kind of CUP or other process and if that would constitute taking away a property right. Mr. Solomon stated that he would like the opportunity to have his office take a look at it to make sure everyone is on the same page.
 
Ms. Dechter continued the presentation.
 
WHAT ABOUT WHERE HOH IS ALREADY PERMITTED?
BLOCK SIZE
EFFICIENT AND EQUITABLE TRANSPORTATION
PUBLIC SPACES
STORMWATER, WASTE AND ENERGY
OTHER GOALS
 
Vice Mayor Whelan stated that she would like to see more substance in the Town and Gown section that really addresses the good neighbor and nuisance issues and the reality that the City and the University need each other and need to work together to combat the issues.
 
APPENDIX B: PLAN AMENDMENTS
TONIGHT’S OBJECTIVES
 
Councilmember Putzova asked how the Hub would have been different if the plan was in place. Ms. Dechter stated that the Hub would have probably needed to be broken into multiple buildings, it would have had to go through an additional process to evaluate impacts and it would have had other requirements such as recycling and energy improvements, connections throughout the site and civic space elements.
 
A break was held from 8:13 p.m. through 8:23 p.m.
             
9. Discussion related to possibly amending the Procurement Code Manual by setting standards for the types of businesses with which we prefer to conduct business.
  Councilmember Putzova stated that there is essentially one amendment she would like to see to the Procurement Policy which would further define the causes for suspension or debarment. It is a narrow addition of circumstances where a contractor can be suspended from providing service. She would like to add “or violation of a relevant criminal statute, as evidenced by a public enforcement order or judgment, settlement with a relevant federal or state enforcement agency, imposition of fines or penalties, or other formal finding by the relevant enforcement agency with regulatory enforcement authority under the applicable consumer protection law” to Article 30 B 2.
 
Jody Clements addressed Council in favor of the proposed amendment.
 
A majority of Council was supportive of the item moving forward.
             
10. Discussion related to possibly amending the Investment Policy to further pursue socially responsible investing.
  Councilmember Putzova stated that she would like the City to prioritize socially responsible investments (SRI) as an approach to its investing.
 
Councilmember Barotz asked if changing the policy to include SRI bonds would preclude any other bond that is not an SRI. Councilmember Putzova stated that SRI bonds are corporate bonds and the change in the policy would narrow down the scope for corporate bonds only; it would not preclude other investments.
 
Mayor Evans stated that she has some concern with the amendment. The City as an organization is charged with maximizing the monies it gets; if the scope is narrowed, it could reduce the City's ability to fully maximize those dollars. She would like to better understand the financial impact of the amendment and what it would mean long term.
 
Councilmember Putzova offered that there are so many corporations that fall under SRI businesses and the performance of investments in an SRI type of instrument are comparable to traditional investing.
 
Mr. Copley stated that if it is Council’s direction to look into this further the City can engage its investment advisors to provide information about SRIs.
 
There was not Council support to move this item forward.
             
11. Discussion on banking service procurement policy considerations.
  Finance Director Brandi Suda provided a PowerPoint presentation that covered the following:
 
BANKING SERVICE PROCUREMENT DISCUSSION
BANKING SERVICE PROCUREMENT
POSSIBLE POLICY CONSIDERATIONS
HISTORY
BANK FEES OVER THE PAST YEARS
EXAMPLE OF VOLUME OF BANKING ACTIVITY
FOCUS: SECURITY OF CITY FINANCIAL ASSETS
FOCUS: CUSTOMER SERVICE
SERVICE EXPECTATIONS
WHAT POLICY CONSIDERATIONS SHOULD BE INCLUDED IN THE EVALUATION OF THE BANK SERVICE CONTRACT?
 
Councilmember Putzova requested that the Request for Proposals (RFP) go out after the Procurement Manual discussion concludes.
 
Councilmember Barotz requested that the RFP include a requirement that the bank has not violated a criminal statute or been involved with the federal government. From an ethical standpoint the Council has an obligation to the taxpayers to not bank with a bank that has been involved in these kinds of things. She is not as concerned about the minor infractions but those that are on a national scope or have hurt a lot of people. Mayor Evans asked what the time limit is and if the requirement would extend to their subsidiaries.
 
Councilmember McCarthy suggested that the time limit be within the last two to three years. Councilmember Odegaard stated that it may be difficult to find a bank with those requirements; he is in favor of going with what the state law requirements are. Councilmember Putzova stated that she would be more comfortable with five or so years.
 
Mayor Evans suggested adding a requirement to the RFP that asks the proposer to address Council goals and provide a statement on how they are addressing that goal.
 
Council agreed on the following points for the RFP:
  • Low cost to City of Flagstaff.
  • Timely and accurate electronic payments and deposits.
  • Wait for Procurement Manual discussions and decisions.
  • Use the proposed Procurement Manual language that ensures vendor has no violations, enforcements or fines.
  • Address Council goals and how they are achieving them.
  • The vendor should also have a local presence in Flagstaff.
             
12. Public Participation

None
             
13.
Review of Draft Agenda Items for the October 3, 2017 City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.

None
             
14. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Putzova reminded everybody that it is National Voter Registration Day. She encouraged people to go to servicearizona.com and check their voter registration.
 
Councilmember Odegaard thanked Assistant to the City Manager Caleb Blaschke for his work in organizing the Coca Cola Swire tour. He spoke with the Manager and asked what his biggest concern is and his response was minimum wage for his customers and how that relates to selling their product at a certain price point.
 
Councilmember Odegaard also spoke with another small business owner about the competition of the internet with the brick and mortar local businesses. The business owner was concerned about the possibility of an additional sales tax and asked that Council think carefully about what they are asking of the community and how that affects small businesses.
 
Councilmember McCarthy reported that the Arizona Board of Regents will be in Flagstaff on Friday; the Council has been invited to attend their meeting.
 
Councilmember McCarthy also reported that Current Planning Manager Mark Sawyers is retiring on Friday; he has done a great job for the City and deserves the best in retirement.
 
Mayor Evans reported that the CVB annual marketing luncheon held last week had a good turnout. The City has an impressive staff in the Economic Vitality Department and the numbers generated by tourism in Flagstaff are amazing.
 
Mayor Evans also encouraged the public to take part in the Festival of Science; noting that www.scifest.org has a lot of information and a schedule of events.
 
Mr. Copley stated that he will be moving the Intergovernmental Priorities originally scheduled for the October 10, 2017 Work Session to the October 24, 2017 Special Work Session to allow staff some extra time to prepare.
             
15. Adjournment

The Work Session of the Flagstaff City Council held September 26, 2017, adjourned at 9:25 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 04:21 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
171 ms 171 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
140 ms 140 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
140 ms 140 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/Application.cfm
47 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
218 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 16:21:34.034
			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 @ 16:21:34.034
				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 @ 16:21:34.034
			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 @ 16:21:34.034
				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 @ 16:21:34.034
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 16:21:34.034
	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 @ 16:21:34.034
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:21:34.034
		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 @ 16:21:34.034
	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 @ 16:21:34.034
		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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
		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 @ 16:21:34.034
		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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:21:34.034
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 16:21:34.034
		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-09-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-09-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 16:21:34.034
			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(611 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 @ 16:21:34.034
	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 @ 16:21:34.034
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 610 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
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 = 610 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 = 259 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=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
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 @ 16:21:34.034
	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 @ 16:21:34.034
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
		
	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 = 259 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 259 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 @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6247 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6253 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6245 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4693 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6246 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6248 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4703 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6259 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4695 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6260 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4696 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6255 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4697 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6257 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4698 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6258 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4699 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6256 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4700 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6251 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6249 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6250 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4702 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6252 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 16:21:34.034
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 16:21:34.034
	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 @ 16:21:34.034
	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 @ 16:21:34.034
		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 @ 16:21:34.034
		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=9&get_year=2017&dsp=min&seq=611
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=9&get_year=2017&dsp=min&seq=611
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=9117939
cftoken=446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
hitcount=4
lastvisit={ts '2024-04-18 16:21:34'}
timecreated={ts '2024-04-18 16:21:34'}
urltoken=CFID=9117939&CFTOKEN=446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
Cookie Variables:
CFID=9117939
CFTOKEN=446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=611
Session Variables:
cfid=9117939
cftoken=446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9117939_446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
subdir=/public/
tzoffset=0
urltoken=CFID=9117939&CFTOKEN=446dfd2428ef6ed9-83030C06-E213-A2F3-1EBEA399439094B5
URL Parameters:
dsp=min
get_month=9
get_year=2017
id=
mt=ALL
seq=611
Debug Rendering Time: 16 ms