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 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 | Aggregate logic |
|---|---|---|
| date | calculation dateall 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 (employee status = ACTIVE) | |
| doctors_inactive_on_date | count all inactive doctors on current 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) |