Age: Difference between revisions

← Older edit

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Age"

@@ Line 1: / Line 1: @@
+{{Data element
+|field_name=age
+|data_type=number
+|program_collecting=Med and CC
+|created_raw=Created
+|data_element_sort_index=3
+|element_description=The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise).
+}}
 {{Reporting Indicators
-|description=See page
+|description=see [[{{PAGENAME}}]]
 |Program=Critical Care and Medicine
 |indicator_start_date=1988-07-11
 |indicator_name={{PAGENAME}}
+|created_raw=Created
 |program=Critical Care and Medicine
+|DataDependencies=Date of Birth; Admit DtTm
 }}
-{{Data_element
-| 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 table, Created_Variables_CC table
-| data_type = number
-| datafield_length =
-| program_collecting = Med and CC
-| created_raw = Created
-| data_element_sort_index = 3
-}}
 Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.
-Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT Scale]] used in Medicine.
+==Uses==
+===Critical Care===
+Part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] where patient's age  falling under an age group(i.e. ≤44,45-54,55-64,65-74,≥75)  has corresponding score
+===Critical Care QI domain===
+[[QualityDomain::Understanding the population]] by showing   aggregate counts of patients per age group (i.e. <40,40-60,61-80,>80)
+===Medicine===
+Part of [[ALERT Scale]]  as Age and  AgexAge
+==Sampling Plan / Procedure==
+% of all patients admitted to Medicine or Critical Care
+===Inclusion Criteria===
+All
+===Exclusion Criteria===
+None
+==Definition and Derivation==
 === 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)
+*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", [[Date of Birth]], [[Admit DtTm]])) + Int(Format([[Admit DtTm]], "mmdd") < Format([[Date of Birth]], "mmdd")), 1)
-**where Birth = [[Date of Birth]] and Adm = ([[Accept DtTm]] if available, [[Arrive DtTm]] otherwise)
 ====SAS ====
+*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of 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)
 == Reported as ==
 * Mean Age, Median Age, Minimum Age, Maximum Age for a given time-frame and/or location
-* Counts or scores based on age ranges  for a given time frame and/or location
+* Counts and % of total patients based on age group  for a given time frame and/or location
 == Frequency ==
 * Time frame can be monthly, quarterly, yearly and can be  based on admission dates or discharge dates
@@ Line 42: / Line 59: @@
 == Related fields ==
 * [[Date of Birth]]
-* [[Accept DtTm]]
+* [[Admit DtTm]]
-* [[Arrive DtTm]]
 == Related articles ==
@@ Line 53: / Line 69: @@
 [[Category:Data structure]]
 [[Category:Data Use]]
-[[Category:Created Variables]]
+[[Category:Created Variables 2021]]