| Title: | ACE Extract Reference File Query (FQ) fixes Deployed to PRODUCTION |
|---|---|
| Date: | 2017-04-18 |
| To: | abi,newace |
| Links: | previous, original, next |
ACE Extract Reference File Query (FQ) software updates have been deployed to the ACE PRODUCTION environment as follows:
• When returning F106 results for an Air Carrier, return the 2-character Census Abbreviation/IATA airline designator in the SCAC field, instead of the 3-character ICAO/SCAC.
• Address data will not be returned in the F106 Carrier Query/Extract for Air Carriers.
• When an "Air" MOT account has no Census Abbreviation/IATA code, the corresponding SCAC field will be blanked out (four spaces).
• Air Carrier List output in F106 ordered alphabetically by Carrier Name.
• F106 Air Carrier Extract to include Active air carriers only.
• Alphabetical ordering of Country list corrected in F202
• AGOA_CBPTA_BEGN_DT and AGOA_CBPTA_END_DT corrected in F202