Versions Compared

Old Version 20

changes.mady.by.user Dragos Dobre

Saved on

compared with

New Version 21

changes.mady.by.user Dragos Dobre

Saved on

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.  

...

Fix the default user's password
On SQL Server 2017, when restoring the backup database, the default user's password was set to NULL.

1.2.0 (October 2018) 

Single Github repository for the database
The first Master Version repository included all the openIMIS components. This version integrates new functionalities and is managed in a separate repository. 

SQL Scripts extract
For documentation purposes, the Github repository includes the SQL scripts of the database.