If Date of First Symptoms is NULL, Tentative Discharge Date is 10 days after Date COVID-19 Test Completed or if that is NULL, Tentative Discharge Date is 10 days after Placement Date
If [Entrance Reason] = "New Placement" or "Room Change", [Tentative Discharge Date] is;;;
If [Reason for Placement] = "Customer had contact with known positive", [Tentative Discharge Date] = 14 days after [Placement Date]
If [Reason for Placement] = " Customer is showing symptoms", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
If [Reason for Placement] = "customer is positive", [Tentative Discharge Date] is 10 days after [Date of First Symptoms]
If [Entrance Reason] = "!Customer returned after preclearance departure!", [Tentative Discharge Date] is 10 days after [Placement Date]
------------------------------
D
------------------------------