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



RequiredColumn NameData TypeLengthComments
YesLast_NameText40
YesFirst_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
Yes
Unique
Social_Security_NumberText11Must be formatted as ###-##-####
YesEmployee_NumberText15
YesEmployee_TypeText128Has an associated System Profile (Drop Down)
YesEmployee_StatusText128Has an associated System Profile (Drop Down)
 Business_PhoneNumeric20Only Numbers allowed
Yes
Unique
Business_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
Unique
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
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article