Import Utility Fields Mapping Table

Each data type in the Vision Field(s) column should have a coordinating data type that you enter, when necessary, in the appropriate Expression field on the Import Employee from ABRA Form Mapping tab.

Field Description
Employee P_EMPNO
LastName L_NAME
FirstName P_FNAME
JobCostRate P_UNITRATE
JobCostType P_UNITPAY
HoursPerDay P_NORMUNIT
HireDate P_ORIGHIRE
RaiseDate P_NEXTPAY
Status P_ACTIVE
SSN P_SSN
Address1 P_HSTREET1
Address2 P_HSTREET2
City P_HCITY
State P_HSTATE
ZIP P_HZIP
Country P_HCOUNTRY
Phone P_HPHONE
Email P_HEMPEMAIL
TerminationDate P_TERMDATE