DRAFT AGENDA
 
REGULAR COUNCIL MEETING
TUESDAY

JUNE 4, 2019
  COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
4:30 P.M. AND 6:00 P.M.

 
4:30 P.M. MEETING
 
Individual Items on the 4:30 p.m. meeting agenda may be postponed to the 6:00 p.m. meeting.
             
1.
CALL TO ORDER

 
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
 
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this regular meeting, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
 
2. ROLL CALL
 
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
MAYOR EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY

COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
 
3.
PLEDGE OF ALLEGIANCE AND MISSION STATEMENT
 
MISSION STATEMENT
 
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
 
4. 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 tonight's 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.
 
             
5. PROCLAMATIONS AND RECOGNITIONS
 
A. Proclamation: Pride Month
 
B. Proclamation: Gun Violence Awareness Day
 
6. LIQUOR LICENSES PUBLIC HEARINGS
 
A.   Consideration and Action on Liquor License Application:  Adam Harrington, "High Altitude Home Brew Supply," 2710 N. Steves Blvd., Suite H, Series 10 (beer and wine store), New License.
 
  STAFF RECOMMENDED ACTION:
 
Open the public hearing.
Receive citizen input.
Close the public hearing.

The City Council has the option to:
(1) Forward the application to the State with a recommendation for approval;
(2) Forward the application to the State with a recommendation for denial based on information from staff, the testimony received at the public hearing and/or other factors.
 
7. CONSENT ITEMS
 
All matters under Consent Agenda are considered by the City Council to be routine and will be enacted by one motion approving the recommendations listed on the agenda. Unless otherwise indicated, expenditures approved by Council are budgeted items.
 
A.   Consideration and Approval of Cooperative Contract: Purchase of Four (4) Itron MC3 lite mobile collection systems for water meter services.
 
  STAFF RECOMMENDED ACTION:
 
  1. Approve the purchase of the four (4) Itron MC3 lite mobile collection systems from Mountain State Pipe and Supply in the amount of $18,000 each for a total of $72,000.
  2. Authorize the City Manager to execute the necessary documents.
 
B.   Consideration and Approval of Municipal Services Accounts, Miscellaneous Account Receivable, and Insufficient Funds Write-offs: Delinquency and Uncollectible Accounts for FY 2019.
 
  STAFF RECOMMENDED ACTION:
 
Approve the write-off of delinquent and uncollectible Municipal Services accounts (water/solid waste utility services), Miscellaneous Account Receivables (variety of fees, lease revenue, retiree insurance), and Insufficient Funds (returned checks) in the combined amount of $91,161.74.
 
8. ROUTINE ITEMS
 
A.   Consideration and Approval of Cooperative Purchase Contract: Consultant Services Contract for the Fourth Street Reconstruction Design Project
 
  STAFF RECOMMENDED ACTION:
 
  1. Award a Consultant Services Contract to AECOM Technical Services, Inc. of Phoenix, AZ under a Cooperative Purchase Contract with the State of Arizona in an amount not to exceed $176,966.00 with a contract duration of 190 calendar days; and
  2. Authorize the City Manager to execute the necessary documents.
 
B.   Consideration and Adoption of Resolution No. 2019-16:  A resolution amending Section 5.2 of the Section 8 Administrative Plan to adopt a local preference for selection from the waiting list.
 
  STAFF RECOMMENDED ACTION:
 
1) Read Resolution No. 2019-16 by title only
2) City Clerk reads Resolution No. 2019-16 by title only (if approved above)
3) Adopt Resolution No. 2019-16
 
C.   Consideration and Approval of Contracts: Annual Workers' Comp and General Liability Insurance.
 
  STAFF RECOMMENDED ACTION:
 
  1. Approve the renewal of our Workers’ Compensation agreement with CopperPoint Mutual with an estimated premium of $515,847.
  2. Approve the renewal of our property insurance agreement with A.I.G. with an estimated premium of $234,916.
  3. Approve the renewal of our General Liability, Auto, Umbrella and associated lines of coverage with travelers Insurance with an estimated premium of $729,590.
 
D.   Consideration and Approval of Construction Contract:  Recommended Approval of the Construction Contract with Mountain High Excavation, LLC. in the amount of $845,051.00 for the Aztec Street Improvements Project.
 
  STAFF RECOMMENDED ACTION:
 
  1. Approve the Construction Contract with Mountain High Excavation, LLC. in the amount of $845,051.00, which includes a $56,000.00 Contract Allowance and a Contract Timeframe of 120 calendar days; and
  2. Approve Change Order Authority to the City Manager in the amount of $78,905.10 (10% of the Contract Price, less the Contract Allowance); and
  3. Authorize the City Manager to execute the necessary documents.
 
E.   Consideration and Adoption of Resolution No. 2019-21:  A resolution of the Flagstaff City Council, approving an Intergovernmental Agreement Between the State of Arizona Department of Revenue and City of Flagstaff for local tax administration; providing for expiration of the existing agreement; and establishing an effective date.
 
  STAFF RECOMMENDED ACTION:
 
1) Read Resolution No. 2019-21 by title only
2) City Clerk reads Resolution No. 2019-21 by title only (if approved above)
3) Adopt Resolution No. 2019-21

Approve the Intergovernmental Agreement between the City of Flagstaff and the Arizona Department of Revenue regarding the uniform administration, licensing, collection, and auditing of transaction privilege tax, use tax, severance tax, jet fuel excise and use tax and rental occupancy taxes imposed by the State or cities or towns.
 
F.   Consideration and Adoption of Resolution No. 2019-22:  A resolution of the Flagstaff City Council, approving a Model Uniform Video Service License Agreement and Application and Affidavit for Uniform Video Service License, as required by state law; providing for delegation of authority and establishing an effective date.
 
  STAFF RECOMMENDED ACTION:
 
1) Read Resolution No. 2019-22 by title only
2) City Clerk reads Resolution No. 2019-22 by title only (if approved above)
3) Adopt Resolution No. 2019-22
 
G.   Consideration and Adoption of Resolution No. 2019-24:  A resolution of the Council of the City of Flagstaff, Arizona adopting the tentative estimates of the amounts required for the public expense for the City of Flagstaff for Fiscal Year 2019-2020; adopting a Tentative Budget; setting forth the receipts and expenditures; the amount proposed to be raised by direct property taxation; giving notice of the time for hearing taxpayers, for adopting of Budget and for fixing the tax levies. (Adopt Tentative Budget for City FY 19-20)
 
  STAFF RECOMMENDED ACTION:
 
1) Read Resolution No. 2019-24 by title only
2) City Clerk reads Resolution No. 2019-24 by title only (if approved above)
3) Adopt Resolution No. 2019-24
 
RECESS
 
6:00 P.M.


RECONVENE
 
NOTICE OF OPTION TO RECESS INTO EXECUTIVE SESSION
 
Pursuant to A.R.S. §38-431.02, notice is hereby given to the members of the City Council and to the general public that, at this regular meeting, the City Council may vote to go into executive session, which will not be open to the public, for legal advice and discussion with the City’s attorneys for legal advice on any item listed on the following agenda, pursuant to A.R.S. §38-431.03(A)(3).
 
9. ROLL CALL
 
NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
MAYOR EVANS
VICE MAYOR SHIMONI
COUNCILMEMBER ASLAN
COUNCILMEMBER MCCARTHY

COUNCILMEMBER ODEGAARD
COUNCILMEMBER SALAS
COUNCILMEMBER WHELAN
 
10. PLEDGE OF ALLEGIANCE
 
11. PUBLIC PARTICIPATION
 
12. CARRY OVER ITEMS FROM THE 4:30 P.M. AGENDA
 
13. PUBLIC HEARING ITEMS
 
A.   Public Hearing, Consideration and Possible Adoption of Ordinance No. 2019-014:  Canyon del Rio Investors, LLC requests a Concept Zoning Map Amendment of approximately 83.88 acres at 3200 East Butler Avenue from the RD, Research and Development Zone, to MR, Medium Density Residential Zone (27.9 acres), HR, High Density Residential Zone (30.0 acres), and HC, Highway Commercial Zone (25.9 acres).  The area proposed for the Concept Zoning Map Amendment is a portion of a 262-acre development known as Canyon del Rio. (Canyon del Rio Investors, LLC Concept Zoning Map Amendment request for property located at 3200 East Butler Avenue.)
 
  STAFF RECOMMENDED ACTION:
 
1) Read Ordinance No. 2019-14 by title only for the final time
2) City Clerk reads Ordinance No. 2019-14 by title only (if approved above)
3) Adopt Ordinance No. 2019-14
 
14. REGULAR AGENDA
 
A.   Consideration and Approval of Preliminary Block Plat  Request by Canyon del Rio Investors, LLC, for Preliminary Plat approval for Canyon del Rio, a subdivision consisting of 22-parcels, 8-tracts and Rights-of-Way on 262 acres, located at 1200 East Butler Avenue in the R1, Single-Family Residential Zone, the MR, Medium-Density Residential Zone, the HR, High-Density Residential Zone and the HC, Highway Commercial Zone.
 
  STAFF RECOMMENDED ACTION:
 
The Planning and Zoning Commission (5-0 vote on April 24, 2019) recommends approving the Preliminary Block Plat with the conditions outlined in the staff summary and its attachments.
 
B.   Consideration and Possible Adoption of Resolution No. 2019-20: A resolution authorizing the execution of a Development Agreement between Canyon del Rio Investors, LLC and the City of Flagstaff related to the development of approximately 262 acres of real property generally located at 3200 East Butler Avenue. (Canyon del Rio Development Agreement)
 
  STAFF RECOMMENDED ACTION:
 
  1. Read Resolution No. 2019-20 by title only
  2. City Clerk reads Resolution No. 2019-20 by title only (if approved)
  3. Adopt Resolution No. 2019-20
 
C.   Consideration and Possible Adoption of Resolution No. 2019-XX: A resolution regarding a potential detention pond Development Agreement involving drainage near Wildwood Hills Subdivision/Wanderland Campground and real estate options.
 
  STAFF RECOMMENDED ACTION:
 
This item will be discussed in Executive Session on May 28, 2019. Direction will be determined during the session. 
 
D.   Public Hearing, Consideration and Adoption of Resolution No. 2019-26 and Ordinance No. 2019-16:  Public hearing to consider proposed adoption of the “The 2018 Suite of Codes and the 2019 Amendments to City Code, Title 4, Building Regulations."
 
  STAFF RECOMMENDED ACTION:
 
At the June 4, 2019 Council Meeting:
1) Read Resolution No. 2019-26 by title only
2) City Clerk reads Resolution No. 2019-26 by title only (if approved above)
3) Read Ordinance No. 2019 -16 by title only for the first time
4) City Clerk reads Ordinance No. 2019-16 by title only (if approved above)

At the June 18, 2019 Council Meeting:
5) Adopt Resolution No. 2019-26
6) Read Ordinance No. 2019-16 by title only for the final time
7) City Clerk reads Ordinance No. 2019-16 by title only (if approved above)
8) Adopt Ordinance No 2019-16
 
E.   Consideration and Adoption of Resolution No. 2019-27 and Ordinance No. 2019-17: Declaring as a Public Record that certain document known as "The International Fire Code, 2018 Edition, and the 2019 Amendments to the Flagstaff City Code, Title 5, Fire Code" and adopting said public record by reference.
 
  STAFF RECOMMENDED ACTION:
 
At the June 4, 2019 Council Meeting:
1) Read Resolution No. 2019-27 by title only
2) City Clerk reads Resolution No. 2019-27 by title only (if approved above)
3) Read Ordinance No. 2019 -17 by title only for the first time
4) City Clerk reads Ordinance No.2019-17 by title only (if approved above)

At the June 18, 2019 Council Meeting:
5) Adopt Resolution No. 2019-27.
6) Read Ordinance No. 2019 -17 by title only for the final time
7) City Clerk reads Ordinance No.2019-17 by title only (if approved above)
8) Adopt Ordinance No 2019-17
 
F.   Consideration and Adoption of Resolution No. 2019-28 and Ordinance No. 2019-19: A resolution and ordinance amending the Flagstaff City Code, Title 8, Streets and Public Ways and Title 9, Traffic, Chapter 9-05, Bicycles.
 
  STAFF RECOMMENDED ACTION:
 
At the June 4, 2019 Council Meeting:
1) Read Resolution No. 2019-28 by title only
2) Read Ordinance No. 2019-19 by title only for the first time
3) City Clerk reads Ordinance No. 2019-19 by title only (if approved above)
 
At the June 18, 2019 Council Meeting:
1) Adopt Resolution No. 2019-28
2) Read Ordinance No. 2019-19 by title only for the final time
3) City Clerk reads Ordinance No. 2019-19 by title only (if approved above)
4) Adopt Ordinance No. 2019-19
 
15. DISCUSSION ITEMS
 
A.   Discussion and Direction: Possible Committees for the November 2020 General Election
 
16.
COUNCIL LIAISON REPORTS
 
17. FUTURE AGENDA ITEM REQUESTS

After discussion and upon agreement by three members of the Council, an item will be moved to a regularly-scheduled Council meeting.
 
A.   Future Agenda Item Request (F.A.I.R.): A request by Mayor Evans to place on a future agenda a discussion about a cell phone tower ordinance to require that the coverage map provided in the application be done by an independent third party.
 
B.   Future Agenda Item Request (F.A.I.R.): A request by Councilmember Odegaard to place on a future agenda a discussion about the creation of a City Veterans’ Liaison Coordinator position.
 
18. INFORMATIONAL ITEMS AND REPORTS FROM COUNCIL AND STAFF, FUTURE AGENDA ITEM REQUESTS
 
19. 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                                       , 2019.



__________________________________________
Stacy Saltzburg, MMC, City Clerk
                                            


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /print_agenda.cfm
Time Stamp 17-May-24 10:24 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.20.230.5
Host Name 10.20.230.5


Execution Time

Total Time Avg Time Count Template
1032 ms 1032 ms 1 D:/inetpub/PublicPages/print_agenda.cfm
641 ms 641 ms 1 D:/inetpub/PublicPages/agpub_client_defines.cfm
313 ms 313 ms 1 D:/inetpub/PublicPages/public/publish/print_agenda_dsp.cfm
252 ms 13 ms 20 D:/inetpub/PublicPages/public/publish/print_agenda_ud_load.cfm
31 ms 31 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgLines(860) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
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 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAgenda(860, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
0 ms 0 ms 1 D:/inetpub/PublicPages/Application.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 20 D:/inetpub/PublicPages/public/publish/print_agenda_ud.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1032 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 22:24:27.027
			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 @ 22:24:27.027
				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'
			
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
	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 IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26','AG TIME')
	AND (opt_form_id = '' OR opt_form_id IS NULL)
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 22:24:27.027
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:24:27.027
	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) = 860

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

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
		SELECT valid_code, descr, long_descr from codes
		WHERE code_type = 'AG_FONT'
	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'
	
checkField (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:24:27.027
		SELECT * from agenda_ln WHERE _rowid > 1 and _rowid < 5
	
final_check (Datasource=frsRO, Time=0ms, Records=20) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:24:27.027
		SELECT _rowid
		FROM ss_ag_item
		WHERE ss_ag_item.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 860

qryResults (Datasource=frsRO, Time=31ms, Records=45) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:24:27.027
	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) = 860

getAgHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
	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_agenda.cfm @ 22:24:27.027
	select * from getAgLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getAgLines (Datasource=, Time=0ms, Records=43) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
	select * from getAgLines where header_ln <> 'Y' and footer_ln <> 'Y'
	order by line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
getorig (Datasource=frsRO, Time=31ms, Records=1) in D:\inetpub\PublicPages\print_agenda.cfm @ 22:24:27.027
	SELECT action_by, stat_date, de.fname, de.lname, de.title as utitle
	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) = 'AGENDA' AND form_num = 860
	AND stat_action = 'ADD'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 22:24:27.027
			select top 1 * from codes
		
qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\print_agenda.cfc @ 22:24:27.027
			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(861 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 @ 22:24:27.027
		SELECT printed_logo, logo_plcmnt FROM getform
	
items (Datasource=frsRO, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4075 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 85 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 = 4075 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4050 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 81 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 = 4050 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4051 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 4051 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4065 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=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 4065 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 3992 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 @ 22:24:27.027
		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 = 86 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 = 3992 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 3989 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 @ 22:24:27.027
		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 = 3989 AND
			rev_num = 2
		order by au.seq_num
	
items (Datasource=frsRO, Time=15ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4044 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 4044 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4052 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 4052 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4064 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=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 86 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 = 4064 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4074 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 86 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 = 4074 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4038 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 @ 22:24:27.027
		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 = 4038 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4046 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=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:27.027
		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 = 88 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 = 4046 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 @ 22:24:27.027
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4054 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:28.028
		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 = 4054 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 @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4081 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=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:28.028
		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 = 4081 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 @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4067 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:28.028
		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 = 86 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 = 4067 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 @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4072 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=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_agenda_ud_load.cfm @ 22:24:28.028
		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 = 86 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 = 4072 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 @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4082 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 @ 22:24:28.028
		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 = 86 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 = 4082 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4066 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = '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 @ 22:24:28.028
		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 = 82 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 = 4066 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4070 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = '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 @ 22:24:28.028
		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 = 82 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 = 4070 AND
			rev_num = 0
		order by au.seq_num
	
items (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_agenda_dsp.cfm @ 22:24:28.028
				SELECT _rowid, seq_num, text_value
				FROM ag_memo_item
				WHERE form_num = 4071 AND rev_num = 0 AND
			((seq_num = 1 and 'Y' = 'Y') OR
			(seq_num = 2 and ' ' = '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 @ 22:24:28.028
		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 = 82 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 = 4071 AND
			rev_num = 0
		order by au.seq_num
	


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_agenda.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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFTOKEN=1248fd4b2e27904c%2D6551D35F%2D0AA1%2DE20A%2DF32D60F17BB5BAD4; CFID=9863619
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//print_agenda.cfm?seq=860&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_agenda.cfm
QUERY_STRING=seq=860&reloaded=true&id=
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/print_agenda.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=9863619
cftoken=1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
hitcount=6
lastvisit={ts '2024-05-17 22:24:27'}
timecreated={ts '2024-05-17 22:24:25'}
urltoken=CFID=9863619&CFTOKEN=1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
Cookie Variables:
CFID=9863619
CFTOKEN=1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
Session Variables:
cfid=9863619
cftoken=1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9863619_1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
subdir=/public/
tzoffset=0
urltoken=CFID=9863619&CFTOKEN=1248fd4b2e27904c-6551D35F-0AA1-E20A-F32D60F17BB5BAD4
URL Parameters:
id=
reloaded=true
seq=860
Debug Rendering Time: 15 ms