Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (m) |
Ttenbergen (talk | contribs) m (m) |
||
Line 9: | Line 9: | ||
| data_element_sort_index = 3 | | data_element_sort_index = 3 | ||
}} | }} | ||
Also: [[InTable::Created_variables_common]] | |||
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine. | Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine. |
Revision as of 01:52, 2017 January 8
Data Element (edit) | |
Field Name: | age |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | Created_variables_common |
Data type: | number |
Length: | |
Program: | Med and CC |
Created/Raw: | Created |
Start Date: | 1988-07-11 |
End Date: | 2300-01-01 |
Sort Index: | 3 |
The number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if applicable, Arrive DtTm otherwise).
Also: Created_variables_common
Age is part of the APACHE II score for Critical Care and ALERT scale used in Medicine.
Function to calculate Age
- Both formula yields the same AGE values.
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 Adm = (Accept DtTm if available, Arrive DtTm otherwise)
SAS
- Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
- where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)
Decided to keep this for now for cross-checking even though it duplicates the calculation in Access.