Return
CITY COUNCIL REGULAR MEETING
TUESDAY, NOVEMBER 17, 2020
CITY HALL STAFF CONFERENCE ROOM
211 WEST ASPEN
3:00 P.M.

 
MINUTES
             
1.
CALL TO ORDER

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

MAYOR EVANS (virtually)
VICE MAYOR SHIMONI (virtually)
COUNCILMEMBER ASLAN (virtually)
COUNCILMEMBER MCCARTHY (virtually)
COUNCILMEMBER ODEGAARD (virtually)
COUNCILMEMBER SALAS (virtually)
COUNCILMEMBER WHELAN (virtually)
ABSENT:









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

The Council and audience recited the pledge of allegiance and Councilmember Salas read the Mission Statement of the City of Flagstaff.

MISSION STATEMENT

The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
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.
  Sustainability Director Nicole Antonopoulos announced that Flagstaff has been named one of 88 agencies on the 2020 A List as climate leaders from the international non-profit Carbon Disclosure Project.
             
5. APPOINTMENTS

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 the City Council may vote to go into executive session, which will not be open to the public, for the purpose of discussing or considering employment, assignment, appointment, promotion, demotion, dismissal, salaries, disciplining or resignation of a public officer, appointee, or employee of any public body...., pursuant to A.R.S. §38-431.03(A)(1).
             
A. Consideration of Appointments:  Airport Commission
  Moved by Councilmember Charlie Odegaard, seconded by Mayor Coral Evans to appoint Cal McCloy to a term expiring October 2023.
  Vote: 7 - 0 - Unanimously
             
B. Consideration of Appointments:  Housing Commission
  Moved by Councilmember Jamie Whelan, seconded by Councilmember Jim McCarthy to appoint Joanna Wheaton to a Community Representative seat for a term expiring in September 2023.
  Vote: 7 - 0 - Unanimously
  Moved by Councilmember Jim McCarthy, seconded by Vice Mayor Adam Shimoni to appoint Chris Kemmerly to a Building and Real Estate Professional - Developer seat to a term expiring in September 2023.

Councilmember Whelan noted that Mr. Kemmerly is a current commissioner and has missed eight of the ten meetings. The commission deserves someone who will be present, attentive, and ready to participate. Councilmember McCarthy stated that he had spoken with Mr. Kemmerly and he noted that he was not attending the meetings that were not relevant to his expertise.
 
Councilmember Aslan also expressed concern about Mr. Kemmerly's absences. Mayor Evans stated that the developer seat has been extremely difficult to fill and it is important there is a development perspective on the commission. She recommended that Councilmember McCarthy continue to engage with Mr. Kemmerly to further stress the importance of attending meetings.
  Vote: 4 - 3
 
NAY: Councilmember Austin Aslan
  Councilmember Jamie Whelan
  Councilmember Regina Salas
  Moved by Vice Mayor Adam Shimoni, seconded by Councilmember Charlie Odegaard to appoint Sandi Flores to a Building and Real Estate Professional - Any seat to a term expiring in September 2023.
  Vote: 7 - 0 - Unanimously
  Moved by Mayor Coral Evans, seconded by Councilmember Charlie Odegaard to appoint Adrah Parafiniuk to a Community Representative seat for a term expiring in September 2021.
  Vote: 7 - 0 - Unanimously
  Moved by Councilmember Charlie Odegaard, seconded by Vice Mayor Adam Shimoni to appoint Eric Davis to a Building and Real Estate Professional - Realtor seat to a term expiring in September 2023.
  Vote: 7 - 0 - Unanimously
             
C. Consideration of Appointment:  Sustainability Commission.
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Austin Aslan to appoint David McCain to a term expiring October 2023.
  Vote: 7 - 0 - Unanimously
  Moved by Councilmember Charlie Odegaard, seconded by Councilmember Jim McCarthy to appoint Kevin White to a term expiring October 2022.
  Vote: 7 - 0 - Unanimously
  Moved by Councilmember Austin Aslan, seconded by Councilmember Jim McCarthy to appoint John Daley to a term expiring October 2023.
  Vote: 7 - 0 - Unanimously
             
6.
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.
  Moved by Councilmember Charlie Odegaard, seconded by Vice Mayor Adam Shimoni to approve the Consent Agenda as presented.
  Vote: 7 - 0 - Unanimously
             
A. Consideration and Approval of Contract:  Slash Management contract for the Schultz Pass and Dry Lake Hills area with Markit! Forestry.
  1. Approve the contract with Markit! Forestry in the amount of $463,060.
  2. Authorize the City Manager to execute the necessary documents.
             
B. Consideration and Approval of a Consulting Contract:  Landfill Road Environmental Assessment with EnviroSystems Management, Inc.
  1. Approve a Cooperative Purchasing Contract with EnviroSystems Management, Inc. to provide professional consulting services for an amount of $73,246.00.
  2. Authorize the City Manager to execute all necessary documents.
             
7. ROUTINE ITEMS
             
A. Consideration and Adoption of Resolution No. 2020-59 and Ordinance No. 2020-28:  A Resolution of the City Council of the City of Flagstaff, Coconino County, Arizona, declaring as a public record that certain document filed with the City Clerk and entitled "Case No. PZ-19-00125 Updates to Zoning Code 2020 - High Occupancy Housing Land Use;" and, an Ordinance of the City Council of the City of Flagstaff, Coconino County, Arizona, amending the Flagstaff City Code, Title 10, Flagstaff Zoning Code, to implement the High Occupancy Housing Plan by adopting the High Occupancy Housing Development (HOHD) and Mixed-Use High Occupancy Housing Development (MHOHD) land uses and related standards.
  Stephen Hastings submitted a written comment in support of delaying the effective date of the high occupancy housing ordinance.
  Moved by Councilmember Jim McCarthy, seconded by Vice Mayor Adam Shimoni to adopt Resolution No. 2020-59 with one minor change to amend Section 2 to change the effective date from January 1, 2021 to March 1, 2021.
  Moved by Councilmember Charlie Odegaard, seconded by Vice Mayor Adam Shimoni to amend the motion to include the following:
 
Sec. 10-80.20.080—HOHD:
 
Housing development, either for rental or purchase, in which all dwelling units are permanently affordable and offered at 60 percent of the Area Median Income (AMI) in compliance with the Department of Housing and Urban Development regulations shall not be categorized as High Occupancy Housing Development, regardless of the number units, bedrooms, or zoning.
 
Sec. 10-80.20.130—MOHD:
 
Mixed-use housing development, either for rental or purchase, in which all dwelling units are permanently affordable and offered at 60 percent of the Area Median Income (AMI) in compliance with the Department of Housing and Urban Development regulations shall not be categorized as High Occupancy Housing Development, regardless of the number of units, bedrooms, or zoning.

Zoning Code Manager Dan Symer noted that the amendment would eliminate all affordable housing projects from the High Occupancy Housing (HOH) requirements and the HOH requirements were based on developments that could be considered high occupancy regardless of affordability or not.
 
Councilmember McCarthy noted concerns about removing the public from the discussion about a high occupancy, affordable housing development. If the amendment fails, the project could be done but it would have to go through a Conditional Use Permit process which would give the public an opportunity to review the development.
 
Mayor Evans indicated that the amendment would address the issue of NIMBYism in terms of affordable housing. Councilmember Odegaard added that the community has said they want affordable housing for the community and this would be a way to deliver affordable housing.
 
Vice Mayor Shimoni asked if there was a way to require a public process on the affordable housing developments. Senior Assistant City Attorney Christina Rubalcava stated that Council cannot make a requirement that specific projects go through public meeting process because they would be an entitled project that is administratively decided.
 
  Vote: 6 - 1
 
NAY: Councilmember Jim McCarthy
  ORIGINAL MOTION:
  Vote: 6 - 1
 
NAY: Councilmember Jamie Whelan
  Council requested that during the time before the effective date of March 1, 2021, that staff review the amended language to determine if there are any concerns that would necessitate further amendment.
  Moved by Councilmember Jim McCarthy, seconded by Vice Mayor Adam Shimoni to read Ordinance No. 2020-28 by title only for the final time with the amended date.
  Vote: 6 - 1
 
NAY: Councilmember Jamie Whelan
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, AMENDING THE FLAGSTAFF CITY CODE, TITLE 10, FLAGSTAFF ZONING CODE, BY ADOPTING BY REFERENCE THAT CERTAIN DOCUMENT ENTITLED “CASE NO. PZ-19-00125 UPDATES TO ZONING CODE 2020 – HIGH OCCUPANCY HOUSING LAND USE”; PROVIDING FOR PENALTIES, REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, AND ESTABLISHING AN EFFECTIVE DATE
  Moved by Vice Mayor Adam Shimoni, seconded by Councilmember Charlie Odegaard to adopt Ordinance No. 2020-28.
  Vote: 6 - 1
 
NAY: Councilmember Jamie Whelan
             
B. Consideration and Adoption of Ordinance No. 2020-29:  An ordinance of the City Council of the City of Flagstaff abandoning and authorizing the sale of approximately 1,200 square feet of public right-of-way adjacent to 4013 S. Holland Road; providing for delegation of authority, repeal of conflicting ordinances, severability, and establishing an effective date.
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Charlie Odegaard to read Ordinance No. 2020-29 by title only for the final time.
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF ABANDONING AND AUTHORIZING THE SALE OF 1,168 SQUARE FEET OF PUBLIC RIGHT-OF-WAY ADJACENT TO 4013 S. HOLLAND ROAD; PROVIDING FOR DELEGATION OF AUTHORITY, REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, AND ESTABLISHING AN EFFECTIVE DATE
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Charlie Odegaard to adopt Ordinance No. 2020-29.
  Vote: 7 - 0 - Unanimously
             
C. Consideration and Adoption of Ordinance No. 2020-30:  An ordinance of the Flagstaff City Council ratifying the grant and reservation of easements; and formally accepting dedications and donations of easements and real property interests; delegating authority; and establishing an effective date. (approving receipt/transfer of easements and real property interests)
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Austin Aslan to read Ordinance No. 2020-30 by title only for the final time.
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE FLAGSTAFF CITY COUNCIL RATIFYING THE GRANT AND RESERVATION OF EASEMENTS; AND FORMALLY ACCEPTING DEDICATIONS AND DONATIONS OF EASEMENTS AND REAL PROPERTY INTERESTS; DELEGATING AUTHORITY; AND ESTABLISHING AN EFFECTIVE DATE
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Charlie Odegaard to adopt Ordinance No. 2020-30.
  Vote: 7 - 0 - Unanimously
             
D. Consideration and Approval of Amendment One to the Construction Manager At Risk Construction Services Agreement:  for the northern portion of the Coconino Estates Improvements Phase I Project.
  Capital Improvements Project Manager Eli Reisner provided a PowerPoint presentation that covered the following:
 
CMAR CONSTRUCTION SERVICES AGREEMENT AMENDMENT ONE
AMENDMENT ONE
VICINITY MAP
  Moved by Councilmember Charlie Odegaard, seconded by Vice Mayor Adam Shimoni to approve Amendment One to the Construction Manager At Risk (CMAR) Construction Services Agreement No. 2019-37, with Eagle Mountain Construction, to include the Guaranteed Maximum Price (GMP) for the northern portion of the Coconino Estates Improvements Phase I Project in the amount of $3,192,513.34 with no changes to the contract duration, approve an Owner’s Contingency of $74,842.99, which is approximately 2.3% of the Guaranteed Maximum Price for the northern portion of the Project, and authorize the City Manager to execute the necessary documents.
  Vote: 7 - 0 - Unanimously
             
E. Consideration and Approval of Contract: Federal Lobbying Services
  Purchasing Director Patrick Brown addressed Council stating proposals were solicited and submitted using a request for proposals. The scope of work was drafted with he City Manager’s Office based on the needs of the city and a scoring criteria was established. Nexxus Consulting was the highest responsive bidder.
 
Management Analyst Sarah Langley addressed Council stating that Nexxus Consulting has a strong presence in Northern Arizona and is keenly aware of the needs of the city. They have in-depth knowledge about projects such as the Rio de Flag and the Airport.
 
Council expressed appreciation for the work done by Nexxus Consulting in prior years and were excited to see their contract with the city continued.
  Moved by Councilmember Jim McCarthy, seconded by Councilmember Regina Salas to approve the Contract with Nexxus Consulting, LLC to provide federal lobbying services for the City of Flagstaff for an annual fee of $96,000 for the first year with a provision for a 2.5% increase each succeeding year, plus applicable expenses billed at cost and authorize the City Manager to execute the necessary documents.
  Vote: 7 - 0 - Unanimously
  A break was held from 4:30 p.m. through 4:45 p.m.
             
8. REGULAR AGENDA
             
A. Consideration and Adoption of Ordinance No. 2020-31:  An ordinance amending Flagstaff City Code, Chapter 1-18, Administrative Departments, to establish the Engineering and Capital Improvements Division in City Code.
  Mr. Clifton addressed Council stating that the ordinance is to permit a restructure of the organization to put into place something that is already occurring internally.
 
Deputy City Manager Shannon Anderson added that the ordinance would update the city code to include a new Engineering and Capital Improvements Division that will report up to one of the Deputy City Managers.
 
Councilmember Whelan asked what the financial impact of the restructure is. Mr. Clifton noted that there is some impact that would involve a reclassification but it is not significant.
  Moved by Vice Mayor Adam Shimoni, seconded by Councilmember Jim McCarthy to read Ordinance No. 2020-31 by title only for the first time.
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, ARIZONA, AMENDING THE FLAGSTAFF CITY CODE, CHAPTER 1-18, ADMINISTRATIVE DEPARTMENTS, TO ESTABLISH THE ENGINEERING AND CAPITAL IMPROVEMENTS DIVISION; PROVIDING REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, AUTHORITY FOR CLERICAL CORRECTIONS, AND ESTABLISHING AN EFFECTIVE DATE
             
B. Consideration and Adoption of Ordinance No. 2020-32:  An ordinance of the City Council of the City of Flagstaff, changing the name of Agassiz Street to ____; providing for severability, authority for clerical corrections, and establishing an effective date
  Management Analyst Sarah Langley provided a PowerPoint presentation that covered the following:
 
AGASSIZ STREET RENAMING
BACKGROUND & COUNCIL DIRECTION
ESTIMATED COSTS
NAME SUGGESTIONS/VETTING PROCESS
SURVEY RESULTS
RATIONALES OF TOP 5 RESULTS
QUESTIONS/COUNCIL DIRECTION
 
Deb Harris addressed Council in support of changing the street name to Wilson Riles.
 
Narvia Riles Bostick submitted a written comment in support of changing the street name to Wilson Riles.
 
Alexa Hart submitted a written comment in support of changing the street name to Wilson Riles or Dr. Charles Drew.
 
Gregg Ensminger submitted a comment card in opposition to changing the name of the street.
 
Council expressed appreciation for the outreach to residents and the public engagement process for soliciting possible names. They discussed the history of Wilson Riles and his impact on Flagstaff. They also discussed some of the other names submitted including Annie Watkins Lane, Code Talker Way, and Pluto Place.
 
Due to another street in Flagstaff named Wilson, Council agreed that the name should be abbreviated to WC Riles to avoid confusion. They also discussed the possibility of providing compensation for the affected property owners for the inconvenience associated with having to change their street address however, there was not majority support for compensation.
 
Council expressed a desire to develop an education component to the renaming that highlights who Wilson Riles was and his impact on the Flagstaff community.
  Moved by Councilmember Jamie Whelan, seconded by Mayor Coral Evans to read Ordinance No. 2020-32 by title only for the first time with the name W C Riles.
  Vote: 7 - 0 - Unanimously
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, CHANGING THE NAME OF AGASSIZ STREET TO W C RILES DRIVE; PROVIDING FOR SEVERABILITY, AUTHORITY FOR CLERICAL CORRECTIONS, AND ESTABLISHING AN EFFECTIVE DATE
             
C. Consideration and Adoption of Resolution No. 2020-62:  A resolution of the Mayor and Council of the City of Flagstaff, Coconino County, Arizona, declaring official and adopting the results of the General/Special Election held on November 3, 2020.
  City Clerk Stacy Saltzburg reported that the total voter turnout was 83.44% which is the highest voter turnout in Flagstaff since 1990. Paul Deasy received the highest number of votes for Mayor. For Councilmembers; Becky Daggett, Jim McCarthy, and Miranda Sweet were the three highest vote getters. The elected officials will be officially sworn in on December 15, 2020.
 
Ms. Saltzburg noted that she received notification from Coconino County that while they were doing their final audit of all the results, they identified a discrepancy and there were 100 early ballots that were not included in the reports that they issued last week. They corrected the deficiency and issued updated reports yesterday which are reflected in the numbers presented today. As a result of the discrepancy the County Board of Supervisors delayed their canvass until Friday, November 20, 2020. Legally the Council can canvass the results now but the best practice would be to wait until the Board of Supervisors canvasses their results on Friday. To do this, a special meeting will need to be called on Monday, November 23, 2020 to canvass the results.
 
Council agreed that a special meeting should be called for Monday, November 23, 2020 to canvass the results of the election.
             
9. COUNCIL LIAISON REPORTS
             
10. FUTURE AGENDA ITEM REQUESTS

After discussion and upon agreement by three members of the Council, an item will be moved to a regularly-scheduled Council meeting.
             
A. Future Agenda Item Request (F.A.I.R.): A request by Councilmember Salas to place on a future agenda a discussion about a policy of a moratorium on any new or increased fees until after the global pandemic is over as set forth by CDC.
  Councilmember Salas stated that she would like to have a discussion about a possible policy to suspend or defer the implementation of new fees or increased fees until after the pandemic is over.
 
Joe Galli, on behalf of the Greater Flagstaff Chamber of Commerce, submitted a written comment in support of moving the item forward to a future agenda for discussion.
 
Four members of Council were supportive of moving the item forward to a future agenda for discussion. It was requested that when the discussion comes back that the decision to defer or suspend fees be tied to the recession plan as well as the budget.
             
11. CITY MANAGER REPORT
             
A. City Manager Report
  Mr. Clifton briefly reviewed his report.
             
12. COVID-19 UPDATES
  Deputy City Manager Shannon Anderson provided a PowerPoint presentation that covered the following:
 
AGENDA
THE DATA
CCHHS: COVID-19 WEEKLY CASES
CCHHS: COVID-19 DAILY CASES
CCHHS: COVID-19 RELATED DEATHS
CCHHS: COMMUNITY TRANSMISSION
COUNCIL DISCUSSION ON COMMUNITY TRANSMISSION LEVEL
ADHS DASHBOARD
 
Councilmembers expressed concern about the number of cases, the capacity of the hospitals, and concerns about how state officials are reporting information.
 
Coordinator for Indigenous Initiatives Rose Toehe continued the presentation.
 
INDIGENOUS NATIONS DATA
NAVAJO NATION
HOPI TRIBE
INDIGENOUS NATIONS UPDATE
             
13. INFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF, FUTURE AGENDA ITEM REQUESTS
  Councilmember Salas thanked everyone for their hard work and reminded everyone to stay safe, mask up, and physically distance.
 
Vice Mayor Shimoni stated that November is Native American Heritage month and there are a number of events happening where the community can engage, learn, and listen. He thanked the Economic Vitality staff for their work on the Flagstaff Local movement. He reported that ADOT will be hosting a couple of town halls in the near future and he expressed gratitude to the Arizona Board of Regents for hosting a town hall at NAU.
 
Mayor Evans stated that she had the opportunity to speak with the Arizona Board of Regents and it is exciting to see the community understanding the roll of the Board in the strategic plan and leadership of NAU.
             
14. ADJOURNMENT

The Regular Meeting of the Flagstaff City Council held November 17, 2020, adjourned at 6:39 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 17, 2020. I further certify that the Meeting was duly called and held and that a quorum was present.
 
DATED this 20th day of September, 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 25-May-24 07:08 PM
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
297 ms 297 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
250 ms 250 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
234 ms 234 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/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
313 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 @ 19:08:41.041
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 19:08:41.041
				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 @ 19:08:41.041
			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 @ 19:08:41.041
				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 @ 19:08:41.041
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 19:08:41.041
	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 @ 19:08:41.041
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:08:41.041
		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 @ 19:08:41.041
	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 @ 19:08:41.041
		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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
		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 @ 19:08:41.041
		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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
	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 @ 19:08:41.041
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:08:41.041
	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=13) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 19:08:41.041
		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) = 2020-11-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2020-11-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
			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(1136 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 @ 19:08:41.041
	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 @ 19:08:41.041
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1135 
getAllMnLines (Datasource=frsRO, Time=16ms, Records=31) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
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 = 1135 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 = 527 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=29) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
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 @ 19:08:41.041
	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 @ 19:08:41.041
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=46) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
		
	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 = 527 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 @ 19:08:41.041
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 527 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=0ms, Records=23) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
		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 = 527 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=15ms, Records=161) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
		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 = 527 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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12742 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12742 
SortedList (Datasource=, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12739 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12739 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8600 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12745 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12745 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12740 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12740 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11047 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12741 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12741 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12753 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12753 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3062 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12753 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12753 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12754 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12754 
SortedList (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3063 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12754 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12754 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3064 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12754 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12754 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3065 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12754 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12754 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3066 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12754 AND
					      motion_seq = 5 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12754 AND
							  allVotes.motion_seq = 5 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3067 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12754 AND
					      motion_seq = 6 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12754 AND
							  allVotes.motion_seq = 6 
fPrintVoteGetLabels (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12755 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12755 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3068 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12755 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12755 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3069 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12755 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12755 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3070 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12755 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12755 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12743 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12743 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3071 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12743 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12743 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12756 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12756 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12757 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12757 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12744 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12744 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12758 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12758 
SortedList (Datasource=, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11048 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3072 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12758 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12758 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'N' 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3073 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12758 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12758 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8605 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3074 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12758 AND
					      motion_seq = 5 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12758 AND
							  allVotes.motion_seq = 5 
fPrintVoteGetLabels (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11049 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3075 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12758 AND
					      motion_seq = 7 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12758 AND
							  allVotes.motion_seq = 7 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8606 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			    	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 = 3076 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12758 AND
					      motion_seq = 9 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12758 AND
							  allVotes.motion_seq = 9 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:41.041
	
		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 @ 19:08:41.041
				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 @ 19:08:41.041
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12759 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12759 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:41.041
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3077 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12759 AND
					      motion_seq = 1 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12759 AND
							  allVotes.motion_seq = 1 
fPrintVoteGetLabels (Datasource=frsRO, Time=15ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8607 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3078 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12759 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12759 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12760 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12760 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3079 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12760 AND
					      motion_seq = 1 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12760 AND
							  allVotes.motion_seq = 1 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
				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 @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8608 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3080 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12760 AND
					      motion_seq = 3 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12760 AND
							  allVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12761 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12761 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8609 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3081 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12761 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12761 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12762 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12762 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11050 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3082 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12762 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12762 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8610 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12746 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12746 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12763 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12763 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11051 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3083 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12763 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12763 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8611 
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12764 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12764 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11052 
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			    	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 = 3084 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 12764 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 12764 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 19:08:42.042
	
		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 @ 19:08:42.042
				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 @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8612 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12767 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12767 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8613 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12751 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12751 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12750 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12750 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12765 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12765 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 8614 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12752 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12752 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12768 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12768 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11053 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12766 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12766 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11054 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12747 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12747 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11055 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 12748 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 12748 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 19:08:42.042
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 19:08:42.042
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 19:08:42.042
	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 @ 19:08:42.042
		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 @ 19:08:42.042
		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=2020&dsp=min&seq=1136
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=2020&dsp=min&seq=1136
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=10058772
cftoken=4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
hitcount=1
lastvisit={ts '2024-05-25 19:08:41'}
timecreated={ts '2024-05-25 19:08:41'}
urltoken=CFID=10058772&CFTOKEN=4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
Cookie Variables:
CFID=10058772
CFTOKEN=4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1136
Session Variables:
cfid=10058772
cftoken=4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_10058772_4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
subdir=/public/
tzoffset=0
urltoken=CFID=10058772&CFTOKEN=4eb7efa8c25c51b2-FA49FA4C-DA87-5463-F1C314FCA3231A6A
URL Parameters:
dsp=min
get_month=11
get_year=2020
id=0
mt=ALL
seq=1136
Debug Rendering Time: 0 ms