Page Comparison

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   
2    MANUFACTURER
3    TCC       
4    OTHER            
5    ACCIDENT INVESTIGATION
6    AIRWORTHINESS AUTHORITIES
8    TC REGIONAL OFFICE
9    AVIATION ASSOCIATION

(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 defined 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

2-NO MAIL - will receive NO notifications

3-ALL - will receive notification of all documents on all products whenever SIGS is included as part of the mailing query

AFTN No

AFTN_TXT

Y57_SIG

https://en.wikipedia.org/wiki/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

Two 2 acceptable formats

1. North American 999-999-9999

2. International 011-99-99999 (011- access to international switchboard, 99-country code, 99999-all other digits provided)

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

Email

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

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 :

1. every type-approved Canadian Mfg/model and

2. every type-approved Mfg/Model for that country (in the event that TC issues an AD against a NON-Canadian product, a copy of that AD should go to the Type-certificate-holder (TCH) country for that product (country code on Y50)

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 to and maintained for these entities.

When TC issues an AD/CASA against a non-Canadian product, the distribution list should include

1. all Canadian owners/operators of that product

2. all Transport Canada regional offices and TCC’s

3. the CAA of the TCH country -and-

4. The Manufacturer of that product

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

This subset provides 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. It was discovered many years ago, that many of the addresses from which TC received AD’s, differed from the addresses that were used for mailing. The differences were entered under this category for reference onlyThese entity names appear in the ISSUING AUTHORITY field of the AD data entry screen, by country code match.

(these are all currently 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
3 - PNR
4 - ONTARIO
5 - QUEBEC
6 - ATLANTIC
7 - HQ AARDG

AVIATION ASSOCIATION

Miscellaneous contactees within the aviation industry (Flying clubs, Pilots associations etc) (these are all currently set to NOMAIL)