03. HR Data Load - Data Elements

PROPRIETARY


 

Compatible Version(s)

  • AC v4.202501 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
Length

Comments

ARequiredLAST_NMELast NameText40
BRequiredFIRST_NMEFirst NameText40
C MIDDLE_NMEMiddle NameText40
D
SUFFIXSuffixText128Has an associated System Profile (Drop Down).
If Personnel has no Suffix, pass as an Empty String or NULL.
E
NICK_NMENicknameText40
FRequiredFCLTY_CDFacility CodeText25Facility must exist in Facility Management module as a Host Facility
GRequired
Unique
SSNSocial Security NumberText11Must be formatted as ###-##-####
HRequiredEMP_NMR_TXTEmployee NumberText15
IRequiredEMP_TYP_DESCEmployee TypeText128Has an associated System Profile (Drop Down)
JRequiredEMP_STS_DESCStatusText128Has an associated System Profile (Drop Down)
K WORK_PHONE_NMRWork PhoneNumeric20Only Numbers allowed
LRequired
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
SRequired
Unique
NTWRK_LOGIN_ID_TXTLogin IdText384This column helps define the username for any future User Accounts used by any of our products.
Customers with SSO configuration should have this match the UPN in the IdP.
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
ABRequiredCTZNSHP_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 StateText2Only US State Abbreviations Allowed
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: July 3, 2025
Updated Version Compatibility.

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