CAWIS (SIGS) SPECIAL INTEREST GROUPS MODULE
- kurt.martin
The SIGS module was initially created to serve a TC/ ICAO (International Civil Aviation Organization) agreement to forward a copy of every Canadian Airworthiness Directive (AD) and Civil Aviation Service Alert (CASA) to every ICAO member (200+ countries) when published.
The module was later modified to include various Sig_types, thus expanding the potential type of recipients beyond ICAO members, that can be contacted during the MDM process.
QUICK SEARCH - this is rarely used. The User needs to know the ID number
2. ADVANCED SEARCH - more commonly used
3. Advanced Search Sample
4. SIGS Data entry
DATA ELEMENTS
DATA ELEMENT | FIELD NAME | TABLE(s) | DESCRIPTION |
SIG_number | SIG_NUMBER | Y57_SIG | Sequential number allocated to each new SIG entry |
SIG_Type | SIG_TYPE_CD | Y57_SIG , TR40_SIG_TYPE | 1 CAA (details down below) |
Name | Y56.NAME_COMMON_NM , Y57.PARTY_SIG_ID | Y57_SIG, Y56_ORGANIZATION | Company/Organization name |
Address | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE1_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
Address 2 | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE2_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
City/Town | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.CITY_TXT | Y90_PARTY_CONTACT, A90_ADDRESS | addressing info |
Country | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.COUNTRY_CD , TR21_COUNTRY | Y90_PARTY_CONTACT, A90_ADDRESS | country code |
Postal Code | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.POSTAL_CODE_ID | Y90_PARTY_CONTACT, A90_ADDRESS | Postal code required for Canadian Addresses. Zip code required for American addresses. Optional for other countries |
Province/State | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.PROVINCE_CD, TR01_PROVINCE | Y90_PARTY_CONTACT, A90_ADDRESS | Provinces for Canada. States for America. Not required for other countries |
Mail Property | MAILING_PROPERTY_CD | Y57_SIG | values 1-MAIL - will receive notification of all documents pertaining to Mfg/models associated with this entity, whenever SIGS is included as part of the mailing query
|
AFTN No | AFTN_TXT | Y57_SIG | Aeronautical Fixed Telecommunication Network Historical AFTN data from the mainframe - this transmission method has not been used since the early 1990’s |
Notes | NOTES_TXT | Y57_SIG | Notes/Emails from from each SIGS entry. Mostly pertains to physical address changes and email-addresses |
Phone Number(s) | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | 2 acceptable formats
No other special characters permitted. Entity can have as many phone numbers as desired. |
FAX Number(s) | Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | same rules as for phone |
Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT | Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY | Entity can have as many email addresses as desired. An entity with NO emails, will NOT appear in any Distribution lists. SIGS entities are currently only contacted by Email. | |
Product Type | PRODUCT_CD | Y63_SIG_PRODUCT_MAKE_MODEL | Mfg/Model product type A-aircraft E-engine P-propeller |
Manufacturer | Y63.MANUFACTURER_ID, Y60.PARTY_ID, Y56.NAME_COMMON_NM | Y63_SIG_PRODUCT_MAKE_MODEL | Product manufacturer |
Model | MODEL_ID | Y63_SIG_PRODUCT_MAKE_MODEL | Product model |
NOTES
SIG TYPES | DETAILS |
|---|---|
CAA | Civil Aviation Authorities (ICAO members) are to receive copies of all AD’s and CASA’s issued by TC. This feature is currently restricted to entities having a valid email address. (PBI#115159) The Mfg/model associations for all CAA’s are auto maintained by script. Each CAA should have a model association (Y63) for :
There is special handling for the European agency, EASA (sig #436) This entity consists of 30+ European countries (found in Z980_TERM_CONVERSION where Term_type_cd = ‘EASA’) So EASA, has model associations for CANADA, and ALL of its member countries. Note: only the TCH CAA should be notified in event of a Canadian AD on a NON-Canadian product, not ALL CAA’s |
MANUFACTURER | Product Manufacturers or Type-Certificate holders. Mfg/Models need to be manually assigned and maintained for these entities. When TC issues an AD/CASA against a non-Canadian product, the distribution list should include
|
TCC | Transport Canada Reference centers (these are all currently set to NOMAIL and will receive nothing) |
OTHER | Miscellaneous contactees (example: Canada Communications Publishing) (these are all currently set to NOMAIL) |
ACCIDENT INVESTIGATION | These entries provide contact information for International entities responsible for Accident Investigation. This subset of data is used for a DROPDOWN selection in the TSB module (these are all currently set to NOMAIL) |
AIRWORTHINESS AUTHORITIES | These are the entities from which CAW receives Airworthiness Directives. These entity names appear in the ISSUING AUTHORITY field of the AD data entry screen, by country code match. (these are all set to NOMAIL) |
TC REGIONAL OFFICE | Airworthiness HQ for each region. They have a mailing property of ALL, so they receive a copy of everything values 1 - PACIFIC |
AVIATION ASSOCIATION | Miscellaneous contactees within the aviation industry (Flying clubs, Pilots associations etc) (these are all currently set to NOMAIL) |
From the MAILING module - Note : SIGS entities will be included in any given distribution provided that “only 5008” is NOT selected