Chapter 4: Data Validation

The Airline Reporting & Data Information System

The Office of Airline Information (OAI) receives over 165 individual T100 submissions from reporting carriers each month.� The data is entered into the "Airline Reporting and Data Information System (ARDIS) where it is validated. OAI reviews the T100 validation reports for any problems. OAI contacts the carriers when reporting problems are found.� Some minor errors are corrected by OAI - with the approval of the carrier- such as reporting dates and airport codes. �For those reports where the errors are not minor, a more extensive review by the carrier is required.� It is then that OAI will ask a carrier for a re-submission of the entire report. OAI is always available to offer assistance to carriers who are unsure about the reporting requirements.

Monthly and quarterly, OAI uses the T100 data, to generate various products that are distributed to other government agencies, and subscribers of the data. The data is also made available to the general public, over the internet at www.transtats.bts.gov.

T100 Traffic Reporting System Flowchart

ARDIS: T100 Traffic Reporting System

Large, Small, Commuter and All-Cargo Aircrafts

Error Messages for Non-Stop Segment Data

The "No. of Error Records" shown on the sample Non-Stop Segment data validation report on the next page, is derived from the following list of edit checks.� These checks are performed on every non-stop segment record.� If one of these checks fails, a record is printed out with the error code printed above the corresponding data field.� It does not necessarily mean that there is an error, but that individual attention must be given to this item to determine is any action is required.

1. RECORD TYPE (SCHEDULE CODE IS INCORRECT)
2. CARRIER ENTITY CODE IS NOT ON CARRIER DECODE FILE
3. DATE IS NOT EQUAL TO CONTROL DATE OR IS NOT NUMERIC
4. AIRPORT IS EITHER NOT ALPHABETIC OR NOT ON OAG-NAMES FILE
5. SERVICE CLASS IS NOT ON SERVICE CLASS FILE
6. AIRCRAFT TYPE IS INVALID
7. FIELD IS NONNUMERIC OR CONTAINS AN INVALID NUMBER
8. AVAILABLE CAPACITY LESS THAN WEIGHT TRANSPORTED
9. TRANSPORTED PASSENGERS EXCEEDS AVAILABLE SEATS FOR CLASS
10. AIRCRAFT HOURS RAMP TO RAMP NOT GREATER THAN AIRBORNE
11. SERVICE CLASS AND CABIN CONFIGURATION DO NOT AGREE
12. THERE IS PASSENGER INFORMATION IN AN ALL CARGO FLIGHT
13. CARGO FLIGHT HAS NO FREIGHT OR MAIL TRANSPORTED
14. REPORTED CAPACITY OF AIRCRAFT EXCEEDS VALUES FOR TYPE
15. TRANSPORTED WEIGHT EXCEEDS AVAILABLE CAPACITY
16. PASSENGER SERVICE CLASS AND AIRCRAFT CABIN CONFIGURATION DO NOT AGREE
17. AVAILABLE SEATS EQUALS ZERO FOR PASSENGER FLIGHT
18. TRANSPORTED PASSENGERS EQUALS ZERO FOR PASSENGER FLIGHT
19. CALCULATED AVAILABLE SEATS OUTSIDE OF TABLE VALUES
20. CALCULATED AIRCRAFT SPEED OUTSIDE OF TABLE VALUES
21. MORE THAN 1 VALID ENTRY FOR AIRPORT22�� SERVICE CLASS = F/L AND CONFIG = "2" CANNOT SELL MORE THAN 1 SEAT

Sample Validation Report for Non-Stop Segment Data

Segment Report

No. of Records: 409

No. of Error Records: 23

Excel | CSV

Error Messages for On-Flight Market Data

The "No. of Error Records" shown on the sample On-Flight Market data validation report here below, is derived from the following list of edit checks.� These checks are performed on every on-flight market record.� If one of these checks fails, a record is printed out with the error code printed above the corresponding data field.� It does not necessarily mean that there is an error, but that individual attention must be given to this item to determine is any action is required.

1. RECORD TYPE (SCHEDULE CODE IS INCORRECT)
2. CARRIER ENTITY CODE IS NOT ON CARRIER DECODE FILE
3. DATE IS NOT EQUAL TO CONTROL DATE OR IS NOT NUMERIC
4. AIRPORT IS EITHER NOT ALPHABETIC OR NOT ON OAG-NAMES FILE
5. SERVICE CLASS IS NOT ON SERVICE CLASS FILE
6. FIELD IS NONNUMERIC OR CONTAINS AN INVALID NUMBER
7. THERE IS PASSENGER INFORMATION IN AN ALL CARGO FLIGHT
8. CARGO FLIGHT HAS NO FREIGHT OR MAIL TRANSPORTED
9. ENPLANED PASSENGERS EQUALS ZERO FOR PASSENGER FLIGHT

Sample Validation Report for On-Flight Market Data

Market Report

No. of Records: 303

No. of Error Records: 3

Excel | CSV

Please Note: ZZZ airport code can be used by any carrier with a non-scheduled service class; L, P; at an undefined point.