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.
@amitsingh88
Hope I get you correctly.