Age: Difference between revisions

Revision as of 00:48, 8 January 2017

Data Element (edit)
Field Name:	age
CCMDB Label:	not stated
CCMDB tab:	not stated
Table:	Created_variables_common
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):	ALERT Scale APACHE Score Critical Care Program Quality Indicator Report Directors Quarterly and Annual Report (Medicine) STB ICCS Mortality

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.

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)

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.

@@ Line 1: / Line 1: @@
 {{Data_element
+| field_name = age
-| field_name = Age
+| 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
-| 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).
+| data_type = number
+| datafield_length =
-| in_table = Created_variables_common table
-| data_type = integer
 | program_collecting = Med and CC
 | 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.