Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (clean-up) |
Ttenbergen (talk | contribs) mNo edit summary |
||
(12 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
{{Data_element | {{Data_element | ||
| field_name = age | |||
| field_name = | | 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 = Created_variables_common table, Created_variables_CC table | |||
| element_description = | | data_type = number | ||
| datafield_length = | |||
| in_table = | |||
| data_type = | |||
| program_collecting = Med and CC | | program_collecting = Med and CC | ||
| created_raw = Created | | created_raw = Created | ||
| data_element_sort_index = 3 | |||
}} | |||
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 | |||
=== Function to calculate Age === | === Function to calculate Age === | ||
*Both formula yields the same AGE values. | *Both formula yields the same AGE values. | ||
====ACCESS==== | ====ACCESS==== | ||
*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1) | *CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1) | ||
Line 35: | Line 31: | ||
[[Category: APACHE II]] | [[Category: APACHE II]] | ||
[[Category: | [[Category: ALERT Scale Elements]] | ||
[[Category: Data structure]] | [[Category: Data structure]] | ||
[[Category: Data Use]] | |||
[[Category: Reporting]] | |||
[[Category: Statistical Analysis]] |
Revision as of 17:17, 2018 December 22
Data Element (edit) | |
Field Name: | age |
CCMDB Label: | not stated |
CCMDB tab: | not stated |
Table: | Created_variables_common table, Created_variables_CC table |
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).
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.