Please enable JavaScript.
Coggle requires JavaScript to display documents.
OD and Revenue Attributes (Trip OD Attibutes (Verify if the Trip OD Main…
OD and Revenue Attributes
POO Attributes
3) Verify the value in the EKPOO operating
4) Verify the NULL values
2) Verify the value in the EK POO
5) Verify the value in the EKPOO marketing
1) Verify the value in the POO column
Trip OD Attibutes
Verify if the
Trip OD Main Operating Carrier
is the Operating Carrier of the sector whose GCD is the longest in the entire Trip Itinerary - exclude all the cancelled segments
Verify if the
Trip OD Longest Marketing Carrier
is identified as the one which forms the longest GCD based on the Sum of the consecutive sectors in the Trip itinerary - excluding all cancelled segments
Verify if the
Trip OD Main marketing Carrier
is the Marketing Carrier of the sector whose GCD is the longest in the entire Trip Itinerary- exclude all the cancelled segments
Verify if the
Trip OD Longest Operating Carrier
is identified as the one which forms the longest GCD based on the Sum of the consecutive sectors in the Trip itinerary - excluding all cancelled segments
Verify if the
Trip OD Date
is the first Departure Date (flight_loc_date) among the active segments in a PNR
Verify if the
Trip OD Pax Count
is set to 1 for the first segment in a Trip itinerary and the rest of the coupons are set to 0
Verify if the
Trip OD Main Cabin Class
is the EK Cabin that corresponds to the sector having the longest GCD in the complete Trip itinerary - excluding all cancelled segments
Verify if the
Trip OD Mix Cabin Flag
is set to Y if the Trip itinerary has multiple combination of cabin classes (F/J/Y)
Verify if the
Trip OD Cabin Class
is set to a string containing the different Cabin Classes in a Trip Itinerary (F, J, Y, F/J, F/Y, F/J/Y, etc.... )
Verify the order of the
Trip OD Cabin Class
- if it is from the highest to the lowest
Verify if the
EK Freedom Type - 3, 4, 5, 6
are set based on the given conditions
Verify OD Attributes are set to null in case of
Inactive coupons
Domestic Itineraries
True OD Attributes
Verification of the
True OD Longest Oper Carr.
based on the True OD Itinerary and True OD
Verification of the
True OD Pax Count
based on the True OD Itinerary
Verification of the
True OD Longest Mktg Carr.
based on the True OD Itinerary and True OD
Verification of the
True OD Main Cabin Class
based on the True OD Itinerary
Verification of the
True OD Operating Carrier
based on the True OD Itinerary and True OD
Verification of the
True OD Mix Cabin Flag
based on the True OD Itinerary
Verification of the
True OD Marketing Carrier
based on the True OD Itinerary and True OD
Verification of the
EK Mktg and EK Operating Flags
based on EK Carrier in each true OD Itinerary
Verification of
True OD Date
based on the True OD Itn
Verification of the
EK Freedom Type - 3, 4, 5 and 6
based on True OD Itinerary
Verification of True OD attributes to be
NULL
where aircraft Type is null (or) for Itinerary with Domestic Sector (or) for inactive coupons
Revenue Attributes
TRIP/TRUE OD Fare Amount (AED and USD)
TRIP/TRUE OD Global Industry Average Fare (USD and AED)
TRIP/TRUE OD RPKM