03. HR Data Load - Data Elements


 

Compatible Version(s)

  • AC v4.11 onwards



Data Elements -- CSV to Field Mapping


DO NOT MODIFY

  • the File Name provided to you
  • the Column Headers
  • the File Format/Structure

CSV
Column
References
Attribute
Properties
CSV Column HeaderDescriptive Name of the AttributeData
Type
LengthComments
AYesLAST_NMELast NameText40
BYesFIRST_NMEFirst NameText40
C MIDDLE_NMEMiddle NameText40
D
SUFFIXSuffixText128Has an associated System Profile (Drop Down)
E
NICK_NMENicknameText40
FYesFCLTY_CDFacility CodeText25Facility must exist in Facility Management module as a Host Facility
GYes
Unique
SSNSocial Security NumberText11Must be formatted as ###-##-####
HYesEMP_NMR_TXTEmployee NumberText15
IYesEMP_TYP_DESCEmployee TypeText128Has an associated System Profile (Drop Down)
JYesEMP_STS_DESCStatusText128Has an associated System Profile (Drop Down)
K WORK_PHONE_NMRWork PhoneNumeric20Only Numbers allowed
LYes
Unique
WORK_EMAIL_TXTWork EmailText384
M
HIRE_DTHire DateDate
Must be formatted as YYYY-MM-DD
N
REHIRE_DTRehire DateDate
Must be formatted as YYYY-MM-DD
O
START_DTStart DateDate
Must be formatted as YYYY-MM-DD
P
TRMNTN_DTTermination DateDate
Must be formatted as YYYY-MM-DD
Q
KEY_MGMT_PRSNL_FLGKey Management PersonnelBit
Expects 1 for True and 0 for False
R
SR_MGMT_OFFCL_FLGSenior Management OfficialBit
Expects 1 for True and 0 for False
SYes
Unique
NTWRK_LOGIN_ID_TXTLogin 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.
T
LCTN_TXTLocationText128
U
BSNS_UNIT_TXTBusiness UnitText128
V
ORG_NME_TXTOrganizationText128
W
DVSN_TXTDivisionText128
X
TITLETitleText128
Y
GRADEGradeText128
Z
COST_CENTERCost CenterText25
AA
GNDR_DESCGenderText1Expects M for Male, F for Female or U for Unknown
ABYesCTZNSHP_DESCCitizenship DescriptionText128Has an associated System Profile (Drop Down)
AC
BIRTH_DTDate of BirthDateMust be formatted as YYYY-MM-DD
AD
BIRTH_CNTRYCountry of BirthText128Has an associated System Profile (Drop Down)
AE
BIRTH_CITYCity of BirthText60
AF
BIRTH_STState of BirthText60
AG
PERSNL_EMAIL_TXTPersonal EmailText50
AH
CELL_NMRCell Phone NumberText20
AI
HOME_ADDR1Home Address 1Text60
AJ
HOME_ADDR2Home Address 2Text30
AK
HOME_CITYHome CityText20
AL
HOME_STATE_CDHome StateText5
AM
HOME_ZIP5Home ZipText5Only Numbers Allowed
AN
MGR_EMP_NMRManager Employee NumberText15For purposes of Portal Commander, this individual will be granted the Supervisor Role



Change Log

Last Updated: March 24, 2025
Updated the Table to include specific information about Manager Employee Number field along with the CSV (Spreadsheet) column references.

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