On checking fact table concepts vs. concept dimension for UW NAACCR, we have ~200 fact records (out of 60,000) whose concepts don't match up. In other words, their 521-Morphology code value (actually 522 - Histology plus 523-Behavior) doesn't match any value in the ICDO_O_MORPH table set up in the naaccr_concepts_load.sql script. Examples are 98153, 80412, 80722. The most likely explanation is data errors of some kind.
So first, have others experienced this sort of thing with field 521? Are there other possible explanations? Second, assuming this data is defective, is there a protocol or principle to follow with such records? i.e., "gently correct them" vs. "nuke them on sight"? Patrick Lenon HIMC Informatics Specialist 608 890 5671
_______________________________________________ Gpc-dev mailing list [email protected] http://listserv.kumc.edu/mailman/listinfo/gpc-dev
