| Table of Contents |
|---|
...
eHealth description
INNMS
Table name: innms
Name | Type | Description and constraints |
|---|---|---|
id | uuid | Identifier in the system |
sctid | varchar(255) | Identifier of the INN of the medicinal product according to SNOMED |
name | varchar(255) | Name |
name_original | varchar(255) | Original title |
is_active | bool | Active in the system |
inserted_by | uuid | Identifier of the person who made the entry in the system |
updated_by | uuid | Identifier of the person who edited the entry in the system |
inserted_at | timestamp | When an entry was made to the system |
updated_at | timestamp | When it was updated |
Dosage of INNM in INNM_DOSAGE, dosage of INNM_DOSAGE in BRAND
Table name: prm.ingredients
Name | Type | Description and constraints | Dosage of INNM in INNM_DOSAGE | Dosage of INNM_DOSAGE in BRAND |
|---|---|---|---|---|
id | uuid | Identifier in the system | ✅ | ✅ |
dosage | jsonb | Dosage | ✅ | ✅ |
is_primary | bool | The main ingredient | ✅ | ✅ |
medication_child_id | uuid | INNM_DOSAGE is a part of BRAND |
| ✅ |
innm_child_id | uuid | INNM is a part of INNM_DOSAGE | ✅ |
|
parent_id | uuid | BRAND ID or INNM_DOSAGE ID, which located in medications table. | ✅ | ✅ |
inserted_at | timestamp | When an entry was made to the system | ✅ | ✅ |
updated_at | timestamp | When it was updated | ✅ | ✅ |
INNM_DOSAGE and BRAND
Table name: prm.medications
Name | Type | Description and constraints | INNM_DOSAGE | BRAND |
|---|---|---|---|---|
id | uuid | Identifier in the system | ✅ | ✅ |
name | varchar(255) | The name of the BRAND of INNM_DOSAGE | ✅ | ✅ |
type | varchar(255) | Type of the record: BRAND or INNM_DOSAGE | ✅ | ✅ |
manufacturer | jsonb | Manufacturer's data set: Name Country |
| ✅ |
code_atc | jsonb | ATX code |
| ✅ |
is_active | bool | Active in the system | ✅ |
|
form | varchar(255) | Release form | ✅ |
|
container | jsonb | Information about primary package of the Brand |
| ✅ |
package_qty | int4 | Quantity in the package |
| ✅ |
package_min_qty | int4 | Minimum quantity available for sale |
| ✅ |
certificate | varchar(255) | Certificate |
| ✅ |
certificate_expired_at | date | Expiration date of the certificate |
| ✅ |
inserted_by | uuid | Identifier of the person who made the entry in the system | ✅ | ✅ |
updated_by | uuid | Identifier of the person who edited the entry in the system | ✅ | ✅ |
inserted_at | timestamp | When an entry was made to the system | ✅ | ✅ |
updated_at | timestamp | When it was updated | ✅ | ✅ |
daily_dosage | float8 | Daily dose of the drug | ✅ |
|
max_daily_dosage | float8 | The maximum allowable daily dose of the drug | ✅ |
|
max_request_dosage | int2 | The maximum dose of the drug within one prescription |
| ✅ |
mr_blank_type | varchar(64) | Type of prescription form. F-1 or F-3. | ✅ |
|
dosage_form_is_dosed | bool | Indication of dosage of the dosage form | ✅ |
|
form_pharm | varchar(255) | Pharmaceutical form |
| ✅ |
drlz_sku_id | varchar(255) | identifier of a product out of external DRLZ register |
| ✅ |
Medical program
Table name: prm.medical_programs
Name | Type | Description and constraints |
|---|---|---|
id | uuid | Identifier in the system |
name | varchar(255) | Name of the medical program |
is_active | bool | Active in the system |
inserted_by | uuid | Identifier of the person who made the entry in the system |
updated_by | uuid | Identifier of the person who edited the entry in the system |
inserted_at | timestamp | When an entry was made to the system |
updated_at | timestamp | When it was edited |
type | text | Type of medical program. Fetches from a dictionary MEDICAL_PROGRAM_TYPE |
medication_request_allowed | bool | It is allowed to issue a Medication request |
medication_dispense_allowed | bool | Dispense of Medication request is allowed |
medication_request_allowed_text | text | Comment for Medication request option |
medication_dispense_allowed_text | text | Comment for Medication dispense option |
medical_program_settings | jsonb | List of medical program settings |
medical_program_settings_text | text | Comment on the settings of the medical program |
funding_source | varchar(255) | Source of funding. Fetches from a dictionary FUNDING_SOURCE |
mr_blank_type | varchar(64) | The type of prescription blank (F-1 or F-3) which is mandatory for INNM_DOSAGE of a BRAND to be a participant in Medical Program. Fetches from a dictionary MR_BLANK_TYPES. |
Program medication
Table name: program_medications
Name | Type | Description and constraints |
|---|---|---|
id | uuid | Identifier in the system |
reimbursement | jsonb | Setting up compensation for a program participant
|
is_active | bool | Active in the system |
medication_request_allowed | bool | Available for prescription |
inserted_by | uuid | Identifier of the person who made the entry in the system |
updated_by | uuid | Identifier of the person who edited the entry in the system |
medication_id | uuid | BRAND identifier |
medical_program_id | uuid | Medical program identifier |
inserted_at | timestamp | When an entry was made to the system |
updated_at | timestamp | When it was updated |
wholesale_price | float8 | Wholesale selling price per package |
consumer_price | float8 | Retail price per package |
reimbursement_daily_dosage | float8 | The daily dose of the drug to be compensated |
estimated_payment_amount | float8 | The amount of surcharge for packaging |
start_date | date | Date of entry into force of the register |
end_date | date | Registry expiration date |
registry_number | varchar(255) | Registration number |
max_daily_dosage | float8 | The maximum allowable daily dose of the medication |