Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (restored to have a redirect from Age to Date of Birth) |
Ttenbergen (talk | contribs) m (should really be two article, two separate concepts) |
||
| 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. | ||
We define age as | |||
* '''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 === | |||
*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. | |||
[[Category: APACHE II]] | [[Category: APACHE II]] | ||
Revision as of 14:05, 2015 April 27
Age is part of the APACHE II score for Critical Care and MOST score used in Medicine.
We define age as
- 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 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.
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
- 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
- CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
- SAS
- Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
- Both formula yields the same AGE values.