Hi everyone-
I am new to the forum and used to do a bit of database design a long time ago. I am a bit rusty and I'm having a problem with designing tables from imported excel data. My data is a dump of patient information with procedure and diagnosis codes. Each patient has a unique patient ID and may have multiple entries in the spreadsheet for individual encounter dates. The problem is that each one of these encounters may have multiple procedures and those are entered on individual rows as well.
So the patient number is the unique identifier for each patient (as different patients could have the same name) and I want to group the data by encounter and by patient. The only thing that changes in those rows for the same encounter is the procedure code fields. I need to be able to search the database by procedure code but I would need to see the other procedures also performed on the same date of service. Ideally, the data would have a single record for each encounter with one or more procedure codes in each record.
Any help in organizing this data would be greatly appreciated.
Thanks.