You can use the Entity export status table to store all entities (data set tables and data entities) as used on data models. When data exports are done, this table also stores the export status for each of the tables.
The Entity export status table exists in both the D365 FO database (CDPEntityExportStatus) and the target database (CDPEntityExportStatusSTAGING).

Entity export status table fields

The Entity export status table has these fields:

• Trunket time: This is the latest date/time on which a table is deployed.
• Date/time: This is the latest date/time on which the data of a table is exported to the target database. This date/time is set if the latest export finished with the status 'Inactive' or 'Error'.
• Export status: The current export status of a table:
  • In progress: A data export is currently in progress for the table.
  • Inactive: No data export is currently in progress for the table. The latest data export was successful.
  • Error: No data export is currently in progress for the table. The latest data export was not successful.

Entity export status table actions

Actions related to the Entity export status table are:

• On Update metadata, the CDPEntityExportStatus table in D365 FO is updated with all entities (data set tables and data entities) as used on data models.
• On deploy, the CDPEntityExportStatusSTAGING table is created on the target database and filled with the entities that exist in the CDPEntityExportStatus table in D365 FO.
• On export, for the tables which data is exported, the status and related dates are set in the Entity export status table in both D365 FO and the target database.

Data warehouse

A data warehouse, as related to the target database (BYOD), only can load records from the target database for tables with export status Inactive. If for a table the status is 'In progress' or 'Error', the data for that table cannot be loaded by the data warehouse.