Flight Statuses

In the following diagram as you see the flight (leg) statuses:

Leg level statuses for KLM 

LegStatusPublic Implementation Logic
CANCELLED

FlightCancelledIndicator = Y

or

LegStatus = C

ARRIVED

TypeOfLatestInternal = A

or

Actual is filled

LANDED

TypeOfTouchDown = A

or

TouchDownTime is filled

EARLY_ARRIVAL

Estimated is filled

and

Estimated is before modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

DELAYED_ARRIVAL

Either one of below

  1. Estimated is filled
    and
    Estimated is after modified/scheduled
    and
    minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
  2. Current date time is after
    and
    minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
IN_FLIGHT

TypeOfTakeOff = A

or

ActualTakeOffTime is filled

DEPARTED

TypeOfLatestInternal = A

or

Actual is filled

DELAYED_DEPARTURE

EstimatedPublic is filled

and

EstimatedPublic is after modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

EARLY_DEPARTURE

EstimatedPublic is filled

and

EstimatedPublic is before modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

NEW_EARLY_DEPARTURE_TIME

modified is filled

and

modified is before scheduled

NEW_DEPARTURE_TIME

modified is filled

and

modified is after scheduled

ONTIME default status if none of above is applicable
DIVERTED

when there are 2 legs with the same departure station but different arrival station

and

One of the leg has the status C

 

 

 Flight level statuses for KLM 

FlightStatusPublic Business Rule OR Definition
DIVERTED

Last leg of flight has

LegStatusInternal="DIVERTED"

All other statuses are default.
PARTIALLY_CANCELLED Flight with more than one leg and not all the legs of flight are CANCELLED
CANCELLED

Flight cancelled indicator ="Y" OR All the legs of flight are cancelled.

 

ARRIVED

Last leg of flight has

LegStatusPublic= ''ARRIVED''

LANDED

Last leg of flight has

LegStatusPublic= "LANDED"

EARLY_ARRIVAL

Last leg of flight has

LegStatusPublic= "EARLY_ARRIVAL"

DELAYED_ARRIVAL

Last leg of flight has

LegStatusPublic="DELAYED_ARRIVAL"

IN_FLIGHT

First leg of flight has

LegStatusPublic= "IN_FLIGHT"

DEPARTED

First leg of flight has

LegStatusPublic= "DEPARTED"

DELAYED_DEPARTURE

First leg of flight has

LegStatusPublic= "DELAYED_DEPARTURE"

EARLY_DEPARTURE

First leg of flight has

LegStatusPublic= "EARLY_DEPARTURE"

NEW_EARLY_DEPARTURE_TIME

First leg of flight has

LegStatusPublic="NEW_EARLY_DEPARTURE_TIME"

NEW_DEPARTURE_TIME

First leg of flight has

LegStatusPublic="NEW_DEPARTURE_TIME"

ON_TIME Default status if none of above is applicable

 

Leg level statuses for Air France, A5 and JN

 

LegStatusPublic Implementation Logic
CANCELLED

FlightCancelledIndicator = Y

or

LegStatus = C

ARRIVED

TypeOfLatestInternal = A

or

Actual is filled

LANDED

TypeOfTouchDown = A

or

TouchDownTime is filled

EARLY_ARRIVAL

Estimated is filled

and

Estimated is before modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

DELAYED_ARRIVAL

Either one of below

  1. Estimated is filled
    and
    Estimated is after modified/scheduled
    and
    minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
  2. Current date time is after
    and
    minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
IN_FLIGHT

TypeOfTakeOff = A

or

ActualTakeOffTime is filled

DEPARTED

TypeOfLatestInternal = A

or

Actual is filled

DELAYED_DEPARTURE

EstimatedPublic is filled

and

EstimatedPublic is after modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

EARLY_DEPARTURE

EstimatedPublic is filled

and

EstimatedPublic is before modified/scheduled

and

minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes

NEW_EARLY_DEPARTURE_TIME

modified is filled

and

modified is before scheduled

NEW_DEPARTURE_TIME

modified is filled

and

modified is after scheduled

ON_TIME default status if none of above is applicable
DIVERTED

when there are 2 legs with the same departure station but different arrival station

and

One of the leg has the status C

Flight level statuses for Air France, A5 and JN 

FlightStatusPublic
PARTIALLY_CANCELLED
CANCELLED
ARRIVED
LANDED
EARLY_ARRIVAL
DELAYED_ARRIVAL
IN_FLIGHT
DEPARTED
DELAYED_DEPARTURE
EARLY_DEPARTURE
NEW_EARLY_DEPARTURE_TIME
NEW_DEPARTURE_TIME
DIVERTED
ON_TIME

Docs Navigation