Dashboards
- As MSP doctor I should see all declarations, created by me
filters:
- date
- date period
dashboard parameters:
- active declarations amount on date
- amount of created declarations and closed declarations for the period
- As MSP owner I should see all declarations which related to this MSP
filters:
- date
- date period
dashboard parameters:
- active declarations amount on date
- amount of created declarations and closed declarations for the period
- As NHS Portal user I should see all active declarations and doctors in the context of area
filters:
- date
- date period (limited on the site side)
dashboard parameters:
- active declarations amount on date
- amount of created declarations for the period
- active doctors on date
- amount of created doctors for the period
- As NHS Portal user I should see map with MSP divisions which contain:
- active declarations amount
- active doctors
- division address
- division phone
- division location
- division working hours
DB views
View contains aggregate declarations by area, msp, division and doctor per day
Parameters | Description |
---|---|
date | calculation date |
area_id | area, where legal_entity is located in which the declaration was made |
msp_id | legal_entity in which the declaration was made |
division_id | division in which the declaration was made |
doctor_id | doctor which signed declaration |
declaration_active_on_date | count all active declarations on date (declaration status = ACTIVE) |
declaration_closed_on_date | count all closed declarations on current date (declaration status = CLOSED) |
declarations_created_per_day | count active declarations per day (declaration status = ACTIVE) |
declarations_closed_per_day | count closed declarations per day (declaration status = CLOSED) |
View contains aggregate doctors by area, msp and division per day.
Parameters | Description |
---|---|
date | calculation date |
area_id | area, where legal_entity is located in which the doctor was registered |
msp_id | legal_entity in which doctor works |
division_id | division in which doctor works |
doctors_active_on_date | count all active doctors on date (employee status = ACTIVE) |
doctors_inactive_on_date | count all inactive doctors on date (employee status = INACTIVE) |
doctors_created_per_day | count doctors who was registered per day (employee status = ACTIVE) |
doctors_dismissed_per_day | count doctors who was dismissed per day (employee status = INACTIVE) |