...
| 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 | sumavg(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: sumavg(qty_person_id_30) - total number average number of patients for doctor for the last 30 days avg(qty_person_id_60) - average number of patients for doctor for 60 days before last 30 days if avg(qty_person_id_60)=0 then 9999 |
| declarations | sum(qty_person_id_30) | patient_increase_30d_0 | if avg(qty_person_id_60)=0 then sum(qntyqty_person_id_30) |
| $inserted_at | report_date | the date when calculated |
...