UPDATE cdisease SET code506='01' WHERE  diseasecode='A00';
UPDATE cdisease SET code506='01' WHERE  diseasecode='A00.0';
UPDATE cdisease SET code506='01' WHERE  diseasecode='A00.1';
UPDATE cdisease SET code506='01' WHERE  diseasecode='A00.9';
UPDATE cdisease SET code506='02' WHERE  diseasecode='A07';
UPDATE cdisease SET code506='02' WHERE  diseasecode='A08';
UPDATE cdisease SET code506='02' WHERE  diseasecode='A09';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A05';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A05.3';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A02';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A05.2';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A05.1';
UPDATE cdisease SET code506='03' WHERE  diseasecode='A05.9';
UPDATE cdisease SET code506='04' WHERE  diseasecode='A04';
UPDATE cdisease SET code506='05' WHERE  diseasecode='A03';
UPDATE cdisease SET code506='06' WHERE  diseasecode='A06';
UPDATE cdisease SET code506='07' WHERE  diseasecode='A01';
UPDATE cdisease SET code506='08' WHERE  diseasecode='A01.0';
UPDATE cdisease SET code506='09' WHERE  diseasecode='A01.1';
UPDATE cdisease SET code506='09' WHERE  diseasecode='A01.2';
UPDATE cdisease SET code506='09' WHERE  diseasecode='A01.3';
UPDATE cdisease SET code506='09' WHERE  diseasecode='A01.4';
UPDATE cdisease SET code506='10' WHERE  diseasecode='B19';
UPDATE cdisease SET code506='11' WHERE  diseasecode='B15';
UPDATE cdisease SET code506='12' WHERE  diseasecode='B16';
UPDATE cdisease SET code506='13' WHERE  diseasecode='B17.1';
UPDATE cdisease SET code506='69' WHERE  diseasecode='B17.0';
UPDATE cdisease SET code506='70' WHERE  diseasecode='B17.2';
UPDATE cdisease SET code506='71' WHERE  diseasecode='B08.4';
UPDATE cdisease SET code506='61' WHERE  diseasecode='A06.4';
UPDATE cdisease SET code506='15' WHERE  diseasecode='J10';
UPDATE cdisease SET code506='15' WHERE  diseasecode='J11';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J12';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J13';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J14';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J15';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J15.7';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J16';
UPDATE cdisease SET code506='31' WHERE  diseasecode='J18';
UPDATE cdisease SET code506='32' WHERE  diseasecode='A15';
UPDATE cdisease SET code506='32' WHERE  diseasecode='A16';
UPDATE cdisease SET code506='32' WHERE  diseasecode='A19';
UPDATE cdisease SET code506='16' WHERE  diseasecode='B05';
UPDATE cdisease SET code506='16' WHERE  diseasecode='B06';
UPDATE cdisease SET code506='17' WHERE  diseasecode='B01';
UPDATE cdisease SET code506='17' WHERE  diseasecode='B02';
UPDATE cdisease SET code506='20' WHERE  diseasecode='A80';
UPDATE cdisease SET code506='21' WHERE  diseasecode='B05';
UPDATE cdisease SET code506='21' WHERE  diseasecode='B06';
UPDATE cdisease SET code506='22' WHERE  diseasecode='B05.2';
UPDATE cdisease SET code506='22' WHERE  diseasecode='B05.0';
UPDATE cdisease SET code506='22' WHERE  diseasecode='B05.3';
UPDATE cdisease SET code506='23' WHERE  diseasecode='A36';
UPDATE cdisease SET code506='24' WHERE  diseasecode='A37';
UPDATE cdisease SET code506='25' WHERE  diseasecode='A35';
UPDATE cdisease SET code506='52' WHERE  diseasecode='B26';
UPDATE cdisease SET code506='53' WHERE  diseasecode='A33';
UPDATE cdisease SET code506='65' WHERE  diseasecode='G82.0';
UPDATE cdisease SET code506='77' WHERE  diseasecode='B02';
UPDATE cdisease SET code506='19' WHERE  diseasecode='A39.0';
UPDATE cdisease SET code506='19' WHERE  diseasecode='A39.9';
UPDATE cdisease SET code506='19' WHERE  diseasecode='G01';
UPDATE cdisease SET code506='28' WHERE  diseasecode='A85';
UPDATE cdisease SET code506='28' WHERE  diseasecode='A86';
UPDATE cdisease SET code506='29' WHERE  diseasecode='A83.0';
UPDATE cdisease SET code506='33' WHERE  diseasecode='A17.0';
UPDATE cdisease SET code506='33' WHERE  diseasecode='G01';
UPDATE cdisease SET code506='54' WHERE  diseasecode='G00';
UPDATE cdisease SET code506='54' WHERE  diseasecode='G01';
UPDATE cdisease SET code506='54' WHERE  diseasecode='G02';
UPDATE cdisease SET code506='54' WHERE  diseasecode='G03';
UPDATE cdisease SET code506='54' WHERE  diseasecode='A87';
UPDATE cdisease SET code506='55' WHERE  diseasecode='G02';
UPDATE cdisease SET code506='26' WHERE  diseasecode='A90';
UPDATE cdisease SET code506='26' WHERE  diseasecode='A91';
UPDATE cdisease SET code506='26' WHERE  diseasecode='A92.0';
UPDATE cdisease SET code506='27' WHERE  diseasecode='A90';
UPDATE cdisease SET code506='27' WHERE  diseasecode='A91';
UPDATE cdisease SET code506='27' WHERE  diseasecode='A99';
UPDATE cdisease SET code506='30' WHERE  diseasecode='B50';
UPDATE cdisease SET code506='30' WHERE  diseasecode='B51';
UPDATE cdisease SET code506='30' WHERE  diseasecode='B52';
UPDATE cdisease SET code506='30' WHERE  diseasecode='B53';
UPDATE cdisease SET code506='30' WHERE  diseasecode='B54';
UPDATE cdisease SET code506='44' WHERE  diseasecode='A75';
UPDATE cdisease SET code506='66' WHERE  diseasecode='A90';
UPDATE cdisease SET code506='76' WHERE  diseasecode='B74.0';
UPDATE cdisease SET code506='76' WHERE  diseasecode='B74.1';
UPDATE cdisease SET code506='14' WHERE  diseasecode='B30';
UPDATE cdisease SET code506='35' WHERE  diseasecode='A30';
UPDATE cdisease SET code506='36' WHERE  diseasecode='A66';
UPDATE cdisease SET code506='37' WHERE  diseasecode='A50';
UPDATE cdisease SET code506='37' WHERE  diseasecode='A51';
UPDATE cdisease SET code506='37' WHERE  diseasecode='A52';
UPDATE cdisease SET code506='37' WHERE  diseasecode='A53';
UPDATE cdisease SET code506='38' WHERE  diseasecode='A54';
UPDATE cdisease SET code506='39' WHERE  diseasecode='N34.1';
UPDATE cdisease SET code506='40' WHERE  diseasecode='A57';
UPDATE cdisease SET code506='41' WHERE  diseasecode='A55';
UPDATE cdisease SET code506='42' WHERE  diseasecode='A82';
UPDATE cdisease SET code506='43' WHERE  diseasecode='A27';
UPDATE cdisease SET code506='45' WHERE  diseasecode='A22';
UPDATE cdisease SET code506='46' WHERE  diseasecode='B75';
UPDATE cdisease SET code506='72' WHERE  diseasecode='A24';
UPDATE cdisease SET code506='18' WHERE  diseasecode='R50';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18.2';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18.0';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18.3';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18.4';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18.1';
UPDATE cdisease SET code506='34' WHERE  diseasecode='A18';
UPDATE cdisease SET code506='63' WHERE  diseasecode='B81.1';
UPDATE cdisease SET code506='63' WHERE  diseasecode='B83.8';
UPDATE cdisease SET code506='68' WHERE  diseasecode='B55.0';
UPDATE cdisease SET code506='74' WHERE  diseasecode='A49.1';
UPDATE cdisease SET code506='74' WHERE  diseasecode='J02.0';
UPDATE cdisease SET code506='74' WHERE  diseasecode='A38';
UPDATE cdisease SET code506='74' WHERE  diseasecode='L01.0';
UPDATE cdisease SET code506='74' WHERE  diseasecode='A46';
UPDATE cdisease SET code506='74' WHERE  diseasecode='O85';
UPDATE cdisease SET code506='75' WHERE  diseasecode='B66.0';