S FIO2 table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m New page: The '''S_FIO2''' table contains the possible entries for the FiO2 field. There is an s_FIO2 table on the PDA and in the CCMDB.mdb. == Data Structure == The s_FIO2 table has th...
 
mNo edit summary
 
(15 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.


== 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: