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.