EMS - SIGAL

System Profile

System Full Name	Enforcement Management System
System Full Name (French)	Système informatisé de gestion de l’application de la loi
Business Administrator	Jeannot Pilon
Business Owner	Jean-François Mathieu
Director	Felix Meunier
Subject Matter Expert
Division
NTARS Code	CA21
Source Location
Source Code Location	http://tfsprod:8080/tfs/CivAv/EMS-SIGAL
Migration to DevOps
New Source Code Location (DevOps)	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/EMS-SIGAL

Technology Assessment

Platform Type	Web (Internal)
Database Platform and Version	Oracle 18C
Development Language and Framework	Classic ASP
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication

Environment Access Information

ENV	UNC	WWWFILES	URL	DB

ENV	WWWFILES	URL	DB
DEV	\\ncrws499\catcappsx\Saf-Sec-Sur\2\EMS	http://catcappsx/Saf-Sec-Sur/2/ems/	EMSD
PREACC			PREACC_CA
ACC	\\tcapps2test\tcappsroot\Saf-Sec-Sur\2\EMS	http://tcapps2test/Saf-Sec-Sur/2/ems/	EMSA
PROD	(Manual deployment)	http://tcapps2.tc.gc.ca/Saf-Sec-Sur/2/EMS/	EMSP
TRAINING			EMST

System Overview

The Enforcement Management System (EMS) supports the enforcement process within the Transport Canada Aviation Enforcement Community. The system functions as a workflow automation tool designed to standardize, streamline and enhance the processing of enforcement cases. It also functions as a decision support system, providing support to both regional managers and headquarters staff within Transport Canada Aviation Enforcement.

EMS also has links to other applications, such as DAPLS and CCARCS for the retrieval of specific enforcement-related information.

EMS sends suspension information to DAPLS on a nightly basis. This is performed by scheduler job “JOB_RUN_SUSPENSIONS_TO_DAPLS”

Good To Know

EMS is not fully supported in Edge, you must set it in IE mode. Under Setting of the browser, under Default browser add http://tcapps2.tc.gc.ca/Saf-Sec-Sur/2/EMS/

Testing of sending an email in the oracle database for a job notification

execute sp_email_notify('To email address','from email address (i.e your email address )','EXTSMTP.TC.GC.CA', 'Testing-Do you receive this?', 'Sent using UTL_SMTP');

BSD - Civil Aviation