...
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'
...