...
| 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_totalactive_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 |
...
| 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_totalactive_on_date | count all active doctors on current date | ||||||
| doctors_createdinactive_on_date | |||||||
| Parameters | Description | Aggregate logic | |||||
| date | calculation date | all calendar dates | |||||
| area_id | area, where legal_entity is located in which the division was registered | msp_id | legal_entity in which the division was registered | divisions_total | count all divisions on current date | divisions_created | count doctors who was registered per day |
View contains aggregate devisions by area and msp per day.
| count divisions 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 |
| Parameters | Description | Aggregate logic | |
|---|---|---|---|
| date | calculation date | all calendar dates | |
| area_id | area, where legal_entity is located in which the division was registered | ||
| msp_total | legal_entity in which the division was registered | msp_created||