Return
 SPECIAL WORK SESSION
TUESDAY, OCTOBER 24, 2017

MURDOCH CENTER
203 EAST BRANNEN AVENUE

6:00 P.M.
 
 


SPECIAL WORK SESSION
             
1.
Call to Order

Mayor Evans called the Special Work Session of the Flagstaff City Council held October 24, 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 work session, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. Pledge of Allegiance and Mission Statement

The Council and audience recited the Pledge of Allegiance and Councilmember Overton 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; 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. Municipal Identification Card Overview.
  Mr. Copley provided a PowerPoint presentation that covered the following:
 
MUNICIPAL IDENTIFICATIONS CARDS
WHAT ARE MUNICIPAL ID’S?
MUNICIPAL ID CARDS – CITY SERVICES ONLY
RISKS
WHAT HAS SLOWED PHOENIX DOWN?
SAMPLE FRONT
SAMPLE BACK
CURRENT CITY POLICY
CONSULAR IDENTIFICATION CARDS
DISCUSSION
 
Vice Mayor Whelan asked if hair and eye color could be included on the card. Mr. Copley stated that if the Council would like to include that information it is a possibility.
 
Councilmember Putzova asked what the Police Department considers appropriate identification and how that standard is determined. Mr. Copley explained that the Police Department accepts passports or identification issued by a state agency. As far as how that policy is determined, he would have to get that information and report back to Council.
 
Councilmember Odegaard asked if the Municipal ID card would allow someone to open a bank account. Mr. Copley stated that the card states that it is only permitted for municipal services and it would not be considered valid identification for that purpose.
 
The following individuals addressed Council in support of Municipal Identification Cards:
  • Sarah Wilce
  • Robert Neustadt
The following comments were received:
  • The City should look further into how the card can be used and be useful to residents.
  • The card needs to be helpful for people who are in changing circumstances, immigrants, homeless, domestic violence victims and others.
  • The card should be able to open a bank account or cash a check, register a child for school or provide proper identification to pick a child up from school.
  • There are a number of cities that have implemented programs; find out how they dealt with some of the problems.
  • This needs to be a card that will help people bank and work for identification with the police.
  • The program and card must reflect the values of the City of Flagstaff.
Mayor Evans stated that she is in favor of moving forward with the original concept. She is also interested in Consular identification cards and if Flagstaff can institute a policy that would allow those cards to be acceptable identification. She would like to see Flagstaff lobby the State to accept that form of identification as well.
 
Councilmember McCarthy offered his support for Mayor’s requests.
 
Councilmember Putzova would like staff to work with the Police Department to figure out what the minimal standard for identification they would accept.
 
Vice Mayor Whelan offered her agreement with the direction given. She added that she would like staff to look at what banks would require for identification and work that into the municipal card.
 
Councilmember Overton expressed concern about running into the same issues as the City of Phoenix and expending resources only to hit a wall. With the numerous time constraints and heavy workload of staff, he does not feel that the municipal Identification cards rise to the level of moving forward.
 
Mayor Evans offered that the major roadblock is how to make sure the information provided is secure and not subject to records requests once the cards are issued.
 
Councilmember Putzova stated that the card must be useful for City services as well as interaction with all City departments including the Police Department. People need to feel encouraged and safe to report crime and interact with the City.
 
Councilmember Odegaard cautioned that if the City goes down the path of making the card more detailed and meaningful the City would have to take ownership and have programs in place to protect against identity theft and records requests. It will be a very costly program.
             
6. Update on Rio de Flag Project.
  Capital Improvements Engineer Bret Peterson provided a PowerPoint presentation that covered the following:
 
RIO DE FLAG FLOOD CONTROL PROJECT
PROJECT UPDATE
PRESENTATION
PROJECT VICINITY MAP
PROJECT PURPOSE
100 YEAR FLOOD IMPACT
 
Councilmember Odegaard asked when the last major flood event was in Flagstaff. Stormwater Manager Chris Kirkendall stated that the last event was in the late 1930’s.
 
Mr. Peterson continued.
 
PROJECT HISTORY
PROJECT FUNDING
2 YEAR PROJECT FUNDING – STORM WATER FEE INCREASE
PROJECT PATH FORWARD
PROJECT CONSTRAINTS
PROJECT UPDATE
OPPORTUNITY FOR PUBLIC INPUT: COMPOSITE CHANNEL
RIO DE FLAG PROJECT MAP
COMPOSITE CHANNEL – CONCEPT PLAN VIEW
CONCEPT USACE CROSS SECTION
COMPOSITE CHANNEL SURFACE ELEMENTS DESIGN
QUESTIONS
 
The following individuals addressed Council about the Rio de Flag Project:
  • Lance Diskan
  • Dr. Tom Whitham
  • Richard Miller
The following comments were received:
  • There are 12 owners on Navajo Drive that will be dramatically affected by the project.
  • There has been discussion about a floodwall along the entire block to push the water out into the Thorpe Park ball fields; as designed, it was estimated to be 35 feet tall along the back property line.
  • The neighbors would like a meeting with the City, the Army Corps of Engineers and their consultants to discuss the various stories going around.
  • The neighborhood should also be included in the composite group study.
  • The engineering on the box is unclear; they should only be used during floods.
  • As much water as possible needs to be kept in the channel.
  • Some cities use these types of areas as showpieces for their communities.
  • Keep the area wetted and plant it in a way to highlight the community.
  • Funding may be even more difficult to obtain based on the recent damage of the hurricanes this year.
  • It will be difficult to get the Rio project high enough on the list to be funded.
  • The process remain as open as possible to the public.
Councilmember Odegaard stated that it is important for the City to stay proactive with the federal government. He would like to see NAU brought into the discussions as well because if there were a major flood much of the campus would be affected.
 
City Engineer Rick Barrett offered that there is a unique situation in the area near the pond and on Navajo and without the final design it is difficult to answer the questions and provide information. He is working to make sure that the community is as informed as possible. He acknowledged that it has been very frustrating and unfortunate for everyone involved that there has been so much stopping and starting. The $1 million will result in a final design and then questions from the community can be answered.
 
Community Development Director Mark Landsiedel stated that it is important to understand that the City does not get to sign off or approve the Army Corps of Engineer’s design. There are requirements set by the federal government and there is limited ability for the City to interject in the process. The City was involved in doing a Value Engineering Study seven years ago, that was presented to the Army Corp of Engineers and it has not been advanced by them at all since that time; the wall is one of the things addressed in the study. One of the City’s wins was to get the Army Corps to hire a consultant that are experts in value engineering and they are working very closely with the Corps.
 
Councilmember McCarthy stated that there might be engineering tradeoffs that the City, the Army Corps and homeowners can discuss once the design is complete.
 
Mayor Evans stated that the economic impact of a 100-year flood is approximately $1 billion and is something that the entire community will bear the burden of. Having NAU as an actual partner would be more meaningful to the project as a whole. She encouraged staff to engage the neighborhood to provide clarity on what is and what is not currently in the proposal. Other places will have a much higher cost to benefit ratio and at some point, the City may need to consider another way to complete the project.
 
Councilmember Overton agreed that having the full and complete design would answer some questions but there are thousands of projects ahead of this and the cost to benefit ratio does not score well. The City will not get to the finish line until the funding rules are changed. Discussions are still needed about funding and the City matches or possibly completing the project on its own; alternative funding methods are going to be needed.
 
Councilmember Putzova offered that the City should start putting together some partnerships and envisioning the project at a lesser degree with a more realistic budget and financing. The longer this takes the more the community will be paying.
 
A break was held from 8:10 p.m. through 8:19 p.m.
             
7. Overview of Proposition 207 (A.R.S. § 12-1134).
  Deputy City Attorney Kevin Fincel provided a PowerPoint presentation that covered the following:
 
OVERVIEW OF PROP 207
THE PLAN FOR TONIGHT’S DISCUSSION
A.R.S. § 12-1134
WHAT IS A LAND USE LAW?
EXEMPTIONS
PUBLIC’S HEALTH AND SAFETY
COMMON MISUNDERSTANDINGS
 
Mayor Evans asked if a Prop 207 claim means that a city is breaking the law. Mr. Fincel stated that cities are not breaking the law; the law is written in a way that it is telling cities and towns that they can take action and if a valid claim is brought forward, there are steps cities can take to remedy or address.
 
Mayor Evans asked who determines the reduction in fair market value. Mr. Fincel explained that it is somewhat unclear but it would likely come down to an appraisal.
 
Mr. Fincel continued the presentation.
 
MAKING A CLAIM
CITY’S OPTIONS IN RESPONSE TO CLAIMS
DENYING A CLAIM
TIME LIMITATION
QUESTIONS
 
Council requested that Mr. Fincel’s presentation be put online for the public to reference.
             
8. 2017 Intergovernmental Priorities Update.
  Mr. Copley stated that every year he likes to have Council review their Intergovernmental Priorities and provide any direction to change or add to them. Recently the Council has asked for the addition of legislation calling for the acceptance of Consular identification and a change to the PACE legislation to include commercial property be added to the state priorities. He introduced State Lobbyist Richard Travis who is available for any questions from the Council.
 
Rick Moore addressed Council on behalf of the Grand Canyon Trust thanking them for including commercial PACE in the legislative agenda.
 
State Legislative Priorities
 
Councilmember Putzova requested the addition of enabling legislation that supports affordable housing.
 
Councilmember Barotz requested the addition of a review of legislation that governs mining of uranium at both the state and federal levels.
 
Mayor Evans asked for advocating for an open application process for low income housing tax credit. Applications are only allowed in April and she would like to see it open at any time or at least multiple times per year.
 
Mayor Evans also asked for advocating for 100% reimbursement for disability related service providers; the change in minimum wage has made the situation much more difficult for them to manage.
 
Mayor Evans requested lobbying for a tax on alcohol, similar to that of tobacco, to address the issue of street intoxicants and serial inebriates.
 
Mayor Evans clarified that all consular identification, from all countries, should be considered acceptable identification.
 
Councilmember Odegaard stated that he would like to see a push for more local control concerning single serve alcohol and hours of operation.
 
Councilmember Overton would like to continue pushing for Capital Improvement Projects with the Arizona Department of Transportation (ADOT). There is a lot more in the ADOT program that the City can advocate for outside of HURF.
 
Mr. Travis suggested that the Council consider adding advocating for the protection of funding for the Veterans home from sweeps. Revenue is currently below projections and it would be unfortunate if the funding that has been set aside for the home were used for other things.
 
Federal Legislative Priorities
 
Mr. Copley explained that the Council has taken recent action with DACA, the transportation of uranium and carbon fee dividend.
 
Councilmember Barotz suggested mirroring the state priority at the federal level with regard to uranium mining.
 
Mayor Evans stated that she would like the Housing Section to give information about the challenges to the Section 8 funding and provide information on what needs to be advocated for.
 
Tribal Priorities
 
Mr. Copley stated that one of the requests from the Indigenous Circle of Flagstaff report was the establishment of a cultural community center. Mayor Evans stated that there was more than just the community center and she would like the Indigenous Circle of Flagstaff report included as part of the priorities.
 
Councilmember Barotz stated she would also like to include the uranium issue with tribal relations.
 
Mayor Evans stated that there has been previous discussion about inviting the Hopi and Navajo delegations to come to Washington D.C. with the Council to lobby for the Veterans Home and other items that are in common. Mr. Copley stated that he would extend invitations as the planning efforts get started. He added that the Council would be doing its first lobbying trip to Phoenix. It will be done similarly to how the federal lobbying trip is conducted.
 
Mr. Copley will work with staff to incorporate all the suggestions from Council and update the legislative priorities to bring back for consideration and possible approval.
             
9. Public Participation

None
             
10. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests.
  Councilmember Odegaard asked that a thank you letter from the Mayor and Council be sent to APS and Palo Verde thanking them for the tour.
 
Councilmember Odegaard reminded the Council about the Flagstaff Watershed Protection Plan Dry Lake Hills tour tomorrow.
 
Councilmember Odegaard stated that Saturday October 28, 2017 is Make a Difference Day; he extended thanks to those who will be participating. He suggested that the Council find another date in the future for another community project; it would be great to have the whole Council involved.
 
Councilmember Odegaard inquired about a striping request that was made recently. Mr. Copley stated that he believed that the striping had been done that day and if not, it is in the work plan for the coming week.
 
Councilmember Barotz reported that the Palo Verde tour was remarkable and she is grateful for the once in a lifetime opportunity.
 
Councilmember Barotz stated that she has been attending the meetings organized by Coconino County Supervisor Art Babbott about the gridlock issues; she is optimistic that there will be some relief this coming winter.
 
Councilmember Barotz attended the HYPO2 open house at the Business Incubator to celebrate their success so far.
 
Councilmember Putzova reported that she had the opportunity to tour some affordable housing in Santa Barbara, California. It was interesting to learn from a community that experiences similar problems to Flagstaff. They have taken some interesting steps to address some of their problems. While there, she visited with the Central Coast Collaborative on Homelessness Executive Director and hopes that once the camping ordinance comes back to Council she can share some ideas and strategies they have used.
 
Councilmember Putzova stated that she saw the Equality Index Code Card and was surprised how low a score Flagstaff received as a community for working with or serving the LGBTQ community especially becuase Flagstaff was the community that lead the lawsuit for marriage equality. She requested a FAIR item for a comprehensive discussion of policies, services, law enforcement practices and relationships regarding equality.
 
Mayor Evans offered that she is not sure there are gaps in service but rather the lack of reporting. It will be important to look at what reporting has been done and if there are ways to improve that level of reporting.
 
Mayor Evans reported that she, along with Vice Mayor Whelan and Supervisor Babbott, participated on a panel for the Flagstaff Leadership Program to talk about why more people need to step up and participate in their government.
 
Mayor Evans was also thankful for the tour of the Palo Verde Plant; she found the tour amazing and informative.
 
Mayor Evans asked how she could expedite a FAIR request. Mr. Solomon stated that if the FAIR item gets four head nods from Council it can be moved up on the list for consideration. Mayor Evans stated that she would like to request an expedited FAIR to consider a repeal of Transect Zoning.
 
Mr. Copley reported that the October 31, 2017 meeting will begin at 1:00 p.m. with an Executive Session beginning at noon. Mayor Evans asked if it would be possible to start the Executive Session at 12:30 p.m. to accommodate the schools that come through City Hall for Halloween. Mr. Copley stated that it would be tight but they could potentially get things done in 30 minutes.
             
11. Adjournment

The Flagstaff City Council Special Work Session of October 24, 2017, adjourned at 9:33 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 03-May-24 04:14 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
188 ms 188 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 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 @ 04:14:54.054
			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 @ 04:14:54.054
				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 @ 04:14:54.054
			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 @ 04:14:54.054
				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 @ 04:14:54.054
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:14:54.054
	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 @ 04:14:54.054
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:14:54.054
		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 @ 04:14:54.054
	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 @ 04:14:54.054
		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 @ 04:14:54.054
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:14:54.054
	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 @ 04:14:54.054
		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 @ 04:14:54.054
		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 @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:14:54.054
	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=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:14:54.054
		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-10-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-10-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 04:14:54.054
			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(629 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 @ 04:14:54.054
	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 @ 04:14:54.054
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 628 
getAllMnLines (Datasource=frsRO, Time=32ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
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 = 628 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 = 263 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=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
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 @ 04:14:54.054
	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 @ 04:14:54.054
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
		
	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 = 263 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 263 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 @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6302 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6306 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6300 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4733 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6301 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6310 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4734 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6311 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4735 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6309 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4736 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6308 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4737 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6304 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6303 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4738 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6305 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:14:54.054
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:14:54.054
	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 @ 04:14:54.054
	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 @ 04:14:54.054
		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 @ 04:14:54.054
		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=10&get_year=2017&dsp=min&seq=629
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=10&get_year=2017&dsp=min&seq=629
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=9474862
cftoken=981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
hitcount=4
lastvisit={ts '2024-05-03 04:14:54'}
timecreated={ts '2024-05-03 04:14:54'}
urltoken=CFID=9474862&CFTOKEN=981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
Cookie Variables:
CFID=9474862
CFTOKEN=981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=629
Session Variables:
cfid=9474862
cftoken=981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9474862_981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
subdir=/public/
tzoffset=0
urltoken=CFID=9474862&CFTOKEN=981f83daae0761e1-6D71E99E-C600-E9F8-C7C33C9C4487B60C
URL Parameters:
dsp=min
get_month=10
get_year=2017
id=
mt=ALL
seq=629
Debug Rendering Time: 16 ms