Closed davidbader closed 7 years ago
Thanks Christian On Mon, Mar 13, 2017 at 11:32 PM Christian Reich notifications@github.com wrote:
@dsbader https://github.com/dsbader: Yes. https://github.com/OHDSI/Vocabulary-v5.0/blob/master/Final_Assembly/concept_ancestor.sql .
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/OHDSI/Vocabulary-v5.0/issues/108#issuecomment-286312192, or mute the thread https://github.com/notifications/unsubscribe-auth/AQAcfTQcVOg0mu-sJPeLWpPTutyMGJW2ks5rlgpRgaJpZM4MXQs6 .
I see that the convenience table CONCEPT_ANCESTOR is limited to standard and valid concepts, however, I'm interested in providing some backwards-compatibility for deprecated concepts. I.e., Roll-up a deprecated concept to its former ancestor concepts, even though the relationship may now be invalidated.
Is there a SQL script or any documentation that I could use to try to replicate the logic used for generating CONCEPT_ANCESTOR?