Employee Direct Deposits Data Load Specifications

Using the Data Load Module in your HRIS Portal, you have the ability to mass import employee information into the system. 

When preparing your data for import to update employee records, make sure each file is in standard CSV file format with " as a text qualifier.

You will need to include "CO" (your company ID number) and any other "Required" fields indicated below.

Downloadable Specifications

You can download a Template File and Spec Sheet for Employee Direct Deposit Imports using the links below:

• Employee Direct Deposit Import Template File
• Employee Direct Deposit Import Specifications

Specifications

Note: The import file must contain all columns listed below in the order listed. You may leave non-required fields blank.

 

Field	Description	Required	Data type	Validation	Comments / Notes
co	Millennium Company code	X	X(10)	Valid Co Code
id	The employee id. This number is the unique identifier for the employee. It must be 6 characters in length and can not contain any trailing spaces. (If fewer than 6 characters are entered Millennium will automatically left pad the value with spaces until it is 6 characters in length.	X	X(6)	N/A
SSN	Social Security Number	X	x(11)		Format: 012-34-5678
startDate	Deduction start date		datetime	MM/DD/YYYY	If this field is null, current date will be used as the start date.
endDate	Deduction End date		datetime	MM/DD/YYYY	If this field is null, default date (12/31/2100) will be used.
aba	Bank Routing Number	X	x(9)		If employee chooses to enroll in Direct Deposit, all seven required fields have to be filled out.
acct	Account Number	X	x(20)	Note: leading zeros matter
cs	Checking or Savings	X	x(1)	"C", "S"	C=Checking, S=Savings *Note: These are case-sensitive.
fp	Flat or Percentage	X	x(1)	"F", "%"	F=Flat Amount, %=Percentage *Note: These are case-sensitive.
amount	Amount	X	decimal(14,2)		Amount to direct deposit - $ amount for flat, numeric percentage for % (100%).  An amount of 0 will end the record
priority	Priority	X	9(3)	"1", "2", "3"	Order of direct deposit 1,2,3 etc.
prenoteDate	Prenote date		datetime		If the prenote is null, HSA will send a prenote with the next payroll and populate this date.
nameonAccount	Name on account	X	X(30)

Notes:

• If a matching record (the same routing and account numbers) currently exists in the system,  the existing record will be updated.
• If the startdate field is null, the current date will be used as the startdate of the record.
• The enddate of an existing record that was disconnected will be the current date (or the startdate of the new record) - 1.
• If the enddate is null, 12/31/2100 will be used.  12/31/2100 should be used to indicate a "forever" date.
• To end an existing direct deposit that is not replaced with a new record, send an entry with the amount set to 0.  The existing direct deposit will be ended with the enddate provided or if the enddate is null, the current date will be used as the enddate.
• Priority is the sequential order in which direct deposits occur.  For multiple direct deposit entries, flat amounts should usually occur prior to percentage based amounts.  To ensure an entire paycheck is sent via direct deposit, the last direct deposit entry should be 100%.  Priorities can also be set directly in the  HSA system after the import .prenoteDate should typically be null.