Please enable JavaScript to view this site.

Exact Online API Data Model

Navigation: Catalog: ExactOnlineREST > Schemas > Schema: Payroll > Tables

Employees: Exact Online Employees

Contents Previous Home Next More

Catalog: ExactOnlineREST

Schema: Payroll

Primary Keys: ID

Label: Employees

The data in this table is partitioned per value of the Division column.

Can retrieve data and change data using insert, update and delete.

Select Exact Online API URL: /api/v1/{division}/payroll/Employees

Insert Exact Online API URL: /api/v1/{division}/payroll/Employees

Update Exact Online API URL: /api/v1/{division}/payroll/Employees

Delete Exact Online API URL: /api/v1/{division}/payroll/Employees

Exact Online API Metadata URL: /api/v1/{division}/payroll/$metadata

Field Selection Method: Required

Table Columns

The columns of the table Employees are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

Name

Data Type

Label

Required

Documentation

ActiveEmployment

int16

 

Obsolete.

AddressLine2

string(60)

Address Line 2

Second address line.

AddressLine3

string(60)

Address Line 3

Third address line.

AddressStreet

string

Address Street

Street of address.

AddressStreetNumber

string

Address Street Number

Street number of address.

AddressStreetNumberSuffix

string

Address Street Number Suffix

Street number suffix of address.

BirthDate

datetime

Birth Date

Birth date.

BirthName

string

Birth Name

Birth name.

BirthNamePrefix

string

Birth Name Prefix

Birth middle name.

BirthPlace

string

Birth Place

Birth place.

BusinessEmail

string(128)

Business Email Address

Email of the employee at the office.

BusinessFax

string(25)

Business Fax

Fax number of the employee at the office.

BusinessMobile

string(25)

Business Mobile

Office mobile number of the employee.

BusinessPhone

string(25)

Business Phone

Phone number of the employee at the office.

BusinessPhoneExtension

string(15)

Business Phone Extension

Phone extension of the employee at the office.

CASONumber

string

 

Obsolete.

City

string(30)

City

City.

Code

string

Code

Code of the employee.

Country

string(30)

Country

Country code.

Created

datetime

Created

Creation date.

CreatedUtc

datetime

Created (UTC)

Creation date in UTC.

Creator

guid

Creator

User ID of creator.

CreatorFullName

string(240)

Creator Full Name

Name of creator.

Customer

guid

Customer

Customer ID.

Division

int32

Division

Division code.

DivisionCompanyCoCNumber

string(20)

Division Chamber of Commerce Number

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Division IBAN Number

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Division Company Name

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Division RSIN Number

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Division VAT Number

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Division Wage Tax Number

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Division Label

Label of the Exact Online division.

DivisionName

string(50)

Administration Name

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Subscription Holder Name

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

DivisionOwnerCompanyNumber

string(18)

Subscription Holder Number

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

DivisionShortName

int64

Division Short Name

Short name of the Exact Online division.

Email

string(128)

Email

Email address.

EmployeeHID

int32

Employee HID

Employee number.

EndDate

datetime

End Date

End date of the employee.

FirstName

string(64)

First Name

First name of the employee.

FullName

string(240)

Full Name

Full name of the employee.

Gender

string

Gender

Gender.

HID

int32

HID

Numeric ID of the employee.

ID

guid

ID

Primary key.

Initials

string(10)

Initials

Initials.

IsActive

boolean

Is Active

IsActive.

IsAnonymised

int16

Is Anonymised

Indicates whether the employee is anonymised.

Language

string(30)

Language

Language code.

LastName

string(60)

Last Name

Last name.

LocationDescription

string

 

Description of the location of the employee (where am I?).

Manager

guid

Manager

Direct manager of the employee.

MaritalDate

datetime

 

Date of marriage.

MaritalStatus

int16

 

Marital status.

MiddleName

string

Middle Name

Middle name.

Mobile

string(25)

Mobile

Mobile phone.

Modified

datetime

Modified

Last modified date.

ModifiedUtc

datetime

Modified (UTC)

Last modified date in UTC.

Modifier

guid

Modifier

User ID of modifier.

ModifierFullName

string(240)

Modified Full Name

Name of modifier.

Municipality

string

Municipality

Municipality.

NameComposition

int16

 

 

Nationality

string

Nationality

Nationality.

NickName

string

 

Nick name.

Notes

string

Notes

Additional notes.

PartnerName

string

Partner Name

Name of partner.

PartnerNamePrefix

string

Partner Name Prefix

Middle name of partner.

Person

guid

Person

Reference to the persons table in which the personal data of the employee is stored.

Phone

string(25)

Phone

Phone number.

PhoneExtension

string(15)

Phone Extension

Phone number extension.

PictureFileName

string

Picture File Name

Filename of picture.

PictureUrl

string

Picture (URL)

Url of picture.

Postcode

string(20)

Postal Code

Postcode.

PrivateEmail

string(128)

 

Private email address.

SocialSecurityNumber

string

Social Security Number

Social security number.

StartDate

datetime

Start Date

Start date of the employee.

State

string(30)

State

State/Province code.

Title

string

Title

Title.

User

guid

User

User ID of employee.

UserFullName

string(240)

User Full Name

Name of user.

 

14-04-2021 14:43 Version 20.1.394-BETA+3155