Data field definitions

All data sets that are uploaded to IATA MRO SmartHub will be checked for data validity and consistency. This data quality assurance process ensures that business processes in Connector and data visualization in Evaluator can be provided in the most efficient way. The requirements for data and values to successfully complete the data quality process to upload data to IATA MRO SmartHub are specified in the following.

Generic data type definitions

integer:

The integer type represents only integer numbers: 0, 1, 2, 3, …

number:

The number type represents both integer and floating point numbers: 0, 1, 2.312, 4, …

string:

The string type represents text consisting of character and/or numbers: Example Text 123

boolean:

The boolean type can only contain true or false.

Monetary values, e.g., part prices, mark-ups

Fields that contain monetary values must contain only integer and floating point numbers. Currency signs or names as well as thousand separators are not allowed and will lead to an error.

Correct:

1200.33

Wrong:

$1200 or 1,200

Date fields

When you are using date fields, the following formats are supported by IATA MRO SmartHub for importing and exporting data: YYYY-MM-DD

Manufacturer of parts

The manufacturer of parts should be specified as cage codes. This provides a standardized method of identifying a given supplier and facility at a specific location.

If for Connector listings the cage code is not available, this will be addressed and handled during the on-boarding process. For more information on this subject, please get in touch with IATA MRO SmartHub support.

Condition of parts

The condition for parts in Connector and Evaluator has to contain the two-letter industry standard as a character string. The following table lists the allowed values and description

Condition as two-letter industry standard	Description
NE	New - factory-new parts mostly sold by a manufacturer with no operating time or cycles.
NS	New surplus - new surplus parts are new and have no operating time or cycles. As differentiation to NE, they are not sold directly from the manufacturer. The previous owner was someone who owned the part with the intention to install/use it.
OH	Overhauled - part has been handled as specified in the manufacturer’s instructions for continued airworthiness, or in the data that is approved or accepted by the Authority. For more details, see the appropriate definitions from the authorities, e.g., EASA or FAA.
SV	Serviceable - part fulfills the standard operational requirements which suffice indicated specifications and can be installed as it is.
AR	As removed - part has been removed from an aircraft without a clear specification which tasks are necessary to fulfill operational requirements. This part has to be handled by an certified MRO for testing, repair, or overhaul.
US	Unserviceable - part which cannot be installed in an aircraft and has to be repaired by an certified MRO first.

Unit of Measure

To ensure comparability for listings in Connector and historical data in Evaluator, every combination of part number and manufacturer is assigned to a base unit.

Base units

The base unit serves to make stock on the platform more streamlined. Uploads containing part number / manufacturer combinations with differing base units will either be automatically converted into the base unit or will be rejected if there is no valid conversion of uploaded unit and base unit.

Example: Suppose you try to upload a part with part number “PN1”, manufacturer “MFR1” and unit “boxes” but the base unit for “PN1” on the platform is “each”. The upload will be rejected and return an error saying that there is no possible conversion of the given units. On the other hand, if you try to upload a part with unit “feet” and the base unit is “meters”, the platform will automatically convert the quantity according to the right conversion factors and add the stock to the platform.

Convertible units

Lengths:

feet, inches, meters, yards

Areas:

square feet, square meters

Volumes:

cubic meters, gallons, liters, pints, quarts

Mass:

grams, kilos, metric tons, ounces, pounds

Inconvertible units

boxes, each, packages, per hundred, per thousand, reels, rolls, sets, spools, tubes, pairs

Serial number restrictions

Any unit field is a special case which has restrictions based on the type of measure. Due to the nature of serial numbers, every part number, manufacturer and serial number combination exists only once. Therefore, IATA MRO SmartHub checks uploads containing serial numbers against duplicates of those types. There is an inherent difference between convertible units and inconvertible units and their respective quantity. While parts like cables may have a serial number and a quantity > 1, this cannot happen for inconvertible units such as “boxes” or “each”.

Example: It is not possible to upload part “PN-1234” with serial number “SN001”, manufacturer “MFR001”, quantity 4 and unit “each”, as only one part of that manufacturer can have this serial number, whereas using the same data and unit “meters” would be a valid input.

Therefore, on IATA MRO SmartHub the following two categories of units exist:

Serial number blocked units:

boxes, each, packages, per hundred, per thousand, reels, rolls, sets, spools, tubes, pairs

Serial number free units:

feet, gallons, grams, inches, kilos, liters, meters, ounces, pints, pounds, quarts, square feet, square meters, yards

Location

The location of material, demands, workshop data, transactions, or consignment material is defined as IATA 3-letter-code of closest airport. Only valid 3-letter-codes are accepted. Datasets with any other values will be rejected. An overview of all IATA codes can be found here: List of airport codes