=== modified file 'src/docbkx/en/dhis2_user_man_NBITS.xml'
--- src/docbkx/en/dhis2_user_man_NBITS.xml 2012-07-23 04:14:08 +0000
+++ src/docbkx/en/dhis2_user_man_NBITS.xml 2012-07-23 08:06:24 +0000
@@ -456,17 +456,17 @@
Beneficiary Aggregation Query Builder is a tool for defining formula, expression, rules for aggregation data from name-based to aggregation system.
- Beneficiary Aggregation to used for generating routine data values from patient-data by month (or other interval if desired) and organization unit.
+ Beneficiary Aggregation to used for generating routine data values from name-based-data by month (or other interval if desired) and organization unit.
- Beneficiary Aggregation Query Builder
- To access Beneficiaries Aggregation Query Builder module, from the Maintenance menu, go to the Beneficiaries and Programs option. Select Beneficiary Aggregation Query Builder option on left menu to proceed.
+ Aggregation Query Builder
+ To access Aggregation Query Builder module, from the Maintenance menu, go to the Persons and Programs option. Select Aggregation Query Builder option on left menu to proceed.
Figure 2.5.4.2
-
+
@@ -475,73 +475,97 @@
Figure 2.5.4.3
-
-
-
-
-
- Area labelled 1:
- Provide the basic information for a query: description, aggregation data element from data element group.
- See the example (Fig. 2.5.4.3): description as Number of children - BCG, and the result with be stored with data element as Number of Children - BCG in data element group BCG Program.
-
-
- Area labelled 2:
-
-
- Select the equivalent data element for the beneficiaries to link to the data element selected above. The information include: program, program stage and data element by the selected program stage.
- Double click on the data element the equivalent code of it will be showed in the condition box (labelled 4). An example of Fig. 2.5.4.3, if double click on the data element named BCG dose given date ((default)) the code appear as [DE:8.75.1].
- To make the condition valid, as default click on button “!=NULL”. Then there will be the text “[DE:8.75.1] is not null” in the Condition box.
-
- Area labelled 3:
-
- For adding and advanced condition for the query. So, it is required more knowledge about the health services of the programs specifically.
- All properties and options listed in this area are flexible and depend on the health program. And users can modify them.
-
-
- Area labelled 4:
-
-
- Includes the buttons of operands and a text box showing the conditions for the query.
- After finishing the area above (1, 2, 3 and 4), click on the Add button.
+
+
+
+
+
+ Name:
+ Provide name of query, this name is usually same with the name of aggregate data element. For example Number of mothers got VAT, Number of children got BCG vaccine,...
+
+
+ Dataset:
+
+ Select dataset contains data elements which will be used to link with persons' data.
+
+ Data element:
+ Select data element which will be used to link with persons' data
+ Operator: Select Number of patients if aggregate based on persons, or Number of visits if aggregate data based on persons' times receiving services
+ Program : Select program which person enrolled to aggregate
+ Program Stage : Select program stage from selected program above.
+ Next section included 3 tabs : Data elements, Person attributes, and Program. Depend on the requirement of data aggregation, data element, person attributes, and number of programs are selected.
+
+ Data elements tab
+ list all the person based data elements available from selected program stage. Select data element according to aggregate condition
+
+ Person attribute tab:
+ list all the person attributes such as Total of patient registration, Gender, Date of birth type, Age, .. Select attribute according to aggregate condition. However, the programs with anonymous type don't have person attributes.
+
+ Program tab:
+ list all program properties like Program enrollment, (Date of enrollment - Date of incident) and program stage properties like visit_program_stage, (Report date - Due date), (Report date-Birthdate). Select properties according to aggregate condition.
+
+ Condition :
+ This section contains comparing operations (<, <=, >, >=, =, != ), calculation operation (+), priority operation ( ( ) ), boolean operation (Yes, No), status operations (=NULL, != NULL), relation operations (AND, OR). These operations are used for supporting in setting condition for query.
+
+ Description :
+ This section show the form of query after above elements were selected and combind with operations in above condition.
+ For example: to get number of girls got Vitamin A dose 6 enrolled Child Health program on January 2012. Then query is created as in the figure below. Note that January 2012 is period parameter which user will select when generate report. It is not set in the query.
+
+ Fig. example_query
+
+
+
+
+
+
+
- Beneficiary Aggregation
- To access Beneficiaries Aggregation module, from the Services menu, go to the Name-Based Data Records option. Select Beneficiary Aggregation option on left menu to proceed. Here are the main screen shots:
+ Person Aggregation
+ After created query, user can use Person Aggregation module to aggregate persons data and import into aggregated data element. To open Person Aggregation module, from the Services menu, go to the Name-Based Data Records option. Select Person Aggregation option on left menu. Person Aggregation form is opened as below
Figure 2.5.4.4
-
-
-
-
-
- Figure 2.5.4.5
-
-
-
-
-
-
+
+
+
+
+ In the Person aggregation form above
- Area in the ORANGE frame: the facility hierarchy tree.
-
-
- Area in the BLUE frame: for choosing the data set, the start and end date of the aggregated period.
+ Select dataset from Dataset List to get aggregate values. Note that only datasets which were assigned to atleast 1 organisation unit will be shown in this list.
+
+
+ Depend on frequency of selected dataset, select period to get aggregate data. For example, if frequency of dataset is quarterly, then select begin quarter and end quarter. To select 1 particular quarter, then begin quarter and end quarter is the same particular quarter name.
+
+
+ Select organisation unit level where person data will be select to aggregate. There are 3 options: Children only : person data from the children of the selected organisation unit will be aggregated, Selected: person data from selected organisation unit will be aggregated, and All will get data from both selected and children organisation unit to aggregate.
+
+
+ Click on the
+Aggregate button to execute aggregate function. The Person aggregation resultpage is opened as below figure
- Click on the
-Aggregate button to execute aggregate function.
-
- Figure 2.5.4.6 - Shows the result from the example
+ Figure - Person aggregation result
-
+
+ In Person aggregation result page
+
+ Click Save all values button to save aggregated values, or select only neccessary data elements and their values values and click Save selected values to save them.
+
+
+ Click yellow arrow next to period name for showing list of data elements and their aggregated data values
+
+
+ Click Show details button to view detail person information which aggregated.
+
+
A Sample for Beneficiary Aggregation
=== modified file 'src/docbkx/en/resources/images/patients_programs/Fig. 2.5.4.2.png'
Binary files src/docbkx/en/resources/images/patients_programs/Fig. 2.5.4.2.png 2011-03-01 01:31:02 +0000 and src/docbkx/en/resources/images/patients_programs/Fig. 2.5.4.2.png 2012-07-23 08:06:24 +0000 differ
=== added file 'src/docbkx/en/resources/images/patients_programs/create_new_person_aggregate_query_builder.png'
Binary files src/docbkx/en/resources/images/patients_programs/create_new_person_aggregate_query_builder.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/patients_programs/create_new_person_aggregate_query_builder.png 2012-07-23 08:06:24 +0000 differ
=== added file 'src/docbkx/en/resources/images/patients_programs/example_query.png'
Binary files src/docbkx/en/resources/images/patients_programs/example_query.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/patients_programs/example_query.png 2012-07-23 08:06:24 +0000 differ
=== added file 'src/docbkx/en/resources/images/patients_programs/information.png'
Binary files src/docbkx/en/resources/images/patients_programs/information.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/patients_programs/information.png 2012-07-23 08:06:24 +0000 differ
=== added file 'src/docbkx/en/resources/images/patients_programs/person_aggregation_form.png'
Binary files src/docbkx/en/resources/images/patients_programs/person_aggregation_form.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/patients_programs/person_aggregation_form.png 2012-07-23 08:06:24 +0000 differ
=== added file 'src/docbkx/en/resources/images/patients_programs/person_aggregation_result.png'
Binary files src/docbkx/en/resources/images/patients_programs/person_aggregation_result.png 1970-01-01 00:00:00 +0000 and src/docbkx/en/resources/images/patients_programs/person_aggregation_result.png 2012-07-23 08:06:24 +0000 differ