← Back to team overview

dhis2-users team mailing list archive

Re: Get Date Values



Periodtype table contains the list of period types (weekly, daily, monthly,
quarterly, etc).

Period table has the actual period definitions: period type, start date,
and end date (e.g. quarterly type, start date january 1, 2018, end date
March 31, 2018).

period id in the data value table refers to the entry in the period table.

periodid is for the period that the data is reported for.

If you need to get when the data value was actually entered/last updated,
in datavalue table you have created (when data point was created) and
lastupdated (when the data point value was last update).


On Thu, Aug 16, 2018 at 2:54 AM Walusiku Muyunda <jomuwalu@xxxxxxxxx> wrote:

> Hello,
> We recently implemented DHIS2 for our data collection needs and are
> currently looking at the first data submitted. Am just getting used to the
> table structure and need help on where the Data Set data entry
> dates/periods are saved. In the datavalue table I have a field periodid but
> cant seem to find what table to link it to to get the actual dates. the
> period and periodtype tables dont seem to have the actual dates when the
> data was being reported. Please help.
> Thank you.
> *Walusiku J. Muyunda*
> *"We have heaven to win and hell to shun, our lives testify better!"
> <http://wildvoices.blogspot.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

Follow ups