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
- Estimated is filled
and Estimated is after modified/scheduled and minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
- 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
- Estimated is filled
and Estimated is after modified/scheduled and minutes betweeen modified/scheduled and Estimatedpublic is greater then 10 minutes
- 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 |
|