Return
CITY COUNCIL WORK SESSION
TUESDAY, MAY 14, 2019
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
6:00 P.M.

 
MINUTES
             
1.
Call to Order

Mayor Evans called the Work Session of May 14, 2019, 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 McCarthy read the Mission Statement of the City of Flagstaff.

MISSION STATEMENT

The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. Roll Call
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN

ABSENT:









  Others present: Deputy City Manager Shane Dille; City Attorney Sterling Solomon. 
             
4. Public Participation
  Multimodal Planner Martin Ince addressed the Mayor and Council to discuss Bike to Work and School Week and distributed a flyer regarding the week's events. He mentioned that it is the 18th annual event organized by the Flagstaff Biking Association. He offered to arrange bikes for the Council if they needed them for the Kick-Off Ride, highlighted the week's events, and spoke about the commuter challenge.

The Thomas Elementary School Student Council presented to the Council. They explained that they are a group of third to fifth-grade students who meet during their lunch and recess periods with the goal of helping their peers grow. They mentioned that their most recent project was for Kindness Week, during which they worked to increase the level of kindness not just within their school but also in the greater Flagstaff community.

Mayor Evans requested a motion to suspend the rules of Public Participation so that Council would be able to greet the students. 

Moved by Councilmember Salas moved to, seconded by Councilmember Odegaard to suspend the rules of Public Participation.

Vote: 7 - 0 - Unanimously

The Mayor and Council stepped down from the dais to greet the students and take photographs with them.
             
5.
Review of Draft Agenda for the May 21, 2019 City Council Meeting
Citizens wishing to speak on agenda items not specifically called out by the City Council may submit a speaker card for their items of interest to the recording clerk.
  Councilmember Odegaard inquired about Item 12A: "Delivering land to affordable housing" and stated that he wanted a presentation on the different options available. 
             
6. 2018 Building Code Adoption Update
  Building Official Amy Palmer introduced herself and Building Plans Examiner Victoria St. Clair. Ms. Palmer acknowledged their County partners in the audience. She also introduced Sustainability Specialist Jenny Niemann and noted the support they have received from the Sustainability Section. They provided a PowerPoint presentation that covered the following:
 
  • What is a Model Code?
  • Update and Adoption Frequency
  • Proposed Model Codes
  • Why adopt an updated code?
  • Code updates vs. local amendments
  • Adoption Timeline
  • Public Outreach
    • Target audience and advertising
    • Training Sessions
  • Boards & Commission Meetings
    • The Building and Fire Code Board of Appeals did not recommend the adoption of proposed amendments due to concerns about blower door testing and EV vehicle charging requirements.
  • Code Updates and Amendments
  • International Building Code
    • Electric Vehicle Charging
      • EV Ready
    • Play Areas
    • Building-integrated photovoltaic roof panels
    • Public toilet facilities
  • International Existing Building Code
    • Snow Damage — 60 pounds per square foot
    • Emergency escape opening operation
  • International Residential Code
    • Seismic Design Category Changed from D2 to a Seismic Design Category C
    • Garage receptacle outlet location
    • EV charging
      • The Boards and Commissions moved to approve this amendment excluding the Building and Fire Code Board of Appeals
    • IRC Appendices
      • Appendix Q Tiny Houses
      • Appendix R Light Straw-Clay Construction on non-load baring walls
      • Appendix S Strawbale Construction
      • Appendix T Solar-ready provisions
  • International Mechanical Code
    • Solar thermal systems
  • International Plumbing Code
    • Separate facilities, exception 4 added.
    • Drinking fountains
  • International Fuel Gas Code
  • International Solar Energy Provisions
  • International Swimming Pool & Spa Code – New addition
  • ICC A117.1-2017
    • Standard for Accessible and Usable Buildings and Facilities
    • General Site and Building Elements
  • National Electrical Code
  • International Energy Efficiency Code
    • Residential Provisions
      • Compliance Paths
        • Prescriptive – most restrictive
        • Total UA Alternative
        • Simulated Performance
        • Energy Rating Index (ERI) – introduced in 2015
      • Rating Index Compliance Alternative
      • ERI Compliance Alternative Report Example
      • Prescriptive Table R402.1.1 with 2018 values
      • Air Leakage and Blower door testing
        • The City and the County do not mirror each other since the County is suggesting the test be optional.
      • Ducts and Testing
        • The City and the County do not mirror each other since the County is suggesting the test be optional.
      • Service hot water systems and lighting equipment
      • Commercial Costs for Energy Provisions
        • Net savings of $9,900 due to the seismic recategorization
           
Mayor and Council thanked staff for the presentation and did not have any questions. 
             
7. 2018 International Fire Code Adoption Update
  Building Official Amy Palmer introduced Deputy Fire Chief Jerry Bills, who gave a presentation on updating the fire code to include the latest NFPA standards. He mentioned that the 2012 Fire Code was adopted in 2016 and that this marked the first time in 14 years that the Fire Department had collaborated with the Building Department on updates, making the process much smoother. The presentation slides covered the following points:
 
  • 2012 IFC to 2018 Changes
  • Addition of Chapter 12
    • Supportive of the CAP Plan
  • Commercial Hood/Cleaning is now in the Fire Code
  • 2012 IFC to 2018 Not Changed
     
Councilmember Odegaard sought clarification on exemptions for existing bars and restaurants. Deputy Fire Chief Bills explained that two historic buildings were exempt, while all other buildings already had sprinklers, and new buildings would need to comply with the code.
 
Councilmember Whelan inquired about additional expenses for businesses or promoters. Deputy Chief Bills stated that there would be no additional expenses and that the new code might even be cost-effective for new builders.
 
During the public comment period, Joe Shannon from the Sierra Club of Northern Arizona, Rick Moore from the Grand Canyon Trust, Alan Francis, and Tom Scheel, who owns a green plumbing company, expressed their support for the proposal.
 
Councilmember Whelan asked Mr. Scheel to explain what he meant by "over-the-counter" permit applications. Mr. Scheel provided examples and clarified the process for obtaining permits for various projects.
 
Vice Mayor Shimoni asked Mr. Scheel to discuss roof pathways and their impact on supporting solar installations. Mr. Scheel explained the benefits of roof pathways for firefighter safety, green energy, and tension but mentioned that they might limit the number of solar panels that can be installed on a roof.
 
Councilmember Whelan inquired about expediting the process, and Ms. Palmer stated that the City could explore this option. Mayor Evans suggested that the conversation could be revisited in the future, and all Councilmembers expressed interest in exploring the idea at a later meeting. 
 
Community Development Director Dan Folke mentioned that there is typically a published schedule for permits that is often exceeded.
 
Councilmember Whelan asked if there was a need for more staff to collect data, and Ms. Palmer clarified that the data had already been collected over the course of a year.
 
Councilmember Odegaard discussed snow load and damages in 2010, inquired about savings for consumers, and suggested that the City needs to prepare for a rapidly transitioning market.
 
Councilmember Salas asked about public outreach efforts and received a summary of the efforts and findings.
 
Councilmember McCarthy asked about the costs of electric vehicle ports and was told that the cost was similar to installing an electrical outlet for a dryer in the garage.
 
Councilmember Odegaard pointed out that housing is becoming very expensive, and the requirement for EV ports could drive costs up, especially considering that only about 25% of the community owns their own homes.
 
Councilmember Aslan expressed that the measure will ultimately save money and make homes more affordable.
 
Mayor Evans noted that a majority of Council supported moving the item forward while also expressing concerns about costs to the community.
             
8. Evaluation of ADA accessible parking options for the new City Court Facility location
  Project Manager Christine Cameron introduced herself and presented staff recommendations on ADA parking at the new City Court facility. She expressed that staff previously presented to Council on March 5, 2019, regarding the Courthouse, and a recommendation regarding parking was requested. The presentation covered the four options that staff had discovered. The City Council Report (CCR) outlining the items was sent to Council in April. Since then, the recommendations have been reprioritized and renumbered, with modifying the secure Court staff parking and procuring adjacent private property falling to the bottom of the recommendations. The secure parking is deemed necessary, and private property costs are too high. The presentation included:
 
  • ADA Accessible Parking Options
    • Modify Secure Court Staff Parking – not suggested
    • Procure Adjacent Private Property – not cost affordable for long-term security
    • Modifying the Playhouse Parking – ADA patrons would have to cross Beaver Street
    • Modify On-Street Parking – Preferred recommendation.
  • On-Street Curb Side Parking Exhibit – Wider spaces than normal.
  • Staff’s Recommend Option
Mayor Evans inquired about the ADA parking, and staff spoke about the potential ADA spots in town and the two spots that will be at the Courthouse.
 
Councilmember Whelan asked how many spots are at the building. Staff spoke about the 19 spots located in the secure area and how one spot is reserved for ADA Court staff.
 
Vice Mayor Shimoni also asked about the ADA accessible spots at the Courthouse, and Community Development Director Dan Folke added that the number of spaces required for ADA spaces is determined by the parking lot location. He added that for a 19-space parking lot, one ADA space would be required, and the recommendation is for three spots.
 
Councilmember McCarthy expressed his satisfaction with the plan.
 
Councilmember Aslan asked about curbside parking on Beaver Street, adding that the grades on Cherry are much gentler than on Beaver Street.
 
Councilmember Odegaard stated that he is not in favor of doing anything with the secure parking lot and that he would like to see one more ADA parking space added on Cherry.
 
The Council gave direction to move forward with the addition of two ADA parking spaces with the understanding that staff will continue to look for additional ADA parking. There was no support to remove secure parking.
 
Mayor Evans called a ten-minute break at 8:13 p.m.
             
9. Discussion: Developing a policy to prioritize water uses in times of shortage, in the context of public investment, and for community planning
  Councilmember Whelan stated that she brought this item up to determine if there was a plan for prioritizing actions during times of water shortages and policies regarding reclaimed water. She added that she believes it is time to initiate a discussion on the matter, and the discussion should encompass reclaimed water.
 
Vice Mayor Shimoni stated that there is a plan in place for prioritizing water usage, but not specifically for reclaimed water. Water Resources Manager Erin Young mentioned that there is a Water Wise Plan, and the City is currently at Strategy Level One. She explained that there are two other levels based on system capacity that further restrict water use.
 
Councilmember McCarthy raised concerns about the cost of using reclaimed water if there is a shortage to replenish the aquifer.
 
Vice Mayor Shimoni and Councilmember Salas expressed their support for discussing the item further.
 
The Council indicated their support for advancing the discussion within the FAIR process.
             
10. Discussion: Continue communicating with the Arizona Board of Regents and invite them to a meeting or send a letter with concerns about impacts on the City.
  Mayor Evans stated that she and the City Manager had a meeting with the NAU President last week, and she shared details of the conversation.
 
Councilmember Whelan expressed her concerns and suggested inviting the Arizona Board of Regents (ABOR) to a Council Work Session.
 
Vice Mayor Shimoni added that he would like to see ABOR participate in an open meeting with the City.
 
Council proposed writing a letter to ABOR and having NAU President Rita Cheng sign the letter. Mayor Evans expressed her reluctance to have President Cheng sign the letter.
 
Council further discussed the idea of writing a letter and had some reservations about that approach.
 
Council deliberated the possibility of an in-person meeting and directed staff to work on an in-person meeting or a letter.  
             
11. Discussion/Direction: Current Issues Before Arizona Legislature and Federal Issues.
  Management Analyst Cliff Bryson gave an update on the State Legislature. 
 
  • General Legislative Overview
    • 177 Bills remain active
  • State Budget Overview
    • Possible adoption of language to implement Wayfair
  • Tobacco Bills
    • Limiting ability to impose a tax on reconstruction
    • Strike everything amendment
    • Allow any city or towns to adopt ordinances or resolutions to make more restrictive
    • SB1147 is opposite bill of HB2357. SB1147 is a bad bill and HB2357 a good bill.
  • HB2672
    • Waiting for house vote.

Councilmember McCarthy inquired whether the lobbyist is effectively educating on the true purpose and intent of the bills. Mr. Bryson responded that lobbyist Todd Madeksza is actively working to educate the legislative body.

Vice Mayor Shimoni asked if the E-bike bill had been signed, and Mr. Bryson confirmed that the Governor had indeed signed it.
             
12. Public Participation
  Steve Finch, representing Flagstaff Lodging, Tourism, & Restaurant Association (FLRTA), addressed the Council. He began by apologizing for missing last Monday's meeting with the Chamber of Commerce. He expressed agreement with Vice Mayor Shimoni's remarks regarding the use of bicycles to reduce reliance on cars and appreciated Councilmember Whelan's comments on the minimum wage. Mr. Finch pointed out that the unemployment rate in Flagstaff is currently at 7%, which is higher than the national average, and he suggested that this might be influenced by the minimum wage. He expressed his gratitude for the meeting and the valuable insights provided by the Council.
             
13. Informational Items To/From Mayor, Council, and City Manager; future agenda item requests
  Councilmember McCarthy reported attending the Dark Skies event at Lowell Observatory, where he had the opportunity to visit the basement and view the photographic plate used to discover Pluto.
 
Councilmember Aslan attended Housing Solutions of Northern Arizona's Breakfast event, where Vice Mayor Whelan served as the Emcee.
 
Vice Mayor Whelan congratulated Flagstaff High School for winning the Vans Custom Shoe Competition, which awarded them a $75,000 prize.
 
Councilmember Shimoni suggested inviting Flagstaff High School students to a meeting to congratulate them. He also had a FAIR request to review the process for applying for rezones and for builders in general to ensure successful construction projects. Mayor Evans suggested that Councilmember Shimoni have a discussion with city management to understand the current process and then bring the issue forward if necessary.
 
Deputy City Manager Dille mentioned that it is Police Memorial Week and that tomorrow Councilmember Odegaard would read a fallen officer proclamation.
 
Mayor Evans and Councilmember Odegaard attended the commissioning ceremony for Airforce/ROTC officers. Mayor Evans requested adding a FAIR item to the calendar to discuss fees for special events on private property.
             
14. Adjournment

The Flagstaff City Council Work Session of May 14, 2019 adjourned at 9:23 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 02-May-24 04:24 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
125 ms 125 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
78 ms 78 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
78 ms 78 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.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/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.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
125 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:24:50.050
			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:24:50.050
				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:24:50.050
			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:24:50.050
				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:24:50.050
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:24:50.050
	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:24:50.050
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:24:50.050
		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:24:50.050
	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:24:50.050
		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:24:50.050
	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 @ 04:24:50.050
	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:24:50.050
		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:24:50.050
		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:24:50.050
	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:24:50.050
	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:24:50.050
	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:24:50.050
	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:24:50.050
	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:24:50.050
	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:24:50.050
	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:24:50.050
	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=15ms, Records=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:24:50.050
		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) = 2019-05-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2019-05-31 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 04:24:50.050
			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(858 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:24:50.050
	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:24:50.050
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 857 
getAllMnLines (Datasource=frsRO, Time=16ms, Records=16) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
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 = 857 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 = 825 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 @ 04:24:50.050
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:24:50.050
	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:24:50.050
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
		
	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 = 825 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 825 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:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18073 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18078 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18071 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11525 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18072 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11526 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18074 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11527 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18081 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11528 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18082 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11529 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18080 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12114 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18083 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12115 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18084 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12116 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18085 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12117 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18076 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12118 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18075 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 12119 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 18077 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:24:50.050
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:24:50.050
	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:24:50.050
	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:24:50.050
		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:24:50.050
		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=5&get_year=2019&dsp=min&seq=858
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=5&get_year=2019&dsp=min&seq=858
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=9449636
cftoken=c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
hitcount=4
lastvisit={ts '2024-05-02 04:24:50'}
timecreated={ts '2024-05-02 04:24:50'}
urltoken=CFID=9449636&CFTOKEN=c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
Cookie Variables:
CFID=9449636
CFTOKEN=c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=858
Session Variables:
cfid=9449636
cftoken=c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9449636_c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
subdir=/public/
tzoffset=0
urltoken=CFID=9449636&CFTOKEN=c0bd044d1ccd6cdf-3A4E8120-D59E-0386-D49C6D038112658A
URL Parameters:
dsp=min
get_month=5
get_year=2019
id=
mt=ALL
seq=858
Debug Rendering Time: 0 ms