...
| SOURCE | FIELD | NAME | DESCRIPTION |
|---|---|---|---|
| employee | party_id | party_id | |
| employee | legal_entity_id | legal_entity_id | |
| declarations | count(person_id) | patients_qty | qty patients by doctor (total till report date) |
| declarations | avg(qty_person_id_30)/ avg(qty_person_id_60) | patient_increase_30d | For each doctor calculate lifetime - (report_date-inserted_at) If doctor lifetime <=90 days - then null if doctor lifetime >= 90 days: avg(qty_person_id_30) - average number of patients (new declarations) for a doctor for the last 30 days avg(qty_person_id_60) - average number of patients (new declarations) for a doctor for 60 days before last 30 days |
| $inserted_at | report_date | the date when calculated |
...