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 | |
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 |
|
PREACC | N/A | N/A | N/A | N/A |
ACC | \\Tctestmaster\tcappsroot\Saf-Sec-Sur\2\GALRO-AGLIE-SEC | N/A |
| |
PROD | consult with Web Group | N/A |
| |
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
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 |
Add Comment