Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

System Profile

System Full Name

General Aviation Licensing and Registration On-line

Business Administrator

Christopher McCue

Business Owner

Jeff Phipps

Director

Felix Meunier

Subject Matter Expert

Division

NTARS Code

CA26

Source Location

Source Code Location

http://tfsprod:8080/tfs/CivAv/GALRO-AGLIE-SEC

Technology Assessment

Platform Type

Web (Internal)

Database Platform and Version

Oracle 18c. DB used: CCARCSP.WORLD, DAPLSP.WORLD and FTAEP.WORLD

Development Language and Framework

.NET 4.0, VB.NET, Web Forms, “Intranet“ GoC CLF

Operating System and Version

Windows Server 2016

Additional Dependencies

Crystal Report

Authentication

Windows/AD

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

DEV

\\ncrws499\catcappsx\Saf-Sec-Sur\2\GALRO-AGLIE-SEC

N/A

http://catcappsx/Saf-Sec-Sur/2/Galro-aglie-sec/client_2.aspx

CCARCSD

HQRDEV

ftaed

PREACC

N/A

N/A

N/A

N/A

ACC

\\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC

N/A

http://tcappstest/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

CCARCST

HQRACC

FTAEA

PROD

consult with Web Group

N/A

http://tcapps/Saf-Sec-Sur/2/GALRO-AGLIE-SEC/req_1.aspx

TRAINING

N/A

N/A

N/A

N/A

System Overview

GALRO Admin is an internal admin website that uses Oracle (CCARCS, FTAE, DAPLS database); It used by TC personnel (GALRO administrators) to manage internal user access and external user registration, activation

Good To Know

<--->

How-To and Fixes

Most asked questions: how/what should I do when user requested Galro online access?

New users, can request an “activation-key” directly from the Web by providing name and address information. The request is sent to CCARCS-E as a BF entry (client server system) where an Administrator reviews it. If there is a client match (existing client with same name and address) the client’s activation key is mailed to the client’s address. If there is no client match, a new client is created, and a new “activation-key” is assigned. The “activation-key” is then sent to the client’s address. 

  • The request is stored in the CCARCS-E database as a BF entry.  The entry is assigned to the appropriate region based on province.

  • The administrator reviews the request

  • The administrator searches the CCARCS-E database to see if a client with the same name/address already exists in the database

  • If a client already exists, a client letter is generated and mailed to the client

  • If there is not existing client found the Administrator:

    • Creates a new client in CCARCS-E database and an activation key is generated

    • The administrator generates the letter and mails it to the client

  • The administrator closes the BF entry

References

RDIMS-#4672886-v2-GALRO_PHASE_I_CONSOLIDATED_ANALYSIS

RDIMS-#4693669-v3-GALRO_PHASE_II_III_CONSOLIDATED_ANALYSIS

RDIMS-#4719638-v1-GALRO_PHASE_II_III_SS2_SECURITY_DETAIL_DESIGN

RDIMS-#16772158-v1-GALRO_ENVIRONMENT_SUMMARY (some information in this document are out of date)

  • No labels