Current Flow
Generate Letter/SMS/Voice Call
Gather Qualified Children records for All Letter types based on Priority
Generate Individual Letter PDFs
Create Letter Activity for each child
Generate Group PDFs
Generate Parent SMS/Voice Call
Send SMS to Primary Contact
Send Voice Call to Primary Contact
Create SMS Activity for each child
Create Voice Call Activity for each child
Send Nightly Emails to PCP
Scheduled to Run: 10:00 PM
Scheduled to Run 9:00 AM
Scheduled to Run: 5:00 AM
Generate Letter/SMS/Voice Call
Generate Group PDFs
Gather Qualified Children records for All Letter types based on Priority
Generate Individual Letter PDFs
Create Letter Activity for each child
Store Group letter Content in a Table for Printing on Day 3⃣, if not reviewed Electronically
Generate Parent SMS/Voice Call 📱
Send Reminder SMS (NO voice call 📵)
Create Reminder SMS Activity
Send SMS to Primary Contact 📱
Send Voice Call to Primary Contact 📞
Create SMS Activity for each child
Create Voice Call Activity for each child
Send Emails to PCP ✉
For Letter Activities which are yet to be Reviewed Electronically by Parent/PCP
Scheduled to Run 9:00 AM
For Letter Activity where Parent or PCP haven't Reviewed PDF Electronically and Activity Date is Less than 2 days 🚩
Scheduled to Run: 5:00 AM
click to edit
Proposed Flow
After the Daily Run of letters and Sending SMS/ Voice calls to Parents & Emails to PCP
1) Parents will use Android App 📱 to Search and Review their Children Letters
Entry from LETTER_GTT is deleted (no more needed to generate Group letter)
Parent Review Data/Time is Captured in VISITS.SCR_FOLLOWUPS table
2) Parents can Call OFHS EHDI Published Phone # 804.212.3020 ☎ for help
Call Recordings are associated with Child Activity
3) PCP Will login to VISITS to review their Pending Children list 💻
PCP Review Date/time is captured in VISITS.SCR_FOLLOWUPS table