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