Age
Age is the number of years between Date of Birth and the last birthday prior to or on admission.
Age is part of the APACHE II score for Critical Care and ALERT scale used in Medicine.
Function to calculate Age
- 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 R_Adm = Date of Admission
- CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
- SAS
- Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
- Both formula yields the same AGE values.
Legacy
Age is actually stored as a value in TMSX and MedTMS rather than calculated when needed. Patient data is sent from the Laptop and is uploaded to the master Critical Care or Medicine database. Calculation of age is done by the PDA uploader during appending (uploading) of sent data to master database.