Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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 (250+ countries) when published.

The module was later modified to include various Sig_types, thus expanding the type of recipients beyond ICAO members, that can be contacted during the MDM process.

  1. 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  - Civil Aviation Authorities (ICAO members)     
2    MANUFACTURER - Product Manufacturers.       
3    TCC - Transport Canada Center Reference centers                
4    OTHER   - Miscellaneous contactees ( example Canada Communications Publishing)          
5    ACCIDENT INVESTIGTN 
6    AIRWORTHINESS AUTH  
8    TC REGIONAL OFFICE  
9    AVIATION ASSOCIATION 

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 for other countries

Mail Property

MAILING_PROPERTY_CD

Y57_SIG

values

1-MAIL - will receive notification of all documents pertaining to 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 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 - 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

FAX Number(s)

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT

Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY

Email

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A92.ADDRESS_PROPERTY_TXT

Y90_PARTY_CONTACT, A92_ADDRESS_PROPERTY

Product Type

PRODUCT_CD

Y63_SIG_PRODUCT_MAKE_MODEL

Manufacturer

Y63.MANUFACTURER_ID, Y60.PARTY_ID, Y56.NAME_COMMON_NM

Y63_SIG_PRODUCT_MAKE_MODEL

Model

MODEL_ID

Y63_SIG_PRODUCT_MAKE_MODEL

  • No labels