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 |
|