Ambiguous FiO2 values in respiratorycharting table

[paradiseThree]

when I run the code as below

SELECT distinct respchartvalue
from respiratorycharting
where lower(respchartvaluelabel) similar to '%fio2%'
and respchartoffset <= 1440
and respchartvalue not like '0%'
and respchartvalue not like '%\%%'
and respchartvalue not like '-%'

I got FiO2 vlues like this picture:

The normal range of FiO2 values is 0 ~100%, but I found the FiO2 values range from 0 to the value more than 1000.

I wonder whether the value 1 means 100% or 1% , and does the values like 1000 , 1001 greater than 100 mean 1000% 1001% or they have other meaning ?

[alistairewj]

As you rightly point out, many of these values are unphysiological (obviously no one is breathing 1000% oxygen). These are often documentation errors. Common error patterns include:

• typos, e.g. entering 1000 when you meant to enter 100
• wrong unit of measurement, e.g. entering 1 (fraction) when you should have used 100 (percentage)
• wrong data field, e.g. entering oxygen flow in litres instead of FiO2

It can be quite laborious to figure this out. On an individual level, if you look at all related data fields around the same time (oxygen flow, tidal volume, minute volume, etc) you can usually figure it out quite quickly. Scaling this up to all patients in the form of an algorithm is a lot harder - even if it's a simple rule based approach! However, we'd welcome any efforts and contributions you may have on this front.