Chapter 6: Business Rules

Business Rules - Segment Data

In preparation for the validation process, the segment data, that is reported by the carriers, is reformatted and tab-delimited when copied to OAI’s WORK directory.

Excel | CSV

¹ The Aircraft field is a four (4) digit field, the first three (3) digits are the Aircraft Type and last one is the Cabin Configuration.

Segment Data Checks:

1) DATA TYPE (SCHEDULE CODE IS INCORRECT)

If the schedule field is not = 'S'

2) CARRIER ENTITY CODE IS NOT ON CARRIER DECODE FILE

If the Entity Code doesn’t exist in the CARDECODE table, or doesn’t match the entry in the CARDECODE table for the given Carrier Code, Year and Month

3) DATE IS NOT EQUAL TO CONTROL DATE OR IS NOT NUMERIC

If the date in the row doesn’t match the year and month being processed

4) AIRPORT IS EITHER NOT ALPHABETIC OR NOT ON OAG-NAMES FILE

If either the Origin or Destination airports are not in the Airports table

5) SERVICE CLASS IS NOT ON SERVICE CLASS FILE

If the Service Class field is not one of F, G, L, P, N, R, Q

6) AIRCRAFT TYPE IS INVALID

If the Aircraft Type (the first three digits in the Aircraft field) doesn’t exist in the ACTYPE table

7) FIELD IS NONNUMERIC OR CONTAINS AN INVALID NUMBER

If the field, defined as numeric, contains a nonnumeric or negative number

8) AVAILABLE CAPACITY LESS THAN WEIGHT TRANSPORTED

If Available capacity payload < Total Carried

Total Carried = (Revenue Passengers Enplaned + Revenue Passengers Enplaned - First Class + Revenue Passengers Enplaned - Coach Class) * 200) + Revenue Freight Transported + Revenue Mail Transported

9) TRANSPORTED PASSENGERS EXCEEDS AVAILALBE SEATS FOR CLASS

IF Service Class is 'F' OR ‘L’
AND
Revenue Passengers Enplaned > Available Passengers
OR
Revenue Passengers Enplaned - First Class > Available Passengers - First Class
OR
Revenue Passengers Enplaned - Coach Class > Available Passengers - Coach Class

10) AIRCRAFT HOURS RAMP TO RAMP NOT GREATER THAN AIRBORNE

If Revenue Hours - Airborne is greater than Revenue Hours - Ramp

11) SERVICE CLASS AND CABIN CONFIGURATION DO NOT AGREE

If CabinConf is ‘1’ OR ‘3’ AND (Service Class is 'P' OR ‘Q’)
OR
If Cabin Configuration is greater than ‘4’ OR is equal to ‘0’

12) THERE IS PASSENGER INFORMATION IN AN ALL CARGO FLIGHT

If Total Passengers IS GREATER THAN ‘0’ AND Service Class is G, P, or Q
Total Passengers = Revenue Passengers Enplaned + Revenue Passengers Enplaned - First Class + Revenue Passengers Enplaned - Coach Class

13) CARGO FLIGHT HAS NO FREIGHT OR MAIL TRANSPORTED

If Total Freight IS ‘0’ AND Service Class is G, P, or Q
Total Freight = Revenue Freight Transported + Revenue Mail Transported

14) REPORTED CAPACITY OF AIRCRAFT EXCEEDS VALUES FOR TYPE

Capacity exceeds the maximum value obtained from the Aircraft Type table (ACTYPE)

15) TRANSPORTED WEIGHT EXCEEDS AVAILABLE CAPACITY

If Total Carried > Available capacity payload

Total Carried = (Revenue Passengers Enplaned + Revenue Passengers Enplaned - First Class + Revenue Passengers Enplaned - Coach Class) * 200) + Revenue Freight Transported + Revenue Mail Transported

16) PASSENGER SERVICE CLASS AND AIRCRAFT CABIN CONF. DO NOT AGREE

If the Service Class is F (Passenger), the Cabin Conf cannot be 2

17) AVAILABLE SEATS EQUALS ZERO FOR PASSENGER FLIGHT

For Service Class F, Available Seats cannot be zero.

18) TRANSPORTED PASSENGERS EQUALS ZERO FOR PASSENGER FLIGHT

For Service Class F, Transported Passengers cannot be zero.

19) CALCULATED AVAILABLE SEATS OUTSIDE OF TABLE VALUES

Available Seats / # of Departures is outside the range provided in the Aircraft Type table (ACTYPE)

20) CALCULATED AIRCRAFT SPEED OUTSIDE OF TABLE VALUES

If Speed is 125% GREATER THAN the speed in the ACTYPE table

If Revenue Hours - Airborne IS EQUAL TO 0  OR
Rev. Departures performed IS EQUAL TO 0
THEN Speed = 0
ELSE
Speed = Distance/ (Revenue Hours Airborne / (60 * Rev. Departures performed)) # Distance / Airborne Min.

21) MORE THAN 1 VALID ENTRIES FOR AIRPORT

In the Airports table, there is more than 1 valid entry for a given airport.

22) SERVICE CLASS = F/L AND CONFIG = "2" CANNOT SELL MORE THAN 1 SEAT

If Service Class F/L and Cabin Configuration "2", #PAX must be less than or equal #Departures

Business Rules - Market Data

In preparation for the validation process, the market data, that is reported by the carriers, is reformatted and tab-delimited when copied to OAI’s WORK directory.

Excel | CSV

Market Data Checks:

1) DATA TYPE (SCHEDULE CODE IS INCORRECT)

If the schedule field is not = 'M'

2) CARRIER ENTITY CODE IS NOT ON CARRIER DECODE FILE

If the EntityCode doesn’t exist in the Cardecode table, or doesn’t match the entry in Cardecode for the given Carrier Code, Year and Month

3) DATE IS NOT EQUAL TO CONTROL DATE OR IS NOT NUMERIC

If the date in the row doesn’t match the year and month being processed

4) AIRPORT IS EITHER NOT ALPHABETIC OR NOT ON OAG-NAMES FILE

If either the Origin or Destination airports are not in the Airports table

5) SERVICE CLASS IS NOT ON SERVICE CLASS FILE

IF the ServiceClass field is not one of F, L, G, P, Q

6) FIELD IS NONNUMERIC OR CONTAINS AN INVALID NUMBER

If the field contains a negative number

7) THERE IS PASSENGER INFORMATION IN AN ALL CARGO FLIGHT

If Total Passengers IS GREATER THAN ‘0’ AND Service Class is G, P, or Q

Total Passengers = Passengers in Market + Passengers in Market - First Class + Passengers in Market - Coach Class

8) CARGO FLIGHT HAS NO FREIGHT OR MAIL TRANSPORTED

If Total Freight IS ‘0’ AND Service Class is G, P, or Q
Total Freight = Freight in Market + Mail in Market

9) ENPLANED PASSENGERS EQUALS ZERO FOR PASSENGER FLIGHT

For Service Class F, the Enplaned Passengers cannot be zero.