nupoorkhandelwal
commented
6 months ago Tech Notes
Here is the base query to get the each vaccination's due date and completion date --
- To get due vaccines in a particular year or any date ranges, just add the filter on the calculated due date.
- And to get the completion of any vaccine in the due range, add the same year/date filter on the completion date.
- Also, after applying filter on the above data then under vaccine coverage only those individuals will be considered, whose all the due vaccines got completed in the same filter. Even if one vaccine is remaining in that duration, then that individual wont be considered.
select cicv.program_enrolment_id,
c.base_date::date + ((item_detail_status::json->>0)::json->>'end')::int as due_date,
completion_date,
item_detail_state
from checklist_item_checklist_view cicv
left join checklist c on cicv.checklist_id = c.id
where item_detail_state = 'Due'
order by 1;
vedfordev
salilsamanvay
AnjaliBhagabati
Context:
This dashboard part is to monitor the vaccination and babies delivered either at home or institutional
for logic requirement document confirmed by client refer below link: https://docs.google.com/spreadsheets/d/1AzSqMT0ksZAes29qxpWAINOIDE3mrFv3/edit?usp=drive_link&ouid=111559638012526864678&rtpof=true&sd=true
for dashboard layout please refer: https://drive.google.com/file/d/11byBuuykwd5EWllVRb9cilKrpeV4FV-z/view?usp=drive_link
above report are to be added to Dashboard which is created for CK: https://reporting.avniproject.org/dashboard/222-dashboard-reports