Page Comparison

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

Excerpt

0 (April 2022)

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
OP-187: IMIS web and policies app: Renewal extracts dont work by @malinowskikam in #106
OTC-484: Fix renewal through USSD to use the bulk CN by @hirensoni913 in #107
Bugfix/otc 505 by @delcroip in #109
rework file structure by @delcroip in #111
fix merge file by @delcroip in #112
OTC-73: Changing of the language of the user interface without logout/login by @hirensoni913 in #114
OTC-511: Add a new column in tblPremium named CreatedDate by @hirensoni913 in #116
Missing FKs fixed by @hirensoni913 in #115
OTC-517: Fix database creation script by @malinowskikam in #117
Hotfix/perf capitation by @delcroip in #119
tblPayment > PhoneNumber length increased to 50 characters by @hirensoni913 in #120
Feature/otc 524 by @delcroip in #121
OTC-70: RFC 103 Report Overview of Commissions by @hirensoni913 in #123
OTC-528: PriceLists LocationId on a national level changed from 0 to NULL. by @wzglinieckisoldevelo in #125
split sp uspSSRSGetClaimOverview by @delcroip in #124
OTC-565: MemberCount type changed to int in schema and migration. by @wzglinieckisoldevelo in #126
OTC - 571: Automatize the claim processing by @hirensoni913 in #127
OTC-578: Alter database phone number fields to NVARCHAR(50) by @malinowskikam in #128
OTC-576: Get control numbers for EO sometimes throws the TimeOut error by @hirensoni913 in #129
OP-504: system can not generate Contribution distribution report by @hirensoni913 in #130
OP-248: Remove hardcodded _CompanyName in EmailHandler by @hirensoni913 in #131
use the period G or O or I by @delcroip in #132

...

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.

Versions Compared

Old Version 22

New Version Current

Key

1.

7.

0 (April 2022)

1.2.0 (October 2018)