UltiPro Export Key


Axxess Hospice generates UltiPro file exports based on the exact template specifications provided by UltiPro. To help you understand the values displayed in each column, the following table outlines how each data point is calculated.


Column

Header

Description

 

A

COMPANY CODE

Displays the company code per branch for UltiPro as established in Company Setup.

 

B

BATCH ID

Displays the auto-populated batch ID associated with the visits that are being exported.

 

C

FILE #

Displays the employee payroll ID number from the employee’s profile.

 

D

NAME

Displays the the employee’s last name, first name and middle initial as applicable.

 

E

RATE CODE

Remains blank. Only the header will display.

 

F

REG HOURS

Displays the sum of all visit hours (patient visits only, not NPAs) per employee for the visits selected to be exported.

 

G

O/T HOURS

Remains blank. Only the header will display.

 

H

PTO CODE

Displays the PTO earning code established by the organization on the Payroll Earning Codes table.

 

I

PTO AMOUNT

Displays the sum of all PTO hours per employee for the task/visit/NPA selected to be exported.

 

J

HOLID CODE

Displays the holiday earning code established by the organization on the Payroll Earning Codes table.

 

K

HOLID AMOUNT

Displays the sum of all holiday hours per employee for the task/visit/NPA selected to be exported.

 

L

FLOAT CODE

Displays the float day earning code established by the organization on the Payroll Earning Codes table.

 

M

FLOAT AMOUNT

Displays the sum of all float day hours per employee for the task/visit/NPA selected to be exported.

 

N

BERV CODE

Displays the bereavement earning code established by the organization on the Payroll Earning Codes table.

 

O

BERV AMOUNT

Displays the sum of all bereavement hours per employee for the task/visit/NPA selected to be exported.

 

P

JURY DUTY

Displays the jury duty earning code established by the organization on the Payroll Earning Codes table.

 

Q

JURY DUTY AMOUNT

Displays the jury duty hours per employee for the task/visit/NPA selected to be exported.

 

R

PARENTAL LEAVE CODE

Displays the parental leave earning code established by the organization on the Payroll Earning Codes table.

 

S

PARENTAL LEAVE AMOUNT

Displays the parental leave hours per employee for the task/visit/NPA selected to be exported.

 

T

HOURS 3 CODE

Displays all other earning codes by earning code name as established by the organization on the Payroll Earning Codes table for the task/visit/NPA selected to be exported.

 

U

HOURS 3 AMOUNT

Displays the sum of all all other earning codes hours by earning code name as established by the organization on the Payroll Earning Codes table for the task/visit/NPA selected to be exported.

 

V

UNPAID TIME OFF CODE

Displays the unpaid PTO earning code established by the organization on the Payroll Earning Codes table.

 

W

UNPAID TIME OFF AMOUNT

Displays the sum of all unpaid PTO hours per employee for the task/visit/NPA selected to be exported.

 

X

CODE

Displays the mileage earning code established by the organization on the Payroll Earning Codes table.

 

Y

AMOUNT

Displays the sum of all associated mileage (miles driven, unreimbursed amount) per employee for the task/visit/NPA selected to be exported.

 

Z

EMPLOYEE TYPE

Displays the employee’s pay type (salary, hourly, per visit).