I have been tasked to build a BAQ for GDPR compliance that essentially searches all of the “person-type” tables for one specific name value. This would be a BAQ that my company would rely on in the event a customer, or dealer, or contact, or supplier exercises their right to know what data we maintain that is directly pertinent to them. We do not have Enterprise Search active and our Customer Service team would prefer a single report (using SSRS/BAQ Report) that returns all areas in the ERP system where a person might appear.
When I say, “person-type” tables, I’m referring to such tables as:
- Customer
- CustCnt
- PerCon
- Person
- EmpBasic
- UserFile
- PurAgent
- Inspectr
How might I approach building an all-encompassing BAQ to look at each of these tables for a single name value (I’m having some difficulty conceptualizing how this might be put together, since some of these tables aren’t directly related as far as data workflow is concerned)?
Is it better, perhaps, to create separate BAQs to look at each table?
Is there a clear way to search all of the table resources listed above for a single name value?
Might there be other suggestions that you see would work more sensibly?