Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
m
No edit summary
 
(39 intermediate revisions by 3 users not shown)
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==
100 % 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 ===
=== Function to calculate Age ===
*Both formula yields the same AGE values.
====ACCESS====
====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}}
* 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)


====SAS ====
====SAS ====
{{discussion}}
*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12)  
* 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)
 
**I haven't used the query ages.  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.  I suggest we just keep the SAS formula in case someone will ask how we are computing age in SAS because this formula is just one of the ways to calculate age in SAS.  
== 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
 
== Frequency ==
* Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates


**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)
*Both formula yields the same AGE values.


== Related fields ==
== Related fields ==
* [[Date of Birth]]
* [[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]]

Latest revision as of 10:12, 30 July 2025

Data Element (edit)
Field Name: age
CCMDB Label: not stated
CCMDB tab: not stated
Table: N/A
Data type: number
Length: not stated
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):

The number of years between Date of Birth and the last birthday prior to or on (Admit DtTm otherwise).

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


see Age

Indicators
Indicator: Age
Created/Raw: Created
Program: Critical Care and Medicine
Start Date: 1988-07-11
End Date:
Reports: ALERT Scale, APACHE Score, Critical Care Program Quality Indicator Report, Directors Quarterly and Annual Report (Medicine), STB ICCS Mortality
Data Dependencies(Reports/Indicators/Data Elements): Date of Birth • Admit DtTm


  • Cargo


  • Helper template:
  • Cargo


  • Categories

none

  • SMW:
  • Categories
  • Default form:


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 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

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

  • Both formula yields the same AGE values.

ACCESS

SAS

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

Frequency

  • Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates


Related fields

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Age&oldid=165658"