ecls_console
This table stores information about the console(s) in use (e.g., Cardiohelp, Rotaflow, Stöckert, etc.).
Column name | Required | Data Type |
---|---|---|
console_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 |
.console_id
The primary key.
.start_datetime
Use the date and time when the console was started.
Circuit components
A console, blood pump and temperature regulation device are usually only present once in a circuit and seldomly changed without exchanging the whole circuit. Make sure to set the correct timestamps.
.stop_datetime
Use the date and time when the last cannula was removed. This timestamp should be the same for the last cannula.
.person_id
The foreign key to the person table.
.stop_reason_concept_id
The foreign key to the concept table.
Record the reason why the console was stopped.
Refer to Stop reasons for details on stopping the run, circuit and/or component properly.
.material_id
The foreign key field to the ECLS CDM ecls_console_material table.
.sn
If applicable, the serial number of the console.
.lot
If applicable, the lot number of the console.
.ref
If applicable, the reference number of the console. 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.