From the CAWIS main menu, go to
main menu → Code table Admin → Make-Model
Available functions :
search (model or model substring)
Advanced Search
New model
Basic Search Example :
Note : this function should be made to search Data_compression(input_value) like %Data_compression(model_id)% when returning results
Advanced Search
Note : the default radio button should be set to ALL in both sections
From this page, the user can search by Product_type & Manufacturer (+ optional Model Substring)
The Type-Certificate section of the page shows the NAPA / NICO a type approval code list in the dropdown. Selecting one or more codes, maps those Type-approval codes back to all the MFG/models in CAWIS holding those codes.
Search Results page
column | description |
|---|---|
ACTIVE/INACTIVE | a mfg/model is set to Active if there are instances of it on currently registered aircraft. A model is set to INACTIVE when all instances of it, leave the Canadian register. This flag determines which mfg/models will appear in the dropdowns on the Airworthiness Directive page, as INACTIVE models do not appear, and are not monitored for new AD’s |
TYPE | product type (A-aircraft, E-engine, P-propeller, Q-equipment, F-float, S-skis) |
MANUFACTURER | manufacturer of this product |
MODEL | model as it appears on the type certificate data sheet |
TATC CODE | Type Approval - or - Type Certificate code from NICO associated with this product. Can also include TC Exceptions |
COUNTRY | Type Certificate Holder - or - State of Design for this product |
A/C COUNT | Number of Aircraft on the current register using this mfg/model |
Modifying a model
1 - SEARCH
2 - SELECT FROM LIST - then click on the manufacturer (or click the Modify button at the bottom)
The View button - a read-only display of the info for this model
The Delete button - will only work if this model is not in use anywhere in the system (WSDRS, SIGS, TSB, PTS, AD, 5008)
3 - THE MODIFY PAGE
DATA ELEMENT OR FEATURE | DESCRIPTION / FUNCTIONALITY |
|---|---|
NAME (or Common Name) | Manufacturer name The Manufacturer is “selectable” during an ADD, but unchangeable afterward. When errors are found, where the wrong manufacturer is assigned to several models, a backend data cleanup is required as outlined here : CAWIS RE-ASSIGNING EXISTING MODELS TO A NEW MANUFACTURER There is no function to do this task. |
LEGAL NAME | The Legal name is auto-assigned during an ADD (tied to Common Name on y56) It is unchangeable during a model ADD or MODIFY. This can only by altered under the Manufacturer maintenance option on the Administration menu. |
COUNTRY | Type Certificate Holder - or - State of Design assigned to this manufacturer. This can only by altered under the Manufacturer maintenance option on the Administration menu. |
PRODUCT TYPE | Product types , A-aircraft, E-engine, P-propeller, Q-equipment, F-float, S-ski. Can only be assigned to a mfg/model during an ADD. It is unchangeable after that. |
MODEL | 20 character limit. Defaults : 1 - A default model called “FLOAT” exists for every FLOAT manufacturer 2 - A default model called “SKI” exists for every SKI manufacturer 3 - A default model called “PROPELLER” exists for every PROPELLER manufacturer 4 - When the Product Type is Q , the model is always Equipment and there is always 1 equipment record for every manufacturer on y60 5 - All Owner Maintenance (flight authority C ) have models that are suffixed with “X” ( This is a business rule from the 1990’s) Hidden function Existing models can be altered. Changing 7AB, to 7ABCD, will alter every occurrence of value-1 to value-2 throughout ALL CAWIS subsystems. This is a highly useful tool, in that when bad models are identified, they can either 1) be consolidated with another existing model (ie: value-1 is deleted and all instances of it are altered to value-2) -or- simply be altered to their desired format |
AIRCRAFT CATEGORY | Only appears for Product-type = A models. Allocated during an ADD, changeable during a modify. However, there are edit rules on 5008 modify page which will be impacted by a radical category change. ie) changing an AEROPLANE to a GLIDER, will hide any engine/propeller models on any 5008 page associated to this Aircraft mfg/model 1-AEROPLANE |
ENGINE CATEGORY | |
GROUP CODE | |
PERSONNEL CODE | |
ACTIVE | |
ASSOCIATED ADS | |
ADD | |
ADD FROM PRODUCT | |
REMOVE | |
TC CODE | |
TC EXCEPTION | |
CAST ICAO | |
SEARCH CAST/ICAO | |
NOTES |
0 Comments