曝光臺 注意防騙 網曝天貓店富美金盛家居專營店坑蒙拐騙欺詐消費者

• Group aircraft with the same make (or manufacturer) before looking at aircraft models.
• If the source system uses codes, use the decodes to perform the initial linking to the
valid values; however always maintain the reference to the source system code. An
example of source system data appears below:
Code (if
applicable)
Make and/or Manufacturer Model
123 Airbus Industrie A300B2-1C
ABC A.Schleicher Gmbh&Co ASK14
XYZ Reims Aviation S.A. Cessna FR172K
985 Piper Aircraft Corp. PA 28-181
1. Create data elements to hold the new CICTT aircraft valid values
LEGACY SYSTEM CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master Series Series
123 Airbus Industrie A300B2-1C
ABC A.Schleicher
Gmbh&Co
ASK14
XYZ Reims Aviation
S.A.
Cessna
FR172K
985 Piper Aircraft
Corp.
PA 28-181
2. Group aircraft from the legacy data with similar manufacturer/make names. For
example, find every spelling of “Cessna” and group it together.
LEGACY SYSTEM CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master
Series
Series
XY2 CESSNA 172F
CESSNA
AIRCRAFT
172 G
XYZ Reims
Aviation S.A.
Cessna FR172K
CESSNA
AIRCRAFT
CO
CESSNA 172E
CESSNA
AIRCRAFT
COMPANY
CESSNA 337 A
CESSNB Cessna 340A
CESSNA INC
WICHITA
KANSAS USA
C340
5
3. Populate the CICTT aircraft valid values for aircraft manufacturer and aircraft make. For
example, add the CICTT manufacturer and CICTT aircraft make “CESSNA” to aircraft
with every possible spelling of Cessna (At this point do not be concerned if matches
include some non-Cessna aircraft or Cessna aircraft manufactured by Reims.)
LEGACY SYSTEM CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master
Series
Series
XY2 CESSNA 172F CESSNA CESSNA
CESSNA
AIRCRAFT
172 G CESSNA CESSNA
XYZ Reims
Aviation S.A.
Cessna FR172K CESSNA CESSNA
CESSNA
AIRCRAFT
CO
CESSNA 172E CESSNA CESSNA
CESSNA
AIRCRAFT
COMPANY
CESSNA 337 A CESSNA CESSNA
CESSNB Cessna 340A CESSNA CESSNA
CESSNA INC
WICHITA
KANSAS USA
C340 CESSNA CESSNA
4. Review each legacy valid value with the CICTT aircraft manufacture and aircraft make.
For example review the legacy system manufacturer/make for each entry where the
CICTT aircraft manufacturer and aircraft make are “CESSNA.” At this time modify the
CICTT manufacturer and/or make to eliminate any non-Cessna aircraft or modify the
CICTT manufacturer for Cessna aircraft manufactured by Reims.
LEGACY SYSTEM CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master
Series
Series
XY2 CESSNA 172F CESSNA CESSNA
CESSNA
AIRCRAFT
172 G CESSNA CESSNA
XYZ Reims
Aviation S.A.
Cessna FR172K REIMS CESSNA
CESSNA
AIRCRAFT
CO
CESSNA 172E CESSNA CESSNA
CESSNA
AIRCRAFT
COMPANY
CESSNA 337 A CESSNA CESSNA
CESSNB Cessna 340A CESSNA CESSNA
CESSNA INC
WICHITA
KANSAS USA
C340 CESSNA CESSNA
5. Populate the CICTT aircraft model for legacy valid values for a specific CICTT aircraft
manufacturer and aircraft make as well as a general entry for the legacy aircraft model.
For example, review the legacy model for each entry where the CICTT manufacturer and
make are “CESSNA” and “172” appears in the legacy aircraft model.
LEGACY SYSTEM
CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master
Series
Series
XY2 CESSNA 172F CESSNA CESSNA 172
CESSNA
AIRCRAFT
172 G CESSNA CESSNA 172
6
LEGACY SYSTEM
CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
Model Manufacturer Make Master Model Model Master
Series
Series
XYZ Reims
Aviation S.A.
Cessna FR172K REIMS CESSNA FR172
CESSNA
AIRCRAFT
CO
CESSNA 172E CESSNA CESSNA 172
6. Populate the CICTT valid values for the aircraft master model, master series, and series.
LEGACY SYSTEM CICTT VALID VALUES
Code (if
applicable)
Make and/or
Manufacturer
　
中國航空網 m.k6050.com
航空翻譯 www.aviation.cn
本文鏈接地址：航空資料28(55)