Document
eSubmit Record formats for Directive
ICR 201609-2139-001 · OMB 2139-0013 · Object 71241401.
This document may belong to an older filing. More recent activity for OMB 2139-0013:
Document Viewer [doc]
Document Metadata
| File Type | application/msword |
|---|---|
| File Title | eSubmit Record formats for Directive |
| Author | marianne.seguin |
| Last Modified By | Writer |
| File Modified | 2017-02-02 |
| File Created | 2026-08-25 |
| Conversion State | complete |
Extracted Text
PART 241 – Passenger Origin-Destination Survey Report OMB NO: 2139-0001 EXPIRATION DATE: 2/28/2017 Paperwork Reduction Act Burden Statement A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2139-0001. Public reporting for this collection of information is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, James Bouse, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – [email protected]. REQUIREMENTS RECORD DESCRIPTION: Origin-Destination Survey Report – U.S. Carriers Field Description Data Type Length Comments Sample Data Carrier code Character 2 IATA code XX Year Numeric 3 Date: YYQ Where ‘09’ = Year: 2009 Quarter: 4 094 Fare Numeric variable Value of the ticket in whole U.S. dollars($) 4913 Passenger Count Numeric variable 3 1st Airport Code Character 3 1st Airport Code is the 3 letter code for the first Origin airport BOS 1st Operating Carrier Character 2 IATA Carrier Code IO 1st Ticketed Carrier Character 2 IATA Carrier Code XX 1st Fare Basis Code Character 1 C - Unrestricted Business Class D - Restricted Business Class F - Unrestricted First Class G - Restricted First Class X - Restricted Coach Y - Unrestricted Coach U - Unknown G 2nd Airport Code Character 3 2nd Airport Code is the 3 letter code for the first destination airport LAX 2nd Operating Carrier Character 2 VA 2nd Ticketed Carrier Character 2 VA 2nd Fare Basis Code Character 1 G 3rd Airport Code 3rd Airport Code is the 3 letter code for the second destination airport SYD 3rd Operating Carrier Character 2 Surface Segment Indicator – for Operating Carrier. -- 3rd Ticketed Carrier Character 2 Surface Segment Indicator – for Ticketed Carrier -- 3rd Fare Basis Code Character 1 For surface travel segment, leave the Fare Basis Code blank 4th Airport Code Character 3 4th Airport Code is the 3 letter code for the third destination airport CNS 4th Operating Carrier Character 2 DJ 4th Ticketed Carrier Character 2 VA 4th Fare Basis Code Character 1 G 5th Airport Code Character 3 5th Airport Code is the 3 letter code for the fourth destination airport BNE 5th Operating Carrier Character 2 VA 5th Ticketed Carrier Character 2 VA 5th Fare Basis Code Character 1 G 6th Airport Code Character 3 6th Airport Code is the 3 letter code for the fifth destination airport LAX 6th Operating Carrier Character 2 IO 6th Ticketed Carrier Character 2 IO 6th Fare Basis Code Character 1 G 7th Airport Code Character 3 7th Airport Code is the 3 letter code for the sixth destination airport. BOS 7th Operating Carrier Character 2 OH 7th Ticketed Carrier Character 2 DL 7th Fare Basis Code Character 1 G 8th Airport Code Character 3 8th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticket DCA 8th Operating Carrier Character 2 If 23 coupons have to be recorded, then the format continues as follows: EV 8th Ticketed Carrier Character 2 DL 8th Fare Basis Code Character 1 X 9th Airport Code Character 3 9th Airport Code is the 3 letter code for the eight destination airport, and in this example, the final destination for this ticket CLT 9th Operating Carrier Character 2 YV 9th Ticketed Carrier Character 2 YV 9th Fare Basis Code Character 1 X 10th Airport Code Character 3 10th Airport Code is the 3 letter code for the ninth destination airport, and in this example, the final destination for this ticket ATL 10th Operating Carrier Character 2 FL 10th Ticketed Carrier Character 2 FL 10th Fare Basis Code Character 1 Y 11th Airport Code Character 3 11th Airport Code is the 3 letter code for the tenth destination airport, and in this example, the final destination for this ticket MIA 11th Operating Carrier Character 2 MQ 11th Ticketed Carrier Character 2 AA 11th Fare Basis Code Character 1 G 12th Airport Code Character 3 12th Airport Code is the 3 letter code for the eleventh destination airport, and in this example, the final destination for this ticket FLL 12th Operating Carrier Character 2 NK 12th Ticketed Carrier Character 2 NK 12th Fare Basis Code Character 1 X 13th Airport Code Character 3 13th Airport Code is the 3 letter code for the twelfth destination airport, and in this example, the final destination for this ticket FMY 13th Operating Carrier Character 2 NK 13th Ticketed Carrier Character 2 NK 13th Fare Basis Code Character 1 X 14th Airport Code Character 3 14th Airport Code is the 3 letter code for the thirteenth destination airport, and in this example, the final destination for this ticket ATL 14th Operating Carrier Character 2 EV 14th Ticketed Carrier Character 2 DL 14th Fare Basis Code Character 1 Y 15th Airport Code Character 3 15th Airport Code is the 3 letter code for the fourteenth destination airport, and in this example, the final destination for this ticket LAS 15th Operating Carrier Character 2 SY 15th Ticketed Carrier Character 2 SY 15th Fare Basis Code Character 1 Y 16th Airport Code Character 3 16th Airport Code is the 3 letter code for the fifteenth destination airport, and in this example, the final destination for this ticket SAN 16th Operating Carrier Character 2 XE 16th Ticketed Carrier Character 2 CO 16th Fare Basis Code Character 1 y 17th Airport Code Character 3 17th Airport Code is the 3 letter code for the sixteenth destination airport, and in this example, the final destination for this ticket MEX 17th Operating Carrier Character 2 AM 17th Ticketed Character 2 MX 17th Fare Basis Code Character 1 Y 18th Airport Code Character 3 18th Airport Code is the 3 letter code for the seventeenth destination airport, and in this example, the final destination for this ticket LIM 18th Operating Carrier Character 2 AA 18th Ticketed Carrier Character 2 AA 18th Fare Basis Code Character 1 y 19th Airport Code Character 3 19th Airport Code is the 3 letter code for the eighteenth destination airport, and in this example, the final destination for this ticket MEX 19th Operating Carrier Character 2 MX 19th Ticketed Carrier Character 2 MX 19th Fare Basis Code Character 1 Y 20th Airport Code Character 3 20th Airport Code is the 3 letter code for the nineteenth destination airport, and in this example, the final destination for this ticket LAX 20th Operating Carrier Character 2 AA 20th Ticketed Carrier Character 2 AA 20th Fare Basis Code Character 1 G 21th Airport Code Character 3 21th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticket PDX 21th Operating Carrier Character 2 QX 21th Ticketed Carrier Character 2 AS 21th Fare Basis Code Character 1 G 22nd Airport Code Character 3 22nd Airport Code is the 3 letter code for the twenty-first destination airport, and in this example, the final destination for this ticket ANC 22nd Operating Carrier Character 2 NW 22nd Ticketed Carrier Character 2 AS 22nd Fare Basis Code Character 1 Y 23rdrd Airport Code Character 3 23rd Airport Code is the 3 letter code for the twenty-second destination airport, and in this example, the final destination for this ticket BNE 23rd Operating Carrier Character 2 VA 23rd Ticketed Carrier Character 2 VA 23rd Fare Basis Code Character 1 G 24th Airport Code Character 3 24th Airport Code is the 3 letter code for the twenty-third destination airport, and in this example, the final destination for this ticket SYD RECORD FORMAT: The Origin-Destination Survey reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application. The comma separated values file MUST BE indicated when naming the file with file extension [CSV] or [csv] following the file name. The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet. The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv. Suggested file name: XX201003-OND.csv Sample Record Format: XX,94,4913,1,BOS,IO,XX,G,LAX,VA,VA,G,SYD,--,--,,CNS,DJ,VA,G,BNE,VA,VA,G,LAX,IO,IO,G,BOS NOTE: The second itinerary in the sample record format above indicates a surface segment between SYD and CNS. The --,--, , indicate the positions the two carriers and fare code would have occupied had there been air transportation between the two airports. PART 241 – Passenger Origin-Destination Survey Report OMB NO: 2139-0001 EXPIRATION DATE: 2/28/2017 Paperwork Reduction Act Burden Statement A federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act unless that collection of information displays a current valid OMB Control Number. The OMB Control Number for this information collection is 2139-0001. Public reporting for this collection of information is estimated to be approximately 7 hours per response, including the time for reviewing instructions, completing and reviewing the collection of information. All responses to this collection of information are mandatory, as authorized by 14 CFR, Part 241. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, James Bouse, OAI/BTS/OST-R, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – [email protected]. REQUIREMENTS RECORD DESCRIPTION: Origin-Destination Survey Report – Foreign Carriers Field Description Data Type Length Comments Sample Data Carrier code Character 2 IATA code XX Year Numeric 3 Date: YYQ Where ‘09’ = Year: 2009 Quarter: 4 094 Fare Numeric variable Value of the ticket in whole U.S. dollars($) 1234 Passenger Count Numeric variable 3 1st Airport Code Character 3 1st Airport Code is the 3 letter code for the first Origin airport BOS 1st Operating Carrier Character 2 IATA Carrier Code IO 1st Ticketed Carrier Character 2 IATA Carrier Code XX 1st Fare Basis Code Character 1 C - Unrestricted Business Class D - Restricted Business Class F - Unrestricted First Class G - Restricted First Class X - Restricted Coach Y - Unrestricted Coach U - Unknown G 2nd Airport Code Character 3 2nd Airport Code is the 3 letter code for the first destination airport LAX 2nd Operating Carrier Character 2 VA 2nd Ticketed Carrier Character 2 VA 2nd Fare Basis Code Character 1 G 3rd Airport Code 3rd Airport Code is the 3 letter code for the second destination airport SYD 3rd Operating Carrier Character 2 Surface Segment Indicator – for Operating Carrier. -- 3rd Ticketed Carrier Character 2 Surface Segment Indicator – for Ticketed Carrier -- 3rd Fare Basis Code Character 1 For surface travel segment 4th Airport Code Character 3 4th Airport Code is the 3 letter code for the third destination airport CNS 4th Operating Carrier Character 2 DJ 4th Ticketed Carrier Character 2 VA 4th Fare Basis Code Character 1 G 5th Airport Code Character 3 5th Airport Code is the 3 letter code for the fourth destination airport BNE 5th Operating Carrier Character 2 VA 5th Ticketed Carrier Character 2 VA 5th Fare Basis Code Character 1 G 6th Airport Code Character 3 6th Airport Code is the 3 letter code for the fifth destination airport LAX 6th Operating Carrier Character 2 IO 6th Ticketed Carrier Character 2 IO 6th Fare Basis Code Character 1 G 7th Airport Code Character 3 7th Airport Code is the 3 letter code for the sixth destination airport and in this example, the final destination for this ticket BOS 8th Airport Code Character 3 8th Airport Code is the 3 letter code for the seventh destination airport, and in this example, the final destination for this ticket DCA 8th Operating Carrier Character 2 If 23 coupons have to be recorded, then the format continues as follows: EV 8th Ticketed Carrier Character 2 DL 8th Fare Basis Code Character 1 X 9th Airport Code Character 3 9th Airport Code is the 3 letter code for the eight destination airport, and in this example, the final destination for this ticket CLT 9th Operating Carrier Character 2 YV 9th Ticketed Carrier Character 2 YV 9th Fare Basis Code Character 1 X 10th Airport Code Character 3 10th Airport Code is the 3 letter code for the ninth destination airport, and in this example, the final destination for this ticket ATL 10th Operating Carrier Character 2 FL 10th Ticketed Carrier Character 2 FL 10th Fare Basis Code Character 1 Y 11th Airport Code Character 3 11th Airport Code is the 3 letter code for the tenth destination airport, and in this example, the final destination for this ticket MIA 11th Operating Carrier Character 2 MQ 11th Ticketed Carrier Character 2 AA 11th Fare Basis Code Character 1 G 12th Airport Code Character 3 12th Airport Code is the 3 letter code for the eleventh destination airport, and in this example, the final destination for this ticket FLL 12th Operating Carrier Character 2 NK 12th Ticketed Carrier Character 2 NK 12th Fare Basis Code Character 1 X 13th Airport Code Character 3 13th Airport Code is the 3 letter code for the twelfth destination airport, and in this example, the final destination for this ticket FMY 13th Operating Carrier Character 2 NK 13th Ticketed Carrier Character 2 NK 13th Fare Basis Code Character 1 X 14th Airport Code Character 3 14th Airport Code is the 3 letter code for the thirteenth destination airport, and in this example, the final destination for this ticket ATL 14th Operating Carrier Character 2 EV 14th Ticketed Carrier Character 2 DL 14th Fare Basis Code Character 1 Y 15th Airport Code Character 3 15th Airport Code is the 3 letter code for the fourteenth destination airport, and in this example, the final destination for this ticket LAS 15th Operating Carrier Character 2 SY 15th Ticketed Carrier Character 2 SY 15th Fare Basis Code Character 1 Y 16th Airport Code Character 3 16th Airport Code is the 3 letter code for the fifteenth destination airport, and in this example, the final destination for this ticket SAN 16th Operating Carrier Character 2 XE 16th Ticketed Carrier Character 2 CO 16th Fare Basis Code Character 1 y 17th Airport Code Character 3 17th Airport Code is the 3 letter code for the sixteenth destination airport, and in this example, the final destination for this ticket MEX 17th Operating Carrier Character 2 AM 17th Ticketed Character 2 MX 17th Fare Basis Code Character 1 Y 18th Airport Code Character 3 18th Airport Code is the 3 letter code for the seventeenth destination airport, and in this example, the final destination for this ticket LIM 18th Operating Carrier Character 2 AA 18th Ticketed Carrier Character 2 AA 18th Fare Basis Code Character 1 y 19th Airport Code Character 3 19th Airport Code is the 3 letter code for the eighteenth destination airport, and in this example, the final destination for this ticket MEX 19th Operating Carrier Character 2 MX 19th Ticketed Carrier Character 2 MX 19th Fare Basis Code Character 1 Y 20th Airport Code Character 3 20th Airport Code is the 3 letter code for the nineteenth destination airport, and in this example, the final destination for this ticket LAX 20th Operating Carrier Character 2 AA 20th Ticketed Carrier Character 2 AA 20th Fare Basis Code Character 1 G 21th Airport Code Character 3 21th Airport Code is the 3 letter code for the twentieth destination airport, and in this example, the final destination for this ticket PDX 21th Operating Carrier Character 2 QX 21th Ticketed Carrier Character 2 AS 21th Fare Basis Code Character 1 G 22nd Airport Code Character 3 22nd Airport Code is the 3 letter code for the twenty-first destination airport, and in this example, the final destination for this ticket ANC 22nd Operating Carrier Character 2 NW 22nd Ticketed Carrier Character 2 AS 22nd Fare Basis Code Character 1 Y 23rdrd Airport Code Character 3 23rd Airport Code is the 3 letter code for the twenty-second destination airport, and in this example, the final destination for this ticket BNE 23rd Operating Carrier Character 2 VA 23rd Ticketed Carrier Character 2 VA 23rd Fare Basis Code Character 1 G 24th Airport Code Character 3 24th Airport Code is the 3 letter code for the twenty-third destination airport, and in this example, the final destination for this ticket SYD RECORD FORMAT: The Origin-Destination Survey reports must be created as an electronic “comma separated values” file, using ASCII text character encoding, for uploading via the “eSubmit” application. The comma separated values file MUST BE indicated when naming the file with file extension [CSV] or [csv] following the file name. The file name is flexible and may be determined by the individual air carrier, but the comma separated values (csv) file format is required, as outlined in the rule entitled, Submitting Airline Data via the Internet. The fields in the sample record shown below follow the same order as the above record description, separated by commas, and saved with the file name extension of .csv. Suggested file name: XX201003-FOND.csv Sample Record Format: XX,94,1234,1,BOS,IO,XX,G,LAX,VA,VA,G,SYD,--,--,,CNS,DJ,VA,G,BNE,VA,VA,G,LAX,IO,IO,G,BOS NOTE: The second itinerary in the sample record format above indicates a surface segment between SYD and CNS. The --,--, , indicate the positions where the ticketing carrier, the operating carrier, and the fare basis code information would have been entered had there been air transportation between the two airports.