← Back to team overview

dhis2-devs team mailing list archive

Re: Fwd: [Dhis2-users] Storing value type 'Age' in numeric form

 

Hi,

I am not using the new age type at all in any application where you want to
do analytics or reporting on the age (in years, months, days etc) AS IT WAS
AT THE TIME OF THE ENROLLMENT AND/OR STAGE VISIT.

The "Age" data type as it is now defined/designed is probably only relevant
for use in applications where you have stored the date of birth and you
simply want to know the patient's age at any point in time - i.e. the
primary usage is patient-centric and not analytics centric.

In the case of Disease Surveillance, for instance, we are capturing CASES
and not PATIENTS per se (the same patient presenting with malaria in
January and Measles in May will be two separate cases). So for any
post-analysis of such data, you want to know e.g. the break-down of cases
per age group AS THOSE AGES WERE ON THE DAY OF DIAGNOSIS/PRESENTATION.

So my recommendation is to instead define three additional attributes/data
elements: Age (years), Age (months), and Age (days) - then you use three
ASSIGN program rules to calculate and assign the relevant values. Those
values are now permanent and locked as long as the DoB or enrollment/report
date don't change.

Best regards
Calle

On 21 May 2017 at 11:23, Dipali Sahu <dipali.sahu@xxxxxxxxx> wrote:

> Hi
>
> I am facing the same issue. I could enter age of a patient in Tracker form
> ( in a attribute type of Age) , but not able to create any indicators based
> on it , for example 'No. of events where Age is less than 1 year'.
>
> Does it work yet?
>
> Thank you in advance
> Deepali
>
>
>
> ---------- Forwarded message ----------
> From: Archana Chillala <archanac@xxxxxxxxxxxxxxxx>
> Date: Thu, Mar 23, 2017 at 2:03 PM
> Subject: Re: [Dhis2-users] Storing value type 'Age' in numeric form
> To: dhis2-devs <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
> Cc: dhis2-users <dhis2-users@xxxxxxxxxxxxxxxxxxx>, Jane GREIG <
> jane.greig@xxxxxxxxxxxxxx>, Theo Krommydakis <theo.krommydakis@xxxxxxxxxx.
> org>, twoca <twoca@xxxxxxxxxxxxxxxx>, carolyn.tauro@xxxxxxxxxxxxxx
>
>
> adding dhis-users list
>
> Archana Chillala
> Application Developer
> Email archanac@xxxxxxxxxxxxxxxx
> Telephone +91 9100960533 <+91+9100960533>
>
> [image: www.thoughtworks.com] <http://www.thoughtworks.com>
>
> On Thu, Mar 23, 2017 at 1:57 PM, Archana Chillala <
> archanac@xxxxxxxxxxxxxxxx> wrote:
>
>> Hi
>>
>> We are using DHIS version 2.26. We are exploring the new value type "
>> *Age*" that has been introduced with this release. On the UI, when we
>> enter a date, it calculates the age in years, months and days perfectly.
>> But we observe that the calculated age in years is not stored in the DB.
>> The value of an Age type data element is stored only as a date (YYYY-MM-DD)
>> in the database. We would like to use the age in years in analytics on the
>> visualisation apps. We have tried using program indicators for the same,
>> but that did not work as expected.
>>
>> Could you please suggest how we could leverage the use of age in years,
>> given the existing functionality.
>>
>>
>>
>> *Cheers*,
>>
>> Archana Chillala
>> Application Developer
>> Email archanac@xxxxxxxxxxxxxxxx
>> Telephone +91 9100960533 <+91+9100960533>
>>
>> [image: www.thoughtworks.com] <http://www.thoughtworks.com>
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 

*******************************************

Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************

PNG image


Follow ups

References