Manufacturer data is maintained from the CAWIS Admin menu, however the full list of data sources for manufacturer data is available at : Manufacturer/Model Tables, Data Sources and Usage
Options :
query manufacturer
modify manufacturer
delete manufacturer
Add new manufacturer
Query Manufacturer - enter full or partial manufacturer name then select from list
Modify manufacturer - The Inspectors occasionally update a manufacturer spelling, or country. A spelling change requires that the auto-correct tables be updated first. All instances of the old spelling of that manufacturer need to be updated on Z980 in the To_txt column. A future enhancement should auto-update the TO_txt column to the new manufacturer value, without having the user enter the Term Conversion module.
3. Delete manufacturer - this works well for “new” entries made in error, but raises an exception for manufacturers in use on any table but Y60. This function is rarely used
4. Add new manufacturer
Fill in the form as seen above - Note: Legal name is not used or viewed anywhere in CAWIS, and is generally filled in with common-name.
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. When this occures, go to the Term_conversion module, and either :
a) delete all instances of the desired “new manufacturer” in the from_txt or
b) update all instances of the To_txt to the “new manufacturer” where that value exists in “From_txt”
Note: there is always one row on Z980 where from_txt = to_txt for each manufacturer listed on y60
Then simply return to the manufacturer module and enter the new manufacturer, as desired.
OTHER SOURCES FOR NEW MANUFACTURERS
TI Entry during Airworthiness Directive (AD) Input
This feature is only used for Equipment AD’s
CLIENT data entry on AAIR page
The CLIENT can define new, Engine, Propeller, Float and Ski manufacturers (and models) during AAIR submission
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.
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
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 (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
a) creates a new mapping to an existing manufacturer on Z980_term_conversion - or -
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.
0 Comments