HR Data Load - Data Elements (Cloud)

Modified on Wed, 10 Apr 2024 at 10:02 AM

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