ProCountor salary data, breakdown format

Column

Field

Integration query field

Type

Notes

A

Row type

Set automatically

string

Always with value "E"

B

Social security number

Set automatically

string

C

Pay grade code

SalaryCode

string

Salary code

D

Pay grade name

ProcountorERowPaygradeName

string

Left empty in export. Overridden by ProcountorERowPaygradeName

E

Amount

Amount

decimal, comma as decimal separator

F

Rate

ProcounterERowRate

decimal, comma as decimal separator

Left empty in export. Overridden by ProcounterERowRate

G

Project 1 name

ProjectName1

string

H

Project 1 code

ProjectCode1

string

I

Project 2 name

ProjectName2

string

J

Project 2 code

ProjectCode2

string

K

Project 3 name

ProjectName3

string

L

Project 3 code

ProjectCode3

string

M

Project 4 name

ProjectName4

string

N

Project 4 code

ProjectCode4

string

O

Project 5 name

ProjectName5

string

P

Project 5 code

ProjectCode5

string

Q

Project 6 name

ProjectName6

string

R

Project 6 code

ProjectCode6

string