Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (m)
m (transcl and clean up)
Line 1: Line 1:
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[MOST]] score used in Medicine.
<onlyinclude>[[Age]] is the number of years between [[Date of Birth]] and the last birthday prior to '''or on''' admission. </onlyinclude>
 
We define age as
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine.
* '''Integer Number of years between DOB and last birthday prior to ''or on'' admission.'''
 
The multi_search module in [[TMSX and MedTMS]] presents '''average age''' with four decimal places.
 
=== Implementation ===
Age is actually stored as a value in  [[TMSX and MedTMS]] rather than calculated when needed.  Patient data is sent from the [[Laptop Setup | Laptop]] and is [[PDA Uploader | uploaded]] to the master [[TMSX | Critical Care]] or [[MedTMS | Medicine]] database. Calculation of age is done by the PDA uploader during appending (uploading) of sent data to master database.
 
When this value is generated in [[CCMDB.mdb]] e.g. for use in the [[Overstay]] project age is implemented using a floor function.


=== Function to calculate Age ===
=== Function to calculate Age ===
Line 18: Line 10:
**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)  
**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)  
*Both formula yields the same AGE values.
*Both formula yields the same AGE values.
== Legacy ==
Age is actually stored as a value in  [[TMSX and MedTMS]] rather than calculated when needed.  Patient data is sent from the [[Laptop Setup | Laptop]] and is [[PDA Uploader | uploaded]] to the master [[TMSX | Critical Care]] or [[MedTMS | Medicine]] database. Calculation of age is done by the PDA uploader during appending (uploading) of sent data to master database.


[[Category: APACHE II]]
[[Category: APACHE II]]
[[Category: MOST Score Elements]]
[[Category: MOST Score Elements]]
[[Category: Data structure]]
[[Category: Data structure]]

Revision as of 14:20, 2015 April 27

Age is the number of years between Date of Birth and the last birthday prior to or on admission.

Age is part of the APACHE II score for Critical Care and ALERT scale used in Medicine.

Function to calculate Age

  • ACCESS
    • CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
      • where Birth = Date of Birth and R_Adm = Date of Admission
  • SAS
    • Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
  • Both formula yields the same AGE values.

Legacy

Age is actually stored as a value in TMSX and MedTMS rather than calculated when needed. Patient data is sent from the Laptop and is uploaded to the master Critical Care or Medicine database. Calculation of age is done by the PDA uploader during appending (uploading) of sent data to master database.