Return
CITY COUNCIL REGULAR MEETING
TUESDAY, NOVEMBER 16, 2021
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
3:00 P.M.

 
MINUTES
             
1.
CALL TO ORDER

Mayor Deasy called the meeting of the Flagstaff City Council held November 16, 2021, to order at 3:03 p.m.
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this regular meeting, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
             
2. ROLL CALL
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR DEASY
VICE MAYOR DAGGETT
COUNCILMEMBER ASLAN (virtually)
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SALAS
COUNCILMEMBER SHIMONI (virtually until 3:39 p.m.)
COUNCILMEMBER SWEET
ABSENT:









  Others present:  City Manager Greg Clifton; City Attorney Sterling Solomon.
             
3.
PLEDGE OF ALLEGIANCE, MISSION STATEMENT, AND LAND ACKNOWLEDGEMENT

The Council and audience recited the pledge of allegiance, Vice Mayor Daggett read the Mission Statement of the City of Flagstaff, and Mayor Deasy read the Land Acknowledgement.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.

LAND ACKNOWLEDGEMENT
The Flagstaff City Council humbly acknowledges the ancestral homelands of this area’s Indigenous nations and original stewards. These lands, still inhabited by Native descendants, border mountains sacred to Indigenous peoples. We honor them, their legacies, their traditions, and their continued contributions. We celebrate their past, present, and future generations who will forever know this place as home.
             
4. PUBLIC PARTICIPATION

Public Participation enables the public to address the Council about an item that is not on the agenda. Comments relating to items that are on the agenda will be taken at the time that the item is discussed. If you wish to address the Council at tonight's meeting, please complete a comment card and submit it to the recording clerk as soon as possible. Your name will be called when it is your turn to speak. 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 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.
  Scott Richards addressed Council about the Museum Fire flood area and expressed frustration about the sandbags and barriers especially with winter approaching.
 
Deb Harris addressed Council requesting information from Housing Solutions to share with the Southside neighborhood about available housing programs.
             
5. PROCLAMATIONS AND RECOGNITIONS
             
A. Recognition: Mrs. Cleo Wilson Murdoch
  Mayor Deasy read and presented the Recognition.
             
B. Proclamation: National Apprenticeship week
  Mayor Deasy read and presented the National Apprenticeship Week proclamation.
             
6. CITY MANAGER REPORT
             
A. City Manager Report
  Mr. Clifton briefly reviewed his report.
 
City Engineer Rick Barrett provided a brief recap of the Engineering and Capital Improvements monthly report.
             
i. Consideration and Direction: Census Draft Letter
  Interim Public Affairs Director Sarah Langley addressed Council stating that that Community Development staff noticed some potential issues in the census data related to vacancy rates being higher than expected, especially in areas where students are congregated. They suspect that this is a result of students having left the university campus around March of 2020 which created some confusion as to where students should fill out their census. The letter stresses the importance of being able to appeal the census data under expanded criteria.
 
Council indicated support to send the letter.
             
7. COVID-19 UPDATE
             
A. COVID-19 Update
  Deputy City Manager Shannon Anderson provided a PowerPoint presentation that covered the following:
 
COVID-19 UPDATE
AGENDA
CCHHS: COVID-19 WEEKLY CASES
CCHHS: HOSPITAL ADMISSIONS
CCHHS: COVID-19 RELATED DEATHS
CCHHS: COMMUNITY TRANSMISSION
CCHHS: COMMUNITY VACCINATION
CCHHS: VARIANTS
NAH: HOSPITAL CENSUS
 
Coordinator for Indigenous Initiatives Rose Toehe continued the presentation.
 
INDIGENOUS NATIONS UPDATE
NAVAJO NATION
HOPI TRIBE
 
Council expressed gratitude for the continued updates on COVID-19.
             
8. COUNCIL LIAISON REPORTS
  Councilmember Salas reported that the Parks and Recreation Commission is experiencing challenges with getting quorum and encouraged people to consider applying to serve on the commission.
 
Vice Mayor Daggett reported that the Housing Commission participated in three working groups focused on housing issues in preparation for their upcoming commission meeting where potential housing bonds will be discussed.
 
Councilmember Shimoni reported that he attended a production meeting with the Sustainability team. He also attended the CJCC meeting last week where local agencies presented their quarterly reports.
 
Councilmember Aslan reported that he attended the quarterly APS update meeting where they discussed exciting new opportunities that are coming to fruition. Presentations to Council will be coming soon.
             
9.
CONSENT ITEMS

All matters under Consent Agenda are considered by the City Council to be routine and will be enacted by one motion approving the recommendations listed on the agenda. Unless otherwise indicated, expenditures approved by Council are budgeted items.
  Mayor Deasy requested that each item be taken seperately.
             
A. Consideration of Ratifying of Contract:  Ratify the Retail Purchase Agreement with Jeff Wyler Columbus, Inc. in the amount of $60,475 for a Chevrolet 3500 HD Silverado Truck with Dump Bed and Accessories.
  Mayor Deasy stated that there are full size hybrid trucks coming online and he has concerns about purchasing a diesel truck if there are other options. Parks Manager Amy Hagin explained that the hybrid vehicles were explored but they were not available in the size necessary to accommodate the dump bed.
  Moved by Councilmember Adam Shimoni, seconded by Councilmember Regina Salas to ratify the Retail Purchase Agreement with Jeff Wyler Columbus, Inc. in the amount of $60,475 for a Chevrolet 3500 HD Silverado Truck with Dump Bed and Accessories and direct the City Manager to execute the necessary documents.
  Vote: 7 - 0 - Unanimously
             
B. Consideration and Approval of Contract:  The Contract for Materials with San Tan Auto Partners d/b/a San Tan Ford for four (4) 2022 Ford Police Interceptor Utility Hybrid vehicles in the amount of $161,776.04.
  Moved by Councilmember Regina Salas, seconded by Mayor Paul Deasy to approve the Contract for Materials with San Tan Auto Partners d/b/a San Tan Ford for four (4) 2022 Ford Police Interceptor Utility Hybrid vehicles in the amount of $161,776.04 (includes all applicable taxes and fees) and authorize the City Manager to execute the necessary documents.
  Vote: 7 - 0 - Unanimously
             
C. Consideration of Appointments:  On-Call Magistrates for the Flagstaff Municipal Court.
Approve the Judicial Appointment Advisory Panel's recommendation to appoint two On-Call Magistrates to the Flagstaff Municipal Court.
             
10. REGULAR AGENDA
             
A. Consideration and Adoption of Resolution No. 2021-51:  A resolution of the Flagstaff City Council, approving a Utility Agreement between the State of Arizona Department of Transportation and the City of Flagstaff, authorizing the City to transfer $87,625 to allow the State of Arizona to adjust City of Flagstaff water valves and sewer manholes to grade during the ADOT Pavement Preservation Project along Milton Road and Interstate - 40 Business Route.
  Engineering Project Manager James Boyer provided a PowerPoint presentation that covered the following:
 
ADOT PAVEMENT PRESERVATION PROJECT AND COF UTILITY ADJUSTMENT AGREEMENT
GOAL
OVERVIEW
EXISTING CONDITIONS
STAFF REQUEST
OPTION 1
OPTION 2
SUMMARY
 
Councilmember Shimoni stated that the City should be pressuring the Arizona Department of Transportation (ADOT) to create a design that would better support bikes and pedestrians. He asked if staff could meet with ADOT to try and get them to change the restriping design. City Engineer Rick Barrett stated that he does not think there is any chance that ADOT would postpone bidding the project, the design is complete and the deadline to submit the application for funding is November 29, 2021. Despite the best efforts of staff, the City will not get bike lanes on Milton per ADOT policy.
 
Vice Mayor Daggett requested that in the future staff help the public to understand that when changes are being made to ADOT roads they should reach out to ADOT directly.
 
Council discussed the challenges with balancing the policies of multiple jurisdictions and expressed a desire to continue engaging with ADOT about local priorities.
  Moved by Mayor Paul Deasy, seconded by Councilmember Adam Shimoni to read Resolution No. 2021-51 by title only.
  Vote: 7 - 0 - Unanimously
  A RESOLUTION OF THE FLAGSTAFF CITY COUNCIL, APPROVING A UTILITY AGREEMENT BETWEEN THE STATE OF ARIZONA DEPARTMENT OF TRANSPORTATION (ADOT) AND THE CITY OF FLAGSTAFF, ALLOWING THE TRANSFER OF CITY FUNDS TO ALLOW THE STATE OF ARIZONA TO ADJUST CITY OF FLAGSTAFF WATER VALVES AND SEWER MANHOLES TO GRADE DURING THE ADOT PAVEMENT PRESERVATION PROJECT ALONG MILTON ROAD AND INTERSTATE – 40 BUSINESS ROUTE
  Moved by Mayor Paul Deasy, seconded by Councilmember Jim McCarthy to adopt Resolution No. 2021-51.
  Vote: 7 - 0 - Unanimously
             
B. Consideration and Adoption of Resolution No. 2021-49:  A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement Between Coconino County and the City of Flagstaff for the Criminal Justice Integration System
  Moved by Mayor Paul Deasy, seconded by Councilmember Miranda Sweet to read Resolution No. 2021-49 by title only.
  Vote: 7 - 0 - Unanimously
  A RESOLUTION OF THE FLAGSTAFF CITY COUNCIL, APPROVING AN INTERGOVERNMENTAL AGREEMENT BETWEEN COCONINO COUNTY AND THE CITY OF FLAGSTAFF FOR THE CRIMINAL JUSTICE INTEGRATION SYSTEM
  Moved by Mayor Paul Deasy, seconded by Councilmember Miranda Sweet to adopt Resolution No. 2021-49.
  Vote: 7 - 0 - Unanimously
             
C. Consideration and Adoption of Resolution No. 2021-50:  A resolution to approve an Intergovernmental Agreement (IGA) between City of Flagstaff and Westwood Estates Fire District to provide fire and emergency medical services.
  Fire Department Chief Mark Gaillard addressed Council stating that the action would maintain the fire services provided to the Westwood Estates Fire District.
  Moved by Councilmember Jim McCarthy, seconded by Mayor Paul Deasy to read Resolution No. 2021-50 by title only.
  Vote: 7 - 0 - Unanimously
  A RESOLUTION OF THE FLAGSTAFF CITY COUNCIL APPROVING AN INTERGOVERNMENTAL AGREEMENT BETWEEN WESTWOOD ESTATES FIRE DISTRICT AND THE CITY OF FLAGSTAFF ON BEHALF OF THE FLAGSTAFF FIRE DEPARTMENT FOR FIRE SERVICES
  Moved by Mayor Paul Deasy, seconded by Councilmember Jim McCarthy to adopt Resolution No. 2021-50.
  Vote: 7 - 0 - Unanimously
             
D. Consideration and Adoption of Resolution No. 2021-52:  A resolution approving the Intergovernmental Agreement between Arizona Board of Regents, for and on behalf of, the University of Arizona and the City of Flagstaff for the Flagstaff Flood Mapping Program.
  Moved by Councilmember Jim McCarthy, seconded by Mayor Paul Deasy to read Resolution No. 2021-52 by title only.
  Vote: 7 - 0 - Unanimously
  A RESOLUTION OF THE FLAGSTAFF CITY COUNCIL, APPROVING AN INTERGOVERNMENTAL AGREEMENT BETWEEN ARIZONA BOARD OF REGENTS FOR AND ON BEHALF OF UNIVERSITY OF ARIZONA AND THE CITY OF FLAGSTAFF FOR THE FLAGSTAFF FLOOD MAPPING PROGRAM
  Moved by Mayor Paul Deasy, seconded by Councilmember Jim McCarthy to adopt Resolution No. 2021-52.
  Vote: 7 - 0 - Unanimously
             
E. Consideration and Approval of Contract:  Approval to not execute the Lease Agreement with US General Services Administration – U.S. Geological Survey Campus Build to Suit.
  Capital Improvements Project Manager David Pedersen provided a PowerPoint presentation that covered the following:
 
USGS CAMPUS BUILD TO SUIT
VICINITY MAP
USGS SCIENCE CENTER OVERVIEW MAP
OVER THE PAST YEAR…
PROJECT DETAILS
SUGGESTED PATH FORWARD
SPECIAL THANKS TO…
 
Management Services Director Rick Tadder continued the presentation.
 
FINANCIAL DETAILS
FINANCIAL DETAILS – PREVIOUS PROPOSAL
FINANCIAL DETAILS – UPDATED COSTS
  Moved by Mayor Paul Deasy, seconded by Councilmember Miranda Sweet to not execute the lease agreement for the U.S. Geological Survey campus reconstruction with US General Services Administration in the amount of $1,894,137.78 annually and a duration of 10 years firm; option for 20 years.
  Vote: 7 - 0 - Unanimously
  A break was held from 5:00 p.m. through 5:20 p.m.
             
11. DISCUSSION ITEMS
             
A. Discussion of San Francisco Square Affordable Housing project and Parking Garage, 320 N. Humphreys Street. 
  Community Development Director Dan Folke provided a PowerPoint presentation that covered the following:
 
SAN FRANCISCO SQUARE AND ASPEN LOFTS
PRESENTATION OBJECTIVES
PROJECT TEAM
320 N. HUMPHREYS STREET
SAN FRANCISCO SQUARE/ASPEN LOFTS
FLAGSTAFF ZONING CODE
TRANSECT ZONE T5-O
T5 BUILDING FORM
 
Current Planning Manager Alaxandra Pucciarelli continued the presentation.
 
PROPOSED DEVELOPMENT
SITE PLAN
SECOND FLOOR PLAN
PERSPECTIVES
VIEW FROM HUMPHREYS AND CHERRY
VIEW FROM HUMPHREYS AND DALE
VIEW FROM HUMPHREYS
PROCESS
SITE PLAN APPLICATION
 
Community Investment Director Dave McIntire continued the presentation.
 
CURRENT PARTNERSHIP
SURFACE PARKING LOT
INTENDED FUTURE PARTNERSHIP
 
Vice Mayor Daggett asked if the residents could park in Phase 1 or Phase 2. Ms. Pucciarelli indicated yes and explained that there are 59 spaces in Phase 1 and 55 spaces in Phase 2 available for parking.
 
Mayor Deasy asked how many spaces are going to be needed for court purposes. Mr. McIntire explained that the need fluctuates based on the business at the court. Currently, there are 16 to 20 vehicles associated with court staff. He added that the Foundation for Senior Living has committed to building the parking garage in a way that allows for future uses.
 
Council expressed appreciation for the project and for the consideration of the future use of the parking garage.
             
B. Regional Plan Amendment for Carbon Neutrality Discussion
  Climate Program Manager Jenny Niemann provided a PowerPoint presentation that covered the following
 
CARBON NEUTRALITY AMENDMENT TO THE REGIONAL PLAN
AGENDA
THE FLAGSTAFF REGIONAL PLAN 2030
CLIMATE CHANGE IN THE FLAGSTAFF 2030 REGIONAL PLAN
EVOLUTION OF THE CITY’S CLIMATE WORK
THE CLIMATE EMERGENCY DECLARATION
REGIONAL PLAN AMENDMENT: PROCESS AND NEED
NEED FOR THIS AMENDMENT
BENEFITS OF THIS AMENDMENT
BACKGROUND: CLIMATE CHANGE AND CLIMATE ACTION IN FLAGSTAFF
CLIMATE CHANGE IN FLAGSTAFF
VULNERABILITIES: WHAT’S AT RISK?
NOT ALL PEOPLE FACE THE SAME THREATS FROM CLIMATE CHANGE
THREE TYPES OF CLIMATE ACTION
CARBON NEUTRALITY PLAN: GOALS
CNP: NINE TARGET AREAS OF ACTION
THE PROPOSED AMENDMENT TO THE REGIONAL PLAN
THE PROPOSED CHANGES TO PAGES IV-11 AND IV-12 INCLUDE:
EDITS TO THE NARRATIVE
CHANGES TO GOAL 2: MITIGATION AND ASSOCIATED POLICIES
CHANGES TO GOAL 3: ADAPTATION AND ASSOCIATED POLICIES
CHANGES TO POLICIES UNDER GOAL 4
CHANGES TO POLICY T.8.1 IN THE TRANSPORTATION CHAPTER
PROCESS RECAP
NEXT STEPS IN THIS PROCESS
 
Council expressed gratitude for the presentation and the work that went into the amendment.
 
Councilmember Aslan asked if there were things reviewed that did not rise to the level of including in the amendment. Ms. Niemann explained that they reviewed every policy in the Regional Plan and did not recall anything that was left out. As they move forward with updates to the entire Regional Plan there is an opportunity to think bigger about how everything works together.
 
Sustainability Director Nicole Antonopoulos added that the goal was to create a starting point for the Regional Plan process that is coming forward. There is still a lot of work to do to analyze policies and codes.
 
Comprehensive Planning Manager Sara Dechter also added that there will be more time to update the Regional Plan comprehensively and that will allow staff to create policies within the plan that incorporate the elements of the Carbon Neutrality Plan.
             
C. Discussion and Direction on Credentialed Wage
  Mayor Deasy stated that there is significant issues with wage theft in the trade skills and not classifying employees appropriately. He would like the city to require all public contracts to include a credentialed wage requirement. This would ensure greater quality work and the ability to detect tax fraud associated with paying people under the table.
 
Southwest Regional Council of Carpenters Regional Manager for Arizona and New Mexico Fabian Sanchez addressed Council in support of moving the matter forward for further discussion and to consider a study to promote local hiring and a credentialed apprenticeship program to address the growing need for skilled workers. He stated that a credentialed wage would also improve enforcement of regulations associated with tax laws to ensure fair competition and responsible contractor practices.
 
Councilmember Shimoni indicated that he has concerns because it is something that has not been done in the state due to legal considerations. He would support a study and further exploration of the matter but he is not supportive of moving forward with an ordinance.
 
Councilmember Salas stated that she would like to have a discussion that focuses on apprenticeship opportunities and creating a local policy that would strengthen these types of programs to create a quality pipeline for trade workers in the community.
 
Matthew Capalby addressed Council stating that there are many contractors who misclassify workers and pay them cash to avoid paying taxes. A credentialed wage ordinance would provide a mechanism for oversight of financial responsibility of contractors.
 
Councilmember Aslan stated that he needs more information and is not ready to move forward with an ordinance.
 
Councilmember McCarthy stated that the matter is synonymous with Davis-Bacon and it is about audits of procedures and financial records. He has heard that projects done under these types of regulations come with significant cost and frustration.
 
Vice Mayor Daggett stated that she would like to have more information and additional conversations before moving forward with drafting an ordinance.
 
There was not Council support to move forward with an ordinance.
             
12. PUBLIC PARTICIPATION

None
             
13. INFORMATIONAL ITEMS TO/FROM MAYOR, COUNCIL, AND STAFF, AND FUTURE AGENDA ITEM REQUESTS
  Councilmember Shimoni reported that he participated in a meeting where the small business micro-grants were discussed. There is hope that the County and NAU will partner to contribute
  funding to the pool. He did a ride-a-long with Sergeant Jeffrey James who is on the traffic unit; they discussed efforts to reducing drinking and driving. He reported that NACA has a ribbon cutting ceremony coming up for their Cedar facility. There is an upcoming meeting to discuss Eco-Passes for downtown employers and the State Transportation Board is meeting on Friday where he will be offering public comment. He expressed his condolences to the family of the pedestrian who was hit and killed on Milton.
 
Councilmember Shimoni requested a FAIR item to have a discussion about establishing a Vision Zero philosophy and the establishment of a committee.
 
Mayor Deasy reported that there is an Independent Redistricting Committee meeting coming up later in the week and encouraged participation in support of the maps submitted by Coconino County.
 
Councilmember McCarthy encouraged people to attend and speak during public participation at the ADOT Transportation Board Meeting. He also requested updates every two weeks on the flood efforts.
 
Councilmember Salas reported that she also attended the micro-grant meeting where she encouraged the team to reach out to women, veteran, minority, and Native American owned businesses to encourage them to consider applying for the grants. She congratulated Mother Road Brewery on their ten-year anniversary. She reported that the Airport Commission is meeting next week and that she will also be attending the RTAC Board meeting.
             
14. ADJOURNMENT

The Regular Meeting of the Flagstaff City Council held November 16, 2021, adjourned at 7:36 p.m.
   
  _______________________________
MAYOR
ATTEST:
 
 

_________________________________
CITY CLERK
 
 
CERTIFICATION

I, STACY SALTZBURG, do hereby certify that I am the City Clerk of the City of Flagstaff, County of Coconino, State of Arizona, and that the above Minutes are a true and correct summary of the Meeting of the Council of the City of Flagstaff held on November 16, 2021. I further certify that the Meeting was duly called and held and that a quorum was present.
 
DATED this 6th day of December, 2022.           
 
________________________________
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 13-Apr-24 08:47 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
438 ms 438 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
375 ms 375 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
375 ms 375 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
438 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 @ 08:47:23.023
			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 @ 08:47:23.023
				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 @ 08:47:23.023
			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 @ 08:47:23.023
				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 @ 08:47:24.024
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:47:24.024
	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 @ 08:47:24.024
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:47:24.024
		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 @ 08:47:24.024
	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 @ 08:47:24.024
		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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
		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 @ 08:47:24.024
		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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:47:24.024
	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=31ms, Records=19) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:47:24.024
		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) = 2021-11-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2021-11-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
			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(1422 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 @ 08:47:24.024
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1421 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=32) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
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 = 1421 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 = 717 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=30) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
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 @ 08:47:24.024
	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 @ 08:47:24.024
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=31ms, Records=26) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
		
	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 = 717 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 717 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
allMotions (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
			   motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 717 AND
			  motion.rev_num = 0 AND
		 	  motion.motion_status <> 'VERBIAGE'
			  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	
allVotes (Datasource=frsRO, Time=16ms, Records=77) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type, c3.long_descr vote_label,
			   v.seq_num sort1,	
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote)
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		WHERE v.form_num = 717 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1							
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16037 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16037 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16035 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16035 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10447 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16040 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16040 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16036 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16036 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11596 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16039 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16039 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16060 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16060 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11597 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16065 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16065 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11598 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16048 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16048 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16064 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16064 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11599 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16066 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16066 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11600 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16061 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16061 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16063 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16063 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11601 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16047 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16047 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11602 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16038 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16038 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10448 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16050 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16050 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10449 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3596 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16050 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16050 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16051 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16051 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3597 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16051 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16051 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16052 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16052 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16041 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16041 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16053 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16053 
SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11603 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3598 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16053 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16053 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10452 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3599 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16053 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16053 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16054 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16054 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3600 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16054 AND
					      motion_seq = 1 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16054 AND
							  allVotes.motion_seq = 1 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10451 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3601 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16054 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16054 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16055 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16055 
SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11604 
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3602 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16055 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16055 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10453 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3603 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16055 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16055 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16056 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16056 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3604 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16056 AND
					      motion_seq = 1 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16056 AND
							  allVotes.motion_seq = 1 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10454 
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3605 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16056 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16056 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16057 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16057 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10455 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			    	SELECT motion.motion_text, motion.time_of_vote, motion.motion_id, motion.second_id,
						   motion.motion_seq, motion.ln_rowid, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
						   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
						   motion.motion_text motion_verbiage, c.misc_alpha disp_after_motion
			        FROM minutes_ln_motion motion
			        INNER JOIN minutes ft ON (ft.form_num = motion.form_num)
					LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
														  r.rev_num = motion.rev_num AND
														  r.valid_code = motion.motion_id)
					LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
														  r2.rev_num = motion.rev_num AND
														  r2.valid_code = motion.second_id)
					LEFT OUTER JOIN codes as c ON (c.code_type = 'MinAddl' AND c.valid_code = CAST(ft.meeting_id as varchar))
					WHERE motion._rowid = 3606 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 16057 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 16057 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:47:24.024
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11605 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16042 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16042 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16058 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16058 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11606 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16059 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16059 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11607 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16062 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16062 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11608 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16049 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16049 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16043 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16043 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11609 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11610 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 16044 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 16044 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:47:24.024
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:47:24.024
	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 @ 08:47:24.024
	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 @ 08:47:24.024
		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 @ 08:47:24.024
		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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=0&mt=ALL&get_month=11&get_year=2021&dsp=min&seq=1422
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=0&mt=ALL&get_month=11&get_year=2021&dsp=min&seq=1422
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=8992111
cftoken=c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
hitcount=4
lastvisit={ts '2024-04-13 08:47:23'}
timecreated={ts '2024-04-13 08:47:23'}
urltoken=CFID=8992111&CFTOKEN=c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
Cookie Variables:
CFID=8992111
CFTOKEN=c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1422
Session Variables:
cfid=8992111
cftoken=c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8992111_c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
subdir=/public/
tzoffset=0
urltoken=CFID=8992111&CFTOKEN=c55b835969f8f826-714AE250-B9F7-F2E2-E8D9BEBE5E17ED31
URL Parameters:
dsp=min
get_month=11
get_year=2021
id=0
mt=ALL
seq=1422
Debug Rendering Time: 0 ms