S FIO2 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
mNo edit summary
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''S_FIO2''' table contains the possible entries for the [[FiO2]] field.  
{{DISPLAYTITLE:s_FIO2 table}}The '''s_FIO2''' is a table in [[CCMDB.accdb]]. The table contains the possible entries for the [[FiO2]] field.  
 
There is an s_FIO2 table on the PDA and in the [[CCMDB.mdb]].
*go here to see the [[FIO2]] table that is used for [[APACHE II]] scoring.
 
*!! FI02’s listed in this table are ESTIMATES ONLY.  The purpose is to allow for the completion of the APACHE II score.
*!! Actual Fi02 delivered will vary.  This depends on a number of factors such as, breath rate and depth, distance of O2 diffuser from face, resistance to flow etc.
 
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
|- style="font-size:11pt"
|style="background-color:#FFFF99" width="70" height="16" align="center" valign="bottom" | NASAL PRONG
|style="background-color:#FFFF99" width="55"  valign="bottom" | &nbsp;
| width="10"  valign="bottom" | &nbsp;
|style="background-color:#FFFF99" width="70"  valign="bottom" | PARTIAL REBREATH MASK
|style="background-color:#FFFF99" width="55"  valign="bottom" | &nbsp;
 
|-
| height="15" valign="top" | Room Air
| align="center" valign="top" | 21%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  8 LRB
| align="center" valign="top" | 65%
 
|-
| height="14" valign="top" | 1 LNP
| align="center" valign="top" | 24%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 10 LRB
| align="center" valign="top" | 65%
 
|-
| height="14" valign="top" | 2 LNP
| align="center" valign="top" | 28%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 12 LRB
| align="center" valign="top" | 65%
 
|-
| height="14" valign="top" | 3 LNP
| align="center" valign="top" | 32%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 13 LRB
| align="center" valign="top" | 70%
 
|-
| height="15" valign="top" | 4 LNP
| align="center" valign="top" | 36%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 15 LRB
| align="center" valign="top" | 70%
 
|-
| height="14" valign="top" | 5 LNP
| align="center" valign="top" | 40%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 15 LRB +
| rowspan="2" align="center" valign="top" | 70%
 
|-
| height="15" valign="top" | 6 LNP
| align="center" valign="top" | 44%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  5 L NP
 
|-
| height="14" valign="top" | 7 LNP
| align="center" valign="top" | 48%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 10 LRB +
| rowspan="2" align="center" valign="top" | 70%
 
|-
| height="15" valign="top" | 8 LNP
| align="center" valign="top" | 50%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  5 L NP
 
|-
|style="background-color:#FFFF99" height="41" valign="top" | NON REBREATH MASK
|style="background-color:#FFFF99" align="center" valign="top" |
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 10 LRB +
| rowspan="2" align="center" valign="top" | 70%
 
|-
| height="16" valign="top" | 10 LNRB
| align="center" valign="top" | 70%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  3 L NP
 
|-
| height="14" valign="top" | 15 LNRB
| align="center" valign="top" | 70%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 15 LRB +
| rowspan="2" align="center" valign="top" | 70%
 
|-
| height="15" valign="top" | 20 LNRB
| align="center" valign="top" | 80%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  7 L NP
 
|-
| height="28" valign="top" | 25 LNRB
| align="center" valign="top" | 80%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="background-color:#FFFF99" valign="top" | VENTURI MASK
|style="background-color:#FFFF99;font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="15" valign="top" | 30 LNRB
| align="center" valign="top" | 80%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  3 LPM
| align="center" valign="top" | 24%
 
|-
| height="27" valign="top" | 100 LNRB
| align="center" valign="top" | 80%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  4 LPM
| align="center" valign="top" | 26%
 
|-
|style="background-color:#FFFF99" height="28" valign="top" | COLD POT
|style="background-color:#FFFF99;font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  5 LPM
| align="center" valign="top" | 28%
 
|-
| height="15" valign="top" | &nbsp;
| align="center" valign="top" | 35%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  6 LPM
| align="center" valign="top" | 30%
 
|-
| height="14" valign="top" | &nbsp;
| align="center" valign="top" | 40%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  9 LPM
| align="center" valign="top" | 35%
 
|-
| height="15" valign="top" | &nbsp;
| align="center" valign="top" | 50%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 12 LPM
| align="center" valign="top" | 40%
 
|-
| height="15" valign="top" | &nbsp;
| align="center" valign="top" | 70%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 15 LPM
| align="center" valign="top" | 50%
 
|-
| height="41" valign="top" | &nbsp;
| align="center" valign="top" | 100%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="background-color:#FFFF99" valign="top" | Simple Flow Mask
|style="background-color:#FFFF99;font-size:11pt"  valign="bottom" | &nbsp;
 
|-
|style="background-color:#FFFF99;font-size:11pt" height="16"  valign="bottom" | BIPAP
|style="background-color:#FFFF99;font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  6 LPM
| align="center" valign="top" | 35%
 
|-
| height="16" valign="top" |  5 LPM
| align="center" valign="top" | 40%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  7 LPM
| align="center" valign="top" | 40%
 
|-
| height="15" valign="top" | 10 LPM
| align="center" valign="top" | 60%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  8 LPM
| align="center" valign="top" | 45%
 
|-
| height="15" valign="top" | 15 LPM
| align="center" valign="top" | 70%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" |  9 LPM
| align="center" valign="top" | 50%
 
|-
| height="15" valign="top" | FLUSH
| align="center" valign="top" | 70%
|style="font-size:11pt"  valign="bottom" | &nbsp;
| valign="top" | 10 LPM
| align="center" valign="top" | 55%
 
|-
|style="background-color:#FFFF99" height="28" valign="top" | OXYMASK (1-40 Lpm)
|style="background-color:#FFFF99;font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 1 LPM
| align="center" valign="top" | 24%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 2 LPM
| align="center" valign="top" | 28%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 3 LPM
| align="center" valign="top" | 32%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 4 LPM
| align="center" valign="top" | 36%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 5 LPM
| align="center" valign="top" | 40%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 6 LPM
| align="center" valign="top" | 44%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 7 LPM
| align="center" valign="top" | 48%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 8 LPM
| align="center" valign="top" | 50%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 9 LPM
| align="center" valign="top" | 54%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 10 LPM
| align="center" valign="top" | 56%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 11 LPM
| align="center" valign="top" | 58%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 12 LPM
| align="center" valign="top" | 60%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 13 LPM
| align="center" valign="top" | 62%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="14" valign="top" | 14 LPM
| align="center" valign="top" | 64%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|-
| height="15" valign="top" | 15 LPM
| align="center" valign="top" | 65%
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
|style="font-size:11pt"  valign="bottom" | &nbsp;
 
|}
 
[[User:TOstryzniuk|TOstryzniuk]] 15:18, 24 December 2008 (CST)
 


== Data Structure ==  
== Data Structure ==  
The s_FIO2 table has three columns,  
The s_[[FIO2]] table has three columns,  
* Type - BiPAP, Cold Pot, Nasal prongs... the modality by which Oxygen is supplied
* Type - BiPAP, Cold Pot, Nasal prongs... the modality by which Oxygen is supplied
* Code - graduated examples the "type", the best-fit of which will provide an FIO2 % estimate
* Code - graduated examples the "type", the best-fit of which will provide an FIO2 % estimate
* % - FIO2 percentage the "code" description works out to
* % - FIO2 percentage the "code" description works out to
{{Foreign key
| foreign_key_table=L_Log
| foreign_key_field=Previous FiO2
| primary_key_table=s_FIO2
| primary_key_field=type}}
== Related articles ==
{{Related Articles}}


[[Category: Data structure]]
[[Category: Data structure]]

Latest revision as of 15:20, 2023 May 17

The s_FIO2 is a table in CCMDB.accdb. The table contains the possible entries for the FiO2 field.

  • go here to see the FIO2 table that is used for APACHE II scoring.

Data Structure

The s_FIO2 table has three columns,

  • Type - BiPAP, Cold Pot, Nasal prongs... the modality by which Oxygen is supplied
  • Code - graduated examples the "type", the best-fit of which will provide an FIO2 % estimate
  • % - FIO2 percentage the "code" description works out to


  • Cargo


  • Categories
  • Forms

none; if we wanted to include this in a form it would need to be in the data field from

  • SMW

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=S_FIO2_table&oldid=159402"