Schema

mvs integration data model v2.drawio.png

Tables

The tables used in the MVS synchronization process are listed there.

unzr_data

The table in MIMIR db used to store unzr data about person that were received from UNZR registry by means of checkunzr service. Records should not store links to mpi.

Name	Type	M/O	Description
id	uuid	M	Internal eHealth identifier
unzr	string	M	UNZR. It is `UNZR` field from request of checkunzr service
family_name	string	M	Last name of the person. `familyName` field from request of checkunzr service
given_name	string	M	First name of the person. `givenName` field from request of checkunzr service
patronymic_name	string	M	Second name of the person. `patronymicName` field from request of checkunzr service
date_birth	date	M	Birth date of the person. `dateBirth` field from request of checkunzr service
status	smallint	M	Status of the UNZR for a person. `Status` field from response of checkunzr service. Available values: 0 - record not found; 1 - record found; -1 - mandatory fields are not filled in or filled in incorrectly; -2 - internal server error
description	string	M	Description of the status. `Description` field from response of checkunzr service
inserted_at	datetime	M	Date and time the record was created
updated_at	datetime	M	Date and time the record was updated

Assumed unique index on unzr:

create unique index unzr_data_unzr_index
    on unzr_data (unzr);

mvs_passport_data

The table in MIMIR db used to store data about passport documents that were received from registry of stolen and lost ones by means of CheckPassportStatus service. Records should not store links to mpi.

Name	Type	M/O	Description
id	uuid	M	Internal eHealth identifier
pass_type	string	M	Passport type. `PassType` field from request of CheckPassportStatus service. Available values are: 0101 - “Паспорт громадянина України” (PASSPORT, NATIONAL_ID from DOCUMENT_TYPE dict) 0102 - “Паспорт громадянина України для виїзду за кордон” (absent in the DOCUMENT_TYPE dict and won’t be used at the moment)
pas_serial	string	O	Passport serial. `PasSerial` field from request of CheckPassportStatus service Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)
pas_number	string	M	Passport number. `PasNumber` field from request of CheckPassportStatus service
pas_status	smallint	M	Passport status in the register. `PasStatus` field from a response of CheckPassportStatus service. Available values: 0 - record not found; 1 - record found; -1 - mandatory fields are not filled in or filled in incorrectly; -2 - internal server error
inserted_at	datetime	M	Date and time the record was created
updated_at	datetime	M	Date and time the record was updated

Assumed unique index on pass_type, pas_serial, pas_number:

create unique index mvs_passport_data_pass_type_pas_serial_pas_number_index
    on mvs_passport_data (pass_type, pas_serial, pas_number);

dms_passport_data

The table in MIMIR db used to store data about passport documents that were received from registry of invalid ones by means of CheckPassportDMSStatus service. Records should not store links to mpi.

Name	Type	M/O	Description
id	uuid	M	Internal eHealth identifier
pass_type	string	M	Passport type. `PassType` field from request of CheckPassportDMSStatus service. Available values are: 0101 - “Паспорт громадянина України” (PASSPORT, NATIONAL_ID from DOCUMENT_TYPE dict) 0102 - “Паспорт громадянина України для виїзду за кордон” (absent in the DOCUMENT_TYPE dict and won’t be used at the moment)
pas_serial	string	O	Passport serial. `PasSerial` field from request of CheckPassportDMSStatus service Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)
pas_number	string	M	Passport number. `PasNumber` field from request of CheckPassportDMSStatus service
pas_status	smallint	M	Passport status in the register. `PasStatus` field from a response of CheckPassportDMSStatus service. Available values: 0 - record not found; 1 - record found; -1 - mandatory fields are not filled in or filled in incorrectly; -2 - internal server error
inserted_at	datetime	M	Date and time the record was created
updated_at	datetime	M	Date and time the record was updated

Assumed unique index on pass_type, pas_serial, pas_number:

create unique index dms_passport_data_pass_type_pas_serial_pas_number_index
    on dms_passport_data (pass_type, pas_serial, pas_number);

person_verifications

The table in MPI db is used to store results of synchronization with external registries that characterizes a person

Model described Person verification data model | person_verifications

party_verifications

The table in PRM db is used to store results of synchronization with external registries that characterizes a party

Model described Party verification data model | party_verifications

unzr_info

The table in MIMIR db used to store personal information of Persons were received by UNZR from EIS MVS registry using unzr service. Records should not store links to mpi.

Name	Type	M/O	Description
id	uuid	M	Internal eHealth identifier
unzr	string	M	UNZR. It is `unzr` field from request of unzr service, unique
job_status	string	M	Status of the data update performed by Oban job: pending processed failed
info	jsonb	O	Personal information received from “unzr“ service (tag Info) example { "first_name": "ІВАН", "last_name": "ІВАНОВ", "middle_name": "ІВАНОВИЧ", "rnokpp": "1234567890", "gender": "M", "date_birth": "1990-12-31", "documents": { "type": "P", "number": "000018", "series": "АА", "date_issue": "2016-10-19", "date_expiry": "2026-10-19" } }
synced_at	datetime	O	Date and time when `info` was successfully synced with register
inserted_at	datetime	M	Date and time the record was created
inserted_by	uuid	M	User who triggered the record creation (an employee’s user who called the “unzr” api from admin panel).
updated_at	datetime	M	Date and time the record was updated or synchronized with EIS MVS registry
updated_by	uuid	M	User who triggered the record update or synchronization (an employee’s user who called the “unzr“ api from admin panel).