STEP 23 ATA/JASC CODES

Sept 2021 : NOTE - all required code for this process is found at :

FAA DATA IMPORT PROCEDURE.TXT

simply copy and place into your preferred SQL tool

ATA = JASC CODES - these terms are used interchangeably in CAWIS

ATA - AIR TRANSPORT ASSOCIATION

JASC - JOINT AIRCRAFT SYSTEM/COMPONENT

Integrity check for ATA/JASC codes.

Null or Undefined ATA/Jasc codes are set to Zero

JASC CODES #2 & #3 are not provided in the FAA data.

*/

UPDATE M70_SDR_TRANSIT M70

SET   JASC_NBR_1 = 0

WHERE JASC_NBR_1 NOT IN

       (SELECT TR57.JASC_NBR FROM TR57_JASC TR57

        WHERE  TR57.JASC_NBR = NVL(M70.JASC_NBR_1,9999)) ;

COMMIT;

/*