Export Utility Fields Mapping Table

Each data type in the Expression column should have a coordinating data type that you enter, when necessary, in the appropriate Expression field on the Export Employee from ABRA form Mapping tab.

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