Minutes

             
F Consideration and Adoption of Resolution No. 2023-20 and Ordinance No. 2023-12:  A Resolution of the City of Flagstaff, Coconino County, Arizona, declaring as a public record that certain document filed with the City Clerk entitled "NAH Health Village Phase 1 Specific Plan" and an Ordinance of the City Council of the City of Flagstaff, Coconino County adopting the NAH Health Village Phase 1 Specific Plan to guide the development of 172.62 acre of real property and to provided specific development requirements for 93.39 acres generally located at 1120 W Purple Sage Trail.         
 
  Zoning Code Manager Tiffany Antol provided a PowerPoint presentation that covered the following:
 
   
NAH HEALTH VILLAGE, SPECIFIC PLAN, CONCEPT ZONING MAP AMENDMENT AND DEVELOPMENT AGREEMENT
NAH HEALTH VILLAGE
DEVELOPMENT AGREEMENT
OVERVIEW
SITE PLAN REVIEW
OPEN SPACE & CIVIC SPACE
RESIDENTIAL DENSITY
SUSTAINABILITY
PRIVATE SHUTTLE SERVICE
FIRE PROTECTION
LEGACY CAMPUS
OUTDOOR LIGHTING
WATER AND SEWER IMPROVEMENTS
ON-SITE TRANSPORTATION IMPROVEMENTS
OFF-SITE TRANSPORTATION IMPROVEMENTS
RECOMMENDATION
 
Mr. Clifton addressed Council to comment on an allegation that the recent Council Washington D.C. trip was done solely for the purpose of advocating for the NAH relocation and associated funding. He stated that the allegation was not true. He explained that trips to Washington D.C. to meet with the city’s delegation are done on an annual basis and have been for many years. The purpose of the trips were to build relationships between elected officials at the local and federal levels; they were also a means by which the city pursued programmatic funding, grant funding, direct appropriations, and funding support. The city had enjoyed a strong track record of receiving funding support that materialized from those trips. Recently, the relationships with congressional delegates had resulted in support, allocation of land resources, and funding for flood mitigation efforts, along with a $56 million allocation toward the Rio de Flag project.
 
Mr. Clifton reviewed the materials presented to representatives during the trip and explained that there was a brief mention of a direct spending request associated with the RAISE grant application that included NAH as a co-applicant and the matching funds that they would be providing should the grant be awarded to the city. He went on to explain that it was not unusual for the city to partner with private entities, developers, nonprofits, service organizations, and other government agencies on grant pursuits. He clarified that there were many needs within the public safety utility and a new fire station in the area of the NAH development was one of them. The current station was undersized and not able to accommodate the newly acquired ladder truck or the necessary staff to man the truck. A new station was needed to provide the necessary public safety services to the area and that need would exist with or without the NAH development; the relocation had just advanced the timeline.
 
Councilmember Matthews asked who was responsible for funding the improvements if the grant was not awarded. Ms. Antol explained that the financial responsibility fell entirely to NAH.
 
NAH Vice President of Real Estate and Construction Steve Eiss, along with Guillermo Cortes from Shepard-Wesnitzer Inc., and Tim Kinney from Kinney Construction Services Inc. continued the presentation.
 
NORTHERN ARIZONA HEALTHCARE HEALTH AND WELLNESS VILLAGE
A POTENTIAL I-17 UNDERPASS
HISTORY OF THE I-17 CROSSING
CONCEPTUAL TRAFFIC CONTROL PLAN
CONCEPTUAL TRAFFIC CONTROL PLAN PHASE 1
CONCEPTUAL TRAFFIC CONTROL PLAN PHASE 2
CONCEPTUAL TRAFFIC CONTROL PLAN PHASE 3
THE CHALLENGE IS CONSTRUCTING THE ACTUAL UNDERPASS
NAH’S SUSTAINABILITY EFFORTS
 
Councilmember McCarthy suggested the following two edits to the development agreement:
 
4.4.4 Electric Vehicle Charging – REVISED WORDING (added words in italics and caps):
“upon surpassing 80% utilization of existing charging stations DURING PEAK HOURS OF OPERATION, NAH shall install additional electric vehicle charging stations sufficient to serve another 20 electric vehicles at a time.”
 
4.4.5 Green Connect Program – REVISED WORDING (added words in italics and caps):
“NAH shall join the APS Green Connect Partner Program prior to receiving the first certificate of occupancy for the Project. TO THE EXTENT THAT ELECTRICAL POWER IS AVAILABLE FROM APS THROUGH THE PROGRAM, THE PROJECT SHALL USE POWER FROM THE PROGRAM OR FROM RENEWABLE ENERGY PRODUCED ON-SITE.”

Mr. Eiss stated that he had no problem with the first suggested amendment. Regarding the second, he stated that he was not sure if that was how the program worked currently through APS. They had committed to signing the same agreement that the City of Flagstaff had signed. Councilmember McCarthy stated that there needed to be some teeth put into that requirement.
 
Councilmember Matthews asked about their experience with building efficient buildings. Mr. Kinney stated that he was one of the first LEED-accredited developers in Northern Arizona over 20 years ago and had built several Green Sustainable buildings, eight of which were certified LEED Platinum. Councilmember Matthews asked Mr. Kinney’s opinion on the project and the amendments that were added. Mr. Kinney stated that the LEED Silver was an excellent place to be, and while the Gold Standard was a reach, they would be able to achieve it without the certifications.
 
Councilmember Sweet asked about the challenges associated with going from a Silver Standard to a Gold Standard in Flagstaff. Mr. Kinney stated that the elevation was a challenge; Flagstaff has four distinct seasons and 40-degree temperature swings which could compromise mechanical equipment. They had been able to meet the Gold Standard with redundancies in place that had been well-designed to be efficient. Mr. Kinney noted that the Gold Standard had a wide range of points associated with it and they would probably be in the middle range of that. Going to Platinum would be another 20 to 40 points and would require an extensive redesign of the mechanical systems. They would have to get into more renewable energy which the site was not suited for because there were a lot of trees. Another significant challenge was accessibility to materials; the things that would have to be done to reach the Platinum Standard would be very costly and would require significant maintenance ongoing.
 
Councilmember Matthews stated that she had concerns with Councilmember McCarthy’s proposed amendment that required the hospital to use clean energy because it may not be available.
 
Mayor Daggett thanked NAH for their commitment to provide all the data requested to calculate the carbon footprint. She stated that the information would allow the city to identify how to address the rest of the Carbon Neutrality Plan.
 
SUSTAINABILITY RECAP
CLARIFICATIONS FOR THE PUBLIC RECORD
FORMAL ASK OF CITY COUNCIL
 
Mayor Daggett asked staff to comment on the proposal regarding Purple Sage. City Engineer Paul Mood explained that it was difficult to respond to the proposed traffic control because it was the first time that staff had seen it. There would be other utilities in the roads such as water, fiber optics, and gas that would have to be considered. Staff’s recommendation remained that the Purple Sage intersection be built to the elevation needed for a future underpass. Should Council like to amend that condition, staff recommended that the development agreement include the requirement that plans be submitted for both the interim condition and the final condition with the lower elevation that would include all demolition and temporary measures needed to do that construction prior to recording the final plat. That would allow staff to know what type of easements and other things would be needed in the future. Staff also recommended that some type of financial assurance be provided for future work.
 
Council inquired about the future need for the underpass. Mr. Mood explained that the underpass was showing in the Regional Plan so staff must assume that it would be built in the future when reviewing projects. Development in the area had not happened yet so the underpass had not been included in the city’s five-year plans.
 
A break was held from 5:22 p.m. through 5:35 p.m.
 
The following individuals spoke in opposition of the NAH relocation project:
  • Patricia Ellsworth
  • Karen Enyedy
  • Michele James
  • David Spence
  • Stefan Sommer
The following comments were received:
  • The Northern Arizona Climate Change Alliance would have liked to have been involved in the conversation earlier.
  • The development agreement should include the requirement for LEED Gold certification.
  • Council should require staff to develop a plan for deep study and analysis.
  • Technology is changing medical infrastructure needs and the infrastructure being envisioned now may not actually be needed.
  • There needs to be an assessment of community health needs with careful attention to lower-income households.
  • There is no way to determine an alternative plan without a study of the existing infrastructure and possible acquisition of available properties.
  • There needs to be full disclosure of both known and potential costs of the project.
  • More information is needed, and more time is needed to gather that information.
  • Council should refer the matter to the voters.
  • The draft development agreement does not adequately outline the expenses the city is responsible for.
  • The development agreement should require a public process before any proposed changes are made to the infrastructure improvement agreements related to the fiscal responsibility of NAH.
  • At what level will NAH join the APS Green Connect Partner program, and how long will the agreement last?
  • The Council should postpone the final reading of 2023-11 to allow time to receive and analyze the carbon footprint data.
  • There should be an analysis of what a typical hospital stay costs at the current location in comparison to the cost at the new facility.
  • Renovating the existing facility can achieve many of the same goals they have outlined for the new facility.
  • The public deserves to know the projected costs for the existing and future locations.
The following individuals submitted written comments in opposition to the NAH relocation project:
  • Kyle Nitschke
  • Alex James Russell
  • Christine Schimanski
  • James Snyder
The following individuals spoke in favor of the NAH relocation project:
  • Joe Galli
  • Whitney Cunningham
The following comments were received:
  • The Greater Flagstaff Chamber of Commerce supports the rezone and the development agreement because of the economic impacts that will come to the community as the facility is constructed and completed.
  • New healthcare industry jobs will be created.
  • Local contractors are being used for construction and they have impeccable reputations.
  • There are over $100 million in tax revenues that will collectively be generated for local municipalities.
  • Construction jobs will benefit retailers, hoteliers, and restaurants.
  • Please continue to support the development and advance the rezone and development agreement.
  • There have been generational investments in Flagstaff; in the 80’s W.L. Gore expanded their facilities by several hundred square feet, NAU expanded significantly in the 60’s, downtown business owners taxed themselves to grow and expand the downtown, and forty years ago, NAH was formed building on a facility that began in 1936.
  • Continue the investment in leadership and vision.
  • NAH is making a $50 million investment in roads and a $5 million investment in fire facilities.
  • NAH is going to build a park bigger than Foxglenn and reduce energy consumption by 50% and fossil fuel usage by 75%. None of those benefits will be realized if the project does not move forward.
  • The project is a generational investment and it should be supported.
Phillip Williams submitted a written comment in support of the NAH relocation project.
 
Senior Assistant City Attorney Christina Rubalcava provided a review of the recommendations for the development agreement:
 
  1. Modify section 4.12.1 and 4.12.2 to reference the northern face of the patient towers rather than the western face.
  2. Modify section 4.4.4 add Utilization shall be measured during regular hours of operation for the ACC as the last sentence.
  3. Modify section 4.4.5 modify as follows:
    1. NAH shall join the APS Green Connect Partner Program for 100 percent of electric power used on-site for the term of this Agreement. Copies of the contract approved by the Arizona Corporation Commission for this program shall be provided to the City prior to receiving the first certificate of occupancy for the Project. In the event that the APS Green Connect Partner Program is terminated or NAH desires to participate in an alternate program, NAH shall be permitted to participate in a substantially equivalent program upon the written approval of the City Manager and in the sole and absolute discretion of the City Manager.
  4. Add section 4.4.7 Within 8 weeks from the date of execution of this Agreement, NAH shall provide the City with the calculated carbon footprint of the hospital and ACC, and shall also provide the underlying data used by NAH to calculate that carbon footprint.
  5. Add section 4.4.8 NAH shall design the hospital and ACC to meet credit guidance for LEED Gold Standards, but is not required to obtain official LEED certification.
 
Councilmember Matthews offered comments about the underpass and suggested that NAH be required to provide engineering plans for the current state and plans for after Beulah was widened and put a 20% financial assurance bond with a sunset of ten years.
 
Councilmember Sweet asked about the APS Green Connect Partner program and if the development agreement would allow NAH to move away from that program should the city find a better program. Ms. Rubalcava stated that the language could be updated to add “unless a substantially equivalent program is approved by the city.”
 
Councilmember Harris expressed frustration about people within the community trying to stop a project that would help other members of the community. She was concerned that the personal agenda of some has been put ahead of the health and safety of everyone else and future generations. The community was growing, and it would continue to grow. The community needed to come together and compromise to do what was best for everyone. She expressed her support for moving the project forward.
 
Councilmember McCarthy stated that he had studied the case in great detail and that he had met with many people on all sides of the issue, read numerous emails, and attended the Planning and Zoning Commission meetings. Many members of the public believed that the city was heavily subsidizing the development. However, based on the actual development agreement, NAH would be responsible for funding the infrastructure, including water and sewer systems, as well as road improvements. The city was assisting NAH in applying for federal road improvement grants, but if the grants were not awarded, NAH would be responsible for covering the costs. He stated that misinformation had circulated on social media that suggested the city would cover the transportation grant match, but NAH was responsible for that. He also stated that a new fire station was required regardless of the hospital's approval, as the current one was inadequate for the new equipment ordered and paid for by the city. The cost of the fire station would be shared equally between the city and NAH.
 
Councilmember McCarthy noted that the hospital itself would not pay property taxes because it was a nonprofit entity. However, the city would receive income from construction taxes and construction impact fees from all aspects of the project. Although carbon neutrality was not a requirement for other projects and was not mandated by city code, there was an understanding of the importance of moving towards carbon neutrality. While the new hospital may not achieve LEED Platinum certification, it had agreed to meet the standards of LEED Gold. NAH had also agreed to solar installations on at least 40% of the parking garage roof within 18 months after receiving their Certificate of Occupancy. He also mentioned bus service, noting that while it would be valuable, the city did not require subsidized bus service for other developments. NAH would provide a free shuttle or taxi service for those who needed transportation.
 
Councilmember House stated that part of her consideration had been the broader vision for sustainable, responsible, and holistic development for Flagstaff’s future. Flagstaff was growing and would continue to grow. She believed that the findings had been met. That did not dismiss the other aspects of the development and it was important to keep constantly engaged in the plans for the existing campus. She would like for the city to engage in a visioning process about future plans for the existing campus. There was a need to make brave decisions when it came to the development of Flagstaff, there had been a hesitation to do that in the past and there was fear in the community about what growth meant. Tough conversations must be had and difficult decisions must be made to grow responsibly.
 
Councilmember Sweet offered that there had been a lot of discussion and listening to all sides of the project and the e decisions were not easy. The project affected many people in the community and those who used the medical system. There were still questions and concerns, but she believed that the findings had been met to move the project forward. She looked forward to engaging on the plans for the legacy campus.
 
Councilmember Matthews stated that she believed that the process had been very open and transparent. So many of the questions being asked and concerns being raised had all been addressed in prior meetings. If people were to go back and watch the presentations over the last couple of years, most of their questions would be answered. At that point, suggesting that things are moving too fast and should slow down was just another delay tactic. She expressed concern that the messages out in the public were not factual and that much of the outrage that was on social media was based on false information. She acknowledged the concerns and complaints about how employees were treated and how business was conducted but those were not within the purview of the City Council. The role of the City Council was to determine if the findings could be met. She appreciated the conditions that were discussed, and she would like to revisit the Purple Sage underpass discussion soon.
 
Mayor Daggett offered appreciation to staff for their part in the process. It had been a long and stressful road for them, and she appreciated the dedication they have shown. She thanked those who came to the table and collaborated on the various conditions and requirements of the development agreement. Collaboration was critical, not just for that project, but moving forward as Flagstaff continued to grow. What was important was that information was factual; she encouraged the public to verify the information that they were presented with. She stated that Council would be discussing the site plan soon; it would be presented to the Council and public at an upcoming meeting. She also noted that the process had demonstrated the need to update codes to meet the community housing and climate goals. Lastly, she thanked the public for their involvement and participation in the public process; public input had led to a lot of important changes and clarifications.
 
  Moved by Councilmember Lori Matthews, seconded by Councilmember Deborah Harris to adopt Resolution No. 2023-20.
  Vote: 6 - 0 - Unanimously
  Moved by Councilmember Lori Matthews, seconded by Councilmember Deborah Harris to read Ordinance No. 2023-12 by title only for the final time.
  Vote: 6 - 0 - Unanimously
  AN ORDINANCE OF THE CITY COUNCIL OF THE CITY OF FLAGSTAFF, ADOPTING A SPECIFIC PLAN, BY ADOPTING BY REFERENCE THAT CERTAIN DOCUMENT ENTITLED “THE NAH HEALTH VILLAGE PHASE 1 SPECIFIC PLAN” TO GUIDE THE DEVELOPMENT OF 172.62 ACRES OF REAL PROPERTY AND TO PROVIDE SPECIFIC DEVELOPMENT REQUIREMENTS FOR 98.39 ACRES GENERALLY LOCATED AT 1120 W PURPLE SAGE TRAIL PROVIDING FOR SEVERABILITY, AUTHORITY FOR CLERICAL CORRECTIONS, AND ESTABLISHING AN EFFECTIVE DATE
 
  Moved by Councilmember Lori Matthews, seconded by Councilmember Miranda Sweet to adopt Ordinance No. 2023-12.
  Vote: 6 - 0 - Unanimously


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_minutes_popup.cfm
Time Stamp 06-May-24 05:43 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
156 ms 156 ms 1 top level D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 16 ms 1 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/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/include_min_print.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
172 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 @ 17:43:55.055
			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:43:55.055
				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'
			
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:43:55.055
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
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.final_stop fas_final_stop,
	   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id,
	   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo, mt.meeting_type,
	   cv.misc_alpha vote_indent, cr.misc_alpha roll_indent,
	   am.long_descr vote_label, am.misc_alpha motion_verbiage
FROM fas
INNER JOIN MINUTES AS ft ON (ft.form_num = fas.form_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 cv ON (cv.code_type = 'AG_FONT' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_FONT' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
WHERE UPPER(fas.form_id) = 'MINUTES' AND
			fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 956

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:43:55.055
		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) = 3780

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:43:55.055
			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(3780 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\print_minutes_popup.cfm @ 17:43:55.055
	SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 956

getLines (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
SELECT ml._rowid _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.page_br,
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   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_action ELSE ml.ag_action END as ag_action,
	   CASE WHEN ml.ainumber IS NOT NULL THEN ml.ainumber ELSE am.ainumber END as ainumber,
	   c.descr as status_desc,
	   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box2_label, ai.box2_disp, ai.box3_label, ai.box3_disp, ai.box4_label,
	   ai.box4_disp, ai.box5_label, ai.box5_disp, ai.box6_label, ai.box6_disp, ai.box7_label, ai.box7_disp,
	   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_underline, ai.lbl_size,
	   ai._rowid as ag_item_rowid
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 = 3779 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 = ? AND
	  ml._rowid = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 956
Parameter #2(cf_sql_integer) = 20202

getMinutes (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
	SELECT meet_minutes, ln_rowid, seq_num, time_of_vote, _rowid,
			text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 956 AND
		  rev_num = 0 AND
		  ln_rowid = 20202 AND
		  meet_minutes IS NOT NULL
getMotions (Datasource=frsRO, Time=31ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
	SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text, motion.time_of_vote,
		   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
		   motion.motion_status status_desc, motion._rowid, motion.seq_num, 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.form_num = 956 AND
		  motion.rev_num = 0 AND
		  motion.ln_rowid = 20202 AND
		  motion.motion_status <> 'VERBIAGE'
	ORDER BY motion.motion_seq
getVotes (Datasource=frsRO, Time=16ms, Records=18) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
	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,
		   v.seq_num sort1, motion.time_of_vote, m.meeting_id,
		   c3.long_descr vote_label,
		   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)
	INNER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote AND c2.misc_alpha3 = 'Y')
	LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND c3.valid_code = CAST(m.meeting_id AS varchar))
	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 minutes_ln_motion motion ON
			(motion.form_num = v.form_num AND
		 	 motion.rev_num = v.rev_num AND
		 	 motion.ln_rowid = v.ln_rowid AND
		 	 motion.motion_seq = v.motion_seq)
	WHERE v.form_num = 956 AND
		  v.rev_num = 0 ANd
		  v.ln_rowid = 20202 
	ORDER BY sort2, sort1						
	
SortedList (Datasource=, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\include_min_print.cfm @ 17:43:55.055
	SELECT * from sortList
	ORDER BY seqNum
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 13555 
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 13696 
getMotion (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
				    	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,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, 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 = 4351 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 20202 AND
						      motion_seq = 3 
getMotionVote (Datasource=, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:55.055
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 20202 AND
							  getVotes.motion_seq = 3 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:43:55.055
	
		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 @ 17:43:55.055
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMotion (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
				    	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,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, 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 = 4352 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 20202 AND
						      motion_seq = 4 
getMotionVote (Datasource=, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 20202 AND
							  getVotes.motion_seq = 4 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:43:56.056
	
		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 @ 17:43:56.056
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 12831 
getMotion (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
				    	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,
							   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,	
				        	   motion.motion_status status_desc, 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 = 4353 
motionRow (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
						SELECT motionName, motionTitle, secondName, secondTitle, motion_text,
								time_of_vote, disp_after_motion
						FROM getMotion
						WHERE ln_rowid = 20202 AND
						      motion_seq = 6 
getMotionVote (Datasource=, Time=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\print_minutes_popup.cfm @ 17:43:56.056
						SELECT valid_code, vote, name, title, vote_type, vote_descr, vote_label
						FROM getVotes
						WHERE getVotes.ln_rowid = 20202 AND
							  getVotes.motion_seq = 6 
fPrintVoteGetLabels (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:43:56.056
	
		SELECT descr, long_descr vote_type, misc_alpha, misc_alpha2
		FROM codes
		WHERE code_type = 'AG_VOTEOTHER' AND misc_alpha3 = 'Y' AND obsolete = 'N'
		ORDER BY dataSortOrder
	
fPrintVoteApprovalQry (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 17:43:56.056
				SELECT descr, misc_alpha, misc_alpha2, misc_alpha4
				FROM codes
				WHERE code_type = 'AG_VOTEOTHER' AND long_descr = 'Y' 


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\print_minutes_popup.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/print_minutes_popup.cfm?seq=956&ln=20202&reloaded=false
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\print_minutes_popup.cfm
QUERY_STRING=seq=956&ln=20202&reloaded=false
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_minutes_popup.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=9567214
cftoken=4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
hitcount=2
lastvisit={ts '2024-05-06 17:43:55'}
timecreated={ts '2024-05-06 17:43:55'}
urltoken=CFID=9567214&CFTOKEN=4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
Cookie Variables:
CFID=9567214
CFTOKEN=4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
Session Variables:
cfid=9567214
cftoken=4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9567214_4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
subdir=/public/
tzoffset=0
urltoken=CFID=9567214&CFTOKEN=4bee99ccb14ac238-24DB6086-EFCB-B1C7-B13AD45253FF9759
URL Parameters:
ln=20202
reloaded=false
seq=956
Debug Rendering Time: 0 ms