MIUS

System Profile

System Full Name	Marine Insurance Unit System
Business Contact	Lachance, Sara <Sara.Lachance@tc.gc.ca> Begin, Linda <linda.begin@tc.gc.ca> Talbot, Stéphanie <stephanie.talbot@tc.gc.ca>
Business Owner
Source Location	https://dev.azure.com/transport-canada/DSD-MARINE%20Support/_git/MIUS

Technology Assessment

Database Platform and Version	Oracle 12c
Development Language and Framework	VB .NET Framework 4.0, Crystal Reports ,Click-Once Deployment
Operating System and Version	Windows 10 (Desktop Application)

Environment Access Information

ENV	UN	PW	UNC	URL	DB
DEV	DELANNP	See here	\\tcappsmssdev\tcappsroot\saf-sec-sur\4\mius-suam	http://tcappsmssdev/saf-sec-sur/4/mius-suam/publish.htm	MIUS@TTSD.WORLD
ACC	DELANNP	See here	\\tctestmaster\tcappstest\Saf-Sec-Sur\4\mius-suam	http://tcappstest/saf-sec-sur/4/mius-suam/publish.htm	MIUS_USER@TTSA.WORLD
PROD	DELANNP	See here	\\tcinfomaster\tcapps\Saf-Sec-Sur\4\MIUS-SUAM	http://tcapps/saf-sec-sur/4/mius-suam/publish.htm	MIUS_USER@TTSP_tcprdpkga.WORLD

System Overview

This system is used for management of certificates issued by the department in the area of CLC and Bunker vessels. These certificates are proof that the vessels have the necessary insurance guarantees to operate their vessels in Canadian waters.

Project History

Version	Project Description	Team	Product Vision Board	Delivery Date
1.5.0	Wreck Certificate and Bug Fixes	Team Kraken	MIUS Product Vision Board.pdf	Estimated: May 31, 2019

Good To Know

<Sub-sections should describe things that are useful to know when having to support the application>

How-To and Fixes

How to delete a certificate:

Delete From UM001_CERTIFICATE_ISSUED
Where CERTIFICATE_ID = @CERTIFICATE_ID;

Delete From TM010_CERTIFICATE_HISTORY
Where PRINTED_CERTIFICATE_NUM = @CERTIFICATE_ID;

MIUS issue: Insurer/Owner's Name or Address removed from saved (but un-finalized) certificates

Problem:
Client facing the issue that insurer’s address is removed from saved (but un-finalized) certificates whenever a change to an insurer’s address is made.

Solution:
See DOS 2419 for an appropriate solution.