Board of Adjustment


Print Agenda Item PDF Return to the Search Page Return to the Agenda Copy Staff Summary Report
  .A.       
Meeting Date: 06/21/2023  
From: Tiffany Antol, Zoning Code Manager

Information
REQUEST:
PZ-23-00085: A request by David and Kelly Yingling, for a Zoning Code Variance from Section 10-40.30.030 (Residential Zones), specifically Table C. (Building Form and Property Development Standards).  The applicant is requesting a variance from the applicable interior side setback to enable the construction of a new single-family residence closer to the interior side setback than would otherwise be allowed by the Zoning Code.  The property is located at 5112 E Cottonwood Drive (APN 106-07-032).   
STAFF RECOMMENDED ACTION:
Staff recommends that the Board of Adjustment approve the proposed Variance for a 10-foot interior side setback in accordance with the finding presented in this staff summary subject to conditions.
INTRODUCTION AND DISCUSSION::
The subject property (Assessor's Parcel Number 106-07-032) is a 2.48 acre parcel located at 5112 E Cottonwood Drive just south of the Coconino County island known as Forestdale.  The property is zoned Estate Residential (ER) with the Resource Protection Overlay (RPO). The site has already been developed with a driveway as well as electrical and water utility infrastructure.  The subject property is encumbered with Forest Service Road 301A known as Cottonwood Drive that enters the property at the northwestern corner and traverses the property in the shape of the letter V, essentially dividing the property into three separate pieces and exiting the property at the northeastern corner. The existing road is smaller than the 30-foot wide easement that encumbers the property for this road. However, as shown on the applicant's site plan, the road occasionally meanders outside the easement further encumbering the site.  The previous property owner occupied the site with a trailer, constructed the existing infrastructure, and cleared the site.  The new property owner is proposing to construct a new 1,885 square foot house with a 912 square foot garage.

The site is heavily treed with mature Ponderosa Pine.  The property has a rolling terrain with a steep slope running in the north/south direction along the eastern third of the property where the applicant intends to develop the new home.  The proposed location of the new home was selected based on the location of the existing infrastructure and site disturbance, the views, and the privacy that this location affords.  Because the site is located within the RPO, the owner is limited to the amount of trees than can be removed from the site to accommodate development.  On larger lots, this is usually calculated by determining total lot disturbance rather than counting the individual trees. 

The property is adjacent to Forest Service lands to the east and south and is adjacent to private property within the City of Flagstaff to the north and west also in the ER zone.
ZONING CODE REQUIREMENTS:
The applicant is seeking a variance from the minium interior side setback found in Table 10-40.30.030.C. Residential Zones- Building Form and Property Development Standards (Page 10-40.30-7) of the Zoning Code to allow the development of a new single-family dwelling.  In accordance with Table 10-40.03.030.C. Building Placement Standards, new development is required to meet building setbacks from all property lines.  The subject property is located within the ER zone which requires the following setbacks:

Front (min)              50'
Interior Side (min)   20'/45' total
Rear (min)               60'

The proposed single family home would meet all required setbacks for the ER zone expect for the interior side setback off the eastern property line which would be 10 feet instead of the required 20 feet.  
VARIANCE CRITERIA AND ANALYSIS:
Pursuant to A.R.S. Section 9-462.06, the Board of Adjustment is granted the authority to consider and approve variances from the otherwise applicable provisions of the Zoning Code subject to specific standards or findings.  Section 10-20.70 of the Zoning Code establishes the procedures for the review of a variance application by the Board of Adjustment.  Section 10-20.70.050 of the Zoning Code identifies the four (4) standards that must apply when granting any variance.  These standards are included below, followed by an analysis of how the requested variance does or does not satisfy these standards.  Note that the Board of Adjustment may only consider and apply arguments in support of these findings, and no other arguments for the granting or denial of the variance are applicable or may be considered.

A variance shall only be granted if the applicant demonstrates all of the following:
  1. That, because of special circumstances applicable to the property, including its size, shape, topography, location, or surroundings, the strict application of these regulations will deprive such property of privileges enjoyed by other property of the same classification in the same zone; 
The development of the site is unusually encumbered by an existing Forest Service Road and easement that essentially divides the subject property into three areas.  As a public access roadway that also serves surrounding properties, the ability to develop the site as permitted with a single-family dwelling is extremely limited without pushing the home up against the roadway or easement. The site also has previously installed infrastructure to support the specific location that is proposed for the new home.  The applicant is requesting the variance for the specific purpose of causing less disturbance to the property than what has already occurred.  A 10-foot interior side setback would allow the applicant to site the home away from the existing steep slope.  The home would be located closer to Forest Service lands and would be unlikely to disturb or interfere with adjacent development.  Few properties in Flagstaff have the same or similar encumbrances that exist on this property.
  1. That a grant of a variance will be subject to conditions to ensure that the adjustment authorized is the minimum variation needed and that it will not constitute a grant of special privileges inconsistent with the limitations upon other properties in the vicinity and zone in which such property is located;
The site plan provided shows the proposed home being constructed within 10 feet of the eastern property line where a 20-foot setback is required.  Originally, the applicant thought that the house would fit within the bounds of the existing setback requirements.  After working with the contractor it became clear that the home would need to be pushed further away from the edge of the slope to avoid further disturbance.  The original home design included an allowed stair encroachment into the eastern 20-foot interior side setback.  The site plan provided for this variance still shows the stairs encroaching into the setback.  The applicant has agreed to relocate those stairs to the northern end of the deck so that the variance total is reduced and will not exceed the minimum variance required for the development of this house.

The grant of the variance will not constitute a special privilege as few lots within the city have the same special circumstances that impact this development site.
  1. The special circumstances applicable to the property are not self-imposed by any person presently having an interest in the property; and
The applicant (current property owner) is not responsible for the establishment of the existing Forest Service Road or easement.  The previous property established the existing driveway and utility infrastructure.  The placement of the home within the existing disturbed areas of the site would not constitute a self-imposed condition.  
  1. The variance will not allow the establishment of a use which: (1) is not otherwise permitted in the zone, (2) would result in the extension of a non-conforming use, or (3) would change the terms of the zone of any or all of the subject property.
The approval of a variance will not establish a use on the property that: 1) is not allowed in the Estate Residential (ER) zone; 2) would result in the extension of a nonconforming use; or, 3) changes the terms of the Estate Residential (ER) zone of any or all the subject property.
 
NOTICE OF PUBLIC HEARING:
The applicant has provided notice by mail of the Board of Adjustment hearing for this application to the property owners within 300 feet of the subject property and staff has placed a sign on the property.  The notice and sign contain the date, time, and place of the hearing.

As of the date of this report, staff has not received any public comments regarding the proposed application.
RECOMMENDATION
Staff recommends that the Board of Adjustment finds that the criteria required for granting of a variance have been met, and approve the variance application subject to the following conditions:
 
  1. The subject property shall be developed in accordance with the site plan provided by the applicant except that there shall be no further encroachments into the setback as allowed in Section 10-50.40.020.A of the Zoning Code.
Attachments
Application
Applicant Narrative
Context Photos
Original Site Plan, Floor Plans, and Elevations
Proposed Site Plan


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/histLink_agmemo.cfm
Time Stamp 16-May-24 05:51 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
688 ms 688 ms 1 D:/inetpub/PublicPages/Application.cfm
657 ms 657 ms 1 D:/inetpub/PublicPages/agpub_client_defines.cfm
297 ms 297 ms 1 D:/inetpub/PublicPages/public/publish/histLink_agmemo.cfm
251 ms 251 ms 1 D:/inetpub/PublicPages/public/publish/agpub_agm_dsp.cfm
235 ms 235 ms 1 D:/inetpub/PublicPages/public/publish/include_ag_memo.cfm
79 ms 79 ms 1 D:/inetpub/PublicPages/public/publish/include_levels.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc | qryAI(7304, 0, Y) ] from D:/inetpub/PublicPages/public/cfm_utilities/print_agenda.cfc
16 ms 16 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/_methodQryAI.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/include_set_fonts.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/print_agm_ud.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/styles/header_styles.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
985 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=32ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 17:51:43.043
			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 @ 17:51:43.043
				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'
			
getFasInfo (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
			,c4.large_misc_alpha customPage
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
	left outer join codes as c4 ON (c4.code_type = 'EXTCUST')
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup2'
UserAttr (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
		SELECT ' ' dflt_conf, 'N' super_user, ' ' dflt_grp FROM websecur WHERE websecur.login_id = 'destiny'
	
getMeetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
			FROM meeting_type mt
			LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
			WHERE mt.show_public = 'Y'
		ORDER BY mt.descr
	
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT user_filedir_alias, confidential_dir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:51:44.044
			select top 1 * from codes
		
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT text_value1, misc_alpha public_window from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
chkMeetings (Datasource=frsRO, Time=0ms, Records=1698) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT 1 meeting_dt from meetings WHERE
	meetings.the_meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE (form_id = 'AGENDA' OR form_id = 'MINUTES') AND final_apprvl = 'Y'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT MAX(fis_yr) fis_yr FROM fas
	WHERE (form_id = 'AGENDA' OR form_id = 'MINUTES') AND final_apprvl = 'Y'

finalized_meeting (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
		SELECT MAX(meeting_dt) last_meeting FROM meetings
		INNER JOIN agenda ON (agenda.meeting_id = meetings.meeting_id)
		INNER JOIN fas ON (fas.form_id = 'AGENDA' AND fas.form_num = agenda.form_num  AND fas.final_apprvl = 'Y')
	
fas_menu (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT menu_label FROM fas_menu WHERE web_page = '../publish/agenda_publish.cfm'
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
chk_aiDisplay (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm @ 17:51:44.044
		select case when ss_agi._rowid is null then agi.display_routine else ss_agi.display_routine end as display_routine
		from ag_memo am
		inner join agenda_ln as atl on (atl.ag_memo_id = am.form_num and atl.ag_memo_rev = am.rev_num)
		inner join agenda as a on (a.form_num = atl.form_num)
		left outer join ag_item as agi on (agi._rowid = am.ag_item_rowid)
		left outer join ss_ag_item as ss_agi on (ss_agi.form_num = a.form_num and ss_agi._rowid = am.ag_item_rowid)
		where am.form_num = ?
		  and am.rev_num  = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7304
Parameter #2(cf_sql_integer) = 0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:51:44.044
			select top 1 * from codes
		
qryResults (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\cfm_utilities\_methodQryAI.cfm @ 17:51:44.044
	SELECT fas.form_id, fas.form_num fas_form_num, fas.rev_num fas_rev_num, fas.rqst_loc fas_rqst_loc, fas.action_cd fas_action_cd, fas.current_stop fas_current_stop,
		   fas.routing_apprvl fas_routing_apprvl, fas.final_apprvl fas_final_apprvl, fas.final_print fas_final_print, fas.fis_yr fas_fis_yr, fas.date_final,
		   fas.final_prt_date, fas.orig_loginid, meetings.meeting_dt as bo_date, de.fname, de.lname, de.title as utitle,															
		   meetings.doc_dir, meetings.meeting_name, meetings.meeting_dt, meetings.meeting_id, ag_times.descr time_descr, orig_depts.dept_desc, orig_divs.div_desc,
		   al.ag_size, al.ag_underline, al.ag_bold, al.ag_center, al.ag_italic, al.disp_level,
	  	   al.ag_level1 chk_level1, al.ag_level2 chk_level2, al.ag_level3 chk_level3,
		   al.ag_level1, al.ag_level2, al.ag_level3, al.ag_level4,al.seq_num,
		   al._rowid line_rowid,
		   a.text_size, a.text_font, a.print_num_ai, a.att_public, a.cont_numbering, a.att_header, a.exp_header, a.line_size, a.line_bold,
	   	   a.disp_num_ai, a.ag_punct, a.disp_ainumber, a.form_num ag_form_num, a.turn_off_level_dsp, a.disp_all_lvls,
		   a.disp_rteinfo, w.email, p.phone_no, p.phone_ext,
		   ft.meeting_id as ai_meeting_id, codes.long_descr px_size, codes.descr pdf_format, codes.misc_alpha4 special_format,
		   al._rowid AS ln_rowid, al._rowid AS agenda_ln_rowid, a.form_num AS ag_num, a.rev_num AS ag_rev, a.use_old_print_format,		
		   aa.descr ag_area_desc, asa.descr ag_subarea_desc, al.seq_vchar,
 	   	   c1.text_value1 pdf_header, c1.text_value2 pdf_footer, c1.misc_alpha prt_att_links,
	 	   c1.misc_alpha3 page_start, c1.misc_alpha2 info_header, c1.text_value3 all_bold,
	 	   	 
	 	   		c1.misc_alpha7 lvl_text_size, c1.misc_alpha6 dp_level_ai, c1.misc_alpha10 printMinutes, c1.misc_alpha11 printLegal, c1.misc_alpha13 dateSpelled, c1.misc_alpha14 left_justify_all,
	 	   	
	 	   c2.misc_alpha2 level_descriptor,
		   amdol.text_value amdol_more_info, amdol.text_block LinesCCCBoardOrder,
		   ft.* 
	FROM fas
	INNER JOIN ag_memo AS ft ON (fas.form_num = ft.form_num AND fas.rev_num = ft.rev_num)
	INNER JOIN form_hist ON (UPPER(form_hist.form_id) = fas.form_id AND UPPER(form_hist.stat_action) = 'ADD' AND form_hist.form_num = fas.form_num AND form_hist.rev_num = fas.rev_num)
	LEFT OUTER JOIN agenda AS a ON (ft.meeting_id = a.meeting_id)
	LEFT OUTER JOIN agenda_ln AS al ON (al.form_num = a.form_num AND al.ag_memo_id = ft.form_num AND al.ag_memo_rev = ft.rev_num)
	LEFT OUTER JOIN meetings ON (ft.meeting_id = meetings.meeting_id) 
	LEFT OUTER JOIN websecur AS w ON (w.login_id = ft.create_by)
	LEFT OUTER JOIN dist_empl AS de ON (de.empl_id = w.empl_id)
	LEFT OUTER JOIN phone AS p ON (p.empl_id = w.empl_id AND p.is_primary ='Y')
	LEFT OUTER JOIN codes AS ag_times ON (ag_times.code_type = 'AG TIME' AND ag_times.valid_code = ft.ag_time)
	LEFT OUTER JOIN codes ON (codes.code_type = 'AG_FONT' and codes.valid_code = a.text_size)
	LEFT OUTER JOIN ag_area aa ON (aa.meeting_type = meetings.the_meeting_type AND aa.ag_area = ft.ag_area)
	LEFT OUTER JOIN area_subarea AS asa ON (asa.ag_area = ft.ag_area and asa.ag_subarea = ft.ag_subarea and asa.meeting_type = meetings.the_meeting_type)

	LEFT OUTER JOIN dist_dept AS orig_depts ON (ft.orig_dept = orig_depts.dept_code)
	LEFT OUTER JOIN dept_div AS orig_divs ON (ft.orig_dept = orig_divs.dept_code AND ft.orig_div = orig_divs.div_code)
	LEFT OUTER JOIN form_userdef as amdol on (amdol.form_id = fas.form_id AND
		amdol.form_num = ft.form_num and amdol.rev_num = ft.rev_num AND
		amdol.code_type = 'AMDOL')
	LEFT OUTER JOIN codes AS c1 ON (c1.code_type = 'AddlMtg' and CAST(c1.valid_code AS INT) = ft.meeting_id)
	LEFT OUTER JOIN codes AS c2 ON (c2.code_type = 'MTG_MSG' and c2.valid_code = meetings.the_meeting_type)
	WHERE UPPER(fas.form_id) = 'AG_MEMO' AND
				fas.form_num = ? AND
				fas.rev_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 7304
Parameter #2(cf_sql_integer) = 0

final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:51:44.044
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 3786 
getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_set_fonts.cfm @ 17:51:44.044
 		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 @ 17:51:44.044
 		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 @ 17:51:44.044
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
agendaChk (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		SELECT fas.final_apprvl
		FROM agenda, fas
		WHERE agenda.meeting_id = 3787 AND
			  fas.form_id = 'AGENDA' AND
			  fas.form_num = agenda.form_num
	
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		SELECT _rowid, agenda.form_num
		FROM ss_ag_item, agenda
		WHERE agenda.meeting_id = 3787 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 @ 17:51:44.044
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 = 3786 AND agi._rowid = 116)
	
LEFT OUTER JOIN codes c ON (c.code_type = 'AG_MEMO_PRT' AND c.valid_code = agi.print_routine)
WHERE m.meeting_id = 3787 AND
	  agt.ag_template_id = m.template_id AND
	  mt.meeting_type = agt.meeting_type AND
  	  agi._rowid = 116 
PrintRoutine (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		SELECT valid_code, descr, misc_alpha, misc_alpha2 pdfHeadersFooters
		FROM codes
		WHERE code_type = 'AG_MEMO_PRT' AND valid_code = 'AMORIG' AND obsolete = 'N'
	
all_userdef (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		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 = 116)
		LEFT OUTER JOIN codes c ON (c.code_type = 'ExpRequired' AND c.valid_code = '116')
		WHERE form_id = 'AG_MEMO'
	
all_codes (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
			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 @ 17:51:44.044
			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 = '116'
			order by  au.seq_num
		
get_userdef (Datasource=frsRO, Time=16ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
			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 = 7304 AND
				      u.rev_num = 0 
getfi3 (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
				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 @ 17:51:44.044
					SELECT valid_code, descr, sort_order, misc_alpha2 FROM all_codes
					WHERE code_type = 'ud_fi3' AND
					(obsolete = 'N' AND create_date <= ? 
					)
					ORDER BY sort_order
				
Query Parameter Value(s) -
Parameter #1(cf_sql_date) = 2023-06-21

getPXvalue (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		SELECT long_descr FROM codes WHERE code_type = 'AG_FONT' AND valid_code = 'mediumText'
	
submittor (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		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 = 'tantol'
	
items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
SELECT _rowid, seq_num, text_value
FROM ag_memo_item
WHERE form_num = 7304 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 @ 17:51:44.044
	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 @ 17:51:44.044
	SELECT dept_code FROM committees WHERE review_comm = 'Y'
expenditures (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
	SELECT text1, input1, input2, input3, input4, input5, input6, fis_yrx, revenue, expenditure
	FROM ag_memo_dol WHERE ag_memo_dol.form_num = 7304 AND ag_memo_dol.rev_num = 0
	ORDER BY  ag_memo_dol._rowid	
attachments (Datasource=frsRO, Time=0ms, Records=5) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
	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 = 7304 AND
		  ad.rev_num = 0 
	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 @ 17:51:44.044
		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 @ 17:51:44.044
		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 @ 17:51:44.044
		SELECT _rowid, seq_num, text_value
		FROM ag_memo_supp
		WHERE form_num = 7304 AND
		      rev_num = 0
		ORDER BY seq_num
	
form_rte_stops (Datasource=frsRO, Time=15ms, Records=0) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
	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 = 7304 AND form_rte.rev_num = 0 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 @ 17:51:44.044
	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 = 7304 AND
		  rev_num = 0 AND
		  stat_action = 'ADD'
getstatus (Datasource=frsRO, Time=31ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
		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 = 'AI116')
		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 = 7304 AND
			  hist.rev_num = 0 AND
			  hist.stat_type = 'H'
		ORDER BY seq_num
	
agmemo_status (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\include_ag_memo.cfm @ 17:51:44.044
	SELECT * from getStatus
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 17:51:44.044
		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) = 3787

GetThisLine (Datasource=frsRO, Time=47ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:51:44.044
				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 = 3786 AND ai._rowid = 116)
				
				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 = 46413 
chkLevel1 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\include_levels.cfm @ 17:51:44.044
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3786
					AND a.ag_level1 = '5'
					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 @ 17:51:44.044
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3786
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'A'
					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 @ 17:51:44.044
					SELECT a.disp_level
					FROM agenda_ln a
					WHERE a.form_num = 3786
					AND a.ag_level1 = '5'
					AND a.ag_level2 = 'A'
					AND a.ag_level3 = ''
					AND (a.ag_level4 = '' OR a.ag_level4 IS NULL)
					AND a.header_ln = 'N' AND a.footer_ln = 'N'
				
get_supp_temp (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:51:44.044
					SELECT * FROM ag_item
					WHERE ag_item._rowid = 76 
supp_items (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_agm_dsp.cfm @ 17:51:44.044
					SELECT _rowid, seq_num, text_value
					FROM ag_memo_supp
					WHERE form_num = 7304 AND
					      rev_num = 0
					ORDER BY 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\public\publish\histLink_agmemo.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=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//public/publish/histLink_agmemo.cfm?dsp=agm&fp=OFF&seq=7304&rev=0
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\public\publish\histLink_agmemo.cfm
QUERY_STRING=dsp=agm&fp=OFF&seq=7304&rev=0
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/histLink_agmemo.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=9831839
cftoken=fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
hitcount=2
lastvisit={ts '2024-05-16 17:51:43'}
timecreated={ts '2024-05-16 17:51:43'}
urltoken=CFID=9831839&CFTOKEN=fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
Cookie Variables:
CFID=9831839
CFTOKEN=fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
Form Fields:
DISPLAY_AG=0
DISPLAY_ID=7304
DISPLAY_REV=0
DSP=
Session Variables:
cfid=9831839
cftoken=fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9831839_fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
subdir=/public/
tzoffset=0
urltoken=CFID=9831839&CFTOKEN=fed85103101609ed-2812F51D-DB19-F0E9-C4BA331047E87AE3
URL Parameters:
dsp=agm
fp=OFF
rev=0
seq=7304
Debug Rendering Time: 15 ms