Age: Difference between revisions
Jump to navigation
Jump to search
| Line 31: | Line 31: | ||
*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) | ||
**where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise) | **where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise) | ||
== Related fields == | == Related fields == | ||
Revision as of 13:40, 11 June 2021
| 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).
See page
| Indicators | |
| Indicator: | Age |
| Created/Raw: | Created |
| Program: | Critical Care and Medicine |
| Start Date: | 1988-07-11 |
| End Date: | |
| Reports: | Critical Care Program Quality Indicator Report, Directors Quarterly and Annual Report (Medicine), STB ICCS Mortality |
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)