Age: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 21: Line 21:
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT Scale]] used in Medicine.
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT Scale]] used in Medicine.


===Critical Care QI domain===
*[[QualityDomain::Understanding the population]]
==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", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
**where Birth = [[Date of Birth]] and Adm = ([[Accept DtTm]] if available, [[Arrive DtTm]] otherwise)
**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',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)  
**where  Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)
**where  Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)

Revision as of 17:20, 2021 December 13

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 table, Created_Variables_CC 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 (Accept DtTm if applicable, Arrive 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.

Age is part of the APACHE II score for Critical Care and ALERT Scale used in Medicine.

Critical Care QI domain

  • Understanding the population

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", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)

SAS

  • Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(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 or scores based on age ranges 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: