Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

GitHub repository: https://github.com/openimis/database_ms_sqlserver

Excerpt

1.5.1 (April 2021)

Update of the Stored Procedures

  • Fix uspMatchPayment

  • Fix uspSSRSOverviewOfCommissions

  • Added capitation payment create and retrieve procedures (for preparation to run capitation report calculation from modular batch run)

  • Added delete case insuree from family to consumeEnrollment

Improve maintainability

  • There is only one database migration script: openIMIS migration latest.sql

Features and bug fixes

  • Added User Profile rights to IMIS Administrator in migration script

  • Added rights for Claim Administrator to enquire insuree

  • Changed the isOffline=0 update to affect only different values

  • Added payment SMS

  • Fix RenewalOrder column

  • Added missing rights for Scheme Administrator in migration script

Check OP-260 for the full list of legacy openIMIS related tickets included in this release.

1.5.0 (October 2020)

Database optimization:

  • Index created on UserDistrict table

  • Partial indexes for actives row (Validity is null)

Update of the Stored Procedures

  • All Stored Procedure are updated based on the latest version (removed from Web Application source code)

  • MatchPayement SP support new Claim Ready state

  • ClaimOverview / ClaimHistory reports update

  • Change processing Marital status in uspConsumeEnrollments

  • Added uspIndexRebuild SP to facilitate index rebuild

Improve maintainability

  • There is only one database creation script

  • There are three additional scripts for specific usage: offline Health Facility, offline Insurance Office, Demo data set

Bug fixes

  • Cyclic dependency removed between Family and Insuree

  • Capitation report showing too many HF

  • Claim Admininstrator role doesn’t have the right authorities

  • Enrolment Officer role doesn’t have the right authorities

  • Add missing column in tblReporting

  • Fix insert of new EO officer

  • Fix insert User

  • Fix adding Claim Admin in uspUpdateClaimFromPhone

Check OP-209 for the full list of legacy openIMIS related tickets included in this release.

1.4.2 (April 2020)

Database optimization: tables partitioning and index creation
The database contains now table partitions and creates new indexes to improve script execution.  

...