Age
| 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 |
| Data Dependencies(Reports/Indicators/Data Elements): | |
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: | ALERT Scale, APACHE Score, Critical Care Program Quality Indicator Report, Directors Quarterly and Annual Report (Medicine), STB ICCS Mortality |
| Data Dependencies(Reports/Indicators/Data Elements): | Date of Birth • Admit DtTm |
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
|
Do you still use the SAS formula, let's confirm it's all gone and all coming from CreatedVariables |
- 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.