City Council Work Session


Return to the Search Page Return to the Agenda
  9.       
Meeting Date: 06/28/2016  
From: Karl Eberhard, Comm Design & Redevelopment Mgr
Department: Economic Vitality  
Co-Submitter:

TITLE:
Discussion/Presentation on the Historic Preservation Ordinance with a focus on Cultural Resource Studies and the Role of the Historic Preservation Officer
DESIRED OUTCOME:
Present to Council and answer any questions
EXECUTIVE SUMMARY:
This report provides information about Historic Preservation with a focus on Cultural Resource Studies including the applicability, requirements, processes, decision making, authorities, and statistical history of the program.  It also provides similar detail as to the role of the Historic Preservation Officer.  The information is summarized, on one page, in the attached "At-a-Glance" flow chart.
INFORMATION:
PART 1 - CULTURAL RESOURCE STUDIES

Background:

Why are Cultural Resource Studies Required?

Regional Plan 2030:  The adopted Regional Plan 2030 establishes the preservation of our heritage as an important policy of the City.  “Preserving the region’s heritage, including its design, building traditions, and cultural preservation, enhances the quality of life in the Flagstaff area.  Our region’s cultural and historic resources must be preserved, protected, and enhanced.”  “For cultural and historic resources to serve as meaningful focal points within the community, it is necessary to preserve archaeological sites, historic sites, and historic buildings of significance.”  Two Regional Plan 2030 goals specific to Cultural Resource Studies are:
 
Policy CC.2.1. Actively locate, identify, interpret, and preserve historical, archaeological, and cultural resources, in cooperation with other agencies and non-governmental organizations, as aspects of our society for future generations to retain, understand, and enjoy their cultural identity.
 
Policy CC.2.3. Mitigate development impacts on heritage resources.

City of Flagstaff Zoning Code:  The Zoning Code identifies the following purpose for Cultural Resource Studies:

To identify significant cultural resources and potential impacts of proposed development so that mitigation measures can be established for major impacts prior to development of the property.

The process was designed and considered to not restrict property rights and to be fair and reasonable in proportion to the nature of the proposal and the value of the resource.

What are Cultural Resources?

Cultural resources are objects, structures, natural features, sites, places, and areas having historic, architectural, archaeological, cultural or aesthetic significance.  In the Zoning Code, they are divided into historic and archeological types.  Historic resources are most often buildings, but can be other structures, objects, sites, districts, and areas.  Historic resources were generally created after European contact with native peoples and are most often above ground.  Archaeological resources include remains from human activities prior to written records.  They can be isolated elements like simple potsherds but can also be habitation complexes.  Notably, cultural resources are finite and non-renewable resources that once destroyed cannot be returned to their original state.

What is a Cultural Resource Study?

In brief, Cultural Resource Studies seek the answers to four questions:

Are significant resources present (defined in ZC 10-30.30-050.B)?  While the determination criteria are more detailed, in general, a resource is significant if it is already on a registry of historic places; if it is associated with historic people or events; or if it embodies distinctive characteristics.  For archeological resources, a resource can also be significant if it may still yield information for further scientific research.  Part of understanding a resource and its significance is identifying the historic context - the period, the place, and the events that created, influenced, or formed the backdrop to the historic resources.  Similarly, this research identifies the “the period of significance” – the span of time associated with its significance.

Does the resource have integrity (defined in ZC 10-30.30-050.C)?  Historic integrity refers to whether or not the property authentically retains its historic appearance, its completeness, and if the remaining physical characteristics still illustrate the property’s significance.  Has the character been retained?  Would someone from the period of significance recognize the resource?  Integrity is the composite of seven qualities:  location, design, setting, materials, workmanship, feeling and association.  Authenticity, or the lack of false history, is integral with integrity.  As a result, preserving the original materials and avoiding re-created elements is important.  Integrity and condition are not the same - a resource in poor condition can still retain integrity.

Will the proposed work negatively impact the resource (defined in ZC 10-30.30-050.D)?  Change often preserves resources and can be positive from a preservation perspective by allowing buildings to have new uses and modern amenities.  Negative impacts are those that compromise the integrity of the resource.  Also, “readily reversible” is a special class of changes that have neither positive nor negative impacts.  On one hand they are superficial and relatively inexpensive changes that often come about through maintenance, and that usually involve elements with relatively short life cycles (like paint).  On the other hand, they can be elements (like additions) designed to allow the historic resource to dominate the overall design; to be compatible with the resource; and if removed, the original resource is intact or nearly intact.

How can negative impacts be mitigated (defined in ZC 10-30.30-050.E)?  In most cases, project goals can be achieved in multiple ways.  This portion of the study identifies steps that can be taken, or alternative design proposals, to mitigate proposed negative impacts on significant resources.  Notably, the mitigation for a proposal to destroy the integrity of a significant cultural resource is complete documentation of the resource (i.e. additional more in-depth studies known as Phase 2 Cultural Resource Studies).

Authorities, Requirements, and Processes:

[Author’s Note:  It may be assistive to have the attached “At-a-Glance” flow chart at hand when reading this section.]

What authorizes the requirement for a Cultural Resource Study and when are they required?

Title 10 of the Flagstaff Municipal Code (Zoning Code), Division 10-30.30: Heritage Preservation, Section 10-30.30.050 Cultural Resources authorizes the requirement for a Cultural Resource Study. 

When a development approval (permit) is sought, Cultural Resource Studies are required for buildings that are already recognized as historic, buildings that are over fifty years old, and for undeveloped land (ZC 10-30.30.050.A.2).  However, this basic applicability standard has exceptions for buildings that are deemed “immediate hazards” by the Chief Building Official, maintenance work, and interior work (ZC 10-30.30.020.B). 

The exclusion of interior work from consideration differentiates the Flagstaff requirements from similar assessments prepared for other cities, the State, or to meet Federal regulations and is a calibration of the Zoning Code requirements to the values of this community.

Further calibrating the Zoning Code to local values and distinguishing it from similar codes, there are additional exceptions that the Historic Preservation Officer (HPO) may determine as applicable (ZC 10-30.30.050.A.2.b):
  1. Small undeveloped parcels, but in generally developed areas, are not required to seek archeological resources on the basis that such sites are generally already disturbed.
  2. In adding these requirements to the development review process, the City Council specifically excluded production housing built after 1945.  This is reflective of broad discussions within the heritage preservation industry that question the historic value of post-war housing.
  3. Structures that lack integrity are exempt.  Notably, the practice of the HPO, supported by the City Attorney’s Office, has been only to exempt those that clearly lack integrity and when there is any doubt, when the answer is “maybe”, a Cultural Resource Study is sought.
In the first (2011) version of these Zoning Code provisions, it was necessary to rely on industry standards (referenced in the Zoning Code) for the definition of “integrity”.  The 2016 revisions copied those standards directly into the Zoning Code.
  1. Work that does not have major impacts; that does not diminish the significance or integrity of the resource; that is reversible; or that is temporary is exempt.  Again, the practice of the HPO has been only to exempt those proposals that clearly do not have impacts and a Cultural Resource Study is sought when there is any doubt.
Projects designed to meet the Secretary of the Interiors’ Standards for the Treatment of Historic Properties (the Standards) retain eligibility for the National Register of Historic Places (NRHP) and thus do not have impacts (ZC 10-30.30.050.F.2).  Furthermore, projects formally or informally reviewed by the State Historic Preservation Officer (SHPO), with results indicating that NRHP eligibility is retained similarly do not have impacts (ZC 10-30.30.050.A.3.c(5)).
 
In the first (2011) version of these Zoning Code provisions, this exception was not clearly stated.  In 2014 the City Attorney’s Office expressed concern about the language.  This was addressed in the short term by a moratorium on the use of this exception and in the long term by the 2016 Zoning Code revisions.
  1. Minor work that is eligible for Consent Approval, a Certificate of No Effect (ZC 10-30.30.030.C), is exempt.
  2. The 2016 Zoning Code revisions added “Other (site specific) circumstances under which it is reasonable to conclude that a Cultural Resource Study is not warranted.”  This reflects the desire for the process to be reasonable and responsive.
Decision:  This applicability assessment is accomplished by the HPO as a standard part of the Inter-divisional Staff (IDS) review of proposed development projects or it is accomplished as a standard part of the review of a Building Permit when IDS review is not required.

Review Time:  It has no additional review time implications for an applicant.

Historical Outcome:  For 85% of development applications, a Cultural Resource Study is not required.  

[Author's Note:  As projects with exceptions for “immediate hazards”, maintenance work, and interior work are not tracked, statistics such as “85%” that have been provided in this report exclude such projects.]

What type of report is required and what is the process?

Applicants or report preparers work with the HPO to determine the appropriate report type and format based on the specific circumstances of the site and the proposed work (ZC 10-30.30.050.A.3.a).  The appropriate type of report may be an Archeological Resource Study or a Historic Resource Study, or both.  They also work collaboratively to determine the appropriate report format (ZC 10-30.30.050.A.3.c) and there are three typical formats, or levels of consideration - Letter Reports, Phase 1 Reports or Phase 2 Reports. 

Letter Reports (ZC 10-30.30.050.A.3.c.(1)):  A Letter Report is appropriate when site conditions, historic records, or previous research or studies indicate that cultural resources are not likely to be present, the integrity of a cultural resource is already severely compromised, or the proposed work will not compromise the integrity of the cultural resource, and when no mitigation measures are warranted.  Letter reports are intended to be informal and brief.  The contents of the report are reduced to only address the subjects in question.  If the situation cannot be addressed in a brief format, or if on-site inspection or research suggests that these conditions are not true, then a Phase 1 Cultural Resource Study is appropriate.

Having reports with reduced content is another way that the program was designed to be reasonable; that calibrates the Zoning Code to local values; and that distinguishes our requirements from similar programs.

Decision:  Letter Reports are accepted by the HPO (ZC 10-30.30.030.C.1.a) with oversight by the Heritage Preservation Commission (Commission) (ZC 10-30.30.030.C.2.b).  At regular meetings of the Commission, the HPO presents Letter Reports that were approved in the prior month, including a description of the resource and project, why a Letter Report was appropriate, and what were the results.  The Commission in turn provides feedback to the HPO on any aspect of the project, determinations, or approval which is then used when future considerations are made by the HPO. 

Review Time:  While Arizona law and our published application approval schedule allows 45 days, approvals are provided within a week.  For projects subject to IDS review, the preparation of these reports overlaps with, or runs parallel to, other development review processes and has no impact on development schedules.  For projects that go directly to a Building Permit (no IDS review), there can be a delay for preparation of the report – the length of that delay being dependent on how fast a consultant can work.  As far as approvals of the Letter Reports, the typical turn-around is measured in hours if not minutes. 

Historical Outcome:  Letter Reports have been applicable for ten percent of all development applications – two-thirds of all required Cultural Resource Studies.

Phase 1 Cultural Resource Study (ZC 10-30.30.050.A.3.c.(2)):  Phase 1 Cultural Resource Studies are the “baseline” requirement.  Such reports formally identify the presence of cultural resources, evaluate the potential for additional cultural resources being discovered, assess the significance of identified and potential cultural resources, assess identified and potential impacts, and provide measures to mitigate major impacts on significant cultural resources.  Again, if on-site inspection or research suggests that these conditions actually are not true, then the report is reduced to a Letter Report.

Decision:  Phase 1 Cultural Resource Studies are reviewed and accepted by the Commission only.  Like Letter Reports, the preparation of these reports overlaps with, or runs parallel to, other development review processes.  Typically, in IDS cases, a delay is rarely the result and for direct to Building Permit cases, the process can cause delay. 

Review Time:  While Arizona law and our published application approval schedule allows 45 days, the typical turnaround does not exceed thirty days.  There have been a handful of cases where an applicant has had to come back to the Commission to provide additional information and in one case the HPO needed to provide the Commission with additional information.

Historical Outcome:  Phase 1 Cultural Resource Studies have been applicable for 4.25% of all development applications – nearly all of the remaining circumstances wherein a Cultural Resource Study is required.

Phase 2 Cultural Resource Study (ZC 10-30.30.050.A.3.c.(3)):  When identified cultural resources are determined to be significant; when they retain integrity; and when total destruction of the resource’s integrity is proposed – only when all three conditions exist – it is appropriate to mitigate the loss of the resource via the preparation of a Phase 2 Cultural Resource Study.  The Zoning Code specifies an “order of preference” for mitigating impacts on resources (ZC 10-30.30.050.E.3b).  For historic resources, a Phase 2 Cultural Resource Study is the least desirable mitigation measure – the recovery of data.  In these cases, where there is a proposal to destroy an intact significant cultural resource, the materials of a Phase 1 Cultural Resource Study are supplemented with as-built drawings so that there is a complete record of the resource prior to its destruction.

Notably, this documentation requirement does not prevent an applicant from destroying an intact significant cultural resource.  So, while approximately 10% of identified significant resources have been destroyed even when the applicant was aware of the value, 90% of applicants have made proposals that do not destroy the resource.

Decision:  Only the Commission determines when a Phase 2 Cultural Resource Study is required, and review and acceptance of the report is only by the Commission. 

Review Time:  When the Commission requires a Phase 2 Cultural Resource Study in response to reviewing a Phase 1 Cultural Resource Study, thirty additional days is normal.  However, the conditions that establish a requirement for a Phase 2 Cultural Resource Study are defined by the Zoning Code and the requirement is very predictable (ZC 10-30.30.050.A.5).  As a result, some applicants – understanding the value of the resource and the major impacts of the proposal – choose to provide the Phase 2 Cultural Resource Study on their first submittal and thus they do not experience the additional review time.

Historical Outcome:  Phase 2 Cultural Resource Studies have been required for 1.5% of all development applications.

In addition, the Zoning Code has provisions for Phase 3 Archeological Reports (ZC 10-30.30.050.A.3.c.(4)).  These are extremely rare reports that address circumstances where archeological artifacts are physically recovered from the field and curated at a museum.  None have been required during the five years since these requirements have been in place.

Appeal Process (ZC 10-30.30.080):  Anyone or any entity aggrieved by a decision of the HPO in interpreting, applying, or enforcing the provisions of the Heritage Preservation Chapter of the Zoning Code properly appeals the decision to the Commission.  The practice of the HPO has been to offer a referral to the Commission – thus avoiding the time and expense of an appeal - whenever an applicant appears dissatisfied (per ZC 10-30.30.030.C.2.a).  Similarly any decision of the Commission is properly appealed to the City Council.  There are no provisions to appeal the decisions of the HPO to City management, State agencies, or directly to the City Council.

Additional Requested Information:

Who prepares Cultural Resource Studies?

For most development projects, applicants hire professionals to prepare application materials.  These include land surveyors to map the land, water courses, trees, and other natural resources; architects to design the site and buildings; and engineers to design the storm water systems and to assess the traffic and other impacts.  Similarly, applicants hire qualified consultants to prepare these reports addressing potential impacts to cultural resources.  These professionals must be qualified in accordance with the Secretary of the Interior's Standards and Guidelines for Archeology and Historic Preservation (ZC 10-30.30.050.3.b).

How much do Cultural Resource Studies cost?

In 2001 when the City Council considered the Zoning Code changes that required Cultural Resource Studies, the Council specifically asked about the expected costs of this documentation.  This was and still is difficult to determine due to the varied nature of resources, the complexity of resources and project proposals, and due to the varied costs of consultant services.  However, the costs that have been reported to the HPO have been as predicted for Letter Reports and Phase 1 reports and substantially less than predicted for Phase 2 reports.  In addition, on behalf of the City, the HPO has ordered several Cultural Resource Studies for our projects and the costs have been consistent with the expectations.

Letter Reports generally cost between $500 and $1,000 and Phase 1 Cultural Resource Studies cost between $2,500 and $5,000.  Phase 2 Cultural Resource Studies were predicted to be double the cost of a Phase 1 Cultural Resource Study or more.  The actual cost has been much less – most have cost less than $5,000 for both the Phase 1 and Phase 2 documentation.

What becomes of these reports?
 

Projects plans, impacts reports, and other development application materials, including Cultural Resource Studies, are public records and are maintained at the offices of the City, specifically at City Hall, pursuant to an established records retention schedules.  Citizens may, and do, review the reports at City Hall.  Only archeological reports are withheld pursuant to Federal law and the Zoning Code (ZC 10-30.30.050.A.4.b).

Staff has been working to make the Historic Resource Studies more available than other public records through curation at the Cline Library.  Language regarding this curation in the 2011 version of the Zoning Code was determined to be legally insufficient.  The language was addressed in the 2016 Zoning Code revisions and staff looks forward to being able to make these public records more available to the public in the future.

How has it been going?

Since the adoption of the new Zoning Code (November of 2011), nearly 400 development applications have been assessed for the need of preparing a Cultural Resource Study.  The applicability of the Cultural Resource Study requirements has been as follows:
 

85%      -    Cultural Resource Study not required.
10%      -    Letter Report required.
4.25%   -    Phase 1 Cultural Resource Study required.
1.50%   -    Phase 2 Cultural Resource Study required.

Notably, fewer projects are getting the higher levels of review than was expected when the City Council considered these requirements.

During this time, as the reports have provided the information necessary for informed decisions, many projects have been conceptualized or changed to address the resources in an appropriate way.  Just a few examples:
  • 23 S. Agassiz Street was originally proposed for demolition and has since become a full restoration project.
  •  623 N. Leroux Street was re-designed to be an exemplary adaptive re-use of an historic house.
  • The historic house on the site of the HUB is proposed to be moved instead of demolished.
  • The Babbitt House on North Beaver Street is proposed to be moved instead of demolished.
  • Previously unknown “pit houses” were found off Rain Valley Road and are being avoided in the development.
  • The pending Timber Sky development incorporated historic features of the McAllister Residence site into the design of their park and incorporated historic themes into the project design and street names.
Several resources that could have been saved – preserved, relocated, or incorporated into a development, were not.

PART 2 – THE ROLE OF THE HISTORIC PRESERVATION OFFICER

What are the enabling ordinances that direct this position?

The role of the Historic Preservation Officer is enabled by Title 10 of the Flagstaff Municipal Code (the Zoning Code), Chapter 10-20: Administration, Procedures, and Enforcement - Section 10-20.20.060. 

What are the duties of the Historic Preservation Officer?

The day-to-day duties of the HPO relative to Cultural Resource Studies have been illustrated above (Authorities, Requirements, and Processes).  These preservation activities are assigned to the HPO and authorized by the Zoning Code (ZC 10-20.20.060):
  1. Develop and direct all heritage preservation projects, activities, and investigations;
  2. Conduct an ongoing survey(s) to identify objects, structures, natural features, sites, places, and areas within the City having historic, architectural, archaeological, cultural or aesthetic significance for the nation, region, State, or City;
  3. Keep and maintain the Flagstaff Register of Historic Places;
  4. Provide technical assistance and make professional recommendations on preservation matters that are brought to the Heritage Preservation Commission, other commissions, or the Council;
  5. Make recommendations to the Heritage Preservation Commission on the designation of cultural resources as Landmarks or as Historic Districts;
  6. Assist the Director with all matters pertaining to heritage preservation;
  7. Serve as liaison between the City and the State Historic Preservation Officer and other government and non-governmental agencies in all matters pertaining to heritage preservation; and,
  8. Serve as liaison between the Heritage Preservation Commission and the public, property owners, other City staff, the Council, and other government and non-governmental agencies in all matters pertaining to heritage preservation.
Please find the following descriptions of day-to-day duties of the HPO not illustrated above (Authorities, Requirements, and Processes):
  1. Prior to the 2011, the Land Development Code inconsistently included application submittal requirements that were often also inconsistent with actual practice.  With the 2011 Zoning Code, the submittal requirements for various development applications were removed from the text of the code - they are now prepared by staff and published separately.  This change was not done in the Heritage Preservation chapter.  The 2016 Zoning Code revisions changed the Heritage Preservation chapter to be consistent with other development application processes which in turn placed the preparation of submittal requirements with the HPO.  While the HPO has developed a “working version” that utilizes the requirements removed from the text of the code, the HPO is currently working with the Commission to finalize the requirements.
  2. The HPO follows approved projects to assure that what is built is consistent with what was approved.  The Building Inspectors seek confirmation of this from the HPO prior to issuance of a Certificate of Occupancy.
  3. As a Certified Local Government (CLG), SHPO consults with the City of Flagstaff when matters of preservation in Flagstaff come within their jurisdiction.  For private development, this is typically relative to the property tax incentives for historic preservation.  Such consultations are specifically directed to the HPO (ZC 10-20.20.060.G) and include discussions of development reviews, approvals, and processes by the City; the work proposed and performed; and often the opinion of the HPO as to appropriate actions by SHPO.
In addition to direction provided by the Zoning Code and the Standards, the HPO consults with SHPO as needed on matters of preservation in Flagstaff.  This typically involves assistance with interpretations of significance, integrity, impacts, or mitigation measures.

In developing the Zoning Code in 2011, the SHPO provided numerous materials and suggestions that were used to prepare the proposed programs and language of the code.  Prior to the adoption by the City Council, the SHPO reviewed and commented on the final draft of the Heritage Preservation chapter.  They recommend not excluding the building interiors from consideration and they commented on the use of the term "cultural resource" - suggesting the use of other terms such as "historic resource" and "archeological resource".
 
It may also be helpful to understand what HPO does not do:
  1. The HPO does not require the preparation of a Cultural Resource Study.  Cultural Resource Studies are required by the Zoning Code (ZC 10-30.30.050.A.2) and the role of the HPO (ZC 10-20.20.060.H) is simply to inform applicants of the requirement and to assist them in the process.
  2. Unlike other Arizona cities, the HPO does not decide if a resource is significant, nor does the HPO determine or impose mitigation measures.  With strict guidelines and under limited circumstances, the HPO may determine a lack of integrity or a lack of impacts (ZC 10-30.30.050.A.2.b).  The significance, integrity, impacts, and mitigation measures are determined by the consultants of applicants.
  3. The HPO works with applicants and consultants to initially determine the appropriate type and format of reports and what “level of report” (Letter Report, Phase 1, or Phase 2) is appropriate.  However, with the exception of Letter Reports, what is accepted, what is ultimately required, is determined by the Commission.
  4. Outside of the local historic districts, the HPO does not require that an applicant follow any preservation standards or guidelines.  However, if an applicant wishes to utilize the “no major impacts” exception (ZC 10-30.30.050.A.2.b), they are directed to the Standards.  The HPO provides technical advice when requested.

Attachments
Powerpoint Slides
At-a-Glance Flow Chart


    

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


Execution Time

Total Time Avg Time Count Template
235 ms 235 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
203 ms 203 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
172 ms 172 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
62 ms 62 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
32 ms 32 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2236, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
15 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
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_expincl.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
250 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 18:24:20.020
			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:24:20.020
				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:24:20.020
			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:24:20.020
				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:24:20.020
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 18:24:20.020
	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:24:20.020
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:24:20.020
		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:24:20.020
	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:24:20.020
		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:24:20.020
	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:24:20.020
	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:24:20.020
		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:24:20.020
		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:24:20.020
	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:24:20.020
	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:24:20.020
	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:24:20.020
	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:24:20.020
	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:24:20.020
	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:24:20.020
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 18:24:20.020
	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 @ 18:24:20.020
		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) = 2016-06-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2016-06-30 00:00:00.0

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

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

final_check (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 18:24:20.020
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 475 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 18:24:20.020
 		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:24:20.020
 		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:24:20.020
		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:24:20.020
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 476 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 476 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
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 = 475 AND agi._rowid = 70)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 476 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 70 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
		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:24:20.020
		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 = 70)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '70')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi13')
			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 @ 18:24:20.020
			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 = '70'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
			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 = 2236 AND
				      u.rev_num = 0 
getfi13 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi13'
			
fi13q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi13' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2016-06-28

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
		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 @ 18:24:20.020
		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 = 'keberhard'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2236 AND
      rev_num = 0
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
	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:24:20.020
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2236 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
	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 = 2236 AND
		  ad.rev_num = 0 
		  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:24:20.020
		SELECT * from codes where code_type ='asdfasdfasfa'
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
	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 = 2236 AND form_rte.rev_num = 0 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
	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 = 2236 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=32ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 18:24:20.020
		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 = 'AI70')
		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 = 2236 AND
			  hist.rev_num = 0 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:24:20.020
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 18:24:20.020
		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) = 476

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:24:20.020
				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 = 475 AND ai._rowid = 70)
				
				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 = 11621 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 18:24:20.020
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 475
					AND a.ag_level1 = '1'
					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:24:20.020
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 475
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '9'
					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:24:20.020
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 475
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '9'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 18:24:20.020
	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:24:20.020
	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:24:20.020
		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:24:20.020
		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=6&get_year=2016&dsp=agm&seq=2236&rev=0&ag=475&ln=11621&nseq=&nrev=&pseq=&prev=
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=6&get_year=2016&dsp=agm&seq=2236&rev=0&ag=475&ln=11621&nseq=&nrev=&pseq=&prev=
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=9567983
cftoken=ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
hitcount=4
lastvisit={ts '2024-05-06 18:24:20'}
timecreated={ts '2024-05-06 18:24:20'}
urltoken=CFID=9567983&CFTOKEN=ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
Cookie Variables:
CFID=9567983
CFTOKEN=ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
Form Fields:
ATT_TYPE=AG
DISPLAY_AG=475
DISPLAY_ID=2236
DISPLAY_REV=0
Session Variables:
cfid=9567983
cftoken=ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9567983_ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
subdir=/public/
tzoffset=0
urltoken=CFID=9567983&CFTOKEN=ab3af3314e3d4d0-264D5220-E63F-6781-10AA89D52AA8A275
URL Parameters:
ag=475
dsp=agm
get_month=6
get_year=2016
id=
ln=11621
mt=ALL
nrev=
nseq=
prev=
pseq=
rev=0
seq=2236
Debug Rendering Time: 15 ms