Database changes to support custom TPRs

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.