Ariadne - Technical description

Description

While entering persons in Ariadne, it sometimes happens that a person is added which already exists in Ariadne. Mostly this is discovered later on, while entries, addresses, archived results may be related to both (or more) entries.

This function displays the multiple records for a person, and resolves the problem.

Multiple records for persons are detected on basis op equal first name and surname. (This may introduce errors of the first and second order. First order errors occur when the first name and or surname are not entered identical. Second order errors happen when two different persons have equal first name and surnames.)

In resolving the multiple entries, the user selects the duplicate record he wants to resolve. All references to this record are redirectected to the first person-record in the database for that person (not being the record to be resolved.)

References which will be redirected are:

- T010-Remark
(if the person-record to which data is redirected has already a remark, the remark from the person-record to be deleted is deleted.)

- T210-Address
(if the person-record to which data is redirected has already an address, the address from the person-record to be deleted is deleted.)

- T220-Official
(All T220-Official records related to the person record to be redirected will be redirected.)

- T230-Participant
(All T230-Participant records related to the person record to be redirected will be redirected.)

The next Person attributes will be copied to the person record to which data will be redirected (only in case the attributes to which values will be copied are empty):

- initials
- tussenvoegsel
- year-of-birth
- age-class-id
- performance-level
- license-number
- archived-person-id

First-name and surname are not copied because they are the matching key fields between duplicate records for a person. Gender-id is not copied because this is a mandatory attribute.

After the redirection of data is complete, the redirected record is deleted.

Remark: Multiple records for one person in the archive are not removed.

Access path

F000-Menu
F180-Multiple-records-person

Function structure

Change history