-
Notifications
You must be signed in to change notification settings - Fork 0
Common Reports
garimadosar5 edited this page Feb 3, 2022
·
20 revisions
2. Analytics (Incidence and Prevalence)
4. Compliance of previous month
6. No of patients enrolled in the program
7. Number of patients followed up at different place
10. Reason for not taking medicines
11. Referral reason
Criteria / Logic for data:
This reports shows how many people are enrolled in the program with any of the addiction.
Title of Report in Jasper: Addiction at enrollment
Columns (along with logic for columns except the basic ones):
| Column | Description |
|---|---|
| Characteristics | Tobacco/Alcohol |
| Hypertension - Number | Number of hypertension cases with Tobacco/Alcohol Consumption |
| Hypertension - Proportion | Proportion of hypertension cases with Tobacco/Alcohol Consumption |
| Diabetes - Number | Number of Diabetes cases with Tobacco/Alcohol Consumption |
| Diabetes - Proportion | Proportion of diabetes cases with Tobacco/Alcohol Consumption |
Filters:
Enrolment start date - On enrolment date
Enrolment end date - On enrolment date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Analytics (Incedence and Prevalence)
Columns (along with logic for columns except the basic ones):
| Characterstics | Incidence | Prevalence | Sex Ratio | Death Rate |
|---|---|---|---|---|
| Hypertension | (1000*New cases diagnosed (include exit also))/population at risk (all 18+ population of programme village) | Total number of hypertension patients till the end of reporting period (Non-exit cases) | (1000*no.of new male HTN patients)/no.of new female HTN patients | No. of deaths of patients with HT/Total population*100000 in a specific period |
| Diabetes | (1000*New cases diagnosed)/population at risk of programme village | Same as above for DM | Same as above for DM | No. of deaths of patients with DM/Total population*100000 in a specific period |
| Sickle Cell | (1000*New cases diagnosed)/Total population of programme village | Same as above for SC | Same as above for SC | No. of deaths of patients with SC/Total population*100000 in a specific period |
| Epilepsy | (1000*New cases diagnosed)/Total population of programme village | same as above for Epilepsy | same as above for Epilepsy | No. of deaths of patients with Epilepsy/Total population*100000 in a specific period |
| Tuberculosis | (1000*New cases diagnosed)/Total population of programme village | same as above for TB | same as above for TB | No. of deaths of patients with TB/Total population*100000 in a specific period |
population in the formula = total registration in the system
Filters:
Enrolment start date - On enrolment
Enrolment end date - On enrolment
Criteria / Logic for data:
Title of Report in Jasper: BMI status enrollment
Columns (along with logic for columns except the basic ones):
| Characteristics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sickle cell-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|
| <18.5 (Underweight) | Where BMI <17.5 in enrolment in HTN | BMI<17.5/total enrolment*100 | Where BMI <17.5 in enrolment in DM | BMI<17.5/total enrolment*100 | Where BMI <17.5 in enrolment in SC | BMI<17.5/total enrolment*100 | Where BMI <17.5 in enrolment in TB | BMI<17.5/total enrolment*100 |
| 18.6 -22.99 (Normal) | Where BMI 17.5-22.99 in enrolment in HTN | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in enrolment in DM | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in enrolment in SC | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in enrolment in TB | BMI 17.5 - 22.99/total enrolment*100 |
| 23.00 - 27.5 (Overweight) | Where BMI 23.00-27.99 in enrolment in HTN | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in enrolment in DM | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in enrolment in SC | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in enrolment in TB | BMI 23.00 - 27.99/total enrolment*100 |
| >27.50 (Obese) | Where BMI >=28.00 in enrolment in HTN | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in enrolment in DM | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in enrolment in SC | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in enrolment in TB | BMI >=28.00/total enrolment*100 |
Filters:
Enrolment start date - On enrolment date
Enrolment end date - On enrolment date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Compliance of previous month
Columns (along with logic for columns except the basic ones):
| Characteristics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sickle cell-Proportion | Sickle cell-Number | Sickle cell-Proportion | Tuberculosis-Number | Tuberculosis- Proportion |
|---|---|---|---|---|---|---|---|---|---|---|
| Good | (From Latest followup - Compliance of previous month)If Compliance of previous month = Poor | (Good compliance/total enrolled)*100 | ||||||||
| Poor | If Compliance of previous month = Poor | (Poor compliance/total enrolled)*100 | ||||||||
| Followup not done | If patient is enrolled but followup not done | (followup not done/totl enorolemnt)*100 |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Current BMI Status
Columns (along with logic for columns except the basic ones):
| Characteristics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sickle cell-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|
| <18.5 (Underweight) | Where BMI <17.5 in latest followup in HTN | BMI<17.5/total enrolment*100 | Where BMI <17.5 in latest followup in DM | BMI<17.5/total enrolment*100 | Where BMI <17.5 in latest followup in SC | BMI<17.5/total enrolment*100 | Where BMI <17.5 in latest followup in TB | BMI<17.5/total enrolment*100 |
| 18.6 -22.99 (Normal) | Where BMI 17.5-22.99 in latest followup in HTN | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in latest followup in DM | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in latest followup in SC | BMI 17.5 - 22.99/total enrolment*100 | Where BMI 17.5-22.99 in latest followup in TB | BMI 17.5 - 22.99/total enrolment*100 |
| 23.00 - 27.5 (Overweight) | Where BMI 23.00-27.99 in latest followup in HTN | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in latest followup in DM | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in latest followup in SC | BMI 23.00 - 27.99/total enrolment*100 | Where BMI 23.00-27.99 in latest followup in TB | BMI 23.00 - 27.99/total enrolment*100 |
| >27.50 (Obese) | Where BMI >=28.00 in latest followup in HTN | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in latest followup in DM | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in latest followup in SC | BMI >=28.00/total enrolment*100 | Where BMI >=28.00 in latest followup in TB | BMI >=28.00/total enrolment*100 |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Enrolment start date - On enrolment date
Enrolment end date - On enrolment date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
- Show the number of patients enrolled in the program.
- By default show non-exit, non-voided.
- if exit filter selected then show exited cases also.
Title of Report in Jasper: No of patients enrolled in program
Columns (along with logic for columns except the basic ones):
| Characterstics | Number |
|---|---|
| Diabetes | Show the number of patients enrolled in the Diabetes program. |
| Hypertension | Show the number of patients enrolled in the Hypertension program. |
| Sickle cell | Show the number of patients enrolled in the Sickle-cell program. |
| Epilepsy | Show the number of patients enrolled in the Epilepsy program. |
| Tuberculosis | Show the number of patients enrolled in the Tuberculosis program. |
Filters:
Enrolment start date - On enrolment date
Enrolment end date - On enrolment date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Number of patients followed up at different place
Columns (along with logic for columns except the basic ones):
| Characteristics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sicklecell-Proportion | Epilepsy-Number | Epilepsy-Proportion |
|---|---|---|---|---|---|---|---|---|
| Subcenter OPD | Latest followup in HTN program. if Place of followup = Subcenter OPD | where followup done in SC OPD/total enrolment*100 | Latest followup in DM program. if Place of followup = Subcenter OPD | where followup done in SC OPD/total enrolment*100 | Latest followup in HTN program. if Place of followup = Subcenter OPD | where followup done in SC OPD/total enrolment*100 | Latest followup in Epilepsy program. if Place of followup = Subcenter OPD | where followup done in SC OPD/total enrolment*100 |
| Mobile Clinic | Latest followup in HTN program. if Place of followup = Mobile Clinic | where followup done in mobile clinic/total enrolment*100 | Latest followup in DM program. if Place of followup = Mobile Clinic | where followup done in mobile clinic/total enrolment*100 | Latest followup in SC program. if Place of followup = Mobile Clinic | where followup done in mobile clinic/total enrolment*100 | Latest followup in Epilepsy program. if Place of followup = Mobile Clinic | where followup done in mobile clinic/total enrolment*100 |
| Ganiyari Hospital | Latest followup in HTN program. if Place of followup = Ganiyari Hospital | where followup done in ganiyari/total enrolment*100 | Latest followup in DM program. if Place of followup = Ganiyari Hospital | where followup done in ganiyari/total enrolment*100 | Latest followup in SC program. if Place of followup = Ganiyari Hospital | where followup done in ganiyari/total enrolment*100 | Latest followup in Epilepsy program. if Place of followup = Ganiyari Hospital | where followup done in ganiyari/total enrolment*100 |
| Home | Latest followup in HTN program. if Place of followup = Home | where followup done at home/total enrolment*100 | Latest followup in DM program. if Place of followup = Home | where followup done at home/total enrolment*100 | Latest followup in SC program. if Place of followup = Home | where followup done at home/total enrolment*100 | Latest followup in Epilepsy program. if Place of followup = Home | where followup done at home/total enrolment*100 |
| PSG Meeting | Latest followup in HTN program. if Place of followup = PSG meeting | where followup done PSG meeting/total enrolment*100 | Latest followup in DM program. if Place of followup = PSG meeting | where followup done PSG meeting/total enrolment*100 | Latest followup in SC program. if Place of followup = PSG meeting | where followup done PSG meeting/total enrolment*100 | Latest followup in Epilepsy program. if Place of followup = PSG meeting | where followup done PSG meeting/total enrolment*100 |
| Followup not done | Where enrolment done but followup not done | followup not done/Total enrolment*100 | Where enrolment done but followup not done | followup not done/Total enrolment*100 | Where enrolment done but followup not done | followup not done/Total enrolment*100 | Where enrolment done but followup not done | followup not done/Total enrolment*100 |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Patient treatment status
Columns (along with logic for columns except the basic ones):
| Characterstics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sicklecell-Proportion | Epilepsy-Number | Epilepsy-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|---|---|
| Default | Latest treatment status of patient = Default (HTN latest followup - "Patient treatment status") | default patients/total enrolled in HTN*100 | Latest treatment status of patient = Default (Diabetes latest followup - "Patient treatment status") | default patients/total enrolled in Diabetes*100 | Latest treatment status of patient = Default (Sickle cell latest followup - "Patient treatment status") | default patients/total enrolled in Sickle cell*100 | Latest treatment status of patient = Default (Epilepsy latest followup - "Patient treatment status") | default patients/total enrolled in Epilepsy*100 | Latest treatment status of patient = Default (Tuberculosis latest followup - "Patient treatment status") | default patients/total enrolled in Tuberculosis*100 |
| Break in treatment | Latest treatment status of patient = Break in treatment (HTN latest followup - "Patient treatment status") | break in treatment patients/total enrolled in HTN*100 | Latest treatment status of patient = Break in treatment (Diabetes latest followup - "Patient treatment status") | break in treatment patients/total enrolled in Daibetes*100 | Latest treatment status of patient = Break in treatment (Sickle cell latest followup - "Patient treatment status") | break in treatment patients/total enrolled in Sickle cell*100 | Latest treatment status of patient = Break in treatment (Epilepsy latest followup - "Patient treatment status") | break in treatment patients/total enrolled in Epilepsy*100 | Latest treatment status of patient = Break in treatment (Tuberculosis latest followup - "Patient treatment status") | break in treatment patients/total enrolled in Tuberculosis*100 |
| Treatment not breaking | Latest treatment status of patient = not breaking (HTN latest followup - "Patient treatment status") | not breaking treatment patients/total enrolled in HTN*100 | Latest treatment status of patient = Regular (Diabetes latest followup - "Patient treatment status") | regular patients/total enrolled in Diabetes*100 | Latest treatment status of patient = Regular (Sickle cell latest followup - "Patient treatment status") | regular patients/total enrolled in Sickle cell*100 | Latest treatment status of patient = Regular (Epilepsylatest followup - "Patient treatment status") | regular patients/total enrolled in Epilepsy*100 | Latest treatment status of patient = Regular (Tuberculosis latest followup - "Patient treatment status") | regular patients/total enrolled in Tuberculosis*100 |
| Can't calculate yet | Latest treatment status of patient = can't calculate yet (HTN latest followup - "Patient treatment status") | patients where treatment status is not calculated/total enrolled in HTN*100 | Latest treatment status of patient = can't calculate yet (Diabetes latest followup - "Patient treatment status") | patients where treatment status is not calculated/total enrolled in Diabetes*100 | Latest treatment status of patient = can't calculate yet (Sickle cell latest followup - "Patient treatment status") | patients where treatment status is not calculated/total enrolled in Sickle cell*100 | Latest treatment status of patient = can't calculate yet (Epilepsy latest followup - "Patient treatment status") | patients where treatment status is not calculated/total enrolled in Epilepsy*100 | Latest treatment status of patient = can't calculate yet (Tuberculosis latest followup - "Patient treatment status") | patients where treatment status is not calculated/total enrolled in Tuberculosis*100 |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Enrolment start date - On enrolment date
Enrolment end date - On enrolment date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Place of referral
Columns (along with logic for columns except the basic ones):
| Characterstics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sicklecell-Proportion | Epilepsy-Number | Epilepsy-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|---|---|
| JSS Mobile clinic | Latest referral in HTN programme. if place of referral = JSS mobile clinic | Referral at JSS mobile clinic/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = JSS mobile clinic | Referral at JSS mobile clinic/Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = JSS mobile clinic | Referral at JSS mobile clinic/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = JSS mobile clinic | Referral at JSS mobile clinic/Total enrollment*100 | Latest referral in TB programme. if place of referral = JSS mobile clinic | Referral at JSS mobile clinic/Total enrollment*100 |
| JSS subcenter | Latest referral in HTN programme. if place of referral = JSS subcenter | Referral at JSS subcenter/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = JSS subcenter | Referral at JSS subcenter/Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = JSS subcenter | Referral at JSS subcenter/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = JSS subcenter | Referral at JSS subcenter/Total enrollment*100 | Latest referral in TB programme. if place of referral = JSS subcenter | Referral at JSS subcenter/Total enrollment*100 |
| Ganiyari Hospital | Latest referral in HTN programme. if place of referral = Ganiyari Hospital | Referral at Ganiyari Hospital/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = Ganiyari Hospital | Referral at Ganiyari Hospital/Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = Ganiyari Hospital | Referral at Ganiyari Hospital/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = Ganiyari Hospital | Referral at Ganiyari Hospital/Total enrollment*100 | Latest referral in TB programme. if place of referral = Ganiyari Hospital | Referral at Ganiyari Hospital/Total enrollment*100 |
| PHC | Latest referral in HTN programme. if place of referral = PHC | Referral at PHC/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = PHC | Referral at PHC/Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = PHC | Referral at PHC/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = PHC | Referral at PHC/Total enrollment*100 | Latest referral in TB programme. if place of referral = PHC | Referral at PHC/Total enrollment*100 |
| Community Health Centre | Latest referral in HTN programme. if place of referral = CHC | Referral at CHC/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = CHC | Referral at CHC/Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = CHC | Referral at CHC/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = CHC | Referral at CHC/Total enrollment*100 | Latest referral in TB programme. if place of referral = CHC | Referral at CHC/Total enrollment*100 |
| District Hospital | Latest referral in HTN programme. if place of referral = DH | Referral at DH /Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = DH | Referral at DH /Total enrollment*100 | Latest referral in Sickle cell programme. if place of referral = DH | Referral at DH /Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = DH | Referral at DH /Total enrollment*100 | Latest referral in TB programme. if place of referral = DH | Referral at DH /Total enrollment*100 |
| Medical College | Latest referral in HTN programme. if place of referral = Medical college | Referral at Medical college/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = Medical college | Referral at Medical college/Total enrollment*100 | Latest referral in Sickle-cell programme. if place of referral = Medical college | Referral at Medical college/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = Medical college | Referral at Medical college/Total enrollment*100 | Latest referral in TB programme. if place of referral = Medical college | Referral at Medical college/Total enrollment*100 |
| Other | Latest referral in HTN programme. if place of referral = Other places | Referral at Other places/Total enrollment*100 | Latest referral in Diabetes programme. if place of referral = Other places | Referral at Other places/Total enrollment*100 | Latest referral in Sickle-cell programme. if place of referral = Other places | Referral at Other places/Total enrollment*100 | Latest referral in Epilepsy programme. if place of referral = Other places | Referral at Other places/Total enrollment*100 | Latest referral in TB programme. if place of referral = Other places | Referral at Other places/Total enrollment*100 |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Reasons for not taking medicines
Columns (along with logic for columns except the basic ones):
| Characterstics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sicklecell-Proportion | Epilepsy-Number | Epilepsy-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|---|---|
| Poor Compliance | ||||||||||
| Forgotten to take medicine | ||||||||||
| Side effects of drugs | ||||||||||
| Patient don’t want to continue medicines from JSS | ||||||||||
| Taking medicines from govt/private hospital/dispensary | ||||||||||
| Taking medicines from traditional healers | ||||||||||
| Others | ||||||||||
| Not answered |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)
Criteria / Logic for data:
Title of Report in Jasper: Referral reason
Columns (along with logic for columns except the basic ones):
| Characterstics | Hypertension-Number | Hypertension-Proportion | Diabetes-Number | Diabetes-Proportion | Sickle cell-Number | Sicklecell-Proportion | Epilepsy-Number | Epilepsy-Proportion | Tuberculosis-Number | Tuberculosis-Proportion |
|---|---|---|---|---|---|---|---|---|---|---|
| Lab and other investigation work up | ||||||||||
| Doctors consultation | ||||||||||
| Annual check | ||||||||||
| Consultation with specialist | ||||||||||
| Admission | ||||||||||
| Other |
Filters:
Observation start date - On encounter date
Observation end date - On encounter date
Cluster - Name of cluster
Age group - Age group (0-30, 31-50, >50)
Gender - Male, Female, Other
Caste category - General, ST, SC, OBC
Exited - (Yes/No)