Skip to content

category_code_map

How the old register system's category codes translate to the current ones. One row is one legacy category code.

One row is
one legacy category code
Columns
7
Rows in Sample
16
Rows in Standard
16
Rows in Full
16

This table describes the company, not individual guests, so it is identical in all three sizes.

Columns

ColumnTypeWhat it holdsValues or range
legacy_category_codekeytextCode used by LegacyPOS.FB-ALC; FB-APP; FB-DES; FB-ENT; FB-KID; FB-NAB; FB-SNK; MR-APP; MR-CND; MR-HOM; MR-JWL; MR-PIN; MR-SOU; MR-SPT; MR-TOY
legacy_departmenttextDepartment under the old scheme.Food & Beverage; Merchandise
legacy_category_nametextCategory name under the old scheme.Alcohol; Apparel; Appetizers & Sides; Candy; Desserts; Entrees; Home Goods; Jewelry; Kids Meals; Non-Alcoholic Beverages; Pins; Snacks; Souvenirs; Sporting Goods; Toys
category_codeintegerMatching current code.1100 to 2500
departmenttextDepartment under the current scheme.Food & Beverage; Merchandise
category_nametextCategory name under the current scheme.Apparel & Headwear; Beer, Wine & Spirits; Beverages; Desserts & Sweets; Entrees; Home & Gifts; Kids Meals; Sides & Starters; Souvenirs & Collectibles; Sporting Goods; Toys & Plush
mapping_notetextAnything to know about the translation.legacy category was split: map at product level using products.legacy_category_code; one to one or merged into the new category

How it connects

First five rows

Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.

legacy_category_codelegacy_departmentlegacy_category_namecategory_codedepartmentcategory_namemapping_note
FB-ALCFood & BeverageAlcohol1600Food & BeverageBeer, Wine & Spiritsone to one or merged into the new category
FB-APPFood & BeverageAppetizers & Sides1300Food & BeverageSides & Startersone to one or merged into the new category
FB-DESFood & BeverageDesserts1400Food & BeverageDesserts & Sweetsone to one or merged into the new category
FB-ENTFood & BeverageEntrees1100Food & BeverageEntreesone to one or merged into the new category
FB-KIDFood & BeverageKids Meals1200Food & BeverageKids Mealsone to one or merged into the new category

Download from Kaggle