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) |
...