I have been working on data cleansing in my hcp attendees. Lots of duplicates, missing NPI number, missing external id's etc.
I wasn't able to find external id in the confirguration attendee tables, at least not label as such. I ended up creating 2 queries- one from expense, the other from the config table and joining.
Is there a better way? Is external id really only in the model in the expense section?