Events indicating microbiology tests taken from a patient.
| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | Y | | The patient for the microbiology event. |
| HADM_ID | NUMBER(7) | Y | | The hospital admission. |
| CHARTTIME | TIMESTAMP(6) WITH TIME ZONE | Y | | The charted time for the microbiology event. |
| SPEC_ITEMID | NUMBER(7) | Y | | The item identifier for the specimen tested. |
| ORG_ITEMID | NUMBER(7) | Y | | The item identifier for the organism tested. |
| ISOLATE_NUM | NUMBER(38) | Y | | The isolate number for the test. |
| AB_ITEMID | NUMBER(7) | Y | | The item identifier for the antibacterium used. |
| DILUTION_AMOUNT | VARCHAR2(72) | Y | | The dilution amount tested for. |
| DILUTION_COMPARISON | VARCHAR2(10) | Y | | The comparison used against the given dilution amount, for the test: either <= (less than or equal), = (equal), or >= (greater than or equal), or null when not available. |
| INTERPRETATION | VARCHAR2(1) | Y | | The interpretation of the test: R, P, I, or S (or null when not available). |
