Flights Database

Home Page→ Flights→ Flights Database

Overview

This interface helps you to look through the information about flights during the selected period.

With the help of the filters, it is possible to find the necessary flight quicker or to select those entries that meet your requirements.

For example, you can display only invoiced flights, or with allocation, or with the necessary status of revenue/expense, etc.

You have an opportunity to look through the deleted entries, flights that have already been closed, without attachments and schedule, but with empty legs.

The reports help to export the information in a more convenient view to conducting the necessary analysis.

The additional buttons make it possible to change the flight’s status or revenue/expense condition, create a schedule or flight report directly from the interface. Use the view selector to change the style of Flights Database.

List description

Status – the condition of the flight. It can be:
- Planned – the cell is highlighted in cyan
- Active – the cell is highlighted in yellow
- Completed - the cell is highlighted in green
- Canceled - the cell is highlighted in gray
- Confirmed - the cell is highlighted in blue-magenta
- Postponed - the cell is highlighted in pink
- Delayed - the cell is highlighted in red
- Request - the cell has no backlight
Report No. – the number of flight report
Closed – the tick is shown in case the flight is operated
Flight ID – the ID of the flight. The cell is highlighted in red
in case of empty leg
Waypoint srv – the number of waypoint services
Date – flight start date/time (planned or actual, depending on flight status). The cell is highlighted in blue in case of the No follow tick in the flight
Date Local – flight start date/time (planned or actual, depending on flight status) according to the local time. The cell is highlighted in blue in case of the No follow tick in the flight
Reg. No – the registration number of the aircraft
Type – the model of the aircraft
Office – the name of the company
Operator – the company who carries out the flight
Brokers – the name of the broker is shown in case it was selected in the customer
Flight No. – the call sign of the flight
Route – the path of flight
Crew checked – the tick
is shown in case the crew is confirmed
Customers – the name of the customer that was selected in the entry
Type – the category of flight
CPT – the name of assigned captains
Crew – the name of the crew members
- the code of crew will be shown in case the person is assigned to flight
- the “assign crew” message is shown in case there is no crew on the flight
Team – the color of the team will be shown
F.P. – the available payload at the first waypoint
F.V. – the available volume at the first waypoint
Wp.load – total flight WP load
Ch.Cargo – the total flight AWB’s chargeable weight
Cargo – the total flight AWB’s weight
Fly T – the time of flight
Block T – the total amount of time between blocks
I – the coins
are shown in case the flight is invoiced
AWB – number of invoiced AWBs/ total AWBs on flight
REV – flight revenue closed status
- a tick
  is shown in case the revenue is notified
- the double tick
  is shown in case the revenue is closed
EXP – flight expenses closed status
- a tick
  is shown in case the expenses are notified
- the double tick
  is shown in case the expenses are closed
A – allocated expenses mark

- the anchor
  is shown in case the expenses are allocated
Maintenance – the icon of tools
is shown

Other columns from the Report tab

F – the icon
of the clip is shown in case of attachments in flight
Aircraft – the registration number of the aircraft
Call sign – the calling code of the aircraft
Empty leg – the number of the PAX empty leg and Cargo empty leg
F.Type – the type of flight
S – the icon
of the briefcase is shown in case of the services

In case you can’t find a column in the list, please, check permissions on the page.

Manuals

How to display the different views of the interface

Open the View selector and select the most suitable variant:

General – full list with information about flights (will be shown by default)
Time – each sector will be shown in the separate box
Report – shortlist with information about flights

How to open the information about maintenance

Hover over the line and the icon of tools will be appeared
Click on the icon

In the sidebar you can find information about maintenance that is planned in the aircraft, its date of start and end, reason, status and left/cycle.

Backlight conditions

days left > 50 – the black text
days left <50-0 – the orange text
days left <0 – the red text

Additional information

FH – the total amount of hours is shown in case flights have flight report

BT – the total amount of hours is shown in case flights have a block time

S – total sectors for result flights

The Quick Search is available by such columns:

Status, Report No, Flight ID, Waypoint srv, Type, Office, Operator, Brokers, Flight No., Route, Customers, Type, CPT, Wp.load, Ch.Cargo, Cargo, Block T, AWB and Cargo weight

Sorting and filtering

Click the “Filters” button and select the necessary field to make the filtration

You have an opportunity to make the filtration by

Types, Office, Operator, Supplier, Customer, Team, Project, Category, Subtype selectors
ID, Crew, Captain, Reg. No. Bulk, Flt. Customer, Customer, AC Type, Report No., Project/Ref/Quote, Brokers, Fit. Brokers input fields

Filtration by the Revenue status (REV column)

ANY – flights with all statuses of revenue will be shown (empty cell/tick/double ticks are shown)
NONE – flights with UnNotify revenue status are shown (the cell in the column is empty)
NOTIFIED – flights with Notified revenue status are shown (one tick
in the column)
CLOSED – flights with Closed revenue status are shown (double tick
in the column)

Filtration by the Expense status (EXP column)

ANY – flights with all statuses of the expense will be shown (empty cell/tick/double ticks are shown)
NONE – flights with UnNotify expense status are shown (the cell in the column is empty)
NOTIFIED – flights with Notified expense status are shown (one tick
in the column)
CLOSED – flights with Closed expense status are shown (double tick
in the column)

Filtration by the Exp allocated (A column)

Any – flights with all expenses condition are shown (empty cell/anchor are shown)
Yes – flights with allocated expense are shown (anchor in the column)
No – flights without allocated expense are shown (the cell in the column is empty)

Filtration by invoiced status (i column)

Yes – flights that have linked jobs will be shown (the icon of coins
)
No – flights that have no linked jobs will be shown (the empty cell)

Filtration by invoice status

Any – all flight will be shown regardless of the invoice status
Not conf. – flights with UnConfirmed revenue are shown
Ready – flights with Confirmed revenue are shown

Sorting with the help of checkboxes

Order by Flight ID – flights will be sorted by the Flight ID column
No attachments – tick to sort flights without attachments
Not follow – tick to sort flights with Not follow checkbox
Closed – tick to sort flights with Operated status
Report confirmed - tick to sort flights with confirmed or checked flight report

Flight has a blue background in case its flight report is confirmed
Flight has a green background in case its flight report is checked

Broken – the list with broken flights will be shown (for example, without date etc.)
With empty legs – tick to sort flights with empty legs
No Schedule – flights without schedule are shown
Deleted – tick to see the list with deleted flights
Crew checked – tick to sort flights with confirmed crew
Report checked – tick to sort flights with checked flight report
Cargo – tick to sort flights with linked AWB

In case you can’t find a filter in the list, please, check permissions on the page.

Additional opportunities

- click the Auto Updates every 5 minutes button to update the flight list automatically

- click the Fight Map to look through the map of the world. Pay attention that the button will be available in case at least one flight is chosen

- click the Flight Report button to open the page with the flight report creation. Pay attention that the button will be available in case at least one flight is chosen

- click the Create Schedule button to open the form of the Schedule/ Trip cloning creation. Pay attention that the button will be available in case at least one flight is chosen

The possibility of quick changes in flight

There is an opportunity to edit the status of Revenue/Expense quicker. Select the necessary flight to make changes and click the Settings button

Revenue

select the Notify option to change the status to the same (one tick
is shown in the REV column)
select the Close option to change the status to the same (double tick
is shown in the REV column)
select the Undo option to change the status to the UnNotify (the cell is empty)

Expense

select the Notify option to change the status to the same (one tick
is shown in the EXP column)
select the Close option to change the status to the same (double tick
is shown in the EXP column)
select the Undo option to change the status to the UnNotify (the cell is empty)

There is an opportunity to change the flight status
- select the necessary flight with the help of tick
- select new status in the Status selector
- click the Set status button
There is an opportunity to change the following for flight
- select the necessary flight with the help of tick
- select the ✓ Follow or - Follow button

How to create the schedule

To create the schedule, select the necessary flight with the help of a tick and click the Create Schedule button
Select the suitable option. It can be:

Schedule

Tick the Clone payload checkbox to create flight with the same payloads, select the period, flight status and weekdays.

Tick the Show Online checkbox in case you need to show the necessary flights in your website.

In case of services in the flight, you have an opportunity to clone them.

Then click the Create Schedule button.

The error message will be shown without marked days of the week.

On date

Tick the Clone payload checkbox to create a flight with the same payloads and select the date. You have an opportunity just to clone the flight, without schedule creation – tick the No Schedule/Clone checkbox. In case of services in the flight, you have an opportunity to clone or move them. Then click the Create Schedule button.