Table of Contents

Introduction

Access to patient medical data is now managed by ABAC module, current chapter is no longer actual.

...

Search for declarations using user_id and client_id

1. Select party_id from PRM.Party_users where 
   1. PRM.Party_users.user_id = user_id
2. Select IDs from PRM.Employees where
   1. PRM.Employees.party_id = Select 1.
   2. PRM.Employees.legal_entitty_id= client_id
3. Select person_id from OPS.Declarations where  
   1. OPS.Declarations.employee_id IN Select 2.
   2. OPS.Declarations.status IN (active, pending_verification)
4. Select user_id from PRM.Party_users where
   1. PRM.Party_users.party_id = Select 1.
5. Write all selected records into Redis in the structure:
   user_id | client_id | | [{person_id}|

Search for declarations using employee_id

1. Select party_id and client_id from PRM.Employees where PRM.Employees.id= employee_id
2. Select user_id from PRM.Party_users where
   1. PRM.Party_users.party_id = party_id
3. Select IDs from PRM.Employee where
   1. PRM.Employee.party_id = Select 2.
   2. PRM.Employee.legal_entitty_id= client_id
4. Select person_id from OPS.Declarations where  
   1. OPS.Declarations.employee_id = Select 3.
   2. OPS.Declarations.status IN (active, pending_verification)
5. Write all selected records into Redis in the structure:
   user_id | client_id | | [{patient_id}|

The data in the Redis expires after N minutes or when declared event happens:

...