Return
   
CITY COUNCIL BUDGET RETREAT
WEDNESDAY-THURSDAY, APRIL 26-27, 2017
FLAGSTAFF CITY COUNCIL CHAMBERS
211 WEST ASPEN
8:00 A.M.

 
MINUTES
           
 
             
1. Call to Order
  Mayor Evans called the Budget Retreat/Special Meeting of April 26-27, 2017, to order at 9:00 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: City Manager Josh Copley and City Attorney Sterling Solomon.
             
3. City Council FY 2018 Budget Retreat
  Mr. Copley began the Retreat with a statement that the proposed budget does not have extra money at the end of it, so to accomplish additional capacity is to reduce other areas. He then began a PowerPoint presentation:

APPROACH FOR FY2018 BUDGET

BUDGET OUTLOOK

Mr. Copley asked Council what their expectations were for the Retreat.

Councilmember Putzova said that it was important to reflect on how the policy goals tie to the budget and are reflected in the organizational structure.

Mr. Copley noted that this is the final meeting for Council to provide input to ensure that the final budget is meeting the objectives before it comes back before them in a public hearing setting.

Vice Mayor Whelan said that her hope today is that the Council comes together and offers staff clear direction and approval of those things that they have worked hard on.

Management Services Director Rick Tadder began the presentation:

BUDGET OUTLOOK REVENUES - GENERAL FUND
BUDGETED NEW REVENUES
USER FEES

Brief discussion was held on the user fee increases, as directed by Council in February. Mr. Copley said that if the fee changes are not approved, they will need to remove expenditures. He said that it is different with property tax; the proposed budget has not incorporated an increase in property tax.

Councilmember Putzova asked why there was a discrepancy between the total new revenue allocated of $4.5  million in the transmittal letter and the $10.7 million in the budget. Mr. Tadder explained that the $10.7 million was citywide; the $4.5 million was General Fund only.

Councilmember Putzova asked for a one-page sheet showing all of the new revenues and how they are going to spend it. Mr. Tadder referred Council to Page 453 of the Budget Book, noting that they do not normally show the information in that manner. They usually look at revenues in a fund.

BUDGET OUTLOOK
EXPENDITURES - GENERAL FUND
FIXED COSTS

It was noted that the Pension Costs go from $7.4 million to $8.6 million in FY18. Councilmember Overton asked if they continue to put funds into the unfunded amount; Ms. Suda replied that they do.

Deputy City Manager Barbara Goodrich said that they accumulate new liability as quickly as they pay it off. They are still paying the required rate and are on track to have it paid off in 18-20 years, but they are not advancing at this time.

BUDGET OUTLOOK
REQUESTS FROM DIVISIONS

Ms. Suda noted that there were 62 positions requested overall. Mr. Copley said that the best people to tell them those needs are the employees. The employees assess the need, the capacity relative to the work program and submit the RSL (Revised Service Level) up through their chain of command. Every RSL must be justified with a nexus to a Council goal or objective, or if not, an ongoing City service that was not addressed that this furthers. The Budget Team goes through department review. They say no to about half of what is requested, but nothing that was asked for was frivolous.

EXPENDITURES - ALL  FUNDS
BUDGET OUTLOOK - OVERALL PERSONNEL
BUDGET PRIORITIES AND PROCESS AND NEW INVESTMENTS
REVIEW OF NEW INVESTMENTS BY COUNCIL GOALS

Deputy City Manager Shane Dille then continued the presentation:

MATRIX

Mr. Dille said that last December staff presented its annual report to Council. It was an eye-opening process in that the document consisted of 20 pages. He said that it represented staff's efforts, but they all agreed that the document consisted of a lot of activity in serving the community's needs, but they had a hard time defining success.

With that in mind they brought forth a proposed format for addressing Council goals and related objectives. While there was overall support by Council for the formatting, concern was also given to not making more work for staff. It was suggested that staff and Council work together to make sure everyone's needs are met.

Mr. Copley said that this tool is extremely useful to staff. It represents the transmission of policy direction from Council and how it converts into administrative action for employees.

A break was held from 10:20 a.m. to 10:42 a.m.
  At this time, staff members reviewed various Council Goals and related objectives, with Economic Vitality Director Heidi Hansen continuing the presentation:

ECONOMIC DEVELOPMENT
Grow and Strengthen a More Equitable and Resilient Economy

Objectives:
     Improve the small business experience when going through the City process
     Support and enhance services to all businesses in the community
     Market Parks and Recreation as accessible for all regardless of income
     Increase eco and historic tourism in Flagstaff

Other items:
     Accelerator Contingency
     Parking District Software and Building Lease
     Airport Marketing Efforts

A break was held from 12:10 p.m. to 12:17 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 home owners throughout the community

Objectives:
     Pursue financing strategies for affordable housing to create additional rental and ownership
          housing opportunities.
     Increase the number of affordable rental units.
     Improve the distribution of affordable rental units throughout the community and
          neighborhood.
     Establish an Employer Assisted Housing Program

Discussion was held on a potential ballot question in 2018 regarding housing and various issues related to housing needs.

City Prosecutor Bret Harris continued the presentation:

SOCIAL JUSTICE
Advance social justice in our community

Objectives:
     Strengthen and repair relationships with the indigenous and immigrant communities.
    
Other items:
     Boys & Girls Club Service Partner Contract
     Annual Meeting with Tribal Nations and Mayors Summit
     Native Youth Service Academy Pilot Program at Picture Canyon

Community Development Director Mark Landsiedel then continued the presentation:

TRANSPORTATION AND OTHER PUBLIC INFRASTRUCTURE
Deliver quality community assets and continue to advocate and implement a highly performing multi-modal transportation system

Objectives:
     Complete the Intergovernmental Agreement with the County for a new courthouse and begin
          the design process.
     Complete the Public Works Yard in the next two years
     Replace aging infrastructure
     Support the airport with needed infrastructure upgrades in order to enhance our tenant and
          patron experience as well as additional airline attraction.
     Support the Regional Transportation Plan

A break was held from 1:48 p.m. to 1:56 p.m.

Planning Director Dan Folke then 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:
     Complete and update neighborhood plans specific to Housing Urban Development
          consolidated plan and target neighborhoods within that plan.
     Align building codes, zoning codes and regional plan

Public Works Director Andy Bertelsen continued the presentation:

CLIMATE CHANGE
Take meaningful climate change action

Objectives:
     Become a 100% renewable energy city as an organization and a community
     Develop and implement a climate action plan

Water Resources Manager Erin Young continued the presentation:

WATER CONSERVATION
Become a national leader in water conservation in all sectors

Objectives:
     Enhance water conservation efforts
     Develop a sustainable water budget

ENVIRONMENTAL AND NATURAL RESOURCES
Actively manage and protect all environmental and natural resources

Objectives:
     Aggressively support efforts for forest health
     Further develop sustainability and waste removal policies and programs
     Preserve natural resources

A break was held from 3:20 p.m. to 3:29 p.m.

Deputy Fire Chief Mark Wilson continued the presentation:

PERSONNEL
Attract and Retain Quality Staff

Objectives:
     Invest in employee training
     Enhance tuition reimbursement opportunities throughout the organization
     Ensure adequate Public Safety staffing levels
     Provide parking incentives for employees

Discussion was held on the City Manager's proposal to adopt a 7% tax levy/revenue increase in FY2018 and an additional 7% tax levy/revenue increase in FY2019 to provide funding to maintain the 12 Public Safety positions after the grant period. Majority of Council supported this proposal.

Other Items:
     Retirement Payouts (16 employees)
     Additional Utility Staff (4 FTEs)
     Additional Library Staff (Partial contingency on additional funding)
     Fire Overtime
     Additional Fleet Staff (2 FTEs)

Human Resources Director Shannon Anderson continued the presentation:

COMPENSATION AND BENEFITS
Compensation Trends
Benefit Trends
Retention Trends
Compensation
Benefit Renewals
Future Retirement Costs

Discussion was held on different benefits that could be provided, other than pay, such as additional vacation time. Staff was asked to place this item on the parking lot.
             
4. Adjournment

The April 26, 2017, portion of the Budget Retreat/Special Council Meeting adjourned at 5:39 p.m.

SPECIAL COUNCIL MEETING
             
1. Call to Order

Mayor Evans called the Special Meeting of April 27, 2017, to order at 9:00 a.m. All Councilmembers were present.
             
2. Consideration and Approval of Construction Manager at Risk Construction Services Agreement (CMAR):  CMAR 2017 Street Maintenance Project - GMP #2 - Chip Seal.
  Senior Procurement Specialist Patrick Brown provided a PowerPoint presentation that covered the following:
 
TERMINOLOGY
CONTRACT ALLOWANCE
CHANGE ORDER AUTHORITY
CONSTRUCTION MANAGER AT RISK – CONTRACTOR’S CONTINGENCY
CONSTRUCTION MANAGER AT RISK – OWNER’S CONTINGENCY
  Moved by Councilmember Charlie Odegaard, seconded by Councilmember Eva Putzova to approve the Construction Manager at Risk Construction Services Agreement with C and E Paving and Grading, LLC in an amount not to exceed $1,603,036.00 for Guaranteed Maximum Price (GMP) #2 - Chip Seal; approve Change Order Authority to the City Manager in the amount of $160,303.00 (10% for GMP #2) to cover potential cost associated with unanticipated or additional items of work; and authorize the City Manager to execute the necessary documents.
  Vote: 6 - 1
 
NAY: Vice Mayor Jamie Whelan
  Councilmember Putzova left the meeting at 9:30 a.m.
             
3. Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement:  2017 Street Maintenance Project - GMP #1 - Overlay.
  Vice Mayor Whelan asked if items 2 and 3 are for the same project but different phases. Public Works Project Manager Adam Miele stated that it is the same contractor but not the same project; he explained that item 2 is for chip sealing certain streets and item 3 is for the overlay of certain streets.

Vice Mayor Whelan expressed frustration with the City's policies related to contingencies and change order allowances. Mr. Copley stated that staff is bringing the Procurement Manual to Council and there will be an opportunity for Council to revisit the policies.
  Moved by Councilmember Scott Overton, seconded by Councilmember Charlie Odegaard to approve the Construction Manager at Risk Construction Services Agreement with C and E Paving and Grading, LLC, in an amount not to exceed $2,695,631.29 for Guaranteed Maximum Price (GMP) #1 - Overlay projects approve Change Order Authority to the City Manager in the amount of $269,563.00 (10% for GMP #1) to cover potential cost associated with unanticipated or additional items of work; and authorize the City Manager to execute the necessary documents.
  Vote: 6 - 0
             
4. Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement: Phase 1 Utility Improvements of the Road Repair and Street Safety Program (RR&SS) Bundle #2 (Beaver/Dale) project to be awarded to Eagle Mountain Construction Inc. in the amount of $1,969,771.19.
  Moved by Councilmember Scott Overton, seconded by Councilmember Charlie Odegaard to approve the Construction Manager at Risk Construction Services Agreement with Eagle Mountain Construction Inc. for Contract Price of $1,969,771.19 and a contract time of 488 calendar days and authorize the City Manager to execute the necessary documents.
  Vote: 6 - 0
             
5. Consideration and Approval of Contract: Approve the Construction Contract with McDonald Brothers Construction in the amount of $1,637,898.50 for the Mike's Pike Water and Sewer Improvement Project (Project).
  Moved by Vice Mayor Jamie Whelan, seconded by Mayor Coral J. Evans to approve the construction contract with McDonald Brothers Construction in the amount of $1,637,898.50 (includes construction total of $1,547,898.50 and contract allowance of $90,000.00), and a contract time of 180 calendar days; approve Change Order Authority to the City Manager in the amount of $154,789.85 (10% of the contract amount, less allowance of $90,000.00); and authorize the City Manager to execute the necessary documents.
  Vote: 6 - 0
  The Special Meeting of April 27, 2017, adjourned at 9:44 a..m. at which time Mayor Evans called the Budget Retreat to order.

Interim Communications Manager Meg Roederer continued the Budget presentation:

COMMUNITY OUTREACH
Enhance Public Transparency and Accessibility

Objectives:
     Build and enhance neighborhood services for the City
     Develop a social media management plan
     Define the City's public communications program

Other Items:
     Labor Standards Manager and Program
     Neighborhood Liaison

Mr. Tadder then continued the presentation:

OTHER NEW INVESTMENTS

A break was held from 10:25 a.m. to 10:37 a.m., at which time Councilmember Putzova returned.

Capital Program Engineer Bret Petersen continued the presentation:

CAPITAL IMPROVEMENT PROGRAM OVERVIEW
EIGHT PROGRAM CATEGORIES
FY17 ESTIMATE
FY18 BUDGET
FY19-22 PROJECTED
CATEGORY TOTAL
TOTAL PLAN SUMMARY
GENERAL GOVERNMENT
STREETS/TRANSPORTATION
STREETS/TRANSPORTATION - LOCKETT CORRIDOR STUDY

Mayor Evans left the meeting at 11:14 a.m.

FUTS FUNDS
BBB FUNDS
WATER/WASTEWATER/RECLAIMED WATER
STORMWATER UTILITY
AIRPORT
SOLID WASTE/SEMS
STORMWATER FEE INCREASE

A break was held from 12:07 p.m. to 12:35 p.m. at which time the Mayor had returned.

COUNCIL DISCUSSION AND PARKING LOT ITEMS

Mr. Copley then began review of the Parking Lot items and said that he also wanted to capture any requests for further information. 

FACTS

Mr. Copley said that they would like to capture the $25,000 one-time general fund money. They do have some capacity in BBB Recreation and could use those dollars to fund that, and put the $25,000 for something else.

He said that the other thing is the Community Housing Assistance Program (CHAP). They were able to find $200,000 in the repaid CHAP loans, which is the purpose of those loans. Vice Mayor Whelan said that her concern about taking the CHAP money from CHAP is that it would be her hope to grow that program and she would much rather see new money come into that program.

With regard to health insurance subsidy, Mr. Copley said that he offered to draw down the $650,000 over two years rather than three and they could increase the subsidy for families. He said that they will have to reconsider how they will further address that in the future, as premiums will go nowhere but up. Majority of Council was in favor of that plan.

Mr. Copley said that many of the things are big dollars and there are not big dollars available. If Council wanted to have a discussion about the Fund Balance Policy, possibly reducing it from 20% to 19% it would free up about half a million dollars in the General Fund. The caution is that it is a rainy day fund and there are impacts with the bond ratings. They have had discussions about cuts in service. If there were to be additional programs, they have to consider cutting other programs.

Vice Mayor Whelan asked when the City went to the 20% policy. Mr. Tadder said that during the recession they dropped to 12% and their policy was 15%. It took them a long time to recover that and then go higher. They have been holding at 20% since 2015 or 2016. He said that it was a fiscal policy. There was no recession built into their five-year plan. After further discussion a majority of Council was not interested in reducing the Fund Balance.

After brief discussion, it was suggested that they start at the top of the list and move down.

FACTS
Majority supported using BBB allocation of $25,000

AFFORDABLE HOUSING
Majority supported moving forward with amount included in proposed budget. With regard to CHAP, majority supported using the funds from previous revolving, redevelopment and proforma planning and put it toward this goal.

SOCIAL JUSTICE AND HOMELESSNESS
Take the $25,000 freed up from FACTS and offer it up to receive ideas on how to advance this goal.

AQUAPLEX
Staff was directed to move this item out of facilities into climate change.

CLIMATE ACTION PLAN
Majority agreed to the $62,000 budgeted

WINDBLOWN LITTER
Majority supported leaving it as is.

EMPLOYEE PARKING
Majority supported leaving it as is.

HEALTH INSURANCE SUBSIDY
Majority supported a two-year draw down.

MAYOR TRAVEL BUDGET
Staff will research further and provide information to Council.

CLEAN TEAM AMBASSADORS
Staff will look into this further.

COMMUNITY BREAKFAST
Staff will look at different ideas and possibly broaden the title.
             
6. 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 this 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
             
7. Informational Items and Reports from Council and Staff, Future Agenda Item Requests

None
             
8. Adjournment
  After final comments were made by Council and staff, the Budget Retreat of April 27, 2017, adjourned at 2:42 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 13-Apr-24 08:07 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
156 ms 156 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
109 ms 109 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
109 ms 109 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
156 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:07:52.052
			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:07:52.052
				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:07:52.052
			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:07:52.052
				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:07:52.052
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 08:07:52.052
	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:07:52.052
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:07:52.052
		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:07:52.052
	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:07:52.052
		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:07:52.052
	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:07:52.052
	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:07:52.052
		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:07:52.052
		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:07:52.052
	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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:07:52.052
	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:07:52.052
	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:07:52.052
	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:07:52.052
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:07:52.052
	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:07:52.052
	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:07:52.052
	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=10) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 08:07:52.052
		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) = 2017-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2017-04-30 00:00:00.0

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

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
			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(577 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:07:52.052
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 576 
getAllMnLines (Datasource=frsRO, Time=15ms, Records=14) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
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 = 576 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 = 251 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=12) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
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:07:52.052
	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:07:52.052
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=20) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
		
	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 = 251 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 251 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=4) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
		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 = 251 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=28) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
		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 = 251 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1							
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6127 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6127 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4669 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6126 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6126 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4670 
get_Minutes (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6138 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6138 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4671 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4672 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4673 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6128 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6128 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6134 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6134 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6130 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6130 
SortedList (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4625 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			    	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 = 1578 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 6130 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 6130 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4626 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6131 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6131 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4627 
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			    	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 = 1579 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 6131 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 6131 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6132 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6132 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			    	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 = 1580 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 6132 AND
					      motion_seq = 2 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 6132 AND
							  allVotes.motion_seq = 2 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6133 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6133 
SortedList (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMotions (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			    	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 = 1581 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
	 				SELECT *
					FROM getmotions
					WHERE ln_rowid = 6133 AND
					      motion_seq = 1 
getVotes (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM allVotes
						WHERE allVotes.ln_rowid = 6133 AND
							  allVotes.motion_seq = 1 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 08:07:52.052
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4676 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6135 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6135 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6136 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6136 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 6137 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
				SELECT * FROM allMotions
				WHERE allMotions.ln_rowid = 6137 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 08:07:52.052
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 4677 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 08:07:52.052
	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:07:52.052
	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:07:52.052
		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:07:52.052
		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=4&get_year=2017&dsp=min&min=577&ln=6131
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=4&get_year=2017&dsp=min&min=577&ln=6131
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=8991403
cftoken=bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
hitcount=4
lastvisit={ts '2024-04-13 08:07:52'}
timecreated={ts '2024-04-13 08:07:52'}
urltoken=CFID=8991403&CFTOKEN=bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
Cookie Variables:
CFID=8991403
CFTOKEN=bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=577
Session Variables:
cfid=8991403
cftoken=bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_8991403_bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
subdir=/public/
tzoffset=0
urltoken=CFID=8991403&CFTOKEN=bbc1957b085ef45e-6FE1178B-040C-30E1-F27C281DF673E401
URL Parameters:
dsp=min
get_month=4
get_year=2017
id=
ln=6131
min=577
mt=ALL
Debug Rendering Time: 0 ms