id

uuid

M

Unique identifier in the system

external_id

varchar(255)

O

Device identifier in external system

classification_type

varchar(255)

M

A classification or risk class of the device model

Dictionary: device_definition_classification_type

description

varchar(2000)

O

Description of the device

manufacturer_name

varchar(255)

M

Name of device manufacturer

manufacturer_country

varchar(255)

M

Country of manufacture. Dictionary: COUNTRY

model_number

varchar(255)

M

The catalog or model number for the device for example as defined by the manufacturer

part_number

varchar(255)

O

The part number or catalog number of the device

packaging_type

varchar(255)

M

A code that defines the specific type of packaging

Dictionary: device_definition_packaging_type

packaging_count

int

M

The number of items contained in the package

packaging_unit

varchar(255)

M

Dictionary: device_unit

note

varchar(2000)

O

Device notes and comments

is_active

boolean

M

Is record active in the system

inserted_at

timestamp

M

When an entry was added to the system

updated_at

timestamp

M

When it was updated

inserted_by

uuid

M

Identifier of the user who made the entry in the system

updated_by

uuid

M

Identifier of the user who edited the entry in the system

properties

jsonb

O

Array of device properties

Structure: https://e-health-ua.atlassian.net/wiki/spaces/EH/pages/17782014038#Device-definition-property

parent_id

uuid

O

Reference to parent device definition

id

uuid

M

Unique record identifier

device_definition_id

uuid

M

Reference to device definition

type

varchar(255)

M

Device name type. Dictionary device_name_type

name

varchar(255)

M

Device name

inserted_at

timestamp

M

When an entry was added to the system

updated_at

timestamp

M

When it was updated

inserted_by

uuid

M

Identifier of the user who created the entry in the system

updated_by

uuid

M

Identifier of the user who edited the entry in the system

id

uuid

M

Unique identifier in the system

reimbursement_type

varchar(255)

M

Dictionary: REIMBURSEMENT_TYPE

reimbursement_percentage_discount

float

O

Applicable only if type PERCENTAGE

reimbursement_amount

float

O

Applicable only if type FIXED

is_active

boolean

M

Is record active in the system

device_definition_id

uuid

M

Device definition identifier

medical_program_id

uuid

M

Medical program identifier

wholesale_price

float

O

Wholesale selling price per package

consumer_price

float

O

Retail price per package

reimbursement_daily_count

integer

O

The daily count of the device definition to be compensated

estimated_payment_amount

float

O

The amount of surcharge for packaging

max_daily_count

integer

O

The maximum allowable daily quantity of the device

device_request_allowed

boolean

M

Is it allowed to prescribe this device definition

registry_number

varchar(255)

O

Number (version) of reimbursement configuration

start_date

date

M

Date of configuration start

end_date

date

O

Date of configuration end

inserted_at

timestamp

M

When an entry was added to the system

updated_at

timestamp

M

When it was updated

inserted_by

uuid

M

Identifier of the user who made the entry in the system

updated_by

uuid

M

Identifier of the user who edited the entry in the system

type

string

Dictionary device_properties

value[X]:

• value_integer

• value_string

• value_boolean

• value_decimal

Depending on the value:

• integer

• string

• boolean

• number

Only one value[x] could be provided