Adult Inpatient Patient Portal Dataset
Data for 826,843 diagnostic test reports on 40,640 unique patients. Specific data fields include: unique patient identification number (deidentified), number of inpatient admissions in 2018, whether test report was during the initial admission in 2018 or a subsequent admission, specific diagnostic test ordered, diagnostic test category, sex (as officially noted in the electronic health record), patient portal status (active or inactive), whether diagnostic test report was viewed in the patient portal, the most common self-declared race categories, simplified race category (White or non-White), age at time of testing, age category, primary/preferred language (as recorded in electronic health record), primary/preferred language (English on non-English), whether there was a legal proxy that had access to the patient’s portal account, and insurance category (private/commercial or public/uninsured).
Steps to reproduce
Epic Reporting Workbench (RWB), a software tool for retrieving specific data from the Epic electronic health record (EHR), was used to retrieve all diagnostic test orders (pathology/laboratory and radiology) ordered during hospitalization between January 1, 2018 and December 31, 2018 on patients 18 years and older. With each diagnostic test order, the RWB search also retrieved age, sex (male or female), self-identified race, self-identified preferred language, insurance status, prior hospitalization, presence of outpatient lab reports, and whether patient had a proxy that could legally access their patient portal. Race was categorized as White or race other than White (included African-American, American Indian / Alaska Native, Asian, Hispanic/Latino, Mixed Race, Native Hawaiian / Pacific Islander, Other, Unknown and Declined), language as English or Non-English (included a total of 75 other languages with the six most common other than English being Spanish, Arabic, French, Chinese, Swahili and Vietnamese) and insurance as commercial payor or public insurance (Medicare or Medicaid)/uninsured. Data was also analyzed by testing category. Pathology/laboratory tests were categorized as Anatomic Pathology (including surgical biopsies and resections, cytopathology, and dermatopathology), Chemistry (includes toxicology, therapeutic drug monitoring, and clinical chemistry), Hematology, Microbiology, and Send-out (referred to outside reference laboratories). Imaging tests were categorized as computerized tomography (CT) scan, magnetic resonance imaging (MRI), nuclear scans, and X-rays.