AMES - STEA

Owned by Alexandre Bédard
Last updated: Jan 11, 2024 by Alain Asgill
2 min read

System Profile

System Full Name

Aircraft Maintenance Engineer System

System Full Name (French)

Systèmes des techniciens d’entretien d’aéronefs

Business Administrator

Ryan Hennigar
AMESServiceRequests-DemandedeServiceTEA@tc.gc.ca

Business Owner

Jeff Phipps

Director

Felix Meunier

Subject Matter Expert

Mike Clark

Division

Operational Airworthiness

NTARS Code

CA01

Source Location

 

Source Code Location

 

Migration to DevOps

New Source Code Location (DevOps)

https://dev.azure.com/transport-canada/DSD-CIVAV Support/_git/AMES-TEA

Technology Assessment

Platform Type

Web (Internal)

Database Platform and Version

Oracle 18C

Development Language and Framework

Classic ASP

Operating System and Version

Windows Server 2016

Additional Dependencies

 

Authentication

 

Environment Access Information

ENV

UNC

WWWFILES

URL

DB

ENV

UNC

WWWFILES

URL

DB

DEV

 

\\ncrws499\catcappsx\Saf-Sec-Sur\2\AMES\AME\

http://catcappsx/saf-sec-sur/2/ames/

TTSXD18

ACC

 

\\tcapps2test\tcappsroot\Saf-Sec-Sur\2\AMES\

http://tcapps2test/saf-sec-sur/2/ames/

TTSXA18

PROD

 

 

http://tcapps2.tc.gc.ca/Saf-Sec-Sur/2/AMES/

TTSXP18

System Overview

The Aircraft Maintenance Engineer System (AMES) is used by Transport Canada Standards Branch, to monitor and generate licenses for Aircraft Maintenance Engineers.

Licensing information is updated directly on the TC web site and stored in a central database located in Ottawa. This system also generates the actual plastic AME licenses.

Good To Know

Description

RDIMS# or Link

Description

RDIMS# or Link

Aircraft Maintenance Engineer System (AMES) Version 2.7.7 - User Guide

15012752

How-To and Fixes

Suggested credentials for any fix: AMES_WEB@TTSXP18

Please refer to the “Request Access” link on the AMES website for information on how to request an account (RDIMS 7818850).

Users are stored in the USERADMIN table.

To add a user, run the following script:

Insert into AMES_WEB.USERADMIN (USERID, NAME, PWORD, STARTDATE, DESIGNATOR, CASUAL, NON_MAINTENANCE_EMPLOYEE_IND, USERLEVEL_ID) Values (:userId, :name, :pword, TO_DATE(:startDte, 'YYYY/MM/DD'), :designator, 0, 0, :userLvl);

If the password is set to a specific keyword (check the code or ask team lead), then the user will be forced to create a new password on login.

Run the following script:

SELECT AMES.AME_ID, FIRSTNAME, LASTNAME, email_txt, dateofbirth, address_1, address_2, city_desc_e, provstate_desc_e, cnt.country_desc_e, cit.country_desc_e, issued, renewed, expires, DATE_LICENCE_VALID_START_DTE, DATE_LICENCE_VALID_END_DTE, LISTAGG (rating_desc_e, ', ') WITHIN GROUP (ORDER BY AME_RATINGS.rating_id) "ratings" FROM ame_ratings JOIN rating_lkp ON AME_RATINGS.RATING_ID = RATING_LKP.RATING_id JOIN AMES ON ame_ratings.AME_ID = AMES.AME_ID INNER JOIN country_lkp cnt ON AMES.COUNTRY_ID = cnt.COUNTRY_ID JOIN city_lkp ON ames.city_id = city_lkp.city_id JOIN provstate_lkp ON AMES.PROVSTATE_ID = PROVSTATE_LKP.PROVSTATE_ID JOIN country_lkp cit ON AMES.CITIZEN_ID = cit.COUNTRY_ID --WHERE --ADD CLAUSES TO FILTER LISTING --email_txt IS NOT NULL and --end_date IS NULL --AND DATE_LICENCE_VALID_END_DTE >= SYSDATE GROUP BY ames.ame_id, FIRSTNAME, LASTNAME, email_txt, dateofbirth, address_1, address_2, city_desc_e, provstate_desc_e, cnt.country_desc_e, issued, renewed, expires, cit.country_desc_e, DATE_LICENCE_VALID_START_DTE, DATE_LICENCE_VALID_END_DTE ;

 

AMES Test Plans, Suites and Test Cases imported from TFS: