{"action":"closed","issue":{"url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm/issues/70","repository_url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm","labels_url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm/issues/70/labels{/name}","comments_url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm/issues/70/comments","events_url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm/issues/70/events","html_url":"https://github.com/PEDSnet/pedsnetcdm_to_pcornetcdm/issues/70","id":135830560,"number":70,"title":"Death Script needs to be updated for death impute PEDSNet v2.1","user":{"login":"burrowse","id":7452282,"avatar_url":"https://avatars.githubusercontent.com/u/7452282?v=3","gravatar_id":"","url":"https://api.github.com/users/burrowse","html_url":"https://github.com/burrowse","followers_url":"https://api.github.com/users/burrowse/followers","following_url":"https://api.github.com/users/burrowse/following{/other_user}","gists_url":"https://api.github.com/users/burrowse/gists{/gist_id}","starred_url":"https://api.github.com/users/burrowse/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/burrowse/subscriptions","organizations_url":"https://api.github.com/users/burrowse/orgs","repos_url":"https://api.github.com/users/burrowse/repos","events_url":"https://api.github.com/users/burrowse/events{/privacy}","received_events_url":"https://api.github.com/users/burrowse/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/PEDSnet/pedsnetcdm_to_pcornetcdm/labels/death","name":"death","color":"009800"}],"state":"closed","locked":false,"assignee":{"login":"toanong","id":5255749,"avatar_url":"https://avatars.githubusercontent.com/u/5255749?v=3","gravatar_id":"","url":"https://api.github.com/users/toanong","html_url":"https://github.com/toanong","followers_url":"https://api.github.com/users/toanong/followers","following_url":"https://api.github.com/users/toanong/following{/other_user}","gists_url":"https://api.github.com/users/toanong/gists{/gist_id}","starred_url":"https://api.github.com/users/toanong/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/toanong/subscriptions","organizations_url":"https://api.github.com/users/toanong/orgs","repos_url":"https://api.github.com/users/toanong/repos","events_url":"https://api.github.com/users/toanong/events{/privacy}","received_events_url":"https://api.github.com/users/toanong/received_events","type":"User","site_admin":false},"milestone":null,"comments":4,"created_at":"2016-02-23T19:02:42Z","updated_at":"2016-03-14T14:18:18Z","closed_at":"2016-03-14T14:18:18Z","body":"The death impute logic needs to be updated now that sites are populating this field for how/if death dates are being imputed:\r\n\r\nInsert into pcornet_cdm.death(\r\n\tpatid, death_date, death_date_impute,\r\n\tdeath_source, death_match_confidence\t\r\n)\r\nSelect \r\n\tde.person_id as patid,\r\n\tde.death_date as death_date,\r\n\t***HERE*** `'NI' as death_impute, -- default for now until next ETL cycle` \r\n\t'L' as death_source, --  default for now until next ETL cycle\r\n\tnull as death_match_confidence --  we do not capture it dicretely in the EHRs \r\nFrom\r\n\tdeath de\r\n\tjoin pcornet_cdm.demographic d on d.patid = cast(de.person_id as text)\r\nWhere \r\n\tde.death_type_concept_id  = 38003569;"}}