Schema
Resources
Device definition
Table name: device_definitions
Name | Type | M/O | Description and constraints |
|---|---|---|---|
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: |
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: |
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: |
packaging_count | int | M | The number of items contained in the package |
packaging_unit | varchar(255) | M | Dictionary: |
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 |
Device definition names
Table name: device_definition_names
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | Unique record identifier |
device_definition_id | uuid | M | Reference to device definition |
type | varchar(255) | M | Device name type. Dictionary |
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 |
Program device
Table name: program_devices
Name | Type | M/O | Description and constraints |
|---|---|---|---|
id | uuid | M | Unique identifier in the system |
reimbursement_type | varchar(255) | M | Dictionary: |
reimbursement_percentage_discount | float | O | Applicable only if type |
reimbursement_amount | float | O | Applicable only if type |
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 |