Attachment_2_-_Retail_Outlet_List_Template(1).xlsx

Procedure Outline

Attachment 2: Retail Outlet List Template and Instructions

Instructions

Brian.Fillmore: Brian.Fillmore:

State ID: 30 Characters Street Address 1: 100 Characters Street Address 2: 100 Characters City: 50 Characters County: 50 Characters State: (Use Abbreviation) Zip Code: 10 Characters

Retail Establishments Required Information All cells should be completed. However, submissions will not be accepted unless all yellow cells have information entered

Trade Name Legal Name State ID Street Address 1 Street Address 2 City County State Zipcode Zip Extn Tribal Affiliation Community Affiliation School Proximity Owner Name Owner Street Address 1 Owner Street Address 2 Owner City Owner State Owner Zipcode Corporate Owner Name Corporate Owner Street Address 1 Corporate Owner Street Address 2 Corporate Owner City Corporate Owner State Corporate Owner Zipcode

Update #1 Required Information All cells should be completed. However, submissions will not be accepted unless all yellow cells have information entered

Trade Name Legal Name State ID Street Address 1 Street Address 2 City County State Zipcode Zip Extn Tribal Affiliation Community Affiliation School Proximity Owner Name Owner Street Address 1 Owner Street Address 2 Owner City Owner State Owner Zipcode Corporate Owner Name Corporate Owner Street Address 1 Corporate Owner Street Address 2 Corporate Owner City Corporate Owner State Corporate Owner Zipcode

Update #2

Trade Name Legal Name State ID Street Address 1 Street Address 2 City County State Zipcode Zip Extn Tribal Affiliation Community Affiliation School Proximity Owner Name Owner Street Address 1 Owner Street Address 2 Owner City Owner State Owner Zipcode Corporate Owner Name Corporate Owner Street Address 1 Corporate Owner Street Address 2 Corporate Owner City Corporate Owner State Corporate Owner Zipcode

Update #3

Trade Name Legal Name State ID Street Address 1 Street Address 2 City County State Zipcode Zip Extn Tribal Affiliation Community Affiliation School Proximity Owner Name Owner Street Address 1 Owner Street Address 2 Owner City Owner State Owner Zipcode Corporate Owner Name Corporate Owner Street Address 1 Corporate Owner Street Address 2 Corporate Owner City Corporate Owner State Corporate Owner Zipcode oleObject1.bin Process for states submitting retail location for entry into TIMS

States can submit information for all the retail locations they want considered for inspections. This information should be saved to a CD as an Excel file (using the template provided) and submitted to the Center for Tobacco Products. The information needs to be arranged in a specific format for uploading to the TIMS Web Application. The required format and information is as follows:

Trade Name

Legal Name

State ID

Street

Address 1

Street

Address 2

City

County

State

Zipcode

Required

Required

Required

Required

Required

It is critical that all information is entered into the appropriate column before the file is uploaded to TIMS. All required information must be included. Please note that the address information has separate cells for street address, city, county, state, and zip code. DO NOT enter all address information in a single cell. Follow the exact format shown above and do not leave any required information out.

Adding additional state retail locations

State Coordinators can manually update the location information for existing retail establishments one at a time through the TIMS Web Application, as well as individually enter additional new retail locations for a state. However, depending on the number of new retail establishments that need to be added, State Coordinators can alternatively send supplemental lists of retail locations saved to a CD as an Excel file. The format and required information is the same as listed above. TIMS does not account for duplicates, so it is critical that the supplemental CD submitted by the state only contains a retail location file with a list of just those new establishments that need to be added to the system.

Using the Excel Template

To assist in this process CTP has provided a template. The initial submission of retail establishments should be entered in the Retail Establishment tab of the excel template. All additional submissions should be entered in the Update tabs of the excel template. Please save the excel file with your state’s name in the file name.

image1.emf