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
Spreadsheet tracker			\\tc4s0b\groups\AMS\amse\MIU Main Tracker

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:

User complaining about insurer’s address is removed from saved (but un-finalized) certificates.

This is more of user training issue.

User blank out, insurer's and owner's name and addresses instead of deleting them.

Search for the Wreck Certificates and found many certificates where insurer's address were blank.

Looked into the database, in the TY002_PARTY and TY001_ADDRESS table some addresses are blank. But TY002_INSURER_CD and TY001_INSURER_ADDRESS_CD fields related to those blank addresses were there in UM001_Cerificate_Issued.

So went to the user in person, search specific insurer's address in the database and update the specific address which populate all the records for the in-progress certificates.

Train the user about how to delete the addresses and not blank out them.