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 9 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

Xia Wang, Nikolay Melnik

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

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

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