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



WORK SESSION
             
1.
CALL TO ORDER

Mayor Evans called the meeting of September 12, 2017, to order at 6:00 p.m.
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this 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 Councilmember Odegaard 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.
  Gabor Kovacs addressed Council about the need to bring unity to the community.
 
John Viktora addressed Council about the events of September 11, 2001 and the events carried out by the United States in World War II.
 
Nicole Selinger addressed Council regarding HB2365 that allows for cell phone transmitters to be placed throughout all public right-of-ways and urged the Council to oppose the bill.
 
Sema Kelly also addressed Council about HB2365. She urged Council to look further into the bill and consider opposing it.
 
Anthony Garcia addressed Council about International Peace Day coming up on September 21, 2017.
 
A written comment card was submitted by Jill Lynn Farrell regarding the train noise at Fanning and Route 66.
             
5.
Preliminary Review of Draft Agenda for the September 19, 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 Odegaard asked for some historical information on item 13A. Planning Development Manager Tiffany Antol stated that she will update the staff reports to include that information.
             
6. Discussion of Possible Council Action Regarding Deferred Action for Childhood Arrivals (DACA) 
  Mr. Copley stated staff is ready to receive direction from Council on how they would like to move forward regarding DACA.
 
Gabor Kovacs addressed Council stating that DACA is an emotional issue and asked what the costs are for people who are here illegally. He offered that many people have waited years to come into the country legally.
 
Councilmember Odegaard stated that he would like to have the City Lobbyist stress the importance of the issue to the City’s delegation. The issue needs to be prioritized and Congress needs to act quickly to resolve it.
 
Councilmember Putzova offered that she is interested in creating a new resolution because the last one was focused on tuition; the Council should urge Congress to pass comprehensive immigration legislation and urge the President to re-evaluate his stance on the DACA Executive Order. While the Congress should act quickly there should be protection for the DACA people.
 
Mayor Evans stated that she would like to have staff use the United Conference of Mayors resolution as a framework for Flagstaff’s resolution.
 
Councilmember’s Barotz and McCarthy also stated their support of the direction.
             
7. Discussion of FY 2019 Budget Calendar, Process and Meeting Dates
  Finance Director Brandi Suda provided a PowerPoint presentation that covered the following:
 
FY2019 BUDGET CALENDAR & PROCESS
PURPOSE
CITY BUDGET PROCESS & CALENDAR FLOWCHART
BUDGET PROCESS – COUNCIL’S ROLE
FY2019 BUDGET RETREAT DATES
 
Mr. Copley stated that the goal setting discussion will begin on October 31, 2017; this discussion will check in on the current Council goals to see if any adjustments need to be made. Due to October 31st being a holiday he is proposing to start the meeting at 1:00 p.m. to allow Council and staff to get home to their families. He added that the December retreat is where Council will set priorities to guide staff in developing the budget.
 
Councilmember Overton stated that he will be out of town on October 31st but he will provide his direction before he leaves.

Council was in favor of starting the meeting of October 31, 2017 at 1:00 p.m.
 
Councilmember Putzova stated that she would like the December meeting to focus around policy issues related to the budget such as maternity and paternity leave.
 
Mayor Evans noted that the Council is scheduled to have a two day retreat on February 13th and 14th; she requested that the days be moved to the 12th and 13th to allow Council and staff the opportunity to celebrate Statehood and Valentine’s Day with their families. Council was in favor of the proposed schedule change.
             
8. Presentation and Discussion of Scattered Site Affordable Housing Concept Zoning Plan Process
  Housing Director Sarah Darr provided a PowerPoint presentation that covered the following:
 
SCATTERED SITE AFFORDABLE HOUSING PROJECT
SCATTERED SITE AFFORDABLE HOUSING
CHALLENGE
PROJECT TEAM
OPTIONS FOR ZONING AND SITE PLAN APPROVALS
STAFF RECOMMENDATION
 
Planning Director Dan Folke continued the presentation.
 
RECOMMENDED ZONING DISTRICT
COMPARISON OF HR AND MR DISTRICTS
CURRENT CONDITIONS
3100 N WEST STREET AERIAL MAP
CURRENT CONDITIONS
1700 E SIXTH AVENUE AERIAL MAP
ZONING MAP AMENDMENT – TWO PRONGED APPROACH
TWO-PRONGED APPROACH COMPARISON
BOTH APPLICATIONS REQUIRE:
WHY IS THE CONCEPT ZONING PLAN APPROPRIATE FOR THESE SITES?
STAFF RECOMMENDS THE FOLLOWING:
 
Ms. Darr continued the presentation.
 
EXISTING TAX CREDIT PROJECTS
CEDAR CREST
SANDSTONE HIGHLANDS
TIMBER TRAILS
FLAGSTAFF SENIOR MEADOWS
HIGH COUNTRY ESTATES
PROJECT TIMELINE
 
Council agreed that the staff recommendation is the appropriate path forward.
             
9. Transportation Impact Analysis (TIA)/Transect Consultant Scoping
  Community Development Director Mark Landsiedel provided a PowerPoint presentation that covered the following
 
TRANSPORTATION IMPACT ANALYSIS / TRANSECT CONSULTING SCOPING
INTRODUCTION
 
Zoning Code Administrator Brian Kulina continued the presentation.
 
TRANSECTS
TRANSECT MAP
CONVENTIONAL ZONING MAP
AMENDMENTS BEING REVIEWED BY PLANNING & ZONING COMMISSION
FUTURE AMENDMENTS
COMPREHENSIVE REVIEW OF EXISTING CODE
NEIGHBORHOOD MAP
NEW DESIGN CHARRETTE
PARKING
BUILDING HEIGHT
OPEN SPACE
CIVIC SPACE / PUBLIC SPACE
 
Councilmember Putzova stated that she would like to see a statement in the RFP that addresses what the City wants the final outcome to achieve. This direction is important so the issues that are being experienced today are no longer issues in the future.
 
Councilmember Barotz offered that the wording needs to be more clear and precise; there is a lot of ambiguity that leads to various interpretations. The end result must be clearly defined.
 
Vice Mayor Whelan stated that a piece of the process is missing and that is the voices of the community that have studied the Transect Zone. The community wants and needs to be included in the process; their knowledge and expertise will compliment that of City staff.
 
Councilmember Odegaard stated that he has concerns about the concept of mandatory transect zoning. He requested information from the City Attorney on what mandatory transect zoning means and looks like and how that relates to private property rights.
 
The following individuals addressed Council in regards to the consultant scoping:
  • Maury Herman
  • Andy Fernandez
The following comments were received:
  • Additional follow-up and conversations are needed with the community.
  • Flagstaff’s needs are unique and doing what other cities have done will not solve the problems.
  • The allocated budget is not enough to cover the scope of work.
  • Two consultants should be used, one for the TIA and the other for Transect.
  • The City Attorney should provide an outline of considerations and limitations on Council’s ability to change entitlements.
  • An improved TIA analysis may provide a Prop 207 defense.
  • Transects are a scam to facilitate high density.
Vice Mayor Whelan requested that community members be included in the evaluation and selection team for the consultant.
 
Mayor Evans stated that the City needs to consult with the community groups to hear their concerns and suggestions about the process and scope of work. There are people in the community who are educated and passionate about the topic and they have information about some of the nuances in the community that the City is trying to address; the sooner they are brought into the process the better.
 
Mr. Copley stated that before the solicitation is sent out staff will come back to Council for review and feedback. Staff is committed to have community representation on the evaluation team.
 
Traffic Engineer Jeff Bauman continued the presentation.
 
TRANSPORTATION IMPACT ANALYSIS
TRANSPORTATION IMPACT ANALYSIS PURPOSE
ZONING CODE OUTLINES WHEN TIAS ARE REQUIRED
ENGINEERING STANDARDS OUTLINE THE ELEMENTS OF A TIA
TRANSPORTATION IMPACT ANALYSIS REPORT OUTLINE
AUTOMOBILE L.O.S. FOR SIGNALIZED INTERSECTIONS
 
Councilmember Putzova stated that the City has a standard where the level of service cannot fall below; she asked where that policy is located within the Code. Mr. Bauman explained that the standard policy is not currently written in the City Code and the Traffic Impact Analysis is part of the Engineering Standards.
 
Mr. Bauman continued.
 
LEVEL OF SERVICE IN PICTURES
‘FREE-RIDER’ AND ‘LAST-IN’ CONCEPTS
REGIONAL LAND USE PLAN – REGIONAL TRANSPORTATION PLAN RELATIONSHIP 2015
REGIONAL LAND USE PLAN – REGIONAL TRANSPORTATION PLAN RELATIONSHIP 2040
FULL REVIEW OF TIA CODE AND TIA MANUAL FOR BEST PRACTICES
PUBLICLY EXPRESSED CONCERNS TO BE STUDIED
ALTERNATIVE MODE ANALYSIS AND MITIGATION
 
Jeff Meilbeck addressed Council stating that transportation alternatives can have good outcomes and impacts in the community. Providing shorter wait times for buses and bigger buses or increased parking fees to promote less cars are all things that can have a big impact on development and transportation.
 
Mr. Bauman continued.
 
IMPACT FEES – PRO-RATA SHARE DISTRICTS
IN-HOUSE TIA DEVELOPMENT
FMPO REGIONAL TRAVEL DEMAND MODEL
ADOT JURISDICTIONAL ROADWAYS
 
Councilmember Overton asked if the City standards are different than the Department of Transportation’s (ADOT) standards. Mr. Bauman stated that the standards are similar, the challenge is that not all projects need permits from ADOT.
 
Councilmember Putzova offered that the ability of the consulting firm to apply legal knowledge to the concepts will be very important. Without having the legal expertise in how the Zoning Code is interpreted and used, it will created a lot of work for the City’s legal department.
 
Mayor Evans stated that the public should be part of the final scoping; Stand Up for Flagstaff and the Southside Community Association would be helpful additions. Meaningful interaction and public engagement must be part of the plan. She would like to understand how the changes in the Code will relate to the neighborhood plans that exist in the City. She would also like to see an opening statement that addresses the specific problems the City is trying to solve as well as establish a timeline for completion.
             
10. Discussion of Talking Points for Upcoming Trip to Navajo Nation.
  Assistant to the City Manager Caleb Blaschke provided a PowerPoint presentation that covered the following:
 
TRIBAL PRIORITIES
SUGGESTED TALKING POINTS
 
Councilmember Putzova stated that she is interested in learning how the Council can work more collaboratively in terms of seeking input. Occasionally there are issues that come to the Council and having a process in place on how the City can reach out and engage the Navajo Nation would be very helpful.
 
Andy Fernandez addressed the Council about the talking points.
             
11.
Review of Draft Agenda Items for the September 19, 2017, City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.

None
             
12. Public Participation
  Andy Fernandez addressed Council with various issues.
             
13. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember McCarthy requested a FAIR item to discuss the possibility of providing written communication to the Arizona Board of Regents (ABOR) regarding items of concern.
 
Councilmember Odegaard requested a copy of the Citizens’ Transportation Tax Commission Roster.
 
Vice Mayor Whelan reported that she had the opportunity to meet with the Coconino County Coalition for Children and Youth and discussed the partnerships between students, teachers and staff members. She requested a CCR to provide historical information on the City’s Youth Commission.
 
Councilmember Putzova stated that she would like the Council to meet with the leadership of NAU since the City has not been able to meet with ABOR. She believes that the meeting can be similar to the joint City/County meetings. Mr. Copley stated that he will extend the offer to NAU.
 
Mayor Evans stated that there is a large STEM display by Flagstaff Unified School District in the lobby of City Hall. She encouraged all to take a look at the display and to also participate in the Festival of Science.
 
Mayor Evans met with Lieutenant Colonel Ray Garcia at Camp Navajo to discuss the 70th anniversary and future of Camp Navajo. She was also interviewed by Brian Powell for the Flinn-Brown website. Additionally, she was the motivational speaker at the Flagstaff Leadership Program Class of 2017-2018 retreat.
 
Mayor Evans stated that she spoke with Mayor Mitchell from Tempe who shared that Tempe nor Tucson has had the opportunity to speak with ABOR. He suggested that the three Mayors combine their efforts for a joint meeting with ABOR.
 
Mr. Copley reminded Council about the Active Shooter Training scheduled for September 13, 2017 at 2:00 p.m. at City Hall.
 
Mr. Copley also stated that November 8, 2017 has been set as a joint meeting with the City Council and the Planning and Zoning Commission regarding High Occupancy Housing.
             
14. Adjournment

The Work Session of the Flagstaff City Council held September 12, 2017, adjourned at 9:34 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 16-Apr-24 10:26 AM
Locale English (US)
User Agent claudebot
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
203 ms 203 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
48 ms 24 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/Application.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
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 10:26:57.057
			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 @ 10:26:57.057
				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 @ 10:26:57.057
			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 @ 10:26:57.057
				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 @ 10:26:57.057
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 10:26:57.057
	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 @ 10:26:57.057
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=15ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:26:57.057
		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 @ 10:26:57.057
	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 @ 10:26:57.057
		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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
		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 @ 10:26:57.057
		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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 10:26:57.057
	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 @ 10:26:57.057
		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 @ 10:26:57.057
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=63ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
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 = 609 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 10:26:57.057
		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) = 609

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 10:26:57.057
			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(609 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 @ 10:26:57.057
	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 @ 10:26:57.057
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 608 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
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 = 608 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 = 258 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 @ 10:26:57.057
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 @ 10:26:57.057
	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 @ 10:26:57.057
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
		
	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 = 258 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 258 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 @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6231 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6237 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6229 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4683 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6230 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4684 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6232 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4685 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6242 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4686 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6241 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4687 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6240 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4688 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6239 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4689 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6243 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4690 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6233 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6235 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4691 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6234 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4692 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6236 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 10:26:57.057
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 10:26:57.057
	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 @ 10:26:57.057
	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 @ 10:26:57.057
		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 @ 10:26:57.057
		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=609
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=609
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=9064333
cftoken=8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
hitcount=4
lastvisit={ts '2024-04-16 10:26:57'}
timecreated={ts '2024-04-16 10:26:56'}
urltoken=CFID=9064333&CFTOKEN=8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
Cookie Variables:
CFID=9064333
CFTOKEN=8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=609
Session Variables:
cfid=9064333
cftoken=8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9064333_8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
subdir=/public/
tzoffset=0
urltoken=CFID=9064333&CFTOKEN=8e54e4531da39e7a-0F56650F-C7AC-0BF3-48F7EE5D7E04CFB5
URL Parameters:
dsp=min
get_month=9
get_year=2017
id=
mt=ALL
seq=609
Debug Rendering Time: 0 ms