Print Minutes Return
CITY COUNCIL WORK SESSION
MARCH 31, 2015
COUNCIL CHAMBERS
211 WEST ASPEN AVENUE
6:00 P.M.
 
MINUTES
             
1. Call to Order
  Mayor Nabours called the Flagstaff Work Session of March 31, 2015, to order at 6:02 p.m.
             
2. Pledge of Allegiance
  The Council and audience recited the 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  
COUNCILMEMBER BREWSTER  
COUNCILMEMBER EVANS  
COUNCILMEMBER ORAVITS  
COUNCILMEMBER OVERTON  
COUNCILMEMBER PUTZOVA  

 Others present:  Interim City Manager Jeff Meilbeck; Deputy City Attorney Sterling Solomon.
             
4.
Preliminary Review of Draft Agenda for the 04/07/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.
             
A. Discussion of Ordinance No. 2015-03. (Zoning Code Amendment to permit freight/trucking in RD zone)
  Comprehensive Planning and Code Administrator Roger Eastman provided a PowerPoint presentation that covered the following:
 
MEETING PURPOSE
RD ZONE AMENDMENTS
             
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.
  Adam Shimoni addressed Council stating disappointment about SB1241 and its efforts to strike everything regarding the ban of plastic bags.
             
6. Revisions to the Special Event Permit Packet and Ordinance
  Recreation Services Director Brian Grube provided a PowerPoint presentation that covered the following:
 
SPECIAL EVENT PERMIT PACKET REVISIONS
HISTORY
DIRECTION NEEDED
MINOR REVISIONS
HISTORICAL PRECEDENT
HERITAGE SQUARE: PRIMARY RETAIL SALES
HERITAGE SQUARE: SECONDARY RETAIL SALES
 
Councilmember Brewster asked if the primary retail sales are determined on a first come first serve basis. Mr. Grube indicated that first come first serve is the typical way however, if they have historical precedent they would be given a higher priority.
 
HERITAGE SQUARE: ALCOHOL SALES
HISTORIC DISTRICT: STREET CLOSURES
 
Vice Mayor Barotz stated that she can see where it could be hard to define what substantially and unnecessarily is. Mr. Grube offered the example of a small fair that would like to close a street but only has a couple vendors and 100 people in attendance; that would be an example of where the discretion should apply. The suggestion is to make street closures a staff function with discussion and input by the Downtown District Manager.
 
FUTURE REVISIONS TO THE SPECIAL EVENT PERMIT PACKET
 
Councilmember Putzova asked how the street closure policies apply to downtown. Mr. Grube explained that currently any street closure would apply to the objective criteria; two way closures do not come to Council but one way street closures do regardless of location. Councilmember Putzova asked how it would be applied should the applicant not meet any of the criteria. Mr. Grube stated that it is not a cut and dry application and staff works with applicants to find alternative solutions.
 
INPUT NEEDED FROM CITY COUNCIL
 
Councilmember Oravits stated that he would like to further discuss Wheeler Park and the impacts to the lawn. Mayor Nabours asked if Wheeler Park is now able to be used. Mr. Grube stated that it is able to be used but there are some restrictions this season. The intent is to not necessarily deny Wheeler Park events but come up with other solutions that benefit all. The goal is to work through the restrictions and find a balance between passive and active use.
 
Councilmember Overton asked if it would be up to the applicant to limit the retail sales or if the City would limit the number of retailers allowed. Mr. Grube explained that it is staff’s recommendation to come up with a number limit; they would like to find a suitable number and through trial and error come to a good solution. Councilmember Overton asked if the secondary retail has to be related to the primary use. Mr. Grube stated that they do not have to be but they typically are. Councilmember Overton suggested that making the retail vendors affiliated with the event could be a way to limit the number. He expressed concern about it being difficult to pick and chose who is in or out and it really should be up to the primary applicant to determine who to bring in for retail.
 
Vice Mayor Barotz asked how the Council came to review this document as it seems to tread the line between administrative and policy. Mr. Grube explained that technically taking street closures and the event packet to Council is not supported by code but it seems to have become an accepted practice that was started some time ago. If it does not work with staff control it can always be brought back to Council.
 
Councilmember Putzova asked if any commissions are involved with approving special events. Mr. Grube stated that the Parks and Recreation Commission is probably the closest but they do not weigh in on or approve events. They will be involved with input and suggestions of the changes in the permit packet.
 
Councilmember Brewster stated that she is glad that staff has involved the personnel from the downtown district in this process.
 
Terry Madeksza addressed Council on behalf of the Flagstaff Downtown Business Improvement and Revitalization District stating that they are in support of the special event process that is being proposed. She indicated that they were given an opportunity to review the document and provide input prior to this meeting. Mayor Nabours asked if the group is satisfied with how the policy is written now. Ms. Madeksza stated that they feel that the City is moving in the right direction and staff has been very supportive of input and comments from the District. Vice Mayor Barotz asked if the District has any specific thoughts about the recommendations and staff being able to make changes to the packet for Council to review annually. Ms. Madeksza stated that she feels comfortable with the dialogue so far and comfortable with the added language of having the District involved in the process.
 
Debbi Grogan addressed Council with concerns about the wording in the packet. She stated that she and other event producers were not included in the process. She expressed concern about Wheeler Park and the lack of specific wording for new events. Councilmember Oravits asked about the challenges at Wheeler Park. Ms. Grogan stated that taking the City Council out of the process completely is concerning; while the staff is great now she is concerned about what happens when new people come in.
 
Matt Ziegler addressed Council with concerns about not being included in the process. He expressed concern about all the authority going to the Public Works Director. He also has concerns with events being worked around the three day watering schedule and feels that bounce houses should be permitted for more than one day. Councilmember Oravits asked how long Hullabaloo has been held at Wheeler Park. Mr. Ziegler stated that the event has been held there for the past five years. They will only be doing a one day event this year due to the park conditions but they are looking forward to next year knowing they can do a two day event.
 
Councilmember Evans asked who was contacted regarding the changes in the packet. Mr. Grube stated that staff began the process 18 months ago and they contacted some of the event producers. Staff has not met with event producers recently but the comments are reflective of what was gathered throughout the process. The historical precedent is a new concept. Councilmember Evans suggested that a focus group with event producers could be helpful in determining what items will be impactful for their events. She also expressed concern with all of the authority going to a single staff member and suggested a committee may be a better option than just one person. Councilmember Putzova added that she would like to see some of the City commissions involved. Mayor Nabours asked if she is suggesting that a commission have the ability to say yes or no to events. Councilmember Putzova responded that it may be worth trying it out for a season and then review the process to see how it went. Mayor Nabours asked staff to provide the Council with some pros and cons with the Parks and Recreation Commission taking on this role. Mr. Grube stated that a pro would be having additional sets of eyes looking at the events. Some of the cons would be keeping the Commission impartial on the events and since they only meet once a month it could slow the application process down.
 
Vice Mayor Barotz also expressed concern about vesting the authority in a single person and she would welcome a discussion on how the City could set up a structure that involves feedback and decision making without involving the Council.
 
Mr. Meilbeck stated that it seems that this much detail and approval seems onerous to Council but seems too much for one person; he suggested that staff can look for things in the middle that find the right balance. Councilmember Brewster suggested that a small committee that makes a recommendation on events to the City Manager may be a way to keep the process objective. Mr. Grube added that the appeal process for an event would go to the City Manager not the City Council.
 
Councilmember Oravits requested additional information on Wheeler Park; what events are planned for the year and how the City can accommodate the historical events.
 
Councilmember Putzova stated that it appears that there is great variability in the events that are seen in the community. Some of the insurance requirements seem too strict but in some cases they are not enough. She indicated that she would like to discuss the size and types of events and the type of liability the City may face. Risk Manager Dean Coughenour stated that every event will be reviewed differently and that there is a base line for insurance. There are some events that create a bigger hazard and there are various elements that could waive the requirements for insurance whereas increased risks could require additional insurance. It really depends on the event and the risks that they pose. All events must come to Risk Management for review and approval. Mayor Nabours asked if Risk Management determines how much insurance is required. Mr. Coughenour stated that he does make that determination and in most cases $1 million general liability insurance is all that is required; more insurance is typically required for fireworks and parades. Councilmember Putzova recommended that the language be clearer that higher insurance limits may apply. Councilmember Overton stated that increased insurance requirements could make it difficult for someone to secure a policy and he is concerned about getting to a point where such high insurance limits would limit events that come to Flagstaff. Mr. Coughenour explained that at times the City has reached out to the various brokers to work together to find a good solution for both parties; they try to be as accommodating as possible.
 
Vice Mayor Barotz asked Mr. Grube to share with Council the concerns event producers have with the language after meeting with them. Mr. Grube agreed and stated that they will also work to clear up the insurance language. He went on to say that the process is a dynamic one and it is important to get as much input as possible. Staff will gladly reconvene with Council to provide all of the input gathered and bring forward additional changes and clarifications.
 
A break was held from 7:14 p.m. through 7:26 p.m.
             
7. Parking Issues in the Vicinity of the Northern Arizona University Campus
  Community Design and Redevelopment Manager Karl Eberhard addressed Council stating that this item came out of the student housing effort. There will be more demand for parking around NAU as more housing comes in. A parking permit was brought before Council that was rejected. The major issue is students parking north and west of campus who then walk to campus or ride the bus. Students are also now parking in the lots on Phoenix, the City Hall lots, as well as Walmart and Target.
 
Flagstaff writes about 5,000 tickets per year and about one third are written by enforcement officers in the Southside neighborhood; there is a need for more overtime and court time for the officers.
 
The parking enforcement officers cost about $55,000 per year and they are able to monitor approximately 200 to 350 spaces. There are about 750 spaces that need to be enforced so two to three officers are needed to cover the entire area. Tickets do not generate enough revenue to cover the costs of enforcement and increasing the ticket amounts does little to the return.
 
Staff has spoken with NAU who states they are committed to educating students and staff about options available for parking. Additionally, staff spoke with NAIPTA and they reported that they have implemented a student bus pass and they are looking at park and ride facilities and universal passes that would allow a student to ride from the east side of town to campus.
 
There are seven options that have been generated to possibly address the parking issues:
  1. Permit parking
  2. Paid on-street parking
  3. Parking Management Company
  4. Build more parking
  5. Promote alternative transportation modes
  6. Participate in park and ride
  7. None of the above 
Mayor Nabours stated that there is no real park and ride location other than what has happened with private properties such as the mall, Target and Walmart. Mr. Eberhard agreed stating that there are options for park and ride locations around the city.
 
Mayor Nabours asked if the officers needed for parking enforcement would be for continuous coverage or just various times of the day. Mr. Eberhard explained that it would be dependent on the number of officers assigned, the more officers there are the more cycles they can complete.
 
Councilmember Oravits asked about the revenue generated from the parking enforcement. Mr. Eberhard stated that the revenue does come close to covering the parking permit program as permits do have the ability to pay for the enforcement. On the paid parking the consultant made a recommendation of $1 per hour and $60 per month for a permit. He explained that parking kiosks are a more modern metering technology and it can be a physical kiosk as well as software based depending on what the community desires.
 
Councilmember Putzova asked what kinds of policies have been explored with NAU. Mr. Eberhard stated that while NAU is at the table they have their own directives that they are trying to accomplish with getting vehicles off campus and they have offered to help in some ways. Councilmember Putzova encouraged staff to push more in exploring policies that the institution can implement to reduce the number of cars in the neighborhood.
 
Mayor Nabours asked for the travel and parking options for students. Mr. Eberhard stated that students can take the bus, drive a car and park lawfully on the street or purchase a $440 campus parking permit and park lawfully on campus.
 
Mayor Nabours asked if the parking could be more randomly enforced so that people never know what days or times the areas would be enforced. Mr. Eberhard stated that while that discussion can occur it is often well worth the time and money for people to just take the ticket.
 
Councilmember Evans stated that parking continues to be a major issue with the Southside neighborhood area, businesses along Milton, City Hall, and within the Plaza Vieja neighborhood. Flagstaff is the only city in Arizona where the residents in neighborhoods adjacent to universities do not have the protection of some kind of residential parking program. The issue is that NAU has a policy in place that they want to be a walking university; people drive and park and then walk or bike onto campus. The Phoenix parking lot was intended to be a lot that would help downtown businesses have a place for their employees to park and now students take the spaces up and park all day long. She added that some of the streets in Southside do not have sidewalks, curbs and gutters so having designated parking spots would be helpful because people are parking in what they think is a random strip of dirt but is actually how someone accesses their house. The police are unable to enforce the parking there because there are no sidewalks, curbs and gutters.
 
Councilmember Oravits asked if the Phoenix parking lot is available all day. Mr. Eberhard stated that it is free all day parking. He stated that if the City were to move to a two hour enforcement strategy cost would be an issue because more staff would be needed.
 
Councilmember Brewster added that the students are also taking up tourist spots. The reality of the issue is that when there is free parking available closer to campus there is no incentive for other alternatives.
 
Councilmember Putzova stated that education is necessary every year, educating students on making the choice to bring fewer cars to town and utilize other transportation methods is key.
 
Councilmember Overton stated that there are some things that can be done at the university level; the root problem is student overflow into the neighborhoods and it is time for the University to help solve the problem. Councilmember Evans stated that NAU has a parking problem and the City has a parking problem; while discussions can be had with NAU at some point the City needs to address the City parking issues.
 
Mr. Meilbeck stated that NAU has managed their parking through incentives and decentives. Incentives are free bus service and decentives are high parking prices. The City’s challenge is to come up with a solution that will work and staff can continue to work on the pros and cons of each of the solutions offered earlier.
 
The following individuals addressed Council in support of a parking program:
  • Maury Herman
  • Charlotte Welch
The following comments were received:
  • Please keep in mind the Regional Plan when considering parking solutions.
  • Businesses are expending considerable resources trying to address parking on their private lots.
  • Any permit policy that is implemented will be a precedent for others.
  • As long as students can park for free they will.
  • There will need to be a lot of community pressure and legislative pressure to get NAU to convert some of their land to parking.
  • Suggest following the Tucson model and let districts expand block by block.

Mayor Nabours asked that staff look further into the solutions already given and look further at Tucson’s model as well as other areas with universities. Councilmember Oravits also requested cost estimates on what the solution will cost and where the funding will come from.
             
8. Consideration of Proposals: Remodel/Expansion of Municipal Court Building
  Court Administrator Don Jacobson provided a PowerPoint presentation that covered the following:
 
FLAGSTAFF MUNICIPAL COURT
HISTORY
REDUCING THE COST
PROPOSAL
PROPOSED SITE LAYOUT PLAN
PROPOSED OUTSIDE RENDERING
PROPOSED CROSS SECTION RENDERING
FIRST FLOOR FLOORPLAN CONCEPT
 
Vice Mayor Barotz asked if there would be a separate accessible entrance due to the raised first floor. Mr. Jacobson stated that there would be ramp similar to what is currently at City Hall.
 
Councilmember Putzova asked if Mr. Jacobson could speak to the type of building this would be from an energy perspective. Mr. Jacobson explained that the building would be a minimum of LEED silver certified.
 
Councilmember Oravits asked if there is a holding cell planned for prisoners being transported to the courthouse. Mr. Jacobson stated that one is included in the design.
 
Mr. Jacobson continued the presentation.
 
SECOND FLOOR FLOORPLAN CONCEPT
COSTS
 
Councilmember Oravits asked for the previous cost estimate, the current square footage, and if the building addresses the future needs of the Court. Mr. Jacobson stated that the previous estimate was $23 million and the current square footage is 10,000 square feet. With regards to the future needs of the Court, Mr. Jacobson explained that if space were available today the court would operate four courtrooms; the new concept allows for six courtrooms. The exact number of years it would last is difficult to determine, his best guess is that it would take the court through 20 years before they start to feel the pinch again.
 
Councilmember Oravits asked how the new design will impact parking. Mr. Jacobson stated that there is no change planned for the parking and the current parking would be maintained. Councilmember Oravits asked how many spaces are available now. Mr. Jacobson stated that there are 20 or 23 spaces at the south lot and staff parking to the north which would become separate and internal to the new structure. Councilmember Oravits asked if there is opportunity to have parking elsewhere. Mr. Jacobson explained that a parking garage has been proposed but there is no money in the proposal for a parking garage but should there be funding and opportunity a parking garage can be added.
 
Councilmember Overton stated that he is willing to see the project go through the site planning and zoning process but he is concerned with adding that much more building with no additional parking. He suggested looking for a joint venture with some of the neighboring properties that are in redevelopment mode for a parking solution. Vice Mayor Barotz also expressed concern about adequate parking and asked if the current parking lot is monitored. Mr. Jacobson stated that the parking lot is posted for two hour parking and it is patrolled.
 
Mayor Nabours stated that the Cherry Building was considered as an option as well and he asked if that building would be more suitable for a remodel with better parking. Mr. Jacobson stated that they did look at the Cherry Building. It is smaller than the current court building and it would have to take a larger expansion to get to the same level of proposal and it would chew through the parking lot that is there and while the parking is better now it probably would not be once it was complete.
 
Councilmember Oravits asked if it is possible to use the spaces underneath to increase parking and then offer offsite parking at the Cherry Building lot. Mr. Jacobson stated that they will be looking at that and other possibilities with the study. They are very aware of the parking limitations and know that they will not get through site plan approval without adequate parking.
 
Mr. Jacobson continued the presentation.
 
FUNDING CURRENTLY AVAILABLE
CURRENT FUNDING GAP
CLOSING THE GAP OPTIONS
 
Councilmember Oravits asked if it would be possible to phase the project out over time. Mr. Jacobson stated that it is possible but would require some changes to the design. Councilmember Oravits asked for phasing the project to be included as an option when brought back to Council.
 
Mr. Jacobson continued the presentation.
 
DOES THE COUNCIL SUPPORT THE CURRENT DEVELOPMENT PROCESS
OPTIONS
 
Councilmember Overton stated that he would like to see staff get through the site plan review process before moving forward with the request for proposals and design work.
 
Mayor Nabours asked if there is any benefit to selling the current courthouse and set aside the proceeds for a joint venture with the County. Mr. Jacobson explained that selling the property could generate some funding but any new property costs more. By recycling the existing property the project is much more cost effective. While having a new building from the ground up is preferred it has become an issue of doing it at a lower cost or not doing it at all.
 
There was consensus from the Council for staff to move forward with the site plan review process and report back.
             
9. US 180 Winter Congestion Report (REMOVED FROM AGENDA)
             
10. Discussion of Procurement Preferences Regarding Carbon Footprint and Disadvantaged Businesses (REMOVED FROM AGENDA)
             
11.
Review of Draft Agenda Items for the 04/07/2015 City Council Meeting.*
* Public comment on draft agenda items will be taken at this time, at the discretion of the Mayor.
  None
             
12. Public Participation
  None
             
13. Informational Items To/From Mayor, Council, and City Manager.
  Councilmember Brewster reported that NAU won the game.
 
Councilmember Putzova stated that she is worried about the bills that are going though the House and Senate lately and what the Governor has been signing; she expressed concern about the state of the State.
 
Councilmember Evans requested a possible future agenda item concerning Senate Bill 1241 which is the State blocking the ban of plastic bags. She stated that she would like to have a discussion about what the City Council can do as the bill seems to be overreaching.
 
She also requested a possible future agenda item on air bed and breakfasts. It is her understanding the people do not have to pay BBB taxes on these and she would like to explore if the City is able to regulate that and how.
 
Councilmember Overton wished everyone a happy Easter.
 
Vice Mayor Barotz requested a CCR on the City’s plans for a major train derailment in downtown. She would like to understand if a plan is required from the State or the Railroad as well.
 
Councilmember Oravits thanked Assistant to the City Manager for Communication Kim Ott and the Streets Section for the weekly updates on what work is currently being done and what is coming up.
 
Councilmember Oravits requested CCRs on the following:
  • The parking of campers and trailers in residential neighborhoods on a side lot; he would like to know what the code prohibits and if there is a need for it to be updated.
  • The winter parking ordinance; he would like to know the history on the ordinance, what it entails and how it is enforced. He is interested in looking at if the ordinance should be changed to be more based around snow events.
  • An update on the streaming of Board and Commission meetings and when it is anticipated that they will be online.
  • Information on any requirement there might be for buildings being pushed to the sidewalks; he would like to know if that is in the City code or if that is a staff discretion item. He would like the history and reasoning behind the requirement and where it applies.
He also requested a future work session item from Code Enforcement and Solid Waste regarding people piling stuff up around town. He would like to understand what the current process is for identifying these areas and what is being done to address them. He would like to know if there has been any direction from Council to prioritize code activities or if that would be helpful. He would like to know more about the bulky trash pick schedule and how it was determined to eliminate February. He would like for Council to discuss possible priorities on code enforcement activities. Councilmember Evans added that she would also like to know what resources are available to them and how it all works with only three employees.
 
Mr. Meilbeck reminded Council about the Pave the Way event Wednesday, April 1, 2015 at 11:00 a.m.
 
Mayor Nabours reported that he spent the day in Phoenix to participate in an emergency response seminar. Flagstaff was used as the example; the seminar focused on fire and flooding and the potential catastrophic results in and around Flagstaff and how State agencies would come to be involved with the events. Deputy City Manager Josh Copley and Fire Chief Gaillard were also in attendance. It did not answer every question but it developed a lot of connections that was helpful in finding out what other agencies do in regards to emergency response.
 
He also reported that he was invited to the House of Representatives for a Resolution in memoriam of Tyler Stewart. He was on the floor of the House with the Stewart family and representatives from the Flagstaff Police Department. The Stewart family received a standing ovation; it was a very moving and thoughtful reception.
             
14. Adjournment
  The Flagstaff City Council Work Session of March 31, 2015, adjourned at 9:08 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 04-May-24 03:02 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
250 ms 250 ms 1 top level D:\inetpub\PublicPages\agenda_publish.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/agpub_min_dsp.cfm
219 ms 219 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_content.cfm
16 ms 16 ms 1 D:/inetpub/PublicPages/public/publish/ext_agpub_top.cfm
15 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/Application.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
250 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 @ 15:02:03.003
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 15:02:03.003
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkForExtraFlds (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 15:02:03.003
			select * from codes c where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
		
getTZOffset (Datasource=frsRO, Time=15ms, Records=1) in D:\inetpub\PublicPages\agpub_client_defines.cfm @ 15:02:03.003
				select c.misc_alpha9 tz, c2.misc_alpha tz_offset
				from codes c
				left outer join codes as c2 on (c2.code_type = 'TIMEZONE' and c2.valid_code = c.misc_alpha9)
				where c.code_type = 'AddlSetup' and c.valid_code = 'SysSetup'
			
chkSite (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:02:03.003
		SELECT dist_name FROM fasinfo
	
AddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\agenda_publish.cfm @ 15:02:03.003
	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 @ 15:02:03.003
			select top 1 * from codes
		
meetingTypes (Datasource=frsRO, Time=0ms, Records=24) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:02:03.003
		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 @ 15:02:03.003
	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 @ 15:02:03.003
		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 @ 15:02:03.003
	SELECT * from codes WHERE code_type = 'AddlSetup' AND valid_code = 'SysSetup'
chkAddlSetup2 (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:02:03.003
	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 @ 15:02:03.003
		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 @ 15:02:03.003
		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 @ 15:02:03.003
	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 @ 15:02:03.003
	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 @ 15:02:03.003
	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 @ 15:02:03.003
	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 @ 15:02:03.003
	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 @ 15:02:03.003
	SELECT MIN(coll_name) coll_name FROM verity_collections
	ORDER BY coll_name
all_userdef (Datasource=frsRO, Time=16ms, Records=58) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:02:03.003
	SELECT code_type FROM user_define
all_codes (Datasource=frsRO, Time=0ms, Records=11) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:02:03.003
	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=0ms, Records=6) in D:\inetpub\PublicPages\public\publish\ext_agpub_top.cfm @ 15:02:03.003
		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) = 2015-03-01 00:00:00.0
Parameter #2(cf_sql_timestamp) = 2015-03-31 00:00:00.0

codesFields (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 15:02:03.003
			select top 1 * from codes
		
checkMinutes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
		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 @ 15:02:03.003
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 = 334 
get_temp_vars (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\agenda\agenda_utilities.cfm @ 15:02:03.003
		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) = 334

qCodes (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\min_print_utilities.cfm @ 15:02:03.003
			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(334 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 @ 15:02:03.003
	SELECT valid_code, descr, long_descr from codes
	WHERE code_type = 'AG_FONT'
final_check (Datasource=frsRO, Time=0ms, Records=3) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
	SELECT _rowid
	FROM ss_ag_item
	WHERE ss_ag_item.form_num = 334 
getAllMnLines (Datasource=frsRO, Time=63ms, Records=17) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
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 = 334 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 = 57 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=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
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 @ 15:02:03.003
	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 @ 15:02:03.003
	select * from getAllMnLines where footer_ln = 'Y'
	order by sort_level1, sort_level2, sort_level3, sort_level4
all_docs (Datasource=frsRO, Time=15ms, Records=10) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
		
	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 = 57 AND
		  min.rev_num = 0 
	  AND (docs.confidentiality IS NULL OR docs.confidentiality = '')		
	  
all_minutes (Datasource=frsRO, Time=0ms, Records=15) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
	SELECT meet_minutes, _rowid, ln_rowid, seq_num, time_of_vote, text_box_lbl, lbl_bold, lbl_underline
	FROM meeting_minutes
	WHERE form_num = 57 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=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1804 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1419 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1810 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1421 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1802 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1422 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1805 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1817 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1424 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1803 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1425 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1813 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1426 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1812 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1427 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1816 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1428 
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1814 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1815 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=0) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1806 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1430 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1808 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1431 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1807 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1432 
get_Minutes (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT *
			FROM all_minutes
			WHERE ln_rowid = 1809 AND
				  meet_minutes <> ''
			ORDER BY seq_num
		
SortedList (Datasource=, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
			SELECT * from sortList
			ORDER BY seqNum
		
getMinutesNow (Datasource=frsRO, Time=0ms, Records=1) in D:\inetpub\PublicPages\public\publish\agpub_min_dsp.cfm @ 15:02:03.003
					SELECT * from meeting_minutes
					WHERE meeting_minutes._rowid = 1433 
Departments (Datasource=frsRO, Time=0ms, Records=17) in D:\inetpub\PublicPages\public\publish\adv_search_selection.cfm @ 15:02:03.003
	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 @ 15:02:03.003
	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 @ 15:02:03.003
		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 @ 15:02:03.003
		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=3&get_year=2015&dsp=min&seq=334
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=3&get_year=2015&dsp=min&seq=334
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=9512691
cftoken=41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
hitcount=4
lastvisit={ts '2024-05-04 15:02:03'}
timecreated={ts '2024-05-04 15:02:03'}
urltoken=CFID=9512691&CFTOKEN=41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
Cookie Variables:
CFID=9512691
CFTOKEN=41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
Form Fields:
ATT_TYPE=AG
DISPLAY_ID=334
Session Variables:
cfid=9512691
cftoken=41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
dbtype=SQLSERVER
dsn=frsRO
extpathprefix=/public/
isexternal=true
logfilepath=d:\logs\
loggedin=false
sessionid=FASPUBLIC_9512691_41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
subdir=/public/
tzoffset=0
urltoken=CFID=9512691&CFTOKEN=41a6225e2446fc2-B814A4EB-0D42-0C36-D894AA217ABDFE6D
URL Parameters:
dsp=min
get_month=3
get_year=2015
id=
mt=ALL
seq=334
Debug Rendering Time: 15 ms