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
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| legacy_category_codekey | text | Code 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_department | text | Department under the old scheme. | Food & Beverage; Merchandise |
| legacy_category_name | text | Category 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_code | integer | Matching current code. | 1100 to 2500 |
| department | text | Department under the current scheme. | Food & Beverage; Merchandise |
| category_name | text | Category 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_note | text | Anything 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
Tables that point here
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| legacy_category_code | legacy_department | legacy_category_name | category_code | department | category_name | mapping_note |
|---|---|---|---|---|---|---|
| FB-ALC | Food & Beverage | Alcohol | 1600 | Food & Beverage | Beer, Wine & Spirits | one to one or merged into the new category |
| FB-APP | Food & Beverage | Appetizers & Sides | 1300 | Food & Beverage | Sides & Starters | one to one or merged into the new category |
| FB-DES | Food & Beverage | Desserts | 1400 | Food & Beverage | Desserts & Sweets | one to one or merged into the new category |
| FB-ENT | Food & Beverage | Entrees | 1100 | Food & Beverage | Entrees | one to one or merged into the new category |
| FB-KID | Food & Beverage | Kids Meals | 1200 | Food & Beverage | Kids Meals | one to one or merged into the new category |