@Christian_Reich: The basic problem with payer_plan_period is that it’s mostly about period, and we’re looking mostly at plan.
You’ve pretty much stated the input side: what we have is that at visit X or for charge X the payer was Healthco Prime Sunrise. We also know that Healthco Prime Sunrise is a Medicaid managed-care plan, and that’s what we need for our analytics. I guess we could use payer_plan_period if we modified the DDL so that the dates weren’t mandatory, and took the source value as the plan ID, and linked the visit through fact_relationship, but I’m thinking you have a simpler solution in mind and I jut missed it?