Age: Difference between revisions

← Older edit

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

@@ Line 1: / Line 1: @@
-{{Data_element
+{{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 [[{{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
+}}
-| field_name = Age
-| 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).
+Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.
-| in_table = Created_Variables
+==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
-| data_type = integer
+===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)
-| program_collecting = Med and CC
+===Medicine===
+Part of [[ALERT Scale]]  as Age and  AgexAge
-| created_raw = Created
+==Sampling Plan / Procedure==
+% of all patients admitted to Medicine or Critical Care
-}}
+===Inclusion Criteria===
+All
-Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine.
+===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)
-{{discussion}}
+====SAS ====
+*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12)
-===== query ages =====
+== Reported as ==
-* this is calculated as part of queries ''ages'' and ''''; can we eliminate query "ages" or is it actually used somewhere? Ttenbergen 16:20, 2016 July 4 (CDT)
+* Mean Age, Median Age, Minimum Age, Maximum Age for a given time-frame and/or location
-** I use the age field from the created variables.  but if I need only the age and I have called the L_LOG_PHI, I used the formula instead of calling another query.
+* Counts and % of total patients based on age group  for a given time frame and/or location
-*** '''I will get rid of that query when I get to it then.''' Ttenbergen 15:04, 2016 September 19 (CDT)
-====SAS ====
+== Frequency ==
-*Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
+* Time frame can be monthly, quarterly, yearly and can be  based on admission dates or discharge dates
-**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 ==
 * [[Date of Birth]]
-* [[Accept DtTm]]
+* [[Admit DtTm]]
-* [[Arrive DtTm]]
+== Related articles ==
+{{Related Articles}}
-[[Category: APACHE II]]
+[[Category:APACHE II]]
-[[Category: MOST Score Elements]]
+[[Category:ALERT Scale Elements]]
-[[Category: Data structure]]
+[[Category:Data structure]]
+[[Category:Data Use]]
+[[Category:Created Variables 2021]]