Development of a New Method to Trace Patient Data Using the National Database in Japan.

• Material Type: 博士論文
• Title: Development of a New Method to Trace Patient Data Using the National Database in Japan.
• Author/Editor: Myojin, Tomoya; Noda, Tatsuya; Kubo, Shinichiro; Nishioka, Yuichi; Higashino, Tsuneyuki; Imamura, Tomoaki
• Author Heading: Myojin, Tomoya; Noda, Tatsuya; Kubo, Shinichiro; Nishioka, Yuichi; Higashino, Tsuneyuki; Imamura, Tomoaki
• Publication, Distribution, etc.: 日本生体医工学会
• Publication Date: 2022
• Publication Date (W3CDTF): 2022
• Alternative Title: NDBを用いた新たな患者追跡手法の開発
• Periodical title: Advanced Biomedical Engineering
• No. or year of volume/issue: 11
• Volume: 11
• Pages: 203-217
• ISSN (Periodical Title): ISSN : 2187-5219
• Degree grantor/type: 奈良県立医科大学
• Date Granted: 2022-12-22
• Dissertation Number: 甲第854号
• Degree Type: 博士（医学）
• Text Language Code: eng
• Subject Heading: national health insurance; insurance claim; NDB; patient tracing; database
• Target Audience: 一般
• Note (General): type:Thesis; The National Database of Health Insurance Claims and Specific Health Checkups of Japan (NDB) is a comprehensive database containing health insurance claim information. The structure of the NDB complicates long-term cohorts for two main reasons. First, the NDB data are stored on a per-claim basis. Second, the NDB is a billing-focused record structure. Therefore, the objective of this study was to use ID0 to modify the data structure to allow for long-term cohorts, provided that the data volume is not increased and the runtime per data year is maintained within one month. The NDB uses two primary keys (ID1 and ID2) made from hash values that mask personally identifiable information. ID0 is our recently developed key from ID1 and ID2, which improves patient-matching efficiency with excellent long-term tracing performance. Our study used claim data with filing dates between April 2013 and March 2016 to trace hospitalizations of one month or longer, including outpatient care, in three steps. In Step 1, claims were transferred to a CD-record format. As some diagnosis procedure combination (DPC) claim records contain a mixture of overlapping comprehensive and piece-rate data, we sorted and reorganized them. In Step 2, pharmacy and medical outpatient claims were integrated using the ID0 key, the medical institution code for issuing a prescription, and the prescription issue date. In Step 3, the transferred data were combined and converted from consecutive hospitalization days into sequences based on ID0, the medical institution code, and hospital ward classification. Consequently, the size of the originally extracted comma-separated variable dataset for three years (approximately 10.5 TB) was reduced to an approximately 6 TB main database file that was usable for processing. The process took approximately three months. With similar conventional methods, the data size was 30 times larger, and it took more than seven months to process a year's worth of data. In addition, to demonstrate the application of this method, we conducted a six-year mortality cohort for all Japanese citizens. Our technique makes it easy to perform follow-up and longitudinal cohort surveys while accurately tracing patient data in large-scale medical claims databases.; 博士（医学）・甲第854号・令和4年12月22日; Copyright: ©2022 The Author(s). This is an open access article distributed under the terms of the Creative Commons BY 4.0 International (Attribution) License (https:// creativecommons.org/licenses/by/4.0/legalcode), which permits the unrestricted distribution, reproduction and use of the article provided the original source and authors are credited.; identifier:Advanced Biomedical Engineering Vol.11 p.203-217 (2022); identifier:21875219; identifier:http://ginmu.naramed-u.ac.jp/dspace/handle/10564/4083; identifier:Advanced Biomedical Engineering, 11: 203-217
• Source: fulltext; http://ginmu.naramed-u.ac.jp/dspace/bitstream/10564/4083/1/01%e7%94%b2854%e6%9c%ac%e6%96%87%e3%81%ae%e8%a6%81%e6%97%a8.pdf; http://ginmu.naramed-u.ac.jp/dspace/bitstream/10564/4083/2/02%e7%94%b2854%e5%af%a9%e6%9f%bb%e8%a6%81%e6%97%a8.pdf; http://ginmu.naramed-u.ac.jp/dspace/bitstream/10564/4083/3/03%e7%94%b2854%e6%9c%ac%e6%96%87.pdf; http://ginmu.naramed-u.ac.jp/dspace/bitstream/10564/4083/4/04%e7%94%b2854Suppl.Fig..pdf; http://ginmu.naramed-u.ac.jp/dspace/bitstream/10564/4083/5/05%e7%94%b2854Suppl.Table.pdf
• Access Restrictions: インターネット公開
• Related Material (DOI): 10.14326/abe.11.203
• Data Provider (Database): 国立情報学研究所 : 学術機関リポジトリデータベース（IRDB）（機関リポジトリ）; https://irdb.nii.ac.jp
• Original Data Provider (Database): 奈良県立医科大学 : 奈良県立医科大学機関リポジトリ GINMU