Page Comparison

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

...

FAA PRODUCT CODES ARE : 1,2,3,4

...

 UPDATE M70_SDR_TRANSIT  SET PRODUCT_CD = 'Q' WHERE PRODUCT_CD = '4';

COMMIT ;

/*

We now update any Product-code that is a mismatch with the ATA/JASC code provided. The ATA/JASC code describes what section of the aircraft is of concern is this SDR.

JASC codes :

  https://wwwapps.tc.gc.ca/Saf-Sec-Sur/2/AWD-CN/documents/JASC.TXT

*/

 UPDATE M70_SDR_TRANSIT SET PRODUCT_CD = 'E'

 WHERE JASC_NBR_1 BETWEEN 7000 AND 8699 AND PRODUCT_CD <> 'E';

 UPDATE M70_SDR_TRANSIT SET PRODUCT_CD = 'P'

 WHERE JASC_NBR_1 BETWEEN 6100 AND 6199 AND PRODUCT_CD <> 'P';

 UPDATE M70_SDR_TRANSIT SET PRODUCT_CD = 'Q'

 WHERE PRODUCT_CD <> 'Q'

 AND   ( JASC_NBR_1 BETWEEN 1000 AND 1000

 OR      JASC_NBR_1 BETWEEN 2500 AND 2565

 OR      JASC_NBR_1 BETWEEN 6800 AND 6999 ) ;

commit;

/*

We now update any Product-code that violates CAWIS/WSDRS editing rules. If the product_cd is 'A', then we must have aircraft manufacturer/model data to insert onto M73. Same for 'E' - engine and 'P' – propeller. The default is always 'Q'

...