Integration tables

In general, the tables are categorized by the prefixes and suffixes shown in this table:

Table	Description
ATT_	A prefix indicating a table that contains cube fact data or dynamic attribute data in the format that Designer can import directly into a cube. In Infor EPM table-naming conventions, the third letter of the name typically indicates C for cube or D for dimension. For example, the BPCMAIN cube or BPDACCOUNT dimension.
DAT_	A prefix indicating a table containing staged or transformed data. These are not read by Designer when importing dimensions or cube data.
DIM_	A prefix indicating one of the sets of four dimension tables that Designer requires to create a dimension.
INV_	A prefix indicating one of the sets of three inventory tables used by the data integration for Base Data Store to define and manage tables. These are not used to hold source system data.
_ATTRIBUTES	Suffix of one of the four dimension tables that Designer requires to create a dimension. They hold attributes for dimension elements.
_ELEMENTS	One of the four dimension tables that Designer requires to create a dimension. It holds the list of dimension elements.
_HIERARCHIES	One of the four dimension tables that Designer requires to create a dimension. It holds the list of hierarchies in the dimension.
_PARENTS	One of the four dimension tables that Designer requires to create a dimension. It holds parent/child relationships between elements.
_STAGED	A table (prefixed with DAT_) to hold the data from the source system that is to be imported into Infor EPM via Designer. The data in these tables are read by stored procedures ending in _PREPARE_STAGING that validate the data and write it out to a separate copy of the table having a suffix of _TRANSFORMED.
_TRANSFORMED	A table (prefixed with DAT_) that holds validated staged data processed by stored procedures ending in _PREPARE_STAGING. This validated data is in turn processed by a second stored procedure to write it to the dimension and cube tables required by Designer. The _TRANSFORMED table may contain values marked by the _PREPARE_STAGING stored procedures as errors. These values are prefixed with _ERROR_ so they can be found with queries. Processing cannot continue until the _ERROR_ values are corrected.