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). |