Template Overview

The Employment Activities import template is a CSV file that is comprised of the activities that occurred during the 12 months preceding the start of the AAP year, including: applicants, hires, promotions, and terminations.

Employment activities, also known as personnel or adverse impact activities, are usually obtained from exports from a company’s HRIS and Applicant Tracking System.

Template Functionality

When imported, the Employment Activities template performs the following functions:

  • Inserts:
    • Activities

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 employment activity. A quick way to build this template is to use the Create/View Template Button within the Import window.

Download the Employment Activities Import Template

Field / Column Value Required? Description Example Excel Column
Location Code Yes A code assigned to the location and/or AAP in which the activity took place. Note: This location code must match an existing location code within the company. SACR A
Activity Code Yes An activity code that describes the type of activity. Common codes are:

APP : Applicant
HIRE : Hire
PROFROM : Promotion From
PROTO : Promotion To
TERMINV : Involuntary Termination
TERMVOL : Voluntary Termination
WORKFORCE : Workforce Snapshot

During the import, it will ask you to map or define a code (by creating a custom activity code) if it doesn’t recognize it.
APP B
Activity Date Yes The date the activity took place. 08/27/2019 C
Individual’s ID No A unique ID of the individual represented by this activity. B12345 D
Individual’s Name Yes The name of the individual represented by this activity. Smith, John E
Race Yes The race of the individual. Common codes are:

W : White
B : Black
H : Hispanic
A : Asian
I : American Indian/Alaskan Native
P : Native Hawaiian or Other Pacific Islander
T : Two or More Race
Blank or Empty : Unknown Race

During the import, it will ask you to map or define a code if it doesn’t recognize it.
B F
Gender Yes The gender of the individual. ommon codes are:

M : Male
F : Female
Blank or Empty : Unknown Gender

During the import, it will ask you to map or define a code if it doesn’t recognize it.
F G
Veteran? Yes Is the individual a protected veteran? Common codes are:

Y : Yes
N : No

During the import, it will ask you to map or define a code if it doesn’t recognize it.
Y H
Disabled? Yes Is this a person with a disability? Common codes are:

Y : Yes
N : No

During the import, it will ask you to map or define a code if it doesn’t recognize it.
N I
Date of Birth No The individual’s date of birth in MM/DD/YYYY format. 05/23/1974 J
Job Group Code Yes A unique code for each unique job group name. 2 K
Job Group Name Yes A name that represents groups of jobs that have similar wages, responsibilities and opportunities for advancement. Professionals L
Job Code Yes The job code for the activity’s job. This could be the job that was applied to or the job that an employee was promoted to for example. Note: If this field is empty, a unique code will be created automatically if there is a value in Job Title. ACCT M
Job Title Yes The job title for the job code. Accountant N
EEO Code Yes The EEO-1 (Private), EEO-4 (Public) or EEO-6 (Educational-IPEDS) code for each job. 2 O
Requisition Code No If the record of an applicant or hire is associated with a requisition, please provide the requisition code. REQ1452 P
Requisition Name No If the record of an applicant or hire is associated with a requisition, please provide the requisition name. My Requisition Q
Department Code No A company-assigned identifier for an organizational unit. FIN R
Department Name No The name of the activity’s department. Finance S
Force Into Location Code No If you wish to report individuals in a location other than the one shown in the Location Code column, indicate the location code here. DENV T
Disposition Code No A code that defines why a candidate was not interviewed or hired. SALARYTOOHIGH U
Referral Source No A code used to signify a referral source. NEWSPAPER V
Pay Analysis Group No A code used for groups of employees from one or more job titles. MYPAG W

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

Thanks for your feedback.