Correspondence between fields in

Data conversion when importing a Human resources file from the Clearview application

Clearview

If empty = field does not exist

Employeur D

Hiring an employee

Rehire an employee

Modifying an existing employee file

Address1+Adress2

Address

Value indicated in the import file

Value indicated in the import file

Empty field = maintain the value of the employee file

Birth_date

Date of birth

Value indicated in the import file

Value indicated in the import file

Empty field = maintain the value of the employee file

City

City

Value indicated in the import file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Value indicated in the import file

Country_Code(CAN)

Country

Canada or U.S.A. (CAN / USA)

Canada or U.S.A. (CAN / USA)

Canada or U.S.A. (CAN / USA)

Email_address

Email address

Value indicated in the import file

Value indicated in the import file

Empty field = maintain the value of the employee file

Emp_cat_code

Schedule status

▪Empty field = apply the default value from the configuration screen

▪Non-empty field = converted value of the import file

▪Error value = line in error and rejection of file

▪Empty field = apply the default value from the configuration screen

▪Non-empty field = converted value of the import file

▪Error value = line in error and rejection of file

▪Empty field = apply the default value from the configuration screen

▪Non-empty field = converted value of the import file

▪Error value = line in error and rejection of file

Employer_code

(mandatory)

Company number (mandatory)

The company number entered in the file must correspond with the company number.

The company number entered in the file must correspond with the company number.

The company number entered in the file must correspond with the company number.

Emp_number

(mandatory)

Employee number

(mandatory)

The company number entered in the file must correspond with the company number.

The company number entered in the file must correspond with the company number.

The company number entered in the file must correspond with the company number.

Emp_status

Employee status

Default value = Active

Default value = Active

▪Empty field = maintain the value of the employee file

▪Active value / Inactive without a Term_date = value of the import file

▪Inactive value / with Term_date = value in the employee file

▪Error value = line in error and rejection of file

Expected_pay_hours

Number of hour per pay

Empty field = apply the default value from the configuration screen

Maintain the value of the employee file

Maintain the value of the employee file

First_name

First name

Value indicated in the import file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Value indicated in the import file

Last_name

Last name

Value indicated in the import file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Value indicated in the import file

Gender

Gender

Value indicated in the import file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Empty field = maintain the value of the employee file

Hire_date

Employment date

▪Value indicated in the import file

▪Empty field = line in error and rejection of file

Value is ignored

Value is ignored

Rehire date

N/A

The payroll application default value:

If an employee’s status changes from Terminated to Active, the first day of the current pay period will automatically be entered in the Date of rehire field.

N/A

Home_phone

Second_phone

Home_phone

Phone numbers:

Home number

Alternate num.

Cell phone

▪The Home_phone entry will be entered in Home number.

▪The Second_phone entry will be entered in Cell phone.

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Hourly_rate

Hourly rate

▪Value indicated in the import file

▪If value is > the company’s maximum rate = $0.01

▪Value indicated in the import file

▪If value is > the company’s maximum rate = $0.01

▪Value indicated in the import file

▪If value is > the company’s maximum rate = $0.01

Lang_key

Language

▪Non-empty field = converted value of the import file

▪Incorrect or empty value = choose the company language

▪Non-empty field = converted value of the import file

▪Empty field = maintain the value of the employee file

▪Incorrect value = choose the company language

▪Empty field = maintain the value of the employee file

▪Incorrect value = choose the company language

Job_Code

Position

▪If the field is empty = default value

▪If the field is not empty = verify if the position exists in the company and if a value is set in the configuration screen

▪If not = error message and rejection of file

▪Convert the file value or use it as is

▪If not = configuration screen value

▪Empty field = maintain the employee file value

▪If impossible = line in error and rejection of file

▪Convert the file value or use it as is

▪If not = configuration screen value

▪Empty field = maintain the employee file value

▪If impossible = line in error and rejection of file

(for all related Position fields click here)

Marital_statuts_key

Marital status

▪Empty field = leave field empty

▪Non-empty field = convert the file value

▪If value is incorrect = leave field empty

▪Empty field = maintain the value of the employee file

▪Non-empty field = convert the file value

▪If value is incorrect = leave field empty

▪Empty field = maintain the value of the employee file

▪Non-empty field = convert the file value

▪If value is incorrect = leave field empty

Postal_code

▪Postal code

▪Zip code – USA

Value indicated in the import file

Value indicated in the import file

Value indicated in the import file

Prov_state

Province of residence

▪Convert the file value

▪Empty field = applies the default value from the configuration screen

▪If impossible = line in error and rejection of file

▪Convert the file value

▪Empty field = maintain the value of the employee file

▪If impossible = line in error and rejection of file

▪Convert the file value

▪Empty field = maintain the value of the employee file

▪If impossible = line in error and rejection of file

Sin_ssn
(mandatory)

SIN
(mandatory)

Value indicated in the import file

▪Value indicated in the import file

▪Empty field = maintain the value of the employee file

Empty field = rejection of file

Term_date

Termination date

Unused field

Unused field

Unused field

Work_prov

Work province

Same as the province of residence

Change of province = exemption value in effect

Change of province = exemption value in effect

Wages display format

The payroll application default value = 004-Rate only

Maintain the value of the employee file

Unused field

Add to massive printing

The payroll application default value = Y or N

Maintain the value of the employee file

Maintain the value of the employee file

Actual rate application date

▪Default value = employment date

▪Empty field or impossible = today’s date

Default value = date of rehire

Maintain the value of the employee file

Employment date

▪Employment date

▪Empty field = line in error and rejection of file

Field value must be empty

Field value must be empty

Salary change date

Default value = employment date

Default value = date of rehire

Maintain the value from the employee file

Basic deduction (federal)

The payroll application default value

Maintain the value from the employee file

Unused field

Basic deduction (provincial)

The payroll application default value

▪Maintain the value of the employee file

▪Change of province = exemption value in effect

▪Maintain the value of the employee file

▪Change of province = exemption value in effect

Smoker

The payroll application default value = Y or N

Maintain the value from the employee file

Unused field

Payment method

The payroll application default value = Cheque

Maintain the value from the employee file

Unused field

Citizenship

The payroll application default value = Canadian

Maintain the value from the employee file

Unused field

Employment insurance rate

▪Configuration screen value (company level)

▪If not = Configuration screen value (company level)

Maintain the value from the employee file

Maintain the value from the employee file

Remuneration type

Application of the default value “Hourly rate”

Maintain the value from the employee file

Maintain the value from the employee file

Wages display format (reports)

Application of default value “Rate only”

Maintain the value from the employee file

Maintain the value from the employee file

Deposit type

Information excluded from import, to be completed in the payroll application.

Maintain the value from the employee file

Maintain the value from the employee file