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. You need 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 |
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 | |
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 |
0 Comments