Configuration

Manage your Healthcare Analytics Insight Framework settings

Database Settings Domain KPIs Insight Settings Output Settings Advanced Configuration Export/Import

Database Connection

Connection String Format: dialect://username:password@host:port/database

Table Mappings

Appointments

Patients

Medicines

Prescriptions

Medical_test_reports

Medicine_batches

Invoices

Invoice_items

Domain-Specific KPIs

Clinical Outcomes KPIs

Name	Description	Threshold
treatment_success_rate	Percentage of treatments resulting in positive outcomes	75.0
symptom_reduction	Average reduction in symptom severity scores	40.0
readmission_rate	Percentage of patients readmitted within 30 days	15.0
complication_rate	Percentage of treatments with complications	5.0

Treatment Efficacy KPIs

Name	Description	Threshold
medicine_response_rate	Percentage of patients showing positive response to medication	70.0
treatment_abandonment	Percentage of treatments abandoned before completion	10.0
medication_adherence	Patient adherence to prescribed medication regimen	80.0
medication_comparison	Comparative efficacy between similar medications	15.0
side_effect_prevalence	Prevalence of reported side effects by medication	8.0

Operational KPIs

Name	Description	Threshold
wait_time	Average patient wait time (minutes)	20.0
appointment_utilization	Percentage of available appointments utilized	85.0
no_show_rate	Percentage of patients who miss appointments	10.0
time_per_patient	Average consultation time per patient	15.0
facility_utilization	Utilization rate of medical facilities	75.0
staff_productivity	Patient encounters per staff member	15.0

Financial KPIs

Name	Description	Threshold
revenue_per_patient	Average revenue generated per patient	5000.0
medication_margin	Profit margin on medication sales	40.0
outstanding_payments	Average days of outstanding payments	30.0
revenue_growth	Month-over-month revenue growth percentage	5.0
inventory_turnover	Rate of inventory usage and replacement	30.0

Patient Experience KPIs

Name	Description	Threshold
satisfaction_score	Average patient satisfaction rating	4.2
retention_rate	Percentage of patients returning for follow-up care	70.0
referral_rate	Rate of new patients from existing patient referrals	15.0
complaint_rate	Number of complaints per 100 patient visits	2.0
follow_up_compliance	Percentage of patients who follow up as recommended	65.0

Physician Performance KPIs

Name	Description	Threshold
patient_load	Average number of patients seen per day	20.0
diagnostic_accuracy	Percentage of accurate diagnoses	90.0
patient_outcomes	Patient outcome measures by physician	80.0
consultation_duration	Average time spent per consultation	15.0

Inventory Management KPIs

Name	Description	Threshold
stock_out_frequency	Frequency of medication stock-outs	5.0
near_expiry_inventory	Percentage of inventory nearing expiration	10.0
inventory_accuracy	Accuracy of physical inventory vs. system records	98.0
reorder_compliance	Compliance with automatic reordering thresholds	90.0
wastage_rate	Percentage of inventory lost to expiration or damage	3.0

Insight Generation Settings

Anomaly Detection

Z-Score Threshold Higher values result in fewer, more significant anomalies

Isolation Forest Contamination Expected proportion of anomalies in the dataset (0.01 to 0.5)

Trend Detection

Minimum Data Points Minimum number of data points required for trend analysis

Statistical Significance Level (p-value) Lower values indicate higher confidence in trend detection (typically 0.01 to 0.1)

Minimum Change Percent Minimum percentage change to qualify as a significant trend

Comparison Thresholds

Significant Difference (%) Minimum percentage difference to qualify as significant

Minimum Sample Size Minimum sample size required for group comparisons

Insight Priority Settings

Configure importance levels for different types of insights (1-5 scale):

Critical

High

Medium

Low

Informational

Output Configuration

Maximum Insights Per Category Limit the number of insights shown per category

Maximum Total Insights Limit the total number of insights generated

Refresh Frequency (hours) How often the insights are automatically refreshed

Notification Settings

Enable email notifications for critical insights

Email Recipients Comma-separated list of email addresses

Show alerts on dashboard for high priority insights

Advanced Configuration

Changing these settings may affect system performance. Proceed with caution.

Logging Configuration

Log Level

Log File Path

Performance Settings

Cache Timeout (seconds)

Query Timeout (seconds)

Custom SQL Templates Directory

Templates Directory

Export/Import Configuration

Current Configuration

Export your current configuration as a JSON file:

Import Configuration

Import a configuration from a JSON file:

Configuration File

Raw JSON Editor

View and edit the configuration directly in JSON format:

{
  "database": {
    "connection_string": "postgresql://parshant:plive#4436@praic.cfugsooweqp6.ap-south-1.rds.amazonaws.com/praic_live",
    "tables": {
      "appointments": "appointments",
      "invoice_items": "invoice_items",
      "invoices": "invoices",
      "medical_test_reports": "medical_test_reports",
      "medicine_batches": "medicine_batches",
      "medicines": "medicines",
      "patients": "patients",
      "prescriptions": "prescriptions"
    }
  },
  "domain_kpis": {
    "clinical_outcomes": [
      {
        "description": "Percentage of treatments resulting in positive outcomes",
        "name": "treatment_success_rate",
        "threshold": 75.0
      },
      {
        "description": "Average reduction in symptom severity scores",
        "name": "symptom_reduction",
        "threshold": 40.0
      },
      {
        "description": "Percentage of patients readmitted within 30 days",
        "name": "readmission_rate",
        "threshold": 15.0
      },
      {
        "description": "Percentage of treatments with complications",
        "name": "complication_rate",
        "threshold": 5.0
      }
    ],
    "financial": [
      {
        "description": "Average revenue generated per patient",
        "name": "revenue_per_patient",
        "threshold": 5000.0
      },
      {
        "description": "Profit margin on medication sales",
        "name": "medication_margin",
        "threshold": 40.0
      },
      {
        "description": "Average days of outstanding payments",
        "name": "outstanding_payments",
        "threshold": 30.0
      },
      {
        "description": "Month-over-month revenue growth percentage",
        "name": "revenue_growth",
        "threshold": 5.0
      },
      {
        "description": "Rate of inventory usage and replacement",
        "name": "inventory_turnover",
        "threshold": 30.0
      }
    ],
    "inventory_management": [
      {
        "description": "Frequency of medication stock-outs",
        "name": "stock_out_frequency",
        "threshold": 5.0
      },
      {
        "description": "Percentage of inventory nearing expiration",
        "name": "near_expiry_inventory",
        "threshold": 10.0
      },
      {
        "description": "Accuracy of physical inventory vs. system records",
        "name": "inventory_accuracy",
        "threshold": 98.0
      },
      {
        "description": "Compliance with automatic reordering thresholds",
        "name": "reorder_compliance",
        "threshold": 90.0
      },
      {
        "description": "Percentage of inventory lost to expiration or damage",
        "name": "wastage_rate",
        "threshold": 3.0
      }
    ],
    "operational": [
      {
        "description": "Average patient wait time (minutes)",
        "name": "wait_time",
        "threshold": 20.0
      },
      {
        "description": "Percentage of available appointments utilized",
        "name": "appointment_utilization",
        "threshold": 85.0
      },
      {
        "description": "Percentage of patients who miss appointments",
        "name": "no_show_rate",
        "threshold": 10.0
      },
      {
        "description": "Average consultation time per patient",
        "name": "time_per_patient",
        "threshold": 15.0
      },
      {
        "description": "Utilization rate of medical facilities",
        "name": "facility_utilization",
        "threshold": 75.0
      },
      {
        "description": "Patient encounters per staff member",
        "name": "staff_productivity",
        "threshold": 15.0
      }
    ],
    "patient_experience": [
      {
        "description": "Average patient satisfaction rating",
        "name": "satisfaction_score",
        "threshold": 4.2
      },
      {
        "description": "Percentage of patients returning for follow-up care",
        "name": "retention_rate",
        "threshold": 70.0
      },
      {
        "description": "Rate of new patients from existing patient referrals",
        "name": "referral_rate",
        "threshold": 15.0
      },
      {
        "description": "Number of complaints per 100 patient visits",
        "name": "complaint_rate",
        "threshold": 2.0
      },
      {
        "description": "Percentage of patients who follow up as recommended",
        "name": "follow_up_compliance",
        "threshold": 65.0
      }
    ],
    "physician_performance": [
      {
        "description": "Average number of patients seen per day",
        "name": "patient_load",
        "threshold": 20.0
      },
      {
        "description": "Percentage of accurate diagnoses",
        "name": "diagnostic_accuracy",
        "threshold": 90.0
      },
      {
        "description": "Patient outcome measures by physician",
        "name": "patient_outcomes",
        "threshold": 80.0
      },
      {
        "description": "Average time spent per consultation",
        "name": "consultation_duration",
        "threshold": 15.0
      }
    ],
    "treatment_efficacy": [
      {
        "description": "Percentage of patients showing positive response to medication",
        "name": "medicine_response_rate",
        "threshold": 70.0
      },
      {
        "description": "Percentage of treatments abandoned before completion",
        "name": "treatment_abandonment",
        "threshold": 10.0
      },
      {
        "description": "Patient adherence to prescribed medication regimen",
        "name": "medication_adherence",
        "threshold": 80.0
      },
      {
        "description": "Comparative efficacy between similar medications",
        "name": "medication_comparison",
        "threshold": 15.0
      },
      {
        "description": "Prevalence of reported side effects by medication",
        "name": "side_effect_prevalence",
        "threshold": 8.0
      }
    ]
  },
  "insight_settings": {
    "anomaly_detection": {
      "isolation_forest_contamination": 0.05,
      "z_score_threshold": 2.5
    },
    "comparison_thresholds": {
      "min_sample_size": 30,
      "significant_difference": 15.0
    },
    "insight_priority": {
      "critical": 5,
      "high": 4,
      "informational": 1,
      "low": 2,
      "medium": 3
    },
    "trend_detection": {
      "min_change_percent": 10.0,
      "min_data_points": 5,
      "significance_level": 0.05
    }
  },
  "output_settings": {
    "max_insights_per_category": 3,
    "max_total_insights": 10,
    "refresh_frequency_hours": 24
  }
}

PRAIC