{"action":"opened","issue":{"url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/93","repository_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0","labels_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/93/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/93/comments","events_url":"https://api.github.com/repos/OHDSI/Vocabulary-v5.0/issues/93/events","html_url":"https://github.com/OHDSI/Vocabulary-v5.0/issues/93","id":194980853,"number":93,"title":"ICD10 Hepatitis C linked to Hepatitis B","user":{"login":"ericaVoss","id":6305439,"avatar_url":"https://avatars.githubusercontent.com/u/6305439?v=3","gravatar_id":"","url":"https://api.github.com/users/ericaVoss","html_url":"https://github.com/ericaVoss","followers_url":"https://api.github.com/users/ericaVoss/followers","following_url":"https://api.github.com/users/ericaVoss/following{/other_user}","gists_url":"https://api.github.com/users/ericaVoss/gists{/gist_id}","starred_url":"https://api.github.com/users/ericaVoss/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ericaVoss/subscriptions","organizations_url":"https://api.github.com/users/ericaVoss/orgs","repos_url":"https://api.github.com/users/ericaVoss/repos","events_url":"https://api.github.com/users/ericaVoss/events{/privacy}","received_events_url":"https://api.github.com/users/ericaVoss/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-12T13:59:07Z","updated_at":"2016-12-12T13:59:07Z","closed_at":null,"body":"**Vocab Version 20160817**\r\n\r\nThere is an ICD10CM `B17.11-\tAcute hepatitis C with hepatic coma` linked to the following standard concept `4314443-Hepatic coma due to acute hepatitis B`.  Does this make sense?\r\n\r\n```{SQL}\r\nSELECT c.CONCEPT_ID, c.CONCEPT_NAME, c.CONCEPT_CODE, \r\n\tc2.CONCEPT_ID, c2.CONCEPT_NAME\r\nFROM CONCEPT c\r\n\tJOIN CONCEPT_RELATIONSHIP cr\r\n\t\tON cr.CONCEPT_ID_1 = c.CONCEPT_ID\r\n\t\tAND cr.INVALID_REASON IS NULL\r\n\tJOIN CONCEPT c2\r\n\t\tON c2.CONCEPT_ID = cr.CONCEPT_ID_2\r\n\t\tAND c2.STANDARD_CONCEPT IS NOT NULL\r\nWHERE c.CONCEPT_CODE = 'B17.11'\r\n```"}}
{"actor":{"display_login":"ericaVoss"}}