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