Validate Tables and Stored Procedures for Each Health Record Type

XMLWordPrintable

    • Type: Story
    • Resolution: Done
    • Priority: High
    • None
    • Affects Version/s: None

      As a backend healthcare integration system, I want to verify if required tables and stored procedures (SPs) exist for each supported record type (e.g., Immunization, OP Consultation, Discharge Summary), so that I can ensure all necessary data sources are available before generating FHIR resources.

      Description:
      Implement logic to check if necessary DB tables and stored procedures exist for Immunization, OP Consultation, Discharge Summary, Diagnostics, and Wellness records. Log missing elements with severity level.

      Acceptance Criteria:

      • System checks if required tables and SPs exist in the database.
      • If any are missing, logs include:
        • Table/SP name
        • Related record type
        • Severity level
      • Fails gracefully and reports errors before proceeding to FHIR generation.

            Assignee:
            Karyamsetty Helen Grace
            Reporter:
            Shashank Kharkwal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: