Please enable JavaScript.
Coggle requires JavaScript to display documents.
Current flow, Generate Letter/SMS/Voice Call (with more Technical details…
Current flow
Generate Letter/SMS/Voice Call
(with more Technical details for Dev team)
Scheduled to Run: 5:00 AM
Gather Qualified Children records for All Letter types and Populate LETTER_GTT table.
truncate table LETTER_GTT
Procedure:POPULATE_LETTER_GTT
PARENT
Letter D
Inserted into LETTER_GTT :checkered_flag:
For All Letter types
PARENT
A,B,C,D,E,P,R,U,V,O,B1
PCP
Q,F,G,H,M,K,L,N,W,S,T,I,J,Z,G1
Letter P
Letter E
Letter V
Letter R
Letter A
Letter B1
Letter B
Letter U
Letter C
Letter Y
Letter O
PCP
Letter N
Letter M
Letter Q
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
CALL_LETTER_FOP
Call FOP_Letter_RUN
Get templates for each letter type from
FOP_MASTER
Generate Individual Letter PDF
front/back
App Server Location :
/visitsletters/
Create Letter Activity for Each Letter for Each Child
SCR_FOLLOWUPS Table
Generate Group Letter PDF
Using LETTER_GTT table rows from previous step (Look for the Flag :checkered_flag:)