Doesn’t work like that. If the source is an EHR the Type Concept will say that. If the source is a claim (which is what you probably are looking at) the Type Concept will distinguish between inpatient, outpatient and facility claims, but that’s it. Records from institutional claims will produce linked CARE_SITE records, records from professional claims will produce PROVIDER records. That’s how you could back track it. But again: OMOP is about the patient, not about running healthcare.
The use case is just more granular insight into the provenance of the data. I agree that simple is better here, as it the extra granularity doens’t buy us much and adds complexity to downstream analytics workflows.