The age group functions are designed to allow easier access to age information in toxiCALL®. When entering age information into toxiCALL® the specialist has a variety of age units and unknown age categories. These functions will simplify the process of placing ages into categories which may be more helpful for reporting needs.
The CASCO_AgeRange_Years function is designed to normalize all known ages to a usable actual age value in years. This will make it significantly easier when performing a search on an age range.
Note: Additional age categories can be added to this list by detailed request of the age groups desired. Please note that age group categories cannot overlap in a single group set.
CASCO_AgeRange_Years
Display the patient age converted to years. Ages marked with any Unknown units will return no value.
Available in TOXICALL® v4.7.30 or later.
Return Value:
Returns a list of age converted to a decimal value in years.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo. CASCO_AgeRange_Years (ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_Years
CASCO_AgeRange_Toxicall
Display the grouping category for the patient for the case. This function returns all the default age groupings as defined in toxiCALL®.
Available in TOXICALL® v4.7.30 or later.
Grouping categories are:
|
<= 5 yrs |
6 to 12 yrs |
|
Teens (13-19) |
20s |
|
30s |
40s |
|
50s |
60s |
|
70s |
80s |
|
>=90 |
Unknown age |
|
Unknown child (<=19 yrs) |
Unknown adult (>=20 yrs) |
|
Unknown adolescent (13-17 yrs) |
Unknown adult (>=18 yrs) |
Return Value:
Returns a value of age converted to age group, if possible. Unknown ages are returned as Unknown.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo.CASCO_AgeRange_Toxicall(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_Toxicall
CASCO_AgeRange_CommonAges
Display the grouping category for the patient for the case.
Available in TOXICALL® v4.7.30 or later.
Grouping categories are:
|
Neonate: 30-days and under |
Infant: 1 to 12 months (under 1-year) |
|
Toddler: 1 to 2 years |
Preschool: 3 to 4 years |
|
Child: 5 to 11 years |
Teen: 12 to 18 years |
|
Adult: 19 to 64 years |
Senior: 65 and older |
|
Unknown |
|
Return Value:
Returns a value of age converted to age group, if possible. Unknown ages are returned as Unknown.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo.CASCO_AgeRange_CommonAges(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_CommonAges
CASCO_AgeRange_USCensusBureau
Display the grouping category for the patient for the case.
Available in TOXICALL® v4.7.30 or later.
Grouping categories are:
|
Under 5 years |
40 to 44 years |
80 to 84 years |
|
5 to 9 years |
45 to 49 years |
85 to 89 years |
|
10 to 14 years |
50 to 54 years |
90 to 94 years |
|
15 to 19 years |
55 to 59 years |
95 to 99 years |
|
20 to 24 years |
60 to 64 years |
100 years and over |
|
25 to 29 years |
65 to 69 years |
Unknown |
|
30 to 34 years |
70 to 74 years |
|
|
35 to 39 years |
75 to 79 years |
|
Return Value:
Returns a value of age converted to age group, if possible. Unknown ages are returned as Unknown.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo.CASCO_AgeRange_USCensusBureau(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_USCensusBureau
CASCO_AgeRange_CommonDemographic
Display the grouping category for the patient for the case.
Available in TOXICALL® v4.7.30 or later.
Grouping categories are:
|
Under 12 years |
35 to 44 years |
75 years and over |
|
12 to 17 years |
45 to 54 years |
Unknown |
|
18 to 24 years |
55 to 64 years |
|
|
25 to 34 years |
65 to 74 years |
|
Return Value:
Returns a value of age converted to age group, if possible. Unknown ages are returned as Unknown.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo.CASCO_AgeRange_CommonDemographic(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_CommonDemographic
CASCO_AgeRange_A
Display the grouping category for the patient for the case.
NOTE: This function is maintained for backwards compatibility. This has been replaced by CASCO_AgeRange_Toxicall
Available in TOXICALL® v4.7.30 or later.
Grouping categories are:
|
<= 5 yrs |
6 to 12 yrs |
|
Teens (13-19) |
20s |
|
30s |
40s |
|
50s |
60s |
|
70s |
80s |
|
>=90 |
Unknown age |
|
Unknown child (<=19 yrs) |
Unknown adult (>=20 yrs) |
|
Unknown adolescent (13-17 yrs) |
Unknown adult (>=18 yrs) |
Return Value:
Returns a list of all miscellaneous scenarios.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo.CASCO_AgeRange_A(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_A
CASCO_AgeRange_Years
Display the patient age converted to years. Ages marked with an Unknown units will return no value.
Available in TOXICALL® v4.7.30 or later.
Return Value:
Returns a list of all miscellaneous scenarios.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Example:
(dbo. CASCO_AgeRange_Years (ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_Years