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
(26 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.
{{Data_element
| field_name = age
| element_description = The number of years between [[Date of Birth]] and the last birthday prior to or on ([[Accept DtTm]] if applicable, [[Arrive DtTm]] otherwise).  
| in_table = Created_variables_common table, Created_variables_CC table
| data_type = number
| datafield_length =
| program_collecting = Med and CC
| created_raw = Created
| data_element_sort_index = 3
}}


We define age as
Age is part of the [[APACHE_Scoring_table#Age_Points|APACHE II score]] for Critical Care and [[ALERT Scale]] used in Medicine.
* '''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.
=== Function to calculate Age ===
*Both formula yields the same AGE values.


=== Implementation ===
====ACCESS====
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.
*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)


When this value is generated in [[CCMDB.mdb]] e.g. for use in the [[Overstay]] project age is implemented using a floor function.
====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)


=== Function to calculate Age ===
Decided to keep this for now for cross-checking even though it duplicates the calculation in Access.
*ACCESS
 
**CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", DOB, Adm)) + Int(Format(Adm, "mmdd") < Format(DOB, "mmdd")), 1)
== Related fields ==
***where Birth = Date of Birth and R_Adm = Date of Admission
* [[Date of Birth]]
*SAS
* [[Accept DtTm]]
**Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
* [[Arrive DtTm]]
*Both formula yields the same AGE values.


[[Category: APACHE II]]
[[Category: APACHE II]]
[[Category: ALERT Scale Elements]]
[[Category: Data structure]]
[[Category: Data Use]]
[[Category: Reporting]]
[[Category: Statistical Analysis]]

Revision as of 17:17, 2018 December 22

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


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

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)

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

Related fields

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Age&oldid=130191"