Compatible Version(s)
- AC v4.11 onwards
Data Elements
| Required | Column Name | Data Type | Length | Comments |
| Yes | Last_Name | Text | 40 | |
| Yes | First_Name | Text | 40 | |
| Middle_Name | Text | 40 | ||
| Suffix | Text | 128 | Has an associated System Profile (Drop Down) | |
| Nickname | Text | 40 | ||
| Yes | Facility_Code | Text | 25 | Facility must exist in Facility Management module as a Host Facility |
| Yes Unique | Social_Security_Number | Text | 11 | Must be formatted as ###-##-#### |
| Yes | Employee_Number | Text | 15 | |
| Yes | Employee_Type | Text | 128 | Has an associated System Profile (Drop Down) |
| Yes | Employee_Status | Text | 128 | Has an associated System Profile (Drop Down) |
| Business_Phone | Numeric | 20 | Only Numbers allowed | |
| Yes Unique | Business_Email | Text | 384 | |
| Hire_Date | Date | Must be formatted as YYYY-MM-DD | ||
| Rehire_Date | Date | Must be formatted as YYYY-MM-DD | ||
| Start_Date | Date | Must be formatted as YYYY-MM-DD | ||
| Termination_Date | Date | Must be formatted as YYYY-MM-DD | ||
| Key_Management_Flag | Bit | Expects 1 for True and 0 for False | ||
| Senior_Management_Official_Flag | Bit | Expects 1 for True and 0 for False | ||
| Yes Unique | Network_Logon_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. |
| Location | Text | 128 | ||
| Business_Unit | Text | 128 | ||
| Organization | Text | 128 | ||
| Division | Text | 128 | ||
| Title | Text | 128 | ||
| Grade | Text | 128 | ||
| Cost_Center | Text | 25 | ||
| Gender | Text | 1 | Expects M for Male, F for Female or U for Unknown | |
| Yes | Citizenship_Status | Text | 128 | Has an associated System Profile (Drop Down) |
| Date_of_Birth | Date | Must be formatted as YYYY-MM-DD | ||
| Birth_Country | Text | 128 | Has an associated System Profile (Drop Down) | |
| Birth_City | Text | 60 | ||
| Birth_State | Text | 60 | ||
| Personal_Email | Text | 50 | ||
| Cell_Phone_Number | Text | 20 | ||
| Home_Address_1 | Text | 60 | ||
| Home_Address_2 | Text | 30 | ||
| Home_City | Text | 20 | ||
| Home_State | Text | 5 | ||
| Home_Zip | Text | 5 | Only Numbers Allowed | |
| Manager_Employee_Id | Text | 15 |
Have further questions? Submit an Inquiry ticket for Support and select the most your version of Access Commander available and select HR Data Load as the Category.
Change Log
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