Approve/reject the Optional Life insurance based on the results from a third party vendor

Summary

Approve/reject the Optional Life insurance based on the results from a third party vendor

Content

According to the client,they will send the details of the Optional Life insurance to a third party vendor and based on their approval/rejection, we should allow it to be on the Employee's elections. There is no fixed timing for the approval/denial result.

In case of denial,we need to remove the plan from the Employee's coverage. 

In case of approval,we need to update the new coverage date.

One option is to ask them to send flat files in a format and load it using HDL. But that might take some manual intervention.