Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
stylenone

...

Name

Type

M/O

Description

id

uuid

M

Internal eHealth identifier

person_id

uuid

M

Person mpi identifier, unique

drfo_data_id

uuid

O

Identifier of the record from mimir.drfo_data

drfo_data_result

smallint

O

Result of the last synchronization with DRFO. Value according to DRFO_RESULT dictionary

drfo_synced_at

datetime

O

Date and time of the last synchronization with DRFO

drfo_verification_status

varchar

M

Verification status according to DRFO for the current person

drfo_verification_reason

varchar

M

Reason of the DRFO verification status

drfo_unverified_at

datetime

O

Date and time of DRFO verification status change to ‘NOT_VERIFIED’

dracs_death_act_id

uuid

O

Identifier of the record from mimir.dracs_death_acts

dracs_death_online_status

varchar

M

Online sync status with DRACS death acts registry for the current person

dracs_death_verification_status

varchar

M

Verification status according to DRACS death acts for the current person

dracs_death_verification_reason

varchar

M

Reason of the DRACS death acts verification status

dracs_death_verification_comment

varchar

O

Comment for DRACS death acts verification status

dracs_death_unverified_at

datetime

O

Date and time of DRACS death acts verification status change to ‘NOT_VERIFIED’

nhs_verification_status

varchar

M

Verification status according to manual NHS rules for the current person

nhs_verification_reason

varchar

M

Reason of the manual NHS rules verification status

nhs_verification_comment

varchar

O

Comment for manual NHS rules verification status

nhs_unverified_at

datetime

O

Date and time of manual NHS rules verification status change to ‘NOT_VERIFIED’

unzr_data_id

uuid

O

Identifier of the record from mimir.unzr_data

unzr_data_status

smallint

O

Status of the last synchronization with UNZR register (MVS). Value according to EIS_MVS_STATUS dictionary

unzr_synced_at

datetime

O

Date and time of the last synchronization with UNZR register

unzr_verification_status

varchar

M

Verification status according to UNZR for the current person

unzr_verification_reason

varchar

M

Reason of the UNZR verification status

unzr_unverified_at

datetime

O

Date and time of UNZR verification status change to ‘NOT_VERIFIED’

mvs_passport_data_id

uuid

O

Identifier of the record from mimir.mvs_passport_data

mvs_passport_data_status

smallint

O

Status of the last synchronization with Passport register (MVS). Value according to EIS_MVS_STATUS dictionary

mvs_passport_synced_at

datetime

O

Date and time of the last synchronization with Passport register (MVS)

mvs_passport_verification_status

varchar

M

Verification status of Passport (MVS) for the current person

mvs_passport_verification_reason

varchar

M

Reason of the verification status for the Passport (MVS)

mvs_passport_unverified_at

datetime

O

Date and time of Passport (MVS) verification status change to ‘NOT_VERIFIED’

dms_passport_data_id

uuid

O

Identifier of the record from mimir.dms_passport_data

dms_passport_data_status

smallint

O

Status of the last synchronization with Passport register (DMS). Value according to EIS_MVS_STATUS dictionary

dms_passport_synced_at

datetime

O

Date and time of the last synchronization with Passport register (DMS)

dms_passport_verification_status

varchar

M

Verification status of Passport (DMS) for the current person

dms_passport_verification_reason

varchar

M

Reason of the verification status for the Passport (DMS)

dms_passport_unverified_at

datetime

O

Date and time of Passport (DMS) verification status change to ‘NOT_VERIFIED’

inserted_at

datetime

M

Date and time the record was created

inserted_by

uuid

M

User who triggered the record creation (system user if job; employee user if online using person request or DRFO api calls from admin panel).

updated_at

datetime

M

Date and time the record was updated

updated_by

uuid

M

User who triggered the record update (system user if job; employee user if online using person request or DRFO api calls from admin panel).

...

The table in MIMIR db used to store drfo data about person that were received from DRFO registry.

Model described at https://e-health-ua.atlassian.net/wiki/spaces/RNOKPPEH/pages/1715811129317629250371/DRFO+integration+data+model#drfomodel_EN#drfo_data

unzr_data

The table in MIMIR db used to store unzr data about person that were received from UNZR registry bu means of checkunzr service.

Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDREH/pages/1804917155518237915151/RC_MVS+integration+data+model+model#unzrDMS#unzr_data

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.

Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDREH/pages/1804917155518237915151/RC_MVS+integration+data+model+model#mvsDMS#mvs_passport_data

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.

Model described at https://e-health-ua.atlassian.net/wiki/spaces/EDDREH/pages/1804917155518237915151/RC_MVS+integration+data+model#dmsmodel+DMS#dms_passport_data