Delete Non Contracted Facilities

[amitsingh88]

Hi,

In this File I want to delete those rows where the Insurance is not contracted with Facility in one Go.

This is contract between payers and facilities-

Aetna -Baylor University Medical Centre(BUMC)
Medicare- Brenham
Medicare -Baylor University Medical Centre(BUMC)
Medicaid -All Saints
Cigna -Centennial
Molina- Baylor University Medical Centre(BUMC) since 10/01/2020

There is one more condition. Molina is contracted with Baylor University Medical Centre since 10/01/2020(Case Discharge Date). So need to delete those before this date for Molina-BUMC.

[Qiu]

@amitsingh88 
Hope I get you correctly.