View contains aggregate declarations by area, msp, division and doctor per day
| Parameters | Description | Aggregate logic |
|---|---|---|
| date | calculation date | all calendar dates |
| 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 current date | |
| declaration_closed_on_date | count all closed declarations on current date | |
| declarations_created_per_day | count active declarations per day | |
| declarations_closed_per_day | count closed declarations per day |
View contains aggregate doctors by area, msp and division per day.
| Parameters | Description | Aggregate logic |
|---|---|---|
| date | calculation date | all calendar dates |
| 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 current date | |
| doctors_inactive_on_date | count all inactive doctors on current date | |
| doctors_created_per_day | count doctors who was registered per day | |
| doctors_dismissed_per_day | count doctors who was dismissed per day |