Every time a new Flight is UPLOADED into XpressA™, the RESULT database gets updated. The RESULT database contains records of all exceedances found in all flights getting analyzed.
Flights not presenting any exceedances are still creating one record in the RESULT database with the term “No Deviations” as Event Text
Each deviation or exceedance coming from Flight Analysis gets automatically recorded as a newline in the RESULT database.
Let’s see a deviation as an example. Let’s go to ‘events’ and look at piloting techniques. In this case, you will see three deviations in red.
We are going to put some comments on them. As an example, we can name them as comment 1, comment 2 and comment 3.
After that, we go to statistics. Its access is located below flights. Inside statistics, there is a column with the comments we’ve added beside the exceedances.
The column ‘parameters’ shows the user and the date that the comment has been modified. As you can see in this example, this comment has been updated by ‘TEST’ and the date is ‘2023-08-24’.
If the User goes back to the event list and reverts the record to the previous state (checks the checkbox and removes the comment), the statistics table will not update, and the comment will be still visible.
To remove the comment from the statistics and revert the original flight, only the User with Admin privileges can upload the same flight to XpressA again and the data will be overwritten over the existing flight.
Flight after flight, the RESULT database grows adding one or multiple records for each flight. Depending on the way the Airline is organized all flight exceedances are regrouped into a single RESULT database or there is one RESULT database by aircraft type.
In any case, the result database is the permanent source of information, which is used for statistics, ‘dashboard’, analytics, and trends.