Versions Compared

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

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

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

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

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

Expand
titleHow/what should I do when a user 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
titleNo account exists in CCARCE. We an 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 has 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