{"action":"created","issue":{"url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/104","repository_url":"https://api.github.com/repos/OHDSI/CommonDataModel","labels_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/104/comments","events_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/104/events","html_url":"https://github.com/OHDSI/CommonDataModel/issues/104","id":250426054,"number":104,"title":"Add observation.row_created_db_time column","user":{"login":"chen-regen","id":10854641,"avatar_url":"https://avatars2.githubusercontent.com/u/10854641?v=4","gravatar_id":"","url":"https://api.github.com/users/chen-regen","html_url":"https://github.com/chen-regen","followers_url":"https://api.github.com/users/chen-regen/followers","following_url":"https://api.github.com/users/chen-regen/following{/other_user}","gists_url":"https://api.github.com/users/chen-regen/gists{/gist_id}","starred_url":"https://api.github.com/users/chen-regen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chen-regen/subscriptions","organizations_url":"https://api.github.com/users/chen-regen/orgs","repos_url":"https://api.github.com/users/chen-regen/repos","events_url":"https://api.github.com/users/chen-regen/events{/privacy}","received_events_url":"https://api.github.com/users/chen-regen/received_events","type":"User","site_admin":false},"labels":[{"id":623228201,"url":"https://api.github.com/repos/OHDSI/CommonDataModel/labels/Proposal","name":"Proposal","color":"EFDEF9","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-08-15T20:19:51Z","updated_at":"2017-09-24T12:10:06Z","closed_at":null,"author_association":"NONE","body":"Per @anthonysena , I am filing this issue for proposing adding following column:\r\nobservation.row_created_db_time (timestamp)\r\n\r\nThis is for implementing feature 3 I listed on issue [217](https://github.com/OHDSI/WebAPI/issues/217) and issue [223](https://github.com/OHDSI/WebAPI/issues/223):\r\nCalculate average delay time between observation.observation_date and row_created_db_time each day and show them in chart.\r\n"},"comment":{"url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/comments/331705848","html_url":"https://github.com/OHDSI/CommonDataModel/issues/104#issuecomment-331705848","issue_url":"https://api.github.com/repos/OHDSI/CommonDataModel/issues/104","id":331705848,"user":{"login":"adfrench","id":5480250,"avatar_url":"https://avatars1.githubusercontent.com/u/5480250?v=4","gravatar_id":"","url":"https://api.github.com/users/adfrench","html_url":"https://github.com/adfrench","followers_url":"https://api.github.com/users/adfrench/followers","following_url":"https://api.github.com/users/adfrench/following{/other_user}","gists_url":"https://api.github.com/users/adfrench/gists{/gist_id}","starred_url":"https://api.github.com/users/adfrench/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/adfrench/subscriptions","organizations_url":"https://api.github.com/users/adfrench/orgs","repos_url":"https://api.github.com/users/adfrench/repos","events_url":"https://api.github.com/users/adfrench/events{/privacy}","received_events_url":"https://api.github.com/users/adfrench/received_events","type":"User","site_admin":false},"created_at":"2017-09-24T12:10:06Z","updated_at":"2017-09-24T12:10:06Z","author_association":"NONE","body":"Adding my comment from the CDM Builders Forum here seeing that Chen already posted the feature request:\r\n\r\nWe have a public health researcher at Indiana University who is working to implement OHDSI / OMOP in the Public Health space. One of the areas that he is currently investigating is the measurement of timeliness that data is reported from a healthcare facility to a public health agency. In order to calculate timeliness, we need to be able to compare the observation time to the time the data was recorded (row created time). However, the created time is not currently part of the CDM. Could you please advise as to the proper workgroup or process to have the additional column added to the CDM? Please reference the following request from Dr. Dixon. Additionally, I would add that at the Regenstrief institute we have found the row_created_time and row_updated_time columns to be valuable to our incremental ETL strategy.\r\n\r\nNote:  In this scenario, the CDM would be used to record data in real-time as it is received by the public health agency, which makes sense to use row_created_time.  However, the column could be more general to be a simple created_tme where it could with be populated with a trigger or set based on a values in a message if the CDM is not being populated in real-time.\r\n\r\n------------------------------\r\nTimeliness is one of the most common dimensions of data quality studied in the information science literature [1]. Furthermore, the timeliness with which data are reported from a healthcare facility to a public health agency is a key aspect of measuring the effectiveness of a surveillance system [2,3]. Under a grant from the U.S. National Library of Medicine, we seek to extend the OHDSI framework to support measurement of data quality characteristics of importance to public health surveillance. To do so, we must make changes to the underlying database architecture to support the calculation of timeliness in OHDSI applications. Public health agencies would be strongly interested in routinely measuring the difference between the date that an observation was added to the database with the date of the observation. This will help the agencies measure how quickly data can be captured by the agency and loaded into the database for use by OHDSI and its surveillance systems. Many state laws require reporting by healthcare facilities within 24, 48, or 72 hours following diagnosis or an emergency room encounter. Measuring timeliness will allow health officials to monitor their ability to make these data available for surveillance following their transmission from healthcare facilities. Monitoring timeliness will help the agencies improve not only their internal processing of data but also improve the responsiveness from their healthcare facilities. Therefore we strongly urge your consideration of our request. We do not anticipate that the new fields will interfere or conflict with other fields already defined in the schema.\r\n<img width=\"1165\" alt=\"timeliness\" src=\"https://user-images.githubusercontent.com/5480250/30782355-c1baa21c-a0fe-11e7-98e1-47741c407d9a.png\">\r\n\r\n[1] Batini C, Cappiello C, Francalanci C, Maurino A. Methodologies for data quality assessment and improvement. Acm Comput Surv. 2009; 41(3).\r\n\r\n[2] Buehler JW, Hopkins RS, Overhage JM, Sosin DM, Tong V. Framework for evaluating public health surveillance systems for early detection of outbreaks: recommendations from the CDC Working Group. MMWR Recomm Rep. 2004 May 7;53(RR-5):1-11.\r\n\r\n[3] Dixon BE, McGowan JJ, Grannis SJ. Electronic laboratory data quality and the value of a health information exchange to support public health reporting processes. AMIA Annu Symp Proc. 2011; 2011:322-30."}}
{"actor":{"display_login":"adfrench"}}