...
If the manufacturer being entered exists in the from_txt of the Z980_term_conversion tables, but points to another existing manufacturer, this page will raise a “duplicate” error on the save. When If this occuresoccurs, go to the Term_conversion module, and either :
a) delete all instances of the desired “new manufacturer” “new manufacturer” in the from_txt or
b) update all instances of the To_txt to the “new manufacturer” “new manufacturer” where that value exists in “From“From_txt”txt”
Note: there is always one row on Z980 where from_txt = to_txt for each manufacturer listed on y60
...
OTHER SOURCES FOR NEW MANUFACTURERS
TI Entry during Airworthiness Directive (AD) Input
This feature is only used for Equipment AD’s
...
. The new manufacturer is assigned whatever country_code is assigned to the AD being entered.
...
2) CLIENT data entry on AAIR page
The CLIENT can define new, Engine, Propeller, Float and Ski manufacturers (and models) during AAIR submission
...
3) CAWIS user data entry on the 5008 or AAIR page
The CAWIS user can define new, Aircraft, Engine, Propeller, Float and Ski manufacturers (and models) during 5008 modification. They can also do this on the internal AAIR page, the same as the client.
...
4) CCARCS DATA IMPORT
CAWIS will establish new manufacturers (and models) for any previously unseen values found under Common-name or Id-Plate-manufacturers-name during the nightly synchronization job
...
5) NAPA interface
The NAPA interface is used in the Airworthiness Directive subsystem to assist with data entry. The TI selects a TC-holder from NAPA, which then maps all of the approval snumber number (TC_code or Foreign_num from V_CAW_TC_HOLDER_NAPA@NNPRODC.WORLD) back to CAWIS TATC-codes and populates the dropdowns with the associate mfg/models. CAWIS picks up any values from the TC-holder column that do not exist on Y60_manufacturer and either
...
b) establishes a new manufacturer in CAWIS ( example: when Bombardier was broken into several organizations a few years back we were presented with AIRBUS CANADA, MHI RJ and DEHAVILLAND AIRCRAFT as “new” manufacturers ) The Continuing Airworthiness TI’s would later establish models based on these designations.
...
6) FAA (Federal Aviation Administration) SDR DATA
A conversion table for incoming FAA data is maintained at Y72_FAA_MODEL_CONVERSION.
For any new manufacturers found during a data import it
a) creates a new mapping to an existing manufacturer on Z980_term_conversion - or -
b) establishes a new manufacturer in CAWIS
...