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