Return
 
JOINT CITY/COUNTY WORK SESSION
MONDAY, DECEMBER 3, 2018
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
 3:00 P.M.

 
MINUTES
             
1. Call to Order

Mayor Evans called the Joint City/County Work Session of December 3, 2018, to order at 3:02 p.m
             
2.
Pledge of Allegiance and Mission Statement

The Council, Board of Supervisors, and audience recited the Pledge of Allegiance and Councilmember Putzova read the Mission Statement of the City of Flagstaff.
MISSION STATEMENT
The mission of the City of Flagstaff is to protect and enhance the quality of life for all.
             
3. Roll Call:
NOTE: One or more Councilmembers/Supervisors may be in attendance telephonically or by other technological means.
BOARD OF SUPERVISORS PRESENT:

CHAIRMAN BABBOTT
SUPERVISOR ARCHULETA
SUPERVISOR PARKS (arrived at 3:09 p.m.)
SUPERVISOR RYAN

CITY COUNCILMEMBERS PRESENT:

MAYOR EVANS
VICE MAYOR WHELAN
COUNCILMEMBER BAROTZ
COUNCILMEMBER MCCARTHY
COUNCILMEMBER ODEGAARD
COUNCILMEMBER OVERTON
COUNCILMEMBER PUTZOVA
BOARD OF SUPERVISORS ABSENT:

VICE CHAIRWOMAN FOWLER




CITY COUNCILMEMBERS ABSENT:









  Others present:  City Manager Barbara Goodrich; County Manager James Jayne; City Attorney Sterling Solomon, Deputy County Attorney Rose Winkler.
             
4. Public Participation:

Public Participation enables the public to address the Council about an items that are not on the 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 on an item that is on the agenda 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 an opportunity to speak.
  Mayor Evans stated that Councilmember Barotz will have to leave the Council Meeting early due to a family emergency and asked her if she would like to make any remarks as this will be her last meeting as a Councilmember.
 
Councilmember Barotz provided a statement about her time on the City Council. She thanked the Council for their work during her tenure and thanked them for all the great things they have accomplished over the years. She thanked the voters for allowing her to serve two terms on the Council. She also thanked her elected official colleagues and City staff for their work towards helping Flagstaff be the best it can be.
 
Councilmember Barotz left the meeting at 3:15 p.m.

Monica Foos with the Flagstaff Family Food Center thanked the City Council and Board of Supervisors for collecting turkeys. Enough food was brought in to provide food boxes to over 470 local families.
             
5. Presentation of Joint Land Use Study Draft Final Report
  Interim Community Development Director Dan Folke introduced Coconino County Community Development Director Jay Christelman and Julie Bassuk and Bob Bengford with the consulting firm Makers who provided a PowerPoint presentation that covered the following:
 
COCONINO JOINT LAND USE STUDY
TODAY’S AGENDA
JLUS STUDY AREA
COMMUNITY OUTREACH
WORK PLAN
JLUS ISSUES & STRATEGIES
ISSUE CATEGORIES
STRATEGY CATEGORIES
DARK SKIES
LAND USE
ENVIRONMENTAL HEALTH
NEXT STEPS
JLUS: STEPS TO COMPLETION
COCONINO COUNTY ACTION ITEMS (SAMPLE)
FLAGSTAFF ACTION ITEMS (SAMPLE)
NEXT STEPS
 
Chairman Babbott thanked Councilmember Barotz for her work in the JLUS process. One of the things that was heavily discussed were land trades and how impactful those can be to a region. The process will ensure that all partners are proactive about potential land trades to benefit everyone. Supervisor Ryan added that the key part of the plan is coordination and working together as partner agencies.
             
6. Joint City and County Proclamation: NAU Cross-Country Championship Three-Peat
  Mayor Evans re-ordered the agenda and took Item 6 after Item 7.
 
The City Council and the Board of Supervisors approached the podium to recognize the NAU Cross-Country Team and present them with a joint City/County proclamation.
 
Chairman Babbott stated that a three-peat is an impressive accomplishment that brings to light the benefits of Flagstaff’s high altitude training.
 
Mayor Evans thanked the team for the way they represent the City of Flagstaff and she expressed pride in having them as students at NAU.
             
7. Update on 2020 Census Coordination and Outreach for the City of Flagstaff and Coconino County
  Comprehensive Planning Manager Sara Dechter provided a PowerPoint presentation that covered the following:
 
CENSUS 2020 COORDINATION AND OUTREACH UPDATE
WHY DO LOCAL GOVERNMENTS CARE ABOUT AN ACCURATE CENSUS?
ROLE OF THE CITY AND COUNTY IN THE 2020 CENSUS
HART TO REACH POPULATIONS
CENSUS 2020 MILESTONES
CENSUS 2020 JOBS
COMMUNITY CENSUS TEAM
CENSUS BUDGET
CENSUS BUDGET OVERSIGHT
WHAT IS PSAP?
PSAP IN COCONINO COUNTY
TIMELINE FOR PSAP
WHAT’S AFTER PSAP
 
Vice Mayor Whelan asked why the City did not just focus on its own jurisdiction. Ms. Dechter stated that there are a lot of efficiencies to be gained by having the City and County work together; the messaging and advertising campaign is uniform and combined so that the same message is being spread throughout the region.
 
Vice Mayor Whelan asked if there are any accommodations provided to Coconino County given the unique elements that it has. Ms. Dechter explained that the main accommodation is a dedicated Census office.
 
Councilmember McCarthy asked how the student population is counted and if it is based on their home location or the university. Ms. Dechter stated that the count is based on where a person lives on April 1, 2020. Part of the outreach will be helping students understand the importance of being counted in Flagstaff.
 
Supervisor Archuleta offered that the synergy between the City and County has been working very well and she complimented the work staff has done thus far. There are commonalities between the two agencies and the difficulty each has to locate certain populations. The intent is to collectively identify strategies to reach those hard to reach populations.
 
Supervisor Ryan stressed the importance of the Census count. It is important to make sure people understand the importance so the region is represented accurately.
             
8. Coconino Criminal Justice Coordinating Council Update
  Honorable Judge Dan Slayton addressed Council stating that the Coconino Criminal Justice Coordinating Council (CJCC) is a joint City and County opportunity. In August 2017, CJCC revised its mission and vision. The vision is that the people of Coconino County are safe, offenders receive efficient and just treatment, victims are protected and able to heal, and crime and recidivism is reduced. They proactively seek to ensure communities of Coconino County are safe, healthy, resilient, and thriving.
 
The mission is to exercise leadership in criminal justice innovation to improve community wellbeing, equity, justice, restitution for victims, and reduction in recidivism. They support and promote reforms that provide for continuous support of justice policy and services.
 
The CJCC was started in 2005 as an attempt to try and reduce the inmate population at the Coconino County Jail as the part of a Federal Consent Decree. The process of people and agencies coming together has developed into the current CJCC.
 
Judge Slayton highlighted the following successes of CJCC:
  • In partnership with the Adult Probation Department, they conceptualized an innovative program utilizing online delivery of cognitive behavioral therapies and mental treatment to probationers which resulted in an award of $700,000 Department of Justice grant.
  • Obtained unprecedented criminal justice history data access from the Arizona Department of Public Safety negotiating a Memorandum of Understanding with the Arizona Department of Public Safety and the Attorney General’s Office to obtain the information annually.
  • Helped Coconino County become a leader in criminal justice data utilization and research partnerships which led to an invitation by the White House Office of Social Innovation to provide expertise and input resulting in the creation of the White House 2016 Data Driven Justice Initiative. As a result of these meetings the US Department of Health and Human Services issued clarifying guidance regarding privacy regulations making health in criminal justice data sharing easier for local government. This data will help the City and County justify funding or not funding programs and services.
Chief of Adult Probation, Sarah Douthit continued the presentation:
 
JOINT CITY/COUNTY MEETING
VISION – THE FUTURE WE WISH TO SEE
CRIMINAL JUSTICE COORDINATING COUNCIL
MISSION – WHY CJCC EXISTS
GUIDING PRINCIPLES – HOW WE DO OUR WORK
VALUES AND BELIEFS
STRENGTHS – OUR SUCCESS DEPENDS ON IT
STRATEGIC FOCUS
GOALS
 
Deputy County Manager Dr. Marie Peoples continued the presentation:
 
GOAL 2 EQUITY
FAIRNESS AND IMPARTIALITY TOWARDS ALL CONCERNED
COCONINO COUNTY RACIAL/ETHNIC DEMOGRAPHICS
JAIL INCARCERATION AMONG COCONINO COUNTY RESIDENTS
GOAL 1. BEHAVIORAL HEALTH/MENTAL HEALTH/SUBSTANCE ABUSE
GOAL 2. EQUITY
GOAL 3. STRATEGIC INVESTMENTS
GOAL 4. DATA
THREE KEY TAKEAWAYS
 
Director of Legal Defenders Gary Pearlmutter continued the presentation stating that the CJCC has enabled its members to establish a strong working relationship between all of its members and these relationships are what has led the program to be successful. Past successes that CJCC is trying to build on include, crisis intervention training and the development of Recovery Court, Mental Health Court, and Veteran’s Court.
 
Mayor Evans stated that the work of CJCC is very valuable and she is excited that the effort is ongoing. She asked how the work and essence of CJCC can be more accessible to the general public. She also asked about the Multi-generational Intervention Initiative and how CJCC plans on incorporating the targeted populations into the design of the program. The work that LAUNCH, Flagstaff Medical Center, and the Northern Arizona Regional Behavioral Authority (NARBHA) are doing compliments the elements of CJCC. She suggested the consideration of something similar to Front Door for re-entry.
 
Ms. Douthit stated LAUNCH will be involved to identify what can be done for the children to prevent issues in the future. She expressed interest in the Front Door suggestion as well. Judge Slayton added that NARBHA is active in CJCC with constant communication and they are heavily utilized.
 
Vice Mayor Whelan stated that it is an honor to represent the City Council on the CJCC and the work that is being done is great for the community.
 
Supervisor Archuleta thanked the CJCC team for their leadership in the community. She appreciates the focus on looking at what it is that brings people into the system, what it is that needs to be addressed, and how to better assist people. Many of the services offered tend to be disjointed and people have to go to a number of places to get access to resources; anything that can be done to assist these individuals and make the process more accessible will not only benefit the individual but the community as well.
 
Councilmember Odegaard asked where the funding comes from to provide the various services. Judge Slayton stated that it comes through the City and County; coming together as one allows for the best utilization of the funding. The efforts of CJCC is to continue encouraging its members to work together and seek funding that provides complimentary services and support between all agencies.
 
Mayor Evans left the meeting at 5:07 p.m. and Vice Mayor Whelan took over as Chair of the meeting.
             
9. Coconino County Flood Control District Update
  Chairman Babbott stated that the Flood Control District update has been pulled from the agenda at this time. Mr. Jayne stated that the Board will be scheduling a hearing that allows the City Council to attend.
 
A break was held from 5:12 p.m. through 5:21 p.m.
             
10. Flagstaff’s Climate Action and Adaptation Plan
  Climate and Energy Specialist Jenny Neimann provided a PowerPoint presentation that covered the following:
 
CITY OF FLAGSTAFF CLIMATE ACTION AND ADAPTION PLAN
2017-2019 FLAGSTAFF CITY COUNCIL GOAL: TAKE MEANINGFUL CLIMATE CHANGE ACTION
CAAP PLAN DEVELOPMENT TIMELINE
WHY DO WE NEED A CLIMATE ACTION AND ADAPTATION PLAN?
CLIMATE CHANGE POSES RISKS TO EVERYTHING
THE BENEFITS OF A PLAN ARE BROAD
CLIMATE PLANS CAN ANSWER MANY QUESTIONS
PLAN DEVELOPMENT
STEP ONE: DEFINE HOW THE CLIMATE IS CHANGING IN FLAGSTAFF
TEMPERATURES HAVE INCREASED IN COCONINO COUNTY
COMPARED TO TODAY, BY 2050 WE EXPECT TO HAVE
STEP TWO: ACKNOWLEDGE THAT EVERYONE HAS A ROLE IN CLIMATE ACTION
HOST COMMUNITY CONVERSATIONS
TO LEARN WHAT ACTIONS THE COMMUNITY SUPPORTS
STEP THREE: ADDRESS BOTH MITIGATION AND ADAPTATION
MITIGATION MEANS CONSIDERING OUR CONTRIBUTIONS
ADAPTATION MEANS PREPARING FOR WHAT’S COMING
VULNERABILITY CONSIDERATIONS
STEP FOUR: BUILD ON THE GREAT WORK ALREADY BEING DONE
STEP FIVE: SET AMBITIOUS OVERARCHING GOALS
STEP SIX: DEVELOP STRATEGIES AND ACTIONS ACROSS SEVEN FOCUS AREAS THAT ADDRESS FLAGSTAFF’S UNIQUE CONTEXT
STEP SEVEN: ANALYZE POTENTIAL IMPACTS OF THE PLAN
POTENTIAL IMPACT OF THE PLAN
STEP EIGHT: CREATE A DETAILED IMPLEMENTATION STRATEGY
 
Chairman Babbott stated that he attended at least two of the open houses and they were incredibly well attended and they engaged community. It is a very comprehensive plan and he asked how changes in data will be integrated into the report over time. Ms. Neiman stated that some of those details are still being developed. All the goals and indicators will be put into a dashboard that will be updated as the Plan moves along.
 
Supervisor Ryan stated that past Regional Plans focused on higher density and when that began to come forward the community did not want it; he asked how the Plan will be modified as the City moves forward and changes. Ms. Neiman offered that the intent is to update the Plan every five years. The Plan is flexible in not defining implementation so it can be modified and developed along the way as the community sees appropriate. It is important to be thinking about the climate benefits of all developments that come to the City and the Plan can support making the conversations easier. The desire is to do things that help people accept the high-density housing and there needs to be better communication with the community in talking about the benefits of the things in the Plan. There will also be an annual check in with Council on what is working well and what is not.
 
Supervisor Archuleta asked what people had expressed about the fear of emissions and not being able to afford modern vehicles that are efficient. Ms. Neiman stated that they did not hear a lot about electric vehicles. There was a lot of talk about consumption and that a used car is probably greener than an electric car at this point as half of the emissions created by a car comes from the actual manufacturing rather than driving. The Plan identifies vehicle share options and supporting the efforts to educate people about these types of programs. It will be important to be creative in our thinking to help meet people where they are.
 
Chairman Babbott stated that the Board of Supervisors has been contemplating building codes and being more flexible about the reuse of materials; it is important that the regulatory components reflect climate action and adaptation values. Councilmember Overton added that there is some fear associated with moving away from normal and it makes a lot of sense to offer flexible alternatives. The City Council will be having similar conversations when it comes time to adopt new building codes. He encouraged the City Council to support the County in its efforts to incorporate some of their ideas into their codes.
 
Supervisor Parks agreed stating that there are large parts of the County in areas that do not have building codes and they are unable to afford a house that is energy efficient; the flexibility is important here and identifying other ways to be energy efficient can have impact.
             
11. Informational Items To/From Chairman, Supervisors and County Manager/Mayor, Council and City Manager
  Councilmember Overton offered appreciation to the County for their participation; this is his last joint meeting with the County and he appreciates the experiences that the City/County partnership has provided.
 
Councilmember Odeagaard thanked the Board of Supervisors for coming and being a part of the conversation and collaborating on things that affect both agencies.
 
Supervisor Parks expressed his appreciation for the continued partnership between the City and County. He wished everyone a Merry Christmas.
 
Supervisor Ryan stated that he was glad that the City and County could come together and collaborate on things. He offered his appreciation to outgoing Councilmembers Overton, Barotz, and Putzova.
 
Supervisor Archuleta also expressed her appreciation to Councilmembers Overton, Barotz, and Putzova for their years of public service. She wished everyone a Merry Christmas and Happy Hanukkah.
 
Councilmember McCarthy offered that it is always a pleasure to work with people who are working toward common goals. He appreciates the partnership with the County and thanked the Board of Supervisors for attending the meeting.
 
Ms. Goodrich echoed the appreciations and thanked the Board of Supervisors for attending.
 
Mr. Jayne stated that he appreciates the relationships between the City and County elected officials as well as the relationships between staff members.
 
Chairman Babbott also offered appreciation for the collaboration between the City and County. He recognized and thanked Councilmembers Overton, Barotz, and Putzova for their work and sacrifices made to serve the community.
 
Vice Mayor Whelan stated that the LAUNCH Steering Committee has been working hard on a proposal to come forward in the new year; they will be asking about funding and discussing the economic return on developing a high quality, free preschool program. She thanked the Board of Supervisors and stated that she appreciates the way the joint meetings are growing and the willingness to talk about all things, not just those that are agreed upon.
             
12. Public Participation

None
             
13. Adjournment

The Joint Work Session of the Flagstaff City Council/Coconino County Board of Supervisors of December 3, 2018, adjourned at 6:05 p.m.
_________________________________________
MAYOR


ATTEST:


_________________________________________
CITY CLERK

    

Level double AA conformance,
                W3C WAI Web Content Accessibility Guidelines 2.0

AgendaQuick ©2005 - 2024 Destiny Software Inc. All Rights Reserved.


Debugging Information
ColdFusion Server Standard 2016,0,16,320445
Template /agenda_publish.cfm
Time Stamp 29-Apr-24 04:35 AM
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
187 ms 187 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
156 ms 156 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
31 ms 31 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/Application.cfm
16 ms 8 ms 2 D:/inetpub/PublicPages/agpub_client_defines.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/508_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/agenda_utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/agenda/aq_copyright.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/user_attr.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/cfm_utilities/utilities.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/adv_search_selection.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/customHeader.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_head.cfm
0 ms 0 ms 1 D:/inetpub/PublicPages/public/publish/min_print_utilities.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:35:39.039
			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 @ 04:35:39.039
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 04:35:39.039
			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 @ 04:35:39.039
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:35:39.039
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 04:35:39.039
	SELECT misc_alpha6 subscribe_tab, misc_alpha7 officials_tab, misc_alpha8 ordinance_tab, misc_alpha9 resolution_tab, misc_alpha11 voting_tab, misc_alpha12 useTabs
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup2'
codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:35:39.039
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
		SELECT mt.meeting_type, mt.descr, c.long_descr notify_public
		FROM meeting_type mt
		LEFT OUTER JOIN codes c ON (c.code_type = 'MTG_MSG' AND c.valid_code = mt.meeting_type)
		WHERE mt.show_public = 'Y'
			
		ORDER BY mt.descr
	
useNotify (Datasource=, Time=0ms, Records=4) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT notify_public FROM meetingTypes WHERE notify_public = 'Y'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
	
chkAddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT c.*,
	 	c.misc_alpha6 subscribe_tab, c.misc_alpha7 officials_tab, c.misc_alpha8 ordinance_tab, c.misc_alpha9 resolution_tab,
	 	c.misc_alpha11 voting_tab, c.misc_alpha12 useTabs, c.datasortOrder noOfMonths, c.loc_code ApplyTab,
	 	c.misc_alpha14 otherTab, c.misc_alpha15 oth_tab_descr, c1.misc_alpha3 other_doc_type,
 		c1.misc_alpha tab_color, c1.misc_alpha2 time_period, c1.misc_alpha4 sort_res_ord,
 		c1.misc_alpha5 ord_tab_descr, c1.misc_alpha6 res_tab_descr
 	from codes c
    LEFT OUTER JOIN codes c1 ON (c1.code_type = 'AddlSetup' AND c1.valid_code = 'SysSetup3')
	WHERE c.code_type = 'AddlSetup' AND c.valid_code = 'SysSetup2'
contactInfo (Datasource=frsRO, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
		select text_value1 notify_public_contact, long_descr confLink
		from codes
		where codes.code_type = 'AddlSetup' and codes.valid_code = 'EmailSub'
MeetingInfo (Datasource=frsRO, Time=0ms, Records=8) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
		select valid_code
		from codes
		where codes.code_type = 'MTG_MSG' and codes.misc_alpha15 = 'Y'
fasinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT user_filedir_alias, min_dir_alias, use_minutes, use_agendaquick,
		srch_engine, isys_path, dflt_verity_coll, hart_version, user_defined
	FROM fasinfo
getFasInfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	select fasinfo.*,
	       c3.large_misc_alpha external_prefix, c3.misc_alpha2 active_directory, c3.misc_alpha3 ad_custsfx,
	       c3.loc_code allowExtNotes, c3.misc_alpha4 hostedInstall, c3.descr publTimeout, c3.text_value2 hosted_code
	from fasinfo
	left outer join codes as c3 on (c3.code_type = 'AddlSetup' and c3.valid_code = 'SysSetup')
AddlSetup (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	select text_value1, misc_alpha public_window, loc_code allowExtNotes
	from codes where code_type = 'AddlSetup' and valid_code = 'SysSetup'
begin_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT MIN(fis_yr) fis_yr FROM fas
	WHERE form_id = 'AGENDA'
end_year (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT MAX(fis_yr) fis_yr
	FROM fas
	WHERE form_id = 'AGENDA' AND final_apprvl = 'Y'
begin_collection (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=0ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
	SELECT c.code_type, c.valid_code, c.descr, c.obsolete, c.misc_alpha2, c.descr, c.dataSortOrder sort_order,
		CASE WHEN descr = '' THEN valid_code ELSE descr END AS time_descr
	FROM codes c
	WHERE c.code_type = 'AG TIME'
	
		OR code_type IN ('ud_tb1','ud_pd1','ud_cb1','ud_ta1','ud_ta2','ud_fi1','ud_fi1','ud_cb1','ud_fi3','ud_fi4','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_yn1','ud_fi12','ud_fi13','ud_tb2','ud_fi2','ud_dt1','ud_fims1','ud_fil1','ud_fi3','ud_fis1','ud_tb3','ud_fi4','ud_tb4','ud_tb5','ud_tb6','ud_fi5','ud_fi6','ud_fi7','ud_fi8','ud_fi9','ud_fi10','ud_fi11','ud_fi12','ud_fi13','ud_fi14','ud_fi15','ud_fi16','ud_fi17','ud_fi18','ud_fi19','ud_fi20','ud_fi21','ud_fi22','ud_fi23','ud_dt1','ud_fi14','ud_fi15','ud_dt2','ud_rs1','ud_fi24','ud_fi25','ud_tb7','ud_fi26')
		AND (opt_form_id = '' OR opt_form_id IS NULL)
	
get_agendas (Datasource=frsRO, Time=16ms, Records=7) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 04:35:39.039
		SELECT m.meeting_dt, m.meeting_name, m.meeting_id, a.form_num as ag_form_num,
			minutes.minutes_published, a.agenda_published,
			a.minutes_doc_name, a.minutes_doc_link,	a.default_doc_dir,
			minutes.default_doc_dir minutes_default_doc_dir,
			a.packet_doc_name, a.packet_published,
			minutes.form_num as min_form_num, minutes.minutes_packet_published,
			minutes.minutes_packet_name,
			ag_links.link_label as ag_link_label, ag_links.link_url as ag_link_url,
			min_links.link_label as min_link_label, min_links.link_url as min_link_url,
			 rel.large_misc_alpha as release_date, agt.meeting_type
		FROM meetings AS m
		INNER JOIN agenda AS a ON ( 
			a.meeting_id = m.meeting_id AND
			(a.agenda_published = 'Y' OR a.packet_published = 'Y')
		)
		LEFT OUTER JOIN minutes ON (
			minutes.meeting_id = m.meeting_id AND
			(minutes.minutes_published = 'Y' OR minutes.minutes_packet_published = 'Y')
		)
		INNER JOIN ag_template AS agt ON (agt.ag_template_id = m.template_id
		
			AND agt.meeting_type IN ('AIR','BOA','SALARY','CCBUDG','CCCSMWS','CCMTG','CCES','CCJWS','CCMTGF','CCSCM','CCSWS','CCWS','DVA','DA','FB','HPC','HOUS','IND','PQ','OSC','PR','PZ','PSPRS','SUS')
		
		)
		LEFT OUTER JOIN codes as rel ON (rel.code_type = 'AddlMtg' AND CAST(rel.valid_code AS INT) = m.meeting_id)
		
		LEFT OUTER JOIN form_links AS ag_links ON (
			ag_links.form_id  = 'AGENDA' AND
			ag_links.form_num = a.form_num AND
			ag_links.link_seq = 1
		)
		LEFT OUTER JOIN form_links AS min_links ON (
			min_links.form_id  = 'MINUTES' AND
			min_links.form_num = minutes.form_num AND
			min_links.rev_num  = minutes.rev_num AND
			min_links.link_seq = 1
		)
		WHERE m.meeting_dt >= ?

		  AND m.meeting_dt <= ?

		ORDER BY m.meeting_dt DESC, m.meeting_name
		
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2018-12-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2018-12-31 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:35:39.039
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
		SELECT TOP 1 * FROM minutes_ln_vote vote
	
getminutes (Datasource=frsRO, Time=62ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
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.date_final, fas.final_prt_date,
	   ft.* ,
	   m.meeting_name, m.meeting_dt, m.meeting_fromthru_time, m.meeting_id, m.meeting_loc,
	   agt.ag_template_name, agt.ag_template_id,
	   codes.long_descr px_size, codes.descr pdf_format, 
	   mt.agmemo_prefix, mt.agmemo_desc, mt.meeting_type,
 	   agt.pdf_header, agt.pdf_footer, ct.descr vote_width, crt.descr roll_format, crt.long_descr roll_px_size,
	   am.long_descr vote_label, 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
FROM minutes ft
INNER JOIN fas ON (fas.form_id = 'MINUTES' AND 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)
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 ft.meeting_id = 780 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 04:35:39.039
		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) = 780

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 04:35:39.039
			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(780 as varchar)
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MinPad

getFonts (Datasource=frsRO, Time=0ms, Records=7) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 779 
getAllMnLines (Datasource=frsRO, Time=47ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
SELECT ml._rowid ln_rowid, ml.ln_rowid ml_rowid, ml.form_num, ml.rev_num, ml.seq_num,
	   ml.ag_level1, ml.ag_level2, ml.ag_level3, ml.ag_level4, ml.header_ln, ml.footer_ln, ml.left_justify, ml.page_br,		
	   c.descr as status_desc,
	   
	   
	   ai.*,
	   
	   am.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.ainumber min_ainumber, ml.ag_memo_id, ml.ag_memo_rev, ml.ag_subject, ml.ag_title ag_heading,
	   ml.header_ln, ml.footer_ln, 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_title ELSE '' END as ag_title,
	   CASE WHEN ml.ag_memo_id IS NOT NULL THEN am.ag_action ELSE ml.ag_action END as ag_action
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 = 779 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 = 396 AND
	  ml.rev_num = 0
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo
getMnLines (Datasource=, Time=0ms, Records=13) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
SELECT *
FROM getAllMnLines
WHERE getAllMnLines.header_ln = 'N' AND getAllMnLines.footer_ln = 'N'
ORDER BY line_sort, sort_level1, sort_level2, sort_level3, sort_level4, min_ainumber, sort_memo	
getHeader (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
	SELECT *
	FROM getAllMnLines
	WHERE getAllMnLines.header_ln = 'Y'
	ORDER BY header_ln DESC, sort_level1, sort_level2, sort_level3, sort_level4
getFooter (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=16ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
		
	SELECT docs.sort_seq, docs.doc_name, docs.doc_link, docs.doc_dir,
			docs.confidentiality, docs.from_agenda,
	       
				'Y' can_look, 'Y' can_link	
			
			,
			ml.form_num, ml.rev_num, ml._rowid ml_rowid,
			min.minutes_published min_published,
			a.agenda_published ag_published
	FROM minutes min
	INNER JOIN minutes_ln AS ml ON (ml.form_num = min.form_num AND ml.rev_num = min.rev_num)
	INNER JOIN minutes_docs AS docs ON(docs.form_num = ml.form_num AND
		  							   docs.rev_num = ml.rev_num AND
		  							   docs.ln_rowid = ml._rowid
		  							
		  								AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
		  							)
	LEFT OUTER JOIN agenda AS a ON (a.form_num = min.ag_form_num AND a.rev_num = min.ag_rev_num)
	WHERE min.form_num = 396 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=9) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 396 AND
		  rev_num = 0 AND
		  print_box = 'Y' AND
		  meet_minutes IS NOT NULL
		  AND (obsolete <> 'Y' OR obsolete IS NULL) 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8644 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8647 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8642 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6164 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8643 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6167 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8652 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6170 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8655 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6173 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8651 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6176 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8650 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6179 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8654 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6182 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8653 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6185 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8648 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 6188 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8645 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 8646 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 04:35:39.039
			SELECT * from sortList
			ORDER BY seqNum
		
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:35:39.039
	SELECT dept_code, dept_desc, obsolete FROM dist_dept ORDER BY dept_desc
sysinfo (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:35:39.039
	SELECT use_agendaquick, use_minutes, public_verity from fasinfo
count_minutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:35:39.039
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, minutes AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.minutes_published = 'Y'
		ORDER BY m.meeting_dt 
count_agendas (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 04:35:39.039
		SELECT TOP 1 c.meeting_id
		FROM meetings AS m, agenda AS c
		WHERE c.meeting_id = m.meeting_id
		  AND c.agenda_published = 'Y'
		ORDER BY m.meeting_dt 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\PublicPages\agenda_publish.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=10.20.10.48:8555
HTTP_REFERER=
HTTP_URL=//agenda_publish.cfm?id=&mt=ALL&get_month=12&get_year=2018&dsp=min&seq=780
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.20.10.48
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\PublicPages\agenda_publish.cfm
QUERY_STRING=id=&mt=ALL&get_month=12&get_year=2018&dsp=min&seq=780
REMOTE_ADDR=10.20.230.5
REMOTE_HOST=10.20.230.5
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/agenda_publish.cfm
SERVER_NAME=10.20.10.48
SERVER_PORT=8555
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Client Variables:
cfid=9372921
cftoken=3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
hitcount=4
lastvisit={ts '2024-04-29 04:35:39'}
timecreated={ts '2024-04-29 04:35:39'}
urltoken=CFID=9372921&CFTOKEN=3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
Cookie Variables:
CFID=9372921
CFTOKEN=3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=780
Session Variables:
cfid=9372921
cftoken=3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9372921_3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
subdir=/public/
tzoffset=0
urltoken=CFID=9372921&CFTOKEN=3e66f5679990377f-A033EA97-0230-A89F-2438120C4C5EDF18
URL Parameters:
dsp=min
get_month=12
get_year=2018
id=
mt=ALL
seq=780
Debug Rendering Time: 0 ms