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)

E-Health