Request: Vaccination will not display unless lot number entered into database.

Discussion in 'Bugs & Issues' started by Jason, Jun 7, 2009.

  1. Jason

    Jason Developer / Handyman Staff Member

    Hepatitis B shots (TwinRix) are one of our most common immunizations.

    The lot numbers always change for every shot. (Whereas the lot numbers for in house immunizations only change every few months.).

    My nurse tried to just manually type in the Lot number ... but when she did, the immunization didn't show up. So she did it again. And again.

    I figured out what was happening. The immunization was being saved (now the patient had 3 shots of Hep B on the same day ..) but it was not displaying.

    To avoid enduser confusion, the Lot number should be either uneditable or accept on the fly changes more gracefully.




    Attached Files:

  2. Graham

    Graham Developer Staff Member

    So, once you added the lot numbers, did the immunizations then appear?

    Sounds like a SQL join problem where the lot number didn't exist ...
  3. Graham

    Graham Developer Staff Member

    Unless you can think of any objections, I will

    1. block the "use" button unless you have selected a lot number

    2. prevent the lot number from being edited

    3. won't allow a vaccination to be added unless the lot number is present.
  4. Jason

    Jason Developer / Handyman Staff Member

    Are there any problems if I have about 250 Hep B Lot numbers per year ?

    Sort of yes.
  5. Graham

    Graham Developer Staff Member

    No, shouldn't be. But then I might change the way lot numbers are shown and only show eg. the latest 10 or so lots.
  6. Graham

    Graham Developer Staff Member

    Each vaccination has a different lot number???

Share This Page