Rate Change 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 Rate Change Imports using the links below:

• Employee Rate Change Import Template File
• Employee Rate Change 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
rateCode		X	X(10)		Base
rate		X	Decimal(14,4)
cc1	Cost Center		X(10)	CDept1	CC1 if rates are cost center specific.
cc2	Cost Center		X(10)	CDept2	CC2 if rates are cost center specific.
cc3	Cost Center		X(10)	CDept3	CC3 if rates are cost center specific.
cc4	Cost Center		X(10)	CDept4	CC4 if rates are cost center specific.
cc5	Cost Center		X(10)	CDept5	CC5 if rates are cost center specific.
startDate			datetime	MM/DD/YYYY	If this field is null, current date will be used as the start date.
endDate			datetime	MM/DD/YYYY	Default: 12/31/2100

Notes:

• If a matching record (the same ratecode) currently exists in the system, the existing code will be disconnected and a new record will be inserted into the system.
• If the startdate field is null, the current date will be used as the startdate of the  new ratecode.
• The enddate an existing record that was disconnected will be 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.