Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (m) |
Ttenbergen (talk | contribs) m (m) |
||
Line 2: | Line 2: | ||
| field_name = age | | field_name = age | ||
| element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Accept DtTm]] if applicable, [[Arrive DtTm]] otherwise). | | element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Accept DtTm]] if applicable, [[Arrive DtTm]] otherwise). | ||
| in_table = | | in_table = Created variables common | ||
| data_type = number | | data_type = number | ||
| datafield_length = | | datafield_length = | ||
Line 9: | Line 9: | ||
| data_element_sort_index = 3 | | data_element_sort_index = 3 | ||
}} | }} | ||
Also: [[InTable:: | Also: [[InTable::Created variables CC]] | ||
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 02:02, 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 CC
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.