Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

DATA ELEMENT OR FEATURE

DESCRIPTION / FUNCTIONALITY

NAME (or Common Name)

Manufacturer name

Manufacturer Maintenance

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.
codes:
https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/AWD-CN/documents/SDRCODE.TXT

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)

6 - a model is considered “aliased” if it occurs under another manufacturer and has the same NICO-TATC-code. All airworthiness directives, projects etc, which apply to one mfg/model, also apply to the aliased mfg/model. This is auto-maintained.

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-

  2. simply be altered to their desired new format. Usually a punctuation change to match similar models already on the tables

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
2-HELICOPTER - cannot have propellers
3-GLIDER - cannot have engines/propellers
4-GYROPLANE
5-BALLOON - cannot have engines/propeller
6-AIRSHIP
7-ORNITHOPTER
8-POWERED PARACHUTE
9-UNKNOWN

ENGINE CATEGORY

Only appears for Product-type = E models.

Allocated during an ADD, changeable during a modify.

A-RECIPROCATING
B-TURBO JET - cannot have a propeller
C-TURBO PROP
D-TURBO FAN - cannot have a propeller
F-TURBO SHAFT
Y-NOT DEFINED

GROUP CODE

Group codes “bundle” together similar type aircraft for SDR trend analysis. They are allocated during an ADD and can be modified anytime afterward from the select list. Some defaults are AMTR for Amateur built products or simply Manufacturer name if the model is unique. These are maintained by the CAW Inspectors.
New Group codes can be allocated from the main menu, go to
CAWIS Main Menu → Code Table Admin → 5008 codes → Group Code

PERSONNEL CODE

A 2 digit code denoting the CAW Inspector responsible for this mfg/model. This is used to direct SDR reports to the inbox of the designated TI.

In the old WSDRS (pre 2007) Personnel codes were allocated with a single user tied to a single manufacturer and they were more simply maintained. Now many manufacturers are split over 3 or 4 inspectors causing much confusion when new personnel are hired.

There is no interface in CAWIS to deal with personnel codes in bulk, when new hires occur in CAW, so it usually needs to be done on the backend.

ACTIVE

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 is auto-maintained by the overnight job which reviews which aircraft are on the current register.

A Canadian mfg/model is NEVER set to inactive since TC always has responsibility for these products.

An “aliased” mfg/model is not set to inactive if instances of that model occur under another manufacturer on the current register.

ASSOCIATED ADS

List of Airworthiness Directives associated to this model and links to those documents

ADD (BUTTON)

Allows the user to ADD this mfg/model onto the applicability of any Airworthiness Directive (C10 table)

ADD FROM PRODUCT (BUTTON)

Allows the user to AD applicabilities FROM another mfg/model onto this new mfg/model (C10)

REMOVE (BUTTON)

Allows the user to Remove this mfg/model from the applicability of any listed AD (highlight radio button, click remove)

TC CODE

Type certificate - or - Type Approval code from NICO. Lookup the TC code, or apply a TC exception

TC EXCEPTION

A check mark appears here if the user has selected one of the TC exceptions for TC Code ( ‘NOT’,'NOT CERTIFICATED','NOT IDENTIFIED')

CAST ICAO

Sourced from a series of ICAO tables prefixed with “X”. This data has not been updated since 2001.

CAWIS TABLES

SEARCH CAST/ICAO

The inspectors occasionally map CAST/ICAO values to new models. Rarely used. Does not appear anywhere else in CAWIS

NOTES

freeform text notes regarding this mfg/model

...