-
Notifications
You must be signed in to change notification settings - Fork 0
Home
1. Work Completion Status - Silt Removal
2. Work Completion Status – Working Hours
4. Machine working hours - Detailed log
5. Work Completion Status – Beneficiaries
8. Form Extract
9. DDM Waterbody parameters report
- Silt Quantity - Cubic Meter
- Land measurement - Acre
- Work Done - Cubic Meter
Criteria / Logic for data:
Data will be calculated for waterbodies in each district and the data will be taken from Registration, Enrolment, Record JCB details, Record Poclain details, baseline survey and end-line survey.
Title of Report in Metabase: Work Completion Status - Silt Removal
Columns (along with logic for columns except the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| NGO | Name of NGOs related to that district |
| Estimated Amount of Silt | Total estimated silt for all the water bodies in all the districts that is there in enrolment of each water body |
| Silt Excavated | Total silt removed from every waterbody in all the districts (from Record JBC details and Record Poclain details from) |
| Percentage of Silt excavated | ((Silt Excavated/ Estimated Amount of Silt) *100) |
| No of structures as per plan | Total No of water bodies in each district |
| No of structures Completed | Number of structures for which end-line survey is sone in each district |
| No of Structure In Progress | Number of structures for which base-line survey is complete but end line survey is not completed in each district |
| Remarks | Empty space (This is for user to put the comment once report is downloaded) |
Filters: Date range filter. (date range will be based on the column for eg. for ‘No of structure completed/In progress/Pending’ it will be calculated on the date of baseline and end line survey. For the column ‘Silt excavated’, it will be calculated on the date of for ‘record desilting data’ form etc.)
Criteria / Logic for data: Data for this report will be taken from the encounters –Record JCB details, record Poclain details and end line survey. From this report user will get the information about how much work has been performed in each district
Title of Report in Metabase: Work Completion Status – Working Hours
Columns (along with logic for columns except the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| NGO | Name of NGOs related to that district |
| Amount of silt excavated | Total how much silt is being excavated from the waterbodies in each district |
| No of structures completed | For how many waterbodies, the work has been completed i.e. the end line survey form has been filled |
| Working hours of Backhoe Loaders | In each district, for how many hours the JCBs have worked |
| Working hours of Excavators | In each district, for how many hours the Poclain have worked |
| Total working hours | Sum of the columns Woking Hours of Backhoe loaders and Working hours of Excavators
|
| Silt excavator per hours (Backhoe) | SUM of quantity of silt removed from Record JCB details encounter)/ (SUM of Working hours from Record JCB details
|
| Silt excavator per hour (Excavator) | SUM of quantity of silt removed from Record Poclain details encounter)/ (SUM of Working hours from Record Pocalin details
|
| Remarks | empty space |
Criteria / Logic for data: This report will have a summary of all the issues reported from the field. Data will be taken from the Record Issues form. How many times the issue has been reported in each district.
Title of Report in Metabase: Summary of Issues
Columns (along with logic for columns except the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| NGO | Name of NGOs related to that district |
| Issus Identified | List of issues
|
| Number of instances | Count of how many times that issue has been reported in that district |
| Details of the Issue | empty space |
| Responsibility | empty space |
| Possible Resolution | empty space |
| Expected timeline | empty space |
| Remarks | Empty space (This is for user to put the comment once report is downloaded) |
Criteria / Logic for data: The data needs to be pulled from JCB details form and Poclain detail form.
Title of Report in Metabase: Machine working hours - Detailed log
Columns (along with logic for columns except the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| NGO | Name of NGOs related to that district |
| No of Backhoe Loaders deployed | Number of backhoe (JCB) working on field. Based on registration number the vehicle is being counted |
| Working hours of backhoe loaders | In each district, for how many hours the JCBs have worked |
| Total silt excavated Backhoe | Total of quantity of silt removed from Record JCB details
|
| Number of excavators deployed | Number of excavator (Poclain) working on field. Based on registration number the vehicle is being counted |
| Working hours of excavators | In each district, for how many hours the Poclain have worked |
| Total silt excavated (Excavators) | SUM of quantity of silt removed from Record Poclain details
|
| Silt excavated per hours (Excavators) | (SUM of quantity of silt removed from Record Poclain details encounter)/ (SUM of Working hours from Record Pocalin details) |
| Remarks | Empty space (This is for the user to put the comment once report is downloaded) |
Criteria / Logic for data:
This report gives the information about the beneficiaries that are getting benefits from the waterbodies in each district. And what benefits they are getting by the program.
Title of Report in Metabase: Work Completion Status – Beneficiaries
Columns (along with logic for columns except for the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| NGO | Name of NGOs related to that district |
| Amount of silt Excavated | SUM of ‘ quantity of silt removed’ from Record JCB details and Record Poclain details |
| Number of Farmers benefited | Count Distinct Number of farmers based on Mobile Number from “Add beneficiary data” |
| Number of small and marginal farmers | Count Distinct Number of farmers with the “land holding” less than or equal to 5 acres from ‘Add beneficiary data’ form. |
| Number of Large Farmers | Count Distinct Number of farmers with the “land holding” greater than 5 acres from ‘Add beneficiary data’. |
| Area Covered with Silt | SUM of answer for question ‘Area covered by silt’ from ‘Add beneficiary data’ from. |
| Average silt per farmer | (Amount of silt excavated) / (No. of Farmers benefited). |
| Average Silt per Acre of Land | (Amount of silt excavated) / (Area covered with silt) |
| Remarks | Empty column |
Criteria / Logic for data:
This report is having the list of District with the count of waterbodies present in that district.
Title of Report in Metabase: District Waterbody Count
Columns (along with logic for columns except for the basic ones):
| Column | Description |
|---|---|
| District | Name of District |
| Total waterbodies | Number of waterbodies in the particular district |
Criteria / Logic for data:
The report has the list of username and the waterbodies assigned to that username.
Title of Report in Metabase: User with water bodies
Column with logic for columns except for the basic ones):
| Column | Description |
|---|---|
| Username | username for the user to login to the application |
| Created date | Date when the user is created in the database |
| District | Name of District |
| Waterbodies | Name of waterbodies attached to that user |
Name of Collection - Form Extracts
This is the collection of all the raw data collected in each form.
- Baseline Survey
- DDM Enrolment
- DDM JCB Details
- DDM Record Issues
- DDM Waterbodies
- Endline Survey
- Record Beneficiary Data
- Record Poclain Details
Criteria / Logic for data:
This report gives the information about the different parameters of each waterbodies.
Title of Report in Metabase: DDM Waterbody parameters report
Columns (along with logic for columns except for the basic ones):
| Column | Description |
|---|---|
| Waterbody | Name of Waterbody |
| Estimated amount of Silt | Total estimated silt for all the water bodies in all the districts that is there in enrolment of each water body |
| Quanity of Silt Excavated | SUM of ‘ quantity of silt removed’ from Record JCB details and Record Poclain details |
| Percentage of Silt excavated | ((Silt Excavated/ Estimated Amount of Silt) *100) |
| Total Working Hours (JCB and Poclain) | Sum of the columns Woking Hours of JCB and Working hours of Poclain
|
| Total Diesel Consumed (JCB and Poclain) | Sum of the columns Diesel input quantity of JCB and Diesel input quantity of Poclain
|
| No. of JCB Deployed | Number of JCB working on field. Based on registration number the vehicle is being counted |
| Working hours of JCB | For how many hours the JCBs have worked |
| Total Silt Excavated (JCB) | Total of quantity of silt removed from Record JCB details
|
| Silt Excavated per Hour (JCB) | (SUM of quantity of silt removed from Record JCB details encounter)/ (SUM of Working hours from Record JCB details) |
| Diesel Consumed (JCB) | Diesel input quantity of JCB |
| No. of Poclain Deployed | Number of Poclain working on field. Based on registration number the vehicle is being counted |
| Working hours of Poclain | For how many hours the Poclain have worked |
| Total Silt Excavated (Poclain) | Total of quantity of silt removed from Record Poclain details
|
| Silt Excavated per Hour (Poclain) | (SUM of quantity of silt removed from Record Poclain details encounter)/ (SUM of Working hours from Record Poclain details) |
| Diesel Consumed (Poclain) | Diesel input quantity of Poclain |
| No. of farmers benefitted | Count Distinct Number of farmers based on Mobile Number from “Add beneficiary data” |
| No. of Small and Marginal Farmers | Count Distinct Number of farmers with the “land holding” less than or equal to 5 acres from ‘Add beneficiary data’ form. |
| No. of Large Farmers | Count Distinct Number of farmers with the “land holding” greater than 5 acres from ‘Add beneficiary data’. |
| Area covered with Silt | SUM of answer for question ‘Area covered by silt’ from ‘Add beneficiary data’ from. |
| Average Silt per Farmer | (Amount of silt excavated) / (No. of Farmers benefited). |
| Average Silt per Acre of Land | (Amount of silt excavated) / (Area covered with silt) |
| No. of Villages Impacted | Count Distinct Number of Villages from “Add beneficiary data” |