| Table of Contents |
|---|
General
...
- DLS.healthcare_service_licenses register is managed by NHS: when new data inserts - previous should be cleared. Register must contain only actual license statuses for healthcare services.
- NHS sets license statuses for healthcare services selected from healthcare_services table (see table specs)
- Data in register should be updated at least once in twenty-four hours
- eHealth performs replication of healthcare_service_licenses table from DLS to PRM database, saving statuses in PRM.licensed_healthcare_services table, log history on PRM.
- PRM.licensed_healthcare_services table isn't clears. The new records are inserts, existing - updates.
...
| Field name | Type | M/O | Description |
|---|---|---|---|
healthcare_service_id | uuid | M | Identifier of the healthcare service in eHealth as primary key. Corresponds to prm.healthcare_services.id (see table specs) |
license_status | varchar(50) | M | Status of the license for healthcare service in the division of the legal entity with MSP or PHARMACY license type. Allowed values: ACTIVE, INACTIVE |
inserted_at | timestamp | M | Date of data insert. Sets automatically |
...
Once in N interval (where N - cron value of DLS_HEALTHCARE_SERVICE_LICENSES_SCHEDULE parameter), Processor app selects all records from PRM.healthcare_service_licenses table. Each entry should be processed with next logic:
- Search healthcare service in PRM.licensed_healthcare_services table by healthcare_service_id:
- If not found - insert new record. Set all fields in PRM.licensed_healthcare_services.
- if found - update PRM.licensed_healthcare_service.status.
- Log status history to PRM.licensed_healthcare_services_status_history table
Influence
TBD