Versions Compared

Old Version 16

changes.mady.by.user Phuong

Saved on

compared with

New Version 17

changes.mady.by.user Phuong

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Xia Wang, Nikolay Melnik (GALRO)

Chantal Avon (FTAE System Administrator)

Christopher McCue (CCARCS System Administrator)

Division

NTARS Code

CA26

Source Location

Source Code Location

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

Migration to DevOps

✅

New Source Code Location (DevOps)

https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/GALRO-AGLIE-SEC

Technology Assessment

Platform Type

Web (Internal)

Database Platform and Version

Oracle 18c

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

ACC

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

N/A

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

CCARCSA

HQRACC

FTAEA

PROD

consult with Web Group

N/A

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

CCARCSP

HQR

FTAE

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

...

Expand
titleUser requests access to GALRO online

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

Expand
titleUnable to issue an activation key in GALRO for the user

No account exists in CCARCE. Not issue an activation key in GALRO for a user because there is no such record in CCARCE. For example, when searching the individual details for that user, we do not find any record in CCARCE

Please send the email to Service Team Support to close all “pending registration action” and have that user re-apply as New Request-License.

References

Document

RDIMS #

GALRO_PHASE_I_CONSOLIDATED_ANALYSIS

4672886

GALRO_PHASE_II_III_CONSOLIDATED_ANALYSIS

4693669

GALRO_PHASE_II_III_SS2_SECURITY_DETAIL_DESIGN

4719638

GALRO_ENVIRONMENT_SUMMARY

Some of information in this document is out of date

16772158