Age: Difference between revisions

updated in Centralized_data.mdb; question for Julie
No edit summary
 
(46 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<onlyinclude>[[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). </onlyinclude>
{{Data element
|field_name=age
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT scale]] used in Medicine.
|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
}}


Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.
==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==
100 % of all patients admitted to Medicine or Critical Care
===Inclusion Criteria===
All
===Exclusion Criteria===
None
==Definition and Derivation==
=== Function to calculate Age ===
=== Function to calculate Age ===
*ACCESS
*Both formula yields the same AGE values.
**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)
====ACCESS====
*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", [[Date of Birth]], [[Admit DtTm]])) + Int(Format([[Admit DtTm]], "mmdd") < Format([[Date of Birth]], "mmdd")), 1)
 
====SAS ====
*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12)  


== Reported as ==
* Mean Age, Median Age, Minimum Age, Maximum Age 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


{{discussion}}
== Frequency ==
* Julie, do you still do your own calculation for this in SAS or do you now use the output of query ''ages'' that has been around for a long time? It would likely be best to only calculate this in one spot, and right now you'd have to update your SAS to use the new fields, so this might be a good time to start using the query. If you are up to it then please delete the SAS part when done. Ttenbergen 16:07, 2016 July 4 (CDT)
* Time frame can be monthly, quarterly, yearly and can be  based on admission dates or discharge dates
*SAS
 
**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
 
*Both formula yields the same AGE values.
== Related fields ==
* [[Date of Birth]]
* [[Admit 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]]