MIMIC II V2.6 - Table-MIMIC2V26.D_CODEDITEMS

Main Tables Materialized Views Indexes Constraints DDL scrips

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.D_CODEDITEMS

Description:

Items with an attached code; may be used in DRGEVENTS, MICROBIOLOGYEVENTS, or PROCEDUREEVENTS, depending on the type.

Columns

Name	Type	Nullable	Default value	Comment
ITEMID	NUMBER(7)	N		Table-unique identifier: the item ID.
CODE	VARCHAR2(10)	Y		Code for the item; meaning and interpretation depend on the category; not necessarily unique.
TYPE	VARCHAR2(12)	Y		The type of the item; indicates whether it appears in DRGEVENTS, MICROBIOLOGYEVENTS, or PROCEDUREEVENTS.
CATEGORY	VARCHAR2(13)	Y		A broad grouping of the items within a type.
LABEL	VARCHAR2(100)	Y		The name of the item (a short description).
DESCRIPTION	VARCHAR2(100)	Y		Comments/description about the item.

Primary key:

Constraint Name	Columns
MIMIC2V26.D_CODEDITEMS_PK	ITEMID

Options:

Option	Settings
Tablespace	MIMIC2_DAT
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
MIMIC2V26.D_CODEDITEMS_PK	NORMAL	UNIQUE	ITEMID	DDL script

Referenced by:

Table	Constraint
MIMIC2V26.DRGEVENTS	MIMIC2V26.DRGEVENTS_FK_ITEMID
MIMIC2V26.MICROBIOLOGYEVENTS	MIMIC2V26.MICROBIOEV_AB_FK_D_CODED
MIMIC2V26.MICROBIOLOGYEVENTS	MIMIC2V26.MICROBIOEV_ORG_FK_D_CODED
MIMIC2V26.MICROBIOLOGYEVENTS	MIMIC2V26.MICROBIOEV_SPEC_FK_D_CODED
MIMIC2V26.PROCEDUREEVENTS	MIMIC2V26.PROCEDUREEVENTS_FK_D_CODED