Reference tables are being used to store look up values and static information that will be accessed by the DQ rules during their runtime. Reference Tables that consist of one or two columns can be directly imported into Product 360 and maintained through the "Dictionary" perspective of the rich client. Reference tables that consist of more than two columns will not show up on the Product 360 UI but directly be used by the DQ rules during runtime.

Product 360 administrative reference tables
Reference tables for data look ups and standardizations

Product 360 administrative reference tables

Name

Description

Importable into Product 360?

Custom_Error_messages_by_language

Reference table that contains the error messages for custom rules.

Important: Please add error messages for custom rules always into this table.

Contains a 4 digit error code plus a language to indicate the preferred error message to be output.

Field	Description
Error_message	Text that builds up the error message of a custom DQ rule in case of a "failed" status result.
Error_code	Identifier that is used by the custom DQ rule to reference the error_message.

Yes

Error_messages_by_Language

Reference table that contains the error messages for standard rules.

Contains a 4 digit error code plus a language to indicate the preferred error message to be output.

Field	Description
Error_message	Text that builds up the error message of a DQ rule in case of a "failed" status result.
Error_code	Identifier that is used by the DQ rule to reference the error_message.

Yes

Language_Inclusion

References all "languages" considered for the attribute value checks. The languages need to be written like their UI label text in the global standard language of the repository. (e.g. "English" and "German" if system language is set to "en, de").

Field	Description
language_list	Semi colon separated list of languages that are included into the DQ checks that use this reference table (e.g. "English;German;French").
lookup_val	Fixed string "lang_list" that is used as an identifier for the DQ rules.

Yes

Structure_checks_inclusion

References the "identifier" values for each Structure System of Product 360 considered by rules that do structure/feature/attribute checks.

Field	Description
flag	Indicates whether the structure system will be taken into consideration by the DQ rule that uses this reference table.
Structure_identifier	List of all structure system identifiers that could be taken into consideration by the DQ rule that uses this reference table.

Yes

System_Language

References the global standard language of the Product 360 repository (e.g. "en" for English) using a single line. Language needs to be value recognized by Product 360.

Field	Description
SysLang	The short spelling of the overall system language / repository language (e.g. "en" for English). This will have effect on data access through Web API during rule execution and the language the error messages are written back into the object status.
Lookup_value	Fixed string "sys_lang" that is used as an identifier for the DQ rules.

Yes

Reference tables for data look ups and standardizations

Name

Description

Importable into Product 360?

color_base_infa

Reference table that maps different color values to a standardized color value (e.g. "Deep sky blue" to "Blue")

Field	Description
column1	The base color value (e.g. "Blue") a DQ rule that uses this table will take for standardization.
column2	The variation of the color value (e.g. "Deep sky blue") a DQ rule uses as look up for a base color value return.

Yes

colors_infa

Dictionary that contains the color values in a standardized format.

Field	Description
column1	The base color value (e.g. "Blue") a DQ rule that uses this table will look up to identify a color string.
column2	Variation of the base color.
column3	Variation of the base color.
column4	Variation of the base color.
column5	Variation of the base color.
column6	Variation of the base color.

No

profanity_infa

Dictionary that contains a variety of profanity values that are being used during rule execution for look ups.

Field	Description
COLUMN1	The profanity word a DQ rule that uses this table will look up to identify bad words.
COLUMN2	The profanity word a DQ rule that uses this table will look up to identify bad words (the same value as in column 1).

Yes

uom_infa

Reference table that contains the unit values in a standardized format.

Field	Description
column1	The base unit (e.g. "sec") a DQ rule that uses this table will look up to identify unit.
column2	Variation of the base unit.
column3	Variation of the base unit.
column4	Variation of the base unit.
column5	Variation of the base unit.

No

usa_company_acronyms_infa

Reference table that maps company names to their corresponding acronyms (e.g. "Hewlett-Packard Co" to "HP")

Field	Description
column1	The abbreviation of a given company name (e.g. "hp") a DQ rule uses as look up for a standardized company name value return.
column2	The standardized company name (e.g. "Hewlett Packard") a DQ rule that uses this table will take for standardization.

Yes

usa_company_names_std_infa

Reference table that maps company names to their standardized spelling format (e.g. "Abercrombie and Fitch" to "Abercrombie & Fitch Co")

Field	Description
column1	The standardized company name (e.g. "Hewlett Packard") a DQ rule that uses this table will take for standardization.
column2	Variation of the company name.
column3	Variation of the company name.
column4	Variation of the company name.
column5	Variation of the company name.
column6	Variation of the company name.
etc.	etc.

No

usa_company_sufx_abrv_infa

Reference table that contains set of American suffixes for company names and their abbreviations (e.g. "Co.")

Field	Description
column1	The standardized company suffix (e.g. "Inc.") a DQ rule that uses this table will take for standardization.
column2	Variation of the company suffix .
column3	Variation of the company suffix .
column4	Variation of the company suffix .
column5	Variation of the company suffix .
column6	Variation of the company suffix .
etc.	etc.

No