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

Address

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE1_TXT

Y90_PARTY_CONTACT, A90_ADDRESS

Address 2

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.ADDRESS_LINE2_TXT

Y90_PARTY_CONTACT, A90_ADDRESS

City/Town

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.CITY_TXT

Y90_PARTY_CONTACT, A90_ADDRESS

Country

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.COUNTRY_CD , TR21_COUNTRY

Y90_PARTY_CONTACT, A90_ADDRESS

Postal Code

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.POSTAL_CODE_ID

Y90_PARTY_CONTACT, A90_ADDRESS

Province/State

Y57.PARTY_SIG_ID, Y90.ADDRESS_ID, A90.PROVINCE_CD, TR01_PROVINCE

Y90_PARTY_CONTACT, A90_ADDRESS

Mail Property

MAILING_PROPERTY_CD

Y57_SIG

AFTN No

AFTN_TXT

Y57_SIG

Notes

NOTES_TXT

Y57_SIG

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