FTAE II - FVEA II

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

http://tfsprod:8080/tfs/civav/FTAE-FVEA/_dashboards

Migration to DevOps

New Source Code Location (DevOps-Git)

FTAE-FVEA-POWERBUILDER - Repos (azure.com)

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

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

Document

RDIMS# or Link

Developer’s Guide - How to Fix FTAE and CDE Issues

10169831

PPC Flight Test & ACP/AQPE Monitor Reports

Flight Training and Aviation Education (FTAE) Instructions / Screen Shots

16758920

FTAE Data Model Review Document

2339536

FTAE Flight Test Business Rules

14192063

Major Transformation Business Requirements Document for Capturing (Pilot) Flight Test Report Data

13473576

FTAE MTOA Business Rules Delta

16084849

Online PPC & Monitor reports - EOC - 11 FEB 2020

16255968

FTAE 3.3.3 - C208817

 

FTAE 3.3.3 Release Notes

16344503

FTAE 3.3.4 - C213448

 

FTAE 3.3.4 Release Notes

16375185

FTAE V3.3.5 - March 26, 2021

/

AEI - CDE-AEI Procedures Guide