id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

ar_reg_date

timestamp

O

Birth act registration date in DRACS registry

ar_reg_number

varchar(255)

O

Birth act registration number in DRACS registry

op_date

timestamp

O

Date of last operation with birth act

ar_op_name

varchar(255)

O

Name of last operation with birth act

reg_numb

varchar(255)

O

Birth act number in the book of state registration of births

compose_date

varchar(255)

O

Birth act compose date

compose_org

varchar(255)

O

The state organization who composed birth act

is_restore

smallint

O

Restored (renewed) flag

0 - no

1 - yes

father_parent_rights

smallint

O

A flag about deprivation/restoration paternity father's rights

mother_parent_rights

smallint

O

A flag about deprivation/restoration paternity mother's rights

child_surname

varchar(255)

O

Child's last name

child_name

varchar(255)

O

Child's name

child_patronymic

varchar(255)

O

Child's patronymic

child_sex

varchar(1)

O

Child’s gender

1 - male

2 - female

сhild_date_birth

date

O

Date of birth

child_birth_state

varchar(255)

O

Name of country

child_birth_region

varchar(255)

O

Name of region

child_birth_district

varchar(255)

O

Name of district

child_birth_locality_type

varchar(255)

O

Value from dictionary

сhild_birth_locality

varchar(255)

O

The name of the settlement

father_surname

varchar(255)

O

Father's last name

father_name

varchar(255)

O

Father's first name

father_patronymic

varchar(255)

O

Father's second name

father_numident

varchar(255)

O

Father's tax id

father_date_birth

date

O

Father's date of birth

father_citizenship

smallint

O

Father citizenship

father_citizenship_another

varchar(255)

O

Use if father_citizenship = 85

father_state

varchar(255)

O

Name of father's country of residence

father_region

varchar(255)

O

Name of father's region of residence

father_district

varchar(255)

O

Name of father's district of residence

father_locality_type

varchar(255)

O

Value from dictionary

father_locality

varchar(255)

O

Name of father's settlement of residence

father_street

varchar(255)

O

Name of father's street of residence

father_house

varchar(255)

O

Building

father_building_part

varchar(255)

O

Number of building part

father_building_part_type

smallint

O

Type of building part

father_apartment

varchar(255)

O

Apartment

mother_surname

varchar(255)

O

Mother's last name

mother_name

varchar(255)

O

Mother's first name

mother_patronymic

varchar(255)

O

Mother's second name

mother_numident

varchar(255)

O

Mother's tax id

mother_date_birth

date

O

Mother's date of birth

mother_citizenship

smallint

O

Mother's citizenship

mother_citizenship_another

varchar(255)

O

Use if mother_citizenship = 85

mother_state

varchar(255)

O

Name of mother's country of residence

mother_region

varchar(255)

O

Name of mother's region of residence

mother_district

varchar(255)

O

Name of mother's district of residence

mother_locality_type

varchar(255)

O

Value from dictionary

mother_locality

varchar(255)

O

Name of mother's settlement of residence

mother_street

varchar(255)

O

Name of mother's street of residence

mother_house

varchar(255)

O

Building

mother_building_part

varchar(255)

O

Number of building part

mother_building_part_type

smallint

O

Type of building part

mother_apartment

varchar(255)

O

Apartment

certificates

jsonb

O

Birth certificates that were created with birth act

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when birth act was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when birth act was updated

cert_status

smallint

O

Certificate status

1 - valid

cert_serial

varchar(255)

O

Certificate series

cert_number

varchar(255)

O

Certificate number

cert_org

varchar(255)

O

Certificate Issued by

cert_date

varchar(255)

O

Certificate date

cert_repeat

smallint

O

1 - yes

0 - no

cert_serial_number

varchar(255)

O

Series and number of certificate about
birth

id

bigserial

M

Internal record identifier

dracs_birth_act_id

uuid

M

Death act identifier from dracs_birth_acts table

dracs_birth_act_data

jsonb

M

Full death birth data in json format

inserted_at

timestamp

M

Date and time when historic birth act was inserted

id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

ar_reg_date

timestamp

O

Marriage act registration date in DRACS registry

ar_reg_number

varchar(255)

O

Marriage act registration number in DRACS registry

op_date

timestamp

O

Date of last operation with marriage act

ar_op_name

varchar(255)

O

Name of last operation with marriage act

reg_numb

varchar(255)

O

Marriage act number in the book of state registration of marriages

compose_date

varchar(255)

O

Marriage act compose date

compose_org

varchar(255)

O

The state organization who composed marriage act

is_restore

smallint

O

Restored (renewed) flag

0 - no

1 - yes

husband_old_surname

varchar(255)

O

Husbands last name before state marriage registration

husband_surname

varchar(255)

O

Husbands last name after state marriage registration

husband_name

varchar(255)

O

Husbands first name

husband_patronymic

varchar(255)

O

Husbands secord name

husband_numident

varchar(255)

O

Husbands tax id

husband_date_birth

varchar(255)

O

Husbands birth date

husband_citizenship

smallint

O

Husbands citizenship

husband_citizenship_another

varchar(255)

O

Husbands another citizenship (set if husband_citizenship = 85)

husband_doc_type

varchar(255)

O

Husbands personal document type

husband_doc_name

varchar(255)

O

Husbands personal document name

husband_series_numb

varchar(255)

O

Husbands personal document series and number

husband_doc_date

varchar(255)

O

Husbands personal document issue date

husband_doc_org_name

varchar(255)

O

Husbands personal document issuer name

husband_birth_state

varchar(255)

O

Husbands birthplace country

husband_birth_region

varchar(255)

O

Husbands birthplace region

husband_birth_district

varchar(255)

O

Husbands birthplace district

husband_birth_locality_type

varchar(255)

O

Husbands birthplace locality type

husband_birth_locality

varchar(255)

O

Husbands birthplace locality name

husband_state

varchar(255)

O

Husbands residence country

husband_region

varchar(255)

O

Husbands residence region

husband_district

varchar(255)

O

Husbands residence district

husband_locality_type

varchar(255)

O

Husbands residence locality type

husband_locality

varchar(255)

O

Husbands residence locality name

husband_street

varchar(255)

O

Husbands residence street name

husband_house

varchar(255)

O

Husbands residence house number

husband_building_part

varchar(255)

O

Husbands residence number of building part

husband_building_part_type

varchar(255)

O

Husbands residence type of building part

husband_apartment

varchar(255)

O

Husbands residence apartment number

wife_old_surname

varchar(255)

O

Wifes last name before state marriage registration

wife_surname

varchar(255)

O

Wifes last name after state marriage registration

wife_name

varchar(255)

O

Wifes first name

wife_patronymic

varchar(255)

O

Wifes secord name

wife_numident

varchar(255)

O

Wifes tax id

wife_date_birth

varchar(255)

O

Wifes birth date

wife_citizenship

smallint

O

Wifes citizenship

wife_citizenship_another

varchar(255)

O

Wifes another citizenship (set if husband_citizenship = 85)

wife_doc_type

varchar(255)

O

Wifes personal document type

wife_doc_name

varchar(255)

O

Wifes personal document name

wife_series_numb

varchar(255)

O

Wifes personal document series and number

wife_doc_date

varchar(255)

O

Wifes personal document issue date

wife_doc_org_name

varchar(255)

O

Wifes personal document issuer name

wife_birth_state

varchar(255)

O

Wifes birthplace country

wife_birth_region

varchar(255)

O

Wifes birthplace region

wife_birth_district

varchar(255)

O

Wifes birthplace district

wife_birth_locality_type

varchar(255)

O

Wifes birthplace locality type

wife_birth_locality

varchar(255)

O

Wifes birthplace locality name

wife_state

varchar(255)

O

Wifes residence country

wife_region

varchar(255)

O

Wifes residence region

wife_district

varchar(255)

O

Wifes residence district

wife_locality_type

varchar(255)

O

Wifes residence locality type

wife_locality

varchar(255)

O

Wifes residence locality name

wife_street

varchar(255)

O

Wifes residence street name

wife_house

varchar(255)

O

Wifes residence house number

wife_building_part

varchar(255)

O

Wifes residence number of building part

wife_building_part_type

varchar(255)

O

Wifes residence type of building part

wife_apartment

varchar(255)

O

Wifes residence apartment number

husband_settlement_id

varchar

O

System field, does not exist in DRACS registry

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

wife_settlement_id

varchar

O

System field, does not exist in DRACS registry

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

persons_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing marriage act with person records in MPI db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

parties_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing marriage act with party records in PRM db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when marriage act was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when marriage act was updated

id

bigserial

M

Internal record identifier

ar_reg_date

date

M

Date of marriage acts registration

updated_at

timestamp

M

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

id

bigserial

M

Internal record identifier

dracs_marriage_act_id

uuid

M

Marriage act identifier from dracs_marriage_acts table

dracs_marriage_act_data

jsonb

M

Full marriage act data in json format

inserted_at

timestamp

M

Date and time when historic marriage act was inserted

id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

ar_reg_date

timestamp

O

Divorce act registration date in DRACS registry

ar_reg_number

varchar(255)

O

Divorce act registration number in DRACS registry

op_date

timestamp

O

Date of last operation with divorce act

ar_op_name

varchar(255)

O

Name of last operation with divorce act

reg_numb

varchar(255)

O

Divorce act number in the book of state registration of marriages

compose_date

varchar(255)

O

Divorce act compose date

compose_org

varchar(255)

O

The state organization who composed divorce act

is_restore

smallint

O

Restored (renewed) flag

0 - no

1 - yes

mn_old_surname

varchar(255)

O

Husbands last name before state divorce registration

mn_surname

varchar(255)

O

Husbands last name after state divorce registration

mn_name

varchar(255)

O

Husbands first name

mn_patronymic

varchar(255)

O

Husbands secord name

mn_numident

varchar(255)

O

Husbands tax id

mn_date_birth

varchar(255)

O

Husbands birth date

mn_citizenship

smallint

O

Husbands citizenship

mn_citizenship_another

varchar(255)

O

Husbands another citizenship (set if husband_citizenship = 85)

mn_doc_type

varchar(255)

O

Husbands personal document type

mn_doc_name

varchar(255)

O

Husbands personal document name

mn_series_numb

varchar(255)

O

Husbands personal document series and number

mn_doc_date

varchar(255)

O

Husbands personal document issue date

mn_doc_org_name

varchar(255)

O

Husbands personal document issuer name

mn_birth_state

varchar(255)

O

Husbands birthplace country

mn_birth_region

varchar(255)

O

Husbands birthplace region

mn_birth_district

varchar(255)

O

Husbands birthplace district

mn_birth_locality_type

varchar(255)

O

Husbands birthplace locality type

mn_birth_locality

varchar(255)

O

Husbands birthplace locality name

mn_state

varchar(255)

O

Husbands residence country

mn_region

varchar(255)

O

Husbands residence region

mn_district

varchar(255)

O

Husbands residence district

mn_locality_type

varchar(255)

O

Husbands residence locality type

mn_locality

varchar(255)

O

Husbands residence locality name

mn_street

varchar(255)

O

Husbands residence street name

mn_house

varchar(255)

O

Husbands residence house number

mn_building_part

varchar(255)

O

Husbands residence number of building part

mn_building_part_type

varchar(255)

O

Husbands residence type of building part

mn_apartment

varchar(255)

O

Husbands residence apartment number

wmn_old_surname

varchar(255)

O

Wifes last name before state divorce registration

wmn_surname

varchar(255)

O

Wifes last name after state divorce registration

wmn_name

varchar(255)

O

Wifes first name

wmn_patronymic

varchar(255)

O

Wifes secord name

wmn_numident

varchar(255)

O

Wifes tax id

wmn_date_birth

varchar(255)

O

Wifes birth date

wmn_citizenship

smallint

O

Wifes citizenship

wmn_citizenship_another

varchar(255)

O

Wifes another citizenship (set if husband_citizenship = 85)

wmn_doc_type

varchar(255)

O

Wifes personal document type

wmn_doc_name

varchar(255)

O

Wifes personal document name

wmn_series_numb

varchar(255)

O

Wifes personal document series and number

wmn_doc_date

varchar(255)

O

Wifes personal document issue date

wmn_doc_org_name

varchar(255)

O

Wifes personal document issuer name

wmn_birth_state

varchar(255)

O

Wifes birthplace country

wmn_birth_region

varchar(255)

O

Wifes birthplace region

wmn_birth_district

varchar(255)

O

Wifes birthplace district

wmn_birth_locality_type

varchar(255)

O

Wifes birthplace locality type

wmn_birth_locality

varchar(255)

O

Wifes birthplace locality name

wmn_state

varchar(255)

O

Wifes residence country

wmn_region

varchar(255)

O

Wifes residence region

wmn_district

varchar(255)

O

Wifes residence district

wmn_locality_type

varchar(255)

O

Wifes residence locality type

wmn_locality

varchar(255)

O

Wifes residence locality name

wmn_street

varchar(255)

O

Wifes residence street name

wmn_house

varchar(255)

O

Wifes residence house number

wmn_building_part

varchar(255)

O

Wifes residence number of building part

wmn_building_part_type

varchar(255)

O

Wifes residence type of building part

wmn_apartment

varchar(255)

O

Wifes residence apartment number

mn_settlement_id

uuid

O

System field, does not exist in DRACS registry

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

wmn_settlement_id

uuid

O

System field, does not exist in DRACS registry

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

persons_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing divorce act with person records in MPI db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

parties_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing divorce act with party records in PRM db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when divorce act was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when divorce act was updated

id

bigserial

M

Internal record identifier

ar_reg_date

date

M

Date of divorce acts registration

updated_at

timestamp

M

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

id

bigserial

M

Internal record identifier

dracs_divorce_act_id

uuid

M

Divorce act identifier from dracs_divorce_acts table

dracs_divorce_act_data

jsonb

M

Full divorce act data in json format

inserted_at

timestamp

M

Date and time when historic divorce act was inserted

id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

ar_reg_date

timestamp

O

Change name act registration date in DRACS registry

ar_reg_number

varchar(255)

O

Change name act registration number in DRACS registry

op_date

timestamp

O

Date of last operation with change name act

ar_op_name

varchar(255)

O

Name of last operation with change name act

reg_numb

varchar(255)

O

Change name act number in the book of state registration of change name acts

compose_date

varchar(255)

O

Change name act compose date

compose_org

varchar(255)

O

The state organization who composed change name act

is_restore

smallint

O

Restored (renewed) flag

old_name

varchar(255)

O

Old first name of person

old_surname

varchar(255)

O

Old last name of person

old_patronymic

varchar(255)

O

Old second name of person 

new_name

varchar(255)

O

New first name of person

new_surname

varchar(255)

O

New last name of person

new_patronymic

varchar(255)

O

New second name of person 

numident

varchar(255)

O

Tax id of person

date_birth

varchar(255)

O

Birth date of person

sex

varchar(255)

O

Gender of person

citizenship

smallint

O

Persons citizenship

citizenship_another

varchar(255)

O

Persons another citizenship (set if citizenship = 85)

doc_type

varchar(255)

O

Persons document type

doc_name

varchar(255)

O

Persons document name

series_numb

varchar(255)

O

Persons document series and number

doc_date

varchar(255)

O

Persons document issue date

doc_org_name

varchar(255)

O

Persons document issuer name

birth_state

varchar(255)

O

Birthplace country of person

birth_region

varchar(255)

O

Birthplace region of person

birth_district

varchar(255)

O

Birthplace district of person

birth_locality_type

varchar(255)

O

Birthplace locality type of person

birth_locality

varchar(255)

O

Birthplace locality name of person

state

varchar(255)

O

Residence country name of person

region

varchar(255)

O

Residence area name of person

district

varchar(255)

O

Residence district name of person

locality_type

varchar(255)

O

Residence settlement type of person

locality

varchar(255)

O

Residence locality name of person

street

varchar(255)

O

Residence street name of person including street type

house

varchar(255)

O

Residence house number of person

building_part

varchar(255)

O

Residence number of building part of person

building_part_type

varchar(255)

O

Residence type of building part of person

apartment

text

O

Residence apartment number of person

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when change name act was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when change name act was updated

persons_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing change name act with person records in MPI db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

parties_compare_status

varchar

M

System field, does not exist in DRACS registry

Status of comparing change name act with party records in PRM db

Possible values:

• READY

• IN_PROCESS

• PROCESSED

settlement_id

varchar

O

System field, does not exist in DRACS registry

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

id

bigserial

M

Internal record identifier

ar_reg_date

date

M

Date of change name acts registration

updated_at

timestamp

M

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

id

bigserial

M

Internal record identifier

dracs_change_name_act_id

uuid

M

Change name act identifier from dracs_change_name_acts table

dracs_change_name_act_data

jsonb

M

Full change name act data in json format

inserted_at

timestamp

M

Date and time when historic change name act was inserted

id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

cert_status

smallint

M

Marriage certificate status

cert_repeat

smallint

O

Repeated (renewed) flag

0 - no

1 - yes

cert_serial

varchar(255)

M

Marriage certificate serial (first symbols of serial number, up to 11)

cert_number

varchar(255)

M

Marriage certificate number (last digits of serial number, up to 10)

cert_serialnumber 

varchar(255)

M

Marriage certificate serial number

cert_org

varchar(255)

M

The state organization who composed marriage certificate

cert_date

varchar(255)

M

Marriage certificate compose date

ar_org

varchar(255)

O

Place of act record registration

ar_numb

varchar(255)

O

Number of act record registration

ar_composedate

varchar(255)

O

Date of act record registration

husband_old_surname

varchar(255)

O

Husbands last name before state marriage registration

husband_surname

varchar(255)

O

Husbands last name after state marriage registration

husband_name

varchar(255)

O

Husbands first name

husband_patronymic

varchar(255)

O

Husbands secord name

husband_citizenship

smallint

O

Husbands citizenship

husband_citizenship_another

varchar(255)

O

Husbands another citizenship (set if husband_citizenship = 85)

husband_date_birth

varchar(255)

O

Husbands birth date

husband_place_of_birth

varchar(255)

O

Husbands birth place

wife_old_surname

varchar(255)

O

Wifes last name before state marriage registration

wife_surname

varchar(255)

O

Wifes last name after state marriage registration

wife_name

varchar(255)

O

Wifes first name

wife_patronymic

varchar(255)

O

Wifes secord name

wife_citizenship

smallint

O

Wifes citizenship

wife_citizenship_another

varchar(255)

O

Wifes another citizenship (set if husband_citizenship = 85)

wife_date_birth

varchar(255)

O

Wifes birth date

wife_place_of_birth

varchar(255)

O

Wifes birth place

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when marriage certificate was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when marriage certificate was updated

id

uuid

M

System field, does not exist in DRACS registry

Internal eHealth identifier

cert_status

smallint

M

Divorce certificate status

cert_repeat

smallint

O

Repeated (renewed) flag

0 - no

1 - yes

cert_serial

varchar(255)

M

Divorce certificate serial (first symbols of serial number, up to 11)

cert_number

varchar(255)

M

Divorce certificate number (last digits of serial number, up to 10)

cert_serialnumber 

varchar(255)

M

Divorce certificate serial number

cert_org

varchar(255)

M

The state organization who composed divorce certificate

cert_date

varchar(255)

M

Divorce certificate compose date

receiver

varchar(255)

O

Receiver of the divorce certificate

ar_org

varchar(255)

O

Place of act record registration

ar_numb

varchar(255)

O

Number of act record registration

ar_composedate

varchar(255)

O

Date of act record registration

husband_old_surname

varchar(255)

O

Husbands last name before state divorce registration

husband_surname

varchar(255)

O

Husbands last name after state divorce registration

husband_name

varchar(255)

O

Husbands first name

husband_patronymic

varchar(255)

O

Husbands secord name

wife_old_surname

varchar(255)

O

Wifes last name before state divorce registration

wife_surname

varchar(255)

O

Wifes last name after state divorce registration

wife_name

varchar(255)

O

Wifes first name

wife_patronymic

varchar(255)

O

Wifes secord name

inserted_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when divorce certificate was inserted

updated_at

timestamp

M

System field, does not exist in DRACS registry

Date and time when divorce certificate was updated