ActiveEmployments: Exact Online Actieve Dienstverbanden

AverageDaysPerWeek

double

Gemiddeld Dagen per Week

☐

The average number of contract days that an employee works per week.

AverageHoursPerWeek

double

Gemiddeld Uren per Week

☐

The average number of contract hours that an employee works per week.

Contract

guid

{res:itgen_eol_contract}

☐

Employment contract ID.

ContractDocument

guid

{res:itgen_eol_contractdocument}

☐

Document ID of the employment contract.

ContractEndDate

datetime

{res:itgen_eol_contractenddate}

☐

End date of employment contract.

ContractProbationEndDate

datetime

{res:itgen_eol_contractprobationenddate}

☐

Employment probation end date.

ContractProbationPeriod

int32

{res:itgen_eol_contractprobationperiod}

☐

Employment probation period.

ContractStartDate

datetime

{res:itgen_eol_contractstartdate}

☐

Start date of employment contract.

ContractType

int32

{res:itgen_eol_contracttype}

☐

Type of employment contract. 1 - Definite, 2 - Indefinite, 3 - External.

ContractTypeDescription

string(240)

{res:itgen_eol_contracttypedescription}

☐

Description of employment contract type.

Created

datetime

Gemaakt

☐

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string(240)

Aanmaker Volledige Naam

☐

Name of creator.

Department

guid

Afdeling

☐

Department of employee.

DepartmentCode

string

Afdelingscode

☐

Department code of employee.

DepartmentDescription

string

Afdelingsomschrijving

☐

Description of department.

Division

int32

Divisie

☐

Division code.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

Employee

guid

Medewerker

☐

Employee ID.

EmployeeFullName

string(240)

Medewerker Volledige Naam

☐

Name of employee.

EmployeeHID

int32

Medewerker HID

☐

Numeric number of Employee.

EmploymentOrganization

guid

{res:itgen_eol_employmentorganization}

☐

Organization of employment.

EndDate

datetime

Einddatum

☐

End date of employment.

HID

int32

HID

☐

Numeric ID of the employment.

HourlyWage

double

Uurloon

☐

Hourly wage.

ID

guid

ID

☑

Primary key.

InternalRate

double

Intern Tarief

☐

Internal rate for time & billing or professional service user.

Jobtitle

guid

Functietitel

☐

Job title of employee.

JobtitleDescription

string

Functieomschrijving

☐

Description of job title.

Modified

datetime

Gewijzigd

☐

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string(240)

Gewijzigd Volledige Naam

☐

Name of modifier.

ReasonEnd

int32

Reden Beeindiging

☐

ID of employment ended.

ReasonEndDescription

string

{res:itgen_eol_reasonenddescription}

☐

Reason of end of employment.

ReasonEndFlex

int32

Reden Einde Flex

☐

Reason of ended flexible employment.

ReasonEndFlexDescription

string

{res:itgen_eol_reasonendflexdescription}

☐

Other reason for end of employment.

Salary

guid

Salaris

☐

Employment salary.

Schedule

guid

Schema

☐

Work schedule.

ScheduleAverageHours

double

{res:itgen_eol_scheduleaveragehours}

☐

Average hours per week in a schedule.

ScheduleCode

string

Schemacode

☐

Work schedule code.

ScheduleDays

double

Schema Dagen

☐

Number of days of work per week.

ScheduleDescription

string

Schema Omschrijving

☐

Description of work schedule.

ScheduleHours

double

Schema Uren

☐

Number of work hours per week.

StartDate

datetime

Startdatum

☐

Start date of employment.

StartDateOrganization

datetime

{res:itgen_eol_startdateorganization}

☐

Start date of the employee in the organization. This field is used to count the years in service.