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

 
MINUTES
             
1.
CALL TO ORDER

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

MAYOR DEASY
VICE MAYOR DAGGETT
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY
COUNCILMEMBER SALAS
COUNCILMEMBER SHIMONI
COUNCILMEMBER SWEET
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 Shimoni read the Mission Statement of the City of Flagstaff.

Mayor requested a moment of silence in honor of a member of Team Flagstaff who passed away.

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.

None
             
5. PROCLAMATIONS AND RECOGNITIONS
             
A. Proclamation: Adult Education and Family Literacy Week
  The City Council approached the podium and Mayor Deasy read and presented the Adult Education and Family Literacy Week proclamation.
             
B. Proclamation: Flagstaff Symphony Orchestra 72nd Season
  The City Council approached the podium and Mayor Deasy read and presented the Flagstaff Symphony Orchestra 72nd Season proclamation.
             
6. CITY MANAGER REPORT
             
A. City Manager Report
  Mr. Clifton briefly reviewed his report.
             
7. COUNCIL LIAISON REPORTS AND INFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF
  Vice Mayor Daggett reported that the 10-Year Housing Plan will be released from the Housing Commission in the near future. She reported that she met with the Deputy Consul General for the Mexican Consulate at the Sunnyside Celebration. She attended the NACA 50th Anniversary celebration and she reminded the public that the Festival of Science is coming up.
 
Councilmember Aslan reported that the Coconino Plateau Water Advisory Council will be holding their annual field trip later that week to Babbitt Ranch.
 
Councilmember McCarthy reported that he toured the Tynkertopia facility the prior week and encouraged everyone to visit. He also attended the Pickin in the Pines Festival.
 
Councilmember Salas reported that the Parks and Recreation Commission was unable to meet that month due to lack of quorum. She attended the ribbon cutting ceremony for a new program that introduces students to beer brewing and provide an opportunity to earn certification and intern with microbreweries in Flagstaff.
 
Councilmember Shimoni also attended the NACA Anniversary event as well as the Tribal Summit Health Choice event.
 
Councilmember Sweet reported that the Beautification and Public Art Commission will be holding its annual budget retreat on September 29, 2021. The deadline to submit applications for the Beautification in Action grants is coming up soon.
 
Mayor Deasy reported that he attended the NACA Anniversary celebration. He also reported that it is the 40th anniversary of the Assistance League of Flagstaff. He reported that there is a Special Work Session of Council on Friday, September 24, 2022 to discuss the Alternate Response Program. He recognized James Turrell, a 44 year resident who was awarded the Japan Art Association’s Praemium Imperiale award for his sculpture work. Lastly, he reported that the Commission on Diversity Awareness is excited about the upcoming Land Acknowledgement discussion.
             
8. COVID-19 UPDATE
             
A. COVID-19 Update
  Deputy City Manager Shannon Anderson provided a PowerPoint presentation that covered the following:
 
AGENDA
CCHHS: COVID-19 WEEKLY CASES
CCHHS: HOSPITAL ADMISSIONS
CCHHS: COVID-19 RELATED DEATHS
CCHHS: COMMUNITY TRANSMISSION
CCHHS: COMMUNITY VACCINATION
CCHHS: VARIANTS
NAH: HOSPITAL CENSUS
 
Coordinator for Indigenous Initiatives Rose Toehe continued the presentation.
 
INDIGENOUS NATIONS DATA
NAVAJO NATION
HOPI TRIBE
 
Council thanked Ms. Anderson and Ms. Toehe for the report.
             
9. LIQUOR LICENSE PUBLIC HEARINGS
  Mayor Deasy opened the public hearing for all applications.
 
Police Sergeant Ryan Turley introduced the two applications noting no concerns.
 
There being no public comment Mayor Deasy closed the public hearing.
  Moved by Mayor Paul Deasy, seconded by Councilmember Miranda Sweet to forward the applications to the State with a recommendation of approval.
  Vote: 7 - 0 - Unanimously
             
A. Consideration and Action on Liquor License Application:  Bryan James Lubbehusen, "Square Root Foods," 2223 E. 7th Avenue, Series 10 (beer and wine store), New License.
             
B. Consideration and Action on Liquor License Application: Ryan Witner Anderson, "Target," 1650 S. Milton Road, Series 09 (liquor store - all spirituous liquor), New Application.
             
10. ROUTINE ITEMS
             
A. Recognition of Bus Art Winners and Ratification: Beautification and Public Art Commission recommendations for Bus Art Project on Climate Change and Hope
  Beautification and Public Arts and Sciences Manager Eliza Kretzman provided a PowerPoint presentation that covered the following:
 
BUS ART ON CLIMATE CHANGE AND HOPE
BACKGROUND
RECOGNITION OF SELECTED ARTISTS
LUKE GILES
DANA KAMBERG
NATE NISE
BEAU ARENAS ORTIZ
KAYLEY QUICK
 
Council expressed their gratitude for the presentation and congratulated the selected artists. They appreciated the inclusions of hope with the messages of climate change and were impressed with the collaboration between commissions, Mountain Line, and local schools.
  Moved by Mayor Paul Deasy, seconded by Councilmember Jim McCarthy to ratify the contracts awarded by the Beautification and Public Arts Commission related to a bus art project on climate change and hope.
  Vote: 7 - 0 - Unanimously
             
B. Update and Review: Working Calendar and Future Agenda Item Requests
  City Clerk Stacy Saltzburg reviewed the Working Calendar and pending Future Agenda Item Requests. Council was appreciative of the update and thanked staff for their work on preparing the upcoming topics for discussion.
             
11. REGULAR AGENDA
             
A. Consideration and Adoption of Ordinance No. 2021-22:  An ordinance of the City Council of the City of Flagstaff clarifying the duties of the Beautification and Public Art Commission, and clarifying that the Procurement Code Manual procedures apply to expenditures for Arts and Sciences and Beautification funds; providing for repeal of conflicting ordinances, severability, and establishing an effective date.
  City Attorney Sterling Solomon introduced the item and stated that the ordinance is needed for some clean up regarding the duties of the Beautification and Public Art Commission.
  The amendments will allow small dollar amount contracts to be processed efficiently and allow Council to provide direction to the commission. This is consistent with current practices and just needs to be clarified accordingly in the city code.
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, ARIZONA CLARIFYING THE DUTIES OF THE BEAUTIFICATION AND PUBLIC ART COMMISSION, AND CLARIFYING THAT THE PROCUREMENT CODE MANUAL PROCEDURES APPLY TO EXPENDITURES OF ARTS AND SCIENCES AND BEAUTIFICATION FUNDS; PROVIDING FOR REPEAL OF CONFLICTING ORDINANCES, SEVERABILITY, AND ESTABLISHING AN EFFECTIVE DATE
  Moved by Councilmember Jim McCarthy, seconded by Mayor Paul Deasy to read Ordinance No. 2021-22 by title only for the first time.
  Vote: 7 - 0 - Unanimously
             
B. Consideration and Adoption of Resolution No. 2021-43 and Ordinance No. 2021-21:  A resolution of the Flagstaff City Council declaring as a public record that certain document filed with the City Clerk and entitled "Nuisance Noise Code Amendments;" and an ordinance of the City Council of the City of Flagstaff, amending the Flagstaff City Code, Title 6, Police Regulations, Chapter 6-08, Noise Control, by adopting by reference that certain document entitled "Nuisance Noise Code Amendments;" providing for penalties, repeal of conflicting ordinances, severability, and establishing an effective date
  Deputy Police Chief Frank Higgins provided a PowerPoint presentation that covered the following:
 
NUISANCE NOISE
NUISANCE NOISE ORDINANCE
WHAT IT COVERS
HOW NOISE WILL BE MEASURED
COUNCIL OPTIONS
PROPOSED PENALTIES AND PROCESS
 
The following individuals addressed Council in support of an ordinance to address nuisance noise:
  • Robyn Cass
  • Michael Collier
  • Rose Houk
The following comments were received:
  • Nuisance noise has significantly increased over the years.
  • The noise impacts people’s lifestyle and wellbeing.
  • Please continue conversations about a possible ordinance to address noise.
  • If the mission of the City is to protect and enhance the quality of life for all, why does it allow nuisance noise to continue.
  • Consider the community’s tolerance for unnecessary vehicle noise.
  • Boise, Idaho restricts noise to 90 decibels at 20 feet; Flagstaff should consider the same.
  • Nothing more than common sense is needed for enforcement.
  • Noise in Townsite has gotten particularly bad in the last year and a half.
  • Enforcement is needed to educate and fine perpetrators.
The following individuals submitted written comments in support of a nuisance noise ordinance:
  • Ellen Ryan
  • Judy Finney
Councilmember McCarthy asked what enforcement would look like. Deputy Chief Higgins stated that it would likely consist of all traffic squads being trained so when they are tracking speed they can also monitor noise. There would need to be some specialized equipment used so there is no subjectivity in enforcement and to ensure that there is something concrete to prove in court. Senior Assistant City Attorney Marianne Sullivan added that specialized equipment is necessary because one person’s view of what is a nuisance may be very different than someone else. Having established limits and ways to quantify the limits is important.
 
Councilmember McCarthy stated that he appreciates starting the process and discussion about putting something in place. He believes that more work is needed, and he suggested a future Work Session to further discuss.
 
Vice Mayor Daggett stated that she would be comfortable with postponing any action to allow more time to consider the process and how things would work.
 
Councilmember Salas also voiced support for postponing action and having a future Work Session. She asked if there were cases from other cities and towns with similar ordinances. She expressed concern about the budgetary impacts and would like to see more analysis in terms of equipment costs, certification costs, and recertification. She was also concerned about the impact on the operations of the Department given their current vacancies and workload; nuisance calls will likely be the lowest priority and while she wants to see the matter addressed an effective enforcement structure is needed.
 
Ms. Sullivan indicated that she did not find any cases but she can do a more comprehensive search to see if there is anything that would provide more guidance.
 
Councilmembers Sweet and Shimoni indicated their support for postponing action and holding a future Work Session to discuss further.
 
Councilmember McCarthy requested a summary on the allowable noise levels at parks to aid in the future discussion.
 
Mayor Deasy stated that he would like to move the ordinance forward with a hard limit of 88 decibels. He is concerned that going to a Work Session would be moving in the wrong direction and would like to see something put into place sooner rather than later.
 
A majority of Council was supportive of postponing the item until after a Work Session could take place.

A break was held from 4:56 p.m. through 5:17 p.m.
             
12. DISCUSSION ITEMS
             
A. Lone Tree Overpass Project Update

ITEM POSTPONED TO A LATER DATE
             
B. Public Release of Draft Active Transportation Master Plan
  Multi-Modal Transportation Planner Martin Ince provided a PowerPoint presentation that covered the following:
 
DRAFT ACTIVE TRANSPORTATION MASTER PLAN
INTENT OF THE ATMP
CONTENTS
APPROACH (THE BIG SHIFT)
POLICY SUPPORT
STRATEGIES AND ACTIONS
PED/BIKE INFRASTRUCTURE
PLANNING AND DESIGN GUIDANCE
PROCESS
PUBLIC REVIEW
OPEN HOUSES
COMMUNITY SURVEY
COUNCIL ROLE
FLAGSTAFF ATMP WEBSITE
 
Councilmember Shimoni expressed excitement about the effort moving forward. He requested a one-page graphic that could direct people to the different informational resources.
 
Councilmember Aslan asked how Proposition 419 money could be invested in critical infrastructure needs if the John Wesley Powell extension was not built out. There will be conversation in the community about whether the extension project should happen.
 
City Engineer Rick Barrett stated that only 40% of the John Wesley Powell extension would be funded by Proposition 419 funds. The extension will connect Pine Canyon to the Butler Avenue and Fourth Street intersection. They are nearing completion of the engineering portion and they are working on the Regional Plan amendment. Council will be heavily involved in many of the details and there will be a lot of public involvement along the way.
 
Councilmember Salas noted that the John Wesley Powell extension is stipulated in the Regional Transportation Master Plan which was developed by many partners within the community. The Council has advocated for funding for the extension. The discussion about the ATMP needs to focus on how the goals coincide and compliment the Regional Transportation Master Plan goals.
             
C. Discussion of Letter Regarding 4FRI RFP Cancellation
  Interim Public Affairs Director Sarah Langley and Wildland Fire Manager Neil Chapman explained that the U.S. Forest Service decided to cancel the Four Forest Restoration Initiative Phase 2 request for proposals (RFP). The Forest Service indicated that the RFP requirements were not aligned with industry standards and that the project involves significant financial and investment risks that are unresolved.
 
The letter for consideration highlights the City’s commitment to forest restoration and its desire to see such project advance and continue.
 
Councilmember McCarthy requested that resulting flooding should also be noted in the letter. With that addition, Council was supportive of sending the letter to the U.S. Forest Service.
             
13. 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 Citizens' Petition seeking to "designate that Woody Way Traffic is a one-way street westbound only. Allowing for emergency vehicle access."
  Petitioner Brianne Hall introduced the petition asking Council to close Woody Way to westbound traffic. She expressed concern about safety in the area stating that the 90 degree turn is difficult to navigate especially when cars are speeding. Too many vehicles are now funneling through the area and putting lives and property at risk.
 
Transportation and Engineering Project Manager Stephanie Santana provided a PowerPoint presentation that covered the following:
 
OUTLINE
VICINITY MAP
ROLE OF TRANSPORTATION COMMISSION
BACKGROUND/HISTORY OF WOODY WAY
CITY TRAFFIC STUDY
RECENT DATA
CURRENT PILOT PROJECTS
RADAR FEEDBACK SIGNS
NEXT TRAFFIC COUNTS
UPCOMING DISCUSSIONS WITH TRANSPORTATION COMMISSION
 
The following individuals addressed Council in support of the citizen petition:
  • Garrett Hall
  • Melody Bowling
The following comments were received:
  • Boulder Point streets are narrow and when cars park on both side of the street it is narrowed to one way which requires vehicles to stop and sometimes back up to allow others to pass.
  • Woody Way should be one way only.
  • Frustrations between drivers are high.
  • The narrow streets combined with speeding drivers is highly dangerous.
  • This is a quality of life issue as much as it is a safety issue.
  • Noise is a big issue now.
  • People have willful disregard for the law and feel like they can come through our neighborhood.
  • Drivers are in a hurry and they are extremely disrespectful.
  • The traffic calming measures are nowhere near where this intersection is and no one stops at the stop signs.
  • A permanent solution is needed to address the issue.
Written comments in support of the citizen petition were submitted by the following:
  • Jason Nackard
Written comments in opposition to the citizen petition were submitted by the following:
  • John Forsythe
  • The Presidio in the Pines Board of Directors
  • Crystal Graziano
  • Robert Davis
  • Elizabeth Jorgensen Winslow
  • Don and Lynne Luker
Councilmember Shimoni stated that similar issues are occurring in other areas of the community. Narrow roads encourage slower speeds. He is eager to see what comes out of the commission discussions regarding the matter. He would like to have the matter run through he proper course and then come back to Council with recommendations from the commissions and staff. He asked staff to consider options that do not negatively impact bicyclists and pedestrians.
 
Councilmember Aslan indicated that he supports the petition and is ready to shut down the road and then discuss other measures.
 
Vice Mayor Daggett acknowledged the challenges being faced by residents. She would like the Transportation Commission and staff to determine the best course of action. There is a big problem all around town with angry drivers driving too fast and being aggressive without thinking about consequences. People need to slow down and respect neighborhoods.
 
Councilmember Sweet noted the increasing traffic and indicated that she does want to know the results of the studies and commission discussions before making a decision.
 
Councilmember McCarthy indicated that prior to Presidio in the Pines being built, Council had a discussion about whether the road should be open or closed and at that time Council made the decision to keep the road closed during construction and that when the construction was done the road would be opened. That was the promise to the people in Presidio.
 
Mayor Deasy recognized the frustration felt by the neighborhood and stated that similar issues exist in other areas of the community. Something needs to be done but it should go through the proper process with the commissions and staff.
 
A majority of Council supported placing the item on a future agenda for discussion. Council asked staff to compile the results of the traffic analysis and meet with the commissions prior to the discussion with Council.
             
14. CITY COUNCIL REQUESTS FOR FUTURE AGENDA ITEMS
  Mr. Clifton noted that staff made a small change to the agenda and separated the To/From section from the Request for Future Agenda Items. To/From would occur at the beginning of the meeting and then the Future Agenda Item Requests would come towards the end of the agenda. Staff is looking for feedback on whether Council would like to continue the new format.
 
Councilmember Shimoni stated that he appreciates giving closing words at the end of the meeting and would support keeping To/From together with Future Agenda Item Requests at the end of the meeting. Council agreed they would like to keep the format as it was with To/From and Future Agenda Item Requests combined at the end of the meeting.
 
Councilmember Salas expressed words of compassion and sympathy for the family, friends, and co-workers of Bret Peterson. She also encouraged the public to donate supplies such as face masks and personal hygiene products to Flagstaff Shelter Services. She also recognized staff involved with the Fourth Street bridge, the City was recognized for the design that improved safety for vehicles, cyclists, and pedestrians.
             
15. ADJOURNMENT

The Regular Meeting of the Flagstaff City Council held September 21, 2021, adjourned at 6:35 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 September 21, 2021. I further certify that the Meeting was duly called and held and that a quorum was present.
 
DATED this 1st day of November, 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 01-Mar-24 01:11 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
218 ms 218 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
218 ms 218 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 01:11:19.019
			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 @ 01:11:19.019
				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 @ 01:11:19.019
			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 @ 01:11:19.019
				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 @ 01:11:19.019
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 01:11:19.019
	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 @ 01:11:19.019
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:11:19.019
		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 @ 01:11:19.019
	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 @ 01:11:19.019
		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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
		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 @ 01:11:19.019
		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 @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
	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 @ 01:11:19.019
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:11:19.019
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=21) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 01:11:19.019
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2021-09-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2021-09-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:11:19.019
			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(1327 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 @ 01:11:19.019
	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 @ 01:11:19.019
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 1326 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=31) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
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 = 1326 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 = 711 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 @ 01:11:19.019
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 @ 01:11:19.019
	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 @ 01:11:19.019
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=28) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
		
	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 = 711 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 711 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=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
		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 = 711 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=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
		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 = 711 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 @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15869 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15869 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15867 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15867 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10403 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15872 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15872 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15868 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15868 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15891 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15891 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15892 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15892 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11380 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15893 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15893 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11381 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15880 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15880 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15890 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15890 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11382 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15879 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15879 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11383 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15897 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15897 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15896 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15896 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11384 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15870 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15870 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10404 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			    	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 = 3555 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 15870 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 15870 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:11:19.019
	
		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 @ 01:11:19.019
				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 @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15883 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15883 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15884 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15884 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15871 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15871 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15885 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15885 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10405 
getMotions (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			    	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 = 3556 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 15885 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 15885 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:11:19.019
	
		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 @ 01:11:19.019
				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 @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15889 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15889 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11385 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15873 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15873 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15895 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15895 
SortedList (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11469 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11386 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10406 
getMotions (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			    	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 = 3557 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 15895 AND
					      motion_seq = 4 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 15895 AND
							  allVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 01:11:19.019
	
		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 @ 01:11:19.019
				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 @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15886 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15886 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10407 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15874 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15874 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15887 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15887 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15881 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15881 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11387 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15894 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15894 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11388 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15878 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15878 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15888 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15888 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 10408 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15882 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15882 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 11389 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 15876 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 15876 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 01:11:19.019
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:11:19.019
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 01:11:19.019
	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 @ 01:11:19.019
		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 @ 01:11:19.019
		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=&mt=ALL&get_month=9&get_year=2021&dsp=min&seq=1327
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=&mt=ALL&get_month=9&get_year=2021&dsp=min&seq=1327
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=7968384
cftoken=caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
hitcount=4
lastvisit={ts '2024-03-01 01:11:19'}
timecreated={ts '2024-03-01 01:11:19'}
urltoken=CFID=7968384&CFTOKEN=caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
Cookie Variables:
CFID=7968384
CFTOKEN=caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=1327
Session Variables:
cfid=7968384
cftoken=caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_7968384_caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
subdir=/public/
tzoffset=0
urltoken=CFID=7968384&CFTOKEN=caa3da6db352430-BA049C48-F0E8-64BF-2461B3A82CCBE546
URL Parameters:
dsp=min
get_month=9
get_year=2021
id=
mt=ALL
seq=1327
Debug Rendering Time: 0 ms