Basic Data Tables
The basic data tables contain a subset of information from the BORM tables. These tables assist with integration between the different CRM products. Currently, PeopleSoft Online Marketing and the external import functionality use these tables. The basic data tables give these other PeopleSoft products an efficient and quick way to obtain the information that they need for their business requirements.
During installation, the basic data tables are automatically synchronized with the information that is in the BORM. After that, the system keeps the BORM tables and the basic data tables in sync.
Image: Basic Data Tables
This diagram illustrates the relationship between CRM basic data tables and the BORM:
When you create a business object and save it in the BORM, a subset of this information is passed to the basic data tables.
PeopleSoft Online Marketing retrieves information directly from the basic data tables and updates information on the basic data tables by using XML messages. This information is also passed to the BORM tables, which keeps the BORM tables and the basic data tables in sync.
The external data import process also updates the basic data tables if audience information is attached to the import template.