Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

General

License verification used for healthcare services linked with divisions that relates to legal entities with MSP or PHARMACY license type. The special register is used as source for the license verification - service_license table in DLS (DataLicenseStorage) database. Each insert/update event triggers replication app which replicates this data to eHealth PRM database. After that Processor app starts and perform actions in eHealth described below.

...

  • DLS.service_license 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 replicatiaon replication of service_license 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 nameTypeM/ODescription
iduuidMUnique identifier of the table record. Sets automatically 

healthcare_service_id

uuidM

Identifier of the healthcare service in eHealth. 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

timestampMDate of data insert. Sets automatically 

...

  1. 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.statusIf it status has INACTIVE value - also set PRM.licensed_healthcare_service.is_active = False.
  2. Log status history

Influence

TBD