Data Elements - Cloud Customers

Modified on Wed, 20 Oct 2021 at 03:36 PM

Compatible Version(s)

AC v4.11 onwards

Data Elements

Required	Unique	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	Yes	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	Yes	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	Yes	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