Template Overview

The Locations import template is a CSV file that includes all of the location data for a company.

Template Functionality

When imported, the Locations import template performs the following functions:

  • Updates Existing:
    • Locations
  • And Inserts New:
    • Locations

Template Layout

All fields/columns in this template must exist in the CSV file in the order that they appear below and each record/row of the CSV file defines a single location. A quick way to build this template is to use the Create/View Template Button within the Import window.

Download the Locations Import Template

Field / Column Value Required? Description Example Excel Column
Location Code Yes A code assigned to the location and/or AAP in which an employee works. Note: If this field is empty, a unique code will be created automatically, but only if Location Name is not empty. SACR A
Location Name Yes A name that describes the location and/or AAP in which an employee works. Note: If this field is empty, the Location Code will be copied to this column. Sacramento B
Address Line 1 No The street address for this location. 2100 Q St C
Address Line 2 No The second street address, if necessary. Suite 123 D
City, No The city for this location. Sacramento E
State No The state for this location. CA F
Zip No The zip code for this location. 95816 G
EEO Coordinator’s Name No The name of the individual given responsibility by the Executive Officer for the creation and implementation of the AAP. Samantha Friedmann H
EEO Coordinator’s Email No The EEO Coordinator’s email address. sam@company.com I
EEO Coordinator’s Company Name No The name of the facility where the EEO Coordinator is located. Sample Company J
EEO Coordinator’s Address No The address for the EEO Coordinator. 2100 Q st K
EEO Coordinator’s City No The city for the EEO Coordinator. Sacramento L
EEO Coordinator’s State No The state for the EEO Coordinator. CA M
EEO Coordinator’s Zip No The zip code for the EEO Coordinator. 95816 N
Executive Officer’s Name No The top-level company official who has overall responsibility for the current plan. Mr. Bart Levitt O
Executive Officer’s Title No The Executive Officer’s job title. President P
Dun & Bradstreet # No The Duns number issued by Dunn & Bradstreet, Inc. 01-234-5678 Q
EIN No The Employer Identification Number issued by the IRS. 09-123-4567 R
EEO-1 # No The employer identification number issued by the Equal Employment Opportunity Commission for the EEO-1 report. 1234567 S
Parent Company Name No The name of parent company for this plan. Sample Company T
Parent Company Dun & Bradstreet # No The Parent Company’s Duns number issued by Dunn & Bradstreet, Inc. 01-234-5678 U
Parent Company EIN No The Parent Company’s Employer Identification Number issued by the IRS. 09-123-4567 V
Parent Company EEO-1 # No The Parent Company’s employer identification number issued by the Equal Employment Opportunity Commission for the EEO-1 report. 1234567 W
Prevent Roll Up? No Prevent employees in this location from rolling up into another location? Common codes are:

Y : Yes
N : No

During the import, it will ask you to map or define a value if it doesn’t recognize it.
N X
Roll Up Employees Into Location No The location to roll employees into if rollups are enabled. This field is typically blank DENV Y
Roll Up Activities Into Location No The location to roll activities into if rollups are enabled. This field is typically blank. DENV Z

Need more help with this?
The Complete AAP 12 Software Client Support Page

Thanks for your feedback.