Amy Sebring: Welcome to the EIIP Tech Arena! Amy Sebring: For the benefit of our first-timers, when you see a blue web address, you can click on it and the referenced Web page should appear in a browser window. Amy Sebring: After the first one, the browser window may not automatically come to the top, so you may need to bring it forward by clicking on a button at the status bar at the bottom of your screen. Amy Sebring: We will start with a presentation, and then follow with a Q&A session for your questions and comments. Right before we begin the Q&A portion we will review the procedure. Amy Sebring: Please do NOT send direct messages to the speaker or moderator as it makes it difficult for us to follow the discussion. Amy Sebring: Background information for today's session may be found at http://www.emforum.org/varena/990825.htm ... Amy Sebring: Today we are pleased to welcome Judy Jaeger, Planner with the Georgia Emergency Management Agency (GEMA). Amy Sebring: Judy has been involved with a project to develop a database application for people with special needs. The platform they are using is Lotus Notes, however, I believe the concepts embodied could be transported to other platforms without much difficulty. Amy Sebring: Welcome Judy. Thank you for joining us today. Judy Jaeger: I'm glad to be here! Judy Jaeger: Georgia's Special Needs Data Base was developed by a task force comprised of representatives from Emergency Management, Emergency Medical Services, Public Health, Home Health Care, medical facilities and the Department of Family and Children Services. The data base was first designed as a Dbase stand-alone program, but we found we needed greater flexibility than that program offered. After a beta test, we converted to a Lotus Notes program because that format could be loaded onto our server at Judy Jaeger: GEMA and shared with almost all counties in Georgia. Judy Jaeger: The data base is intended to serve as a system to record and follow our People with Special Needs if they do not have care takers and transportation arrangements in place. Just by asking the questions to collect data, we force people to think about their own preparedness plans. Judy Jaeger: Often, by the time we finish a data collection interview, the person with special needs realizes that they have arrangements in place to serve them during an emergency or disaster. Judy Jaeger: Amy, let's take a look at Slide 1, please. Amy Sebring: http://www.emforum.org/varena/GEMA/Slide1.htm Judy Jaeger: This is the title screen of the data base. From here, you can either enter original data or skip directly to a report. Some of the report fields are indicated by the darker boxes on the right. Judy Jaeger: Slide 2, please Amy Sebring: http://www.emforum.org/varena/GEMA/Slide2.htm Judy Jaeger: "Client information" includes demographic data and a large field to insert directions to the person's home. Judy Jaeger: Slide 3, please, Amy. Amy Sebring: http://www.emforum.org/varena/GEMA/Slide3.htm Judy Jaeger: We included a contact screen so we know who can provide reliable information about the person's special needs and possibly the names of a couple of neighbors in case we have trouble communicating with this individual. Judy Jaeger: Slide 4, please. Amy Sebring: http://www.emforum.org/varena/GEMA/Slide4.htm Judy Jaeger: Our medical information is pretty comprehensive. This page alone helps us plan for the level of care and equipment we will need at a shelter where this person is housed...You might notice in three categories, we allowed space for "other" information, then we provided a box in the lower right corner for further explanation. Judy Jaeger: This page is keyed so that anyone with allergies has a red alert sign beside their name in any given report.... Judy Jaeger: This way, the data manager knows to look closely at this person's background to determine if it is a food allergy, medication allergy, or such. Judy Jaeger: Slide 5, Amy? Amy Sebring: http://www.emforum.org/varena/GEMA/Slide5.htm Judy Jaeger: Georgia's Home Health Care agencies have agreed to continue providing services whenever their patient must evacuate to a shelter, so we collect data on the agency providing home health care.... Judy Jaeger: We also indicate Medicaid and Medicare clients, as they might receive transportation assistance through their programs. Judy Jaeger: Slide 6, please. Amy Sebring: http://www.emforum.org/varena/GEMA/Slide6.htm Judy Jaeger: We capture the provider of information about our People with Special Needs, and date the information. The program automatically assigns date and time when the data set is opened.. ... Judy Jaeger: For EMA use, we have some counties who use planning zones (primarily for evacuation purposes), so we added a collection point for that information...At the lower right, you might notice "Level of Need." ... Judy Jaeger: The American Red Cross and our Division of Public Health agreed upon five different levels of need, from one to five, with "one" being an ambulatory person who can stay comfortably in a congregate shelter. Level five is a person who would likely meet admission standards at a hospital. Judy Jaeger: Slide 7, please, Amy... Amy Sebring: http://www.emforum.org/varena/GEMA/Slide7.htm Judy Jaeger: ...shows the drop-down information provided to the data entry person when a particular level of need is chosen. Judy Jaeger: And I have one final slide, #8. Amy Sebring: http://www.emforum.org/varena/GEMA/Slide8.htm Judy Jaeger: A bright blue screen pops up as soon as this data base is opened...All parties involved in the development were concerned about confidentiality issues.... Judy Jaeger: This screen serves as a reminder that this data base is to be used for the care and management of People with Special Needs, and that the information contained here is proprietary. These People with Special Needs have given us their consent to include them in our data base, and we need to guard their privacy carefully. Judy Jaeger: That's about it for background information....Amy, are you ready for questions now? Amy Sebring: Thank you very much Judy, I am sure we will have a few questions ... Amy Sebring: I do want to say that because of confidentiality ... Amy Sebring: we could not show the summary reports ... Amy Sebring: as they contain real data. But that is where the computer power comes in, right Judy? Amy Sebring: Audience please enter a question mark (?) to indicate you wish to be recognized, go ahead and compose your comment or question, but wait for recognition before hitting the enter key or clicking on Send. Amy Sebring: We now invite your questions or comments. David King: ? Amy Sebring: David please. Daryl Spiewak: ? David King: Judy...did you look at using existing E-911 systems for making this info available? Russell Coile: ? Judy Jaeger: Two year ago, when we were developing this system, we had fewer 911 systems in Georgia than we have now. We did what we thought would reach the most counties. Amy Sebring: Russell please. John Pine: I assume that the database is maintained at the state level with access by counties? Amy Sebring: Oops sorry Daryl, will come back to you. Russell Coile: If one is just starting, how would one find out who are these folks to ask them for info? David King: ? Judy Jaeger: In Georgia, we identify our People with Special Needs through Home Health Care and social services or referrals. Amy Sebring: Judy, go ahead and address John's question next please. Judy Jaeger: John... Judy Jaeger: yes, we maintain the data base at the state level. Amy Sebring: Daryl please. Daryl Spiewak: How often do you have to review the database and how much time/resources do you devote to database maintenance? Amy Sebring: ? Judy Jaeger: The data base is maintained at the county level.... Judy Jaeger: after the initial effort of inputting data, we ask that they review it periodically to be sure that it is up to date...This does not require a great deal of their time.... Judy Jaeger: and, some counties are lucky enough that Public Health actually comes by to input and update data! Amy Sebring: David King please. cam king: ? David King: Is this database kept at a central site and then accessed via Internet by the counties? John Pine: ? Judy Jaeger: not really INTERnet, it is more INTRAnet. Amy Sebring: Does the county do the initial data collection/interviews and how many counties do you have participating now? David King: ? Judy Jaeger: Yes, the county does data collection. they have a paper form that can be submitted by a referring agency... Merrily Powell: ? Judy Jaeger: only a dozen or so counties are using the system so far...they were eager to get set up. Amy Sebring: Cam please. cam king: David/Judy could you expand on how you looked at the E911 as part of this concept? David King: E-911 has some fields for Special Notes that can be entered and come up when that person calls in or you check the database on them or their phone Judy Jaeger: Simple--I really didn't. I had a dBase system that we modified and blended into Lotus Notes. Amy Sebring: John, you are next I believe. John Pine: What is the reaction from county emergency management officials to this system? scope of the data - ease of use - application to their needs. Amy Sebring: ? Judy Jaeger: Several of my more active EMA Directors played a large part in beta-testing this system. I heard plenty from them when they tried the Dbase system. I listened to their input and made sure to address their issues... Judy Jaeger: they seem to be very pleased with the user-friendly system here. Amy Sebring: David King please. David King: What kind of numbers do you find (special needs people per county or percentage of population?) How big of a group? Judy Jaeger: Initially, our EMA Directors told us that they had HUNDREDS of people with special needs.... Judy Jaeger: but when we implemented a tracking system, the numbers plummeted. In reality, they have a small percentage (maybe 1%) of people with special needs. Amy Sebring: Merrily please. Merrily Powell: I'm sorry if this was covered in the beginning, but how are all of the counties and the state EMA connected so that they all access and benefit from this data? Judy Jaeger: We share a Lotus Notes system via our server at GEMA....the counties replicate a copy of the data base and use it from their local computer. Amy Sebring: Judy, my experience is that there has been a great reluctance to get involved with this. What was the specific impetus in Georgia? Why did you do this? Judy Jaeger: Our coastal counties were worried that we would leave behind someone frail, so they begged for a system. David King: ? Amy Sebring: David King please. David King: Have you worked with ARC on Special needs population training for responders? Judy Jaeger: No.. Judy Jaeger: David... Amy Sebring: ? Marilyn Barker: ? Judy Jaeger: The ARC played a role in the development of this program. Amy Sebring: Judy, we have previously done a session on Public Health plans in Georgia with Anita Kellogg ... Amy Sebring: I take it that Public Health has been involved? How did you do training on the system? Marilyn Barker: Once you have these people identified, what then? Who transports them to where they need to go? Judy Jaeger: Yes, public health was involved....Most of our data base users are self-taught. We had already provided extensive Lotus Notes training, so this was just an additional program for them. cam king: ? Kevin Farrell: ? Amy Sebring: (response to Marilyn's question coming) John Pine: ? Judy Jaeger: Marilyn, the local EMA Director appoints a transportation manager to be responsible for moving non-ambulatory folks. ,,, Judy Jaeger: This is just a tracking system. The local EMA than knows to consider these folks when he/she writes a plan. Amy Sebring: Cam please. Marilyn Barker: I work w/ the local EMA director. We do not have the manpower or the funding for this. cam king: Judy - will Lotus Notes convert to Microsoft Access or did they all need to go to Notes? Judy Jaeger: What funding do you need? ? Judy Jaeger: Cam, one of the good features about Lotus Notes is that is exports easily into Access so you can manipulate data if you'd like to. Amy Sebring: They already had Notes didn't they Judy? Judy Jaeger: yes Amy Sebring: Kevin please. Gil Gibbs: ? Kevin Farrell: I'm not real familiar with Notes, but could your data be integrated into a GIS like those used in some 911 Centers? I'd be interested in viewing the information spatially... (BTW - our GIS interfaces with an Oracle 7 db) Judy Jaeger: Once you export the data, you can use Access or excel to save the DB in whatever DB type necessary (except maybe Oracle)... Judy Jaeger: we have in the past integrated Lotus Notes Data with ArcView Kevin Farrell: In our case, it would have to be usable by Oracle... Judy Jaeger: sorry Marilyn Barker: ? Amy Sebring: I am sure you could replicate in Oracle Kevin! Amy Sebring: John please. John Pine: Given that databases are difficult to build and maintain - did you consider other options - i.e.: just identifying special needs shelters without attempting to identify the population. Kevin Farrell: Yes, I think we could too. I like the concept... Judy Jaeger: John, we have worked hard to identify shelters where we can accommodate a wide range of people with special needs. Amy Sebring: Gil quickly please. Gil Gibbs: To address the legal side, is it advisable to have an M.D. on staff or on the panel of evaluators? Judy Jaeger: absolutely. Amy Sebring: (Marilyn's will be the last we have time for. Marilyn please. Marilyn Barker: Just wanted to say thanks for developing the software. Judy Jaeger: If my experience can be useful to someone else, I am glad. We learned plenty from our earlier mistakes. Amy Sebring: Thank you very much for being with us today Judy and sharing this, we hoped you enjoyed it. David King: Judy.. it's a great idea and obviously a lot of time and thought went into it. Congratulations. Amy, great session and information, thanks. Judy Jaeger: my pleasure. Thanks, everyone, for visiting and allowing me to share this info. Amy Sebring: Would you like to put up an email address Judy for follow up? Judy Jaeger: Certainly: e-mail is Jjaeger@gema.state.ga.us or call (404) 635-7237. Amy Sebring: Before we go to Ava for upcoming events, I would like to take this opportunity to recognize Tom Hale and thank him for his pledge yesterday. Amy Sebring: //bell http://www.emforum.org/pledge.wav for Tom! Amy Sebring: If you have not yet made a pledge to participate in the Virtual Forum, please see http://www.emforum.org/eiip/pledge/pledge.asp Amy Sebring: We are getting close to the halfway mark to our goal! Now Avagene, upcoming events please. Avagene Moore: Thanks, Amy, and my appreciation to Judy for a great job today and a very interesting topic. ... Avagene Moore: Next Tuesday, August 31, 12 Noon EDT, the Central United States Earthquake Consortium (CUSEC), headquartered in Memphis, TN, will be hosting our Round Table. Look for further information on this session the first of the week. ... Avagene Moore: We begin September with a Virtual Library presentation by Claire Rubin, Claire B. Rubin & Associates. Next Wednesday, September 1, 12 Noon EDT, Claire will discuss a new project, Disaster Time Line (1965-2000), that provides a unique, graphic depiction of major disasters, both natural and technological, that have affected the emergency management policies in the US. ... Avagene Moore: That's all for now, Amy. Amy Sebring: Reminder, we will have an online transcript next week with links to the slides ... Amy Sebring: Thanks Ava and thank you audience. We will adjourn for now, but you are invited to remain for open discussion.