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… >