ЕСОЗ - публічна документація

Program device data model_EN

Schema

Resources

Program device

Table name: program_devices

Name

Type

M/O

Description and constraints

Name

Type

M/O

Description and constraints

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

care_plan_activity_allowed

boolean

M

Available for care plan activity

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

ЕСОЗ - публічна документація