3 Replies Latest reply on Mar 17, 2014 9:25 AM by philmodjunk

    Patient Record/Lab Results

    rlamberts

      Title

      Patient Record/Lab Results

      Post

           I have been working on a medical record for the past 9 months or so and am at an impasse.  The record works pretty well in most areas, but I want to find a better way to do data input, such as lab results.  My first attempt was to make a table for lab tests that linked to the patient's index, which allowed input of the date, location, signature status, and value of the test results.  The problem is that the list of tests is very long, and has to be updated within the table to add any new tests that have not been previously done (and updated in the layout as well).  This also didn't allow the system to flag abnormal results, nor did it account for the fact that lab normals vary by sex and age.

           So I set about to try a different approach, setting up the following tables:

      Table 1 (Table_Patient): the patient's main record.

      Table 2 (Table_Terms): a table where each lab test's specific information is kept:

             
      1.           Test Name
      2.      
      3.           Type (Chemistry, Hematology, Microbiology, etc)
      4.      
      5.           Units
      6.      
      7.           High and low Normals (as well as thresholds for "Panic" values)

      Table 3 (Patient_Data): Where input of labs on a given date for a given patient are put in.

      Table 4 (Results_Input): Combining the data from 1-3 for a single lab result input:

             
      1.           Patient Info (from Table 1)
      2.      
      3.           Test Name/Type/etc. From Table 2
      4.      
      5.           Date of test results from Table 3
      6.      
      7.           Results of the test
      8.      
      9.           Flagging of result based on info from Table 2

           This is what the tables look like in my database.

           This works quite well for data input, and it does the flagging of tests that are abnormal, adds the correct units, and allows addition of tests without the addition of table rows.  Nice.  BUT, I am having lots of trouble figuring out how to get the information back out in a format I can use.  First, I would like to see a tabular list of test results like this (OK to switch X and Y axes):

           I need to be able to view lab results over time, and would like to see similar results over time as well (chemistry labs batched together, as they are often run together).  I also would like to be able to answer the important questions: "when was this person's last cholesterol test?", "what was the last thyroid results?", and "when are they next due for a liver test?"

           I am stuck.  I can't figure out how to push this data back in this kind of format.  Please help!!

        • 1. Re: Patient Record/Lab Results
          rlamberts

               P.S.  Sorry that the lists did not indent the way the should have.

          • 2. Re: Patient Record/Lab Results
            rlamberts

                 Any Help here?

            • 3. Re: Patient Record/Lab Results
              philmodjunk

                   This is not a question that can be answered briefly. I had a long answer ready to post here and then a forum software glitch logged me out and killed my comment when I tried to post it. I just didn't have the time or patience to retype and repost it.

                   The bottom right table occurrence looks like it has way too many match fields. That may or may not be relevant to your question.

                   From what table is the data shown in your lower screen shot stored?

                   Are you trying to design a table for the results such that one record records: "Sodium 140", another records "Potassium 4.2" and so forth? 

                   And does one row in this example show one sample taken and each column a different test result from that common sample?

                   That's how I would structure the table for test results if at all possible and the tabular format can be still be set up to report results.