Releases: openimis/database_ms_sqlserver
v1.7.0-rc0
Merge pull request #124 from openimis/feature/otc-492 split sp uspSSRSGetClaimOverview
v1.6.0
What's Changed
- OTC-8: Fixed brackets in latest migrations by @dborowiecki in #69
- OTC-250: Missing data in API (requested amount) during download by @malinowskikam in #72
- OP-347: Include SMS Logic in SQL database tables and procedures by @dborowiecki in #73
- OTC-318: Change uspConsumeEnrollments validation order by @dborowiecki in #74
- OTC-328: new policy status [Ready] accommodated in inquiry procedures by @hirensoni913 in #75
- OTC-319: Missing controls are added in Online and Migration script by @hirensoni913 in #78
- OP : 357 - Error in creating new database with Online script by @hirensoni913 in #80
- OP-358 : Latest migration failed to run by @hirensoni913 in #82
- OTC-348: Add rejection state to claim submission by @malinowskikam in #81
- OTC-65: RfC 101 Report Claim History by @hirensoni913 in #83
- OTC-364: Bulk control number request by @hirensoni913 in #85
- OTC-114 : CHF-5 Reconciliation of payment transactions by @hirensoni913 in #84
- OE0-34: Split medical item ItemPackage into ItemForm and ItemAmount => openIMIS side by @hirensoni913 in #86
- OTC-410: Change all the dates from string to datetime in rest api by @hirensoni913 in #87
- OTC-381: MV IMIS Policies::renewal prompts are not displayed by @hirensoni913 in #90
- OTC-415: MV: 500 error on GET /api/policy/ request by @hirensoni913 in #91
- OTC-431: Update XML serializing format to yyyy-MM-dd by @malinowskikam in #92
- Feature/otc 70 otc 223 by @delcroip in #88
- OP-373: Enquiry function doesn't provide full data by @malinowskikam in #93
- OTC-438: Adapt Claims app to get Claim response after submission by @malinowskikam in #94
- OTC-438: Fixed ClaimRejectionStatus declaration by @malinowskikam in #95
- OP-454: Add Usage field to the tblIMISDefaultsPhone to explain the fields by @malinowskikam in #97
- OTC-459: Change the policy renewal criteria from 14 days to <= 14 days by @hirensoni913 in #98
- OTC-463: Do not create payment if the amount is not passed during renewal by @hirensoni913 in #100
- OTC-472: Added new RestAPI procedures to migrations by @dborowiecki in #101
- Batch run chf prod fix by @malinowskikam in #102
- Resolved renewal bugs when the product is discontinued and a conversion product is assigned by @hirensoni913 in #103
- OP-459: Feedback does not upload correctly by @malinowskikam in #104
- OP-460: Drop uspConsumeEntolments stored procedure and rename uspRESTAPIConsumeEnrolments to uspConsumeEnrolments by @hirensoni913 in #105
New Contributors
- @hirensoni913 made their first contribution in #75
Full Changelog: v1.5.1...v1.6.0
Contributors
Assets 2
v1.5.1
April 2021 Release
Release notes
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.
Dependency / compatibility
Details on openIMIS Software Components page.
What's Changed
- OP-191: Added response to GetPolicyRenewals procedure by @dborowiecki in #54
- Feature/otc 40 by @delcroip in #56
- Feature/otc 66 by @malinowskikam in #57
- OTC-226: Capitation report shows region instead of districts by @malinowskikam in #58
- hotfix/tblProduct_recurrence by @dragos-dobre in #59
- fix tblProduct by @dragos-dobre in #60
- OTC-10: Added capitation payment create and retrieve procedures by @dborowiecki in #62
- Optimization: Changed the isOffline=0 update to affect only different values by @malinowskikam in #63
- Fix OP-328 by @dragos-dobre in #64
- OP-324: Delete member of family in uspConsumeEnrollment by @sniedzielski in #66
- OTC-243: added rights for claim admin to enquire insuree by @sniedzielski in #67
- OTC-10: Procedures used for batch reports don't include claims with RunID != null by @dborowiecki in #65
- OTC-8: Authorisation doesn't work properly by @malinowskikam in #68
- OTC-8: Fixed brackets in latest migrations by @dragos-dobre in #70
- Release/v1.5.1 by @dragos-dobre in #71
New Contributors
- @sniedzielski made their first contribution in #66
Full Changelog: v1.5.0...v1.5.1
Contributors
Assets 2
v1.5.0
October 2020 Release
Release notes
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.
Dependency / compatibility
Details on openIMIS Software Components page.
v1.4.2
April 2020 Release
Release notes
Database optimization: tables partitioning and index creation
The database contains now table partitions and creates new indexes to improve script execution.
Added import tools
The import tools have been moved from the documentation repository to the openIMIS Database repository.
Bug fixes
Check the Jira tickets for the list of issues fixed in this release.
Dependency / compatibility
Details on openIMIS Software Components page.
v1.4.1
December 2019 Patch
Release notes
Fix the language field length in ONLINE script
Dependency / compatibility
v1.4.0
October 2019 Release
Release notes
UUID fields are added to improve security
The identification of entities is now done through the UUID field. The id fields are maintained for backward compatibility.
New tables for ePayment module support
New tables have been added for the ePayment module.
New Demo database script
For demo and testing purposes, a new SQL script to generate the online database with the initial demo data has been included in the repository
Dependency / compatibility
v1.3.0
April 2019 Release
Release notes
Backup files are replaced by initial database SQL creation scripts
Because the passwords storage mechanism has been replaced, the stored procedure SETUP-IMIS has been removed and the installation of the database can be done by executing the new SQL creation scripts.
Scripts folder has been removed
Scripts folder (used for documentation purposes) has been removed due to it duplication. All scripts can be accessed from the initial database creation scripts.
Dependency / compatibility
v1.2.1
December 2018 Release
Release notes
Fix the default user's password
On SQL Server 2017, when restoring the backup database, the default user's password was set to NULL.
Dependency / compatibility
v1.2.0
October 2018 Release
Release notes
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.