dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

Hi,

I need some urgent feedback on one very specific issue:

1.
We have a lot of monthly data that have been captured on a daily basis
(up to now in 1.4). The data is in reality monthly aggregated data
because it is the monthly totals that are used for indicators,
analysis, reports etc - but the data is captured daily into DHIS to
enable consistency/completeness tracking and to cut down on the
erroneous manual data compilation from paper forms at the end of every
month.

2.
Initially, the HISP team converted these daily captured values in 1.4
into datavalues in DHIS2 with dataperiodtype = daily. This approach
has various shortcomings, in particular when the use of daily
capturing is slowly being rolled out - meaning that while let us say
30% of all facilities captured data on a daily basis themselves, the
remaining 70% are still submitting monthly summary forms to the
sub-district office for capturing as monthly total data.

3.
I believe a more logical approach is to store the daily data (Day01,
Day02, ...., Day31) as categories - as mentioned, we are in general
NOT using those daily values for anything beyond the initial data
quality and completeness process.

QUESTION:
1. Are there any major drawbacks to storing these daily values as categories?

2. Are there any major limitations with regard to the design of data
entry forms that will make it difficult to have a "matrix" type data
entry form where
(a) the user select OrgUnit, DataSet, and the DATE (as in 2015-01-30)
(b) the year/month part of that date determines the dataperiodid
(c) the day portion of the date determines which category will be the
right-most column in the data entry matrix
(d) we can display let us say 7 preceding days in the matrix to assist
the data capturer with eyeballing data during capture (dynamic
selection & display of categories).

So the entry form would show up as
DataElement          Day23 Day24 Day25 Day26 Day27 Day28 Day29 Day30
<data element1>         17       14      15       22       18
19       20     <entry>
<data element2>         13       11      19        8        15
12       10     <entry>

Any quick feedback would be appreciated

Regards
Calle

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

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

Email: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

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