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

RC_Party verification data model_EN (DRACS 2.0)

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

Schema

 

party_verification_data_model.png

Source:

Tables

party_verifications

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

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

 Internal eHealth identifier

party_id

uuid

M

Party 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 party

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_online_status

varchar

M

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

dracs_death_verification_status

varchar

M

Verification status according to DRACS death acts for the current party

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’

dracs_name_change_verification_status

varchar

M

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

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

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).

dracs_death_act_id

uuid

O

Identifier of the record from mimir.dracs_death_acts

Assumed unique constraint on person_id:

create unique index party_verifications_party_id_index on party_verifications (party_id);

party_verification_candidates

The table in PRM db is used to store links between party_id and entities that were created as the result of comparing party data with external registries

Name

Type

M/O

Description

Name

Type

M/O

Description

id

uuid

M

Internal record identifier

party_id

uuid

M

Party prm 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_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:

  • PARTY_UPDATED

  • DEATH_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

 

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