PROPRIETARY
Compatible Version(s)
AC v4.202501 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 | Required | LAST_NME | Last Name | Text | 40 | |
| B | Required | 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). If Personnel has no Suffix, pass as an Empty String or NULL. | |
| E | NICK_NME | Nickname | Text | 40 | ||
| F | Required | FCLTY_CD | Facility Code | Text | 25 | Facility must exist in Facility Management module as a Host Facility |
| G | Required Unique | SSN | Social Security Number | Text | 11 | Must be formatted as ###-##-#### |
| H | Required | EMP_NMR_TXT | Employee Number | Text | 15 | |
| I | Required | EMP_TYP_DESC | Employee Type | Text | 128 | Has an associated System Profile (Drop Down) |
| J | Required | 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 | Required 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 | Required Unique | NTWRK_LOGIN_ID_TXT | Login Id | Text | 384 | This column helps define the username for any future User Accounts used by any of our products. Customers with SSO configuration should have this match the UPN in the IdP. |
| 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 | Required | 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 | 2 | Only US State Abbreviations Allowed | |
| 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: July 3, 2025
Updated Version Compatibility.
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