Casino City's Gaming Business Directory 2022 Edition CD User Guide

Casino City’s Gaming Business Directory CD 29 Appendix A: Data Table Column Summary and Row Order The following table summarizes the columns containing data in each of the five data tables provided on Casino City’s Gaming Business Directory CD. Within each data table, the columns are ordered in the same sequence as they are listed in the table below. Columns without a checkmark are still present in a data table, but do not contain any actual data. The data tables are provided in eight distinct data formats. There are exceptions to the information provided in this section for three of these formats. Appendix C describes the exceptions for dBase III, Appendix D describes the exceptions for the ACT! contact manager, and Appendix E describes the exceptions for the GoldMine business contact manager. Descriptions of the contents of each data table column can be found in Appendix B. The Type column indicates whether the data in a column is of data type text or data type number. If you convert data from one format to another, you should be sure the appropriate data type is specified for each column during the conversion process. Otherwise, the wrong data type may be used by default. For example, when importing comma-separated values data into Excel, values that should be treated as having a data type of “text” may incorrectly be treated as having a data type of “number” when they contain numeric digits. Thus zip codes can be incorrectly treated as numeric values, leading to the deletion of initial zeros. Rows within the data tables are sorted in ascending order based upon the values in the columns: (i) Country, (ii) StateLong, (iii) Company, (iv) ResponsibilityOrder, (v) LastName and (vi) FirstName. Column Name Type Gaming Properties Gaming Property Contacts Property Owners Property Owner Contacts Property Owner Properties RecordType Text ✓ ✓ ✓ ✓ ✓ Company Text ✓ ✓ ✓ ✓ ✓ Address1 Text ✓ ✓ ✓ ✓ ✓ Address2 Text ✓ ✓ ✓ ✓ ✓ Address3 Text ✓ ✓ ✓ ✓ ✓ City Text ✓ ✓ ✓ ✓ ✓ State Text ✓ ✓ ✓ ✓ ✓ StateLong Text ✓ ✓ ✓ ✓ ✓ PostalCode Text ✓ ✓ ✓ ✓ ✓ PostalCodePlacement Text ✓ ✓ ✓ ✓ ✓ Country Text ✓ ✓ ✓ ✓ ✓ PhysicalAddress1 Text ✓ ✓ ✓ ✓ ✓ PhysicalAddress2 Text ✓ ✓ ✓ ✓ ✓ PhysicalCity Text ✓ ✓ ✓ ✓ ✓ PhysicalState Text ✓ ✓ ✓ ✓ ✓ PhysicalPostalCode Text ✓ ✓ ✓ ✓ ✓ PhysicalPostalCodePlacement Text ✓ ✓ ✓ ✓ ✓ PhysicalCountry Text ✓ ✓ ✓ ✓ ✓ Longitude Number ✓ ✓ ✓ Latitude Number ✓ ✓ ✓ LocationPrecision Text ✓ ✓ ✓

RkJQdWJsaXNoZXIy NDIzMTA=