Delete Non Contracted Data.

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-BUMC
Medicare-BUMC, Brenham
Medicaid-All Saints
Cigna-Centannial

Like in the row 4, All Saints is showing insurance Cigna, this row needs to deleted as Cigna is only contracted with Centannial not All Saints as shown above.

Can we do this using Macros? Can we make dropdown for payers to select?

Thanks,

Amit

NTX OP.xlsx

MattBSlalom

On your 6 row Facility & Insurance valid relationship data set, you can add a 3rd column for the Effective Start Date.  The value for most of your rows can be a default date like January 1, 1900.  (You could also have those date fields as null or empty if you prefer.)

After you've performed the join on Facility & Insurance, then add a Filter tool setting the condition that the Case Discharge Date is greater than the Effective Start Date (also add an "or" condition for Effective Start Date equal to null or empty if that was your default value of choice).