City Council Work Session


Return to the Search Page Return to the Agenda
  10.       
Meeting Date: 04/28/2015  
From: David Wessel, Metro Planning Org Manager

TITLE:
US 180 Winter Congestion Report
RECOMMENDED ACTION:
Discussion and possible direction
Executive Summary:
Traffic congestion on US 180 during peak winter activity is a historical problem with multi-hour delays for recreationists returning to town from snow play areas and the Arizona Snowbowl.  The traffic backup creates concerns for emergency vehicle access to the corridor and makes residents of the corridor feel trapped in their own homes.  The problem typically occurs on holiday weekends with good snow conditions and fresh snow.  Implementation of a traffic signal timing plan in 2011 resolved most of the traffic congestion that season and for the following two seasons.  This past holiday break saw the evening traffic congestion return and introduced a new phenomenon of morning congestion during both the Christmas and New Year's weekends.  The backup extended to I-17 creating potentially dangerous conditions.  This report describes those conditions and the status of the implementation strategies developed in the 2011 study developed by FMPO in cooperation with regional agencies and businesses.  Active pursuit of strategies may see some read for the 2015-2016 season.
Financial Impact:
Implementation of additional strategies will have a range of financial impacts:
  • Thousands of dollars for additional signs;
  • tens of thousands of dollars for new timing plans
  • tens of thousands of dollars for an AM radio broadcast; plus an annual maintenance or licensing fee
  • thousands of dollars to manage dual, southbound right turn lanes on Milton and millions of dollars to make permanent improvements
  • Tens of thousands of dollars for transit service plus considerable coordination efforts with vendors and concessionaires and/or millions of dollars to widen shoulders on US 180 for a transit bypass lane (and emergency vehicle access)
Connection to Council Goal and/or Regional Plan:
COUNCIL GOALS:
3) Provide sustainable and equitable public facilities, services, and infrastructure systems in an efficient and effective manner to serve all population areas and demographics

Winter recreation creates economic activity that, through tax collection, benefits the broader community.  The traffic impacts are disproportionately born by residents in the US 180 corridor.  That said, the impacts occur on 8-12 days per year.

5) Develop and implement guiding principles that address public safety service levels through appropriate staffing levels

With emergency service access potentially restricted by congestion, contingency plans should be in place.

6) Relieve traffic congestion throughout Flagstaff

The Milton corridor is the most congested in the City.  Between Butler and W. Route 66 it is over capacity during evening peak hours.  The congestion on US 180 is largely event related.  Both Milton and US 180 are under ADOT jurisdiction so cooperation and collaboration are critical.

8) Improve effectiveness of notification, communication, and engagement with residents, neighborhoods and businesses and about City services, programs, policies, projects and developments

Winter recreation and it positive and negative impacts warrant notice to and involvement of all in seeking resolution.

9) Foster relationships and maintain economic development commitment to partners

Winter recreation is a recognized part of the regional economy.  Working in concert with the business community to balance the benefits and impacts is important.

REGIONAL PLAN:
There are several goals promoting transportation safety and efficiency, regional cooperation and quality emergency services.
Previous Council Decision on This:
The City was an active part of the US 180 Winter Congestion Study in 2011 and the Council heard several reports on the study.  Alternative or dispersed snow play areas is an implementation strategy and previous councils have heard reports on locations in the city and region.
Options and Alternatives:
The Council may wish to direct City staff or request the FMPO to pursue further implementation strategies.  The following is a list of what has been done and what additional activities might take place:

Coordination: The Winter Activity Task Force did not meet prior to the holiday week.  A coordination meeting was held among member agencies public safety staff and Coconino County Public Works.

Traffic operations: The signal timing plan was in operation during the entire period.  It may be possible to improve it, extend the hours it operates, and develop a morning signal timing plan for the same days.  It may be possible to place a temporary signal at the US 180 / Snowbowl Road intersection to equitably distribute traffic between those two roads.

Traffic signing for alternate routes:  No additions to the existing alternate route signing were in place.  ADOT has developed new signs for additional locations and others were proposed in the 2011 Study.  They are fold-up signs to be displayed during critical periods.  For some visitors recreating north of Snowbowl Road continuing north to 64 and returning to I-17 via Williams may be a time advantage in particularly crowded times.  This does represent a potential economic loss to businesses in Flagstaff.

Early departure incentives: No incentives were offered, but USFS personnel report that Wing Mountain concessionaires would use a loud speaker starting at 2:00 p.m. to encourage people to leave early. USFS also encouraged Wing Mountain to stay open until 5:00 p.m. to ease the demand at 4:00 p.m.  Some in the business community express concern that such actions diminish the visitor experience.  Incentives may be appealing to some.

Visitor Information: Information flier was updated for 2014-2015 with improved directions to Ft. Tuthill, Mormon Lake and Happy Jack.  The Visitor Center, Chamber and Convention & Visitors Bureau reported that visitor contacts were not higher than normal though all received calls or emails complaining about the traffic.  Portable signs were in place on I-17 but the overhead variable message signs were not in use.  Development of an AM Radio message in conjunction with signing has been proposed.  Again, some in the business community have expressed concerns about the type of message sent.

Alternate Snow Play Areas:  Ft. Tuthill was open with the cinder hill play area in place.  They did receive many phone calls from Phoenix.  No visitation numbers are collected but it did appear busier than usual.  Officers reported random snow play along most regional highways.

Travel Demand Management: This was not offered in the original report but represents an opportunity to work with area residents and employers to encourage people to work from home, leave work early, take the bus or take other measures to help ease travel demand.
Background/History:
Background
In 2011 the member agencies of the FMPO requested that a study be conducted to evaluate the congestion experienced on US 180 during peak winter activity and to recommend mitigation solutions.  Interviews and data indicated that the worst congestion historically occurred during holidays, on a weekend, with good snow conditions and recent snowfall with the worst conditions occurring when snowfall exceeded ADOT’s ability to clear the shoulders on US 180 in a timely manner.

Modeling of the corridor indicated that traffic signal timing was the principle cause of congestion followed by a lack of capacity in the corridor.  Tracking of blue tooth signals in vehicles indicated little time advantage to the use of alternate routes and very little use of alternate routes from US 180 to I-17 southbound.  The study was conducted in cooperation with the Winter Activity Task Force spearheaded by the Coconino County Parks Department.

The study recommended short, mid and long-term solutions to be implemented as conditions indicated.  The following table lists these strategies and their respective support from the public:

Table 3: Near-, Mid-, and Long-Term Strategies Point Totals
  MindMixer Public Meeting   Combined
Near-Term Strategies Points Points   Total Points
Early Departure Incentives 57 59   116
Traffic Signal Timing 87 82   169
Traffic Signing Plan 51 72   123
Traveler Information System 67 74   141
Mid-Term Strategies Points Points   Total
Dispersed Snow Play Sites 94 99   193
Managed Lane 51 62   113
Transit 74 60   134
U.S. 180 Winter Recreation Parking Pass 25 18   43
Long-Term Strategies Points Points   Total
Alternate Route to I-40 72 63   135
Cable Propelled Transit 19 9   28
Intersection Improvements 31 71   102
Widen U.S. 180 29 50   79
 

Magnitude of and Effects of Congestion
Snowbowl reported employees remaining until 8 p.m. waiting for traffic to clear.  Ski rental operations reported staying open to 9 or 10 p.m. waiting for customers to return skis.
  • Friday, January 2 and Saturday, January 3:  Northbound traffic backed up on to I-17 (some reports back to John Wesley Powell).  Corroborated by ADOT District and DPS.
  • Saturday, January 3: 1.5 to 1.75 hours from town (speculation) to Flagstaff Nordic Center.   USFS Survey.
  • Saturday, January 3: 2 hours from Flagstaff Nordic Center to USFS Ranger Station on 89 (USFS employee)
  • Friday, January 2 and Saturday, January 3: 3 hours from Snowbowl to town with standing traffic up to 3 miles up Snowbowl Road. (Snowbowl employees/USFS communication)
Gas stations at Plaza, W. Route 66, and Forest reported record-breaking or double the amount of business.  All businesses reported excessive traffic with some reporting customers having difficulty entering their site.

Snow Play Participation
The numbers reported below are in keeping with the historical counts from 2009-2011 reported in the congestion study.
Arizona Snowbowl Visitation:
  • Thursday-Saturday: 3000+; Saturday 3800 (all reported as normal), capacity reached at 10:30 a.m.
Wing Mountain Snow Play Visitation:
  • Friday (Jan. 2) = 1045 cars / Saturday (Jan. 3) = 988 cars / Sunday (Jan. 4) = 994 cars
  • Parking lot was at capacity at 10:30/11:00 a.m. each day with little turnover. Earlier than past years.
Flagstaff Nordic Center (FNC)
  • Reported as not reaching capacity most days.  1/1 – 290; 1/2 – 642; 1/3 – 326; 1/4 - 137
Crowley Pit Parking Area – about 1 mile past Flagstaff Nordic Center (Visitation):
  • The site holds about 50-75 cars depending on conditions.
  • About 275-325 cars each day.
  • The parking lot was at capacity around 11:00/11:30 a.m. each day with slow turnover.
Informal Snow Play
  • Informal reports from law enforcement that visitors were taking advantage of any patch of snow in which to play on US 180, SR 89a, and I-17

Potentially Contributing Factors
Most of these are anecdotal, some are fact based.
  • Maricopa County population increase: Up about 200,000 people since 2011
  • Holiday weekend traffic at points on I-17 up 6%-16% between 2011/12 and 2013/14.
  • Holiday weekend traffic north of Snowbowl on US 180 up 8% between 2011/12 and 2013/14.
  • Accidents: Several reported, but none were reported as significantly impacting traffic
  • Local population and related traffic growth: Up 2,700 people between 2011 and 2013.  Traffic on US 180 between Beale and Mead up 14%-25% between 2012 and 2013.  Traffic on Humphreys between Dale and Columbus up 6% and 4% in 2012 and 2013 respectively.
Pending Information and/or Data
  • ADOT – updated continuous traffic counts from I-17 at various locations and US 180 north of Snowbowl for the time period in question
  • Flagstaff Convention & Visitors Bureau – Occupancy data for December 2014 and January 2015 and two prior years for comparison
  • Flagstaff Sales Tax office – sales tax receipts for December 2014 and January 2015 and two prior years for comparison
  • Grand Canyon National Park visitation at the South Entrance
  • Response from Mormon Lake Lodge
  • Response from Happy Jack Lodge
Key Considerations:
Economic Development:  The winter season is traditionally slower for tourism with hotel occupancy dropping from 85% in the summer to 60% in the winter.  Winter activity such as skiing and snow play, especially if more predictable due to snow-making, can raise that winter participation rate and make fiscal planning more predictable for many firms in the industry.  Excessive traffic - especially if it becomes the norm - may depress economic activity for businesses outside the hospitality sector as local residents and shoppers from outside the region choose to stay home or take their business elsewhere.

Public Safety:  If traffic congestion persists, then access for emergency service vehicles to patients and/or victims in the corridor will be compromised.  Contingency practices should be developed.  One such idea is to have EMS vehicles prepared to take patients northwest on US 180 to areas that can be reached by helicopter.  This, of course, is weather dependent.  Alternatives such as a bypass or widened shoulders are expensive.

Congestion as a public cost:  Many communities with depressed economies seek congestion.  Busy streets and sidewalks are signs of success.  NAU, another economic driver, produces extreme congestion during graduation.  A notable difference is that much of its impacts are contained on campus and the commercial corridors.  There may be value in a public discussion about what is an acceptable level or duration of congestion during these events.
Expanded Financial Considerations:
Rough costs associated with various implementation strategies:

Use of Variable Message Signs (VMS): not known at this time

Installation of AM Radio:  $15,000-20,000 plus annual maintenance

Alternative Routes:  $1.8 million per lane at 6 miles = $20 million more or less

Widened Shoulders: $600,000 per "shoulder" mile at 4-5 miles.  One-side = $3 million more or less

Managed Lanes:  $500-600/day

Dispersed Snow Play Areas: $200,000-$1,000,000 depending on level of improvement

Design, environmental clearances and construction management fees will add an additional 35-50%
Community Benefits and Considerations:
Mitigating traffic impacts during peak events creates a better experience for visitors and a less inconvenient and safer situation for residents and businesses alike.

Certainly the economic activity within the hospitality sector created by snow play helps to balance the peak summer season and allow businesses to create revenue from their otherwise idle capital assets.  It also brings in sales tax revenue to the region (sales tax and hotel occupancy for December and January are not yet available.  A significant number of people are employed in the hospitality sector and increased activity will benefit their wages and tips.

The visits from Sonora, Mexico were noted and this represents expanded tourism opportunities and could translate to business activities in other sectors.

The availability of snow play areas and Snow Bowl add to the recreational activities in which area residents may participate.

Excessive traffic is detrimental to some businesses and several reported the difficulty their customers experienced entering and existing their businesses.

During extreme traffic congestion residents of the corridor experience difficult entering and exiting their neighborhoods.  This represents delayed or deferred economic activity.
Community Involvement:
Inform - Outreach to the public continues through the distribution of winter activity maps and advertisement.  Some strategies expand the "inform" type of outreach.

Involve - the original 2011 study had extensive on-line participation and two well-attended public meetings in which participants were involved in identifying problems, developing solutions and prioritizing them.
Expanded Options and Alternatives:
Managed lanes:  It is possible to manage traffic lanes or Humphreys or possibly Beaver to allow for dual right turns onto westbound E. Route 66.  This is only effective if the downstream traffic is cleared so well that the right turn at Humphreys becomes the bottleneck.

Transit or Shuttle Services: The successful implementation of transit services geared at relieving congestion requires considerable interagency cooperation.  A base parking lot is required.  No city lots are sufficient.  The most likely candidate is an NAU lot which may be available since most peak winter events are during scheduled holidays.  In order to reduce congestion is requires the elimination of parking at the snow play and ski destinations.  This would likely including charging for parking at those locations, too.  Adding transit or shuttle vehicles to the traffic stream without removing vehicles does not resolve the problem.  Given the apparent increasing demand for snow play opportunities and the evident lack of capacity in the US 180 corridor some means of metering traffic into the corridor in addition to the transit services may be warranted.

Capital improvements:  Major intersection improvements at Humphreys/Rte 66; widened shoulders on US 180 and some other physical changes can assist this condition.  The wide shoulders could be used by transit to jump the queue and make emergency vehicle access better.  It likely requires more aggressive enforcement to keep the shoulders clear.


    

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 05-May-24 07:41 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
281 ms 281 ms 1 D:/inetpub/PublicPages/agenda_publish.cfm
250 ms 250 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
234 ms 234 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
78 ms 78 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(1637, 1, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
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/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/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/include_set_fonts.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_expincl.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
297 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 @ 07:41:02.002
			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 @ 07:41:02.002
				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 @ 07:41:02.002
			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 @ 07:41:02.002
				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 @ 07:41:02.002
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 07:41:02.002
	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 @ 07:41:02.002
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:41:02.002
		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 @ 07:41:02.002
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:41:02.002
		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 @ 07:41:02.002
	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 @ 07:41:02.002
	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 @ 07:41:02.002
		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 @ 07:41:02.002
		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 @ 07:41:02.002
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:41:02.002
	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 @ 07:41:02.002
	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 @ 07:41:02.002
	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 @ 07:41:02.002
	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 @ 07:41:02.002
	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 @ 07:41:02.002
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:41:02.002
	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=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 07:41:02.002
		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) = 2015-04-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-04-30 00:00:00.0

chk_aiDisplay (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_content.cfm @ 07:41:02.002
		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) = 1637
Parameter #2(cf_sql_integer) = 1

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 07:41:02.002
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 07:41:02.002
	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) = 1637
Parameter #2(cf_sql_integer) = 1

final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 07:41:02.002
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 349 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 07:41:02.002
 		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 @ 07:41:02.002
 		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 @ 07:41:02.002
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:02.002
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 349 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:02.002
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 349 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
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 = 349 AND agi._rowid = 74)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 349 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 74 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
		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 @ 07:41:03.003
		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 = 74)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '74')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi10')
			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 @ 07:41:03.003
			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 = '74'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
			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 = 1637 AND
				      u.rev_num = 1 
getfi10 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi10'
			
fi10q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi10' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2015-04-28

getPXvalue (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
		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 = 'dwessel'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 1637 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 @ 07:41:03.003
	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 @ 07:41:03.003
	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 @ 07:41:03.003
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 1637 AND ag_memo_dol.rev_num = 1
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
	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 = 1637 AND
		  ad.rev_num = 1 
		  AND (ad.confidentiality IS NULL OR ad.confidentiality = '')		
		
	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 @ 07:41:03.003
		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 @ 07:41:03.003
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 1637 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 @ 07:41:03.003
	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 = 1637 AND form_rte.rev_num = 1 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
	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 = 1637 AND
		  rev_num = 1 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=16ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
		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 = 'AI74')
		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 = 1637 AND
			  hist.rev_num = 1 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 07:41:03.003
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 07:41:03.003
		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) = 349

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 07:41:03.003
				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 = 349 AND ai._rowid = 74)
				
				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 = 8665 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 07:41:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 349
					AND a.ag_level1 = '10'
					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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 07:41:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 349
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					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 @ 07:41:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 349
					AND a.ag_level1 = '10'
					AND a.ag_level2 = ''
					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 @ 07:41:03.003
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 2 
supp_items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 07:41:03.003
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 1637 AND
					      rev_num = 1
					ORDER BY seq_num
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 07:41:03.003
	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 @ 07:41:03.003
	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 @ 07:41:03.003
		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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 07:41:03.003
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=/agenda_publish.cfm?id=&mt=ALL&get_month=4&get_year=2015&dsp=agm&seq=1637&rev=1&ag=349&ln=8665&nseq=1687&nrev=0&pseq=1638&prev=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\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=4&get_year=2015&dsp=agm&seq=1637&rev=1&ag=349&ln=8665&nseq=1687&nrev=0&pseq=1638&prev=1
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=9530584
cftoken=241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
hitcount=4
lastvisit={ts '2024-05-05 07:41:02'}
timecreated={ts '2024-05-05 07:41:02'}
urltoken=CFID=9530584&CFTOKEN=241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
Cookie Variables:
CFID=9530584
CFTOKEN=241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=349
DISPLAY_ID=1637
DISPLAY_REV=1
Session Variables:
cfid=9530584
cftoken=241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9530584_241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
subdir=/public/
tzoffset=0
urltoken=CFID=9530584&CFTOKEN=241fb281256c620c-DBCDD396-BBFF-3A8A-EEB5729C2781497F
URL Parameters:
ag=349
dsp=agm
get_month=4
get_year=2015
id=
ln=8665
mt=ALL
nrev=0
nseq=1687
prev=1
pseq=1638
rev=1
seq=1637
Debug Rendering Time: 0 ms