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.
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) |
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 |
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 | Two 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. | |
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 |
0 Comments