Breadcrumbs

CSV Export – Technical Specification

This article aims to describe the CSV export format specifications for a pay period.

This article provides technical information regarding the export file format. Some technical knowledge is necessary in order to fully understand the terminology.

Export file characteristics

  • The file always has a “.csv” extension

  • The file data is encoded with UTF-8 encoding

  • Column data is comma delimited

  • The first line of the file contains header data which describes the nature of the information in each column.

  • The order of the columns is always the same (see details in the next section).

Data format

Here is the format of each column, in order:

Pass

Description

Format

HAS

Company
Matches your organization ID.

Text

B

Pay period year
Fiscal year associated with the pay period. For example, for pay period 2025#49, this field will contain the value “2025”.

Integer numeric

C

Pay period number
Sequential number associated with the pay period. For example, for pay period 2025#49, this field will contain the value “49”.

Integer numeric

D

Pay period review
Revision number for the pay period. Contains “0” for the original version of a pay period. Then contains a sequential number for each correction. For example, for pay period 2025#49 R3, this field will contain the value “3”.

Integer numeric

E

Employee number
Contains the employee number as configured in the employee file.

If the employee in question does not have an employee number, this field will be empty!

Text

F

Project number
Corresponds to the project number associated with the data. This number makes it possible to identify the project phase which is associated with this data.

Text

G

Date
Contains the date associated with the data. The format will always be “YYYY-MM-DD”; for example, for November 23, 2025, this field will contain “2025-11-23”.

Date
YYYY-MM-DD

H

Kind
Corresponds to the type of gain associated with this data. To see the correspondence of the types of gain, see the table Types of winning.

Integer numeric

I

Type Details
Sometimes adds precision related to the type of gain.

Text

J

Quantity
The raw quantity associated with this data. Sometimes the quantity is monetary, sometimes it is in hours. See the table Types of winning for more details.

Digital

K

Rate
The rate used to multiply the quantity and obtain a final amount for this data. If the quantity is already expressed monetarily, this rate will always be “1”.

Digital

L

Amount
Amount to be paid to the employee for this gain.

Digital

M

Collective agreement
Code of the collective agreement associated with this gain. See the agreements section to see the different collective agreements supported.

Text

N

Occupation
Occupation code for this gain. See the conventions section to see the different professions supported.

Text

O

Skill level
Skill level associated with the profession. See the conventions section to see the different skill levels supported

Text

P

Appendix
Appendix code used to locate the correct hourly rate to use for this gain. See the conventions section to see the different supported appendices.

Text

Q

Status
Status code associated with this gain. This value corresponds to the status code, specified in the configurable statuses.

Text

R

Activity
Type of main site work performed.

Text


Types of winning

The export format allows you to differentiate between the following types of gain:

Value

Description

Quantity in

1

Simple time
Working time paid at a straight rate.

Hours

2

Time and a half
Working time paid at time and a half.

Hours

3

Double time
Working time paid at double rate.

Hours

4

Presentation time
Working time linked to presentation time on site.

Hours

5

Spent
Expense to be reimbursed to the employee. In the case of expenses, the “Type Details” column contains the type of the expense.

Monetary

6

Harmonized Sales Tax (HST)
Tax associated with expenses.

Monetary

7

Federal Sales Tax (GST)
Tax associated with expenses.

Monetary

8

Provincial sales tax (QST)
Tax associated with expenses.

Monetary

9

Tools
Compensation for handling tools.

Monetary

10

Meal
Compensation for meals.

Monetary

11

Vehicle use
Compensation for use of a personal vehicle.

Monetary

12

Travel time
Compensation for travel time.

Monetary

13

Travel bonus
Flat-rate or per kilometer premiums for travel.

Monetary

14

Pension
Compensation for board or lodging costs.

Monetary

15

Public transportation
Compensation for use of public transport.

Monetary

16

Evening bonus
Bonus for evening work or shifts.

Hours

17

Night bonus
Bonus for night work or shifts.

Hours

18

Individual bonus
Individual bonus to be paid, as configured in the employee file.

Monetary

19

Leader or status bonus (simple time)
Leader bonus (team, group or other status linked to a collective agreement) for time at a simple rate.

Hours

20

Leader or status bonus (time and a half)
Leader bonus (team, group or other status linked to a collective agreement) for time at time and a half.

Hours

21

Leader or status bonus (double time)
Leader bonus (team, group or other status linked to a collective agreement) for time at double rate.

Hours

22

Leader or status bonus (presentation time)
Leader bonus (team, group or other status linked to a collective agreement) for presentation time.

Hours

23

Travel time (vehicle provided)
Compensation for travel time before vehicle provided.

Monetary

24

Height bonus
Bonus for carrying out work on suspended scaffolding or a cage suspended at a height of 10 meters or more above any surface.

Monetary

25

Powered ventilation mask premium
Bonus for the use of a mask with assisted ventilation or a continuous flow or positive pressure breathing air supply.

Monetary

26

Crane operator bonus

Monetary

27

Bonus for connection work

Monetary

28

Bonus for welding work

Monetary

29

Fixed transport premium

Monetary

30

Custom
Any custom bonus configured in your settings.

Depending on the type of personalized bonus.

Agreements

The software supports several conventions in order to automate calculations. Here are the details regarding the export of these different conventions:

CCQ (Quebec)

The CCQ conventions bring together calculations specific to construction projects regulated by the CCQ in Quebec.

Agreement

In payroll, a convention is used for each sector of the CCQ. Here are the matches:

Convention (sector)

Value

Industrial

CCQ.Industrial

Institutional and commercial

CCQ.InstitutionalAndCommercial

Civil engineering and roads

CCQ.CivilEngineering

Residential

CCQ.Residential

Excluding decree with CCQ calculations

CCQ.Unregulated

Professions

Occupation

Value

For the CCQ, the “Profession” field will contain the profession code, prefixed with “CCQ.”. For example, for a mason, the “Profession” field will contain the value “CCQ.110”.

CCQ.<code>

Skill Levels

For the CCQ, the “Skill level” field will always be empty except when the gain is associated with an apprentice level. Here are the matches:

Skill level

Value

Profession is a skill

<empty>

Companion of a trade

Journeyman

Apprentice level 1

Apprentice1

Apprentice level 2

Apprentice2

Apprentice level 3

Apprentice3

Apprentice level 4

Apprentice4

Apprentice level 5

Apprentice5

Appendices

Appendix

Value

For the CCQ, we will see in the “Annex” field the same annex codes as those of the CCQ. For example, for institutional and commercial day work, the “Appendix” field will contain the value “C3”.

<code>

Excluding decree

Decree hours do not follow specific collective agreement rules.

Agreement

The field always contains the value “Unregulated”.

Agreement

Value

Excluding decree

Unregulated

Professions

Occupation

Value

Always empty

<empty>

Skill Levels

Skill level

Value

Always empty

<empty>

Appendices

Appendix

Value

Individual rate configured for an employee

∅

Configured appendices use the configured appendix code.

<code>

Carpenters (Ontario)

The Carpenters Agreement allows the calculations of the Carpenters Union in Ontario to be used.

Agreement

Agreement

Value

Carpenters

Ontario.Carpenters

Professions

Occupation

Value

Carpenter

Carpenter

Skill Levels

Skill level

Value

Companion of a trade

Journeyman

Apprentice level 1

Apprentice1

Apprentice level 2

Apprentice2

Apprentice level 3

Apprentice3

Apprentice level 4

Apprentice4

Appendices

Appendix

Value

Barrie

27.18

Belleville

397.4

Cambridge

785

Cobourgh

397.3

Cornwall

93.2

Goderich

2222

Hamilton

18.1

Kingston

249.1

London

1946

Niagara Area

18.2

Oshawa

397.1

Ottawa

93.1

Pembroke

93.3

Peterborough

397.2

Sarnia

1256

Sault Ste. Married

2486.2

Smiths Falls

249.2

Sudbury

2486.1

Thunder Bay

1669

Toronto

27.8

Windsor

494