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)
...
Create a Vitals Master Tables
Vital Category Master - Groups vitals on treatment sheet and/or patient Record.
Display Name
Active
Vital Master - Defines the types of vitals available and data type.
Display Name
Description
Value Type (Number, Value List, Text)
Number Constraints
Vital Category
Species Filter Flag
Vital Species Filter Master - If vitals are filter by species, this records the species to make available.
Species
Separate the current Hospital Episode Vitals so each value is in its own record, mapping the current field to a new Vital Master.
Create a script to automate creating a Vitals Master for the current value types, Weight, Pulse, Temp. Resp. etc.
Create a script to create a new vital record linked to the corresponding vital master if value is not null.
Create a script to remove old vital records.
Remove old result values no longer valid.
| Gliffy | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|