Age: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 8: | Line 8: | ||
{{Data_element | {{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 ([[ | | element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise). | ||
| in_table = | | in_table = Created_Variables_Common_2021 table, Created_Variables_CC_2021 table | ||
| data_type = number | | data_type = number | ||
| datafield_length = | | datafield_length = | ||
| Line 19: | Line 19: | ||
Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital. | 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=== | ===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== | ==Sampling Plan / Procedure== | ||
100 % of all patients admitted to Medicine or Critical Care | 100 % of all patients admitted to Medicine or Critical Care | ||
===Inclusion Criteria=== | ===Inclusion Criteria=== | ||
All | All | ||
===Exclusion Criteria=== | ===Exclusion Criteria=== | ||
None | None | ||
| Line 34: | Line 41: | ||
=== 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',Birth, | *Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12) | ||
== Reported as == | == Reported as == | ||
* Mean Age, Median Age, Minimum Age, Maximum Age for a given time-frame and/or location | * Mean Age, Median Age, Minimum Age, Maximum Age for a given time-frame and/or location | ||
* Counts | * Counts and % of total patients based on age group for a given time frame and/or location | ||
== Frequency == | == Frequency == | ||
* Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates | * Time frame can be monthly, quarterly, yearly and can be based on admission dates or discharge dates | ||
| Line 50: | Line 58: | ||
== Related fields == | == Related fields == | ||
* [[Date of Birth]] | * [[Date of Birth]] | ||
* [[ | * [[Admit DtTm]] | ||
== Related articles == | == Related articles == | ||
| Line 61: | Line 68: | ||
[[Category:Data structure]] | [[Category:Data structure]] | ||
[[Category:Data Use]] | [[Category:Data Use]] | ||
[[Category:Created Variables]] | [[Category:Created Variables 2021]] | ||
Latest revision as of 14:24, 19 April 2023
See page
| Indicators | |
| Indicator: | Age |
| Created/Raw: | not stated |
| Program: | Critical Care and Medicine |
| Start Date: | 1988-07-11 |
| End Date: | |
| Reports: | Critical Care Program Quality Indicator Report, Directors Quarterly and Annual Report (Medicine), STB ICCS Mortality |
| Data Element (edit) | |
| Field Name: | age |
| CCMDB Label: | not stated |
| CCMDB tab: | not stated |
| Table: | Created_Variables_Common_2021 table, Created_Variables_CC_2021 table |
| Data type: | number |
| Length: | |
| Program: | Med and CC |
| Created/Raw: | Created |
| Start Date: | 1988-07-11 |
| End Date: | 2300-01-01 |
| Sort Index: | 3 |
The number of years between Date of Birth and the last birthday prior to or on (Admit 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.
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