Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (clean-up)
m (lnk fix)
Line 5: Line 5:
| element_description = Age is the number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if available, Arrive DtTm otherwise).  
| element_description = Age is the number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if available, Arrive DtTm otherwise).  


| in_table = Created_Variables table
| in_table = Created_Variables_common table


| data_type = integer
| data_type = integer

Revision as of 15:17, 2016 September 19

Data Element (edit)
Field Name: Age
CCMDB Label: not stated
CCMDB tab: not stated
Table: Created_Variables_common table
Data type: integer
Length: not stated
Program: Med and CC
Created/Raw: Created
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 999

Age is the number of years between Date of Birth and the last birthday prior to or on (Accept DtTm if available, Arrive DtTm otherwise).

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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)

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.

Related fields