Defining encounter-level visit grain from claims with inconsistent place-of-service and nested detail lines

The visit detail and a visit centric ETL solves most of this. Please see