Søgning » Hændelsesdatabase for Luftfart » Entity_Part_Information
Tabel

Entity_Part_Information


Beskrivelse ?

Detailed information on specific aircraft parts, e.g. emanating from maintenance organisations.

Størrelse (Antal rækker) ?

32

Indhold (Kolonner/variable) ?

Navn Indhold
OID OID (database unique ID) - numeric datatype A single column containing a database-unique identifier. It is this identifier which is actually used to link all the records in all the tables to the same Occurrence.
ID ID (Instance ID) This is the instance ID in this table.
A485 Part name
A486 Part number - Component
A657 Serial number
A658 Manufacturer
A659 ATA chapter number
A660 Time since new, specified in hours
A661 Time since overhaul, specified in hours
A662 Time since inspection, specified in hours
A663 Cycles since new
A664 Cycles since overhaul
A665 Cycles since insp
A666 Date of manufacturing
A667 Date of overhaul
A668 Date repair/insp
A670 Monitoring sys funct
A658_T Extension to Manufacturer of the part, text
A659_T Extension to ATA chapter number of the part involved, text
A658_1 Extension to Manufacturer of the part, part 1
A659_1 Extension to ATA chapter number of the part involved, part 1
A659_2 Extension to ATA chapter number of the part involved, part 2
A659_3 Extension to ATA chapter number of the part involved, part 3
A659_4 Extension to ATA chapter number of the part involved, part 4
A659_5 Extension to ATA chapter number of the part involved, part 5
A659_6 Extension to ATA chapter number of the part involved, part 6
A670_1 Extension to Part - Monitoring system functioning, part 1
A658_1_Translate Translation of the code-value in A658_1 column.
A658_Translate Translation of the code-value in A658 column.
A659_1_Translate Translation of the code-value in A659_1 column.
A659_2_Translate Translation of the code-value in A659_2 column.
A659_3_Translate Translation of the code-value in A659_3 column.
A659_Translate Translation of the code-value in A659 column.
A659_4_Translate Translation of the code-value in A659_4 column.
A659_5_Translate Translation of the code-value in A659_5 column.
A670_1_Translate Translation of the code-value in A670_1 column.
A670_Translate Translation of the code-value in A670 column.