Employee Tax Changes 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 Tax Imports using the links below:

• Employee Tax Import Template File
• Employee Tax 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
fitwexemptions	The number of Federal exemptions claimed by the employee.		decimal(8,2)		Federal number of exemptions from Federal W-4
fitwstatus	The Federal filing status claimed by the employee.		X(10)	S, "M", "NRA", "NRM"	Federal status.  Either "S", "M", "NRA" (single non-resident alien), "NRM" (married non-resident alien), depending on what was entered on federal W-4 *Note: These are case-sensitive.
sitw	The state income tax withholding code to modify		x(10)	CTax	State tax code, IE: ILSITW, WISITW, etc.  *Note: This is case-sensitive.
sitwexemptions	The number of exemptions claimed by the employee for state income tax withholding.		decimal(8,2)		State Exemptions.  Pass the number of exemptions elected.
sitwexemptions2	The number of additional exemptions claimed by the employee. (This is for a few states that have two sets of exemptions)		decimal(8,2)		Secondary State exemptions if applicable
sitwstatus	The filing status claimed by the employee for state income tax withholding.		X(10)		State Marital Status.  Pass same marital status provided on Federal W-4.

Notes:

This import only supports exemption and filing status changes to existing Federal and State withholding tax codes.  Changing states, adding tax codes, local taxes, unemployment, etc. must be handled through the HSA system.