Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (should really be two article, two separate concepts)
mNo edit summary
 
(46 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[MOST]] score used in Medicine.
{{Reporting Indicators
|description=See page
|Program=Critical Care and Medicine
|indicator_start_date=1988-07-11
|indicator_name={{PAGENAME}}
|program=Critical Care and Medicine
}}
{{Data_element
| field_name = age
| element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Admit DtTm]] otherwise).  
| in_table = Created_Variables_Common_2021 table, Created_Variables_CC_2021 table
| data_type = number
| datafield_length =
| program_collecting = Med and CC
| created_raw = Created
| data_element_sort_index = 3
}}


We define age as  
Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.  
* '''Integer Number of years between DOB and last birthday prior to ''or on'' admission.'''


The multi_search module in [[TMSX and MedTMS]] presents '''average age''' with four decimal places.
==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


=== Implementation ===
===Critical Care QI domain===
Age is actually stored as a value in  [[TMSX and MedTMS]] rather than calculated when needed.  Patient data is sent from the [[Laptop Setup | Laptop]] and is [[PDA Uploader | uploaded]] to the master [[TMSX | Critical Care]] or [[MedTMS | Medicine]] database. Calculation of age is done by the PDA uploader during appending (uploading) of sent data to master database.
[[QualityDomain::Understanding the population]] by showing  aggregate counts of patients per age group (i.e. <40,40-60,61-80,>80)


When this value is generated in [[CCMDB.mdb]] e.g. for use in the [[Overstay]] project age is implemented using a floor function.
===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 ===
*ACCESS
**CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
***where Birth = Date of Birth and R_Adm = Date of Admission
*SAS
**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
*Both formula yields the same AGE values.
*Both formula yields the same AGE values.


[[Category: APACHE II]]
====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
 
 
== Related fields ==
* [[Date of Birth]]
* [[Admit DtTm]]
 
== Related articles ==
{{Related Articles}}
 
 
[[Category:APACHE II]]
[[Category:ALERT Scale Elements]]
[[Category:Data structure]]
[[Category:Data Use]]
[[Category:Created Variables 2021]]

Latest revision as of 15:24, 2023 April 19

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


  • Cargo


  • SMW:
    • "not stated" is not in the list (Created, Raw) of allowed values for the "IndicatorCreatedRaw" property.
  • Categories
  • Default form:
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).

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


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=159037"