Provide tables detailing Data Source -> Class of data ->Table name for each Table

[tompollard]

As you may know, Scientific Data provides full structured metadata records to document the provenance, manner of generation, and location in public repositories of the datasets linked to our Data Descriptors.

I have begun to look at your article, but in order to proceed I require the following information.

Please provide tables detailing Data Source -> Class of data ->Table name for each Table in the PhysioNet archive.

Data Source will be one of the sources listed in 'database development', ie. one of:

1. archives from critical care information systems
2. hospital electronic health record databases
3. Social Security Administration Death Master File

'Class of data' will be as listed in Table 3 and 'Table name' as listed in Table 4.

Each 'class of data' may have several 'Data Sources' and each 'Table name' may contain several 'classes of data'.

[alistairewj]

What if it's more than one?

Table	Primary source	Secondary Source
ADMISSIONS	hospital electronic health record databases
CALLOUT	hospital electronic health record databases
CAREGIVERS	archives from critical care information systems
CHARTEVENTS	archives from critical care information systems
CPTEVENTS	hospital electronic health record databases
D_CPT	?Other - publicly available dictionary
D_ICD_DIAGNOSES	?Other - publicly available dictionary
D_ICD_PROCEDURES	?Other - publicly available dictionary
D_ITEMS	archives from critical care information systems
D_LABITEMS	hospital electronic health record databases
DATETIMEEVENTS	archives from critical care information systems
DIAGNOSES_ICD	hospital electronic health record databases
DRGCODES	hospital electronic health record databases
ICUSTAYS	hospital electronic health record databases
INPUTEVENTS_CV	archives from critical care information systems
INPUTEVENTS_MV	archives from critical care information systems
OUTPUTEVENTS	archives from critical care information systems
LABEVENTS	hospital electronic health record databases
MICROBIOLOGYEVENTS	hospital electronic health record databases
NOTEEVENTS	archives from critical care information systems	hospital electronic health record databases
PATIENTS	hospital electronic health record databases	Social Security Administration Death Master File
PRESCRIPTIONS	hospital electronic health record databases
PROCEDUREEVENTS_MV	archives from critical care information systems
PROCEDURES_ICD	hospital electronic health record databases
SERVICES	hospital electronic health record databases
TRANSFERS	hospital electronic health record databases

[tompollard]

How about this?

Table	Class	Source/s
ADMISSIONS	Descriptive	Hospital electronic health record databases
CALLOUT	Descriptive	Hospital electronic health record databases
CAREGIVERS	Descriptive	Archives from critical care information systems
CHARTEVENTS	Physiologic, interventions	Archives from critical care information systems
CPTEVENTS	Billing	Hospital electronic health record databases
D_CPT	Dictionary	High level description of the dictionary available from the American Medical Association
D_ICD_DIAGNOSES	Dictionary	Dictionary available from the Centers for Medicare & Medicaid Services
D_ICD_PROCEDURES	Dictionary	Dictionary available from the Centers for Medicare & Medicaid Services
D_ITEMS	Dictionary	Archives from critical care information systems
D_LABITEMS	Dictionary	Hospital electronic health record databases
DATETIMEEVENTS	Interventions	Archives from critical care information systems
DIAGNOSES_ICD	Billing	Hospital electronic health record databases
DRGCODES	Billing	Hospital electronic health record databases
ICUSTAYS	Descriptive	Hospital electronic health record databases
INPUTEVENTS_CV	Medications	Archives from critical care information system (Philips CareVue)
INPUTEVENTS_MV	Medications	Archives from critical care information system (iMDsoft MetaVision)
OUTPUTEVENTS	Physiologic	Archives from critical care information systems
LABEVENTS	Laboratory	Hospital electronic health record databases
MICROBIOLOGYEVENTS	Laboratory	Hospital electronic health record databases
NOTEEVENTS	Notes and reports	Archives from critical care information systems; hospital electronic health record databases
PATIENTS	Descriptive	Hospital electronic health record databases; Social Security Administration Death Master File
PRESCRIPTIONS	Medications	Hospital electronic health record databases
PROCEDUREEVENTS_MV	Interventions	Archives from critical care information system (iMDsoft MetaVision)
PROCEDURES_ICD	Billing	Hospital electronic health record databases
SERVICES	Descriptive	Hospital electronic health record databases
TRANSFERS	Descriptive	Hospital electronic health record databases

[alistairewj]

Most looks good - maybe physiologic is the wrong term? Because a lot of it is non-physiologic like treatment, cuff pressures, restraints, etc.

On Fri, Apr 29, 2016 at 1:33 PM, Tom Pollard notifications@github.com wrote:

How about this? Table Class Source/s ADMISSIONS Descriptive Hospital electronic health record databases CALLOUT Descriptive Hospital electronic health record databases CAREGIVERS Descriptive Archives from critical care information systems CHARTEVENTS Physiologic Archives from critical care information systems CPTEVENTS Procedure and billing Hospital electronic health record databases D_CPT Dictionary High level description of the dictionary available from the American Medical Association D_ICD_DIAGNOSES Dictionary Dictionary available from the Centers for Medicare & Medicaid Services D_ICD_PROCEDURES Dictionary Dictionary available from the Centers for Medicare & Medicaid Services D_ITEMS Dictionary Archives from critical care information systems D_LABITEMS Dictionary Hospital electronic health record databases DATETIMEEVENTS Physiologic Archives from critical care information systems DIAGNOSES_ICD Procedure and biling Hospital electronic health record databases DRGCODES Procedure and biling Hospital electronic health record databases ICUSTAYS Descriptive Hospital electronic health record databases INPUTEVENTS_CV Medications Archives from critical care information system (Philips CareVue) INPUTEVENTS_MV Medications Archives from critical care information system (iMDsoft MetaVision) OUTPUTEVENTS Physiologic Archives from critical care information systems LABEVENTS Laboratory Hospital electronic health record databases MICROBIOLOGYEVENTS Laboratory Hospital electronic health record databases NOTEEVENTS Notes and reports Archives from critical care information systems; hospital electronic health record databases PATIENTS Descriptive Hospital electronic health record databases; Social Security Administration Death Master File PRESCRIPTIONS Medications Hospital electronic health record databases PROCEDUREEVENTS_MV Procedure and billing Archives from critical care information system (iMDsoft MetaVision) PROCEDURES_ICD Procedure and billing Hospital electronic health record databases SERVICES Descriptive Hospital electronic health record databases TRANSFERS Descriptive Hospital electronic health record databases

— You are receiving this because you commented. Reply to this email directly or view it on GitHub https://github.com/MIT-LCP/mimic-iii-paper/issues/20#issuecomment-215824361

[tompollard]

Physiologic is one of the terms that we used to describe the classes of data in MIMIC (Table 3), but I agree it doesn't feel quite right sometimes (particularly for DATETIMEEVENTS and OUTPUTEVENTS). Can you think of any additional/alternative terms? e.g. 'Physiologic and interventions' or 'Physiologic and treatments'...

[tompollard]

Update Table 3 in proofs:

• Split 'procedure and billing' into intervention and billing.

[tompollard]

This issue is dealt with as part of https://github.com/MIT-LCP/mimic-iii-paper/issues/21