ASTRA
- Alexandre Bédard
- kurt.martin
System Profile
System Full Name | Aviation Safety Response and Transmittal Action |
Business Administrator |
|
Business Owner | Joel Morley |
Director |
|
Subject Matter Expert |
|
Division | AARBQ |
NTARS Code | CA41 |
Source Location | Source code , data and documentation backed up to : \ncras22\CSSG Release\CSSG Staging\ASTRA\PROD{254499} |
Source Code Location | MDB file at : |
Technology Assessment
Platform Type | MS Access |
|---|---|
Database Platform and Version |
|
Development Language and Framework | MS Access |
Operating System and Version | Windows Server 2016 |
Additional Dependencies |
|
Authentication |
|
Environment Access Information
ENV | UNC | WWWFILES | URL | DB |
|---|---|---|---|---|
DEV |
|
|
|
|
PREACC |
|
|
|
|
ACC |
|
|
|
|
PROD |
|
|
|
|
TRAINING |
|
|
|
|
System Overview
Aviation Safety Response and Transmittal Action (ASTRA) is a Microsoft Access 2.0 based application used to track recommendations coming into TC from external stakeholders (TSB, Coroner, etc.) after their investigation of an occurrence. These recommendations are received by the Minister or ADM and are routed to the appropriate OPIs for evaluation and response. ASTRA helps facilitate this process along with CCM Mercury.
ASTRA was created by and for Civil Aviation, back in 1984 by the Aviation Safety Bureau, which became the System Safety Directorate in 1991. The System Safety Directorate was an aviation-specific direction, reporting directly to the Assistant Deputy Minister – Aviation.
The identification, definition and monitoring of any condition, circumstance or situation that is considered to be a hazard or a source of danger is an essential part of the Safety Programs, Strategies and Coordination (SPSC) Branch’s mandate. The ASTRA system provides a program to track proposed corrective actions and to monitor the responses the Department has agreed to take in an effort to eliminate these deficiencies.
Since aviation accidents have largely proven to be re-occurring and predictable occurrences, it is essential to have a program to track defects in the system that have already been actioned in order to facilitate additional advances in safety. The ASTRA system records hazards and deficiencies reported to Transport Canada. It retains these actions as a data base to assist in the preparation of corrective actions for similar hazards.
The system is composed of a computer based record of all identified deficiencies, a procedural system of allocating these deficient items within the Department for corrective action and the publication and distribution of a periodic report on the status of implementation of recommendations and advisories made by the Transportation Safety Board of Canada (TSB) and by provincial coroners.
The HQ ASTRA database is on the Local Area Network (LAN) of SPSC in Ottawa, and regional System Safety offices hold a stand alone copy of the HQ database, which can be updated through an e-mail transmit utility. This allows regions to browse, search and produce reports with their own copy of the HQ database on their own PC, (without affecting the HQ database).
Similarly, there is a capability to have regional ASTRA databases held on the Ottawa IAN, so that HQ staff may browse, search and produce reports from the regional databases. HQ copies of regional databases must be updated by e-mail by a transmit utility to stay current.
Good To Know
Formal decommissioning task initiated June 2022 PBI #132503 SM-GS #C254499
From Rdims #12733094 - Transport Canada Application Portfolio Managment
2020-10-21: During 2020 assessment, found ready TBD
2021-11-17: client identified app as to be decommissioned
2022-06-22
all source code , data and documentation backed up to :
\ncras22\CSSG Release\CSSG Staging\ASTRA\PROD{254499}
ATTACHMENTS
RDIMS-#6481686-v1-TSBL_MMS_AND_ASTRA_BACKGROUND
How-To and Fixes
<Sub-sections should describe how to address known support request, including any scripts, instructions / steps, etc… >