← Back to team overview

dhis2-users team mailing list archive

Re: one to many relation ability- tracker module

 

Hi Markus and Abyott,

without knowing Hariris use-case I think that he is touching an interesting
point about mapping relational data models into the tracker-module. Am I
actually able to create relations as in a relational DBMS? Extending Hariris
case, could he actually record a patient having multiple visits, each visit
showing multiple issues, each issue getting multiple medications? (Patient <-
Visit <- Issue <- Prescription) 

In my current understanding I can only have Objects and (mulitple) Events, while
the objects can form relational models, but not the events, which would be
necessary if I wanted to record the prescribing doctor in the above example. Is
this because of an eventual integration into the dimensional model with
dimensions and dataelements in analysis and the aggregate level?

Best regards,

Uwe

> Markus Bekken <markus.bekken@xxxxxxxxx> hat am 9. März 2016 um 10:18
> geschrieben:
> 
> 
> Hi Hariri,
> The only way to collect the same data elements multiple times is to make a
> repeatable program stage that only contains the repeating data elements. You
> could then use the table entry mode to enter one row for each medication:
> 
> 
> Markus
> 
> > 8. mar. 2016 kl. 18.28 skrev Hariri, Ousama Al <Hariri@xxxxxxxxxx>:
> > 
> > Hallo Abyott,
> > Many thanks for prompt reply; I did what you said already.. Please, check
> > the attached screenshot.
> > But, I have added secondary section, in order to input in: the second
> > disease, second medication… etc.
> > But, I’m still restricted to those fields. When it is needed to add a third
> > or fourth medication, then I’m obliged to add new data elements.
> > Is there a better solution?
> > Best regards
> >  
> >  
> >  
> > From: Abyot Asalefew Gizaw [mailto:abyot@xxxxxxxxx <mailto:abyot@xxxxxxxxx>]
> > 
> > Sent: Dienstag, 8. März 2016 18:03
> > To: Hariri, Ousama Al <Hariri@xxxxxxxxxx <mailto:Hariri@xxxxxxxxxx>>; DHIS 2
> > Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx
> > <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>>
> > Subject: Re: one to many relation ability- tracker module
> >  
> > Dear Ousama,
> >  
> > You can record as many patient visits as you can - there is no limit.
> >  
> > What you can do is create a program and program stage. The data elements you
> > created needs to be assigned to program stage.
> >  
> > You can have one or more program stages depending on the number and type of
> > disease you wanted to record.
> >  
> > If you make a program stage repeatable, you will be able to record as many
> > visits as you have.
> >  
> > Please refer to our documentation for more details
> > http://dhis2.github.io/dhis2-docs/master/en/user/html/dhis2_user_manual_en_full.html#d5e5778
> > <http://dhis2.github.io/dhis2-docs/master/en/user/html/dhis2_user_manual_en_full.html#d5e5778>
> >  
> > 
> > ---
> > Thank you,
> > Abyot.
> >  
> > On Tue, Mar 8, 2016 at 5:31 PM, Ousama Hariri <hariri@xxxxxxxxxx
> > <mailto:hariri@xxxxxxxxxx>> wrote:
> > Dear admins,
> > I am trying to setup a tracker system that can capture a basic patient
> > visit.
> > Therefore, I have created "data elements" for disease and medicine.
> > But, I can record only 1 disease and 1 medicine... while it is much
> > possible that the patient has a main disease and secondary diseases as
> > well as main medicine and many supplementary medicines.
> > Can you help me in such a case?
> > Thanks in advance
> > hariri
> > --
> > This message was sent from Launchpad by
> > Ousama Hariri (https://launchpad.net/~hariri
> > <https://launchpad.net/~hariri>)
> > using the "Contact this team's admins" link on the DHIS 2 Users team page
> > (https://launchpad.net/~dhis2-users <https://launchpad.net/~dhis2-users>).
> > For more information see
> > https://help.launchpad.net/YourAccount/ContactingPeople
> > <https://help.launchpad.net/YourAccount/ContactingPeople>
> >  
> > <screenshot.jpg>_______________________________________________
> > Mailing list: https://launchpad.net/~dhis2-users
> > <https://launchpad.net/~dhis2-users>
> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> > <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
> > Unsubscribe : https://launchpad.net/~dhis2-users
> > <https://launchpad.net/~dhis2-users>
> > More help   : https://help.launchpad.net/ListHelp
> > <https://help.launchpad.net/ListHelp>
> 
> _______________________________________________
> 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


Follow ups

References