reporting_facility_states


Description

Monthly summary of a facility’s indicators. This table has one row per facility, per month, from the month of the facility’s first registration.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
month_date date 13 √ null

The reporting month for this row, represented as the date at the beginning of the month
month float8 17,17 √ null

Month (1-12) of year
quarter float8 17,17 √ null

Quarter (1-4) of year
year float8 17,17 √ null

Year in YYYY format
month_string text 2147483647 √ null

String that represents a month, in YYYY-MM format
quarter_string text 2147483647 √ null

String that represents a quarter, in YYYY-Q format
facility_id uuid 2147483647 √ null

ID of the facility
facility_name varchar 2147483647 √ null

Name of the facility
facility_type varchar 2147483647 √ null

Type of the facility (eg. ‘District Hospital’)
facility_size varchar 2147483647 √ null

Size of the facility (community, small, medium, large)
facility_region_id uuid 2147483647 √ null

ID of the facility region
facility_region_name varchar 2147483647 √ null

Name of the facility region. Usually the same as the facility name
facility_region_slug varchar 2147483647 √ null

Human readable ID of the facility region
block_region_id uuid 2147483647 √ null

ID of the block region that the facility is in
block_name varchar 2147483647 √ null

Name of the block region that the facility is in
block_slug varchar 2147483647 √ null

Human readable ID of the block region that the facility is in
district_id uuid 2147483647 √ null

ID of the facility group that the facility is in
district_region_id uuid 2147483647 √ null

ID of the district region that the facility is in
district_name varchar 2147483647 √ null

Name of the district region that the facility is in
district_slug varchar 2147483647 √ null

Human readable ID of the district region that the facility is in
state_region_id uuid 2147483647 √ null

ID of the state region that the facility is in
state_name varchar 2147483647 √ null

Name of the state region that the facility is in
state_slug varchar 2147483647 √ null

Human readable ID of the state region that the facility is in
organization_id uuid 2147483647 √ null

ID of the organization that the facility is in
organization_region_id uuid 2147483647 √ null

ID of the organization region that the facility is in
organization_name varchar 2147483647 √ null

Name of the organization region that the facility is in
organization_slug varchar 2147483647 √ null

Human readable ID of the organization region that the facility is in
cumulative_registrations int8 19 √ null

The total number of hypertensive patients registered at the facility up to the end of the reporting month
monthly_registrations int8 19 √ null

The number of hypertensive patients registered at the facility in the reporting month
cumulative_diabetes_registrations int8 19 √ null

The total number of diabetic patients registered at the facility up to the end of the reporting month
monthly_diabetes_registrations int8 19 √ null

The number of diabetic patients registered at the facility in the reporting month
cumulative_hypertension_and_diabetes_registrations int8 19 √ null

The total number of patients registered at the facility with both hypertension and diabetes up to the end of the reporting month
monthly_hypertension_and_diabetes_registrations int8 19 √ null

The number of patients registered at the facility with both hypertensio and diabetes in the reporting month
under_care int8 19 √ null

The number of patients assigned to the facility as of the reporting month where the patient had a BP recorded within the last year, and is not dead
lost_to_follow_up int8 19 √ null

The number of patients assigned to the facility as of the reporting month where the patient did not have a BP recorded within the last year, and is not dead
dead int8 19 √ null

The number of hypertensive patients assigned to the facility as of the reporting month who are dead
cumulative_assigned_patients int8 19 √ null

The total number of hypertensive patients assigned to the facility up to the end of the reporting month
diabetes_under_care int8 19 √ null

The number of patients assigned to the facility as of the reporting month where the patient had a blood sugar recorded within the last year, and is not dead
diabetes_lost_to_follow_up int8 19 √ null

The number of diabetic patients assigned to the facility as of the reporting month where the patient did not have a blood sugar recorded within the last year, and is not dead
diabetes_dead int8 19 √ null

The number of diabetic patients assigned to the facility as of the reporting month who are dead
cumulative_assigned_diabetic_patients int8 19 √ null

The total number of diabetic patients assigned to the facility up to the end of the reporting month
adjusted_controlled_under_care int8 19 √ null

The number of hypertensive patients registered before the last 3 months, with a BP < 140/90 at their last visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_uncontrolled_under_care int8 19 √ null

The number of hypertensive patients assigned to the facility that were registered before the last 3 months, with a BP >= 140/90 at their last visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_missed_visit_under_care int8 19 √ null

The number of hypertensive patients assigned to the facility that were registered before the last 3 months, with no visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_visited_no_bp_under_care int8 19 √ null

The number of hypertensive patients assigned to the facility that were registered before the last 3 months, with no BP taken at their last visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_missed_visit_lost_to_follow_up int8 19 √ null

adjusted_missed_visit_lost_to_follow_up
adjusted_visited_no_bp_lost_to_follow_up int8 19 √ null

adjusted_visited_no_bp_lost_to_follow_up
adjusted_patients_under_care int8 19 √ null

The number of hypertensive patients assigned to the facility that were registered before the last 3 months
adjusted_patients_lost_to_follow_up int8 19 √ null

The number of hypertensive patients assigned to the facility that were registered before the last 3 months, with no visit in the last year
adjusted_random_bs_below_200_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a random blood sugar < 200 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_fasting_bs_below_200_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a fasting blood sugar < 126 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_post_prandial_bs_below_200_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a post-prandial blood sugar < 200 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_hba1c_bs_below_200_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a hba1c blood sugar < 7%. Dead and lost to follow-up patients are excluded.
adjusted_bs_below_200_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar value as of a month is categorized as bs_below_200. Dead and lost to follow-up patients are excluded.
adjusted_random_bs_200_to_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a random blood sugar >= 200 mg/dL and < 300 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_fasting_bs_200_to_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a fasting blood sugar >= 126 and < 200 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_post_prandial_bs_200_to_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a post-prandial blood sugar >= 200 and < 300 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_hba1c_bs_200_to_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a hba1c blood sugar >= 7% and < 9%. Dead and lost to follow-up patients are excluded.
adjusted_bs_200_to_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar value as of a month is categorized as bs_200_to_300. Dead and lost to follow-up patients are excluded.
adjusted_random_bs_over_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a random blood sugar >= 300 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_fasting_bs_over_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a fasting blood sugar >= 200 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_post_prandial_bs_over_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a post-prandial blood sugar >= 300 mg/dL. Dead and lost to follow-up patients are excluded.
adjusted_hba1c_bs_over_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar measurement is a hba1c blood sugar >= 9%. Dead and lost to follow-up patients are excluded.
adjusted_bs_over_300_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, where their latest blood sugar value as of a month is categorized as bs_over_300. Dead and lost to follow-up patients are excluded.
adjusted_bs_missed_visit_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, with no visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_visited_no_bs_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, with no blood sugar taken at their last visit in the last 3 months. Dead and lost to follow-up patients are excluded.
adjusted_bs_missed_visit_lost_to_follow_up int8 19 √ null

adjusted_diabetes_missed_visit_lost_to_follow_up
adjusted_diabetes_patients_under_care int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months
adjusted_diabetes_patients_lost_to_follow_up int8 19 √ null

The number of diabetic patients assigned to the facility that were registered before the last 3 months, with no visit in the last year
monthly_cohort_controlled int8 19 √ null

The number of patients from monthly_cohort_patients with a BP <140/90 at their latest visit in the next two months. Eg. The number of patients registered in Jan 2020 with a controlled BP at their latest visit in Feb-Mar 2020
monthly_cohort_uncontrolled int8 19 √ null

The number of patients from monthly_cohort_patients with a BP >=140/90 at their latest visit in the next two months. Eg. The number of patients registered in Jan 2020 with an uncontrolled BP at their latest visit in Feb-Mar 2020
monthly_cohort_missed_visit int8 19 √ null

The number of patients from monthly_cohort_patients with no visit in the next two months. Eg. The number of patients registered in Jan 2020 with no visit in Feb-Mar 2020
monthly_cohort_visited_no_bp int8 19 √ null

The number of patients from monthly_cohort_patients with no BP recorded at their latest visit in the next two months. Eg. The number of patients registered in Jan 2020 with no BP recorded at their latest visit in Feb-Mar 2020
monthly_cohort_patients int8 19 √ null

The number of patients assigned to the facility that were registered two months before the reporting month, and have a . Eg. For a March 2020 report, the number of patients registered in Jan 2020
monthly_overdue_calls int8 19 √ null

The number of overdue calls made by healthcare workers at the facility in the reporting month
monthly_follow_ups int8 19 √ null

The number of hypertensive follow-up patient visits at the facility in the reporting month
monthly_diabetes_follow_ups int8 19 √ null

The number of diabetic follow-up patient visits at the facility in the reporting month
total_appts_scheduled int4 10 √ null

The total number of appointments scheduled by healthcare workers for hypertensive patients at the facility in the reporting month
appts_scheduled_0_to_14_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for hypertensive patients at the facility in the reporting month between 0 and 14 days from the visit date
appts_scheduled_15_to_31_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for hypertensive patients at the facility in the reporting month between 15 and 31 days from the visit date
appts_scheduled_32_to_62_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for hypertensive patients at the facility in the reporting month between 32 and 62 days from the visit date
appts_scheduled_more_than_62_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for hypertensive patients at the facility in the reporting month more than 62 days from the visit date
diabetes_total_appts_scheduled int4 10 √ null

The total number of appointments scheduled by healthcare workers for diabetic patients at the facility in the reporting month
diabetes_appts_scheduled_0_to_14_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for diabetic patients at the facility in the reporting month between 0 and 14 days from the visit date
diabetes_appts_scheduled_15_to_31_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for diabetic patients at the facility in the reporting month between 15 and 31 days from the visit date
diabetes_appts_scheduled_32_to_62_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for diabetic patients at the facility in the reporting month between 32 and 62 days from the visit date
diabetes_appts_scheduled_more_than_62_days int4 10 √ null

The total number of appointments scheduled by healthcare workers for diabetic patients at the facility in the reporting month more than 62 days from the visit date
overdue_patients int8 19 √ null

The total of overdue patients at the facility at the beginning of the reporting month. Dead and lost to follow-up patients are excluded.
contactable_overdue_patients int8 19 √ null

The total of overdue patients at the facility at the beginning of the reporting month excluding patients who are removed from overdue list. Dead and lost to follow-up patients are excluded.
patients_called int8 19 √ null

The total of calls made to overdue patients at the facility during the reporting month. Dead and lost to follow-up patients are excluded.
contactable_patients_called int8 19 √ null

The total of calls made to overdue patients at the facility during the reporting month. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
patients_called_with_result_agreed_to_visit int8 19 √ null

The total of overdue patients having call result type marked as ‘agreed_to_visit’ at the facility during the reporting month. Dead and lost to follow-up patients are excluded.
patients_called_with_result_remind_to_call_later int8 19 √ null

The total of overdue patients having call result type marked as ‘remind_to_call_later’ at the facility during the reporting month. Dead and lost to follow-up patients are excluded.
patients_called_with_result_removed_from_list int8 19 √ null

The total of overdue patients having call result type marked as ‘remind_to_call_later’ at the facility during the reporting month. Dead and lost to follow-up patients are excluded.
contactable_patients_called_with_result_agreed_to_visit int8 19 √ null

The total of overdue patients having call result type marked as ‘agreed_to_visit’ at the facility during the reporting month. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
contactable_patients_called_with_result_remind_to_call_later int8 19 √ null

The total of overdue patients having call result type marked as ‘remind_to_call_later’ at the facility during the reporting month. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
contactable_patients_called_with_result_removed_from_list int8 19 √ null

The total of overdue patients having call result type marked as ‘removed_from_overdue_list’ at the facility during the reporting month. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
patients_returned_after_call int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month. Dead and lost to follow-up patients are excluded.
contactable_patients_returned_after_call int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
patients_returned_with_result_agreed_to_visit int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘agreed_to_visit’. Dead and lost to follow-up patients are excluded.
patients_returned_with_result_remind_to_call_later int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘remind_to_call_later’. Dead and lost to follow-up patients are excluded.
patients_returned_with_result_removed_from_list int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘removed_from_overdue_list’. Dead and lost to follow-up patients are excluded.
contactable_patients_returned_with_result_agreed_to_visit int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘agreed_to_visit’. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
contactable_patients_returned_with_result_remind_to_call_later int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘remind_to_call_later’. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.
contactable_patients_returned_with_result_removed_from_list int8 19 √ null

The total of overdue patients who returned to a facility within 15 days after a call during the reporting month and call result type is ‘removed_from_overdue_list’. Patients who are removed from the overdue list at the beginning of the month are excluded. Dead and lost to follow-up patients are excluded.

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views