| Status | ||||||
|---|---|---|---|---|---|---|
|
...
| Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ||
| name | varchar(255) | O | DEPRECATED | |
| short_name | varchar(255) | O | DEPRECATED | |
| public_name | varchar(255) | O | DEPRECATED | |
| owner_property_type | varchar(255) | O | DEPRECATED | |
| legal_form | varchar(255) | O | DEPRECATED | |
| kveds | jsonb | O | DEPRECATED | |
| registration_address | jsonb | O | object Addresses | DEPRECATED |
| edr_data_id | uuid | M | FK(edr_data) | |
| type | varchar | M | Dictionary LEGAL_ENTITY_TYPE PRIMARY_CARE, OUTPATIENT, EMERGENCY, PHARMACY MSP, MSP_PHARMACY (could not be created or updated in e-Health, should be processed as PRIMARY_CARE, then should be deprecated) | |
| edrpou | varchar | M | ||
| accreditation | jsonb | O | array of object /wiki/spaces/EB/pages/582811690accreditation | |
| residence_address | jsonb | O | object Addresses | |
| phones | jsonb | M | array of object Phones | |
| varchar | M | |||
| is_active | boolean | M | ||
| website | varchar | O | ||
| receiver_funds_code | varchar | O | ||
| archive | jsonb | O | array of object Table specs#available_time | |
| created_by_mis_client_id | uuid | O | ||
| nhs_verified | boolean | M | ||
| nhs_reviewed | boolean | M | ||
| inserted_at | timestamp | M | ||
| inserted_by | uuid | M | ||
| updated_at | timestamp | M | ||
| updated_by | uuid | M | ||
| license_id | uuid | O | FK(licenses) | |
| status | boolean | M | active, closed, suspended, reorganised | |
| status_reason | varchar | O | ||
| nhs_verified_change_date | timestamp | O |
...
| Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ||
| legal_entity_id | uuid | M | reference to legal entity | |
| division_id | uuid | M | reference to division | |
| speciality_type | varchar | M | Dictionary: speciality_type | |
| providing_conditions | varchar | M | Dictionary: INPATIENT, OUTPATIENT, HOME, FIELD | |
| category | [uuid] | O | array of references to service_group with parent_group_id = null | No Implementation yet |
| type | [uuid] | O | array of references to array of references to service_group with no grandparents | No Implementation yet |
| status | varchar | M | ACTIVE, INACTIVE Available transitions: Active → Inactive Inactive → Active | |
| coverage_area | [uuid] | O | array of references to divisions | No Implementation yet |
| comment | varchar | O | ||
| available_time | jsonb | O | array of object Table specs#available_time | |
| restricted_periods | jsonb | O | object Table specs#restricted_periods | |
| is_active | boolean | M | by default = true | |
| inserted_at | timestamp | M | ||
| inserted_by | uuid | M | ||
| updated_at | timestamp | M | ||
| updated_by | uuid | M |
...
| Name | Type | M/O | Description and constraints | Status |
|---|---|---|---|---|
| id | uuid | M | ok | |
| status | varchar | M | active, inactive Available transitions: Active → Inactive Inactive → Active | ok |
| type | jsonb | M | object CodeableConcept | ok |
| external_id | varchar | M | Not in FHIR, ok | |
| division_id | uuid | M | reference to division | ok |
| legal_entity_id | uuid | M | reference to legal entity | ok |
| udi | jsonb | O | array of objects. Contains unique identifiers assigned to the asset by the manufacturer (like IMEI for phones) Object fields:
| ok |
| lot_number | varchar | O | ok | |
| manufacturer | varchar | O | ok | |
| manufacture_date | date | O | date | ok |
| expiration_date | date | O | date | ok |
| model_number | varchar | O | ok | |
| part_number | varchar | O | ok | |
| version | varchar | O | ok | |
| name | varchar | O | ok | |
| serial_number | varchar | O | ok | |
| note | varchar | O | ok | |
| is_active | boolean | M | by default = true | ok |
| inserted_at | timestamp | M | ok | |
| inserted_by | uuid | M | ok | |
| updated_at | timestamp | M | ok | |
| updated_by | uuid | M | ok |
...
| Name | Type | M/O | Description and constraints |
|---|---|---|---|
| days_of_week | [varchar] | M | values: mon | tue | wed | thu | fri | sat | sun |
| all_day | boolean | O | |
| available_start_time | varchar | O | |
| available_end_time | varchar | O |
...