Create confidant person relationship

1 Purpose
2 Key points
3 Specification
4 Validate confidant person
5 Validate newness of relationship
6 Service logic

Purpose

This algorithm is used to create relationship between Confidant Person and Related Person and save it to the table MPI | confidant_person_relationships .

This algorithm is currently used by following WS:

https://e-health-ua.atlassian.net/wiki/pages/createpage.action?spaceKey=EH&title=TRUSTED%20PIS.%20Confidant%20patient%20sign-up&linkCreation=true&fromPageId=17525605929
https://e-health-ua.atlassian.net/wiki/spaces/EH/pages/17525605827
Sign person request

Key points

This procedure uses dataset data to store relationship between two persons from mpi database to confidant_person_relationships and save documens that prove relationship to confidant_person_relationship_documents.
This procedure can be used in different processes and is not limited to specific process.

Specification

{
	"confidant_person_id": "70a9e15b-b71b-4caf-8f2e-ff247e8a5677",
	"person_id": "70a9e15b-b71b-4caf-8f2e-ff247e8a5678",
	"verification_status": "VERIFICATION_NEEDED",
	"verification_reason": "ONLINE_TRIGGERED",
    "confidant_person_relationship_documents": [
          {
            "type": "BIRTH_CERTIFICATE", 
            "number": "АА120518",
            "issued_by": "Рокитнянським РВ ГУ МВС Київської області", (optional)
            "issued_at": "2017-02-28" (optional)
          }
        ],
	"inserted_by": "70a9e15b-b71b-4caf-8f2e-ff247e8a5677", (optional) 
	"updated_by": "70a9e15b-b71b-4caf-8f2e-ff247e8a5678", (optional)
	"active_to": "2022-01-01" (optional)
}

Validate confidant person

Check if confidant_person_id is not already stored as person_id in confidant_person_relationships table
- in case of error - return 422 ('Patient who has confidant person can not be used as confidant for other patients')

Validate newness of relationship

Call https://e-health-ua.atlassian.net/wiki/spaces/EH/pages/17525605916 to check if relationship is already exists
- in case of error - return 422 ('Relationship between confidant patient and related patient already exists')

Service logic

Create relationship between two persons to confidant_person_relationships table where:
- confidant_person_id = $.confidant_person_id
- person_id = $.person_id
- is_active = true
- verification_status = $.verification_status
- verification_reason = $.verification_reason
- inserted_by = $.inserted_by
- updated_by = $.updated_by
- active_to = $.active_to (only if active_to is presented in the input parameters, else - leave field empty)
For each item in the confidant_person_relationship_documents array save it to confidant_person_documents table where:
- confidant_person_relationship_id = relationship.id
- type = $.confidant_person_relationship_documents[i].type
- number = $.confidant_person_relationship_documents[i].number
- issued_at = $.confidant_person_relationship_documents[i].issued_at
- issued_by = $.confidant_person_relationship_documents[i].issued_by
- inserted_by = $.inserted_by
- updated_by = $.updated_by