Payroll Payments Import Layout

The layout below can be used to import Payroll Payments into the HRIS. Column Headers must be provided in the import file and the order of the columns must match the order specified in the table below. The import file must have the same number of columns as indicated in the table below, as well.

General Information on Importing Data

For general information on importing data including supported formats and common questions see Imports Overview

When is a Record Added vs Updated?

If an existing record is found using the key fields ([key]) identified below, the HRIS will update that record

Column Header

Data Type

Max Field Length

Required

Notes

Employee SSN

 

Text

 

9

 

Yes

 Unique; must be numeric

Received Date

 

Date

 

Yes 

Must be a valid date matching a Payment Record

Amount Received

 

Double

 

 

Yes

Amount Received

Trace Number

 

Text

 
50

 

Payment Tracking Number

Notes

 

Text

 
50



Payment Tracking Notes

Was this article helpful?
0 out of 0 found this helpful