Compatible Version(s)
- AC v4.11 onwards
Data Elements -- CSV to Field Mapping
DO NOT MODIFY
- the File Name provided to you
- the Column Headers
- the File Format/Structure
CSV Column References | Attribute Properties | CSV Column Header | Descriptive Name of the Attribute | Data Type | Length | Comments |
A | Yes | LAST_NME | Last Name | Text | 40 | |
B | Yes | FIRST_NME | First Name | Text | 40 | |
C | MIDDLE_NME | Middle Name | Text | 40 | ||
D | SUFFIX | Suffix | Text | 128 | Has an associated System Profile (Drop Down) | |
E | NICK_NME | Nickname | Text | 40 | ||
F | Yes | FCLTY_CD | Facility Code | Text | 25 | Facility must exist in Facility Management module as a Host Facility |
G | Yes Unique | SSN | Social Security Number | Text | 11 | Must be formatted as ###-##-#### |
H | Yes | EMP_NMR_TXT | Employee Number | Text | 15 | |
I | Yes | EMP_TYP_DESC | Employee Type | Text | 128 | Has an associated System Profile (Drop Down) |
J | Yes | EMP_STS_DESC | Status | Text | 128 | Has an associated System Profile (Drop Down) |
K | WORK_PHONE_NMR | Work Phone | Numeric | 20 | Only Numbers allowed | |
L | Yes Unique | WORK_EMAIL_TXT | Work Email | Text | 384 | |
M | HIRE_DT | Hire Date | Date | Must be formatted as YYYY-MM-DD | ||
N | REHIRE_DT | Rehire Date | Date | Must be formatted as YYYY-MM-DD | ||
O | START_DT | Start Date | Date | Must be formatted as YYYY-MM-DD | ||
P | TRMNTN_DT | Termination Date | Date | Must be formatted as YYYY-MM-DD | ||
Q | KEY_MGMT_PRSNL_FLG | Key Management Personnel | Bit | Expects 1 for True and 0 for False | ||
R | SR_MGMT_OFFCL_FLG | Senior Management Official | Bit | Expects 1 for True and 0 for False | ||
S | Yes Unique | NTWRK_LOGIN_ID_TXT | Login Id | Text | 384 | This column helps define the username for any future Access Commander user accounts and/or ViSi Commander and Portal Commander accounts. If you currently use SSO/AD Authentication or plan to do so in the future, please align these with your SSO/AD usernames. |
T | LCTN_TXT | Location | Text | 128 | ||
U | BSNS_UNIT_TXT | Business Unit | Text | 128 | ||
V | ORG_NME_TXT | Organization | Text | 128 | ||
W | DVSN_TXT | Division | Text | 128 | ||
X | TITLE | Title | Text | 128 | ||
Y | GRADE | Grade | Text | 128 | ||
Z | COST_CENTER | Cost Center | Text | 25 | ||
AA | GNDR_DESC | Gender | Text | 1 | Expects M for Male, F for Female or U for Unknown | |
AB | Yes | CTZNSHP_DESC | Citizenship Description | Text | 128 | Has an associated System Profile (Drop Down) |
AC | BIRTH_DT | Date of Birth | Date | Must be formatted as YYYY-MM-DD | ||
AD | BIRTH_CNTRY | Country of Birth | Text | 128 | Has an associated System Profile (Drop Down) | |
AE | BIRTH_CITY | City of Birth | Text | 60 | ||
AF | BIRTH_ST | State of Birth | Text | 60 | ||
AG | PERSNL_EMAIL_TXT | Personal Email | Text | 50 | ||
AH | CELL_NMR | Cell Phone Number | Text | 20 | ||
AI | HOME_ADDR1 | Home Address 1 | Text | 60 | ||
AJ | HOME_ADDR2 | Home Address 2 | Text | 30 | ||
AK | HOME_CITY | Home City | Text | 20 | ||
AL | HOME_STATE_CD | Home State | Text | 5 | ||
AM | HOME_ZIP5 | Home Zip | Text | 5 | Only Numbers Allowed | |
AN | MGR_EMP_NMR | Manager Employee Number | Text | 15 | For purposes of Portal Commander, this individual will be granted the Supervisor Role |
Change Log
Last Updated: March 24, 2025
Updated the Table to include specific information about Manager Employee Number field along with the CSV (Spreadsheet) column references.
Last Updated: October 20, 2021
Updated Column Name to reflect the spreadsheet and the order of the fields
Last Updated: May 24, 2021
Updated Data Elements List to support AC v4.11
Last Updated: Nov 3, 2020
Added Nickname as an option to the Data Elements list