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: