CITY COUNCIL WORK SESSION
FEBRUARY 24, 2015
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
 
               
1.

Call to Order

 
  Mayor Nabours called the Flagstaff Work Session of February 24, 2015, to order at 6:10 p.m.
 
2. Pledge of Allegiance
 
3. Roll Call

NOTE: One or more Councilmembers may be in attendance telephonically or by other technological means.
 
 
PRESENT ABSENT
   
MAYOR NABOURS NONE
VICE MAYOR BAROTZ ( left meeting at 7:51 p.m.)  
COUNCILMEMBER BREWSTER  
COUNCILMEMBER EVANS  
COUNCILMEMBER ORAVITS  
COUNCILMEMBER OVERTON  
COUNCILMEMBER PUTZOVA  
 
4.
Preliminary Review of Draft Agenda for the March 3, 2015, City Council Meeting.*
 
* Public comment on draft agenda items may be taken under “Review of Draft Agenda Items” later in the meeting, at the discretion of the Mayor. Citizens wishing to speak on agenda items not specifically called out by the City Council for discussion under the second Review section may submit a speaker card for their items of interest to the recording clerk.
 
  Mayor Nabours asked that Council be prepared to discuss and consider the Community Reinvestment Plan that is scheduled for March 3, 2015. He also asked Council to take a look at the street maintenance map and proposal in advance of the meeting.
 
5. Public Participation

Public Participation enables the public to address the council about items that are not on the prepared agenda. Public Participation appears on the agenda twice, at the beginning and at the end of the work session. You may speak at one or the other, but not both. Anyone wishing to comment at the meeting is asked to fill out a speaker card and submit it to the recording clerk. When the item comes up on the agenda, your name will be called. 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 to have 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.
 
  Ben Murphy, on behalf of Flagstaff Lodging and Restaurant Association, addressed Council regarding the easement in Tusayan and the harm it could cause to tourism in Flagstaff.
 
6. Presentation from Closing the Gap Coalition   
 
  Housing and Grants Administrator Leah Bloom introduced Vice President of Southwest Behavioral Health Services Lauren Lauder and Housing Team Lead of Catholic Charities Camie Rasband.
 
Ms. Lauder provided a PowerPoint presentation that covered the following:

  • CLOSING THE GAP
  • COLLABORATIVE COUNCIL
  • PARTICIPATING AGENCIES
  • SOME HISTORY
  • NATIVE AMERICAN CONNECTIONS
  • GOALS FOR THE CLOSING THE GAP
  • THE DETAILS
Ms  Rasband continued the presentation.

  • BRIDGE HOUSE PROJECT
  • THE BRIDGE HOUSE AND BEYOND
  • THE BRIDGE HOUSE NEXT STEPS
  • SUSTAINABILITY
Councilmember Overton asked if there is a lot of turnover at the property. Ms. Lauder explained that the intent is for the home to be permanent housing; there is the possibility that the initial eight people would stay there for the duration and work with Catholic Charities to get them into supportive permanent housing.
 
Mayor Nabours noted that until the chronic alcoholism is stopped there is a vicious cycle that is difficult to get out of. Ms. Lauder agreed that it is an issue. She stated that while there will be no alcohol use on the property residents will not be required to abstain from alcohol. Research shows that substance abuse will decline as a steady housing situation is presented. There will be treatment and other related services available to residents as well.
 
Councilmember Putzova asked what would be helpful for Council to think about in terms of future funding or projects. Ms. Lauder stated that they are currently working with the Department of Health Services on housing vouchers and that might be something that the City could assist with as well.
 
Councilmember Evans asked the plan to make sure that the residents are a positive part of the neighborhood. Ms. Rasband explained that there will be onsite staff at all times and this should help prevent a situation in which people who do not live there are hanging around or moving in. They are also working with the Southside Community to make sure that they are aware of what is going on and to be a part of the group.
 
           
7. City of Flagstaff 2015 Student Housing Work Plan Progress and Update   
 
  Deputy City Manager Jerene Watson introduced Dr. Sarah Bickle, Executive Vice President and Chief of Staff to the President at NAU.
 
Ms. Watson stated that an external group is being formed to also provide input and recommendations on the work plan. Staff would like recommendations from Council on individuals they would like to see in the group. The external group will meet for the first time in March and they will help shape and steer the regional plan with possible amendments, neighborhood components and property owner outreach. Also in March, Community Design and Redevelopment Manager Karl Eberhard with work with the team and bring the residential parking permit program back to Council for consideration.
 
In May 2015 the group will establish standard security conditions for development agreements and zoning ordinances. In June 2015 they will review and assess the current definition of family and also discuss the traffic impact analysis study. In June 2015 they will review the zoning code and examine use by right. In August 2015 the University Liaison to Neighborhoods will be in motion and will report on student housing work plan done by the external working group.
 
Dr. Bickle continued stating that the University has decided to offer the Office of Student Life and the five individuals that work with student organizations to help start this process. They are looking at the program that serves Colorado State University and trying to develop similar criteria. This service would be for anyone who is having issues with student housing groups. Through the orientation department the University would provide all students that do not apply for university housing the handbook “A Guide to Living Off Campus.” It would provide educational information on how to be good neighbors and citizens as well as the laws that would pertain to their activity and helpful information to those living off campus such as how to be a good renter, how to work with a roommate and how to host a successful social event within city ordinances.
 
Dr. Bickle extended an invitation to the City and other community services to participate in NAU's welcome events to introduce themselves and their services to the first year and continuing students.
 
Mayor Nabours thanked Dr. Bickle and the University for their role in the program.
 
8. Discussion of possible amendment to City Charter to address municipal election dates   
 
  City Clerk Elizabeth Burke provided a PowerPoint presentation that covered the following:

  • ELECTIONS IN FLAGSTAFF
  • AGENDA
  • COUNCIL DECISIONS REQUIRED
  • HISTORY OF ELECTIONS
  • OPTIONS – ELECTION DATES
  • OPTIONS #1, #2, OR #3 – PROS/CONS
  • OPTION #4
  • PRIOR YEARS DATA
  • ELECTION COST COMPARISON
  • OPTIONS – QUESTION TO VOTERS
  • QUESTIONS/COUNCIL DIRECTION
Mayor Nabours asked when the next election would be if the elections were set for the spring of even numbered years. Ms. Burke stated that the next election would be in May 2016 if the voters approved it in the August 2015 election. Mayor Nabours asked if the people that were elected in November 2014 would come up for election in May of 2018. Ms. D’Andrea confirmed that and Ms. Burke stated that the term of the Mayor would be extended to 3.5 years. Councilmember Oravits pointed out that if the elections were changed to Spring of even numbered years in 2020 all council seats would be up for election.
 
Mayor Nabours asked if multiple questions could be asked on the ballot to see what the public would like in terms of election dates. Assistant City Attorney Anja Wendel stated that the Council could put more than one Charter question on the ballot but there would be problems if more than one was approved. It would be necessary to pose the questions one at a time to avoid any overlap in approval to happen.
 
Councilmember Putzova stated that the most important consideration is how the election date will impact voter turnout; the Council should aim to maximize the turnout. Councilmember Brewster stated that even though statistics show state and national elections bringing in a higher percentage of voters there is no break out in the reports that show how many local people voted. Ms. Burke stated that staff tried to get this information from the County but it was unavailable. She added that while the Flagstaff precincts can be tallied to create a number there are a few precincts that include people outside the city limits.
 
Mayor Nabours stated that if the elections are done in conjunction with the state and federal elections then an all mail election is not possible whereas a spring election could be all mail. Councilmember Oravits asked what triggers the need to have a polling place election. Ms. Burke explained that the only requirement there is on election dates is that of increasing sales taxes; that election must be done at a City general election.
 
The following individuals addressed Council in support of a fall election in even numbered years:
  • Jane O’Donnell
  • Moran Henn
  • Emily Ross
  • Marilynn Wisemann
  • Jim McCarthy
The following comments were received:

  • Getting higher voter turnout and greater representation is the most important thing.
  • November elections work for getting people involved, the City should pursue it.
  • Outreach opportunities for voting are greater when City elections are done in conjunction with state and federal elections.
  • Partisanship is present in all elections; voter turnout is what is important.
  • Will need to address the issue of how no party designated and independents get their ballots.
  • Both parties are very active in the non-partisan election cycles. The real effect of changing the elections to spring would be less voter turnout.
Stuart McDaniel addressed Council in support of a spring election in odd numbered years stating that focusing on local issues is critical. Having a mail only election also increases voter turnout and Flagstaff is used to having its election in the spring.
 
Mayor Nabours stated that he would like staff to research if there is a way of presenting all options to the voters to let them decided.
 
Councilmember Oravits asked what the deadline is for Council to make a decision on the election dates. Ms. Burke stated that if the Council wants to move forward with putting the question on the August ballot the question would need to be called on the meeting of April 21, 2015.
 
Councilmember Oravits asked if the question is put on the ballot and it fails if the City would default to the state election date. Ms. Wendel stated that if the question failed the City would have a charter where the election dates do not match and would default to the November election with the state. Ms. D’Andrea added that if Tucson and Phoenix are successful with the appeal and charters prevail the City could arguably go back to the spring of even years; however, it is difficult to predict the outcome with any certainty.
 
A break was held from 7:51 p.m. through 8:04 p.m. at which time Vice Mayor Barotz left the meeting.
 
9. Boards and Commissions - Process Update and Proposed Manual Changes   
 
  Ms. Burke provided a PowerPoint presentation that covered the following:
  • CURRENT BOARDS AND COMMISSIONS
  • BACKGROUND
Deputy City Clerk Stacy Saltzburg continued the presentation.
  • BOARD AND COMMISSION OUTREACH
  • PAST MEMBERSHIP SELECTION
  • CURRENT COUNCIL INTERVIEW TEAM SELECTION
  • INTERVIEW TEAM CONSIDERATIONS
Mayor Nabours asked if there is a process in place that checks to see if the same interview team was used for past appointments on the same commission. Ms. Saltzburg explained that she does not go back to check past interview teams but if that is something that Council would like to have checked she can work that into the process.
 
Mayor Nabours asked Councilmember Evans if the presentation covered what she had requested. Councilmember Evans stated that it had and it allowed the Council and the public to further understand how the process works and how the interview teams are selected.
 
Councilmember Putzova stated that she would like to see more women represented on boards and commissions. She suggested increasing the outreach to focus on bringing more women to the applicant pool. Ms. Saltzburg stated that it is a good observation and indicated that staff is open to any recommendations on how to increase outreach to that or any other demographic. Councilmember Putzova added that she would like to see gender and diversity added to the list of considerations. Councilmember Brewster stated that she is not certain that categorizing people into certain groups would be beneficial to the process and would have concerns about considering people simply based on demographic.
 
Ms. D’Andrea continued the presentation.
  • PROPOSED MANUAL CHANGES
Mayor Nabours stated that he likes the proposed six month rule but that it does not address the contingency of resignation should the commissioner apply for another commission while in office. He asked if the intent is to prohibit the application unless they resign their current seat or allow it. Ms. D’Andrea stated that the intent when drafting the changes was to allow a current commissioner in the last six months of their term to apply for another commission and finish out their remaining term. Councilmember Overton stated that he would like to see commissioners fulfill their commitments to their current commission and would like to see a resign to run requirement if the commissioner is not within six months of their term expiring.
 
Mayor Nabours also asked that “as required by law” be added to the liaison section for better clarification.
 
Ms. Burke continued the presentation.

  • UPDATE – STREAMING

Councilmember Oravits asked for information on the cost estimates for increasing the meetings with the streaming vendor. Ms. Burke explained that staff’s recommendation is to increase the meeting number to 200 which would be an additional $10,000 per year.
 
10. Overview of City Council Legislative Trip to Washington D.C.   
 
  Deputy City Manager Josh Copley provided a presentation on the upcoming trip to Washington D.C. that covered the following:

  • COUNCILMEMBER REPRESENTATIVES
  • MEETING WITH FAA
  • MEETING WITH OMB OFFICE
  • MEETING WITH HOUSE NATURAL RESOURCE SUBCOMMITTEE
  • MEETING WITH SENATOR FLAKE
  • MEETING WITH ARMY CORP OF ENGINEERS
  • MEETING WITH CONGRESSMAN GOSAR
  • MEETING WITH CONGRESSWOMAN ANN KIRKPATRICK
  • MEETING WITH OFFICE OF UNDER SECRETARY OF AGRICULTURE
  • MEETING WITH SENATOR JOHN MCCAIN’S OFFICE
 
11. Possible Future Agenda Item:    Request by Councilmember Putzova to place the consideration of a Council Resolution pertaining to DACA (Deferred Action for Childhood Arrivals) on a future agenda.   
 
12.
Review of Draft Agenda Items for the March 3, 2015, City Council Meeting.*
 
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
 
  None
 
           
13. Public Participation
 
  None
 
14.

Informational Items To/From Mayor, Council, and City Manager; and request for future agenda items.

 
  Councilmember Brewster stated that she hopes that the Washington D.C. trip is successful and the City is able to see some results.
 
Councilmember Evans requested a Possible Future Agenda Item for a resolution against the Federal Forest Service Easement in Tusayan. This action will have negative effects on the environment and tourism in Flagstaff.
 
She also requested a memo from staff regarding the status of the water at the Red Gap Ranch wells including the quality of the water and the draw down effect of the springs.
 
She also offered a thank you to the Greater Flagstaff Chamber of Commerce for their Winter Fest event on Fourth Street; it was a great event and she was happy to see an event on Fourth Street. She thanked Cal Ranch and Pepsi for being partners.
 
Councilmember Evans also noted that there was a soft opening for the Market of Dreams located on Fourth Street in the same parking lot as Cal Ranch. This is a micro entrepreneurship program and multi-cultural marketplace.
 
Councilmember Oravits also stated that the event on Fourth Street was a great event. He also stated that it was great meeting with the Governor last week.
 
Mayor Nabours reported that last Tuesday he and Councilmember Oravits had a private meeting with Governor Ducey to discuss the items on the City’s State legislative agenda and the Governor was extremely receptive to the issues. They also spent time with Representative Gosar and other state representatives. It was a great opportunity to advance the City agenda.
 
15. Adjournment
 
  The Flagstaff City Council Work Session of February 24, 2015, adjourned at 8:53 p.m.




 
 
  _______________________________
MAYOR
ATTEST:
 

 
 
_________________________________
CITY CLERK
 


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /public/publish/print_minutes.cfm
Time Stamp 19-May-24 02:29 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
172 ms 172 ms 1 top level D:\inetpub\PublicPages\public\publish\print_minutes.cfm
47 ms 47 ms 1 D:/inetpub/PublicPages/public/publish/print_minutes_dsp.cfm
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 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 24 D:/inetpub/PublicPages/public/publish/clean_subject.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
172 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
all_codes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.dataSortOrder 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 @ 14:29:08.008
			select top 1 * from codes
		
getform (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
SELECT fas.form_num fas_form_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,
	   ft.* ,
	   m.meeting_name, m.meeting_fromthru_time, m.meeting_dt, m.meeting_loc, m.meeting_id,
	   agt.ag_template_name, agt.ag_template_id, codes.long_descr px_size, codes.descr pdf_format,
	   cv.misc_alpha vote_position, cr.misc_alpha roll_position,
 	   mt.agmemo_prefix, mt.agmemo_desc, mt.logo_plcmnt, mt.printed_logo, mt.meeting_type,
 	    ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, am.misc_alpha motion_verbiage, am.misc_alpha3 att_print_nametitle,
	   am.misc_alpha4 att_print_format, am.loc_code att_title_place, am.large_misc_alpha roll_title_place,
	   amm.misc_alpha prt_att_links, amm.misc_alpha3 page_start, amm.text_value1 pdf_header, amm.text_value2 pdf_footer,
	   amm.misc_alpha9 printLine
FROM fas
INNER JOIN MINUTES 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 crt ON (crt.code_type = 'AG_FONT' and crt.valid_code = ft.roll_text_size)
LEFT OUTER JOIN codes cv ON (cv.code_type = 'AG_JUST' and cv.valid_code = ft.vote_disp_position)
LEFT OUTER JOIN codes cr ON (cr.code_type = 'AG_JUST' and cr.valid_code = ft.roll_disp_position)
LEFT OUTER JOIN codes ct ON (ct.code_type = 'VOTE_WIDTH' and ct.valid_code = ft.vote_disp_width)
LEFT OUTER JOIN codes am ON (am.code_type = 'MinAddl' and
	am.valid_code = CAST(ft.meeting_id as varchar))
LEFT OUTER JOIN codes amm ON (amm.code_type = 'AddlMtgMin' and
	amm.valid_code = CAST(ft.meeting_id as varchar))
WHERE fas.form_id = 'MINUTES' AND
	  fas.form_num = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 46

get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 14:29:08.008
		SELECT 'Alpha','Alpha','Alpha','Alpha', min.ag_punct
		FROM meetings, minutes min
		WHERE meetings.meeting_id = ? AND
		      min.meeting_id = meetings.meeting_id
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 318

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT descr, long_descr, valid_code from codes WHERE code_type = 'AG_FONT'
	
getLvlPdf (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT long_descr, descr from getFonts
		WHERE valid_code = 'mediumText'
	
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 318 
getAllLines (Datasource=frsRO, Time=31ms, Records=17) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
SELECT ml._rowid _rowid, ml.form_num, ml.rev_num, ml.seq_num, ml.motion_text,  
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.page_br,	
	   c.descr as status_desc,

	   ai.box1_label, ai.disp_title, ai.box1_disp, ai.box2_label, ai.box2_disp, ai.box3_label, ai.box3_disp, ai.box4_label,
	   ai.box4_disp, ai.box5_label, ai.box5_disp, ai.box6_label, ai.box6_disp, ai.box7_label, ai.box7_disp,
	   ai.print_time, ai.time_label, ai.ainumber_label, ai.lbl_bold, ai.lbl_underline, ai.lbl_size,
	   ai._rowid as ag_item_rowid,
	   CASE WHEN ml.header_ln = 'Y' THEN 1	
	   		WHEN ml.footer_ln = 'Y' THEN 3
	   		ELSE 2 END AS line_sort,
	   
	   as1.sort_seq sort_level1,
	   CASE WHEN ml.ag_level2 != '' AND ml.ag_level2 != '0' THEN as2.sort_seq ELSE -1 END AS sort_level2,	
	   CASE WHEN ml.ag_level3 != '' AND ml.ag_level3 != '0' THEN as3.sort_seq ELSE -1 END AS sort_level3,
	   CASE WHEN ml.ag_level4 != '' AND ml.ag_level4 != '0' THEN as4.sort_seq ELSE -1 END AS sort_level4,	
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN ml.ag_memo_id ELSE -1 END AS sort_memo,
	   
	   ml.ag_size, ml.ag_underline, ml.ag_bold, ml.ag_center, ml.ag_italic, ml.disp_level,
	   am.allow_comment, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, ml.color_impact, ml.left_justify,		
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_time ELSE ml.ag_time END as ag_time,
	   
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action,
	   CASE WHEN ml.ainumber IS NOT NULL THEN ml.ainumber ELSE am.ainumber END as ainumber
FROM minutes_ln ml
LEFT OUTER JOIN ag_memo AS am ON (am.form_num = ml.ag_memo_id AND am.rev_num = ml.ag_memo_rev)

LEFT OUTER JOIN ss_ag_item AS ai ON (ai.form_num = 318 AND ai._rowid = am.ag_item_rowid)

LEFT OUTER JOIN codes AS c ON (c.code_type = 'MIN STATUS' AND c.valid_code = ml.ag_line_status)

LEFT OUTER JOIN alpha_sort AS as1 ON (as1.alpha_value = ml.ag_level1 AND CAST(as1.alpha_value AS binary(8)) = CAST(ml.ag_level1 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as2 ON (as2.alpha_value = ml.ag_level2 AND CAST(as2.alpha_value AS binary(8)) = CAST(ml.ag_level2 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as3 ON (as3.alpha_value = ml.ag_level3 AND CAST(as3.alpha_value AS binary(8)) = CAST(ml.ag_level3 AS binary(8)))
LEFT OUTER JOIN alpha_sort AS as4 ON (as4.alpha_value = ml.ag_level4 AND CAST(as4.alpha_value AS binary(8)) = CAST(ml.ag_level4 AS binary(8)))
WHERE ml.form_num = ?
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 46

getLines (Datasource=, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
			
	SELECT *
	FROM getAllLines
	WHERE getAllLines.header_ln = 'N' AND getAllLines.footer_ln = 'N'
	ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, ainumber, sort_memo
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
	select * from getAllLines where header_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
	select * from getAllLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
getheader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT *
		FROM getAllLines
		WHERE getAllLines.header_ln = 'Y'
		ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
	
all_docs (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid
	FROM minutes_ln ml,
		 minutes_docs docs
	WHERE ml.form_num = 46 AND
		  docs.form_num = ml.form_num AND
		  docs.rev_num = ml.rev_num AND
		  docs.ln_rowid = ml._rowid
all_minutes (Datasource=frsRO, Time=0ms, Records=14) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
	SELECT *
	FROM meeting_minutes
	WHERE form_num = 46 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
allMotions (Datasource=frsRO, Time=16ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT motion.ln_rowid, motion.motion_seq, motion.motion_text,
				motion.time_of_vote, motion.seq_num, motion._rowid, motion.motion_status as status_desc,
			   r.name motionName, r.title motionTitle, r2.name secondName, r2.title secondTitle,
			   c.descr status_desc
		FROM minutes_ln_motion motion
		LEFT OUTER JOIN minutes_roll AS r ON (r.form_num = motion.form_num AND
											  r.rev_num = motion.rev_num AND
											  r.valid_code = motion.motion_id)
		LEFT OUTER JOIN minutes_roll AS r2 ON (r2.form_num = motion.form_num AND
											  r2.rev_num = motion.rev_num AND
											  r2.valid_code = motion.second_id)
		LEFT OUTER JOIN codes AS c ON (c.code_type = 'AG STATUS' AND c.valid_code = motion.motion_status)
		WHERE motion.form_num = 46 AND
			  motion.rev_num = 0 AND
			  (motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		  AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
		ORDER BY motion.ln_rowid, motion.motion_seq
	
allVotes (Datasource=frsRO, Time=31ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes.cfm @ 14:29:08.008
		SELECT v.ln_rowid, v.motion_seq, v.valid_code, v.vote,
			   r.name, r.title, c2.descr vote_descr, c2.long_descr vote_type,
			   c2.misc_alpha3 disp_in_vote,
			   v.seq_num sort1, motion.time_of_vote, m.meeting_id,
			   c3.misc_alpha motion_verbiage, c3.long_descr vote_label,
			   CASE WHEN c2.long_descr = 'Y' THEN 1
			   		WHEN c2.long_descr = 'N' THEN 2
					ELSE 3 END AS sort2
		FROM minutes_ln_vote AS v
		INNER JOIN minutes AS m ON (m.form_num = v.form_num AND
								m.rev_num = v.rev_num)
		INNER JOIN minutes_roll AS r ON (r.form_num = v.form_num AND		
											  r.rev_num = v.rev_num AND
											  r.valid_code = v.valid_code)
		INNER JOIN codes AS c2 ON (c2.code_type = 'AG_VOTEOTHER' AND c2.valid_code = v.vote AND c2.misc_alpha3 = 'Y')
		LEFT OUTER JOIN codes AS c3 ON (c3.code_type = 'MinAddl' AND
			c3.valid_code = CAST(m.meeting_id AS varchar))
		LEFT OUTER JOIN minutes_ln_motion motion ON
						(motion.form_num = v.form_num AND
					 	 motion.rev_num = v.rev_num AND
					 	 motion.ln_rowid = v.ln_rowid AND
					 	 motion.motion_seq = v.motion_seq AND
					 	(motion.motion_status IS NULL OR motion.motion_status <> 'VERBIAGE')
		 AND (motion.obsolete <> 'Y' OR motion.obsolete IS NULL)
			 )
		WHERE v.form_num = 46 AND
			  v.rev_num = 0 AND (v.obsolete <> 'Y' OR v.obsolete IS NULL) 
		ORDER BY sort2, sort1						
		
qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 14:29:08.008
			select c.misc_alpha mHead_pad, c.misc_alpha2 mBody_pad, c.misc_alpha3 mPresent_pad, c.misc_alpha4 mAbsent_pad,
				   c.misc_alpha5 mStaff_pad, c.misc_alpha6 mOthers_pad, c.misc_alpha7 mAGtext_pad,
				   c.misc_alpha8 mMintext_pad, c.misc_alpha9 mMotion_pad, c.misc_alpha10 mVote_pad,
				   c.misc_alpha11 mRollSection_pad
			from codes c
			where c.code_type = ? and
			     c.valid_code = CAST(318 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1582
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1582 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1582 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1045 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1588
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1588 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1588 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1580
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1580 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1580 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1048 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1583
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1583 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1583 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1051 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1581
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1581 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1581 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1054 
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1591
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1591 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1591 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1057 
attachments (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1592
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1592 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1592 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1060 
attachments (Datasource=, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1590
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1590 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1590 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1063 
attachments (Datasource=, Time=0ms, Records=2) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1595
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1595 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1595 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1066 
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1593
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1593 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1593 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1069 
attachments (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1594
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1594 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1594 
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1584
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1584 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1584 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1075 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1586
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1586 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1586 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1078 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1585
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1585 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1585 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1081 
attachments (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT doc_name, doc_link, doc_dir, confidentiality, from_agenda
				FROM all_docs
				WHERE form_num = 46 AND
					  rev_num = 0 AND
					  ml_rowid = 1587
				ORDER BY sort_seq, doc_name
			
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT *
				FROM all_minutes
				WHERE ln_rowid = 1587 AND
					  meet_minutes <> ''
				ORDER BY seq_num
			
get_Motions (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
					SELECT * FROM allMotions
					WHERE allMotions.ln_rowid = 1587 
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
				SELECT * from sortList
				ORDER BY seqNum
			
getMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\print_minutes_dsp.cfm @ 14:29:08.008
						SELECT * from meeting_minutes
						WHERE meeting_minutes._rowid = 1084 


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\print_minutes.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=CFID=9905105; CFTOKEN=ddf1219d77f3eaa3%2DBB4F2EB0%2DCEC0%2DE22C%2D9D7641E72753D3E8
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=http://cityweb.flagstaffaz.gov/print_minutes.cfm?seq=46&id=&mode=External&reloaded=true
HTTP_URL=/public/publish/print_minutes.cfm?seq=46&id=&mode=External&reloaded=true&CFID=9905105&CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
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\print_minutes.cfm
QUERY_STRING=seq=46&id=&mode=External&reloaded=true&CFID=9905105&CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/public/publish/print_minutes.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=9905105
cftoken=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
hitcount=55
lastvisit={ts '2024-05-19 14:29:08'}
timecreated={ts '2024-05-19 14:29:01'}
urltoken=CFID=9905105&CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
Cookie Variables:
CFID=9905105
CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
Session Variables:
ailist=Query (11)
cfid=9905105
cftoken=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9905105_ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
subdir=/public/
tzoffset=0
urltoken=CFID=9905105&CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
URL Parameters:
CFID=9905105
CFTOKEN=ddf1219d77f3eaa3-BB4F2EB0-CEC0-E22C-9D7641E72753D3E8
id=
mode=External
reloaded=true
seq=46
Debug Rendering Time: 16 ms