NOTICE AND AGENDA
 
BUDGET RETREAT/SPECIAL 
    COUNCIL MEETING

WEDNESDAY - THURSDAY
APRIL 26-27, 2017

 
  FLAGSTAFF AQUAPLEX
1702 NORTH FOURTH STREET
FLAGSTAFF, ARIZONA
             9:00 A.M. EACH DAY
BUDGET RETREAT 
             
1.

Call to Order

 
2. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
 
MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY

COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
 
3.   City Council FY 2018 Budget Retreat
 
  RECOMMENDED ACTION:
 
Present City Manager's Recommended Budget for Fiscal Year 2018 and receive Council direction.
 
4.

Adjournment
 

SPECIAL COUNCIL MEETING

 
1. Call to Order
 
2.   Consideration and Approval of Construction Manager at Risk Construction Services Agreement (CMAR):  CMAR 2017 Street Maintenance Project - GMP #2 - Chip Seal
 
  RECOMMENDED ACTION:
 
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with C and E Paving and Grading, LLC in an amount not to exceed $1,603,036.00 for Guaranteed Maximum Price (GMP) # 2 – Chip Seal.
2) Approve Change Order Authority to the City Manager in the amount of $160,303.00 (10% for GMP #2) to cover potential cost associated with unanticipated or additional items of work.
3) Authorize the City Manager to execute the necessary documents.
 
3.   Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement:  2017 Street Maintenance Project - GMP #1 - Overlay
 
  RECOMMENDED ACTION:
 
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with C and E Paving and Grading, LLC, in an amount not to exceed $2,695,631.29 for Guaranteed Maximum Price (GMP) #1 - Overlay projects.
2) Approve Change Order Authority to the City Manager in the amount of $269,563.00 (10% for GMP #1) to cover potential cost associated with unanticipated or additional items of work.
3) Authorize the City Manager to execute the necessary documents.
 
4.   Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement: Phase 1 Utility Improvements of the Road Repair and Street Safety Program (RR&SS) Bundle #2 (Beaver/Dale) project to be awarded to Eagle Mountain Construction Inc. in the amount of $1,969,771.19.
 
  RECOMMENDED ACTION:
 
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with Eagle Mountain Construction Inc. for a Contract Price of $1,969,771.19 and a contract time of 488 calendar days; and
2) Authorize the City Manager to execute the necessary documents.
 
5.   Consideration and Approval of Contract: Approve the Construction Contract with McDonald Brothers Construction in the amount of $1,637,898.50 for the Mike's Pike Water and Sewer Improvement Project (Project).
 
  RECOMMENDED ACTION:
 
1) Approve the construction contract with McDonald Brothers Construction in the amount of $1,637,898.50 (includes construction total of $1,547,898.50 and contract allowance of $90,000.00), and a contract time of 180 calendar days;
2) Approve Change Order Authority to the City Manager in the amount of $154,789.85 (10% of the contract amount, less allowance of $90,000.00); and
3) Authorize the City Manager to execute the necessary documents.
 
6. Public Participation

Public Participation enables the public to address the Council about an item that is not on the agenda. Comments relating to items that are on the agenda will be taken at the time that the item is discussed. If you wish to address the Council at this meeting, please complete a comment card and submit it to the recording clerk as soon as possible. Your name will be called when it is your turn to speak. You may address the Council up to three times throughout the meeting, including comments made during Public Participation. Please limit your remarks to three minutes per item to allow everyone an opportunity to speak. At the discretion of the Chair, ten or more persons present at the meeting and wishing to speak may appoint a representative who may have no more than fifteen minutes to speak. 
 
7. Informational Items and Reports from Council and Staff, Future Agenda Item Requests
 
8. Adjournment




 
 
CERTIFICATE OF POSTING OF NOTICE

The undersigned hereby certifies that a copy of the foregoing notice was duly posted at Flagstaff City Hall on                      , at                a.m./p.m. in accordance with the statement filed by the City Council with the City Clerk.

Dated this               day of                                       , 2017.



__________________________________________
Elizabeth A. Burke, MMC, City Clerk
                                            
 
3.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: Brandi Suda, Finance Director
Date: 04/20/2017
Meeting Date: 04/26/2017

TITLE:
City Council FY 2018 Budget Retreat
RECOMMENDED ACTION:
Present City Manager's Recommended Budget for Fiscal Year 2018 and receive Council direction.
Executive Summary:
Staff will presenting the City Manager's Recommended Budget for Fiscal Year 2018. The following information is included in the agenda materials:
  • Slide Presentations
  • Council Review Budget Book
  • Supplemental Materials:
    • Council Goals and Objectives
    • Council Goals and Objectives Matrices
    • Approved New Budget Requests by Council Goal and Objective
    • New Personnel Listing
Mayor and Council will receive a detailed agenda prior to the retreat which will include an index referencing page numbers in the agenda packet. 

Due to file size, the full budget reports including budget narratives can be accessed through the City’s S:\Drive.  You may access these files at City Hall, using the following link  S:\- City of Flagstaff\BUDGET 2018\April Retreat\Budget Reports.
Please contact Jason Cook if you need assistance accessing these files.
 
Executive Agenda - April 26 - 27, 2017
  1. Welcome and Council's Expectations
  2. Approach for FY 2018 Budget
  3. Budget Outlook/Overview
  4. FY 2018 New Investments by Council Goal
  5. Capital Improvement Program
  6. Council Discussion and Parking Lot
  7. Council Direction and Adds & Deletes
Financial Impact:
This Council Budget Retreat is to present the City Manager's Recommended Budget and received direction from Council on the FY 2018 Budget.
Policy Impact:
 The FY 2018 Budget is a guiding document for the financial plan of the City for next fiscal year.
Connection to Council Goal, Regional Plan and/or TeampFlatstaff Strategic Plan:
COUNCIL GOALS:
ECONOMIC DEVELOPMENT: Grow and strengthen a more equitable and resilient economy.
AFFORDABLE HOUSING: Support development and increase the inventory of public and private affordable housing for renters and home owners throughout the community.
SOCIAL JUSTICE: Advance social justice in our community. 
TRANSPORTATION AND OTHER PUBLIC INFRASTRUCTURE: Deliver quality community assets and continue to advocate and implement a highly performing multi-modal transportation system.
BUILDING AND ZONING/REGIONAL PLAN: Revise the zoning code to remove ambiguities, and ensure it is consistent with community values and the regional plan.
CLIMATE CHANGE: Take meaningful climate change action. 
WATER CONSERVATION: Become a national leader in water conservation in all sectors.
ENVIRONMENTAL AND NATURAL RESOURCES: Actively manage and protect all environmental and natural resources.
PERSONNEL: Attract and retain quality staff.
COMMUNITY OUTREACH: Enhance public transparency and accessibility.
TOWN AND GOWN: Enhance relationships between the city and institutions of higher education.  
CODE COMPLIANCE: Achieve comprehensive and equitable code compliance.
Previous Council Decision on This:
There was two previous Council budget retreats regarding the FY2018 budget on January 19, 2017 and February 16, 2007.

Attachments: PowerPoint Presentation
FY2018 Council Review Budget Book
Council Goals and Objectives
Matrix of Council Goals and Objectives
Approved New Budget Requests
New Personnel Listing
Minutes Attachments
No file(s) attached.

 
2.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: Adam Miele, Airport Program Manager
Date: 04/19/2017
Meeting Date: 04/26/2017

TITLE:
Consideration and Approval of Construction Manager at Risk Construction Services Agreement (CMAR):  CMAR 2017 Street Maintenance Project - GMP #2 - Chip Seal
RECOMMENDED ACTION:
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with C and E Paving and Grading, LLC in an amount not to exceed $1,603,036.00 for Guaranteed Maximum Price (GMP) # 2 – Chip Seal.
2) Approve Change Order Authority to the City Manager in the amount of $160,303.00 (10% for GMP #2) to cover potential cost associated with unanticipated or additional items of work.
3) Authorize the City Manager to execute the necessary documents.
Executive Summary:
 
The 2017 Street Maintenance project has been segmented into two phases. These construction phases are divided by the asphalt surface treatment types. The first phase, Phase 1, is comprised of minor concrete repair, utility collar grade adjustments, grinding / milling portions of the surface and repaving. The second phase, Phase 2, is comprised of applying a thin layer of hot asphalt and crushed stone. This thin asphalt surface treatment is commonly referred to as a chip seal.
 
This project has been developed through the City’s Construction Manager at Risk (CMAR) project delivery method. The CMAR process allows staff to work directly with the selected contractor (contractor selection was made by an open solicitation and evaluated by qualifications) and real-time construction estimates are given throughout the project development process. In working with the contractor, modifications are made to the scope of the project to ensure the overall project is within the allocated budget. The Guaranteed Maximum Price (GMP) developed through this process is typically made at the 60% plan development stage. Included in this GMP is a contingency line item (for both owner and contractor) to take care of bid overages, reasonably inferred items and other project related items that may arise during construction. Because the contractor proposes on these projects at the 60% plan stage, unknown conditions are likely present that necessitate the owner and contractor contingencies. Staff is also including City Manager Change Order Authority in the event that additional pavement preservation work needs to be done.
 
Approval of this Agreement will allow the City to complete construction of Phase 2 (GMP 2) of the 2017 Street Maintenance Program (Program). Phase 2 will consist of chip sealing on various roadways utilizing monies from the Highway User Revenue Fund (HURF) funding (Street Maintenance Section's annual ongoing and one-time budget). Following the passing of Proposition 406 (Road Repair and Street Safety ballot question in November 2014), the HURF funding has been allocated to chip seals for roadways throughout the city. 
 
Financial Impact:
Funding for GMP #2 is provided by the annual Street Maintenance Program and is funded in account 040-06-162-3073-6-4443 in FY17.

Contract Definitions per City of Flagstaff CMAR Agreement.

Owners Contingency - A fund to cover cost growth during the project used at the discretion of the Owner usually for costs that result from Owner directed changes or unforeseen Site conditions.  The amount of the Owner’s contingency shall be set solely by the Owner and shall be in addition to the Project costs included in CMAR’s GMP packages.  Use and management of the Owner’s contingency is described in Section 5.3.3.
  • Section 5.3.3 - Owner’s Contingency are funds to be used at the sole discretion of the Owner to cover any increases in Project costs that result from Owner directed changes or unforeseen Site conditions.  Owner’s Contingency shall be added to the GMP amount provided by CMAR, the sum of which shall be the full Contract Price for construction.  At the time that Owner’s Contingency is used the appropriate markups shall be applied.

CMAR's Contingency - A fund to cover cost growth during the Project used at the discretion of CMAR usually for costs that result from Project circumstances.  The amount of CMAR’s Contingency shall be negotiated as a separate line item in each GMP package.  Use and management of CMAR’s Contingency is described in Subsections 5.3.1 and 5.3.2.
  • Section 5.3.1 - CMAR’s Contingency is an amount CMAR may use at its sole discretion for, an increase in the Cost of Work, and may use for increases in General Conditions Costs with written approval of the City.  CMAR’s Contingency is assumed to be a direct Project cost and all applicable markups shall be applied at the time of GMP submission.
  • Section 5.3.2 - When CMAR utilizes CMAR’s Contingency funds, CMAR shall make the appropriate changes to the Schedule of Values with the next regular progress payment request.  CMAR shall deduct the amount of CMAR’s Contingency funds used from CMAR’s Contingency line item and add the same amount to the line item on the Schedule of Values where the funds were used.  If CMAR’s contingency funds are used for a new line item that was not given with the original Schedule of Values, these shall be so indicated.
Policy Impact:
No policy impacts will result from this project.

By approving this Agreement, improvements to the City’s existing infrastructure will improve the health, welfare and safety of the residents of Flagstaff.
 
Connection to Council Goal, Regional Plan and/or TeamFlagstaff Strategic Plan:
Transportation and Other Public Infrastructure – Approval of this Agreement will preserve and improve the City's roadway assets.
 
Regional Plan goals that apply include:
 Goal LU.7. Provide for public services and infrastructure.
 Goal LU.10. Increase the proportion of urban neighborhoods to achieve walkable, compact growth.
 Goal T.1. Improve mobility and access throughout the region.
 Goal T.2. Improve transportation safety and efficiency for all modes.
 Goal T.8. Establish a functional, safe, and aesthetic hierarchy of roads and streets.
Has There Been Previous Council Decision on This:
Yes:
  • In January 2016, Council approved the design phase services contract with Plateau Engineering, Inc.
  •  In April 2016, Council approved the construction of a multiple phased roadway project (2016 Street Maintenance Project) with the same contractor for this Agreement, C and E Paving and Grading, LLC.
  • In March 2015, Council approved the construction of a multiple phased roadway project (2015 Street Maintenance Project) with the same contractor for this Agreement, C and E Paving and Grading, LLC.
Options and Alternatives:
  1. Approve the CMAR Construction Phase 2 (GMP #2) Services Agreement as presented.
  2. Reject the CMAR Construction Phase 2 (GMP #2) Services Agreement and direct Staff to pursue traditional design-bid-build project delivery. This would negatively delay progress on the project by three to five months.
  3. Reject the CMAR construction Phase 2 (GMP #2) and defer all street maintenance until 2018.
Background and History:
The City has established an annual Street Maintenance Program (Program) to maintain existing streets.  This year, the Program will provide three major services: non-structural upgrades by overlay, Americans with Disabilities Act (ADA) compliance, and chip sealing. 

Improvements to the City’s streets are selected after evaluation of the street condition using pavement management software owned by the City.  One half of the City street pavements are evaluated and ranked each year.  Each street pavement segment is assigned an overall condition index (OCI) based on the type and severity of the distress observed.  A pavement that has no distress is given OCI of 100.  Each pavement distress such as cracking or roughness reduces the street’s OCI.  The street pavements are ranked by OCIs and the pavements exhibiting the most severe distress are programmed for replacement. OCIs that score within the middle range receive resurfacing with asphaltic concrete overlays as budget allows. Roadways with a higher OCI will receive a chip seal that provides a cost effective pavement preservation treatment to maintain newer pavements in a good condition.

In recent years, the Arizona State Legislature has authorized the use of Alternative Project Delivery Methods (APDM) in lieu of the traditional Design-Bid-Build method of project delivery.  These alternative methods, including CMAR, allow a contracting agency the opportunity to select a construction team utilizing a Qualifications Based Selection process to procure construction services from a firm deemed most qualified to perform the work.  The enabling legislation also allows for provision of multiple GMPs under a single procurement.   

On August 31, 2014, a Request for Statements of Qualifications for CMAR services was published in the Arizona Daily Sun and posted on the City’s Purchasing web site.  On September 23, 2014, the City received five Statements of Qualifications from firms wishing to provide CMAR services for the project.  A selection committee of five members independently reviewed and evaluated those statements in accordance with guidelines established by the enabling legislation.  Based on numerical evaluation of the statements received, the firm of C and E Paving and Grading, LLC, received the highest ranking and was deemed the most qualified among those submitting proposals to provide the desired design phase services. 

On November 18, 2014, Council approved an award of the CMAR Design Phase Services Contract for the 2015, 2016 and 2017 programs to C and E Paving & Grading, LLC in the amount of $112,821.00.  Design Phase Services including program and budget evaluation, project scheduling, design document reviews, constructability reviews, detailed cost estimating, and preparation of final construction documents have now been completed.  Based upon the Design Phase Services, C and E Paving & Grading, LLC, has provided GMPs to complete construction of the annual Program.  The GMP includes costs for construction, a CMAR contingency, owners contingency, construction fee, costs for General Conditions including bonds and insurance, and sales taxes.
 
Key Considerations:
The goal of the Program is to use the available funds in the most efficient manner to lengthen the service life of the City street pavements and avoid costly pavement reconstruction. Chip seal work provides a cost effective pavement preservation treatment to maintain newer pavements in a good condition.
Community Benefits and Considerations:
Funding for the pavement preservation portion of the Program GMP #2 is provided by the budget in FY 2016/2017. The Agreement includes an owner’s contingency of $50,000.00 and a contractor’s contingency of $50,000.00 (to be authorized by the owner) to cover the potential cost of unanticipated or additional work which may be required during construction.

 
Community Involvement:
The Program provides surface treatments as required to preserve and maintain pavement condition on the 664 lane miles of asphalt City streets.  The ADA improvements provide improved access for disabled citizens and visitors along existing streets and provide compliance with Federal requirements.
 
Previous Councils have approved programs in the 2015 and 2016 fiscal years which were a great success. These programs utilized 2014 voter approved sales tax funds (59 streets or 45 lane miles of overlay and 1 street or 1.2 miles of repaving). In addition to the sales tax funds, HURF funds were utilized (267 streets or 178 lane miles in chip sealing).

Use of the CMAR method of project delivery will eliminate the need for an advertisement/bid/award process and will cut approximately two months off the project development schedule.  In addition, value engineering, constructability reviews and design input conducted as part of this service agreement have the potential to realize significant construction cost savings over the traditional design-bid-build delivery method.
Expanded Options and Alternatives:
Inform - The Public Works Division will prepare weekly news releases to be distributed to the local media outlets describing the location of the street construction and any traffic restrictions planned for the week.  The contractor will distribute written notices to all the adjacent businesses and residents in advance of the construction.

Attachments: CMAR Contract
GMP Summary
Map
Minutes Attachments
No file(s) attached.

 
3.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: Adam Miele, Airport Program Manager
Date: 04/19/2017
Meeting Date: 04/26/2017

TITLE:
Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement:  2017 Street Maintenance Project - GMP #1 - Overlay
RECOMMENDED ACTION:
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with C and E Paving and Grading, LLC, in an amount not to exceed $2,695,631.29 for Guaranteed Maximum Price (GMP) #1 - Overlay projects.
2) Approve Change Order Authority to the City Manager in the amount of $269,563.00 (10% for GMP #1) to cover potential cost associated with unanticipated or additional items of work.
3) Authorize the City Manager to execute the necessary documents.
Executive Summary:
 
The 2017 Street Maintenance project has been segmented into two phases. These construction phases are divided by the asphalt surface treatment types. The first phase, Phase 1, is comprised of minor concrete repair, utility collar grade adjustments, grinding / milling portions of the surface and repaving. The second phase, Phase 2, is comprised of applying a thin layer of hot asphalt and crushed stone. This thin asphalt surface treatment is commonly referred to as a chip seal.
 
This project has been developed through the City’s Construction Manager at Risk (CMAR) project delivery method. The CMAR process allows staff to work directly with the selected contractor (contractor selection was made by an open solicitation and evaluated by qualifications) and real-time construction estimates are given throughout the project development process. In working with the contractor, modifications are made to the scope of the project to ensure the overall project is within the allocated budget. The Guaranteed Maximum Price (GMP) developed through this process is typically made at the 60% plan development stage. Included in this GMP is a contingency line item (for both owner and contractor) to take care of bid overages, reasonably inferred items and other project related items that may arise during construction. Because the contractor proposes on these projects at the 60% plan stage, unknown conditions are likely present that necessitate the owner and contractor contingencies. Staff is also including City Manager Change Order Authority in the event that additional pavement preservation work needs to be done.
 
Approval of this Agreement will allow the City to complete construction of Phase 1 (GMP #1) of the 2017 Street Maintenance Program (Program). The funding for this project is from the approved Prop 406 Road Repair and Street Safety ballot question, which was approved by voters in 2014.
Financial Impact:
Funding for Phase 1 (GMP #1) is provided by the Proposition 406 funded in account: 040-06-163-3321-6-4443 in FY17.

Contract Definitions per City of Flagstaff CMAR Agreement.

Owners Contingency - A fund to cover cost growth during the project used at the discretion of the Owner usually for costs that result from Owner directed changes or unforeseen Site conditions.  The amount of the Owner’s contingency shall be set solely by the Owner and shall be in addition to the Project costs included in CMAR’s GMP packages.  Use and management of the Owner’s contingency is described in Section 5.3.3.
  • Section 5.3.3 - Owner’s Contingency are funds to be used at the sole discretion of the Owner to cover any increases in Project costs that result from Owner directed changes or unforeseen Site conditions.  Owner’s Contingency shall be added to the GMP amount provided by CMAR, the sum of which shall be the full Contract Price for construction.  At the time that Owner’s Contingency is used the appropriate markups shall be applied.

CMAR's Contingency - A fund to cover cost growth during the Project used at the discretion of CMAR usually for costs that result from Project circumstances.  The amount of CMAR’s Contingency shall be negotiated as a separate line item in each GMP package.  Use and management of CMAR’s Contingency is described in Subsections 5.3.1 and 5.3.2.
  • Section 5.3.1 - CMAR’s Contingency is an amount CMAR may use at its sole discretion for, an increase in the Cost of Work, and may use for increases in General Conditions Costs with written approval of the City.  CMAR’s Contingency is assumed to be a direct Project cost and all applicable markups shall be applied at the time of GMP submission.
  • Section 5.3.2 - When CMAR utilizes CMAR’s Contingency funds, CMAR shall make the appropriate changes to the Schedule of Values with the next regular progress payment request.  CMAR shall deduct the amount of CMAR’s Contingency funds used from CMAR’s Contingency line item and add the same amount to the line item on the Schedule of Values where the funds were used.  If CMAR’s contingency funds are used for a new line item that was not given with the original Schedule of Values, these shall be so indicated.
Policy Impact:
No policy impacts will result from this project.

By approving this Agreement, improvements to the City’s existing infrastructure will improve the health, welfare and safety of the residents of Flagstaff.
 
Connection to Council Goal, Regional Plan and/or TeamFlagstaff Strategic Plan:
Transportation and Other Public Infrastructure – This Agreement will preserve and improve the community’s roadway assets.

Regional Plan goals that apply include:
 Goal LU.7. Provide for public services and infrastructure.
 Goal LU.10. Increase the proportion of urban neighborhoods to achieve walkable, compact growth.
 Goal T.1. Improve mobility and access throughout the region.
 Goal T.2. Improve transportation safety and efficiency for all modes.
 Goal T.8. Establish a functional, safe, and aesthetic hierarchy of roads and streets.
Has There Been Previous Council Decision on This:
Yes:
  • In January 2016, Council approved the design phase services contract with Plateau Engineering, Inc.
  •  In April 2016, Council approved the construction of a multiple phased roadway project (2016 Street Maintenance Project) with the same contractor for this Agreement, C and E Paving and Grading, LLC.
  • In March 2015, Council approved the construction of a multiple phased roadway project (2015 Street Maintenance Project) with the same contractor for this Agreement, C and E Paving and Grading, LLC.
Options and Alternatives:
  1. Approve the CMAR Construction Phase 1 (GMP #1) Services Agreement as presented.
  2. Reject the CMAR Construction Phase 1 (GMP #1) Services Agreement and direct Staff to pursue traditional design-bid-build project delivery. This would delay progress on the project by two to five months.
  3. Reject the CMAR construction Phase 1 (GMP #1) and defer all street maintenance until 2018.
Background and History:
The City has established an annual Street Maintenance Program (Program) to maintain existing streets.  This year, the Program will provide three major services: non-structural upgrades by overlay (Prop. 406 funding), Americans with Disabilities Act (ADA) compliance (Prop. 406 funding), and chip sealing (HURF funding).
 
Improvements to the City’s streets are selected after evaluation of the street condition using pavement management software owned by the City.  One half of the City street pavements are evaluated and ranked each year.  Each street pavement  segment is assigned an overall condition index (OCI) based on the type and severity of the distress observed.  A pavement that has no distress is given OCI of 100.  Each pavement distress such as cracking or roughness reduces the street’s OCI.  The street pavements are ranked by OCIs and the pavements exhibiting the most severe distress are programmed for replacement. OCIs that score within the middle range receive resurfacing with asphaltic concrete overlays as budget allows. Roadways with a higher OCI will receive a Chip seal that provides a cost effective pavement preservation treatment to maintain newer pavements in a good condition.
 
In recent years, the Arizona State Legislature has authorized the use of Alternative Project Delivery Methods (APDM) in lieu of the traditional Design-Bid-Build method of project delivery.  These alternative methods, including CMAR, allow a contracting agency the opportunity to select a construction team utilizing a Qualifications Based selection process to procure construction services from a firm deemed most qualified to perform the work.  The enabling legislation also allows for provision of multiple GMPs under a single procurement.  

On August 31, 2014, a Request for Statements of Qualifications for CMAR services was published in the Arizona Daily Sun and posted on the City’s Purchasing web site.  On September 23, 2014, the City of Flagstaff received five Statements of Qualifications from firms wishing to provide CMAR services for the project.  A selection committee of five members independently reviewed and evaluated those statements in accordance with guidelines established by the enabling legislation.  Based on numerical evaluation of the statements received, the firm of C and E Paving and Grading, LLC, received the highest ranking and was deemed the most qualified among those submitting proposals to provide the desired design phase services. 

On November 18, 2014, Council approved an award of the CMAR Design Phase Services Contract for the 2015, 2016 and 2017 programs to C and E Paving & Grading, LLC in the amount of $112,821.00.  Design Phase Services including program and budget evaluation, project scheduling, design document reviews, constructability reviews, detailed cost estimating, and preparation of final construction documents have now been completed.  Based upon the Design Phase Services, C and E Paving & Grading, LLC, has provided GMPs to complete construction of the annual Program.  The GMP includes costs for construction, a CMAR contingency, owners contingency, construction fee, costs for General Conditions including bonds and insurance, and sales taxes.
 
Key Considerations:
The goal of the Program is to use the available funds in the most efficient manner to lengthen the service life of the City street pavements and avoid costly pavement reconstruction.  Overlay work provides a cost effective pavement preservation treatment to maintain older and oxidized pavements in a good condition. Chip seal work provides a cost effective pavement preservation treatment to maintain newer pavements in a good condition.
 
Community Benefits and Considerations:
Funding for the pavement preservation portion of the Program GMP #1 is provided by the budget in FY 2016/2017. The Agreement includes an owner’s contingency of $50,000.00 and a contractor’s contingency of $50,000.00 (to be authorized by the owner) to cover the potential cost of unanticipated or additional work which may be required during construction.
Community Involvement:
The Program provides surface treatments as required to preserve and maintain pavement condition on the 664 lane miles of asphalt City streets. The ADA improvements provide improved access for disabled citizens and visitors along existing streets and provide compliance with Federal requirements.
 
Use of the CMAR method of project delivery eases the need for a traditional advertisement/bid/award process and cuts approximately two months off the project development schedule.  In addition, value engineering, constructability reviews and design input conducted as part of this service agreement have the potential to realize significant construction cost savings over the traditional design-bid-build delivery method.
Expanded Options and Alternatives:
Inform - The Public Works Division will prepare weekly news releases to be distributed to the local media outlets describing the location of the street construction and any traffic restrictions planned for the week.  The contractor will distribute written notices to all the adjacent businesses and residents in advance of the construction. In addition, site maps of the streets planned for construction activities will be provided on the City's website.

Attachments: CMAR Contract
GMP Overlay
Map
Minutes Attachments
No file(s) attached.

 
4.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: Eli Reisner, Project Manager - ER
Date: 04/19/2017
Meeting Date: 04/26/2017

TITLE:
Consideration and Approval of Construction Manager at Risk (CMAR) Construction Services Agreement: Phase 1 Utility Improvements of the Road Repair and Street Safety Program (RR&SS) Bundle #2 (Beaver/Dale) project to be awarded to Eagle Mountain Construction Inc. in the amount of $1,969,771.19.
RECOMMENDED ACTION:
1) Approve the Construction Manager at Risk Construction Services Agreement (Agreement) with Eagle Mountain Construction Inc. for a Contract Price of $1,969,771.19 and a contract time of 488 calendar days; and
2) Authorize the City Manager to execute the necessary documents.
Executive Summary:
Staff recommends a Construction Manager at Risk (CMAR) construction contract award of $1,969,771.19 to Eagle Mountain Construction, Inc. (EMC) to complete Phase 1 Utility Improvements of the RR&SS Bundle #2 (Beaver/Dale) project, which includes water main, water services, fire hydrants, sewer main, sewer services, underground traffic signal conduit, and street lights with underground electric.  Phase 2, the Roadway Improvements portion of the project, will be presented for Council’s consideration on June 20, 2017.  Pending Council's approval, construction is anticipated to begin May 2017 for Phase 1 and in July 2017 for Phase 2.  Both phases are to be completed by August 2018.  Please refer to attached context and vicinity maps.
Financial Impact:
The RR&SS Bundle #2 (Beaver/Dale) project is funded by the total budget appropriations of $9,144,212.00 (includes FY 17 budget and FY 18 proposed budget) from the Road Repair and Street Safety – Utility Replacements and Overlays Fund.  The other funding sources are $16,000.00 from NAIPTA for temporary bus stops, $100,000.00 from the Transportation Tax Fund for street lighting and conduit, and $100,000.00 from the Aging Water Infrastructure Replacement Fund (Account # 202-08-370-3157-0-4463) for new waterline infrastructure on Beaver St. south of Cherry Ave. Contract Definitions per City of Flagstaff CMAR Construction Services Agreement. Owners Contingency - A fund to cover cost growth during the project used at the discretion of the Owner usually for costs that result from Owner directed changes or unforeseen Site conditions.  The amount of the Owner’s contingency shall be set solely by the Owner and shall be in addition to the Project costs included in CMAR’s GMP packages.  Use and management of the Owner’s contingency is described in Section 5.3.3.
  • Section 5.3.3 - Owner’s Contingency are funds to be used at the sole discretion of the Owner to cover any increases in Project costs that result from Owner directed changes or unforeseen Site conditions.  Owner’s Contingency shall be added to the GMP amount provided by CMAR, the sum of which shall be the full Contract Price for construction.  At the time that Owner’s Contingency is used the appropriate markups shall be applied.
CMAR's Contingency - A fund to cover cost growth during the Project used at the discretion of CMAR usually for costs that result from Project circumstances.  The amount of CMAR’s Contingency shall be negotiated as a separate line item in each GMP package.  Use and management of CMAR’s Contingency is described in Subsections 5.3.1 and 5.3.2.
  • Section 5.3.1 - CMAR’s Contingency is an amount CMAR may use at its sole discretion for, an increase in the Cost of Work, and may use for increases in General Conditions Costs with written approval of the City.  CMAR’s Contingency is assumed to be a direct Project cost and all applicable markups shall be applied at the time of GMP submission.
  • Section 5.3.2 - When CMAR utilizes CMAR’s Contingency funds, CMAR shall make the appropriate changes to the Schedule of Values with the next regular progress payment request.  CMAR shall deduct the amount of CMAR’s Contingency funds used from CMAR’s Contingency line item and add the same amount to the line item on the Schedule of Values where the funds were used.  If CMAR’s contingency funds are used for a new line item that was not given with the original Schedule of Values, these shall be so indicated.
     
Policy Impact:
No Impact.
Connection to Council Goal, Regional Plan and/or TeamFlagstaff Strategic Plan:
COUNCIL GOALS:
Transportation and Other Public Infrastructure:

Deliver quality community assets and continue to advocate and implement a highly performing multi-modal transportation system.

  • Replacement of aging infrastructure
REGIONAL PLAN:
Goal T.8. Establish a functional, safe, and aesthetic hierarchy of roads and streets. 

TEAM FLAGSTAFF STRATEGIC PLAN:
Strategic priority #4: Work in partnership to enhance a safe and livable community
  1. Foster a safe, healthy, equitable and accessible community.
Has There Been Previous Council Decision on This:
  • Council previously approved the ballot language for the Road Repair and Street Safety Initiative (Prop. 406).
  • Council adopted the FY16 and FY17 budgets and these appropriations were included in those budgets.
  • Council approved the award of both Consultant Services and CMAR Design and Construction Phase Services contracts for the design of RR&SS Bundle #2 (Beaver/Dale) project to The WLB Group, Inc. (WLB) and to EMC, respectively, at the September 20, 2016 Council Meeting.
Options and Alternatives:
  1. Approve the award as recommended. Approval will allow work to move forward in calendar year 2017; or,
  2. Reject approval of the award as recommended.  This action would delay the project until next construction season.  If rejection occurs, possible options include:
             a.  Ask staff to re-evaluate the recommendation; or
             b.  Suspend or cancel the project completely.
Background and History:
On November 18, 2014, Council adopted the results of the General Election held on November 4, 2014.  In the General Election voters approved a dedicated sales tax increase, Proposition 406, which included funding for road repairs and street safety improvements throughout the City of Flagstaff.  Attached is the Road Repair and Street Safety Program Schedule for 2015 - 2022.  Beaver St. and Dale Ave. both qualified to receive pavement and utility improvements and their proximity made them ideal projects to combine into Bundle #2 of the Road Repair and Street Safety Program.

Phase 1 Utility Improvements consist of upgrading the existing water main and water services in Beaver St., upgrading the existing water services and extending stubbed out water mains in Dale Ave., upgrading select existing sections of sewer main, upgrading the existing sewer services, installing new underground traffic signal conduit in Beaver St., and installing new street lights with underground electric on Beaver St.

Phase 2 roadway improvements consist of upgrading the underground storm water system in Sullivan Ave. and Hunt Ave. from Beaver St. to Humphreys St. to improve drainage, re-building the roadway section on Beaver St., rebuilding portions of the roadway section on Dale Ave. to relieve the extreme cross slope, milling and overlaying the roadway on Dale Ave. where possible, replacing select curb and gutter, replacing select concrete sidewalk, replacing select sidewalk ramps, and resetting tree grates and select sidewalk brick in the downtown area on Beaver St. The Purchasing Section solicited a Request for Statement of Qualifications (RSOQ) for a CMAR Contractor.  Statement of Qualifications were evaluated and EMC was selected to provide CMAR design and construction phase services.  EMC performed CMAR design phase services with the goal of developing a Guaranteed Maximum Price (GMP) for both Phase 1 and Phase 2.
Key Considerations:
Staff identified the following items, and associated costs, as not being eligible to be constructed with Road Repair and Street Safety funds:
  • New street lights, poles, and underground electric on Beaver St.
  • New traffic signal conduit in Beaver St.
  • New waterline (that does not currently exist) in Beaver St. from Cherry Ave. to Birch Ave. outside the original project limits.
Separate funding sources have been identified to pay or reimburse the costs for the above identified items.

The Construction Manager at Risk (CMAR) method of procurement was selected to expedite the design and construction schedule and to accommodate complex sequencing of construction activities for a complex project with limits in an established neighborhood and the downtown district.  Pending Councils approval of this contract, the CMAR method of procurement will potentially allow underground utility construction to begin two months ahead of the original schedule.  The CMAR process is a collaborative effort, which allows for open dialog between the City, the design consultant, and the contractor on critical design and construction issues to minimize impacts to the community during construction.  The contractor will be intimately involved with the coordination of construction activities and keeping the stakeholders informed on schedule, sequence, and impacts.  488 calendar days is for both Phase 1 and Phase 2 to be complete by end of August 2018.
 
Community Benefits and Considerations:
The Guaranteed Maximum Price (GMP) is $1,875,972.56 plus a 5% Owners Contingency of $93,798.63 which equals the total contract amount of $1,969,771.19.
The City of Flagstaff is the Owner.
Community Involvement:
  • Replacement of aged water and sewer infrastructure, with some existing utilities dated 1919, to meet current standards.
  • Improving fire flows and increasing the water capacity in the downtown area to accommodate future growth by replacing the existing 8” water main with a 12” water main in Beaver St. from Columbus Ave. to Birch Ave.
  • Installation of new underground traffic signal conduit on Beaver St. for future traffic signal connections from Columbus Ave. to Birch Ave.
  • New Streetlights with underground electric on Beaver St. (Columbus to Cherry).
  • The project will reduce the infrastructure maintenance in the project area.
  • Construction coordination with two City projects to minimize inconveniences to the downtown area and the public.
  • Phase 2 - replacement of aging asphalt pavement that can no longer be maintained with a chip seal or pavement overlay.
Expanded Options and Alternatives:
Inform, Involve, Empower:
  • In November 2014, voters approved a dedicated sales tax increase to fund road repair and street safety improvements throughout the City of Flagstaff.
  • The City of Flagstaff notified the public of the upcoming project in the summer and winter 2016 Cityscape.
  • The project is shown in the interactive map located under the Road Repair and Street Safety Updates on the City of Flagstaff’s Website at: http://www.flagstaff.az.gov/index.aspx?nid=3210
  • In September 2016, staff sent temporary entry permit requests and project notices to approximately 80 property owners adjacent to the project.
  • The City of Flagstaff’s Capital Improvements Engineer presented an update of the Road Repair and Street Safety Program, which included the RR&SS Bundle #2 (Beaver/Dale) project, at the February 1, 2017 Transportation Commission Meeting.
  • The Project Stakeholders, ADOT, FUSD, NAIPTA, Flagstaff Medical Center, and all First Responders were notified of the upcoming project and were asked to provide their input and concerns with the project.  They were also consulted with during the development of the traffic control plan for the project.
  • A public meeting was held on March 30th, 2017 at City Hall.  City Staff, EMC, and WLB were in attendance.  City Staff presented the Project and held discussions with residents and business owners from the neighborhood.
  • Staff, EMC, and WLB met with the Downtown Business Alliance (DBA) Members to present and discuss the Project at the April 3rd DBA Meeting.
  • Staff has met with individual property/business owners and will continue to do so through construction.
     

Attachments: CMAR Contract
GMP
RR&SS Program Schedule
Context
Vicinity Map
Minutes Attachments
No file(s) attached.

 
5.
         
CITY OF FLAGSTAFF
STAFF SUMMARY REPORT
To: The Honorable Mayor and Council
From: Christine Cameron, Project Manager III
Date: 04/19/2017
Meeting Date: 04/26/2017

TITLE:
Consideration and Approval of Contract: Approve the Construction Contract with McDonald Brothers Construction in the amount of $1,637,898.50 for the Mike's Pike Water and Sewer Improvement Project (Project).
RECOMMENDED ACTION:
1) Approve the construction contract with McDonald Brothers Construction in the amount of $1,637,898.50 (includes construction total of $1,547,898.50 and contract allowance of $90,000.00), and a contract time of 180 calendar days;
2) Approve Change Order Authority to the City Manager in the amount of $154,789.85 (10% of the contract amount, less allowance of $90,000.00); and
3) Authorize the City Manager to execute the necessary documents.
Executive Summary:
A contract award of $1,637,898.50 to McDonald Brothers Construction is proposed to construct the Mike's Pike Water and Sewer Improvement Project, which includes replacement of aging water and sewer mains and services, roadway pavement, curb, gutter, sidewalk, and street lights on Mike's Pike, Kendrick Street, Benton Avenue, and Phoenix Avenue. The Project is planned for construction from May to November 2017. Please see attached context and vicinity map.  
Financial Impact:
The Mike's Pike Improvement Project is funded by Utility Program budget appropriations in the amount of $100,000 for FY 2017 and anticipated FY 2018 funding in the amount of $2,250,000, Account #203-08-375-3367-0. Anticipated FY 18 funding will be covered by the Aging Sewer Replacement funds and Capacity fees. Core Campus, the developer of the HUB on Campus Flagstaff, will be providing funding to cover the development’s share of expenditures for utilities and roadway improvements along the frontage of their property.


  SUMMARY
Total Bid Cost of all Construction Items $1,547,898.50
Contract Allowance       $90,000.00
Total Contract Award Request  $1,637,898.50
Administrative (City Manager's) Change Order Authority Approval Request      $154,789.85 

Contract Allowance and Administrative (City Manager) Change Order Authority Definitions per City of Flagstaff City Manager's Directive No. 2-021 dated 09/22/08:

Contract Allowance: Contract allowances of 5%, 7.5%, or 10% may be added to all design and construction contracts. The allowance is based on the Engineer's estimate and will be included in design contracts for recommendation of award by City Council. The allowance will also be included in the bid for construction contracts for recommendation of award by City Council.
 
CONTRACT AMOUNT CONTRACT ALLOWANCE
Over $1,000,000 in value Allowance of 5%
From $999,999.99 to $250,000 Allowance of 7.5%
From $249,999.99 or lower Allowance of 10%

Administrative Change Orders (City Manager Change Order Authority): A ten-percent (10%) Administrative (City Manager) Change Order (ACO) amount may be included in all design and construction contracts to be considered by the City Council. The ACO amount is 10% of the total contract less the Contract Allowance amount. The ACO shall not exceed $500,000. 
Policy Impact:
• No impact.
Connection to Council Goal, Regional Plan and/or TeamFlagstaff Strategic Plan:
COUNCIL GOALS:
TRANSPORTATION AND OTHER PUBLIC INFRASTRUCTURE - Deliver quality community assets and continue to advocate and implement a highly performing multi-modal transportation system.
Has There Been Previous Council Decision on This:
Council approved the on-call consultant contract, through which a consultant services contract for the design of the Mike's Pike Improvement Project was established with The WLB Group, Inc.
Options and Alternatives:
1. Approve the award as recommended. Approval will allow work to move forward in calendar year 2017 or,
2. Reject all bids. This action would delay the Project. If rejection occurs, possible options Include:
          a) Re-advertise the Project and open new bids;
          b) Suspend or cancel the Project.
Background and History:
The Mike's Pike Improvement Project is located in downtown Flagstaff and includes work on Mike's Pike, Phoenix Avenue, Kendrick Street, and Benton Avenue. The Project scope includes replacement of aging water and sewer mains and services, street asphalt reconstruction, and new curb, gutter, sidewalk, driveways, and streetlights.  The Purchasing Section solicited for construction bids on March 6, 2017 on the City's website and on Purchasing's electronic bidding website, and the bid was advertised in the Arizona Daily Sun on March 12 and 19, 2017. Three bids were received by the opening date of March 29, 2017 and McDonald Brothers Construction was determined to be the lowest responsive and responsible bidder. A tabulation of bids is summarized below in Expanded Financial Considerations.
Key Considerations:
The Project is planned and programmed in the Utilities' ten-year Capital expenditure program for aging infrastructure due to the age and condition of the facilities. The water main was constructed in 1906 and the sewer main was constructed in 1919. With the inception and development of the HUB on Campus Project, the Utilities Program investigated the opportunity to combine the projects to accomplish the work earlier during the HUB construction and cost share on the construction of the project.  The City was able to advance the Mike's Pike infrastructure improvements in the planning schedule to coincide with the HUB project and expedite the utility and roadway construction during the building construction.

The Core Campus developer will be contributing funding for the new construction improvements along the frontage of the development. Funded construction items include water and sewer mains, services, manholes, asphalt roadway, sidewalk, curb, gutter, and driveways.

The future Rio de Flag Flood Control Project main line culvert is planned to be installed down Mike's Pike. Installation of the box structure will necessitate relocations of existing utilities that are in conflict with the future culvert. This Project will relocate the water and sewer mains ahead of the construction of the Rio de Flag Project.    

There are several coordination items included in the construction contract due to the street traffic and nature of the businesses along Mike's Pike. The contractor is required to accommodate businesses during operating hours, keep a minimum one lane of traffic open at all times during normal business hours, and provide safe pedestrian access to buildings. Full road closures are only allowed from 10:30 pm to 6:00 am, which will keep NAIPTA transit in regular operation and reduce impacts. The City is aware that this project will impact the business and resident operations along the corridor and the Contractor and the City will work diligently to avoid and mitigate any issues that arise during construction.

Included in the contract amount will be an allowance of $90,000.00.  The allowance will be used for items of work that were unanticipated but necessary to complete the Project. The Project Manager, Section Head and Division Head will have the authority to approve the use of the allowance. 

Change Order Authority establishes a dollar amount of $154,789.85 (10% of the contract amount, less allowance of $90,000.00) to provide the City Manager, on behalf of the Council, authority to amend the contract amount in response to unforeseen costs that are more than the contracted amount and in excess of the contract allowance.
Community Benefits and Considerations:
Below is a summary of bids received. Contractor totals include $90,000.00 contract allowance.
 
Engineer's Estimate $1,750,000.00
McDonald Brothers Construction $1,637,898.50
Standard Construction $1,885,256.00
Kinkaid Civil Construction $1,929,568.75

The Mike's Pike Improvement Project is funded by Utility Program budget appropriations in the amount of $100,000 for FY 2017 and anticipated FY 2018 funding in the amount of $2,250,000. Account #203-08-375-3367-0. Anticipated FY 18 funding will be covered by the Aging Sewer Replacement funds and Capacity fees. Core Campus, the developer for the HUB on Campus Flagstaff will be providing funding to cover the development’s share of expenditures for utilities and roadway improvements along the frontage of their property.
Community Involvement:
The community benefits of this project include the following:
  • Updated utility mains and services
  • New roadway and concrete improvements
  • New pedestrian facilities
  • New street lighting
  • Early coordination of future Rio de Flag construction requirements
  • Funding benefit from the Core Campus developer
Expanded Options and Alternatives:
Inform/Involve - In December 2016, City staff mailed an informational flyer to the surrounding neighborhood describing the Project and inviting the community to a Public Open House to learn about the project and provide feed back. Staff held the open house on December 15 in City Hall. City Capital staff has also been conducting one-on-one contact through the neighborhood and will continue to coordinate the construction work and schedule throughout the duration of the Project. The City has held on-going meetings with NAIPTA to minimize the impact of construction to their transit routes.

Attachments: Construction Contract
Mike's Pike Context map
Mike's Pike Vicinity Map
Minutes Attachments
No file(s) attached.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /print_all.cfm
Time Stamp 04-May-24 11:25 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
1168 ms 1168 ms 1 D:/inetpub/PublicPages/print_all.cfm
891 ms 178 ms 5 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
309 ms 62 ms 5 D:/inetpub/PublicPages/public/publish/include_levels.cfm
95 ms 19 ms 5 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
94 ms 94 ms 1 D:/inetpub/PublicPages/public/publish/print_agenda_dsp.cfm
57 ms 11 ms 5 D:/inetpub/PublicPages/public/publish/flagstaff.cfm
32 ms 32 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2595, 2) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
32 ms 6 ms 5 D:/inetpub/PublicPages/public/publish/print_agenda_ud_load.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2638, 2) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2674, 2) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2699, 0) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgenda(576, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(2673, 2) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgLines(576) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
15 ms 15 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | fGetAGPaddingOptions([complex value], YES, AGPad) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 6 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
0 ms 0 ms 5 D:/inetpub/PublicPages/public/publish/print_agenda_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1183 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 @ 23:25:03.003
			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 @ 23:25:03.003
				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 @ 23:25:03.003
			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 @ 23:25:03.003
				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'
			
get_fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_all.cfm @ 23:25:03.003
	SELECT user_defined FROM fasinfo
all_codes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\print_all.cfm @ 23:25:03.003
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, dataSortOrder as sort_order,

		   c.misc_alpha2,
		   CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:03.003
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 23:25:03.003
	SELECT fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop, fas.routing_apprvl fas_routing_apprvl,
		   fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.final_stop fas_final_stop,
		   fas.date_final fas_date_final, fas.final_prt_date fas_final_prt_date, fas.form_num ag_num,
		   ft.* ,
		   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id, mt.meeting_type,
		   agt.ag_template_name, agt.ag_template_id, agt.ag_item_rowid, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   form_hist.stat_date as bo_date,
	 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo,
	 	   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_alpha6 dp_level_ai, c1.misc_alpha7 lvl_text_size, c1.misc_alpha9 printLine, 
	 	   	  c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all
	 	   
	 	   ,c2.misc_alpha2 level_descriptor, c3.descr custom_print_routine_name
	FROM fas
	INNER JOIN agenda AS ft ON (ft.form_num = fas.form_num)
	INNER JOIN form_hist ON (form_hist.form_id = fas.form_id AND
				form_hist.stat_action = 'ADD' AND
				form_hist.form_num = fas.form_num)
	INNER JOIN meetings AS m ON (m.meeting_id = ft.meeting_id)
	LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = ft.ag_template_id)
	LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = ft.text_size)
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = m.meeting_id)	
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = m.the_meeting_type)
	LEFT OUTER JOIN codes AS c3 ON (c3._rowid = ft.custom_print_routine)
	WHERE fas.form_id = 'AGENDA' AND
		  fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 576

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:03.003
		SELECT 'Alpha','Alpha','Alpha','Alpha', a.ag_punct
		FROM meetings, agenda a
		WHERE meetings.meeting_id = ? AND
		      a.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 577

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:03.003
 		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 @ 23:25:03.003
 		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 @ 23:25:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
checkField (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 23:25:03.003
		SELECT * from agenda_ln WHERE _rowid > 1 and _rowid < 5
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 23:25:03.003
		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 576

qryResults (Datasource=frsRO, Time=15ms, Records=14) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 23:25:03.003
	SELECT al._rowid ln_rowid, al.form_num, al.seq_num,  al.alt_ai_num, 
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.header_ln, al.footer_ln, al.page_br,	
		   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,
		   al.video_link,
		   ai.*,

		   am.ag_item_rowid, am.prt_exp_agenda, am.submitted_for, am.submitted_for_more, c1.descr ag_time_descr,
		   CASE WHEN al.header_ln = 'Y' THEN 1
		   		WHEN al.footer_ln = 'Y' THEN 3
		   		ELSE 2 END AS line_sort,
		   
		   as1.sort_seq sort_level1,
		   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.alt_ai_num IS NOT NULL then al.alt_ai_num 
		   		WHEN am.ainumber = '' then '-1'
				WHEN am.ainumber = '0' then '-1'
				WHEN am.ainumber IS NULL then '-1'
		   ELSE am.ainumber END AS sort_memo2,		   
		   
		   al.ag_size, al.ag_font, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
		   am.allow_comment, am.ainumber, al.ag_memo_id, al.ag_memo_rev, al.ag_line_status, c.descr status_desc, al.ag_subject, al.ag_title ag_heading,
		   al.left_justify, al.color_impact,
		   al.ag_area, aa.descr ag_area_desc, al.ag_subarea, asa.descr ag_subarea_desc, 
		   codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,	   
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_title ELSE '' END as ag_title,
		   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_action ELSE al.ag_action END as ag_action,
		   fu1.text_value skipAIprint
	FROM agenda_ln al
	INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
	INNER JOIN meetings m ON (m.meeting_id = a.meeting_id)	
	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 ss_ag_item AS ai ON (ai.form_num = al.form_num AND ai._rowid = am.ag_item_rowid)
	
	LEFT OUTER JOIN ag_area AS aa ON (aa.meeting_type = m.the_meeting_type AND aa.ag_area = al.ag_area and aa.obsolete <> 'Y')          
	LEFT OUTER JOIN area_subarea AS asa ON (asa.meeting_type = m.the_meeting_type AND asa.ag_area = al.ag_area and asa.ag_subarea = al.ag_subarea and asa.obsolete <> 'Y')
	LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = al.ag_line_status)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = al.ag_size)
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AG TIME' and c1.valid_code = am.ag_time)
	LEFT OUTER JOIN form_userdef AS fu1 ON (fu1.form_id = 'AG_MEMO' AND fu1.form_num = al.ag_memo_id AND fu1.rev_num = al.ag_memo_rev AND fu1.fld_label = 'Skip Printing AB#' and fu1.text_value = 'Y')
	
	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)))
	WHERE al.form_num = ?
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo, ln_rowid
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 576

getAgHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_all.cfm @ 23:25:03.003
	select * from getAgLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_all.cfm @ 23:25:03.003
	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgLines (Datasource=, Time=0ms, Records=12) in D:\inetpub\PublicPages\print_all.cfm @ 23:25:03.003
	select * from getAgLines where header_ln <> 'Y' and footer_ln <> 'Y'
	order by line_sort, sort_level1, sort_level2, sort_level3, sort_level4, sort_memo2, sort_memo
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:03.003
			select top 1 * from codes
		
qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 23:25:03.003
			select c.misc_alpha aHead_pad, c.misc_alpha2 aBody_pad, c.misc_alpha3 aAGItems_pad
			from codes c 
			where c.code_type = ? and 
			     c.valid_code = CAST(577 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = AGPad

AQLogo (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
		SELECT printed_logo, logo_plcmnt FROM getform
	
items (Datasource=frsRO, Time=16ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2699 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
				
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 23:25:03.003
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 77 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 2699 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2673 AND rev_num = 2 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
				
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 23:25:03.003
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 78 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 2673 AND
			rev_num = 2
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2674 AND rev_num = 2 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
				
getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 23:25:03.003
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 78 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 2674 AND
			rev_num = 2
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2595 AND rev_num = 2 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
				
getUserDef (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 23:25:03.003
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 78 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 2595 AND
			rev_num = 2
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 23:25:03.003
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 2638 AND rev_num = 2 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and 'Y' = 'Y') OR
			(seq_num = 3 and ' ' = 'Y') OR
			(seq_num = 4 and ' ' = 'Y') OR
			(seq_num = 5 and ' ' = 'Y') OR
			(seq_num = 6 and ' ' = 'Y') OR
			(seq_num = 7 and ' ' = 'Y'))
				ORDER BY seq_num
				
getUserDef (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 23:25:03.003
		SELECT au.*,
			   fu.seq_num, fu.fld_label, fu.code_type, fu.text_value, fu.text_block,
			   codes.descr, codes.large_misc_alpha
		FROM form_userdef fu
		INNER JOIN agi_userdef AS au ON (au.agi_rowid = 78 AND
										 au.code_type = fu.code_type AND au.ag_print = 'Y')
		LEFT OUTER JOIN codes ON (codes.code_type = fu.code_type AND codes.valid_code = fu.text_value)
		WHERE fu.form_id = 'ag_memo' AND
			form_num = 2638 AND
			rev_num = 2
		order by au.seq_num
	
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:25:03.003
	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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' 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) = 2699
Parameter #2(cf_sql_integer) = 0

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:03.003
 		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 @ 23:25:03.003
 		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 @ 23:25:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 577 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 577 AND
			  ss_ag_item.form_num = agenda.form_num
	
get_agi_temp (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 576 AND agi._rowid = 77)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 577 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 77 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 77)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '77')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi10')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '77'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 2699 AND
				      u.rev_num = 0 
getfi10 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
				SELECT * from get_userdef
				WHERE code_type = 'ud_fi10'
			
fi10q (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi10' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2017-04-26

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

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:03.003
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
					   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
					   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
					   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 576 AND ai._rowid = 77)
				
				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 = 14005 
chkLevel1 (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					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 @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '3'
					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 @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '1'
					AND a.ag_level2 = '3'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 23:25:03.003
		SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
			   ud.form_label, codes.descr, codes.large_misc_alpha
		FROM form_userdef AS u
		INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
		LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
		WHERE u.form_id = 'AG_MEMO' AND
			  u.form_num = 2699 AND
			  u.rev_num = 0 and
			  ud.form_label LIKE '%submitter%'
	
qryResults (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:25:03.003
	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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' 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) = 2673
Parameter #2(cf_sql_integer) = 2

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:03.003
 		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 @ 23:25:03.003
 		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 @ 23:25:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 577 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 577 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 @ 23:25:03.003
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 576 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 = 577 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 @ 23:25:03.003
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 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 @ 23:25:03.003
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi3')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '78'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 2673 AND
				      u.rev_num = 2 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
				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 @ 23:25:03.003
					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) = 2017-04-26

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

GetThisLine (Datasource=frsRO, Time=48ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:03.003
				SELECT am.form_num fas_form_num, al._rowid ln_rowid, al.form_num, al.seq_num,
					   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
					   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4, al.disp_level, am.ainumber,
					   as1.sort_seq sort_level1, al.ag_memo_id, al.ag_memo_rev, c1.descr ag_time_descr,
					   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl,
					   c2.misc_alpha7 lvl_text_size, c2.misc_alpha6 dp_level_ai, c3.long_descr px_size, c3.descr pdf_format,
							mt.agmemo_prefix, mt.agmemo_desc, a.disp_ainumber,
					   ai.*,
					   CASE WHEN al.ag_level2 != '' AND al.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,
					   CASE WHEN al.ag_level3 != '' AND al.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
					   CASE WHEN al.ag_level4 != '' AND al.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN al.ag_memo_id ELSE -1 END AS sort_memo,
					   CASE WHEN al.ag_memo_id IS NOT NULL THEN am.ag_time ELSE al.ag_time END as ag_time
				FROM agenda_ln al
				INNER JOIN agenda a ON (a.form_num = al.form_num AND a.rev_num = al.rev_num)
				LEFT OUTER JOIN ag_template AS agt ON (agt.ag_template_id = a.ag_template_id)
				LEFT OUTER JOIN meeting_type AS mt ON (mt.meeting_type = agt.meeting_type)
				LEFT OUTER JOIN ag_memo AS am ON (am.form_num = al.ag_memo_id AND am.rev_num = al.ag_memo_rev)
				LEFT OUTER JOIN fas ON (fas.form_id = 'AG_MEMO' AND fas.form_num = am.form_num AND fas.rev_num = am.rev_num)
				
				INNER JOIN ss_ag_item AS ai ON (ai.form_num = 576 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 = 13997 
chkLevel1 (Datasource=frsRO, Time=8ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					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 @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '2'
					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 @ 23:25:03.003
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '2'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 23:25:03.003
		SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
			   ud.form_label, codes.descr, codes.large_misc_alpha
		FROM form_userdef AS u
		INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
		LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
		WHERE u.form_id = 'AG_MEMO' AND
			  u.form_num = 2673 AND
			  u.rev_num = 2 and
			  ud.form_label LIKE '%submitter%'
	
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:25:03.003
	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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' 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) = 2674
Parameter #2(cf_sql_integer) = 2

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:03.003
 		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 @ 23:25:03.003
 		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 @ 23:25:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 577 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 577 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 @ 23:25:03.003
SELECT agi.*, mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type, mt.resolution_number mt_resolution_number, mt.num_label mt_num_label,
	   c.misc_alpha print_routine_program, c.misc_alpha2 pdfHeadersFooters, c.misc_alpha3 print_only_routine,
	   agt.text_size, agt.text_font, agt.ag_template_id, agt.disp_rteinfo,
	   agt.disp_ainumber, agt.print_num_ai , m.template_id 									
FROM meetings m, ag_template agt, meeting_type mt
	
	INNER JOIN ss_ag_item AS agi ON (agi.form_num = 576 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 = 577 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 @ 23:25:03.003
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'FLAG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT au.code_type au_code_type, c.misc_alpha sortRequired, au.*
		FROM user_define ud
		INNER JOIN agi_userdef as au ON (au.fld_name = ud.fld_name AND au.agi_rowid = 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 @ 23:25:03.003
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi3')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '78'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
			SELECT u._rowid AS ud_id, u.ud_rowid, u.code_type, u.text_value,
				   ud.form_label, codes.descr, codes.large_misc_alpha
			FROM form_userdef AS u
			INNER JOIN user_define AS ud ON (ud._rowid = u.ud_rowid)
			LEFT OUTER JOIN codes ON (codes.code_type = u.code_type AND codes.valid_code = u.text_value)
			WHERE UPPER(u.form_id) = 'AG_MEMO' AND
					  u.form_num = 2674 AND
				      u.rev_num = 2 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
				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 @ 23:25:03.003
					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) = 2017-04-26

getPXvalue (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'amiele'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2674 AND
      rev_num = 2
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT dept_code, dept_desc, review_comm FROM dist_dept
	
ReviewCommittee (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2674 AND ag_memo_dol.rev_num = 2
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT _rowid ag_doc_id, ag_doc_name, ag_doc_dir, ag_doc_link, sort_seq, confidentiality
		,'Y' as can_look, 'Y' as can_link
		
	FROM agenda_docs ad
	WHERE ad.form_num = 2674 AND
		  ad.rev_num = 2 
		  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 @ 23:25:03.003
		SELECT * from codes where code_type ='asdfasdfasfa'
	
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=17ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 2674 AND
		      rev_num = 2
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT _rowid stop_id, descr, form_rte.stop_id chkd_stop_id, form_rte.stop_seq
	FROM rte_stop
	LEFT OUTER JOIN form_rte ON (UPPER(form_rte.form_id) = 'AG_MEMO' AND form_rte.form_num = 2674 AND form_rte.rev_num = 2 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle, w.dflt_rte_stop			
	FROM form_hist
	LEFT OUTER JOIN websecur AS w ON (w.login_id = form_hist.action_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	WHERE UPPER(form_id) = 'AG_MEMO' AND
	      form_num = 2674 AND
		  rev_num = 2 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=11) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
		SELECT (hist.seq_num - 1) stop_seq, hist.stop_id, hist.action_by apprvl_id, hist.stat_date apprvl_date, 	
				hist.stat_action, hist.stat_action apprvl_stat, rte_stop.descr, rte_stop.prt_on_routing,
				de.fname, de.lname, de.title, fa.incl_originator		
		FROM form_hist hist
		INNER JOIN rte_stop ON (rte_stop._rowid = hist.stop_id AND rte_stop.prt_on_routing = 'Y')
		LEFT OUTER JOIN form_actions AS fa ON (UPPER(fa.form_id) = 'AG_MEMO' AND			
			                               fa.action_cd = '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 = 2674 AND
			  hist.rev_num = 2 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:03.003
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:04.004
		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) = 577

GetThisLine (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
				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 = 576 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 = 13998 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					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 @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '3'
					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=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '3'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 23:25:04.004
		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 u.form_id = 'AG_MEMO' AND
			  u.form_num = 2674 AND
			  u.rev_num = 2 and
			  ud.form_label LIKE '%submitter%'
	
qryResults (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:25:04.004
	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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' 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) = 2595
Parameter #2(cf_sql_integer) = 2

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:04.004
 		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 @ 23:25:04.004
 		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 @ 23:25:04.004
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 577 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 577 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 @ 23:25:04.004
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 = 576 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 = 577 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 @ 23:25:04.004
		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 @ 23:25:04.004
		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 @ 23:25:04.004
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi3')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '78'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
			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 = 2595 AND
				      u.rev_num = 2 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
				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 @ 23:25:04.004
					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) = 2017-04-26

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		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 = 'ereisner'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2595 AND
      rev_num = 2
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 @ 23:25:04.004
	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 @ 23:25:04.004
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2595 AND ag_memo_dol.rev_num = 2
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 = 2595 AND
		  ad.rev_num = 2 
		  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 @ 23:25:04.004
		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 @ 23:25:04.004
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=15ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 2595 AND
		      rev_num = 2
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 = 2595 AND form_rte.rev_num = 2 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 @ 23:25:04.004
	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 = 2595 AND
		  rev_num = 2 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=15) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		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 = 2595 AND
			  hist.rev_num = 2 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:04.004
		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) = 577

GetThisLine (Datasource=frsRO, Time=60ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
				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 = 576 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 = 13999 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					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=4ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '4'
					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 @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '4'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 23:25:04.004
		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 u.form_id = 'AG_MEMO' AND
			  u.form_num = 2595 AND
			  u.rev_num = 2 and
			  ud.form_label LIKE '%submitter%'
	
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 23:25:04.004
	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,
	 	   	  'largeText' lvl_text_size, 'Y' dp_level_ai, 'N' printMinutes, 'N' printLegal, 'N' dateSpelled, 'N' 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) = 2638
Parameter #2(cf_sql_integer) = 2

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 23:25:04.004
 		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 @ 23:25:04.004
 		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 @ 23:25:04.004
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
agendaChk (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 577 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 577 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 @ 23:25:04.004
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 = 576 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 = 577 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 @ 23:25:04.004
		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 @ 23:25:04.004
		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 @ 23:25:04.004
			SELECT code_type, valid_code, descr, long_descr, misc_alpha2, obsolete, dataSortOrder sort_order, create_date
			FROM codes WHERE code_type IN ('ud_fi3')
			AND (opt_form_id = '' OR opt_form_id IS NULL)
		
getAllUD (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
			SELECT au.code_type, au.field_type, au.query_name, au.fld_name, au.seq_num,
					au.fld_label, au.fld_print, au.lbl_placement, au.new_row, au.colspan,
					text_block, au.agm_print_plcmnt,au.agm_csen, au.verti_hori, au.verti_hori_cols,
					CASE WHEN au.fld_rqd = 'N' then '2' else '1' end as sortBy
			FROM agi_userdef AS au
			WHERE au.agi_rowid = '78'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
			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 = 2638 AND
				      u.rev_num = 2 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
				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 @ 23:25:04.004
					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) = 2017-04-26

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'largeText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT ee.fname + ' ' + ee.lname name,
			websecur.login_id, ee.title utitle, websecur.email, p.phone_no, p.phone_ext,
			dept.dept_desc, dept.dept_code, dd.div_code, dd.div_desc
		FROM websecur
		LEFT OUTER JOIN dist_empl AS ee ON (ee.empl_id = websecur.empl_id)
		LEFT OUTER JOIN dist_dept AS dept ON (dept.dept_code = ee.department)
		LEFT OUTER JOIN dept_div AS dd ON (dd.dept_code = ee.department AND
											dd.div_code = ee.division)
		LEFT OUTER JOIN phone AS p ON (p.empl_id = ee.empl_id AND p.is_primary = 'Y')
		WHERE websecur.login_id = 'ccameron'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 2638 AND
      rev_num = 2
ORDER BY seq_num
committees (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 @ 23:25:04.004
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 2638 AND ag_memo_dol.rev_num = 2
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 = 2638 AND
		  ad.rev_num = 2 
		  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 @ 23:25:04.004
		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 @ 23:25:04.004
		SELECT * FROM ag_item
		WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 2638 AND
		      rev_num = 2
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 = 2638 AND form_rte.rev_num = 2 AND form_rte.stop_id = rte_stop._rowid)
	WHERE UPPER(rte_grp) = 'AG_MEMO'
getorig (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	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 = 2638 AND
		  rev_num = 2 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=32ms, Records=11) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
		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 = 2638 AND
			  hist.rev_num = 2 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 23:25:04.004
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 23:25:04.004
		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) = 577

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
				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 = 576 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 = 14000 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND (a.ag_level2 = '' OR a.ag_level2 IS NULL)
					AND (a.ag_level3 = '' OR a.ag_level3 IS NULL)
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
chkLevel2 (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '5'
					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 @ 23:25:04.004
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 576
					AND a.ag_level1 = '2'
					AND a.ag_level2 = '5'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
coSubmitter (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\flagstaff.cfm @ 23:25:04.004
		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 u.form_id = 'AG_MEMO' AND
			  u.form_num = 2638 AND
			  u.rev_num = 2 and
			  ud.form_label LIKE '%submitter%'
	


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\print_all.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=//print_all.cfm?seq=576&reloaded=true&id=
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\print_all.cfm
QUERY_STRING=seq=576&reloaded=true&id=
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/print_all.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=9521560
cftoken=668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
hitcount=3
lastvisit={ts '2024-05-04 23:25:03'}
timecreated={ts '2024-05-04 23:25:03'}
urltoken=CFID=9521560&CFTOKEN=668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
Cookie Variables:
CFID=9521560
CFTOKEN=668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
Session Variables:
cfid=9521560
cftoken=668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9521560_668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
subdir=/public/
tzoffset=0
urltoken=CFID=9521560&CFTOKEN=668032901dd59c05-CA114382-ED6D-E320-9689B2DA0E60B120
URL Parameters:
id=
reloaded=true
seq=576
Debug Rendering Time: 16 ms