Defining PDW Metadata Items

Use PDW Metadata Maintenance to define metadata items, which identify the data stored in the PDW. Once defined, you can use these metadata items to import data from vendor sources into the PDW and export data from the PDW to the Eclipse Product file.

Create a metadata item for each product attribute you want to store in the PDW. You can create multiple metadata items for the same type of information. For example, the IDW provides standard price updates for all your products, but Delta has set up special pricing for your company and sends price updates on diskette. In the PDW you can create metadata items for the IDW prices and metadata items for the Delta prices.

To limit user access to metadata items, assign authorization keys to the items. For example, if you want to limit who can access the buying price of a product, assign an authorization key to that metadata item. You can assign one of the predefined authorization keys included in the Eclipse system or you can assign a user-defined authorization key.

To define a metadata item:

From the Tools > Product Data Warehouse (PDW) menu, select PDW Meta Maintenance to display the PDW MetaData Maintenance window.
Complete the follow fields, as needed, to set up your metadata items:

Field	Description
Meta ID	Click Create New to define a new item. The system automatically assigns a unique key number to new metadata item.
Description	Enter the description of the data element, such as TS UPC for the Trade Service UPC number or Ven UPC for a vendor UPC number. This field automatically populates based on your Meta ID selection.
Length	Enter the number of characters across the screen that you want this metadata item to occupy. Note: We recommend that you enter the same number of characters that the Eclipse dictionary item to which you will map this element occupies.
Justify (Affects Eterm only)	Select either Justify Left, JustifyRight, or None to indicate whether this metadata item is right or left justified within its field.
Index	Select this check box to index this metadata item for product searches. For example, you can search for a product using its UPC number or description, so flag these elements as indexed items.
This meta item is part of the description (Sel Desc)	Select this check box to indicate this metadata item is part of the record description. Vendors can break their product description data into multiple data elements, such as manufacturer ID, product type, and product ID number. You can combine these to create a complete record description.
Authorization area	To require users to be authorized to view or edit this metadata item, do the following: In the Authorization Key Required field, enter the required authorization key. The key can be user-defined or one of the predefined Eclipse authorization keys. If the authorization key has multiple levels, in the Authorization Level field, enter the level of authorization that users must be assigned to view this metadata item.
File Validation	Select this check box to have this metadata item populate a user-defined file for validation purposes. In the corresponding File field, enter the file name to which you want to import this metadata item.
Sort Order	If you included this metadata item in the record description, enter the order in which this portion of the description displays with respect to the other metadata items that create the record description. For example, if multiple metadata items create the product description, then assign sort order 1 to the metadata item that displays first, 2 to the metadata item that displays second, and so on.
Display in Web	Select this check box to display this metadata item in the technical specifications in Web Order Entry.
Parametric	Select this check box if you will use parameters by which you want to search the metadata, such as a keyword like Manufacturer. Use the Value field to enter the specific keyword information, such as Syl. Caution:We recommend consulting Eclipse prior to using Parametric Data. Setting parametric data incorrectly can effect system performance.
Data Type	Select one of the following to identify metadata items as types when matching items in the PDW Catalog: UPC - Identifies this item as an 11-digit UPC code. If the item you are defining is a 12-, 13-, or 14-digit UPC code, assign the Unique Key type. Unique Key - Identifies this item as a unique key. Price - Identifies this item as pricing data. Web URL - Identifies this item as an Internet address that points to a web site. Media URL - Identifies this item as an Internet address that points to the location containing an image of the product. Date - Identifies this item as a date.

Save your changes and exit the window.

More Options When Defining PDW MetaData Items

The PDW MetaData Maintenance window also offers the following options:

To...

Select this menu option...

rebuild all indexes containing this metadata item.

File > Re-Index

You must be assigned a high enough level of authorization of the PDW.REINDEX.ALLOWED authorization key to rebuild indexes.