Database changes to support custom TPRs

Owned by Cathy Allison
Last updated: Apr 24, 2024 by Jeff Duke
1 min read

Create Master Tables

  • Patient Data Category Master - Groups vitals on treatment sheets, patient Record, or Communication logs. Each category can also be associated to the medical record group, for display in the patient visit history.

    • Display Name

    • Icon

    • Active

    • Record Group Master

  • Patient Data Item Master - Defines the types of data item available and data type.

    • Display Name

    • Description

    • Value Type (Number, Value List, Text) - Also some known specific types like: Temperature (C/F), Weight, Blood Pressure, etc,

    • Number Constraints

    • Category

    • Species Filter Flag

  • Patient Data Species Filter - If data items are filter by species, this records the species to make available. The species record will also contain normal ranges.

    • Species

    • Normal Minimum

    • Normal Maximum

    • Display Value

    • Show Range Flag

    • Show High Low Flag

Separate the current Hospital Episode Vitals so each value is in its own record, mapping the current field to a new Patient Data Item.

  • Create a script to automate creating a Patient Data Item Master for the current value types, Weight, Pulse, Temp. Resp. etc.

  • Create a script to create a new patient data item record that corresponding data item master if value is not null.

  • Remove old vitals table.