Age: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) No edit summary |
|||
| (15 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{ | {{Data element | ||
| field_name = age | |field_name=age | ||
| element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[ | |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 | {{Reporting Indicators | ||
| description = | |description=see [[{{PAGENAME}}]] | ||
| indicator_name = {{PAGENAME}} | |Program=Critical Care and Medicine | ||
| created_raw = Created | |indicator_start_date=1988-07-11 | ||
| program = Critical Care and Medicine | |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. | *Both formula yields the same AGE values. | ||
====ACCESS==== | ====ACCESS==== | ||
*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", | *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 ==== | ====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 | |||
== Frequency == | |||
* Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates | |||
== Related fields == | == Related fields == | ||
* [[Date of Birth]] | * [[Date of Birth]] | ||
* [[ | * [[Admit DtTm]] | ||
== Related articles == | == Related articles == | ||
| Line 45: | Line 69: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:Data Use]] | [[Category:Data Use]] | ||
[[Category:Created Variables]] | [[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).
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 |
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
- 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
Frequency
- Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates