{"id":"https://openalex.org/W2503510587","doi":"https://doi.org/10.4018/978-1-61520-905-7.ch007","title":"Merging Different Datasets to Allow for a Complete Analysis (Inpatient, Outpatient, Physician Visits, Medications)","display_name":"Merging Different Datasets to Allow for a Complete Analysis (Inpatient, Outpatient, Physician Visits, Medications)","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2503510587","doi":"https://doi.org/10.4018/978-1-61520-905-7.ch007","mag":"2503510587"},"language":"en","primary_location":{"id":"doi:10.4018/978-1-61520-905-7.ch007","doi":"https://doi.org/10.4018/978-1-61520-905-7.ch007","is_oa":false,"landing_page_url":"https://doi.org/10.4018/978-1-61520-905-7.ch007","pdf_url":null,"source":{"id":"https://openalex.org/S4210233881","display_name":"Advances in medical technologies and clinical practice book series","issn_l":"2327-9354","issn":["2327-9354","2327-9370"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advances in Medical Technologies and Clinical Practice","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W4214770932","display_name":"Clinical Data Mining for Physician Decision Making and Investigating Health Outcomes"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5112136051","display_name":"Patricia Bintzler Cerrito","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I142740786","display_name":"University of Louisville","ror":"https://ror.org/01ckdn478","country_code":"US","type":"education","lineage":["https://openalex.org/I142740786"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Patricia Cerrito","raw_affiliation_strings":["University of Louisville, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Louisville, USA","institution_ids":["https://openalex.org/I142740786"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5018598784","display_name":"John Cerrito","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I4401726750","display_name":"Kroger (United States)","ror":"https://ror.org/04fj16d47","country_code":"US","type":"company","lineage":["https://openalex.org/I4401726750"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"John Cerrito","raw_affiliation_strings":["Kroger Pharmacy, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Kroger Pharmacy, USA","institution_ids":["https://openalex.org/I4401726750"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.37243151,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"116","last_page":"153"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T14400","display_name":"Medical Coding and Health Information","score":0.7455999851226807,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},"topics":[{"id":"https://openalex.org/T14400","display_name":"Medical Coding and Health Information","score":0.7455999851226807,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T10391","display_name":"Healthcare Policy and Management","score":0.22470000386238098,"subfield":{"id":"https://openalex.org/subfields/2002","display_name":"Economics and Econometrics"},"field":{"id":"https://openalex.org/fields/20","display_name":"Economics, Econometrics and Finance"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12246","display_name":"Chronic Disease Management Strategies","score":0.015300000086426735,"subfield":{"id":"https://openalex.org/subfields/2713","display_name":"Epidemiology"},"field":{"id":"https://openalex.org/fields/27","display_name":"Medicine"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/episodes-of-care","display_name":"episode of care","score":0.7940000295639038},{"id":"https://openalex.org/keywords/data-merging","display_name":"data merging","score":0.5130000114440918},{"id":"https://openalex.org/keywords/inpatient-care","display_name":"inpatient care","score":0.5960000157356262},{"id":"https://openalex.org/keywords/outpatient-care","display_name":"outpatient care","score":0.9350000023841858},{"id":"https://openalex.org/keywords/physician-visits","display_name":"physician visits","score":0.9959999918937683},{"id":"https://openalex.org/keywords/medication","display_name":"medication","score":0.5619999766349792},{"id":"https://openalex.org/keywords/economic-burden","display_name":"economic burden","score":0.5669999718666077},{"id":"https://openalex.org/keywords/medical-expenditure-panel-survey","display_name":"Medical Expenditure Panel Survey","score":0.7369999885559082},{"id":"https://openalex.org/keywords/patient-visits","display_name":"patient encounters","score":0.5600000023841858},{"id":"https://openalex.org/keywords/follow-up-visits","display_name":"follow-up visits","score":0.550000011920929}],"concepts":[{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.7716479301452637},{"id":"https://openalex.org/C2775909303","wikidata":"https://www.wikidata.org/wiki/Q3259564","display_name":"Inpatient care","level":3,"score":0.6496085524559021},{"id":"https://openalex.org/C2780724011","wikidata":"https://www.wikidata.org/wiki/Q1295316","display_name":"Emergency department","level":2,"score":0.5707584619522095},{"id":"https://openalex.org/C512399662","wikidata":"https://www.wikidata.org/wiki/Q3505712","display_name":"Family medicine","level":1,"score":0.4358386695384979},{"id":"https://openalex.org/C2781158071","wikidata":"https://www.wikidata.org/wiki/Q55379489","display_name":"Primary care physician","level":3,"score":0.4297696352005005},{"id":"https://openalex.org/C2989236134","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Patient care","level":2,"score":0.4297577142715454},{"id":"https://openalex.org/C2994511739","wikidata":"https://www.wikidata.org/wiki/Q336641","display_name":"Emergency physician","level":3,"score":0.4289044141769409},{"id":"https://openalex.org/C2909321700","wikidata":"https://www.wikidata.org/wiki/Q181600","display_name":"Outpatient visits","level":3,"score":0.42384785413742065},{"id":"https://openalex.org/C545542383","wikidata":"https://www.wikidata.org/wiki/Q2751242","display_name":"Medical emergency","level":1,"score":0.42086803913116455},{"id":"https://openalex.org/C2777267654","wikidata":"https://www.wikidata.org/wiki/Q3519023","display_name":"Test (biology)","level":2,"score":0.4120938777923584},{"id":"https://openalex.org/C194828623","wikidata":"https://www.wikidata.org/wiki/Q2861470","display_name":"Emergency medicine","level":1,"score":0.39969152212142944},{"id":"https://openalex.org/C2984752397","wikidata":"https://www.wikidata.org/wiki/Q3259956","display_name":"Primary care","level":2,"score":0.3436529040336609},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.2725932002067566},{"id":"https://openalex.org/C118552586","wikidata":"https://www.wikidata.org/wiki/Q7867","display_name":"Psychiatry","level":1,"score":0.1512291431427002},{"id":"https://openalex.org/C159110408","wikidata":"https://www.wikidata.org/wiki/Q121176","display_name":"Nursing","level":1,"score":0.1392127275466919},{"id":"https://openalex.org/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.4018/978-1-61520-905-7.ch007","doi":"https://doi.org/10.4018/978-1-61520-905-7.ch007","is_oa":false,"landing_page_url":"https://doi.org/10.4018/978-1-61520-905-7.ch007","pdf_url":null,"source":{"id":"https://openalex.org/S4210233881","display_name":"Advances in medical technologies and clinical practice book series","issn_l":"2327-9354","issn":["2327-9354","2327-9370"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advances in Medical Technologies and Clinical Practice","raw_type":"book-chapter"},{"id":"doi:10.4018/9781615209057.ch007","doi":"https://doi.org/10.4018/9781615209057.ch007","is_oa":false,"landing_page_url":"https://doi.org/10.4018/9781615209057.ch007","pdf_url":null,"source":{"id":"https://openalex.org/S4306463409","display_name":"IGI Global eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/P4310320424","host_organization_name":"IGI Global","host_organization_lineage":["https://openalex.org/P4310320424"],"host_organization_lineage_names":["IGI Global"],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Clinical Data Mining for Physician Decision Making and Investigating Health Outcomes","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Good health and well-being","id":"https://metadata.un.org/sdg/3","score":0.46810001134872437}],"sustainable_development_goals_aurora":[{"display_name":"Good health and well-being","id":"https://metadata.un.org/sdg/3","score":0.75}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":15,"referenced_works":["https://openalex.org/W28754331","https://openalex.org/W205842318","https://openalex.org/W560959966","https://openalex.org/W1975314381","https://openalex.org/W1978769487","https://openalex.org/W1980158318","https://openalex.org/W1997402220","https://openalex.org/W2070212101","https://openalex.org/W2078361216","https://openalex.org/W2155719878","https://openalex.org/W2336740718","https://openalex.org/W2416269758","https://openalex.org/W2441542402","https://openalex.org/W2468309171","https://openalex.org/W4239921820"],"related_works":["https://openalex.org/W2477351763","https://openalex.org/W193209607","https://openalex.org/W4407242080","https://openalex.org/W2213916160","https://openalex.org/W2405125512","https://openalex.org/W1971885534","https://openalex.org/W1975359639","https://openalex.org/W3136131876","https://openalex.org/W2476961552","https://openalex.org/W1599164315"],"abstract_inverted_index":{"If":[0,116],"we":[1,11,23,92,105],"want":[2,173],"to":[3,13,25,41,50,60,68,72,84,97,111,137,174,212],"gain":[4],"a":[5,37,42,61,117,122,134,157,167,181,184],"complete":[6],"picture":[7],"of":[8,30,89,101,107,114,126,166,180,191],"patient":[9,16,70,169],"treatment,":[10],"need":[12,24],"examine":[14,112],"all":[15,189],"encounters":[17],"with":[18,36,55],"the":[19,73,86,102,138,143,164,177],"medical":[20],"profession.":[21],"Then,":[22],"divide":[26],"them":[27],"into":[28],"episodes":[29,109],"care.":[31,115],"For":[32],"example,":[33],"an":[34,79,127,150],"encounter":[35],"physician":[38,118,144,194],"might":[39],"lead":[40,49,67],"laboratory":[43],"test,":[44],"which":[45,76],"in":[46],"turn":[47],"could":[48,66,77],"inpatient":[51,80,128,139,151],"(or":[52],"outpatient)":[53],"surgery":[54],"additional":[56],"follow":[57,135],"up":[58,136],"visits":[59,71],"physician.":[62],"A":[63],"chronic":[64],"condition":[65],"multiple":[69],"emergency":[74],"department,":[75],"become":[78],"stay.":[81],"In":[82],"order":[83],"determine":[85],"total":[87],"cost":[88,179],"such":[90,206],"episodes,":[91],"must":[93],"first":[94],"be":[95],"able":[96],"define":[98],"them.":[99],"One":[100],"major":[103],"ways":[104],"have":[106],"defining":[108],"is":[110,131,154,203],"dates":[113],"visit":[119,145],"occurs":[120,146],"within":[121],"week":[123],"or":[124,160],"two":[125],"event,":[129,152],"it":[130,153,161],"very":[132],"likely":[133,155],"treatment.":[140],"However,":[141],"if":[142],"several":[147],"months":[148],"after":[149],"for":[156,205],"general":[158],"checkup,":[159],"may":[162],"mark":[163],"start":[165],"new":[168],"episode.":[170],"We":[171],"also":[172],"look":[175],"at":[176],"overall":[178],"disease":[182],"over":[183],"year\u2019s":[185],"time":[186],"period":[187],"given":[188],"requirements":[190],"that":[192],"treatment:":[193],"visits,":[195],"medications,":[196],"lab":[197],"tests,":[198],"and":[199],"hospitalizations.":[200],"The":[201],"MEPS":[202],"ideal":[204],"analyses.Request":[207],"access":[208],"from":[209],"your":[210],"librarian":[211],"read":[213],"this":[214],"chapter's":[215],"full":[216],"text.":[217]},"counts_by_year":[],"updated_date":"2026-10-27T15:51:10.671819","created_date":"2016-08-23T00:00:00"}