eMER - eREM

System Profile

System Full Name	Electronic Medical Examination Report
System Full Name (French)	Rapport d'éxamination médicale électronique
Subject Matter Expert
Web Team Expert
Division	Medicine
NTARS Code
Source Code Location	http://tfsprod:8080/tfs/CivAv/eMER-eREM
Migration to DevOps
New Source Code Location (DevOps)	https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/eMER-eREM

Technology Assessment

Platform Type	Web (Internal/External)
Database Platform and Version	Oracle 18C
Development Language and Framework	ASP.NET + VB.NET
Operating System and Version	Windows Server 2016
Additional Dependencies
Authentication	GCKey + 2FA

Environment Access Information

eMER does not have its own database, it uses CAMIS' database.

ENV	UNC	URL	DB

ENV	UNC	URL	DB
DEV	\\ncrws499\cawwwappsx\Saf-Sec-Sur\2\eMER-eREM	https://cawwwappsx.tc.gc.ca/Saf-Sec-Sur/2/eMER-eREM/	CAMISD
DEV (GCKey)	\\ncrws548\TPwwwroot\eigdev\secure\eMER-eREM	https://secweb-dev.tc.canada.ca/secure/eMER-eREM	CAMISD
DEV(GCKey) GART	\\tcwebscripts\gacswwwroot\securedev\eMER-eREM	https://gartdev.tc.gc.ca/secure/eMER-eREM/	CAMISD
PREACC			PREACC_CA
ACC	\\ncrws548\TPwwwroot\eigacc\secure\eMER-eREM	https://secweb-test.tc.canada.ca/secure/eMER-eREM	CAMISA
PROD	(Web Group manual deployment)	https://secweb.tc.canada.ca/secure/eMER-eREM	CAMISP

Documents

RDIMS (Protected B)

http://mytc/rdims/15596133

System Overview

eMer is an online tool to allow CAME to submit MER forms electronically.

It is integrated with TCMailer 3.0, Entrust GetAccess, TcVirusScan, Oracle Client 12c

How to set up eMER locally for first-time use

Good To Know

User profile must have a valid phone number in order to login due to 2FA authentication (in Acceptance and Production).

A doctor will do these following steps

Step 1: Click on eMER - Prod

Step 2: Login using GCKey with username and password

Step 3: Entering their activation code

Step 4: Prompted to enter their cell phone number

Step 5: Receiving the 2FA code to their cell phone

Step 6: Entering the 2FA code

Sign in successfully

Decommissioning of GART server n DEV:

The web group is working on decommissioning of GART Server (secweb-dev.tc.canada.ca ), starting with DEV Environment. eMER is migrated to the new server in DEV, tested and working properly. The link and path are updated accordingly.

Files for testing attachment types:

see Files for testing attachment types

How-To and Fixes

For support requests, see CAMIS - SIMAC.

For support requests, see CAMIS - SIMAC.

Note: Environment must be set to “PeerReview” in the web.config.

Get the 2FA user ID of the CAME, by running the following script in the 2FA database using the eMER activation code you can find in their CAME profile in CAMIS.

SELECT s.global_userid_lbl, s.* 
FROM AC040_STAKEHOLDER s 
JOIN AC044_EXTERNAL_STAKEHOLDER ext ON ext.stakeholder_id = s.stakeholder_id
WHERE ext.activation_code_txt = :activationCode ;

Open the repo and go to the l.aspx.vb file.

In the Private Sub Login() method, go to line 132: Dim twoFAUserID As String = "4UGF2GRY7B2F".

Update twoFAUserID variable to the 2FA user ID retrieved at the start.

BSD - Civil Aviation