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 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
Catchment
Village
Phulwari
Gender
Visit Type
Visit Name
IndividualId

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:

Title of Report in Metabase:

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

Column	Description
Cathment
Village
Phulwari
Full Name
Age
Gender
Father's Name
Recent Encounter date
Recent WFA grade
Recent WFA Zscore
Recent WFA status
Enrolment Date
Time since Enrolment
IndividualId

Filters:

Start Date and End Date :

Catchment name:

Logic for data:

Line list of children - weight not taken

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
Full Name
Mother's Name
Father's Name
DOB
Age
Gender
Last weight taken date
Time since last weight taken
Registration Date
Enrolment Date
IndividualId

Filters:

Catchment name:

Start Date:

Logic for data:

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: