System Profile
System Full Name | Flight Training and Aviation Education |
System Full Name (French) | Formation au vol et éducation aéronautique |
Business Administrator | Chantal Avon / Martine Dumas |
Business Owner | Ryan Johnson |
Director | Felix Meunier |
Subject Matter Expert | |
Division | Commercial Flight Standards |
NTARS Code | CA74 |
Source Location | |
Source Code Location | |
Migration to DevOps | |
New Source Code Location (DevOps-Git) |
Technology Assessment
Platform Type | Client/Server |
---|---|
Database Platform and Version | Oracle 18C |
Development Language and Framework | Appeon PowerBuilder 2021 |
Operating System and Version | Windows Server 2016 |
Additional Dependencies | |
Authentication |
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
---|---|---|---|---|
DEV | FTAED | |||
PREACC | PREACC_CA | |||
ACC | FTAEA | |||
PROD | FTAE | |||
TRAINING |
System Overview
The Flight Training and Aviation Education (FTAE) computer system is designed to utilize data compiled from flight test reports and written examination answer sheets.
FTAE is the central hub for the following applications:
CDE Internal – the interface to FTAE is real-time. If FTAE is down, the CDE Internal cannot function. The CDE internal is used for internal exams, but most of the examination information resides within the FTAE database and therefore, if FTAE is down, so is the CDE Internal.
CDE External – The CDE external is used for external exams. Exams are downloaded though GALRO, which accesses the FTAE database through the DMZ. Furthermore, once an external exam has been graded, it is uploaded through GALRO and the DMZ into the FTAE database.
GALRO communicates with external clients allowing them access to change addresses and reserve marks. This access will not be available during the outage.
TTSP (AMES) – AME checks exam results into the FTAE database.
DAPLS gets flight test information on a nightly basis from FTAE
NACIS sends and receives training unit information from/to FTAE.
CAS searches/displays Flight Training Units data of FTAE
FTAE Internal (web application) displays Flight Training Units data and updates them
CADORS receives a daily feed from CCARCSE. This daily feed will not be available during the outage.
AMES displays real-time exam results from FTAE.
MTOA Service connects to FTAE for Monitor form
Good To Know
The FTAE application can be accessed at \\TC4S0A\GROUPS\CIVAV shared\FTAE 3.3.5 CT\ftae2.exe
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >
Document | RDIMS# or Link |
---|---|
Developer’s Guide - How to Fix FTAE and CDE Issues | |
PPC Flight Test & ACP/AQPE Monitor Reports Flight Training and Aviation Education (FTAE) Instructions / Screen Shots | |
FTAE Data Model Review Document | |
FTAE 3.3.3 - C208817 | |
FTAE 3.3.4 - C213448 | |
FTAE V3.3.5 - March 26, 2021 | / |
AEI - CDE-AEI Procedures Guide |
Add Comment