Launching the Fleet AAIR Report at the Beginning of a new AAIR cycle
During the first week of each January, the Publications Unit (AARDA) requests the
“Consolidated Fleet Report” Report” from the AAIR side menu
The Fleet report “Launch” button performs the following tasks
Creates email documents, 1 for each FLEET, containing a spreadsheet of the tombstone data for each aircraft within each that fleet, with blank columns for the owner to fill in
It publishes these “unsent” emails to the inbox ofmailboxTC.AAIR-RAINA.TC@TC.GC.CA , the Publications Unit’s generic help email
A Publications user forwards these emails manually to each client, after ensuring that the email addresses and spreadsheet contents are correct
It allocates an M01 record for each aircraft having a fleet number, with an ISSUE-date = Current-date (assuming that an M01 record for the current reporting year does not already exist) It is also possible that some of these aircraft already reported under previous ownership.
An ISSUE-date = current-date is written to the Y59_fleet table
Special note : the Launch function is NOT security protected to the Admin role code (AU) though it likely should be. Any CAWIS user with a role code of HU or above can “launch” this report in the mistaken belief that they will see an online list of all FLEETS and their associated aircraft. (This is already available at: FLEET AAIR AIRCRAFT SUMMARY ) While the these emails generated do not go any further than the Publications unit, it does cause the unit frequent confusion (3 or 4 times per year) Also, there is no record kept of which user launched the report. This issue has been raised with AARDA management previously.
SAMPLE CONSOLIDATED FLEET REPORT FORM & Email - 2 columns for each aircraft
...
To: AAIR / RAINA (TC) <TC.AAIR-RAINA.TC@tc.gc.ca>
Subject: 2020 202X Fleet Report/ Rapport de flotte 2020202X
Annual Airworthiness Information Report (AAIR) – Consolidated Fleet Report
...