System Profile
System Full Name | Civil Aviation Medical Examiner Search |
System Full Name (French) | Recherche de médecins-examinateurs de l'aéronautique civile |
Business Administrator | Daniel Baptiste |
Business Owner | Tyler Brooks |
Director | Tyler Brooks |
Subject Matter Expert | Mike Clark |
Division | Medicine |
NTARS Code | CA08 |
Source Location | |
Source Code Location | |
Migration to DevOps | ✅ |
New Source Code Location (DevOps) | https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/CAME-MEAC |
Technology Assessment
Platform Type | Web (External) |
|---|---|
Database Platform and Version | Oracle 11g18C |
Development Language and Framework | ASP.NET |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | |
Authentication |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV | \\ncrws499\cawwwappsx\Saf-Sec-Sur\2\CAME-MEAC | CAMISD | ||
PREACC | \\ncrws499\cawwwpreaccpx\Saf-Sec-Sur\2\came-meac | PREACC_CA | ||
ACC | \\tctestmaster\wwwappsroot\Saf-Sec-Sur\2\CAME-MEAC | CAMISA | ||
PROD | \\ncrws536\wwwapps\Saf-Sec-Sur\2\CAME-MEAC | CAMISP | ||
TRAINING | CAMIST |
System Overview
The Civil Aviation Medical Examiner Search (CAME SEARCH) is a web based application that allows internal and external users to search for approved Civil Aviation Medical Examiners by location.
Good To Know
...
The CAME search mainly retrieves data from table UA047_CAME_DIR_SEARCH, this table does not store data from the CAME application, but is refreshed by a daily job PROG_REFRESH_CAMEDIR_TABLES, implemented by package PK_CAME_DIR.spRefresh_Data, upon the job run, existing data will be overwritten.
...
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >