City Council Meeting - FINAL


Return to the Search Page Return to the Agenda
  8.E.       
Meeting Date: 03/21/2023  
Co-Submitter: David McIntire
From: Jana Weldon, Beautification Arts & Sciences Program Manager

Information
TITLE:
Consideration and Approval of Contract:  Artist Services Contract with Haddad/Drugan LLC for $530,451 for two artworks for the Downtown Connection Center.  Art Glass Fabrication & Delivery; and Southside Grove Sculpture Fabrication, Delivery & Installation.
STAFF RECOMMENDED ACTION:
  1. Approve artist services contract for the Art Glass and the Southside Grove Sculpture at the Downtown Connection Center (DCC) with Haddad|Drugan LLC for $530,451.
  2. Authorize the City Manager to execute all necessary documents.
Executive Summary:
At the January 31, 2023 Work Session, City Council reviewed and responded positively to the public art concepts recommended by the Beautification and Public Art Commission (BPAC). The proposed public art consists of: Art Glass, and a Southside Grove Sculpture. It is designed for the DCC being constructed on west Phoenix Avenue, just east of Milton Road.  The City Council is being asked to approve a services contract to the artist team to coordinate the fabrication and delivery the Art Glass artwork, and the fabrication, delivery, and installation of the Southside Grove Sculpture artwork.   
 
The full agenda and Council package for the January 31, 2023 Work Session can be found here: https://agenda.flagstaffaz.gov/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2023&dsp=agm&seq=7013&rev=0&ag=3654&ln=44449&nseq=6993&nrev=0&pseq=7016&prev=0#ReturnTo44449
 
The Art Glass:
The Art Glass is luminous art. It will be integrated into the main entry of the new DCC building, which should have its groundbreaking in February 2023. The Art Glass on the south facades is over the front door and faces Phoenix Ave, and then wraps to the east facade facing the future bus bays and civic space. The art draws from elements of the Mountain Line logo and Flagstaff’s natural beauty, and fuses those elements with color and light. Using a graphic technique, the design overlays, into a unique composition, the imagery of a mountain lion, the San Francisco peaks as viewed from the DCC, and ponderosa pines in three different colors (blue, green, red). The artwork will have a different presence at night than during the day. In daylight, the multiple colors and images are superimposed. At night different colored back lights will highlight the individual layers of the overlapped images on the south facade, making each image pop as the other images recede, creating a gentle morphing through the series of colorful illuminations. The east facade will also be back-lit as the image of the ponderosa pines alone wraps around from the front facade. The architect and the artist team worked diligently to align the glass mullions and support features so that the art glass and architectural features are complementary, enhancing each other.
 
The Southside Grove Sculpture:
The "Southside Grove” is an immersive sculpture, has a meet-me-here presence, but also is reflective of natural and cultural history, especially that of the Southside but also Flagstaff and the surrounding region. The primary elements of the sculpture are:
  • six ponderosa pine and telescope inspired “trunks” made from weathered steel, positioned in a circle to form a grove and to reflect the strong circle of community that is the Southside;
  • all of the trunks have different cultural symbols etched into each representing important cultures that have come together as community in Flagstaff;
  • five of the trunks are etched with a bark texture and have “branches” that end in prisms that catch and cast spectrums of color, and star clusters of luminous green needles that glow in the sunlight;
  • the grove is aligned to mark the Spring and Autumn Equinoxes at sunrise and sunset and the largest trunk positioned South more strongly references a telescope and works as a sun portal casting a beam of light at noon on the summer solstice onto a “Time-Table” located at the center of the grove;
  • the top of the south trunk also includes a wind activated bell-like feature that creates a chime-like sound when windy;
  • in the center of the grove, a circular granite “Time-Table” is etched with tree rings that contain significant natural and cultural events in astronomy, of Indigenous peoples, of the region, and of the Southside.
 
While strong and durable sculptural forms are created with steel, the variety of finishes and details are layered to create a softer organic appearance and experience. Hence it is anticipated that the Southside Grove sculpture will create a natural rendezvous and visual landmark, but also have a strong experiential quality once there.
 
The Southside Grove Sculpture initially will be installed within a landscaped area adjacent the entry plaza of the new building, during phase one of the DCC Project. The sculpture will later be moved into a new civic space east of the future bus bays which will be constructed during phase two of the DCC Project. The relocation is necessitated by the Rio de Flag Flood Control Project work by the Army Corps of Engineers in the same area as the DCC.  While the schedule and length of time between the phases has not yet been set, the current estimate is between four and eight years.
 
Financial Impact:
Funding is available for this contract in the Council approved 5-year plan for the Beautification Fund with $470,000 in FY2023-24 and $100,000 in FY2024-25.  The Beautification Fund is supported by voter approved Bed, Board, & Beverage tax revenue and may only be used for purposes of Beautification.
 
Policy Impact:
No impact. This contract does, however, reflect our new practices in public art, including the following elements below, which will be codified in guidelines at some point in the future:
  • Artist Selection Panels: The City is implementing a new process for artist selection to (a) increase inclusivity of the community and diversity in the selection of public art and beautification, and (b) better align with current ‘best practices’ for artist selection.
  • Inclusion of Artist on Design Teams: The City is shifting our processes to bring artists in earlier in the design phase when art and beautification are part of a larger project to help create more integrated pieces and, where possible and appropriate, bring an artistic viewpoint to project design. For example, rather than adding art at the end of a project, it may be integrated into infrastructure such as walls, floors or seating.
Connection to PBB Priorities/Objectives, Carbon Neutrality Plan & Regional Plan:
This project and contract are related to several Priority-Based Budgeting (PBB) Key Community Priorities, including:
  • Livable Community: The inclusion of art in the new Downtown Connection Center creates a more welcoming, vibrant and beautiful public space in the city’s historic core.
  • Robust Resilient Economy: The project adds to community draw for tourists and locals alike in a new and important hub for transportation.
  • Inclusive and Engaged Community: This project includes community outreach for input on design elements by the artist and city staff.
  • Sustainable, Innovative Infrastructure: This project allows for innovative, creative integration of designs.
This project also reflects the following Regional Plan Goals and Policies:
Goal CC.3. Preserve, restore, enhance, and reflect the design traditions of Flagstaff in all public and private development efforts.

Goal CC.4. Design and develop all projects to be contextually sensitive, to enhance a positive image and identity for the region.

Goal CC.5. Support and promote art, science, and education resources for all to experience. (Including: Policy CC.5.3. Encourage the integration of art into public and private development projects.)

Goal LU.3. Continue to enhance the region’s unique sense of place within the urban, suburban, and rural context.

Goal LU.9. Focus reinvestment, partnerships, regulations, and incentives on developing or redeveloping urban areas.

Goal LU.11. Prioritize the continual reinvigoration of downtown Flagstaff, whose strategic location, walkable blocks, and historic buildings will continue to be a vibrant destination for all.

Goal LU.17. Protect, manage, and enhance the region’s Special Planning Areas to benefit the whole community.

Goal LU.18. Develop well designed activity centers and corridors with a variety of employment, business, shopping, civic engagement, cultural opportunities, and residential choices.

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. (Including: Policy PF.2.3. Provide accessible public facilities and services in strategic locations. Policy PF.2.4. Support quality civic design for all public facilities.)

Goal NH.2. Look to downtown Flagstaff as the primary focal point of the community character. (Highlighting Policy NH.2.1. Encourage the rehabilitation of historic downtown structures and contextual new structures as office, retail, entertainment, and residential space to reinvigorate the area as a destination of culture, shopping, government, and the arts.)

Goal ED. 6. Tourism will continue to provide a year-round revenue source for the community, while expanding specialized tourist resources and activities.

Goal ED.7. Continue to promote and enhance Flagstaff ’s unique sense of place as an economic development driver. (Including:

Policy ED.7.1. Support planning, design, and development that positively, creatively, and flexibly contribute to the community image.)

Policy T.1.7. Coordinate transportation and other public infrastructure investments efficiently to achieve land use and economic goals.

Goal T.4. Promote transportation infrastructure and services that enhance the quality of life of the communities within the region. (Including: Policy T.4.1. Promote context sensitive solutions (CSS) supportive of planned land uses, integration of related infrastructure needs, and desired community character elements in all transportation investments, and Policy T.4.3. Design transportation facilities and infrastructure with sensitivity to historic and prehistoric sites and buildings, and incorporate elements that complement our landscapes and views.)

Goal T.7. Provide a high-quality, safe, convenient, accessible public transportation system, where feasible, to serve as an attractive alternative to single-occupant vehicles. (Including: Policy T.7.1. Cooperate with Mountain Line in developing and implementing the five-year transit master planning goals and objectives to continuously improve service, awareness, and ridership.)

Goal T.11. Build and sustain public support for the implementation of transportation planning goals and policies, including the financial underpinnings of the Plan, by actively seeking meaningful community involvement. (Including: Policy T.11.5. Promote effective intergovernmental relations through agreed-upon procedures to consult, cooperate, and coordinate transportation-related activities and decisions, including regional efforts to secure funding for the improvement of transportation services, infrastructure, and facilities.)

Southside Neighborhood Specific Plan: The new Southside plan supports these activities, such as stating “Opportunities for public art are highly prized” (Chapter 2 page 25). Outdoor public spaces are also emphasized in the plan. This contract also supports “Encourage the Southside community work with Mountain Line on the Downtown Connection Center design” on page 54.
Has There Been Previous Council Decision on This:
Council approved a design contract for this artist team on Dec 1, 2020 (https://agenda.flagstaffaz.gov/agenda_publish.cfm?id=&mt=ALL&get_month=12&get_year=2020&dsp=agm&seq=5032&rev=1&ag=1147&ln=26891&nseq=5051&nrev=1&pseq=5029&prev=1#ReturnTo26891 ).

Council heard a presentation on the art concepts on January 31, 2023
(https://agenda.flagstaffaz.gov/agenda_publish.cfm?id=&mt=ALL&get_month=1&get_year=2023&dsp=agm&seq=7013&rev=0&ag=3654&ln=44449&nseq=6993&nrev=0&pseq=7016&prev=0#ReturnTo44449.

Council has previously approved the FY 2023 Beautification 5-Year Plan and authorized the FY 2023 budget for this project.
 
Options and Alternatives:
  1. Approve the contract award and go forward with the fabrication and delivery of the Art Glass, and the fabrication, delivery and installation of the Southside Grove Sculpture
  2. Council may request changes to the contract which may delay implementation and inclusion of the artwork in the DCC project
  3. Reject the contract award and give direction to staff. This will prevent these artworks from being implanted.
Background and History:
Purchasing staff published a Request for Statement of Qualifications (RSOQ) solicitation for Artistic Services for Downtown Connection Center Art in the Arizona Daily Sun on September 13 and September 20, 2020 and posted the solicitation to the City of Flagstaff’s PlanetBids Website on September 8, 2020. On September 30, 2020, the City received 13 Statements of Qualifications (SOQs) from Artist firms. A seven- member Selection Committee reviewed and evaluated the statements. Based upon the numerical scoring of the written SOQs, the Selection Committee identified the most qualified Firm to perform the engineering professional services for the Project and recommended to commence negotiations for a scope and fee proposal to be provided by Haddad|Drugan LLC. Final scores of all firms are as follows:
 
Haddad Drugan, LLC       662
Social Space LLC              648
James Carpenter Design Associates Inc.  624
zischke studio    622
Willco Art and Design     620
Zokaites Sculpture LLC   602
Five Moores Enterprises              570
Summer Kitchen Studios              568
Mary Shindell    559
Hans van Meeuwen LLC 525
Brailsford Public Art       502
Four Lizard Studios LLC  463
Robin Wallenfang           427

Haddad|Drugan LLC demonstrated, a clear recognition of the knowledge and experience needed to represent the City’s vision in this undertaking, as well as understanding the schedule and collaboration requirements for completing this project.

City Council approved award of design services contract on December 1, 2020 with Haddad/Drugan LLC, the artist team of Laura Haddad and Tom Drugan. The artist team was charged to work with Mountain Line’s design team to identify and design multiple public art or beautification projects/elements that integrate with the new Downtown Connection Center project. The original contract of $25,000 took this design work to 60%, and a subsequent amendment in the amount of $22,000 is taking the Art Glass and Southside Grove sculpture art concepts to 100% of design.  

The agenda and full Council package for the December 1, 2020 contract approval can be found here: https://agenda.flagstaffaz.gov/agenda_publish.cfm?id=&mt=ALL&get_month=12&get_year=2020&dsp=agm&seq=5032&rev=1&ag=1147&ln=26891&nseq=5051&nrev=1&pseq=5029&prev=1#ReturnTo26891                   

Best practices in the field of public art were utilized in all stages of design. Vested community members were on the selection panel. Prior to design commencement, a broad community survey was conducted for which approximately 70 responses were received, and a photo contest was run to provide images to inspire the artist team. Also prior to design commencement, the artist team met with a group of Southside residents and business owners on site, met with the City team for the Rio de Flag project, participated in a walking tour with the Historic Preservation Officer and administrator of the Southside Plan, did regional hiking, and went to Lowell Observatory among other cultural centers. The artist team then came up with a master plan of about fifteen (15) project ideas. Through vetting with the design team and Mountain Line’s Southside Stakeholder group, five (5) project ideas emerged. These five ideas were presented in public meetings with Mountain Line in the Fall of 2021 for feedback and all five went forward based on responses. Three (3) of these ideas will be developed by other artists. This artist team took two (2) ideas, Art Glass and the Southside Grove sculpture, and developed the concepts while working with the design team to integrate the art within the evolving design of the DDC. The developed concepts were presented for comment to the original selection panel members, the Southside Community Association, and Mountain Line’s Southside Stakeholder group and Boards in the Spring of 2022. The artist team made some modifications, and BPAC at its May 2022 meeting approved its recommendation to City Council for Council approval of the Art Glass, and provisionally recommended the Southside Grove sculpture with some changes. The artist team incorporated the direction and other community and upper management comments into the features of the sculpture, and at the November 2022 BPAC gave its full recommendation to Council to approve the Southside Grove sculpture. Staff sought the input of the Indigenous Commission and has recommendations from the Southside Community Association for cultural submissions for the project. Staff reviewed the concepts with Risk Management for safety. No changes were sought.

Staff presented the art concepts to Council in a work session on January 31, 2023
 
Expanded Options and Alternatives:
See Background/History above. Further vetting of the cultural and historical text in the Time Table element of the Southside Grove Sculpture with the Southside and Indigenous communities will occur in the upcoming year.
Attachments
Council Presentation
2023-116 Contract for DCC Two Pieces of Artwork


    

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 25-Apr-24 06:11 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
234 ms 234 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
187 ms 187 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
157 ms 157 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
63 ms 63 ms 1 D:/inetpub/PublicPages/Application.cfm
63 ms 32 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(7099, 1, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.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/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.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=63ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 18:11:23.023
			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 @ 18:11:23.023
				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 @ 18:11:23.023
			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 @ 18:11:23.023
				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 @ 18:11:23.023
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 18:11:23.023
	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 @ 18:11:23.023
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=15ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:23.023
		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 @ 18:11:23.023
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:23.023
		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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
		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 @ 18:11:23.023
		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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=16ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:23.023
	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=16) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:11:23.023
		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) = 2023-03-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2023-03-31 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 18:11:23.023
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3728 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 18:11:23.023
 		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 @ 18:11:23.023
 		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 @ 18:11:23.023
		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 @ 18:11:23.023
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 3729 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 3729 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
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 = 3728 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 = 3729 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 @ 18:11:23.023
		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 @ 18:11:23.023
		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 @ 18:11:23.023
			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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
			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=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
			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 = 7099 AND
				      u.rev_num = 1 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
				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 @ 18:11:23.023
					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) = 2023-03-21

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submit_for (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
			SELECT ee.title utitle,
			ee.fname + ' ' + ee.lname name
			,ee.lname, ee.fname, p.phone_no, p.phone_ext, websecur.email,
			dept.dept_desc, dd.div_desc,
			case when ee.title is null then 'false' else 'true' end as display_title
			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 = websecur.empl_id AND is_primary = 'Y')
			WHERE login_id = 'dmcintire'
		
getSubmitFor (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
			SELECT * from submit_for
		
submittor (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
		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 = 'jweldon'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 7099 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 @ 18:11:23.023
	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 @ 18:11:23.023
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 7099 AND ag_memo_dol.rev_num = 1
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
	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 = 7099 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 @ 18:11:23.023
		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 @ 18:11:23.023
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 7099 AND
		      rev_num = 1
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
	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 = 7099 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 @ 18:11:23.023
	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 = 7099 AND
		  rev_num = 1 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
		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 = 7099 AND
			  hist.rev_num = 1 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:11:23.023
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:11:23.023
		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) = 3729

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:11:23.023
				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 = 3728 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 = 45220 
chkLevel1 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:11:23.023
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3728
					AND a.ag_level1 = '8'
					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 @ 18:11:23.023
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3728
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'E'
					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 @ 18:11:23.023
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3728
					AND a.ag_level1 = '8'
					AND a.ag_level2 = 'E'
					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 @ 18:11:23.023
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 18:11:23.023
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 7099 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 @ 18:11:23.023
	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 @ 18:11:23.023
	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 @ 18:11:23.023
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 18:11:23.023
		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=3&get_year=2023&dsp=agm&seq=7099&rev=1&ag=3728&ln=45220&nseq=7050&nrev=1&pseq=7117&prev=0
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=3&get_year=2023&dsp=agm&seq=7099&rev=1&ag=3728&ln=45220&nseq=7050&nrev=1&pseq=7117&prev=0
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=9288423
cftoken=ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
hitcount=4
lastvisit={ts '2024-04-25 18:11:23'}
timecreated={ts '2024-04-25 18:11:23'}
urltoken=CFID=9288423&CFTOKEN=ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
Cookie Variables:
CFID=9288423
CFTOKEN=ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=3728
DISPLAY_ID=7099
DISPLAY_REV=1
Session Variables:
cfid=9288423
cftoken=ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9288423_ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
subdir=/public/
tzoffset=0
urltoken=CFID=9288423&CFTOKEN=ebbcbab86995e7a-EF65E109-C7DF-4C5A-07E15B0F44D6B7A8
URL Parameters:
ag=3728
dsp=agm
get_month=3
get_year=2023
id=
ln=45220
mt=ALL
nrev=1
nseq=7050
prev=0
pseq=7117
rev=1
seq=7099
Debug Rendering Time: 16 ms