HOSPITAL_UNIT_VITALS_MASTER
Create a new table called HOSPITAL_UNIT_VITALS_MASTER that contains a blank template for all existing units in the hospital.
This will be used to store the data at the Unit level.
This includes all the columns from HOSPITAL_SETUP, and new columns to support Unit, Pulse and Resp quality, and their value options.
...
Species Link to new HOSPITAL_UNIT_VITALS_MASTER
The same type of linking table used for species on Digital Document Elements (HOSPITAL_RESULT_SPECIES_LINK) should be used to limit species on the new Vitals Masters.
...
If no species are selected, then then TPR becomes available for patients of any species.
Migrate current Hospital TPR values to each of the new Unit Vital Masters.
All units will receive these values, including inactive units.
These values are currently stored in the HOSPITAL_SETUP table. Since they are being moved to the new individual unit tables, we may consider removing the data from SETUP after the migration is complete, and deleting the columns (since SETUP is a huge table.)
New Columns in existing HOSPITAL_EPISODE_VITAL_SIGNS
To align the new custom columns with existing TPRs in the database, we will need to add the following columns to this table:
Unit (to link to the new Vitals Master table)
Pulse Quality Null (off), Text, or Value List
Resp Quality Null, Text, or Value List
Pulse Quality Value List link
Resp Quality Value List link
Pulse Quality Saved Value
Resp Quality Saved Value
Comment Box Size
Intermediary table off the new VITALS_MASTER that contains the optional custom options
Custom TPR Option 1 Y/N
Custom TPR Option 1 Label
Custom TPR Option 1 Min
Custom TPR Option 1 Max
Custom TPR Unit (link to Common Unit table)
Custom TPR Value List (link to custom value list table)
Custom TPR Value List Info Dot
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.
| Gliffy | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
|