Data Elements - Cloud Customers

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


 

Compatible Version(s)

  • AC v4.11 onwards



Data Elements



RequiredUniqueColumn NameData TypeLengthComments
Yes Last_NameText40
Yes First_NameText40
  Middle_NameText40


SuffixText128Has an associated System Profile (Drop Down)


NicknameText40

Yes

Facility_Code
Text25Facility must exist in Facility Management module as a Host Facility
YesYesSocial_Security_NumberText11Must be formatted as ###-##-####
Yes
Employee_NumberText15
Yes Employee_TypeText128Has an associated System Profile (Drop Down)
Yes Employee_StatusText128Has an associated System Profile (Drop Down)
  Business_PhoneNumeric20Only Numbers allowed
YesYesBusiness_EmailText384


Hire_Date
Date
Must be formatted as YYYY-MM-DD


Rehire_DateDate
Must be formatted as YYYY-MM-DD


Start_Date
Date
Must be formatted as YYYY-MM-DD


Termination_DateDate
Must be formatted as YYYY-MM-DD


Key_Management_FlagBit
Expects 1 for True and 0 for False


Senior_Management_Official_FlagBit
Expects 1 for True and 0 for False
Yes
Yes
Network_Logon_IdText384This 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.


LocationText128


Business_UnitText128


OrganizationText128


DivisionText128


TitleText128


GradeText128


Cost_CenterText25


GenderText1Expects M for Male, F for Female or U for Unknown
Yes

Citizenship_Status
Text128Has an associated System Profile (Drop Down)


Date_of_BirthDateMust be formatted as YYYY-MM-DD


Birth_CountryText128Has an associated System Profile (Drop Down)


Birth_City
Text60



Birth_StateText60


Personal_EmailText50


Cell_Phone_NumberText20


Home_Address_1Text60


Home_Address_2Text30


Home_CityText20


Home_StateText5


Home_ZipText5Only Numbers Allowed


Manager_Employee_IdText
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




Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article