Employees: Exact Online Employees

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.