Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

A workflow management and medical assessment tool used to support the entire life-cycle of a medical report for licensed aviation personnel.

Key functionality includes:
• A secure Internet-based application;
• Online access to current and previous medical history of applicants;
• Electronic submission of medical reports of licensed aviation personnel; and
• Online assessments of the reports and secure storage of medical documentation and
assessment results.

System Profile

System Full Name

Civil Aviation Medical Information System

System Full Name (French)

Systeme d'information medicine de l'Aviation civile

Subject Matter Expert

Michelle Coelho

Web Team Expert

Michaud, Marcel

Division

Medicine

NTARS Code

CA09

Source Code Location (Archived)

http://tfsprod:8080/tfs/CivAv/CAMIS-SIMAC/

Source Code Location

https://dev.azure.com/transport-canada/DSD-CIVAV%20Support/_git/CAMIS-SIMAC

Technology Assessment

Platform Type

Web (Internal/Secure)

Database Platform and Version

Oracle 18C

Development Language and Framework

ASP.NET + VB.NET

Operating System and Version

Windows Server 2016

Additional Dependencies

Authentication

Entrust True Pass

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

DEV

\\tcwebscripts\tpwwwroot\eigdev\CAMIS-SIMAC

https://eigdev.tc.gc.ca/camis-simac/

CAMISD

PREACC

PREACC_CA

ACC

\\tcwebscripts\tpwwwroot\eigacc\CAMIS-SIMAC

https://eigacc.tc.gc.ca/camis-simac/

CAMISA

TRAINING

CAMIST

PROD

https://eig.tc.gc.ca/camis-simac/

CAMISP

Expand
titleOld ETP Links

PreAcc: http://catcpreaccpx.tc.gc.ca/Saf-Sec-Sur/2/camis-simac
Acceptance: https://etpacc.tc.gc.ca/camis_simac/
Production: https://etp.tc.gc.ca/camis-simac/

...

see Files for testing attachment types

Deploying CAMIS to development, acceptance and production:

Checklist for deploying CAMIS

to dev/acc/prod

, 2FA, eMER, CAME to DEV/ACC/PROD

How-To and Fixes

Info

Suggested credential for any fix:
Development: CAMIS_DATA_ADMIN@CAMISPADMIN@CAMISD
Acceptance: CAMIS_DATA_ADMIN@CAMISPADMIN@CAMISA
Production: CAMIS_DATA_ADMIN@CAMISP

...

  • localhost

  • publishing packages for development, acceptance and production

Overview of CAMIS User (internal) and eMER accounts

External (eMER) and Internal (CAMIS User) accounts are both added to AC040_STAKEHOLER because AC040 is the master account table.
-> External accounts are identified by STAKEHOLDER_TYPE_CD = 2
-> Internal accounts are identified by STAKEHOLDER_TYPE_CD = 1

Table AC043_INTERNAL_STAKEHOLDER is for internal (CAMIS User) accounts ONLY.   

Table AC044_INTERNAL_STAKEHOLDER is for external (eMER - aka CAME Admin and CAME Associate Admin) only ONLY.


Account access issues:


CAME Accounts:

...

CAMES and CAME Associates access eMER the same way: with a GCKey and 2FA authentication.

The processes for creating a CAME or CAME Associate profile can be used by developers for creating test accounts on development and acceptance but not Production as the names of developers are not supposed to appear in the list of CAMES in the existing CAME dropdown.

This is the process that developers should use to create a test CAME troubleshooting account on production: Developer access to eMER on PROD

We should not submit data to production without collaborating with the business first.

Creating a CAME profile

Creating a CAME Associate Profile

...