Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m lnk fix
No edit summary
 
(35 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_common table
==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.
*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 ====
*Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)  
*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of 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 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


Decided to keep this for now for cross-checking even though it duplicates the calculation in Access.


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