Record Table file is loaded into database before each calling period. SQL Table format for Quarantine (csv): "<CallCount>","<Name>","<PhoneNumber>","<CallStatus>" |
CallCount | Name | PhoneNumber | CallStatus |
---|---|---|---|
0 | John Doe | 5555551234 | N |
0 | Jane Smith | 5555557890 | N |
0 | Pete Black | 5555553456 | N |
0 | Kelly Green | 5555552345 | N |
0 | Jack Black | 5555557654 | N |
0 | Bill Blue | 5555553456 | N |
0 | Nancy White | 5555550098 | N |
After 1st run thru Table, everyone except Bill and Nancy answered call and provided a response.
CallCount | Name | PhoneNumber | CallStatus |
---|---|---|---|
1 | John Doe | 5555551234 | D |
1 | Jane Smith | 5555557890 | D |
1 | Pete Black | 5555553456 | D |
1 | Kelly Green | 5555552345 | D |
1 | Jack Black | 5555557654 | D |
1 | Bill Blue | 5555553456 | R |
1 | Nancy White | 5555550098 | R |
After 2nd run thru Table, Bill answered and provided a response but Nancy did not.
CallCount | Name | PhoneNumber | CallStatus |
---|---|---|---|
1 | John Doe | 5555551234 | D |
1 | Jane Smith | 5555557890 | D |
1 | Pete Black | 5555553456 | D |
1 | Kelly Green | 5555552345 | D |
1 | Jack Black | 5555557654 | D |
2 | Bill Blue | 5555553456 | D |
2 | Nancy White | 5555550098 | H |
Report would be generated that indicates that Nancy requires a house call, and the other 6 people are being successfully monitored by application.