ЕСОЗ - публічна документація

RC_Person verification data model (DRACS 2.0)

Owned by Anna Popelysheva (SoE eHealth)
Sep 16, 2024
2 min read

Schema

person_verification_data_model.png

Source:

Tables

person_verifications

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

Name

Type

M/O

Description

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

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

Values:

  • READY

  • IN_PROCESS

  • COMPLETED

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

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

dracs_birth_act_id

uuid

O

Identifier of the record from mimir.dracs_birth_acts

dracs_birth_verification_status

varchar

M

Verification status according to DRACS birth acts for the current person

dracs_birth_verification_reason

varchar

M

Reason of the DRACS birth acts verification status

dracs_birth_verification_comment

varchar

O

Comment for DRACS birth acts verification status

dracs_birth_synced_at

datetime

O

Date and time of the last synchronization with DRACS birth acts

dracs_birth_unverified_at

datetime

O

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

dracs_name_change_verification_status

varchar

M

Verification status according to DRACS change name (marriage, divorce, change name) acts for the current person

dracs_name_change_verification_reason

varchar

M

Reason of the DRACS change name acts verification status

dracs_name_change_verification_comment

varchar

O

Comment for DRACS change name acts verification status

legal_capacity_verification_status

varchar

M

Verification status of Legal capacity for the current person

legal_capacity_verification_reason

varchar

M

Reason of the verification status of Legal capacity

legal_capacity_entity_id

uuid

O

Identifier of the record from mimir database

legal_capacity_entity_type

varchar

O

Type of the record from mimir database

legal_capacity_unverified_at

datetime

O

Date and time of Legal capacity 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).

Assumed unique constraint on person_id:

create unique index person_verifications_person_id_index on person_verifications (person_id);

person_verification_candidates

The table in MPI db is used to store links between person_id and dracs_death_act_id that were created as the result of comparing persons data with death act data

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

Internal record identifier

person_id

uuid

M

Person mpi identifier, unique

entity_id

uuid

M

Identifier of entity that created candidate, type is specified in entity_type field

entity_type

varchar

M

Type of entity that triggered verification candidate pair

Values:

  • dracs_death_act

  • dracs_birth_act

  • dracs_marriage_act

  • dracs_divorce_act

  • dracs_change_name_act

status

varchar

M

Status of verification candidate

Values:

  • NEW

  • CONFIRMED

  • NOT_CONFIRMED

  • DEACTIVATED

status_reason

varchar

O

Optional reason of verification candidate status

Values:

  • PERSON_UPDATED

  • DEATH_ACT_UPDATED

  • BIRTH_ACT_UPDATED

  • MARRIAGE_ACT_UPDATED

  • DIVORCE_ACT_UPDATED

  • CHANGE_NAME_ACT_UPDATED

config

jsonb

O

Variables that were used in comparison process

details

jsonb

O

Additional details of comparison process

score

float

O

Logistic regression comparison score

inserted_at

timestamp

M

Date and time the record was created

updated_at

timestamp

M

Date and time the record was updated

ЕСОЗ - публічна документація