d o t logoUnited States Department of Transportation

  OST-R > BTS
ESubmit User Guide Report Formats Manage Profile Contact OAI FAQ Log Out

FORM 41 FINANCIAL DATA P-10 – Employee Statistics by Labor Category

PDF

OMB NO: 2138-0013

EXPIRATION DATE: 11/30/2021

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 2138-0013. Public reporting for Schedule P-10, Employment Statistics by Labor Category, is estimated to be approximately 2 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, Jeff Gorham, OAI/BTS, RTS-42, Room E34, 1200 New Jersey Avenue, SE, Washington, D.C. 20590 or e-mail – jeff.gorham@dot.gov.

REQUIREMENTS

RECORD DESCRIPTION: P-10 – Employee Statistics by Labor Category Report - Group I+, II & III

Field Description Data Type Length Comments Sample Data
Schedule Item Character 4 P100
Carrier Code Character 3 3Z
Entity Region Character 1 D
Aircraft Type Character 4 (P-5.1, P-5.2) 0000
Account Code Character 5 0014A, 10100
Frequency Numeric 1 1, 2, 3 or 4 see below 2
Year Character 4 ccyy 2010
Month Character 2 12
Gain or Loss Numeric --- 2282243, -5645


RECORD FORMAT:

The P-10 – Employee Statistics by Labor Category 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, by using the letters [CSV] or [csv] following the file name, as the file name extension.

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-F41-P-10.csv

Sample Record Format:

P100,3Z,D,0000,00310,4,2010,12,31

Frequency definitions:

1 = monthly filing
2 = quarterly filing
3 = semi-annual filing
4 = annual filing