-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -
-- used to house the subset of umls that is being used by scrubber dictionary annotator
-- this is housed in the same schema as the umls data (currently that is expected to be called 'umls')
-- 
-- this will also populate the table with that subset.
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - 
create table lookup_umls like mrconso;

insert into lookup_umls select * from mrconso where sab in (
'COSTAR',
'HL7V2.5',
'HL7V3.0',
'ICD10CM',
'ICD10PCS',
'ICD9CM',
'LNC',
'MSH',
'RXNORM',
'SNOMEDCT'
);
