Multicenter Sepsis Database(MSD):
Based on Real-world Clinical Data

Patient_ID

The patient's current visit ID directly links to various sub-tables.

PAADMDR

The patient's primary index.

OrderNoHis

The number of hospitalizations for the patient.

PAsex

Patient's gender.

PABirthDay

Patient's date of birth.

PAAgeYear

Patient's age.

PATransHosp

The patient's transfer records.

PANationDesc

Patient's ethnicity.

PABeInDesc

Admission Condition (1: Critical, 2: Urgent, 3: General)

PADInDate

Admission Date.

PADDisDate

Discharge Date.

PAAgeYear

Patient's age.

PAInLocDesc

Admission Department.

PAOutLocDesc

Discharge Department.

PADeathDate

Date of Death.

TransCountReal

Indicates if there was a transfer out: 0 if transferred, 1 if no transfer (representing actual discharge count)

CheckBlood

Blood Transfusion Check

HospInfect

Hospital-Acquired Infection.

BloodTypeABO

Blood Type (1: A, 2: B, 3: AB, 4: O, 5: Other, 6: Not Checked).

BloodTypeRh

Rh Blood Type.

InfusionRBC

Red Blood Cell Infusion.

InfusionPLT

Platelet Infusion.

InfusionPLA

BPlasma Infusion.

InfusionAllOrig

Whole Blood Infusion.

Infusion0ther

Other Infusions.

Patient_ID

The patient's current visit ID directly links to various sub-tables.

Diag_ID

Patient diagnosis ID.

DiagDesc

Diagnostic name, corresponding to standard ICD-10.

DiagCode

Diagnostic code, corresponding to standard ICD-10.

DiagType

the type of diagnosis of the patient, admission diagnosis, discharge diagnosis.

DiagDate

The time when the doctor made the diagnosis.

Drug_ID

Unique Medication Usage Table ID.

Patient_ID

The patient's current visit ID directly links to various sub-tables.

OrdLocDesc

Pharmacy Department.

DrugName

Medication Name.

Doscification

Medication Specification.

Rouage

Medication Dosage.

Frequency

Medication Frequency.

PrescriptionStartDate

Prescription Date.

PrescriptionStopDate

Discontinuation Date.

Qutantity

Total Medication Quantity.

Ops_ID

Patient Surgery Unique ID.

Patient_ID

The patient's current visit ID directly links to various sub-tables.

SurgType

Surgical Procedure Type, including Day Surgery and Scheduled Surgery.

IncisionDR

Incision Type: 1 - Class I Incision, 2 - Class II Incision, 3 - Class III Incision, 4 - Other, 5 - Class 0 Incision.

HealingDR

Incision Healing Type: 1 - Grade A Healing, 2 - Grade B Healing, 3 - Grade C Healing, 4 - Not Healed, 5 - Other.

OpCode

Patient Surgery Code, corresponding to standard ICD-9 Procedure Code.

OpName

Patient Surgery Name, corresponding to standard ICD-9 Procedure Name.

OpDate

Patient Surgery Date.

Lab_ID

Unique ID for Laboratory Test.

Patient_ID

The patient's current visit ID directly links to various sub-tables.

LabItemCode

Laboratory Test Code.

LabItemName

Laboratory Test Name.

LabReference

Reference Range for Test Value.

SpecimenSiteCode

Sample Collection Code.

SpecimenSiteName

Sample Collection Name.

LabValue

Laboratory Test Results.

LabDate

Laboratory Test Date.

Labunit

Units for Laboratory Test Items.

AbnormalFlags

Abnormal Flag for Laboratory Test Results.

Check_ID

Unique ID for Patient Examination.

Patient_ID

The patient's current visit ID directly links to various sub-tables.

CheckItemCode

Examination Item Code.

ChecItemName

Examination Item Name.

CheckDate

Examination Date.

CheckDescribe

The imaging findings and textual descriptions play a crucial role during the examination process.

CheckResults

Imaging examination results.

CheckType

Types of examinations, such as CT, MRI, etc.