RC_MIMIR (DMC)

id

Internal eHealth identifier

uuid

ar_reg_date

Death act registration date in DRACS registry

timestamp

ar_reg_number

Death act registration number in DRACS registry

varchar(255)

op_date

Date of last operation with death act

timestamp

ar_op_name

Name of last operation with death act

varchar(255)

reg_numb

Death act number in the book of state registration of deaths

varchar(255)

compose_date

Death act compose date

varchar(255)

compose_org

The state organization who composed death act

varchar(255)

is_restore

Restored (renewed) flag

smallint

name

First name of deceased person

varchar(255)

surname

Last name of deceased person

varchar(255)

patronymic

Second name of deceased person 

varchar(255)

date_birth

Birth date of deceased person

varchar(255)

birth_state

Birthplace country of deceased person

varchar(255)

birth_region

Birthplace region of deceased person

varchar(255)

birth_district

Birthplace district of deceased person

varchar(255)

birth_locality_type

Birthplace locality type of deceased person

varchar(255)

birth_locality

Birthplace locality name of deceased person

varchar(255)

sex

Gender of deceased person

varchar(255)

numident

Tax id of deceased person

varchar(255)

date_death

Death date of deceased person

varchar(255)

state

Residence country name of deceased person

text

region

Residence area name of deceased person

text

district

Residence district name of deceased person

text

locality_type

Residence settlement type of deceased person

text

locality

Residence locality name of deceased person

text

street

Residence street name of deceased person including street type

text

house

Residence house number of deceased person

text

apartment

Residence apartment number of deceased person

text

doc_seizes

Documents that were seized from a deceased person

jsonb

inserted_at

Date and time when death act was inserted

timestamp

updated_at

Date and time when death act was updated

timestamp

persons_compare_status

Status of comparing death act with person records in MPI db

varchar

parties_compare_status

Status of comparing death act with party records in PRM db

varchar

settlement_id

Identifier of deceased persons residence address (calculated based on locality and district fields)

varchar

id

Internal record identifier

bigserial

dracs_death_act_id

Death act identifier from dracs_death_acts table

uuid

dracs_death_act_data

Full death act data in json format

jsonb

inserted_at

Date and time when historic death act was inserted

timestamp

id

Internal record identifier

bigserial

ar_reg_date

Date of death acts registration

date

updated_at

Date and time when death acts registration date was last time updated from DRACS registry

timestamp

id

 Internal eHealth identifier

uuid

rnokpp

Identifier of the person in the DRFO registry. May contain tax ID, passport number, ID passport

varchar

last_name

Last name of the person

varchar

first_name

First name of the person

varchar

middle_name

Second name of the person

varchar

date_birth

Birth date of the person

date

info_result

Result of InfoRNOKPP call

smallint

info_error_message

Error message from InfoRNOKPP call. Returns in Errormsg field if Result != 0

varchar

applications

Result of FindRNOKPPQuery call

[jsonb]

find_result

Result of FindRNOKPPAnswer call

smallint

inserted_at

Date and time the record was created

datetime

inserted_by

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

uuid

updated_at

Date and time the record was updated or synchronized with DRFO registry

datetime

updated_by

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

uuid

id

bigserial

queue

char_length between 1 and 127

text

worker

char_length between 1 and 127

text

args

jsonb

errors

_jsonb

attempt

Job performing attempts: value from 0 to max_attempts

int4

max_attempts

Maximum attempts allowed to perform job

int4

inserted_at

timestamp

scheduled_at

timestamp

attempted_at

timestamp

completed_at

timestamp

attempted_by

_text

discarded_at

timestamp

priority

Priority of job, values from 0 to 3

int4

tags

_varchar

meta

jsonb

cancelled_at

timestamp

state

State of job, values according to oban_job_state type:

• available

• scheduled

• executing

• retryable

• completed

• discarded

• cancelled

enum

name

text

node

text

started_at

timestamp

expires_at

timestamp

id

 Internal eHealth identifier

uuid

unzr

UNZR. It is UNZR field from request of checkunzr service

string

family_name

Last name of the person. familyName field from request of checkunzr service

string

given_name

First name of the person. givenName field from request of checkunzr service

string

patronymic_name

Second name of the person. patronymicName field from request of checkunzr service

string

date_birth

Birth date of the person. dateBirth field from request of checkunzr service

date

status

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

smallint

description

Description of the status. Description field from response of checkunzr service

string

inserted_at

Date and time the record was created

datetime

updated_at

Date and time the record was updated

datetime

id

 Internal eHealth identifier

uuid

pass_type

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)

string

pas_serial

Passport serial. PasSerial field from request of CheckPassportStatus service

Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)

string

pas_number

Passport number. PasNumber field from request of CheckPassportStatus service

string

pas_status

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

smallint

inserted_at

Date and time the record was created

datetime

updated_at

Date and time the record was updated

datetime

id

 Internal eHealth identifier

uuid

pass_type

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)

string

pas_serial

Passport serial. PasSerial field from request of CheckPassportDMSStatus service

Might be empty if passport type is NATIONAL_ID (from DOCUMENT_TYPE dict)

string

pas_number

Passport number. PasNumber field from request of CheckPassportDMSStatus service

string

pas_status

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

smallint

inserted_at

Date and time the record was created

datetime

updated_at

Date and time the record was updated

datetime

id

 Internal eHealth identifier

uuid

unzr

UNZR. It is unzr field from request of unzr service, unique

string

job_status

Status of the data update performed by Oban job:

• pending

• processed

• failed

string

info

Personal information received from “unzr“ service (tag Info)

jsonb

synced_at

Date and time when info was successfully synced with register

datetime

inserted_at

Date and time the record was created

datetime

inserted_by

User who triggered the record creation (an employee’s user who called the “unzr” api from admin panel).

uuid

updated_at

Date and time the record was updated or synchronized with EIS MVS registry

datetime

updated_by

User who triggered the record update or synchronization (an employee’s user who called the “unzr“ api from admin panel).

uuid