SELECT DISTINCT v.Description, v.Item_ID, v.Required, CASE LCase(Trim(v.Description)) WHEN 'temperature' THEN 1 WHEN 'heart rate' THEN 2 WHEN 'respiratory rate' THEN 3 WHEN 'blood pressure systolic' THEN 4 WHEN 'bp systolic' THEN 4 WHEN 'blood pressure diastolic' THEN 5 WHEN 'bp diastolic' THEN 5 WHEN 'height' THEN 6 WHEN 'weight' THEN 7 WHEN 'pain' THEN 8 WHEN 'pain (0-10)' THEN 8 WHEN 'girth' THEN 9 ELSE 100 + IFNULL(v.Item_ID, 0) END AS sort_order FROM #Request.prefix_db_lookup#.pValue_Lookup v WHERE v.Description <> 'wound' ORDER BY sort_order, v.Item_ID SELECT ID, Description, Reading1, Notes, Item_ID FROM #Request.prefix_db_agency#.pWoundsVitals WHERE Assmt_ID = AND VitalOrWound = 'vital' AND Status = 0

Saving vital signs...

SELECT Lookup_1, Lookup_2, Measure, Descriptor, ID FROM #Request.prefix_db_lookup#.pValue_Lookup WHERE Item_ID = ORDER BY ID ASC

#_description# *

Reading *

#measureVal#

Descriptor *

checked="checked" /> #GetVitalLookup.Descriptor#

Notes