Enterprise Systems Home
Curriculum
Systems
- Brief Overview
- IBM Academic Initiative
- Microsoft Enterprise Consortium
- SAP University Alliance
- Teradata University Network
Datasets
Collaboration
About Us
Information Systems
Student Downloads
globe here
globe here
Sam's Club - Datasets
UA_SAMSCLUB contains sales transaction data for 18 Sam's Club stores between January 1 and January 31, 2000. Below is an actual table retrieved from the Sam's Club Database.
| Store Nbr | Records in Item_Scan Table | Store Location |
| 3 | 237844 | Anchorage, WI |
| 4 | 225817 | Appleton, WI |
| 5 | 260580 | Arvada, WI |
| 15 | 430447 | Chesapeake, TX |
| 16 | 301493 | Chesterfield, TX |
| 17 | 301107 | Cicero, TX |
| 18 | 510786 | Cincinnati, TX |
| 19 | 423904 | Cincinnati, TX |
| 20 | 300048 | City of Industry, TX |
| 21 | 402393 | Clarksville, TX |
| 22 | 393728 | Clearwater, TX |
| 23 | 263775 | Columbus, TX |
| 24 | 389834 | Concord, TX |
| 25 | 203126 | Conroe, TX |
| 26 | 281471 | Coral Springs, TX |
| 27 | 443051 | Crystal Lake, TX |
| 28 | 443324 | Dallas, TX |
| 29 | 309004 | Daytona Beach, TX |
The UA_SAMSCLUB consists of six tables which include STORE_VISITS (Store vists by member), ITEM_SCAN (Information collected when item is scanned), STORE_INFORMATION (Information about store), MEMBER_INDEX (Member's information), ITEM_DESC (Item description), and SUB_CATEGORY_DESC (Item's secondary information).
The metadata for Sam's Club database is shown below.
| Attribute | Description | Values |
| ACTIVITY_CD | Activity Code | Y, N |
| BRAND_NAME | Name of the brand associated with the item | Null, name of brand |
| BUS_CR_TYP_STAT_CD | Business Credit Type Status Code | 0-10 |
| CARD_HOLDER_NBR | Card holder within an account | 1-99 |
| CATEGORY_NBR | Number assigned to a category of items | Null, 0-99 |
| CMPLMNTRY_CARD_CNT | Number of extra cards given to an account | 0-4 |
| COLOR_DESC | Color description of an item | White, Almond, etc |
| CREATE_DATE | Date the item was created | Date |
| EFFECTIVE_DATE | Date the item began to be sold | Date |
| ELITE_STAT_CODE | 0-4 | |
| EXPIRATION_DATE | Expiration date of an item | Date |
| FINELINE | Combination of category_nbr & sub_category_nbr | 4 digit number |
| ISSUING_CLUB_NBR | The club that the member originally joined | 1-150 |
| ITEM_NBR | The number assigned to every different item for sale | Unique number (PK) |
| ITEM_QUANTITY | The quantity of a unique item that is scanned | |
| JOIN_DATE | Date the member joined the club | Date |
| LAST_RENEWAL_DATE | Last date that the member renewed their membership | Date |
| MEMBER_CODE | 1,A,D,E,G,V,W,X,Y | |
| MEMBER_STATUS_CD | A,D,E,T | |
| MEMBER_TYPE | 1,A,E,G,V,W,X | |
| MEMBERSHIP_NBR | The number assigned to the member upon joining the club | |
| MFG_NBR | Number representing a manufacturer | |
| OBSOLETE_DATE | The date an item is no longer sold | Date |
| OPERATOR_NBR | ||
| PRIMARY_DESC | The description of an item | Teal X-Large etc |
| QUALIFY_ORG_CODE | Null, 015-3001 | |
| REFUND_CODE | Code to indicate a return transaction | 0 = Not Return, 1= Return |
| REGISTER_NBR | The register identification number where the transaction took place | 1-85 |
| RENEWAL_DATE | Date a membership should be renewed | Date |
| SALES_TAX_AMT | Tax charged for total visit | |
| SECONDARY_CARD_CNT | Number of cards other than primary card assigned to the membership | |
| SECONDARY_DESC | Additional description of an item | Sweatshirt, gift set etc |
| SIC | Standard Industry Classification code | 783700, 443700 etc |
| SIZE_DESC | Text description of the size of the item, including clothing and non-clothing items | 15CUFT, LARGE, etc |
| STATUS_CHG_DATE | The date an item last changed its status code | Date |
| STATUS_CODE | Whether an item is active or deactive | A = Active, D = Deactive |
| STORE_NAME | The name of the store | |
| STORE_NBR | Store identification number | 1-150 |
| SUB_CATEGORY_NBR | The number assigned to a sub_category of items | |
| TAX_COLLECT_CODE | Purchase taxable or not | 0,1 |
| TENDER_AMT | The amount tendered for the purchase | |
| TENDER_TYPE | Type of payment used | 0 - Cash 1 - Check 2 - Gift Card 3 - Discover 4 - Direct Credit 5 - Business Credit 6 - Personal Credit |
| TOT_SCAN_CNT | Total number of scanned items per transaction | |
| TOT_UNIQUE_ITM_CNT | The number of unique items purchased per transaction | 0-84 |
| TOT_UNIT_COST | The cost of the item (scrubbed) | |
| TOTAL_SCAN_AMOUNT | The total number of items scanned per visit number | |
| TOTAL_VISIT_AMT | The total value of the entire transaction | |
| TRANSACTION_DATE | Date of the transaction | |
| TRANSACTION_TIME | The time of day that the transaction started | |
| UNIT_COST_AMOUNT | Cost/Unit (scrubbed) | |
| UNIT_RETAIL_AMOUNT | Purchase Price/Unit (scrubbed) | |
| VENDOR_NBR | The number of the vendor that supplies the item | |
| VISIT_NBR | Every time a member goes to the register and has their membership card scanned, this number is then created | 9 digit # |
| VNPK_CUBIC_FT | How many cubic feet does a vendor pack take up | |
| VNPK_QTY | The quantity of items in a vendor pack | |
| ZIP_CODE | The zip-code of the store | |
| ZIP_CODE | The zip-code of the member |
