Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
 
(45 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 ===
*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)


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


**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
== Frequency ==
*Both formula yields the same AGE values.
* Time frame can be monthly, quarterly, yearly and can be  based on admission dates or discharge dates
 
 
== 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]]

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: