ecls_blood_pump
This table stores information about the blood pumps in use.
Column name | Required | Data Type |
---|---|---|
blood_pump_id | True | integer, generated always as identity |
start_datetime | True | timestamptz |
stop_datetime | (True) | timestamptz |
person_id | True | integer |
stop_reason_concept_id | (True) | integer |
material_id | True | integer |
sn | text | |
lot | text | |
ref | text | |
udi | text |
.blood_pump_id
The primary key column.
.start_datetime
The date and time when the blood pump was started.
.stop_datetime
The date and time when the blood pump was removed.
Info
Blood pumps are usually not changed in a running circuit. So they typically have the same start_datetime and stop_datetime as the corresponding circuit.
.person_id
The foreign key to the person table.
.stop_reason_concept_id
The foreign key to the concept table.
Store information, as to why the blood pump was stopped.
Allowed concepts:
concept_id | concept_name | comment |
---|---|---|
4149524 | Patient's condition improved | |
40483850 | Treatment changed | Indicating that the blood pump was not necessary anymore. |
434489 | Dead | |
4154766 | Moribund | |
36717814 | Acute obstruction to extracorporeal blood flow | |
36717815 | Increasing resistance to extracorporeal blood flow | |
36717816 | Air in extracorporeal life support circuit or component | |
36717819 | Accidental dislodgement of extracorporeal life support component | |
36717823 | Coagulopathy caused by extracorporeal life support blood pump | |
36717828 | Hemolysis caused by extracorporeal life support blood pump | |
36717833 | Blood clot in extracorporeal life support blood pump | |
36717839 | Extracorporeal life support blood pump failure | Should be used for technical malfunctions, where none of the other concepts fit. |
36717844 | Impaired structural integrity of extracorporeal life support circuit or component | |
44790553 | Following protocol | If the center demands a change/stop of the component, use this concept. |
36717877 | End of product life-cycle |
.material_id
The foreign key to the ecls_blood_pump_material table.
.sn
If applicable, the serial number of the blood pump.
.lot
If applicable, the lot number of the blood pump.
.ref
If applicable, the reference number of the blood pump. This is usually the manufacturer's internal model number.
.udi
If applicable, the whole data matrix/bar code of the Unique Device Identifier, consisting of UDI-DI + UDI-PI.