Category Lookup

This file will be updated when a new category structure has come into use. You can check the server modification time of this file to determine if you need to install a new category structure. DataUnison keeps a historical time and date stamed file for use with historical data.

Description
Example Data

Pos	Column	Column Type	Description
1	SITE_ID	DECIMAL(9,0)	Site ID
2	MARKETPLACE	DECIMAL(9,0)	Marketplace ID
3	ID	DECIMAL(12,0)	Category ID
4	NAME	VARCHAR(30)	Category Name
5	DESCRIPTION	VARCHAR(255)	Name of the category, with names off all categories up to the Meta category
6	ADULT	CHAR(1)	0 = general audience 1 = adult audience
7	ISLEAF	CHAR(1)	1 if this is a category with no children
8	ISEXPIRED	CHAR(1)	1 if the category is expired
9	LEVEL1	DECIMAL(12,0)	The category above leaf (0 if there is none)
10	LEVEL2	DECIMAL(12,0)	The category 2 above this (0 if there is none)
11	LEVEL3	DECIMAL(12,0)	The category 3 above this (0 if there is none)
12	LEVEL4	DECIMAL(12,0)	The category 4 above this (0 if there is none)
13	LEVEL5	DECIMAL(12,0)	The category 5 above this (0 if there is none)
14	LEVEL6	DECIMAL(12,0)	The category 6 above this (0 if there is none)
15	NAME1	VARCHAR(30)	The category name above leaf (null if there is none)
16	NAME2	VARCHAR(30)	The category name 2 above this (null if there is none)
17	NAME3	VARCHAR(30)	The category name 3 above this (null if there is none)
18	NAME4	VARCHAR(30)	The category name 4 above this (null if there is none)
19	NAME5	VARCHAR(30)	The category name 5 above this (null if there is none)
20	NAME6	VARCHAR(30)	The category name 6 above this (null if there is none)

Example Row:

Delimiter: Each field is delimited by character 127, the delete character. Hold alt then type 0,1,2,7 in sequence will type the delete character or use "x7F" in most programming languages.
Example File Name: dw_categories_intl.dat_2006-05-14_00.31