City Council Meeting - FINAL


Print Agenda Item PDF Return to the Search Page Return to the Agenda Copy Staff Summary Report
  11.A.       
Meeting Date: 03/05/2019  
From: Christine Cameron, Project Manager III

Information
TITLE:
Consideration and Approval of Contract:  City Court Facility Project - Award of Amendment #1 to the Design-Build Services Agreement #2018-63. This amendment contains the Guaranteed Maximum Price (GMP) #1 agreement for preliminary construction work.
STAFF RECOMMENDED ACTION:
1)  Award the Design-Build Services Amendment GMP #1 to Kinney Construction Services, Inc. of Flagstaff Arizona in an amount not to exceed $1,518,175.00 with a 148 calendar-day contract period; and 
2) Authorize the City Manager to execute the necessary documents.
Executive Summary:
Kinney Construction Services, Inc. (KCS) was selected by a five-member evaluation committee as the most qualified service provider for the City Court Facility Project pursuant to the evaluation and ranking process per A.R.S. 34-603.

City Council awarded the original Design-Build Agreement #2018-63 on July 3, 2018, for design phase services. KCS and the Architect (CGL Companies) have been working over the last seven months on programming the building space and developing construction plans with Courts Administration, the City Prosecutor's Office, Flagstaff Police Department, City Manager's Office, and City Planning.  In order to expedite site construction, GMP #1 is being submitted for award first while the full construction documents are being finalized. This will allow for hazardous materials abatement and demolition of the existing buildings at 101 W. Cherry and 15 N. Beaver and site work (grading, underground utility installation) at the 101 W. Cherry site. The proposed future GMP #2 Amendment will contain the remainder of the work for full construction of the facility and sites.
Financial Impact:
The City Court Facility is currently budgeted in the amount of $17,408,403.00 for FY19 and is anticipated to be budgeted in the amount of $4,009,024.00 for FY20. Project funding is in the General Government Fund, Account Number 408-09-426-3278-1.
 
Policy Impact:
Award of the Design-Build Services Amendment GMP #1 will allow KCS to proceed with building abatement, demolition, and site preparation necessary for the construction of the new facility as approved by Proposition 412 in the November 2016 ballot question.
Connection to Council Goal, Regional Plan and/or Team Flagstaff Strategic Plan:
Council Goal: Transportation and Other Pubic Infrastructure.
Deliver quality community assets and continue to advocate and implement a highly performing multi-modal transportation system.

Flagstaff Regional Plan 2030: Locating Facilities Goals and Policies.
Goal PF.2. - Provide sustainable and equitable public facilities, services and infrastructure systems in an efficient and effective manner to serve all population areas and demographics.
 
Team Flagstaff Strategic Plan: Foster a Resilient and Economically Prosperous City.
Deliver outstanding service through a healthy environment, resources and infrastructure.
Has There Been Previous Council Decision on This:
On June 14, 2016, Council reviewed options for the City Court Facility bond project and directed staff to prepare ballot language for a $12M bond project to be funded through secondary property tax.

On July 3, 2018, City Council awarded the Design-Build Contract #2018-63 to KCS for design phase services of the project.
Options and Alternatives:
1.  Approve the Design-Build Services Amendment GMP #1 to KCS as presented.
2.  Reject the Design-Build Services Amendment GMP #1 and direct staff to re-negotiate the terms and fee structure with KCS.
 
Background and History:
The physical condition of the existing City Court building located at 15 North Beaver Street has deteriorated to a point where significant financial resources would be needed to remediate, remodel and stabilize the structure. In addition, the need exists for current and future space to ensure continued operational viability.
 
On July 5, 2016, staff came before Council with the Consideration and Adoption of Resolution No. 2016-27.  This Resolution allowed Council to adopt an official ballot question to be submitted to qualified electors of the City of Flagstaff.  This ballot question asked the citizens of Flagstaff to approve a temporary increase in the City’s secondary property tax and authorize the sale and issuance of bonds for purposes of constructing a new City Court Facility.  Council adopted the Resolution and the question was placed on the ballot for the election of November 8, 2016. The ballot question was approved.
 
On April 1, 2018, the City advertised a Request for Statement of Qualifications from Arizona Registered Contractors for the qualification-based selection of a Design-Build team to provide design and construction services for the City Court Facility.
 
On April 23, 2018, the City received eight responses to the Request for Statements of Qualifications.  A five-person committee was formed to evaluate the Statements of Qualifications and the committee selected 3 firms for interviews.  Upon the completion of the interviews, the committee selected KCS as most qualified Design-Builder to perform the work.

On July 3, 2018, City Council awarded the Design-Build contract to KCS for design phase services. Over the last seven months the Design-Build team has been working on programming the building space and developing construction plans with Courts Administration, the City Prosecutor's Office, Flagstaff Police Department, City Manager's Office, and City Planning.
Key Considerations:
The new City Court Facility will be located on property owned by the City located at 101 W. Cherry Avenue.  The existing buildings at this location are occupied by various City staff (Building and Safety, Risk Management, Sustainability, I.T. Lab, Environmental Inspection).  The Space Planning Committee has developed a strategy and timeline to relocate City staff from the existing building ahead of the planned abatement and demolition.

To meet City of Flagstaff Zoning Code-Title 10, parking capacity requirements, the existing City Court located at 15 N. Beaver Street and the City Prosecutor’s Offices located at 107 W. Aspen Avenue will need to be demolished.  The new City Court Facility will also be designed to provide parking.  The combined parking at these two parcels will meet the Zoning Code requirements for parking capacity.

The GMP #1 scope also includes the fee for abatement and demolition of the existing City Courts building and City Prosecutor's buildings. This work will not occur until the new facility is complete and staff is relocated in the spring of 2020.
 
 
Community Benefits and Considerations:
Total project funding for the project is as follows:
 
Prop 412 Voter Approved Courts Project Funding
 
Bonds                                                      $12,000,000
Sale of Beaver Lot                                    $ 2,000,000
**Identified Funding (Courts Fees)           $ 7,500,000
Total                                                        $21,500,000
                       
**Identified Funding                                                
Court Fees                                              $2,080,000
Sale of Fire Station #1                            $   520,000
Re-development Fund                            $   500,000
Capital Funding Transfer                        $   400,000
Capital Financing                                    $4,000,000
Total                                                        $7,500,000

The sale of the Beaver Street lot will not be included in the budget for this Project as this parcel will need to be used for surface parking in order to meet the City's Zoning Code requirement for parking capacity.  The total project budget for the delivery of a new City Court Facility is $19.5M.

 
Community Involvement:
The new City Court Facility will provide a safe and efficient Municipal building that will greatly improve the Court's operations now and into the future, enhance the staff and user experience, and provide an attractive amenity to downtown Flagstaff.
Expanded Options and Alternatives:
There have been multiple Council meetings to discuss the City Court Facility over the course of the last three years, in addition to, multiple public meetings prior to the ballot question of 2016.
 
A Public Meeting was held on February 20, 2019 to present the project design and engage the public on the project.
Attachments
Full Courts GMP 1
Original Courts DB contract
Courts Context Map
Courts Vicinity Map
Presentation


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/histLink_agmemo.cfm
Time Stamp 25-Apr-24 05:24 PM
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
188 ms 188 ms 1 top level D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
141 ms 141 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/Application.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/agpub_client_defines.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
0 ms 0 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(3922, 1, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.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/include_set_fonts.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_ud.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/styles/header_styles.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=62ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:24:45.045
			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 @ 17:24:45.045
				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'
			
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	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
			,c4.large_misc_alpha customPage
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
	left outer join codes as c4 ON (c4.code_type = 'EXTCUST')
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup2'
UserAttr (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
		SELECT ' ' dflt_conf, 'N' super_user, ' ' dflt_grp FROM websecur WHERE websecur.login_id = 'destiny'
	
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
		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
	
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT user_filedir_alias, confidential_dir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:24:45.045
			select top 1 * from codes
		
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT text_value1, misc_alpha public_window from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
chkMeetings (Datasource=frsRO, Time=16ms, Records=1698) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT 1 meeting_dt from meetings WHERE
	meetings.the_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')
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE (form_id = 'AGENDA' OR form_id = 'MINUTES') AND final_apprvl = 'Y'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT MAX(fis_yr) fis_yr FROM fas
	WHERE (form_id = 'AGENDA' OR form_id = 'MINUTES') AND final_apprvl = 'Y'

finalized_meeting (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
		SELECT MAX(meeting_dt) last_meeting FROM meetings
		INNER JOIN agenda ON (agenda.meeting_id = meetings.meeting_id)
		INNER JOIN fas ON (fas.form_id = 'AGENDA' AND fas.form_num = agenda.form_num  AND fas.final_apprvl = 'Y')
	
fas_menu (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT menu_label FROM fas_menu WHERE web_page = '../publish/agenda_publish.cfm'
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
	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)
	
chk_aiDisplay (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:24:45.045
		select case when ss_agi._rowid is null then agi.display_routine else ss_agi.display_routine end as display_routine
		from ag_memo am
		inner join agenda_ln as atl on (atl.ag_memo_id = am.form_num and atl.ag_memo_rev = am.rev_num)
		inner join agenda as a on (a.form_num = atl.form_num)
		left outer join ag_item as agi on (agi._rowid = am.ag_item_rowid)
		left outer join ss_ag_item as ss_agi on (ss_agi.form_num = a.form_num and ss_agi._rowid = am.ag_item_rowid)
		where am.form_num = ?
		  and am.rev_num  = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3922
Parameter #2(cf_sql_integer) = 1

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:24:45.045
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 17:24:45.045
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, 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, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4,al.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold,
	 	   	 
	 	   		c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all,
	 	   	
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (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 AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3922
Parameter #2(cf_sql_integer) = 1

final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:24:45.045
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 838 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 17:24:45.045
 		SELECT valid_code, descr, long_descr from codes
 		WHERE code_type = 'AG_FONT'
 	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 17:24:45.045
 		SELECT long_descr from getFonts
 		WHERE valid_code = 'mediumText'
 	
getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 17:24:45.045
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 839 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=21) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 839 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 838 AND agi._rowid = 78)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 839 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 78 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 78)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '78')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi3')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '78'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 3922 AND
				      u.rev_num = 1 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi3'
			
fi3q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi3' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2019-03-05

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'ccameron'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 3922 AND
      rev_num = 1
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 3922 AND ag_memo_dol.rev_num = 1
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 3922 AND
		  ad.rev_num = 1 
	ORDER BY sort_seq, ag_doc_id
min_attachments (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT * from codes where code_type ='asdfasdfasfa'
	
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 3922 AND
		      rev_num = 1
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 3922 AND form_rte.rev_num = 1 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 3922 AND
		  rev_num = 1 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=15ms, Records=9) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = 'AI78')
		LEFT OUTER JOIN websecur AS w ON (w.login_id = hist.action_by)
		LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
		WHERE UPPER(hist.form_id) = 'AG_MEMO' AND
			  hist.form_num = 3922 AND
			  hist.rev_num = 1 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:24:45.045
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:24:45.045
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 839

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:24:45.045
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
					   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
					   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
					   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 838 AND ai._rowid = 78)
				
				LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
				LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = al.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(al.ag_level1 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = al.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(al.ag_level2 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = al.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(al.ag_level3 AS binary(8)))
				LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = al.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(al.ag_level4 AS binary(8)))
				LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'AddlMtg' and CAST(c2.valid_code AS INT) = a.meeting_id)
				LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'AG_FONT' and c3.valid_code = a.text_size)
				WHERE al._rowid = 19867 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:24:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 838
					AND a.ag_level1 = '13'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:24:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 838
					AND a.ag_level1 = '13'
					AND a.ag_level2 = 'A'
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel3 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:24:45.045
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 838
					AND a.ag_level1 = '13'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:24:45.045
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:24:45.045
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 3922 AND
					      rev_num = 1
					ORDER BY seq_num
				


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\public\publish\histLink_agmemo.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=//public/publish/histLink_agmemo.cfm?dsp=agm&fp=OFF&seq=3922&rev=1
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\public\publish\histLink_agmemo.cfm
QUERY_STRING=dsp=agm&fp=OFF&seq=3922&rev=1
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/histLink_agmemo.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=9287592
cftoken=c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
hitcount=2
lastvisit={ts '2024-04-25 17:24:45'}
timecreated={ts '2024-04-25 17:24:45'}
urltoken=CFID=9287592&CFTOKEN=c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
Cookie Variables:
CFID=9287592
CFTOKEN=c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
Form Fields:
DISPLAY_AG=0
DISPLAY_ID=3922
DISPLAY_REV=1
DSP=
Session Variables:
cfid=9287592
cftoken=c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9287592_c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
subdir=/public/
tzoffset=0
urltoken=CFID=9287592&CFTOKEN=c5378626ddea0abe-EDBAE132-A30C-BF0A-EDFAC631497587DB
URL Parameters:
dsp=agm
fp=OFF
rev=1
seq=3922
Debug Rendering Time: 0 ms