Metabase Report

Following is the list of all the reports provided -

1. All Children

2. Due Visits

3. Faltering Children

4. List of Children - weight not taken

5. New children enrolled in Phulwari in a month

6. Phulwari child weight gain (Enrolled Children)

7. Population Standard

8. Sync Report

9. Weight for Age Grade - Phulwari Children

All Children

Purpose of the report:

The purpose of this report is to have all the information about all the children in the system(Enrolled in Phulwari, Exited from Phulwari, Registered in the system but not enrolled in the Phulwari yet).

Title of Report in Metabase: All Children

Columns (along with logic for columns except for the basic ones):

Column	Description
Name	Name of Child
Age	Age of Child
Registration Date	Date of registration in the system for Child
Enrolment Date	Date of enrolment in Phulwari for child (This will be empty if child never got enrolled in the Phulwari)
Exit Date	Date when the child got exit from Phulwari(This date will be empty if the child is still in the Phulwari or never got enrolled in any Phulwari)
Catchment	Name of Chatchment
Village	Name of Village of Phulwari
Phulwari	Name of Phulwari where the child is enrolled
Gender	Gender of Child
Time since enrolment	How may months/year back child got enrolled in the phulwari
Visit done	How many GMP visits are done for the child till now
Age>=6 months	(Yes or No) If the age of the baby is 6 months or more
First Weight	First weight taken for the child
First WFA grade	First WFA grade for the child
Last weight	Last weight taken for the child
Last WFA grade	Last WFA grade for the child
IndividualId	System ID

Filters:

No Filter

Logic for data:

This report has the list of all the children that are in the Phulwari program at any point of time or even got registered in the system(baseline is done but not enrolled in Phulwari).

Due Visits

Purpose of the report:

The purpose of this report is to provide a list to user with all the children for them any visit is due(GMP or Albendazole).

Title of Report in Metabase: Due Visits

Columns (along with logic for columns except for the basic ones):

Column	Description
Name	Name of Child
Age	Age of Child
Enrolment Date	Date of Enrolment of child in the Phulwari
Catchment	Name of Catchment
Village	Name of Village of Phulwari
Phulwari	Name of Phulwari the child is associated to
Gender	Gender of Child
Visit Type	Type of visit due(Albendazole/Anthropometry Assessment)
Visit Name	Name of the visit due(Albendazole AUG/Albendazole FEB/Anthropometry Assessment)
IndividualId	Syatem ID

Filters:

Visit Type: User can filter based on which visit is scheduled for the children.

Logic for data:

It takes all the cases that are due for any visit(Monthly GMP or Albendazole) as of the date.

Faltering Children

Purpose of the report:

Purpose of the report is to have a list of all the falter children between two given dates.

Title of Report in Metabase: Faltering Children

Columns (along with logic for columns except for the basic ones):

Column	Description
Cathment	Name of Catchment
Village	Name of Village of Phulwari
Phulwari	Name of Phulwari where the child is enrolled
Full Name	Name of the child
Age	Age of the child
Gender	Gender of the child
Father's Name	Name of Father of the Child
Recent Encounter date	Date of recent visit done
Recent WFA grade	WFA grade of the child in recent visit
Recent WFA Zscore	WFA Zscore of the child in recent visit
Recent WFA status	WFA status of the child in recent visit
Enrolment Date	Date of enrolment of the child in the system
Time since Enrolment	For how many months/years child is enrolled in the Phulwari
IndividualId	SystemId

Filters:

Start Date and End Date: Date range in which the user wants to see the faltering children.

Catchment name: User can filter the cases based on which catchment they belong to.

Logic for data:

This report picks all the cases that were marked as Falter during the last Anthropometry Assessment visit in the given date range.

Line list of children - weight not taken

Purpose of the report:

This report is to get all the children list who have not weighed since a given date. For example: List of all the children whose weight has not taken since 01-Jan-19.

Title of Report in Metabase: Line list of Children - weight not taken

Columns (along with logic for columns except for the basic ones):

Column	Description
Catchment	Name of catchment
Village	Name of the village of Phulwari
Phulwari	Name of Phulwari of the child
Full Name	Name of Child
Mother's Name	Name of the mother of child
Father's Name	Name of the father of child
DOB	Date of birth of child
Age	Age of child
Gender	Gender of child
Last weight taken date	Date when the last time weight was taken for the child
Time since last weight taken	Time in months since the weight was taken for the last time for the child
Registration Date	date of registration of child
Enrolment Date	date of enrolment of the child in Phulwari
IndividualId	Syatem Id

Filters:

Catchment name: User can filter by the name of Catchment.

Start Date: This is the date since when user wants to know, the weight has not been taken for the children. This is a mandatory filter. User needs to select the date to see the data.

Logic for data:

This report takes all the cases where the weight has not been taken since the Start date from the filter.

New children enrolled in Phulwari in a month

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column	Description
Catchment
Phulwari
Name of Individual
Mother's Name
Father's Name
DOB
Enrolled On
Age at Enrolment
First Height
First Weight
Exit Date
IndividualId

Filters:

Start Date and End Date:

Logic for data:

Phulwari child weight gain (Enrolled Children)

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column	Description
Catchment
Village
Phulwari
Name
Age
DOB
Gender
Registration Date
First Weight
Recent Weight
Last Weight taken
Weight Gain
First WFA Grade
Recent WFA Grade
First WFA Zscore
Recent WFA Zscore
First WFA Status
Recent WFA status
Enrolment Date
Time since enrolment
IndividualId

Filters:

Start Date and End date:

Catchment:

Logic for data:

Population Standard

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column	Description
Age Group
Total
< -3SD
< -2SD
Mean
SD

Filters:

Catchment:

As of Date:

At least enrolled for (months):

Logic for data:

Sync Report

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column	Description
UserID
Individuals
Enrolments
Encounters

Filters:

Start Date and End date:

Logic for data:

Weight for Age Grade - Phulwari Children

Purpose of the report:

Title of Report in Metabase:

Columns (along with logic for columns except for the basic ones):

Column	Description
Catchment
Village
Phulwari
Grade 1
Grade 2
Grade 3
Weight not Taken
Total

Filters:

Select period:

Catchment:

Logic for data: