A Appendix: Entity Sequence List

The Entity Sequence screen in the Data Conversion tool will provide you with the list of entities that can be loaded through the Data Conversion tool. The screen also lists the entity file formats, entity grouping and the load sequences. To access this screen, select Entity Sequence List from the task list.

The screen contains three tables - entity groups, entity details, and entities.

Entity Groups

The entity group table shows the groups that are used for organizing sets of tables for conversion. You will select the group in the screens when importing and validating data, as described above. Clicking on the different rows in this table will show the entity details contained in each group.

Entity Details

In the entity details table, you will be able to see the sequence within each group that the entities will be processed. Additionally, it shows the expected file naming convention for your files and the type (*.dat or *.zip). Additionally, clicking the edit icon button or the Action menu item will allow you to manage the thread count and chunk sizes when processing. This may be especially important for larger data sets being loaded. It is only enabled for entities that are expected to have larger data volumes such as, item/location ranging, as shown below, and is used during the Business Validation phase. Clicking on the different rows in the Entity Details table will provide details about the entities represented in each file.

Entities

This table lists each of the table that are in the highlighted row in the Entity Details table. For a row that has a file format of *.dat, there will be just one row. But, for those with a *.zip format, there will be multiple tables listed that are loaded as a group. Each row in this table will show the naming convention for that specific table and the name of the staging table that is used for that entity.

The Download Entity List button on this page can be used to download a csv file containg all details for entity groups, entities relationship, file formats and sequencing. This may be a helpful reference to download while designing, building, and testing your conversion load programs.