Age: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 1:

{{Data element

|field_name=age

|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

|description=~~See page~~

|description=see [[{{PAGENAME}}]]

|Program=Critical Care and Medicine

|indicator_start_date=1988-07-11

|indicator_name={{PAGENAME}}

|created_raw=Created

|program=Critical Care and Medicine

|DataDependencies=Date of Birth; Admit DtTm

}}

~~{{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~~

}}

Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.

Line 22:

Line 23:

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

Line 36:

Line 42:

=== 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)

*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", [[Date of Birth]], [[Admit DtTm]])) + Int(Format([[Admit DtTm]], "mmdd") < Format([[Date of Birth]], "mmdd")), 1)

**where Birth = [[Date of Birth]] and Adm = [[Admit DtTm]]

====SAS ====

*Age=floor((intck('month',Birth,~~R_Adm~~) - (day(~~R_Adm~~) < day(Birth))) / 12)

*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12)

**where Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)

== Reported as ==

Line 54:

Line 59:

== Related fields ==

* [[Date of Birth]]

* [[~~Accept DtTm]]~~

* [[Admit DtTm]]

* [[Arrive DtTm]]

== Related articles ==

Line 65:

Line 69:

[[Category:Data structure]]

[[Category:Data Use]]

[[Category:Created Variables]]

[[Category:Created Variables 2021]]

@@ Line 1: / Line 1: @@
+{{Data element
+|field_name=age
+|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
-|description=See page
+|description=see [[{{PAGENAME}}]]
 |Program=Critical Care and Medicine
 |indicator_start_date=1988-07-11
 |indicator_name={{PAGENAME}}
+|created_raw=Created
 |program=Critical Care and Medicine
+|DataDependencies=Date of Birth; Admit DtTm
 }}
-{{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
-}}
 Usually used in aggregate form as "per location" and/or "per timeframe", e.g. by day/month/quarter/year x Ward/Unit x Hospital.
@@ Line 22: / Line 23: @@
 ===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==
 % of all patients admitted to Medicine or Critical Care
 ===Inclusion Criteria===
 All
 ===Exclusion Criteria===
 None
@@ Line 36: / Line 42: @@
 === 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)
+*CCMDB_Age = excel.WorksheetFunction.Floor(CInt(DateDiff("yyyy", [[Date of Birth]], [[Admit DtTm]])) + Int(Format([[Admit DtTm]], "mmdd") < Format([[Date of Birth]], "mmdd")), 1)
-**where Birth = [[Date of Birth]] and Adm = [[Admit DtTm]]
 ====SAS ====
-*Age=floor((intck('month',Birth,R_Adm) - (day(R_Adm) < day(Birth))) / 12)
+*Age=floor((intck('month',[[Date of Birth]],[[Admit DtTm]]) - (day([[Admit DtTm]]) < day([[Date of Birth]]))) / 12)
-**where  Birth = Date of Birth and R_Adm = (Accept DtTm if available, Arrive DtTm otherwise)
 == Reported as ==
@@ Line 54: / Line 59: @@
 == Related fields ==
 * [[Date of Birth]]
-* [[Accept DtTm]]
+* [[Admit DtTm]]
-* [[Arrive DtTm]]
 == Related articles ==
@@ Line 65: / Line 69: @@
 [[Category:Data structure]]
 [[Category:Data Use]]
-[[Category:Created Variables]]
+[[Category:Created Variables 2021]]