Resistant Organism Screen report

[docsteveharris]

first pass of an infection control report
details in comment below suggest the lab battery codes
need to then figure out how best to display against current inpatients
lab_battery_id 29846 for ROS and 337045 for ROSR

[docsteveharris]

-- SELECT 
-- *
-- FROM star.lab_battery lb
-- WHERE lb.battery_code LIKE '%ROS%'
-- LIMIT 3
-- ;
-- lab_battery_id 29846 for ROS and 337045 for ROSR

-- looks like 29846 is the right code
SELECT 
*
FROM star.lab_order lo
--WHERE lo.lab_battery_id IN (29846, 337045)
WHERE lo.internal_lab_number = '140060553'
LIMIT 3;