Compatible Version(s)

  • AC v4.11



Data Elements



RequiredUniqueColumn NameData TypeLengthComments
Yes LAST_NMEText40
Yes FIRST_NMEText40
  MIDDLE_NMEText40


SUFFIXText128Has an associated System Profile (Drop Down)


NICK_NMEText40



FCLTY_CD
Text25Facility must exist in Facility Management module as a Host Facility
YesYesSSNText11Must be formatted as ###-##-####
Yes
EMP_NMR_TXTText15
Yes EMP_TYP_DESCText128Has an associated System Profile (Drop Down)
Yes EMP_STS_DESCText128Has an associated System Profile (Drop Down)
  WORK_PHONE_NMRNumeric20Only Numbers allowed
YesYesWORK_EMAIL_TXTText384


HIRE_DTDate



REHIRE_DTDate



START_DT
Date



TRMNTN_DTDate



KEY_MGMT_PRSNL_FLGBit
Expects 1 for True and 0 for False


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


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

CTZNSHP_DESC
Text128Has an associated System Profile (Drop Down)


BIRTH_DTDate


BIRTH_CNTRYText128Has an associated System Profile (Drop Down)


BIRTH_CITYText60



BIRTH_ST_CDText60


LCTN_TXTText128


BSNS_UNIT_TXTText128


ORG_NME_TXTText128


DVSN_TXTText128


TITLEText128


GRADEText128


COST_CENTERText25


HOME_ADDR1Text60


HOME_ADDR2Text30


HOME_CITYText20


HOME_STATE_CDText5


HOME_ZIP5Text5Only Numbers Allowed


PERSNL_EMAIL_TXTText50


CELL_NMRText20Only Numbers Allowed


MGR_EMP_NMRText
15


WORK_CLASSText50


HR_AREA_FULLText50



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: 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