Return
CITY COUNCIL BUDGET RETREAT
TUESDAY, APRIL 24, 2018
AND WEDNESDAY, APRIL 25, 2018
CITY HALL COUNCIL CHAMBERS
211 WEST ASPEN
1:00 P.M.
             
1. Call to Order
  Mayor Evans called the Budget Retreat of April 24, 2018, to order at 1:02 p.m.
             
2. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD (arrived at 1:04 p.m.)
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

NONE






  Others Present: Interim City Manager Barbara Goodrich; City Attorney Sterling Solomon
             
3. City Council FY 2019 Budget Retreat
  Interim City Manager Barbara Goodrich provided an overview of the budget process. Ms. Goodrich offered that she feels that the proposed budget that is being brought forward addresses many of the Council’s goals and priorities, but there were also many things that were unable to be addressed. The City is healthy from an economic perspective with on-going revenues continuing to grow but there were things that still could not be done including staff compensation. There was no ability to offer any kind of merit increase this year and unfortunately this is being reflected in the City’s increased turnover. There are a number of requests in front of Council that are for maintenance, capital, and city services that were unable to be provided for this year as well. There will be discussions about the various fees and taxes that are new, existing, or being requested to continue basic city services. They also include providing funds for sustained maintenance of the Flagstaff Watershed Protection Project. Additionally, there are a number of desired enhancements in the Sustainability Section and they would like to review their fees to increase their revenues and that is not part of this year’s recommendation because of all the things that are already on the table. These are just a couple of the items that were unable to be addressed to the depth Council may have wanted.
 
Ms. Goodrich offered that she would like to suggest that the Council take a longer view of the City budget process, not this fiscal year but going forward into the next budget year. Staff prepares a five-year plan each year to ensure that the budget decisions are sustainable going forward. It is necessary to look at the root cause of why the City is unable to advance so many of its strategic priorities and it really comes down to the continued burden that the public safety pension system is putting on the budget.
 
Over the last three years the unfunded liability has grown by an average of $10 million per year putting the current unfunded liability over $100 million. These increases are a result of changes in actuarial assumptions and the two recent lawsuits that rolled back benefits to the people who were vested in those benefits before the package changed.
 
Of the $10.5 million spent each year for public safety pension, $8 million is for the unfunded portion. She again suggested that the Council take longer term view and consider possible solutions to this problem. Perhaps it is time for the Council and the community to seriously consider a public safety tax in 2020 to buy down the liability so that $8 million can be used for ongoing operations in the city and be able to advance the community priorities in a better way than is possible today.
 
It is a big ask but doing this would lessen the need to continually ask for increased fees and taxes to continue services in the community. A priority or performance-based budgeting process will do a deep dive into what the community feels are priority services and programs provided by the city. This is important because every service the city provides has a constituency and it is very hard to objectively talk about what the impacts are when there is a Council Chambers full of people that depend on that service. This type of budgeting system will allow objective community feedback on what the community, as a whole, feels are important services to provide within limited financial resources.
 
Councilmember McCarthy asked if the City continues on its current path with the pension issues if it will get caught up. Ms. Goodrich state that implementation of Tier 3 will get the City there. The City does not have control over the actuarial assumptions and the continuation of the decrease in interest rates will help make the contributions go further but it is time to be more proactive.
 
Staff is looking at a possible study to identify where the City’s sales tax primarily comes from; from inside residents our outside visitors. That data will be used to provide consideration of a sales tax initiative. Being aggressive could mean that a majority of the pension could be paid off in five years and the City could start immediately putting some of those resources back into the organization’s resources and employees.
 
Management Services Director Rick Tadder began the Budget Retreat PowerPoint presentation:
 
APPROACH FOR FY2019 BUDGET
GOALS AND OBJECTIVES
BUDGET PRIORITIES
BASE BUDGET REDUCTIONS
BUDGET OUTLOOK
BASE BUDGET REDUCTIONS
REQUESTS FROM DIVISIONS
REVENUES – GENERAL FUND
EXPENDITURES – GENERAL FUND
SUMMARY – GENERAL FUND
TOTAL AVAILABLE FOR PARKING LOT: $253,000
BUDGET OUTLOOK
EXPENDITURES – ALL FUNDS
EXPENDITURES BY GOAL – $14.7M
REVENUE CONSIDERATIONS
TAX DISCUSSION
RECENT FEE/CHARGE CHANGES
UPCOMING FEE/CHARGE CHANGES
BUSINESS LICENSES AND TRANSACTION PRIVILEGE TAX LICENSES (TPT)
STORMWATER SERVICE CHARGE
FUTURE FEE/CHARGE CHANGES
SOLID WASTE
ENVIRONMENTAL FEE
FLAGSTAFF WATERSHED PROTECTION PROJECT
AIRPORT PARKING
COUNCIL GOALS, OBJECTIVES AND BUDGET PRIORITIES
BUDGET PROCESS – RECOMMENDED BUDGET
REVIEW OF NEW INVESTMENTS BY COUNCIL GOAL
 
At this time, staff members reviewed various Council Goals and related objectives, budget priorities, and work programs with Economic Vitality Director Heidi Hansen continuing the presentation.
 
ECONOMIC DEVELOPMENT
Grow and Strengthen a More Equitable and Resilient Economy
 
Objectives:
Market Parks and Recreation as accessible for all regardless of income
 
Budget Priorities:
Downtown Litter/Recycling/Cleanup
 
Work Program:
Airport – presented by Airport Director Barney Helmick
Community Investment – presented by Community Investment Director David McIntire
Tourism – presented by Convention and Visitor’s Bureau Director Trace Ward
Economic Vitality Campaign – presented by Ms. Hansen
Flagstaff Sister Cities – presented by Ms. Hansen
 
After a brief discussion Council requested that the Airport Waste Dump Station, TSA Security, and Sister Cities funding be added to the Parking Lot list.
 
A break was held from 3:08 p.m. to 3:21 p.m. at which time Housing Director Sarah Darr continued the presentation.
 
AFFORDABLE HOUSING
Support Development and Increase the Inventory of Public and Private Affordable Housing for Renters and Homeowners Throughout the Community
 
Objectives:
Increase the number of affordable rental units
Seek partnerships with private developers to increase the inventory of affordable rental and ownership housing
 
Budget Priorities:
Funding for Down Payment and Closing Cost Programs
 
Work Program:
Continued facilitation with Brinshore for Scattered Sites Affordable Housing
Provide public education for Housing ballot question
Participate with local groups to enhance housing opportunities throughout the community
Work with local service providers on the Front Door program
Pursue further creation of rental housing units on City owned land

Ms. Goodrich continued the presentation.
 
SOCIAL JUSTICE
Advance Social Justice in the Community
 
Objectives:
Develop a strategic plan to implement the Indigenous Circle of Flagstaff recommendations.
Improve overall communications and engagement with Native Nations as we work in partnership on shared issues and concerns.
Facilitation of annual meetings with tribal nations and collaborate on agenda development
 
Budget Priorities:
Indigenous Organizational Development
Meetings with Indigenous Councils
Federal Match for Disability Service Providers
Economic Analysis of Visitation to the Community
 
Work Program:
Indigenous Circle of Flagstaff Recommendations
Indigenous Commission
Cultural Awareness Training
Marketing of Indigenous Community
Meetings with Indigenous Groups
 
Discussion was held concerning minimum wage and the federal match for disability service providers as well as the need for an economic analysis of visitation to the community.
 
Public Works Director Andy Bertelsen continued the presentation.
 
TRANSPORTATION AND OTHER PUBLIC INFRASTRUCTURE
Deliver Quality Infrastructure and Continue to advocate for and Implement a Highly Performing Multi-Modal Transportation System
 
Objectives:
Advocate for additional state and federal funding for state and federal roads
Complete construction of the new core maintenance facility in the next two years
Replace aging infrastructure
 
Budget Priorities:
Northern Arizona Council of Governments Regional Planning Grant Increase
Environmental Remediation and Demolition of Mogollon Yard
Replace Two (2) Street Sweepers
Replace One (1) Dump/Plow Truck
Repurpose Two (2) Solid Waste Tractors and Trailers to Street Operations
 
Work Program:
Street Lights to Enhance Dark Skies
Street Maintenance Program
Street Sweeping
Storm Drain Maintenance
 
Planning Director Dan Folke continued the presentation.
 
BUILDING AND ZONING/REGIONAL PLAN
Revise the Zoning Code to Remove Ambiguities and Ensure it is Consistent with Community Values and the Regional Plan
 
Objectives:
Adjust the codes to better reflect community values and the intent of the regional plan.
 
Budget Priorities:
Codification Services
Building Inspector Overlap
StruCalc Computer Program
 
Work Program:
Complete Southside Specific Plan and Code Amendments
Implement Building Safety succession plan for Building inspection retirements
Accept and review building permit plans electronically
 
Council discussed the staffing needs of Community Development and requested that a Neighborhood Planner position and Planning Development Manager position be added to the Parking Lot list.
 
The Council also discussed impact fees. Ms. Goodrich noted that they can only be collected and spent if they are increasing service to a new area or because of new growth. She said that if they are trying to enhance the code enforcement they provide, they could not be used for that; if they were growing by 10,000 people that requires a new police substation, it could be used for that new infrastructure.
 
Sustainability Manager Nicole Antonopoulos continued the presentation.
 
CLIMATE CHANGE
Take Meaningful Climate Change Action
 
Objective:
Develop and implement a climate action plan
 
Budget Priorities:
Energy Data and Energy Rebate Contract Pay
Fire Adapted Community Events
Greenhouse Gas Inventory Software
 
Work Program:
Climate Action and Adaptation Plan
Arizona Renewable Energy Collective
City of Flagstaff Hopi Renewable Energy Memo of Understanding
Fire Adapted Community Resiliency and Preparedness Events
Home Energy Efficiency Rebate Program
 
Council requested that increasing funding to the Home Energy Efficiency Program and Teacher Training for sustainability be added to the Parking Lot list.
 
Water Conservation Manager Erin Young continued the presentation.
 
WATER CONSERVATION
Become a National Leader in Water Conservation in All Sectors
 
Objective:
Secure long-term water resources
 
Budget Priorities:
Aquifer Recharge Feasibility Study
Water Service contribution toward Sustainability programs
 
Work Program:
Conservation Program
Water Resources
Reclaimed Water
 
A break was held from 5:05 p.m. through 5:25 p.m. after which Fire Chief Mark Gaillard continued the presentation.
 
ENVIRONMENTAL AND NATURAL RESOURCES
Actively Manage and Protect All Environmental and Natural Resources
 
Objective:
Preserve natural resources
Increase City recycling from 13% to 75%
 
Budget Priorities:
Open Space Specialist
Schultz Creek Trailhead Construction
Zero Waste Coordinator
 
Work Program:
Flagstaff Watershed Protection Project
Four Forests Restoration Initiative
Firewise Neighborhoods
Wildland Urban Interface Code
Volunteers
Fire Metrics: Occurrences and Acres/Incident (Treated vs Untreated)
McMillian Mesa Management Plan
Schultz Creek Trailhead Management Plan
Picture Canyon Natural and Cultural Preserve Improvements and Graffiti Abatement
Indigenous Youth Service Academy
Conservation Easement Reporting
Legally Designated Open Space Easement Process Updated (Application/Fee Assessment)
 
Human Resources Director Shannon Anderson continued the presentation.
 
COMPENSATION AND BENEFITS
COMPENSATION TRENDS
BENEFIT TRENDS
RETENTION TRENDS
COMPENSATION
BENEFITS
FUTURE RETIREMENT COSTS
 
Employee Advisory Committee Co-Chairs Kristi Markey and Tamara Lawless continued the presentation.
 
EAC PRESENTATION FY2019
EAC FY2019 BUDGET RECOMMENDATIONS
WHAT WAS ADOPTED BY THE BUDGET TEAM
EAC FY2019 ACCOMPLISHMENTS
 
Ms. Anderson continued the presentation.
 
PERSONNEL
Attract and Retain Quality Staff
 
Objectives:
Invest in employee training
Ensure adequate Public Safety staffing levels
Enhance tuition reimbursement opportunities throughout the organization
Provide parking incentives for employees
 
Budget Priorities:
Increase in Training Budget City Wide
Regional Fire Training Coordinator
Increase (3) Paramedic Assignments
Summit IGA
CART Overtime Funding
Radio System
Police Officers (2)
Police Aides (3)
Security Guards for Libraries
Tuition Reimbursements (Citywide)
Parking Permits, EcoPass and Incentives
 
Work Program:
Recruitment Incentive for Police Personnel
Hiring Bonus for Lateral Officers
Hired 2 Police Officers with award of COPS Grant
Hired 6 Firefighters with award of SAFER Grant
IGA with Summit Fire and Medical District
Regional Firefighter Academy
 
Following Council discussion, it was requested that paid maternity/paternity leave, a ten-year longevity payout, and an establishment of a housing relocation fund be added to the Parking Lot list.
 
Communications Manager Jessica Drum continued the presentation.
 
COMMUNITY OUTREACH
Enhance Public Transparency and Accessibility
 
Budget Priorities:
Election
Citizens Survey
Website Optimization
Certified Public Participation and Other Trainings
 
Work Program:
Strategic Communications Plan
Social Media Best Practices Guide
 
Neighborhood Liaison Valeria Chase continued the presentation.
 
TOWN & GOWN
Enhance Relationships Between the City and Institutions of Higher Education
 
Objective:
Coordinate with NAU, CCC and the Arizona Board of Regents (ABOR) in planning for future growth of the student population
 
Budget Priorities:
Neighborhood Liaison
 
Work Program:
International Town and Gown Association
Community Welcome Event
Neighborhood Events and Outreach
Internship IGA with NAU
 
Code Compliance Manager Reggie Eccelston continued the presentation.
 
CODE COMPLIANCE
Achieve Comprehensive and Equitable Code Compliance
 
Budget Priorities:
Graffiti Abatement Supplies
Litter Removal Program
Litter Prevention Programming Supplies
 
Work Program:
Work with neighborhood associations and community groups to prioritize issues and coordinate enforcement
Complete neighborhood outreach on parking and solid waste in neighborhoods around NAU
Work with Dark Skies community to develop education pieces and enforcement of dark sky compliant lighting
Community Stewards community clean-ups and group clean-ups
 
Council requested that a Litter Clean Up Program be added to the Parking Lot list.
 
At this time, the following individuals addressed the Council regarding the budget:
  • Amanda Kristinat, Boys and Girls Club of Flagstaff
  • Delfina Rodriguez, Arrowhead Mobile Home Park resident
  • Norma Rodriguez, Arrowhead Mobile Home Park resident
  • Miriam Meza, Arrowhead Mobile Home Park resident
  • Olga Garcia, Arrowhead Mobile Home Park resident
  • Gabby Vazguez, Arrowhead Mobile Home Park resident
             
4. Adjournment
  The Flagstaff City Council Budget Retreat of April 24, 2018, recessed at 7:33 p.m.
             
City Council FY 2019 Budget Retreat - Day Two
             
1. Call to Order

Mayor Evans called the Special Budget Retreat of the Flagstaff City Council held April 25, 2018, to order at 9:03 a.m.
             
2. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
ABSENT:

NONE






  Others present: Interim City Manager Barbara Goodrich and City Attorney Sterling Solomon.
             
3. City Council FY 2019 Budget Retreat
  City Engineer Rick Barrett provided a PowerPoint presentation that covered the following:
 
CAPITAL IMPROVEMENT PROGRAM OVERVIEW
CAPITAL IMPROVEMENT PROGRAM SUMMARY – FISCAL YEARS 2019-2023
 
Capital Project Manager Trevor Henry continued.
 
EIGHT PROGRAM CATEGORIES
PROGRAM CATEGORIES FY18 ESTIMATES
PROGRAM CATEGORIES FY19 BUDGET
PROGRAM CATEGORIES FY20-23 PROJECTIONS
PROGRAM CATEGORIES CATEGORY TOTAL
TOTAL PROGRAM SUMMARY
GENERAL GOVERNMENT
STREETS/TRANSPORTATION
FUTS
BBB
WATER/WASTEWATER/RECLAIMED WATER
STORMWATER
SOLID WASTE / SEMS
AIRPORT
 
Mr. Tadder continued the presentation.
 
OTHER NEW INVESTMENTS
APPROVED PERSONNEL AND OTHER REQUESTS
Census 2020 Count Committee
Service Partner Contracts
Library
Tourism
 
Councilmember Barotz asked about IT security funding. IT Director Ladd Vagen stated that there is approximately $450,000 in anticipated cost to increase securities. Not all of that was funded in this year’s budget but there are improvements that can be done with the funding that was received.
 
Councilmember Bartoz requested that additional IT funding be added to the Parking Lot list.
 
A break was held from 10:19 a.m. through 10:46 a.m.
 
At this time the following individuals addressed the Council regarding the budget:
  • Moran Henn, Willow Bend
  • Murielle Mesa, Arrowhead Mobile Home Park resident
  • Gaby Vasquez, Arrowhead Mobile Home Park resident
  • Jose Alvarado, Arrowhead Mobile Home Park resident
  • Dr. Louis Fernandez, Arrowhead Mobile Home Park resident
  • Susan Altiveros, Arrowhead Mobile Home Park resident
  • Susan Wallace, Arrowhead Mobile Home Park resident
  • Paul Linds, Arrowhead Mobile Home Park resident
  • Evan Hotbaker, Arrowhead Mobile Home Park resident
Written comment cards regarding the Council budget were submitted by the following:
  • Nicole Charles
  • Nate Edenhofer
  • Mare Schumacher
  • Jessica Martinez
The budget discussion continued.
 
Councilmember Barotz asked about the increased service levels with the Fire Department. There has been an increased call load by over 325% while reducing staff. She asked how the current financial situation in the department is modifying the way they respond to calls and the equipment used in an effort to save money.
 
Fire Chief Mark Gaillard stated that the situation is the rapidly increasing service demand and no increase in resources. The number one requested service is emergency medical services and it has been difficult to ensure a paramedic is responding with Fire personnel. This is a high priority use and they want to put enough paramedics on the work force to respond at all times. There has been discussion about a partnership with Summit Fire to reduce overhead and increasing service in the community. With regard to equipment Flagstaff Fire is using equipment that in some communities would have been retired at half the level that is currently being used.
 
Councilmember Putzova asked what the total budget contingency the City maintains in its budget is. Ms. Goodrich explained that there is a contingency fund for forest fires and other unexpected things that come up. 20% is the current contingency percentage as adopted by Council some years ago.
 
Mr. Tadder continued the presentation.
 
COUNCIL PARKING LOT ITEMS
 
Mr. Tadder provided Council with a list of their requested Parking Lot items. The Council reviewed and discussed each one; the final outcome of the parking lot list is attached.
             
4. Adjournment
  The Flagstaff City Council Budget Retreat of April 25, 2018, adjourned at 1:49 p.m.
   
_______________________________
MAYOR
ATTEST:
 

 
 
_________________________________
CITY CLERK

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 28-Apr-24 08:04 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.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
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
187 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 08:04:46.046
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 08:04:46.046
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 08:04:46.046
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 08:04:46.046
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:04:46.046
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:04:46.046
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 08:04:46.046
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
	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=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:04:46.046
		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) = 2018-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:04:46.046
			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(694 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:46.046
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=16ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:46.046
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 693 
getAllMnLines (Datasource=frsRO, Time=31ms, Records=11) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
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 = 693 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 = 323 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=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
		
	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 = 323 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=16ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 323 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7444 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5511 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8721 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6242 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7447 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6240 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7445 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6241 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8719 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8720 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 7443 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 5512 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8722 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6243 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8723 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:04:47.047
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6244 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:04:47.047
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:04:47.047
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:04:47.047
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:04:47.047
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=4&get_year=2018&dsp=min&seq=694
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=4&get_year=2018&dsp=min&seq=694
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=9351102
cftoken=a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
hitcount=4
lastvisit={ts '2024-04-28 08:04:46'}
timecreated={ts '2024-04-28 08:04:46'}
urltoken=CFID=9351102&CFTOKEN=a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
Cookie Variables:
CFID=9351102
CFTOKEN=a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=694
Session Variables:
cfid=9351102
cftoken=a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9351102_a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
subdir=/public/
tzoffset=0
urltoken=CFID=9351102&CFTOKEN=a43e49244b20b797-742FE696-BACC-CD5E-0148E5BDEB091499
URL Parameters:
dsp=min
get_month=4
get_year=2018
id=
mt=ALL
seq=694
Debug Rendering Time: 0 ms