← Back to team overview

dhis2-devs team mailing list archive

[Branch ~dhis2-documenters/dhis2/dhis2-docbook-docs] Rev 315: Added section to the data admin module on SQL view management.

 

------------------------------------------------------------
revno: 315
committer: Jason P. Pickering <jason.p.pickering@xxxxxxxxx>
branch nick: dhis2-docbook-docs
timestamp: Fri 2011-05-13 10:33:06 +0200
message:
  Added section to the data admin module on SQL view management.
added:
  src/docbkx/en/resources/images/dhis2_images/accept.png
  src/docbkx/en/resources/images/dhis2_images/add.png
  src/docbkx/en/resources/images/dhis2_images/add_small.png
  src/docbkx/en/resources/images/dhis2_images/ajax-loader-bar.gif
  src/docbkx/en/resources/images/dhis2_images/ajax-loader-circle.gif
  src/docbkx/en/resources/images/dhis2_images/and.png
  src/docbkx/en/resources/images/dhis2_images/arrow_double_clockwise_y.png
  src/docbkx/en/resources/images/dhis2_images/assign_a.png
  src/docbkx/en/resources/images/dhis2_images/assign_b.png
  src/docbkx/en/resources/images/dhis2_images/cachestatistics.png
  src/docbkx/en/resources/images/dhis2_images/calendar.png
  src/docbkx/en/resources/images/dhis2_images/cancel.png
  src/docbkx/en/resources/images/dhis2_images/caseaggregation.png
  src/docbkx/en/resources/images/dhis2_images/caseaggregationmapping.png
  src/docbkx/en/resources/images/dhis2_images/chart.png
  src/docbkx/en/resources/images/dhis2_images/checked.png
  src/docbkx/en/resources/images/dhis2_images/clean-up.png
  src/docbkx/en/resources/images/dhis2_images/clear.png
  src/docbkx/en/resources/images/dhis2_images/color_swatch2.png
  src/docbkx/en/resources/images/dhis2_images/configuration.png
  src/docbkx/en/resources/images/dhis2_images/cross.png
  src/docbkx/en/resources/images/dhis2_images/data_mart_export.png
  src/docbkx/en/resources/images/dhis2_images/dataarchive.png
  src/docbkx/en/resources/images/dhis2_images/databrowser.png
  src/docbkx/en/resources/images/dhis2_images/datacompletenessreport.png
  src/docbkx/en/resources/images/dhis2_images/datadictionary.png
  src/docbkx/en/resources/images/dhis2_images/dataelement.png
  src/docbkx/en/resources/images/dhis2_images/dataentry.png
  src/docbkx/en/resources/images/dhis2_images/dataintegrity.png
  src/docbkx/en/resources/images/dhis2_images/datalocking.png
  src/docbkx/en/resources/images/dhis2_images/dataset.png
  src/docbkx/en/resources/images/dhis2_images/datasetreport.png
  src/docbkx/en/resources/images/dhis2_images/datastatistics.png
  src/docbkx/en/resources/images/dhis2_images/delete-denied.png
  src/docbkx/en/resources/images/dhis2_images/dhis14.png
  src/docbkx/en/resources/images/dhis2_images/diff.png
  src/docbkx/en/resources/images/dhis2_images/distribution.png
  src/docbkx/en/resources/images/dhis2_images/duplicatedataelimination.png
  src/docbkx/en/resources/images/dhis2_images/edit-clear.png
  src/docbkx/en/resources/images/dhis2_images/edit_add.png
  src/docbkx/en/resources/images/dhis2_images/edit_compulsory_data_elements.png
  src/docbkx/en/resources/images/dhis2_images/edit_sections.png
  src/docbkx/en/resources/images/dhis2_images/equal.png
  src/docbkx/en/resources/images/dhis2_images/error2.png
  src/docbkx/en/resources/images/dhis2_images/excel.gif
  src/docbkx/en/resources/images/dhis2_images/exit2.png
  src/docbkx/en/resources/images/dhis2_images/export.png
  src/docbkx/en/resources/images/dhis2_images/export2.png
  src/docbkx/en/resources/images/dhis2_images/favorite.png
  src/docbkx/en/resources/images/dhis2_images/forum_denied.png
  src/docbkx/en/resources/images/dhis2_images/gear.png
  src/docbkx/en/resources/images/dhis2_images/greater.png
  src/docbkx/en/resources/images/dhis2_images/greater_or_equal.png
  src/docbkx/en/resources/images/dhis2_images/help2.png
  src/docbkx/en/resources/images/dhis2_images/hide.png
  src/docbkx/en/resources/images/dhis2_images/hide_active.png
  src/docbkx/en/resources/images/dhis2_images/hierarchy.png
  src/docbkx/en/resources/images/dhis2_images/history.png
  src/docbkx/en/resources/images/dhis2_images/history2.png
  src/docbkx/en/resources/images/dhis2_images/history2_small.png
  src/docbkx/en/resources/images/dhis2_images/image.png
  src/docbkx/en/resources/images/dhis2_images/image2.png
  src/docbkx/en/resources/images/dhis2_images/import.png
  src/docbkx/en/resources/images/dhis2_images/in.png
  src/docbkx/en/resources/images/dhis2_images/indicator.png
  src/docbkx/en/resources/images/dhis2_images/is_null.png
  src/docbkx/en/resources/images/dhis2_images/jchart.png
  src/docbkx/en/resources/images/dhis2_images/labels.png
  src/docbkx/en/resources/images/dhis2_images/legendset.png
  src/docbkx/en/resources/images/dhis2_images/less.png
  src/docbkx/en/resources/images/dhis2_images/less_or_equal.png
  src/docbkx/en/resources/images/dhis2_images/magnifier.png
  src/docbkx/en/resources/images/dhis2_images/maintenance.png
  src/docbkx/en/resources/images/dhis2_images/marked.png
  src/docbkx/en/resources/images/dhis2_images/marked_large.png
  src/docbkx/en/resources/images/dhis2_images/minmaxvaluegeneration.png
  src/docbkx/en/resources/images/dhis2_images/not_null.png
  src/docbkx/en/resources/images/dhis2_images/or.png
  src/docbkx/en/resources/images/dhis2_images/organisationunit.png
  src/docbkx/en/resources/images/dhis2_images/organisationunitmerge.png
  src/docbkx/en/resources/images/dhis2_images/organisationunitpruning.png
  src/docbkx/en/resources/images/dhis2_images/overlay.png
  src/docbkx/en/resources/images/dhis2_images/patient.png
  src/docbkx/en/resources/images/dhis2_images/pdf.png
  src/docbkx/en/resources/images/dhis2_images/pivottable.png
  src/docbkx/en/resources/images/dhis2_images/printer.png
  src/docbkx/en/resources/images/dhis2_images/program.png
  src/docbkx/en/resources/images/dhis2_images/question.png
  src/docbkx/en/resources/images/dhis2_images/read.png
  src/docbkx/en/resources/images/dhis2_images/remove.png
  src/docbkx/en/resources/images/dhis2_images/reporttable.png
  src/docbkx/en/resources/images/dhis2_images/resourcetable.png
  src/docbkx/en/resources/images/dhis2_images/scheduling.png
  src/docbkx/en/resources/images/dhis2_images/search.png
  src/docbkx/en/resources/images/dhis2_images/search2.png
  src/docbkx/en/resources/images/dhis2_images/settings.png
  src/docbkx/en/resources/images/dhis2_images/settings_small.png
  src/docbkx/en/resources/images/dhis2_images/sqlview.png
  src/docbkx/en/resources/images/dhis2_images/standardreport.png
  src/docbkx/en/resources/images/dhis2_images/staticreport.png
  src/docbkx/en/resources/images/dhis2_images/summaryreport.png
  src/docbkx/en/resources/images/dhis2_images/systemsettings.png
  src/docbkx/en/resources/images/dhis2_images/tallysheetgenerator.png
  src/docbkx/en/resources/images/dhis2_images/transparency.png
  src/docbkx/en/resources/images/dhis2_images/transparency2.png
  src/docbkx/en/resources/images/dhis2_images/unenroll.png
  src/docbkx/en/resources/images/dhis2_images/unmarked.png
  src/docbkx/en/resources/images/dhis2_images/unmarked_large.png
  src/docbkx/en/resources/images/dhis2_images/user.png
  src/docbkx/en/resources/images/dhis2_images/usersettings.png
  src/docbkx/en/resources/images/dhis2_images/validationanalysis.png
  src/docbkx/en/resources/images/dhis2_images/validationcriteria.png
  src/docbkx/en/resources/images/dhis2_images/validationrule.png
  src/docbkx/en/resources/images/dhis2_images/view_sections.png
  src/docbkx/en/resources/images/dhis2_images/visitplan.png
  src/docbkx/en/resources/images/dhis2_images/wmslegend.png
  src/docbkx/en/resources/images/dhis2_images/wrench.png
  src/docbkx/en/resources/images/dhis2_images/zerovaluestorage.png
  src/docbkx/en/resources/images/dhis2_images/zoom_in2.png
  src/docbkx/en/resources/images/dhis2_images/zoom_out2.png
  src/docbkx/en/resources/images/dhis2_images/zoom_world2.png
modified:
  src/docbkx/en/dhis2_user_man_data_administration.xml
  src/docbkx/en/resources/images/dhis2_images/color_swatch.png
  src/docbkx/en/resources/images/dhis2_images/excel.png
  src/docbkx/en/resources/images/dhis2_images/exit.png
  src/docbkx/en/resources/images/dhis2_images/favorite_star.gif
  src/docbkx/en/resources/images/dhis2_images/help.png
  src/docbkx/en/resources/images/dhis2_images/open.png
  src/docbkx/en/resources/images/dhis2_images/zoom_in.png
  src/docbkx/en/resources/images/dhis2_images/zoom_out.png
  src/docbkx/en/resources/images/dhis2_images/zoom_world.png


--
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs

Your team DHIS 2 developers is subscribed to branch lp:~dhis2-documenters/dhis2/dhis2-docbook-docs.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs/+edit-subscription
=== modified file 'src/docbkx/en/dhis2_user_man_data_administration.xml'
--- src/docbkx/en/dhis2_user_man_data_administration.xml	2011-04-28 19:13:18 +0000
+++ src/docbkx/en/dhis2_user_man_data_administration.xml	2011-05-13 08:33:06 +0000
@@ -1,279 +1,301 @@
-<?xml version='1.0' encoding='UTF-8'?>
-<!-- This document was created with Syntext Serna Free. --><!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.4//EN" "docbookV4.5/docbookx.dtd" []>
-<chapter>
-  <title>Data Administration in DHIS 2</title>
-  <para>The data administration module provides a range of functions to ensure that the data stored in the DHIS2 database is integral and that the database performance is optimised. These functions should be executed on a regular basis by a data administrator to ensure that the quality of the data stored is optimal. </para>
-  <section id="dataBrowser">
-    <title>Data browser</title>
-    <para>The data browser maintenance and analysis module which allows the user to produce a summary of the data contained in the DHIS2 database. The summary view provides a count of data elements which have been entered at the selected organisation unit as well as its descendants. Raw data for all data elements for a range of time periods and a given organisational unit can be browsed and exported to Excel, CSV, or PDF formats. There are four modes of the data browser, which determine how the data is summarized</para>
-    <itemizedlist>
-      <listitem>
-        <para>Data sets</para>
-      </listitem>
-      <listitem>
-        <para>Data element groups</para>
-      </listitem>
-      <listitem>
-        <para>Organisational unit groups</para>
-      </listitem>
-      <listitem>
-        <para>Organisational units</para>
-      </listitem>
-    </itemizedlist>
-    <para>Each of these options can be accessed by selecting the desired option from  <guilabel>&quot;Browse by&quot; </guilabel>drop-down menu. </para>
-    <para>In order to produce a summary of submitted data for a given period and grouped by data sets, the user should follow this procedure. Begin by selecting a given periodicity type (e.g. Weekly, monthly, yearly, etc) and then a &quot;From date&quot; and &quot;To date&quot;. (e.g. January 2009 to March 2009). Select the type of summary to be produced (e.g. Dataset) from the &quot;Browse by&quot; drop-down menu. Click the &quot;Browse&quot; button to view the summary. </para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_browser1.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para>A summary of the number  of data element values that have been submitted over the user selected time period is shown below. </para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_browsing_data_sets.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para> By clicking on the name of the individual dataset, a more detailed summary of each data element can be obtained as shown below.  A cross-tab table summarising each time period will be shown. </para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_dataset_detail.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para>The functionality of the grouping by Datasets, Data element groups, and Organisational groups is essentially the same. </para>
-    <para>The functionality of grouping by organisation units will be discussed below. Begin by selecting &quot;Organisation units&quot; from the &quot;Browse by&quot; drop-down menu. The organisational hierarchy present in the database will now be displayed. Organisational units can be expanded by clicking on the plus symbol in the organisational tree view.</para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_org_unit1.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para> By clicking on an organisational unit, and the clicking the &quot;Browse&quot; button, a summary of submitted data elements present in the database is returned for all immediate children of the selected organisational as shown below:</para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_orgunit2a.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para>By clicking on one of the organisational units, two drill down modes are presented to the user. </para>
-    <itemizedlist>
-      <listitem>
-        <para>Summary drill down- Drill down to the selected organisational units children to see the count of data elements. </para>
-      </listitem>
-      <listitem>
-        <para>View raw data at this level: View the actual raw data at the selected organisational unit. A typical view of the raw data export can be seen below.</para>
-        <screenshot>
-          <mediaobject>
-            <imageobject>
-              <imagedata width="40%" align="center" fileref="resources/images/maintainence/data_browser_org_unit_raw.png"/>
-            </imageobject>
-          </mediaobject>
-        </screenshot>
-        <para>Data can be exported into Excel, CSV and as a PDF report by clicking the appropriate button.</para>
-      </listitem>
-    </itemizedlist>
-  </section>
-  <section id="dataIntegrity">
-    <title>Data integrity</title>
-    <para>DHIS2 can perform a wide range of data integrity checks on the data contained in the database. Identifying and correcting data integrity issues is extremely important for ensuring that the data used for analysis purposes is valid. Each of the data integrity checks that are performed by the system will be described, along with general procedures that can be performed to resolve these issues. </para>
-    <section>
-      <title>Data elements without data set</title>
-      <para>Each data element must be assigned to a data set. Values for data elements will not be able to be entered into the system if a data element is not assigned to a data set. Choose Maintenance-&gt;Datasets-&gt;Edit from the main menu and then add the &quot;orphaned&quot; data element to the appropriate data set. </para>
-    </section>
-    <section>
-      <title>Data elements without groups</title>
-      <para>Some Data Elements have been allocated to several Data Element Groups. This is currently not allowed, because it will result in duplication of linked data records in the PivotSource recordsets that `feed` the pivot tables. Go to Maintenance -&gt; Data Element Groups to review each Data Element identified and remove the incorrect Group allocations.</para>
-    </section>
-    <section>
-      <title>Data elements assigned to data sets with different period types</title>
-      <para>Data Elements should not be assigned to two separate data sets whose period types differ. The recommended approach would be to create two separate data elements (for instance a monthly and yearly data element) and assign these to respective datasets. </para>
-    </section>
-    <section>
-      <title>Data sets not assigned to organisation units</title>
-      <para>All data sets should be assigned to at least one organisation unit. </para>
-    </section>
-    <section>
-      <title>Indicators with identical formulas</title>
-      <para>Although this rule will not affect data quality, it generally does not make sense to have two indicators with the exact same definition. Review the identified indicators and their formulas and delete or modify  any indicator that appears to be the duplicate.</para>
-    </section>
-    <section>
-      <title>Indicators without groups</title>
-      <para>All Data Elements and Indicators must be assigned to at least one group, so these Indicators need to be allocated to their correct Data Element and Indicator Group. Go to Maintenance -&gt; Indicator Groups, and allocate each of the `Orphaned` Indicators to its correct group.</para>
-    </section>
-    <section>
-      <title>Invalid indicator numerators</title>
-      <para>Violations of this rule may be caused by an incorrect reference to a deleted or modified data element. Review the indicator and make corrections to the numerator definition. </para>
-    </section>
-    <section>
-      <title>Invalid indicator denominators</title>
-      <para>Violations of this rule may be caused by an incorrect reference to a deleted or modified data element. Review the indicator and make corrections to the denominator definition. </para>
-    </section>
-    <section>
-      <title> Organisation units with cyclic references</title>
-      <para>Organisation units cannot be both parent and children of each other, directly nor indirectly.</para>
-    </section>
-    <section>
-      <title>Orphaned organisation units</title>
-      <para>All organisation units must exist within the organisation unit hierarchy. Go to Organisation-&gt;Hierarchy Operations and move the offending organisation unit into the proper position in the hierarchy. </para>
-    </section>
-    <section>
-      <title>Organisation units without groups</title>
-      <para>All organisation units <emphasis>must</emphasis> be allocated to at least <emphasis>one</emphasis> group. The problem might either be that you have not defined any `compulsory` OrgUnit Group Set at all, or that there are violations of the `compulsory` rule for some OrgUnits . NOTE: If you have defined no `compulsory` OrgUnit Group Sets, then you must first define them by going to  Maintenance -&gt; Organisation units-&gt;Organisation unit group sets and define at least one `compulsory` Group Set (the group set `OrgUnitType` are nearly universally relevant). If you have the relevant group sets, go to Maintenance -&gt; OrgUnit Groups to review each OrgUnit identified and add the relevant Group allocation.</para>
-    </section>
-    <section>
-      <title>Organisation units violating compulsory group sets</title>
-      <para>These organisation units have not been assigned to the any organisation unit group within one of the  <emphasis>compulsory</emphasis> organisation unit group sets. When a group set is defined as `compulsory`, it means that an organisation unit must be allocated to at least one organisation unit group within that group set. For instance, all organisation units must belong to one of the groups in the `organisation unitType` group set. It might belong to  the `Hospital` or the `Clinic` or any other `type` group - but it must belong to exactly one of them.  Go to Maintenance -&gt; organisation unit-&gt;Organisation unit groups to review each organisation unit identified in the integrity check. Allocate all organisation units to exactly one group. </para>
-    </section>
-    <section>
-      <title>Organisation units violating exclusive group sets</title>
-      <para>Some organisation units have been allocated to several organisation unit groups that are members of the same exclusive organisation unit group set. When a group set is defined as exclusive, it means that an organisation unit can <emphasis>only</emphasis> be allocated to <emphasis>one</emphasis> organisation unit group within that Group Set. For instance, one organisation unit cannot normally belong to the both the &apos;Hospital&apos; and &apos;Clinic&apos; groups , but rather to only to one of them. Go to Maintenance -&gt; organisation unit-&gt;Organisation unit groups to review each organisation unit identified in the integrity check. Remove the organisation unit from all groups except the one that it should be allocated to. </para>
-    </section>
-    <section>
-      <title> Organisation unit groups without group sets</title>
-      <para>The organisation unit groups listed here have not been allocated to a group set. Go to Maintenance-&gt;Organisation unit-&gt;Organisation unit group sets and allocate the Organisation unit group to the appropriate group set. </para>
-    </section>
-    <section>
-      <title>Validation rules without groups</title>
-      <para>All validation rules must be assigned to a group. Go to <command>Services-&gt;Data quality-&gt;Validation rule group</command> and assign the offending validation rule to a group. </para>
-    </section>
-    <section>
-      <title>Invalid validation rule left side expressions</title>
-      <para>An error exists in the left-side validation rule definition. Go to <command>Services-&gt;Data quality-&gt;Validation rule</command> and click the &quot;Edit&quot; icon on the offending rule. Press &quot;Edit left side&quot; and make the corrections that are required. </para>
-    </section>
-    <section>
-      <title>Invalid validation rule right side expressions</title>
-      <para>An error exists in the left-side validation rule definition. Go to <command>Services-&gt;Data quality-&gt;Validation rule</command> and click the &quot;Edit&quot; icon on the offending rule. Press &quot;Edit right side&quot; and make the corrections that are required.</para>
-    </section>
-  </section>
-  <section id="dataArchive">
-    <title>Data Archive</title>
-    <para>The purpose of the data archive function is to move data which is currently not being used for analysis to a secondary storage location in order to improve performance of the application. Data can be both archived and unarchived. When archiving data one moves it from the primary storage to the secondary storage location, while unarchiving moves it from the secondary storage location to the primary. Analysis functionality in DHIS 2 heavily utilizes queries to the data value database table, and by reducing the size of this table these operations will be significantly faster. Typically one would want to archive data that is older than two years.</para>
-    <para>To archive data, first enter a start date and an end date for the time span of the data which should be archived. Then press the archive button. The operation might take a few minutes.</para>
-    <para>To unarchive data, first enter a start date and an end date for the time span of the data which should be unarchived. Then press the unarchive button. The operation might take a few minutes.</para>
-    <para>In some cases you might end up with overlapping data. For instance one might archive data for a given timespan, then later enter data for a period in that timespan. In such cases the system will automatically overwrite the oldest of the overlapping values with the newest during the archive or unarchive operation.</para>
-  </section>
-  <section id="patientDataArchive">
-    <title>Beneficiary Data Archive</title>
-    <para>The purpose of the beneficiary data archive function is to move beneficiary data value which is currently not being used for analysis to a secondary storage location in order to improve performance of the application. Data can be both archived and unarchived. When archiving data one moves it from the primary storage to the secondary storage location, while unarchiving moves it from the secondary storage location to the primary. Analysis functionality in DHIS 2 heavily utilizes queries to the data value database table, and by reducing the size of this table these operations will be significantly faster. Typically one would want to archive beneficiary data that is older than two years.</para>
-    <para>To archive beneficiary data, first enter a start date and an end date for the time span of the data which should be archived. Then press the archive button. The operation might take a few minutes.</para>
-    <para>To unarchive beneficiary data, first enter a start date and an end date for the time span of the data which should be unarchived. Then press the unarchive button. The operation might take a few minutes.</para>
-    <para>In some cases you might end up with overlapping data. For instance one might archive beneficiary data for a given timespan, then later enter data for a period in that timespan. In such cases the system will automatically overwrite the oldest of the overlapping values with the newest during the archive or unarchive operation.</para>
-  </section>
-  <section id="maintenance">
-    <title>Maintenance</title>
-    <para>The data maintenance module has five options, each described below. </para>
-    <itemizedlist>
-      <listitem>
-        <para>Clear data mart (aggregated datavalues)</para>
-        <para>The data mart is where DHIS 2 stores aggregated data produced during the export to data mart process. This function clears the database table which contains aggregated data element values.</para>
-      </listitem>
-      <listitem>
-        <para>Clear data mart (aggregated indicatorvalues)</para>
-        <para>The data mart is where DHIS 2 stores aggregated data produced during the export to data mart process. This function clears the database table which contains aggregated indicator  values.</para>
-      </listitem>
-      <listitem>
-        <para>Clear zero values</para>
-        <para>This function removes zero data values from the database. Values registered for data elements with aggregation operator <emphasis role="italic">average</emphasis> is not removed, as such values will be significant when aggregating the data, contrary to values registered for data elements with aggregation operator <emphasis role="italic">sum</emphasis>. Reducing the number of data values will improve system performance.</para>
-      </listitem>
-      <listitem>
-        <para>Clear dataset completeness</para>
-        <para>This function removes aggregated dataset completeness values. This data is produced and used by report tables.</para>
-      </listitem>
-      <listitem>
-        <para>Prune periods</para>
-        <para>This function removes all periods which have no registered data values. Reducing the number of periods will improve system performance.</para>
-      </listitem>
-    </itemizedlist>
-  </section>
-  <section id="resourceTables">
-    <title>Resource tables</title>
-    <para>Resource tables are supporting tables that are used during analysis of data. One would typically join the contents of these tables with the data value table when doing queries from third-party applications like Microsoft Excel. Simply select the tables that should be regenerated and press &quot;Generate tables&quot;. Regeneration of the resource tables should only be done once all data integrity issues are resolved. </para>
-    <itemizedlist>
-      <listitem>
-        <para>Organisation unit structure (orgunitstructure)</para>
-        <para>This table should be regenerated any time there have been any changes made to the organisational unit hierarchy. This table provides information about the organisation unit hierarchy. It has one row for each organisation unit, one  column for each organisation unit level and the organisation unit identifiers for all parents in the lineage as values.</para>
-      </listitem>
-      <listitem>
-        <para>Exclusive organisation unit groupset structure normalized (orgunitgroupsetstructure)</para>
-        <para>This table provides information about the which organisation units are member of which organisation unit group sets.</para>
-      </listitem>
-      <listitem>
-        <para>Data element group set structure (_dataelementgroupsetstructure)</para>
-        <para>This table provides information about which data elements are members of which data element group sets. The table has one row for each data element,  one column for each data element group set and the names of the data element group as values.</para>
-      </listitem>
-      <listitem>
-        <para>Indicator group set structure (_indicatorgroupsetstructure)</para>
-        <para>This table provides information about which indicators are members of which indicator group sets. The table has one row for each indicator, one column for each indicator group set and the names of the indicator group as values.</para>
-      </listitem>
-      <listitem>
-        <para>Organisation unit group set structure (_organisationunitgroupsetstructure)</para>
-        <para>This table provides information about which organisation units are members of which organisation unit group sets. The table has one row for each organisation unit, one column for each organisation unit group set and the names of the organisation unit groups as values.</para>
-      </listitem>
-      <listitem>
-        <para>Category structure (_categorystructure)</para>
-        <para>This table provides information about which data elements are members of which categories. The table has one row for each data element, one column for each category and the names of the category options as values.</para>
-      </listitem>
-      <listitem>
-        <para>Data element category option combo name (categoryoptioncomboname)</para>
-        <para>This table should be regenerated any time there have been changes made to the category combination names. It contains readable names for the various combinations of categories.</para>
-      </listitem>
-    </itemizedlist>
-  </section>
-  <section id="organisationUnitMerge">
-    <title>Organisation unit merge</title>
-    <para>This function is useful when two organisation units need to be merged, eg. it is decided that one facility will be shut down and its services will be provided by a nearby facility.</para>
-    <para>Start by selecting the organisation unit to eliminate from the tree and click <emphasis role="italic">confirm</emphasis>.  Then select the organisation unit to keep and click <emphasis role="italic">confirm</emphasis> again. Finally, verify the selection and click <emphasis role="italic">merge</emphasis>.  </para>
-    <para>In the sitation where data exist  for the organisation unit to eliminate and not for the one to keep, the data will be moved to the one to keep. When data exists for both organisation units, the data will be summarized and moved to the one to keep. When data exists only for the one to keep, no action is taken. The organisation unit to eliminate will eventually be deleted.</para>
-  </section>
-  <section id="duplicateDataElimination">
-    <title>Duplicate data elimination</title>
-    <para>This function is useful when data has been entered mistakenly for two data elements which represents the same phenomena.</para>
-    <para>Start by selecting the data element to eliminate from the list and click confirm. Then select the data element to keep and click confirm again. Finally, verify the selection and click merge.</para>
-    <para>In the situation where data exists for the data element to eliminate and not for the one to keep, the data will be moved to the one to keep. When data exists for both data elements, the data which was updated last will be used. When data exists only for the one to keep, no action will be taken. The data element to eliminate will eventually be deleted, except when it is a multidimensional data element and has other data registered.</para>
-  </section>
-  <section id="dataStatistics">
-    <title>Data statistics</title>
-    <para>The data statistics module provides an overview of the number of objects stored in the DHIS2 database. </para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_stats.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para>The total number of each type of object is presented in a table, as well as a graph. </para>
-  </section>
-  <section id="dataLocking">
-    <title>Data locking</title>
-    <para>This module gives users the privilege of locking certain datasets for chosen organisation units. This encourages timely data entry and prevents unwanted to changes to the data once it has been entered. When the ‘Data Administration’ option is chosen the data locking interface is displayed. The user has to select the periodicity of the report e.g. monthly, quarterly or
-yearly for which the data is to be locked. The month, quarter or year for which the reports are to be locked is then specified. </para>
-    <screenshot>
-      <mediaobject>
-        <imageobject>
-          <imagedata width="100%" fileref="resources/images/maintainence/data_locking_main.png" format="PNG"/>
-        </imageobject>
-      </mediaobject>
-    </screenshot>
-    <para>The unlocked data sets for the period are displayed and the user will then have to choose the data sets to be locked.
-</para>
-    <para>After choosing the datasets to be locked, double click on each one by one to display the organisation unit tree in the field below. Click on the organisation unit to lock the dataset.
-</para>
-    <para>The <guibutton>Apply Locks on All</guibutton> button locks the dataset for all the organisation units to which that dataset has been assigned. <guibutton>‘Remove locks on All’</guibutton> removes all locks put on the organisation units corresponding to the selected dataset. After the operations are completed the user must click <guibutton>‘Save’</guibutton> to apply the settings. The <guibutton>‘Lock at level’</guibutton> button locks datasets at a particular level that the user chooses. . <guibutton>‘Unlock at Level’</guibutton> removes locks that have been put on the organisation units corresponding to the selected dataset at the selected level. After the operations are completed, the user must click <guibutton>‘Save’</guibutton> to apply the settings. The <guibutton>‘Save’</guibutton> button will also lock those organisation unit datasets that have been specified by the user.
-</para>
-  </section>
-  <section id="zeroValueStorage">
-    <title>Zero value storage</title>
-    <para>The zero value storage function makes it possible to define for which data elements the system should store zero values. In most cases zeros are significant only for a subset of the data elements in the database. Zero values will be ignored during data entry for selected data elements.</para>
-  </section>
-  <section id="cacheStatistics">
-    <title>Cache Statistics </title>
-    <para>This option is for system administrators only to use. The cache statistics shows the status of the application level cache. The application level cache refers to the objects and query results that the application is caching in order to speed up performance. If the database has been modified directly the application cache needs to be cleared for it to take effect.</para>
-  </section>
-</chapter>
+<?xml version='1.0' encoding='UTF-8'?>
+<!-- This document was created with Syntext Serna Free. --><!DOCTYPE chapter PUBLIC "-//OASIS//DTD DocBook XML V4.4//EN" "docbookV4.5/docbookx.dtd" []>
+<chapter>
+  <title>Data Administration in DHIS 2</title>
+  <para>The data administration module provides a range of functions to ensure that the data stored in the DHIS2 database is integral and that the database performance is optimised. These functions should be executed on a regular basis by a data administrator to ensure that the quality of the data stored is optimal. </para>
+  <section id="dataBrowser">
+    <title>Data browser</title>
+    <para>The data browser maintenance and analysis module which allows the user to produce a summary of the data contained in the DHIS2 database. The summary view provides a count of data elements which have been entered at the selected organisation unit as well as its descendants. Raw data for all data elements for a range of time periods and a given organisational unit can be browsed and exported to Excel, CSV, or PDF formats. There are four modes of the data browser, which determine how the data is summarized</para>
+    <itemizedlist>
+      <listitem>
+        <para>Data sets</para>
+      </listitem>
+      <listitem>
+        <para>Data element groups</para>
+      </listitem>
+      <listitem>
+        <para>Organisational unit groups</para>
+      </listitem>
+      <listitem>
+        <para>Organisational units</para>
+      </listitem>
+    </itemizedlist>
+    <para>Each of these options can be accessed by selecting the desired option from  <guilabel>&quot;Browse by&quot; </guilabel>drop-down menu. </para>
+    <para>In order to produce a summary of submitted data for a given period and grouped by data sets, the user should follow this procedure. Begin by selecting a given periodicity type (e.g. Weekly, monthly, yearly, etc) and then a &quot;From date&quot; and &quot;To date&quot;. (e.g. January 2009 to March 2009). Select the type of summary to be produced (e.g. Dataset) from the &quot;Browse by&quot; drop-down menu. Click the &quot;Browse&quot; button to view the summary. </para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_browser1.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para>A summary of the number  of data element values that have been submitted over the user selected time period is shown below. </para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_browsing_data_sets.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para> By clicking on the name of the individual dataset, a more detailed summary of each data element can be obtained as shown below.  A cross-tab table summarising each time period will be shown. </para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_dataset_detail.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para>The functionality of the grouping by Datasets, Data element groups, and Organisational groups is essentially the same. </para>
+    <para>The functionality of grouping by organisation units will be discussed below. Begin by selecting &quot;Organisation units&quot; from the &quot;Browse by&quot; drop-down menu. The organisational hierarchy present in the database will now be displayed. Organisational units can be expanded by clicking on the plus symbol in the organisational tree view.</para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_org_unit1.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para> By clicking on an organisational unit, and the clicking the &quot;Browse&quot; button, a summary of submitted data elements present in the database is returned for all immediate children of the selected organisational as shown below:</para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_browser_orgunit2a.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para>By clicking on one of the organisational units, two drill down modes are presented to the user. </para>
+    <itemizedlist>
+      <listitem>
+        <para>Summary drill down- Drill down to the selected organisational units children to see the count of data elements. </para>
+      </listitem>
+      <listitem>
+        <para>View raw data at this level: View the actual raw data at the selected organisational unit. A typical view of the raw data export can be seen below.</para>
+        <screenshot>
+          <mediaobject>
+            <imageobject>
+              <imagedata width="40%" align="center" fileref="resources/images/maintainence/data_browser_org_unit_raw.png"/>
+            </imageobject>
+          </mediaobject>
+        </screenshot>
+        <para>Data can be exported into Excel, CSV and as a PDF report by clicking the appropriate button.</para>
+      </listitem>
+    </itemizedlist>
+  </section>
+  <section id="dataIntegrity">
+    <title>Data integrity</title>
+    <para>DHIS2 can perform a wide range of data integrity checks on the data contained in the database. Identifying and correcting data integrity issues is extremely important for ensuring that the data used for analysis purposes is valid. Each of the data integrity checks that are performed by the system will be described, along with general procedures that can be performed to resolve these issues. </para>
+    <section>
+      <title>Data elements without data set</title>
+      <para>Each data element must be assigned to a data set. Values for data elements will not be able to be entered into the system if a data element is not assigned to a data set. Choose Maintenance-&gt;Datasets-&gt;Edit from the main menu and then add the &quot;orphaned&quot; data element to the appropriate data set. </para>
+    </section>
+    <section>
+      <title>Data elements without groups</title>
+      <para>Some Data Elements have been allocated to several Data Element Groups. This is currently not allowed, because it will result in duplication of linked data records in the PivotSource recordsets that `feed` the pivot tables. Go to Maintenance -&gt; Data Element Groups to review each Data Element identified and remove the incorrect Group allocations.</para>
+    </section>
+    <section>
+      <title>Data elements assigned to data sets with different period types</title>
+      <para>Data Elements should not be assigned to two separate data sets whose period types differ. The recommended approach would be to create two separate data elements (for instance a monthly and yearly data element) and assign these to respective datasets. </para>
+    </section>
+    <section>
+      <title>Data sets not assigned to organisation units</title>
+      <para>All data sets should be assigned to at least one organisation unit. </para>
+    </section>
+    <section>
+      <title>Indicators with identical formulas</title>
+      <para>Although this rule will not affect data quality, it generally does not make sense to have two indicators with the exact same definition. Review the identified indicators and their formulas and delete or modify  any indicator that appears to be the duplicate.</para>
+    </section>
+    <section>
+      <title>Indicators without groups</title>
+      <para>All Data Elements and Indicators must be assigned to at least one group, so these Indicators need to be allocated to their correct Data Element and Indicator Group. Go to Maintenance -&gt; Indicator Groups, and allocate each of the `Orphaned` Indicators to its correct group.</para>
+    </section>
+    <section>
+      <title>Invalid indicator numerators</title>
+      <para>Violations of this rule may be caused by an incorrect reference to a deleted or modified data element. Review the indicator and make corrections to the numerator definition. </para>
+    </section>
+    <section>
+      <title>Invalid indicator denominators</title>
+      <para>Violations of this rule may be caused by an incorrect reference to a deleted or modified data element. Review the indicator and make corrections to the denominator definition. </para>
+    </section>
+    <section>
+      <title> Organisation units with cyclic references</title>
+      <para>Organisation units cannot be both parent and children of each other, directly nor indirectly.</para>
+    </section>
+    <section>
+      <title>Orphaned organisation units</title>
+      <para>All organisation units must exist within the organisation unit hierarchy. Go to Organisation-&gt;Hierarchy Operations and move the offending organisation unit into the proper position in the hierarchy. </para>
+    </section>
+    <section>
+      <title>Organisation units without groups</title>
+      <para>All organisation units <emphasis>must</emphasis> be allocated to at least <emphasis>one</emphasis> group. The problem might either be that you have not defined any `compulsory` OrgUnit Group Set at all, or that there are violations of the `compulsory` rule for some OrgUnits . NOTE: If you have defined no `compulsory` OrgUnit Group Sets, then you must first define them by going to  Maintenance -&gt; Organisation units-&gt;Organisation unit group sets and define at least one `compulsory` Group Set (the group set `OrgUnitType` are nearly universally relevant). If you have the relevant group sets, go to Maintenance -&gt; OrgUnit Groups to review each OrgUnit identified and add the relevant Group allocation.</para>
+    </section>
+    <section>
+      <title>Organisation units violating compulsory group sets</title>
+      <para>These organisation units have not been assigned to the any organisation unit group within one of the  <emphasis>compulsory</emphasis> organisation unit group sets. When a group set is defined as `compulsory`, it means that an organisation unit must be allocated to at least one organisation unit group within that group set. For instance, all organisation units must belong to one of the groups in the `organisation unitType` group set. It might belong to  the `Hospital` or the `Clinic` or any other `type` group - but it must belong to exactly one of them.  Go to Maintenance -&gt; organisation unit-&gt;Organisation unit groups to review each organisation unit identified in the integrity check. Allocate all organisation units to exactly one group. </para>
+    </section>
+    <section>
+      <title>Organisation units violating exclusive group sets</title>
+      <para>Some organisation units have been allocated to several organisation unit groups that are members of the same exclusive organisation unit group set. When a group set is defined as exclusive, it means that an organisation unit can <emphasis>only</emphasis> be allocated to <emphasis>one</emphasis> organisation unit group within that Group Set. For instance, one organisation unit cannot normally belong to the both the &apos;Hospital&apos; and &apos;Clinic&apos; groups , but rather to only to one of them. Go to Maintenance -&gt; organisation unit-&gt;Organisation unit groups to review each organisation unit identified in the integrity check. Remove the organisation unit from all groups except the one that it should be allocated to. </para>
+    </section>
+    <section>
+      <title> Organisation unit groups without group sets</title>
+      <para>The organisation unit groups listed here have not been allocated to a group set. Go to Maintenance-&gt;Organisation unit-&gt;Organisation unit group sets and allocate the Organisation unit group to the appropriate group set. </para>
+    </section>
+    <section>
+      <title>Validation rules without groups</title>
+      <para>All validation rules must be assigned to a group. Go to <command>Services-&gt;Data quality-&gt;Validation rule group</command> and assign the offending validation rule to a group. </para>
+    </section>
+    <section>
+      <title>Invalid validation rule left side expressions</title>
+      <para>An error exists in the left-side validation rule definition. Go to <command>Services-&gt;Data quality-&gt;Validation rule</command> and click the &quot;Edit&quot; icon on the offending rule. Press &quot;Edit left side&quot; and make the corrections that are required. </para>
+    </section>
+    <section>
+      <title>Invalid validation rule right side expressions</title>
+      <para>An error exists in the left-side validation rule definition. Go to <command>Services-&gt;Data quality-&gt;Validation rule</command> and click the &quot;Edit&quot; icon on the offending rule. Press &quot;Edit right side&quot; and make the corrections that are required.</para>
+    </section>
+  </section>
+  <section id="dataArchive">
+    <title>Data Archive</title>
+    <para>The purpose of the data archive function is to move data which is currently not being used for analysis to a secondary storage location in order to improve performance of the application. Data can be both archived and unarchived. When archiving data one moves it from the primary storage to the secondary storage location, while unarchiving moves it from the secondary storage location to the primary. Analysis functionality in DHIS 2 heavily utilizes queries to the data value database table, and by reducing the size of this table these operations will be significantly faster. Typically one would want to archive data that is older than two years.</para>
+    <para>To archive data, first enter a start date and an end date for the time span of the data which should be archived. Then press the archive button. The operation might take a few minutes.</para>
+    <para>To unarchive data, first enter a start date and an end date for the time span of the data which should be unarchived. Then press the unarchive button. The operation might take a few minutes.</para>
+    <para>In some cases you might end up with overlapping data. For instance one might archive data for a given timespan, then later enter data for a period in that timespan. In such cases the system will automatically overwrite the oldest of the overlapping values with the newest during the archive or unarchive operation.</para>
+  </section>
+  <section id="patientDataArchive">
+    <title>Beneficiary Data Archive</title>
+    <para>The purpose of the beneficiary data archive function is to move beneficiary data value which is currently not being used for analysis to a secondary storage location in order to improve performance of the application. Data can be both archived and unarchived. When archiving data one moves it from the primary storage to the secondary storage location, while unarchiving moves it from the secondary storage location to the primary. Analysis functionality in DHIS 2 heavily utilizes queries to the data value database table, and by reducing the size of this table these operations will be significantly faster. Typically one would want to archive beneficiary data that is older than two years.</para>
+    <para>To archive beneficiary data, first enter a start date and an end date for the time span of the data which should be archived. Then press the archive button. The operation might take a few minutes.</para>
+    <para>To unarchive beneficiary data, first enter a start date and an end date for the time span of the data which should be unarchived. Then press the unarchive button. The operation might take a few minutes.</para>
+    <para>In some cases you might end up with overlapping data. For instance one might archive beneficiary data for a given timespan, then later enter data for a period in that timespan. In such cases the system will automatically overwrite the oldest of the overlapping values with the newest during the archive or unarchive operation.</para>
+  </section>
+  <section id="maintenance">
+    <title>Maintenance</title>
+    <para>The data maintenance module has five options, each described below. </para>
+    <itemizedlist>
+      <listitem>
+        <para>Clear data mart (aggregated datavalues)</para>
+        <para>The data mart is where DHIS 2 stores aggregated data produced during the export to data mart process. This function clears the database table which contains aggregated data element values.</para>
+      </listitem>
+      <listitem>
+        <para>Clear data mart (aggregated indicatorvalues)</para>
+        <para>The data mart is where DHIS 2 stores aggregated data produced during the export to data mart process. This function clears the database table which contains aggregated indicator  values.</para>
+      </listitem>
+      <listitem>
+        <para>Clear zero values</para>
+        <para>This function removes zero data values from the database. Values registered for data elements with aggregation operator <emphasis role="italic">average</emphasis> is not removed, as such values will be significant when aggregating the data, contrary to values registered for data elements with aggregation operator <emphasis role="italic">sum</emphasis>. Reducing the number of data values will improve system performance.</para>
+      </listitem>
+      <listitem>
+        <para>Clear dataset completeness</para>
+        <para>This function removes aggregated dataset completeness values. This data is produced and used by report tables.</para>
+      </listitem>
+      <listitem>
+        <para>Prune periods</para>
+        <para>This function removes all periods which have no registered data values. Reducing the number of periods will improve system performance.</para>
+      </listitem>
+    </itemizedlist>
+  </section>
+  <section id="resourceTables">
+    <title>Resource tables</title>
+    <para>Resource tables are supporting tables that are used during analysis of data. One would typically join the contents of these tables with the data value table when doing queries from third-party applications like Microsoft Excel. Simply select the tables that should be regenerated and press &quot;Generate tables&quot;. Regeneration of the resource tables should only be done once all data integrity issues are resolved. </para>
+    <itemizedlist>
+      <listitem>
+        <para>Organisation unit structure (orgunitstructure)</para>
+        <para>This table should be regenerated any time there have been any changes made to the organisational unit hierarchy. This table provides information about the organisation unit hierarchy. It has one row for each organisation unit, one  column for each organisation unit level and the organisation unit identifiers for all parents in the lineage as values.</para>
+      </listitem>
+      <listitem>
+        <para>Exclusive organisation unit groupset structure normalized (orgunitgroupsetstructure)</para>
+        <para>This table provides information about the which organisation units are member of which organisation unit group sets.</para>
+      </listitem>
+      <listitem>
+        <para>Data element group set structure (_dataelementgroupsetstructure)</para>
+        <para>This table provides information about which data elements are members of which data element group sets. The table has one row for each data element,  one column for each data element group set and the names of the data element group as values.</para>
+      </listitem>
+      <listitem>
+        <para>Indicator group set structure (_indicatorgroupsetstructure)</para>
+        <para>This table provides information about which indicators are members of which indicator group sets. The table has one row for each indicator, one column for each indicator group set and the names of the indicator group as values.</para>
+      </listitem>
+      <listitem>
+        <para>Organisation unit group set structure (_organisationunitgroupsetstructure)</para>
+        <para>This table provides information about which organisation units are members of which organisation unit group sets. The table has one row for each organisation unit, one column for each organisation unit group set and the names of the organisation unit groups as values.</para>
+      </listitem>
+      <listitem>
+        <para>Category structure (_categorystructure)</para>
+        <para>This table provides information about which data elements are members of which categories. The table has one row for each data element, one column for each category and the names of the category options as values.</para>
+      </listitem>
+      <listitem>
+        <para>Data element category option combo name (categoryoptioncomboname)</para>
+        <para>This table should be regenerated any time there have been changes made to the category combination names. It contains readable names for the various combinations of categories.</para>
+      </listitem>
+    </itemizedlist>
+  </section>
+  <section id="sqlView">
+    <title>SQL View</title>
+    <para> Database administrators must be very careful about creating database views directly in the DHIS 2 database. Certain  DHIS 2 operations drop and recreate tables, for instance when the resource tables are regenerated. If any SQL views depend on these tables, an error will occur, since the tables are referenced in an SQL view. </para>
+    <para>The SQL View functionality of DHIS2 will store the SQL view definition internally, and then materialize the view when requested. </para>
+    <para/>
+    <section>
+      <title>Creating a new SQL view</title>
+      <para>To create a new SQL view, choose Maintenance-&gt;SQL view and click the &quot;Add new&quot; button. </para>
+      <screenshot>
+        <mediaobject>
+          <imageobject>
+            <imagedata fileref="resources/images/maintainence/create_sql_view.PNG" align="center" width="60%"/>
+          </imageobject>
+        </mediaobject>
+      </screenshot>
+      <para>The &quot;Name&quot; attribute of the SQL view will be used to determine the name of the table that DHIS2 will create when the view is materialized by the user. The &quot;Description&quot; attribute allows one to provide some descriptive text about what the SQL view actually does. Finally, the &quot;SQL statement&quot; should contain the SQL view definition. Only SQL  &quot;SELECT&quot; statements are allowed and certain sensitive tables (i.e. user information) are not accessible Press &quot;Save&quot; to store the SQL view definition.</para>
+    </section>
+    <section>
+      <title>SQL View management</title>
+      <para>In order to utilize the SQL views, simply press the &quot;Execute query&quot; button <inlinegraphic fileref="resources/images/dhis2_images/start_process.png"/> from the &quot;SQL View management page. Once the process is completed, you will be informed that a table has been created. The name of the table will be provided, and is composed from the &quot;Description&quot; attribute provided in the SQL view definition. Once the view has been materialized, click on the &quot;View&quot; button <inlinegraphic fileref="resources/images/dhis2_images/view_sections.png"/>.</para>
+    </section>
+  </section>
+  <section id="organisationUnitMerge">
+    <title>Organisation unit merge</title>
+    <para>This function is useful when two organisation units need to be merged, eg. it is decided that one facility will be shut down and its services will be provided by a nearby facility.</para>
+    <para>Start by selecting the organisation unit to eliminate from the tree and click <emphasis role="italic">confirm</emphasis>.  Then select the organisation unit to keep and click <emphasis role="italic">confirm</emphasis> again. Finally, verify the selection and click <emphasis role="italic">merge</emphasis>.  </para>
+    <para>In the sitation where data exist  for the organisation unit to eliminate and not for the one to keep, the data will be moved to the one to keep. When data exists for both organisation units, the data will be summarized and moved to the one to keep. When data exists only for the one to keep, no action is taken. The organisation unit to eliminate will eventually be deleted.</para>
+  </section>
+  <section id="duplicateDataElimination">
+    <title>Duplicate data elimination</title>
+    <para>This function is useful when data has been entered mistakenly for two data elements which represents the same phenomena.</para>
+    <para>Start by selecting the data element to eliminate from the list and click confirm. Then select the data element to keep and click confirm again. Finally, verify the selection and click merge.</para>
+    <para>In the situation where data exists for the data element to eliminate and not for the one to keep, the data will be moved to the one to keep. When data exists for both data elements, the data which was updated last will be used. When data exists only for the one to keep, no action will be taken. The data element to eliminate will eventually be deleted, except when it is a multidimensional data element and has other data registered.</para>
+  </section>
+  <section id="dataStatistics">
+    <title>Data statistics</title>
+    <para>The data statistics module provides an overview of the number of objects stored in the DHIS2 database. </para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_stats.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para>The total number of each type of object is presented in a table, as well as a graph. </para>
+  </section>
+  <section id="dataLocking">
+    <title>Data locking</title>
+    <para>This module gives users the privilege of locking certain datasets for chosen organisation units. This encourages timely data entry and prevents unwanted to changes to the data once it has been entered. When the ‘Data Administration’ option is chosen the data locking interface is displayed. The user has to select the periodicity of the report e.g. monthly, quarterly or
+yearly for which the data is to be locked. The month, quarter or year for which the reports are to be locked is then specified. </para>
+    <screenshot>
+      <mediaobject>
+        <imageobject>
+          <imagedata width="100%" fileref="resources/images/maintainence/data_locking_main.png" format="PNG"/>
+        </imageobject>
+      </mediaobject>
+    </screenshot>
+    <para>The unlocked data sets for the period are displayed and the user will then have to choose the data sets to be locked.
+</para>
+    <para>After choosing the datasets to be locked, double click on each one by one to display the organisation unit tree in the field below. Click on the organisation unit to lock the dataset.
+</para>
+    <para>The <guibutton>Apply Locks on All</guibutton> button locks the dataset for all the organisation units to which that dataset has been assigned. <guibutton>‘Remove locks on All’</guibutton> removes all locks put on the organisation units corresponding to the selected dataset. After the operations are completed the user must click <guibutton>‘Save’</guibutton> to apply the settings. The <guibutton>‘Lock at level’</guibutton> button locks datasets at a particular level that the user chooses. . <guibutton>‘Unlock at Level’</guibutton> removes locks that have been put on the organisation units corresponding to the selected dataset at the selected level. After the operations are completed, the user must click <guibutton>‘Save’</guibutton> to apply the settings. The <guibutton>‘Save’</guibutton> button will also lock those organisation unit datasets that have been specified by the user.
+</para>
+  </section>
+  <section id="zeroValueStorage">
+    <title>Zero value storage</title>
+    <para>The zero value storage function makes it possible to define for which data elements the system should store zero values. In most cases zeros are significant only for a subset of the data elements in the database. Zero values will be ignored during data entry for selected data elements.</para>
+  </section>
+  <section id="cacheStatistics">
+    <title>Cache Statistics </title>
+    <para>This option is for system administrators only to use. The cache statistics shows the status of the application level cache. The application level cache refers to the objects and query results that the application is caching in order to speed up performance. If the database has been modified directly the application cache needs to be cleared for it to take effect.</para>
+  </section>
+</chapter>

=== added file 'src/docbkx/en/resources/images/dhis2_images/accept.png'
Binary files src/docbkx/en/resources/images/dhis2_images/accept.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/accept.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/add.png'
Binary files src/docbkx/en/resources/images/dhis2_images/add.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/add.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/add_small.png'
Binary files src/docbkx/en/resources/images/dhis2_images/add_small.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/add_small.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/ajax-loader-bar.gif'
Binary files src/docbkx/en/resources/images/dhis2_images/ajax-loader-bar.gif	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/ajax-loader-bar.gif	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/ajax-loader-circle.gif'
Binary files src/docbkx/en/resources/images/dhis2_images/ajax-loader-circle.gif	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/ajax-loader-circle.gif	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/and.png'
Binary files src/docbkx/en/resources/images/dhis2_images/and.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/and.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/arrow_double_clockwise_y.png'
Binary files src/docbkx/en/resources/images/dhis2_images/arrow_double_clockwise_y.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/arrow_double_clockwise_y.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/assign_a.png'
Binary files src/docbkx/en/resources/images/dhis2_images/assign_a.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/assign_a.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/assign_b.png'
Binary files src/docbkx/en/resources/images/dhis2_images/assign_b.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/assign_b.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/cachestatistics.png'
Binary files src/docbkx/en/resources/images/dhis2_images/cachestatistics.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/cachestatistics.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/calendar.png'
Binary files src/docbkx/en/resources/images/dhis2_images/calendar.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/calendar.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/cancel.png'
Binary files src/docbkx/en/resources/images/dhis2_images/cancel.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/cancel.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/caseaggregation.png'
Binary files src/docbkx/en/resources/images/dhis2_images/caseaggregation.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/caseaggregation.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/caseaggregationmapping.png'
Binary files src/docbkx/en/resources/images/dhis2_images/caseaggregationmapping.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/caseaggregationmapping.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/chart.png'
Binary files src/docbkx/en/resources/images/dhis2_images/chart.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/chart.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/checked.png'
Binary files src/docbkx/en/resources/images/dhis2_images/checked.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/checked.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/clean-up.png'
Binary files src/docbkx/en/resources/images/dhis2_images/clean-up.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/clean-up.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/clear.png'
Binary files src/docbkx/en/resources/images/dhis2_images/clear.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/clear.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/color_swatch.png'
Binary files src/docbkx/en/resources/images/dhis2_images/color_swatch.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/color_swatch.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/color_swatch2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/color_swatch2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/color_swatch2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/configuration.png'
Binary files src/docbkx/en/resources/images/dhis2_images/configuration.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/configuration.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/cross.png'
Binary files src/docbkx/en/resources/images/dhis2_images/cross.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/cross.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/data_mart_export.png'
Binary files src/docbkx/en/resources/images/dhis2_images/data_mart_export.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/data_mart_export.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dataarchive.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dataarchive.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dataarchive.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/databrowser.png'
Binary files src/docbkx/en/resources/images/dhis2_images/databrowser.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/databrowser.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/datacompletenessreport.png'
Binary files src/docbkx/en/resources/images/dhis2_images/datacompletenessreport.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/datacompletenessreport.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/datadictionary.png'
Binary files src/docbkx/en/resources/images/dhis2_images/datadictionary.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/datadictionary.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dataelement.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dataelement.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dataelement.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dataentry.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dataentry.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dataentry.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dataintegrity.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dataintegrity.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dataintegrity.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/datalocking.png'
Binary files src/docbkx/en/resources/images/dhis2_images/datalocking.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/datalocking.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dataset.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dataset.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dataset.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/datasetreport.png'
Binary files src/docbkx/en/resources/images/dhis2_images/datasetreport.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/datasetreport.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/datastatistics.png'
Binary files src/docbkx/en/resources/images/dhis2_images/datastatistics.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/datastatistics.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/delete-denied.png'
Binary files src/docbkx/en/resources/images/dhis2_images/delete-denied.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/delete-denied.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/dhis14.png'
Binary files src/docbkx/en/resources/images/dhis2_images/dhis14.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/dhis14.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/diff.png'
Binary files src/docbkx/en/resources/images/dhis2_images/diff.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/diff.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/distribution.png'
Binary files src/docbkx/en/resources/images/dhis2_images/distribution.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/distribution.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/duplicatedataelimination.png'
Binary files src/docbkx/en/resources/images/dhis2_images/duplicatedataelimination.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/duplicatedataelimination.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/edit-clear.png'
Binary files src/docbkx/en/resources/images/dhis2_images/edit-clear.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/edit-clear.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/edit_add.png'
Binary files src/docbkx/en/resources/images/dhis2_images/edit_add.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/edit_add.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/edit_compulsory_data_elements.png'
Binary files src/docbkx/en/resources/images/dhis2_images/edit_compulsory_data_elements.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/edit_compulsory_data_elements.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/edit_sections.png'
Binary files src/docbkx/en/resources/images/dhis2_images/edit_sections.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/edit_sections.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/equal.png'
Binary files src/docbkx/en/resources/images/dhis2_images/equal.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/equal.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/error2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/error2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/error2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/excel.gif'
Binary files src/docbkx/en/resources/images/dhis2_images/excel.gif	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/excel.gif	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/excel.png'
Binary files src/docbkx/en/resources/images/dhis2_images/excel.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/excel.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/exit.png'
Binary files src/docbkx/en/resources/images/dhis2_images/exit.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/exit.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/exit2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/exit2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/exit2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/export.png'
Binary files src/docbkx/en/resources/images/dhis2_images/export.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/export.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/export2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/export2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/export2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/favorite.png'
Binary files src/docbkx/en/resources/images/dhis2_images/favorite.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/favorite.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/favorite_star.gif'
Binary files src/docbkx/en/resources/images/dhis2_images/favorite_star.gif	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/favorite_star.gif	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/forum_denied.png'
Binary files src/docbkx/en/resources/images/dhis2_images/forum_denied.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/forum_denied.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/gear.png'
Binary files src/docbkx/en/resources/images/dhis2_images/gear.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/gear.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/greater.png'
Binary files src/docbkx/en/resources/images/dhis2_images/greater.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/greater.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/greater_or_equal.png'
Binary files src/docbkx/en/resources/images/dhis2_images/greater_or_equal.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/greater_or_equal.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/help.png'
Binary files src/docbkx/en/resources/images/dhis2_images/help.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/help.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/help2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/help2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/help2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/hide.png'
Binary files src/docbkx/en/resources/images/dhis2_images/hide.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/hide.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/hide_active.png'
Binary files src/docbkx/en/resources/images/dhis2_images/hide_active.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/hide_active.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/hierarchy.png'
Binary files src/docbkx/en/resources/images/dhis2_images/hierarchy.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/hierarchy.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/history.png'
Binary files src/docbkx/en/resources/images/dhis2_images/history.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/history.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/history2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/history2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/history2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/history2_small.png'
Binary files src/docbkx/en/resources/images/dhis2_images/history2_small.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/history2_small.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/image.png'
Binary files src/docbkx/en/resources/images/dhis2_images/image.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/image.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/image2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/image2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/image2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/import.png'
Binary files src/docbkx/en/resources/images/dhis2_images/import.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/import.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/in.png'
Binary files src/docbkx/en/resources/images/dhis2_images/in.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/in.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/indicator.png'
Binary files src/docbkx/en/resources/images/dhis2_images/indicator.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/indicator.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/is_null.png'
Binary files src/docbkx/en/resources/images/dhis2_images/is_null.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/is_null.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/jchart.png'
Binary files src/docbkx/en/resources/images/dhis2_images/jchart.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/jchart.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/labels.png'
Binary files src/docbkx/en/resources/images/dhis2_images/labels.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/labels.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/legendset.png'
Binary files src/docbkx/en/resources/images/dhis2_images/legendset.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/legendset.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/less.png'
Binary files src/docbkx/en/resources/images/dhis2_images/less.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/less.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/less_or_equal.png'
Binary files src/docbkx/en/resources/images/dhis2_images/less_or_equal.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/less_or_equal.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/magnifier.png'
Binary files src/docbkx/en/resources/images/dhis2_images/magnifier.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/magnifier.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/maintenance.png'
Binary files src/docbkx/en/resources/images/dhis2_images/maintenance.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/maintenance.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/marked.png'
Binary files src/docbkx/en/resources/images/dhis2_images/marked.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/marked.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/marked_large.png'
Binary files src/docbkx/en/resources/images/dhis2_images/marked_large.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/marked_large.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/minmaxvaluegeneration.png'
Binary files src/docbkx/en/resources/images/dhis2_images/minmaxvaluegeneration.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/minmaxvaluegeneration.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/not_null.png'
Binary files src/docbkx/en/resources/images/dhis2_images/not_null.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/not_null.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/open.png'
Binary files src/docbkx/en/resources/images/dhis2_images/open.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/open.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/or.png'
Binary files src/docbkx/en/resources/images/dhis2_images/or.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/or.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/organisationunit.png'
Binary files src/docbkx/en/resources/images/dhis2_images/organisationunit.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/organisationunit.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/organisationunitmerge.png'
Binary files src/docbkx/en/resources/images/dhis2_images/organisationunitmerge.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/organisationunitmerge.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/organisationunitpruning.png'
Binary files src/docbkx/en/resources/images/dhis2_images/organisationunitpruning.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/organisationunitpruning.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/overlay.png'
Binary files src/docbkx/en/resources/images/dhis2_images/overlay.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/overlay.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/patient.png'
Binary files src/docbkx/en/resources/images/dhis2_images/patient.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/patient.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/pdf.png'
Binary files src/docbkx/en/resources/images/dhis2_images/pdf.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/pdf.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/pivottable.png'
Binary files src/docbkx/en/resources/images/dhis2_images/pivottable.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/pivottable.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/printer.png'
Binary files src/docbkx/en/resources/images/dhis2_images/printer.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/printer.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/program.png'
Binary files src/docbkx/en/resources/images/dhis2_images/program.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/program.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/question.png'
Binary files src/docbkx/en/resources/images/dhis2_images/question.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/question.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/read.png'
Binary files src/docbkx/en/resources/images/dhis2_images/read.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/read.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/remove.png'
Binary files src/docbkx/en/resources/images/dhis2_images/remove.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/remove.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/reporttable.png'
Binary files src/docbkx/en/resources/images/dhis2_images/reporttable.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/reporttable.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/resourcetable.png'
Binary files src/docbkx/en/resources/images/dhis2_images/resourcetable.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/resourcetable.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/scheduling.png'
Binary files src/docbkx/en/resources/images/dhis2_images/scheduling.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/scheduling.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/search.png'
Binary files src/docbkx/en/resources/images/dhis2_images/search.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/search.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/search2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/search2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/search2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/settings.png'
Binary files src/docbkx/en/resources/images/dhis2_images/settings.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/settings.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/settings_small.png'
Binary files src/docbkx/en/resources/images/dhis2_images/settings_small.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/settings_small.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/sqlview.png'
Binary files src/docbkx/en/resources/images/dhis2_images/sqlview.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/sqlview.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/standardreport.png'
Binary files src/docbkx/en/resources/images/dhis2_images/standardreport.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/standardreport.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/staticreport.png'
Binary files src/docbkx/en/resources/images/dhis2_images/staticreport.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/staticreport.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/summaryreport.png'
Binary files src/docbkx/en/resources/images/dhis2_images/summaryreport.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/summaryreport.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/systemsettings.png'
Binary files src/docbkx/en/resources/images/dhis2_images/systemsettings.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/systemsettings.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/tallysheetgenerator.png'
Binary files src/docbkx/en/resources/images/dhis2_images/tallysheetgenerator.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/tallysheetgenerator.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/transparency.png'
Binary files src/docbkx/en/resources/images/dhis2_images/transparency.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/transparency.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/transparency2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/transparency2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/transparency2.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/unenroll.png'
Binary files src/docbkx/en/resources/images/dhis2_images/unenroll.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/unenroll.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/unmarked.png'
Binary files src/docbkx/en/resources/images/dhis2_images/unmarked.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/unmarked.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/unmarked_large.png'
Binary files src/docbkx/en/resources/images/dhis2_images/unmarked_large.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/unmarked_large.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/user.png'
Binary files src/docbkx/en/resources/images/dhis2_images/user.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/user.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/usersettings.png'
Binary files src/docbkx/en/resources/images/dhis2_images/usersettings.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/usersettings.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/validationanalysis.png'
Binary files src/docbkx/en/resources/images/dhis2_images/validationanalysis.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/validationanalysis.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/validationcriteria.png'
Binary files src/docbkx/en/resources/images/dhis2_images/validationcriteria.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/validationcriteria.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/validationrule.png'
Binary files src/docbkx/en/resources/images/dhis2_images/validationrule.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/validationrule.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/view_sections.png'
Binary files src/docbkx/en/resources/images/dhis2_images/view_sections.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/view_sections.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/visitplan.png'
Binary files src/docbkx/en/resources/images/dhis2_images/visitplan.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/visitplan.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/wmslegend.png'
Binary files src/docbkx/en/resources/images/dhis2_images/wmslegend.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/wmslegend.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/wrench.png'
Binary files src/docbkx/en/resources/images/dhis2_images/wrench.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/wrench.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/zerovaluestorage.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zerovaluestorage.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/zerovaluestorage.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/zoom_in.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_in.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_in.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/zoom_in2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_in2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_in2.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/zoom_out.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_out.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_out.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/zoom_out2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_out2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_out2.png	2011-05-13 08:33:06 +0000 differ
=== modified file 'src/docbkx/en/resources/images/dhis2_images/zoom_world.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_world.png	2010-01-19 19:29:45 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_world.png	2011-05-13 08:33:06 +0000 differ
=== added file 'src/docbkx/en/resources/images/dhis2_images/zoom_world2.png'
Binary files src/docbkx/en/resources/images/dhis2_images/zoom_world2.png	1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/dhis2_images/zoom_world2.png	2011-05-13 08:33:06 +0000 differ