The Pediatric Procedure database is a Micrsoft Access v2.0 ...



The Pediatric Procedure database is a Microsoft Access v. 2.0 database which was created by our ER program director, CDR Paul Pearigan. I modified it and added a few forms and beefed up the presentation (some of which I stole from the transport database that Mike Cinoman had created). Both were kind enough to allow the sharing of the database.

Our residents keep track of their procedures using a checkbook with duplicate style checks. I have enclosed a copy of the form. They simply carry the checkbook of 25 around with them and then turn in the original to a secretary who inputs all the information. We then print up periodic reports for the advisers and for our quarterly evaluations. Most printing companies can easily make the checkbooks up for you and the residents find them extremely easy to use.

SAMPLE FORM:

| | | |

| |RECORD ALL |RECORD at least 10 |

|ResLName: |(Bone marrow |(Arterial Puncture |

| |(Cardioversion |(Bladder Cath |

|PL1 PL2 PL3 |(Central venous access |(Conscious sedation |

| |(Circumcision |(IV |

|PtLName: |(Intubation |(I & D |

| |(I/O |(DDST |

| |(LP |(Laceration repair |

|Last4: |(Thoracentesis, needle |(PAL |

| |(Thoracentesis, chest tube |(Pelvic exam |

|Age: |(UVC |(Rapid sequence |

| |(UAC |(Suprapubic |

|Date: |(Neonatal Resuscitation |(SQ/IM injections |

| |(Pediatric Resuscitation |(Venous blood draw |

|(Supervised? |(PAL | |

| |(PICC | |

|Dx: |(Pericardiocentesis | |

| |(Vaginal delivery | |

|Rotation: N P W E CHP CHED T Other | | |

How to use the database

When you open the file (proced.mdb) using Microsoft access you will get the main switchboard which you then use to import the resident’s names, the procedures, and generate reports. I have enclosed some sample resident and procedure data which you should delete after experimenting with the program.

If you decide to try it for your program, you must first enter your residents’ data using the “resident data entry form”. Once you have entered all of the residents, their social security numbers, graduation year, etc.; you can close this and use the “procedure entry form”. It is important to enter data on all the questions asked although you can delete some things if you want. Much of the data is used in generating the reports and it is often hard to figure out what is required in relational databases once they are constructed. Feel free to play around if you have experience in Access. I am still on the steep portion of the learning curve and it is getting steeper all the time.

Multiple procedures can be entered on a single patient by clicking on the “another procedure same patient” button (be sure the resuscitation box is only clicked once or it will record multiple resuscitations). All of the data is stored in table form as “procedure data” in the main database section. There are several different reports which are self explanatory. Just click on the report button on the main switchboard and choose the one that interests you. You need the last 4 digits of the Social Security Number of the resident for individual resident reports or you can look at the residents as a whole or by the year of graduation. The report by year group will also allow you to look at a particular level as they progress and breaks it down to by PL level. I have also found the ”procedure by rotation” report helpful in looking at the various rotations that we participate in.

You can individualize the database for your program by modifying the tables which contains the rotation list and the procedure list. The procedures listed are the ones we chose to track but each program is different. In addition, feel free to customize the reports by going to the design view and putting your own program’s name on the output. This is relatively easy.

It is relatively easy to use. I would be happy to answer questions and again am indebted to Paul Pearigan and Mike Cinoman whose ideas I plagiarized. The AAP is creating a database and there is a commercial product from San Antonio by a Steven Hecht which looked nice and is also based on Access. I had a chance to give it a test and it worked well. We had already been using our own for awhile and didn’t want to switch in mid-stream. Please contact me if needed.

LCDR Brad Poss

Director, PICU

Naval Medical Center San Diego

San Diego, CA 92134-5000

(619) 532-8266

wposs@snd10.med.navy.mil

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download