Development of a real-world database for asthma and COPD: The SingHealth-Duke-NUS-GSK COPD and Asthma Real-World Evidence (SDG-CARE) collaboration

Table 1 SingHealth COPD and Asthma Data Mart (SCDM) Folders

No	Folder
1	Master List¹
2	Patient Demographics
3	Problem List²
4	Laboratory Results
5	Radiology Reports
6	Medications Prescribed
7	Medications Dispensed
8	Visit Details³
9	Diagnosis⁴
10	Rescue Therapy⁵
11	Referrals⁶
12	Clinical Document Metadata
13	Patient History⁷
14	Objective Diagnosis
15	Asthma Control Test
16	COPD Assessment Test
17	Modified Medical Research Council Dyspnea Scale
18	GOLD Score
19	Physical Measurements
20	Physical Examination⁷
21	Peak Expiratory Flow Rate
22	Spirometry Results
23	Smoking Status
24	Vaccination Details⁸
25	Written Asthma Action Plan
26	Management Plan⁷
27	Asthma Counselling
28	Pulmonary Rehabilitation

COPD Chronic obstructive pulmonary disease, GOLD Global Initiative for Obstructive Lung Disease
¹The data extraction is done in a two-step process. Firstly, the Master List is used to extract the ID for patients of interest. Then with this list of IDs, the other subject areas are used to extract the rest of the data elements of interest
²Problem list conditions were based on SNOMED Clinical Terms (SNOMED-CT) coding
³Visits details includes details such as visit date, visit location, and visit provider
⁴Diagnosis conditions were based on 10th revision of the International Classification of Diseases (ICD-10) coding
⁵Rescue therapy is a protocol-based bronchodilator intervention administered at the polyclinic for patients assessed to have asthma exacerbation
⁶Referrals made from SingHealth Polyclinics to tertiary hospitals, including Singapore General Hospital
⁷Patient history, physical examination findings and management plan were captured as free-text data
⁸For influenza and pneumococcal vaccinations only

ISSN: 1472-6947