Table of Contents
Below are the following accepted/required fields for location files. For any questions on custom fields, please reach out to your CS Representative.
| Field | Required | Format | Description | Note |
|---|---|---|---|---|
| Location Name | String | Name of the location. This is used for searching inside of the CEM | If Override Location Permissions is toggled on, then the locations on the file will override any current locations assigned to the employee. | |
| Location ID | String or Integer | ID of the location to be referenced via API or other file uploads | ||
| Country | String | Country that the location is located in | Must be ISO 2 or 3 format https://en.wikipedia.org/wiki/List_of_ISO_3166_country_codes | |
| Street Address | String | Address of location | ||
| Address 2 | String | Suite number of the location | ||
| City | String | City that the location is in | ||
| State/Providence/Region | String | State, province, or region of the location | ||
| Zip Code | String | Zip code of the location | ||
| Area | String | Area containing the location | Will be read left to right | |
| Timezone | String | Timezone of the location. Use the format in the TZ database name column of this wiki: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones | ||
| Location Email Address | String | Email of the location to be used in communication or shared with candidates | ||
| Location Phone Number | String | Phone number of the location to be used in communication or shared with candidates | ||
| Action | String | What should be done with this location? Options include: Update, Add, and Delete | If the action is not in Delete or not mapped, the file will import as ADD/Update. |
Timestamp formats accepted
The following timestamp formats are accepted through user feeds:
- MM-DD-YYYY (04-03-2025)
- DD-MM-YYYY (03-04-2025)
- YYYY-MM-DD (2025-04-03)
- MMDDYYYY (04032025)
- DDMMYYYY (03042025)
- YYYYMMDD (20250403)
- MMDDYYYYHHmmss (04032025084608)
- DDMMYYYYHHmmss (03042025084608)
- YYYYMMDDHHmmss (20250403084608)
- MMDDYYYY_HHmmss (04032025_084608)
- DDMMYYYY_HHmmss (03042025_084608)
- YYYYMMDD_HHmmss (20250403_084608)
- MMDDYY_HHmmss (040325_084608)
- DDMMYY_HHmmss (030425_084608)
- YYMMDD_HHmmss (250403_084608)
- MMDDYYHHmmss (040325084608)
- DDMMYYHHmmss (030425084608)
- YYMMDDHHmmss (250403084608)