MicroStrategy Tutorial » MicroStrategy Tutorial schema » Table column information

Table column information

This section describes each physical table column used in the Tutorial project.

Column Name	Data Type	Description
Table: CITY_CTR_SLS Fact table that stores sales data at the City and Call Center logical level.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
CUST_CITY_ID	Integer(2)	Unique identifier of customer city values.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
Table: CITY_MNTH_SLS Fact table that stores sales data at the City and Month logical level.
CUST_CITY_ID	Integer(2)	Unique identifier of customer city values.
MONTH_ID	Integer(4)	Unique identifier of a month.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
Table: CITY_SUBCATEG_SLS Fact table that stores sales data at the City and Subcategory logical level.
CUST_CITY_ID	Integer(2)	Unique identifier of customer city values.
SUBCAT_ID	Integer(2)	Unique identifier for the subcategory of an item.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
TOT_COST	Double	The total amount charged by supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: CUSTOMER_SLS Fact table that shows sales data at the Customer logical level.
CUSTOMER_ID	Integer(4)	The unique identification number allocated to the customer by the company.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_COST	Double	The number of individual items bought by a customer.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: DAY_CTR_SLS Fact table that shows sales data at the Day and Call Center logical level.
DAY_DATE	TimeStamp	The day and date on which the transaction took place.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales after deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: INVENTORY_CURR Fact table that shows data for the current Inventory logical level.
ITEM_ID	Integer(2)	Unique identifier of an item.
TARGET_QTY	Double	The target set for the product units sold.
EOH_QTY	Double	The number of individual items remaining at the close of each month.
ON_ORDER_QTY	Double	The quantity ordered by the customer.
UNIT_COST	Double	The amount of money charged by the supplier to the company per individual item purchased.
Table: INVENTORY_ORDERS Fact table that shows data for the Inventory and Order logical level.
ITEM_ID	Integer(2)	Unique identifier of an item.
UNITS_RECEIVED	Double	The number of individual items acquired from a supplier.
MONTH_ID	Integer(4)	Unique identifier of a month.
MONTH_DURATION	Double	Duration in months for which the inventory is calculated.
Table: ITEM_CCTR_MNTH_SLS Fact table that shows sales data at the Item, Call Center, and Month logical level.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
MONTH_ID	Integer(4)	Unique identifier of a month.
ITEM_ID	Integer(2)	Unique identifier of an item.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales after deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: ITEM_EMP_SLS Fact table that shows sales data at the Item and Employee logical level.
ITEM_ID	Integer(2)	Unique identifier of an item.
EMP_ID	Integer(2)	Unique identifier of an employee.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales after deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: ITEM_MNTH_SLS Fact table that shows sales data at the Item and Month logical level.
ITEM_ID	Integer(2)	Unique identifier of an item.
MONTH_ID	Integer(4)	Unique identifier of a month.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales after deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by customers.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: LU_AGERANGE Lookup table for Customer Demographic: Age Range.
AGERANGE_ID	Integer(4)	Unique identifier for the age range.
AGERANGE _DESC	NVarChar(20)	Description of the age range.
Table: LU_BRAND Lookup table for Brand data, which lists the manufacturer or artist for a particular product.
BRAND_ID	Integer(2)	Unique identifier for the brand.
BRAND_DESC	NVarChar(50)	Description of the brand.
Table: LU_CALL_CTR Lookup table for the Call Center data, which lists the Call Center details where product phone-in orders are taken.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
CENTER_NAME	NVarChar(50)	Name of the call center.
COUNTRY_ID	Integer(2)	Unique identifier of country values.
REGION_ID	Integer(2)	Unique identifier of region values.
DIST_CTR_ID	Integer(2)	Unique identifier of distribution center values.
MANAGER_ID	Integer(2)	Unique identifier for managers.
Table: LU_CATALOG Lookup table for the Catalog data, which lists the products available in the catalog.
CAT_ID	Integer(2)	Unique identifier of catalog values.
CAT_DESC	NVarChar(50)	Description of the catalog values.
Table: LU_CATEGORY Lookup table for Category data, which lists the products categorized at the highest levels.
CATEGORY_ID	Integer(2)	Unique identifier of the category values.
CATEGORY_DESC	NVarChar(50)	Description for the category values.
Table: LU_COUNTRY Lookup table for Country data, which represents countries where the company does or hopes to do business in the future. Also includes countries where employees work.
COUNTRY_ID	Integer(2)	Unique identifier of country values.
COUNTRY_NAME	NVarChar(50)	Name of the country.
Table: LU_CUST_CITY Lookup table for customer geographic information: City.
CUST_CITY_ID	Integer(2)	Unique identifier of customer city values.
CUST_CITY_NAME	NVarChar(50)	Name of the city in which the customer stays.
CUST_STATE_ID	Integer(2)	Unique identifier of customer state values.
Table: LU_CUST_REGION Lookup table for customer geographic information: Region.
CUST_REGION_ID	Integer(2)	Unique identifier of customer region values.
CUST_REGION_NAME	NVarChar(50)	Name of the region in which the customer stays.
CUST_COUNTRY_ID	Integer(2)	Unique identifier of customer country values.
Table: LU_CUST_STATE Lookup table for customer geographic information: State.
CUST_STATE_ID	Integer(2)	Unique identifier of customer state.
CUST_STATE_NAME	NVarChar(50)	Name of the state in which the customer stays.
CUST_REGION_ID	Integer(2)	Unique identifier of customer region.
Table: LU_CUSTOMER Lookup table for Customer data. This table targets a customer as a consumer rather than a business.
CUSTOMER_ID	Integer(4)	Unique identification number allocated to the customer by the company.
CUST_FIRST_NAME	NVarChar(255)	First name of the customer.
CUST_LAST_NAME	NVarChar(255)	Last name of the customer.
CUST_BIRTHDATE	TimeStamp	Birth date of the customer.
ADDRESS	NVarChar(255)	Address of the customer.
INCOME_ID	Integer(2)	Unique identifier of the customer’s income.
EMAIL	NVarChar(50)	Email ID of the customer.
CUST_CITY_ID	Integer(2)	Unique identifier of customer city values.
ZIPCODE	NVarChar(255)	The zip code of the address where the customer resides.
GENDER_ID	Integer(4)	Unique identifier of the customer’s gender.
AGE_YERS	Real	Age in years of a customer.
AGERANGE_ID	Integer(4)	Unique identifier of segregation of customers between a certain age group.
MARITALSTATUS_ID	Integer(4)	Unique identifier of marital status of the customer.
EDUCATION_ID	Integer(4)	Unique identifier of level of education of the customer.
HOUSINGTYPE_ID	Integer(4)	Unique identifier of type of housing owned by the customer.
HOUSEHOLDCOUNT_ID	Integer(4)	Unique identifier of number of houses owned by the customer.
FIRST_ORDER	TimeStamp	The date of first order placed by the customer.
LAST_ORDER	TimeStamp	The date of last order placed by the customer.
STATUS_ID	Integer(4)	Unique identifier of the current account status of the customer.
TENURE	Real	The duration an employee is employed by the company.
RECENCY	Real	The number of days elapsed since the last purchase was made by the customer.
Table: LU_CUSTOMER_TELCO Lookup table for Customer Telephone data, which lists the telephone plan details of the customer.
CUSTOMER_ID	Integer(4)	Unique identification number allocated to the customer by the company.
PLAN_ID	Integer(2)	Unique identifier of the telephone plan purchased by the customer.
AVG_MIN_PEAK	Double	Average calls made by the customer in minutes during peak time.
AVG_MIN_OFFPEAK	Double	Average calls made by the customer in minutes during off-peak time.
MONTHLY_PROFIT	Double	The monthly excess of the selling price of goods over their cost.
HELPDESK_CALLS	Integer(2)	Calls made by the customer to the Helpdesk.
DROPPED_CALLS	Integer(2)	Number of calls made by the customer that were dropped or disconnected unexpectedly.
ACTIVE_MONTHS	Double	The total number of months the customer has had a telephone plan. This includes the number of months into the current two-year contract, and all months for any previous contracts.
CURRENT_MONTHS	Double	The number of months into the current two-year contract.
LIFETIME_VALUE	Double	A customer score that identifies the customers most likely to be profitable to a company over a period of time.
NET_PRESENT_VALUE	Double	Net present value of the telephone plan.
REMAINING_VALUE	Double	The remaining value of the telephone plan.
START_DATE	TimeStamp	Start date of the customer telephone plan.
EXPIRE_DATE	TimeStamp	Expiry date of the customer telephone plan.
RENEWALS	Integer(2)	Renewals made by the customer.
CANCEL_DATE	TimeStamp	Date on which the customer canceled the telephone plan.
CHURN	Integer(2)	The trends and profiles of the acquired, retained, and lost customers.
LIFETIMEVALUESCORE	NVarChar(50)	Lifetime value score of the customer.
CREDITRISKSCORE	NVarChar(50)	Credit risk score of the customer.
CREDITRISKVALUE	NVarChar(50)	Credit risk value of the customer.
Table: LU_CUSTSTATUS Lookup table for Customer Statuses.
STATUS_ID	Integer(4)	Unique identifier of customer status.
STATUS_DESC	NVarChar(20)	Description of customer status.
Table: LU_DAY Lookup table for Day data, which lists the calendar dates for customer transactions.
DAY_DATE	TimeStamp	Day and date.
MONTH_ID	Integer(4)	Month of the date.
QUARTER_ID	Integer(2)	Quarter of the date.
YEAR_ID	Integer(2)	Year of the date.
Table: LU_DIST_CTR Lookup table for Distribution Center data, which lists the location where product orders are sent out to customers.
DIST_CTR_ID	Integer(2)	Unique identifier of distribution center.
DIST_CTR_NAME	NVarChar(50)	Distribution center name.
COUNTRY_ID	Integer(2)	Unique identifier of a country.
Table: LU_EDUCATION Lookup table for Customer Psychographics: Level of Education.
EDUCATION_ID	Integer(4)	Unique identifier of education level of the customer.
EDUCATION_DESC	NVarChar(20)	Description of education level of the customer.
Table: LU_EMPLOYEE Lookup table for Employee data, which lists the details of individuals working for the company who receive salary and benefits in return.
EMP_ID	Integer(2)	Unique identifier of an employee.
EMP_LAST_NAME	NVarChar(50)	Last name of the employee.
EMP_FIRST_NAME	NVarChar(50)	First name of the employee.
EMP_SSN	NVarChar(50)	Social security number of the employee.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
DIST_CTR_ID	Integer(2)	Unique identifier of distribution center values.
COUNTRY_ID	Integer(2)	Unique identifier of country values.
MANAGER_ID	Integer(2)	Unique identifier of a manager.
SALARY	Integer(4)	The amount of money an employee makes per year.
BIRTH_DATE	TimeStamp	The birth date of each employee.
HIRE_DATE	TimeStamp	The date on which a particular employee was hired.
FTE_FLAG	NVarChar(50)	Indicates whether the employee’s status is full-time.
Table: LU_GENDER Lookup table for Customer Gender data, which lists the gender of the customer.
GENDER_ID	Integer(4)	Unique identifier of the customer’s gender.
GENDER_DESC	NVarChar(20)	Description of the customer’s gender.
Table: LU_HOUSEHOLDCOUNT Lookup table for Household Count data, which lists the details of the number of houses owned by the customer.
HOUSEHOLDCOUNT_ID	Integer(4)	Unique identifier of the household count of the customer.
HOUSEHOLDCOUNT_DESC	NVarChar(20)	Description of the number of houses owned by the customer.
Table: LU_HOUSINGTYPE Lookup table for Housing Type data, which lists the details of type of house owned by the customer.
HOUSINGTYPE_ID	Integer(4)	Unique identifier of the housing type of the customer.
HOUSINGTYPE_DESC	NVarChar(20)	Description of the type of house owned by the customer.
Table: LU_INCOME Lookup table for the Customer Income data, which lists the salary range reported by the customer.
INCOME_ID	Integer(2)	Unique identifier of the customer’s income.
BRACKET_DESC	NVarChar(50)	Description for customer’s income.
Table: LU_ITEM Lookup table for the Item data, which lists the details of the individual products sold.
ITEM_ID	Integer(2)	Unique identifier of an item.
ITEM_NAME	NVarChar(255)	Name of the product sold.
SUPPLIER_ID	Integer(2)	Unique identifier of the supplier that supplies the product.
ITEM_FOREIGN_NAME	NVarChar(50)	Name given to the item by other suppliers.
SUBCAT_ID	Integer(2)	Unique identifier of the subcategory to which the item belongs.
DISC_CD	Double	Unique code that identifies items as either available or discontinued.
ITEM_LONG_DESC	NVarChar(255)	Detailed description of the item.
WARRANTY	NVarChar(50)	The time period in months during which a manufacturer repairs a broken item.
UNIT_PRICE	Double	The amount of money charged by the company to the customer per individual item sold.
BRAND_ID	Integer(2)	Unique identifier of manufacturer or artist for a particular product.
UNIT_COST	Double	The amount of money charged by the supplier to the company per individual item purchased.
Table: LU_MANAGER Lookup table for Manager data, which lists the details of the person responsible for a specific call center.
MANAGER_ID	Integer(2)	Unique identifier of the person responsible for a specific call center.
MGR_LAST_NAME	NVarChar(50)	Last name of the person responsible for a specific call center.
MGR_FIRST_NAME	NVarChar(50)	First name of the person responsible for a specific call center.
EMAIL	NVarChar(50)	Email ID of the person responsible for a specific call center.
ADDRESS_DISPLAY	NVarChar(50)	Manager’s name displayed in Last Name, First Name format.
DEVICE_ID	NVarChar(50)	Unique identifier of the device.
MSTR_USER	NVarChar(50)	Login ID of the MicroStrategy user. This attribute is used for implementing data security using system prompts.
Table: LU_MARITALSTATUS Lookup table for customer Marital Status, which lists the marital details of the customer.
MARITALSTATUS_ID	Integer(4)	Unique identifier for the marital status of the customer.
MARITALSTATUS_DESC	NVarChar(20)	Description of the marital status of the customer.
Table: LU_MONTH Lookup table for Month data, which lists the month of the customer transaction.
MONTH_ID	Integer(4)	Unique identifier of month of the date.
MONTH_DESC	NVarChar(50)	Description of the month.
MONTH_OF_YEAR	Integer(2)	Calendar month of purchase.
QUARTER_ID	Integer(2)	Unique identifier of the quarters.
YEAR_ID	Integer(2)	Unique identifier of year of the date.
MONTH_DATE	TimeStamp	Calendar day of purchase.
MONTH_DURATION	Double	Duration in months.
Table: LU_MONTH_OF_YEAR Lookup table for Month of Year data, which lists the calendar month of purchase.
MONTH_OF_YEAR	Integer(2)	Calendar month of purchase.
MONTH_OF_YEAR_NAME	NVarChar(50)	Name of the calendar month of purchase.
Table: LU_PROMO_TYPE Lookup table for Promotion Type data, which lists the type of discount offered on the sale product.
PROMO_TYPE_ID	Integer(2)	Unique identifier of the type of discount period offered on the product.
PROMO_TYPE_DESC	NVarChar(50)	Description of the type of discount period offered on the product.
Table: LU_PROMOTION Lookup table for Promotion data, which lists the discount being offered on the sale item.
PROMOTION_ID	Integer(4)	Unique identifier of the date range for a particular discount period under which an item is purchased.
PROMOTION_DESC	NVarChar(50)	Description of the discount period under which an item is purchased.
PROMOTION_DISCOUNT	Integer(4)	Monetary reduction made from a regular price for a particular discount period under which an item is purchased.
PROMO_TYPE_ID	Integer(2)	Unique identifier of the type of discount period offered on the product.
Table: LU_PYMT_TYPE Lookup table for Payment Type data, which lists the payment mode used by a customer to pay for an order.
PYMT_TYPE	Integer(2)	The mode used by a customer to pay for an order.
PYMT_DESC	NVarChar(50)	Description of the way in which a customer pays for an order.
Table: LU_QUARTER Lookup table for Quarter data, which list the details of the calendar quarter of purchase.
QUARTER_ID	Integer(2)	Unique identifier of the calendar quarter of purchase.
QUARTER_DESC	NVarChar(50)	Description of the calendar quarter of purchase.
YEAR_ID	Integer(2)	Unique identifier of the calendar year of purchase.
QUARTER_DATE	TimeStamp	Calendar date from which the quarter starts.
QUARTER_DURATION	Integer(2)	Duration of quarter.
Table: LU_REGION Lookup table for Region data, which lists the regions into which a country is split.
REGION_ID	Integer(2)	Unique identifier of region values.
REGION_NAME	NVarChar(50)	Name given to a region, which is part of a country.
COUNTRY_ID	Integer(2)	Unique identifier of country values.
Table: LU_SHIPPER Lookup table for Shipper data, which lists the details of the vendor used to send products to the customer.
SHIPPER_ID	Integer(2)	Unique identifier of the vendor used to send products to the customer.
SHIPPER_DESC	NVarChar(50)	Description of the vendor used to send products to the customer.
Table: LU_STORE Lookup table for Store data, which lists the details of a retail store including the location information.
STORE_ID	Integer(4)	Unique identifier for store values.
STORE_NAME	NVarChar(100)	Name given to a store.
CUSTOMER_ID	Integer(4)	The unique identification number allocated to the customer by the company.
STORE_ADDRESS	NVarChar(255)	Address where the store is located.
STORE_ZIPCODE	NVarChar(10)	The postal zip code for a store.
STORE_STATE	NVarChar(50)	The state that a store resides in.
STORE_CITY	NVarChar(100)	The city that a store resides in.
STORE_PHONE	NVarChar(50)	Telephone number of the store.
STORE_EMAIL	NVarChar(100)	Email address of the store.
STORE_USER_RATING	Integer(2)	Rating given by customers to the store.
STORE_WIFI	Integer(4)	Indicates whether Wi-Fi is available at the store.
STORE_DRIVE_THRU	Integer(4)	Indicates whether a drive-through facility is available at the store.
STORE_SERVICE_CENTER	Integer(4)	Indicates whether a service center facility is available at the store.
STORE_SUPER	Integer(4)	Indicates whether the store is a super store.
STORE_LATITUDE	Double	Latitude coordinates of the store location.
STORE_LONGITUDE	Double	Longitude coordinates of the store location.
STORE_WEBSITE	NVarChar(100)	URL of the store website.
STORE_SPECIALITY	Integer(4)	Indicates whether the store is a specialty store.
STORE_STATE_DESC	NVarChar(255)	Full name of the state in which the store is located.
STORE_COUNTRY	NVarChar(50)	The country that a store resides in.
Table: LU_SUBCATEG Lookup table for Subcategory data, which further differentiates a subset of products within a category.
SUBCAT_ID	Integer(2)	Unique identifier of the subcategory of a product.
SUBCAT_DESC	NVarChar(50)	Description of the subcategory of the product.
CATEGORY_ID	Integer(2)	Unique identifier of the category of a product.
Table: LU_SUPPLIER Lookup table for Supplier data, which lists the distributor for a set of brands.
SUPPLIER_ID	Integer(2)	Unique identifier of supplier values.
SUPPLIER_NAME	NVarChar(50)	Name of the distributor for a set of brands.
CONTACT_LAST_NAME	NVarChar(50)	Last name of the contact person at the supplier’s location.
CONTACT_FIRST_NAME	NVarChar(50)	First name of the contact person at the supplier’s location.
Table: LU_TELCO_PLANS Lookup table for Telephone Plan data, which lists the telephone plan details.
PLAN_ID	Integer(2)	Unique identifier of the phone plan purchased by the customer.
PLAN_DESC	NVarChar(255)	Name given to a phone plan.
PLAN_MINUTES	Double	Talk time, in minutes, available under the plan selected by the customer.
PLAN_PRICE_MO	Double	Price per month of the phone plan.
PLAN_COST_ACQ	Double	Acquisition cost of the phone plan.
PLAN_COST_FIX_MO	Double	Monthly fixed cost of the phone plan.
PLAN_COST_VAR_MO	Double	Monthly variable cost of the phone plan.
PLAN_PRICE_MINPK	Double	Price per minute for calls during peak time.
PLAN_PRICE_MINOP	Double	Price per minute for calls during off-peak time.
Table: LU_YEAR Lookup table for Year data, which lists the calendar year of purchase.
YEAR_ID	Integer(2)	Unique identifier of year.
YEAR_DATE	TimeStamp	Year and date details.
YEAR_DURATION	Integer(2)	Duration in years.
Table: MNTH_CATEGORY_SLS Fact table that stores sales data at the Month and Category logical level.
CATEGORY_ID	Integer(2)	Unique identifier of the category values.
MONTH_ID	Integer(4)	Unique identifier of month values.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: MTD_DAY Table that defines the month-to-date time period for a given date.
DAY_DATE	TimeStamp	Day and date.
MTD_DAY_DATE	TimeStamp	Month-To-Date day and date.
Table: ORDER_DETAIL Fact table that stores Order Details.
ORDER_ID	Integer(4)	Unique identifier of an order.
ORDER_DATE	TimeStamp	Date on which the order was placed.
ITEM_ID	Integer(2)	Unique identifier of an item.
QTY_SOLD	Double	Number of items sold.
UNIT_PRICE	Double	The amount of money charged by the company to the customer per individual item sold.
PROMOTION_ID	Integer(4)	Unique identifier of the date range for a particular discount period under which an item is purchased.
DISCOUNT	Double	A monetary reduction made from a regular price.
EMP_ID	Integer(2)	Unique identifier of an employee.
UNIT_COST	Double	The amount of money charged by the supplier to the company per individual item purchased.
CUSTOMER_ID	Integer(4)	The unique identification number allocated to the customer by the company.
Table: ORDER_FACT Fact table containing Order data.
ORDER_ID	Integer(4)	Unique identifier of an order.
EMP_ID	Integer(2)	Unique identifier of an employee.
ORDER_DATE	TimeStamp	Date on which the order was placed.
ORDER_AMT	Double	The total amount of money charged by the company to the customer for the order.
FREIGHT	Double	The compensation paid for the transportation of goods.
SHIP_DATE	TimeStamp	The date on which an order is shipped from the distribution center.
QTY_SOLD	Double	Quantity of items sold in the order.
ORDER_COST	Double	The total amount charged by the supplier to the company for the ordered items.
CUSTOMER_ID	Integer(4)	The unique identification number allocated to the customer by the company.
PYMT_TYPE	Integer(2)	The mode used by a customer to pay for an order.
SHIPPER_ID	Integer(2)	Unique identifier of the vendor used to send products to the customer.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: PROMOTIONS Fact table for Promotion details.
ITEM_ID	Integer(2)	Unique identifier of an item.
DAY_DATE	TimeStamp	The day and date on which the transaction took place.
Table: QTD_DAY Table that defines the quarter-to-date time period for a given date.
DAY_DATE	TimeStamp	Day and date.
QTD_DAY_DATE	TimeStamp	Quarter-to-date day and date.
Table: QTR_CATEGORY_SLS Fact table that stores sales data at Quarter and Category logical level.
CATEGORY_ID	Integer(2)	Unique identifier of the category values.
QUARTER_ID	Integer(2)	Unique identifier of the quarters.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: REL_CAT_ITEM Relation table showing relation of Category and Item.
ITEM_ID	Integer(2)	Unique identifier of an item.
CAT_ID	Integer(2)	Unique identifier of category values.
Table: RUSH_ORDER Table for Rush Order data that indicates whether a customer chose to expedite delivery of an order.
ORDER_ID	Integer(4)	Unique identifier of an order.
RUSH_CHARGE	Real	The amount of money charged to expedite delivery service.
Table: STATE_REGION_MNTH_SLS Fact table that stores sales data at State, Region, and Month logical levels.
CUST_STATE_ID	Integer(2)	Unique identifier of customer state values.
REGION_ID	Integer(2)	Unique identifier of region values.
MONTH_ID	Integer(4)	Unique identifier of a month.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: STATE_SUBCATEG_MNTH_SLS Fact table that stores sales data at State, Subcategory, and Month logical levels.
CUST_STATE_ID	Integer(2)	Unique identifier of customer state values.
SUBCAT_ID	Integer(2)	Unique identifier for the subcategory of an item.
MONTH_ID	Integer(4)	Unique identifier of a month.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: STATE_SUBCAT_REGION_SLS Fact table that stores sales data at State, Subcategory, and Region logical levels.
CUST_STATE_ID	Integer(2)	Unique identifier of customer state values.
SUBCAT_ID	Integer(2)	Unique identifier for the subcategory of an item.
REGION_ID	Integer(2)	Unique identifier of region values.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: SUBCAT_MNTH_CTR_SLS Fact table that stores sales data at Subcategory, Month, and Call Center logical levels.
SUBCAT_ID	Integer(2)	Unique identifier of the subcategory of an item.
MONTH_ID	Integer(4)	Unique identifier of a month.
CALL_CTR_ID	Integer(2)	Unique identifier of call center values.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: YR_CATEGORY_SLS Fact table that stores sales data at Year and Category logical levels.
CATEGORY_ID	Integer(2)	Unique identifier of the category values.
YEAR_ID	Integer(2)	Unique identifier of the year of purchase.
TOT_UNIT_SALES	Double	The number of individual items bought by a customer.
TOT_DOLLAR_SALES	Double	The total income produced by a given source accounting for all product sales deducting discounts.
TOT_COST	Double	The total amount charged by the supplier to the company.
GROSS_DOLLAR_SALES	Double	The total income received from the company’s product sales before deducting the expenses.
Table: YTD_DAY Table that defines the year-to-date time period for a given date.
DAY_DATE	TimeStamp	The day and date on which the transaction took place.
YTD_DAY_DATE	TimeStamp	The year-to-date day and date.