Skip to main content
Solved

Meta data information on IFS database objects with PII information

  • May 28, 2025
  • 1 reply
  • 26 views

Forum|alt.badge.img+6

We are in the process of transporting data from IFS database into an organization internal Data warehouse. We are needing a list of IFS database objects that have PII information. Please let us know if there is a some kind of have a dictionary or data guide that helps to identify where sensitive entities/fields/etc may be in the database


Product Version: 24.2.5
Business Impact: Unable to proceed with setting up the ETL process to transport data from IFS database to the internal Datawarehouse

Best answer by asjaus

After investigating this case, the conclusion was that IFS does not provide a standard table- or column-level PII inventory, nor a comprehensive data guide covering all database objects. Identifying PII within an IFS environment depends significantly on the modules that are licensed, implemented, and customized for a particular customer.

During the investigation, guidance from IFS R&D indicated that there is no universal database object guide available. As a result, customers are generally required to perform their own data-classification exercise based on their specific implementation, business processes, and data model.

As a starting point, you may find the GDPR / Personal Data Management functionality in IFS useful. This functionality can help identify business objects classified as Data Subjects (for example, persons, employees, and contacts) and can provide valuable insight when assessing where personal data may exist within the application.

The overall recommendation from the investigation was that, if a detailed PII inventory is required to support a data warehouse initiative, compliance assessment, or data governance program, customers should engage Consulting Services or Customer Success. This type of analysis is implementation-specific and is generally considered outside the scope of standard product support.

1 reply

Forum|alt.badge.img+6
  • Author
  • Do Gooder (Employee)
  • Answer
  • July 28, 2026

After investigating this case, the conclusion was that IFS does not provide a standard table- or column-level PII inventory, nor a comprehensive data guide covering all database objects. Identifying PII within an IFS environment depends significantly on the modules that are licensed, implemented, and customized for a particular customer.

During the investigation, guidance from IFS R&D indicated that there is no universal database object guide available. As a result, customers are generally required to perform their own data-classification exercise based on their specific implementation, business processes, and data model.

As a starting point, you may find the GDPR / Personal Data Management functionality in IFS useful. This functionality can help identify business objects classified as Data Subjects (for example, persons, employees, and contacts) and can provide valuable insight when assessing where personal data may exist within the application.

The overall recommendation from the investigation was that, if a detailed PII inventory is required to support a data warehouse initiative, compliance assessment, or data governance program, customers should engage Consulting Services or Customer Success. This type of analysis is implementation-specific and is generally considered outside the scope of standard product support.