Bewerken: Employee (Medewerker)

Sectie: Belangrijkste properties

Reden:

## Belangrijkste properties

| Property | Type | Kolom | Nullable | Omschrijving |
|----------|------|-------|----------|-------------|
| Id | UltimoString(9) | EMPID | Nee | Medewerker-ID |
| Description | UltimoString(200) | EMPDESCR | Ja | Volledige naam |
| FirstName | UltimoString(50) | EMPFIRSTNAME | Ja | Voornaam |
| MiddleName | UltimoString(50) | EMPMIDDLENAME | Ja | Tussenvoegsel |
| Surname | UltimoString(50) | EMPSURNAME | Ja | Achternaam |
| Initials | UltimoString(15) | EMPINITIALS | Ja | Initialen |
| Function | UltimoString(200) | EMPFUNCTION | Ja | Functie |
| EmailAddress | UltimoString(80) | EMPEMAILADDRESS | Ja | E-mailadres |
| Phone | UltimoString(25) | EMPPHONE | Ja | Telefoonnummer |
| PhoneInternal | UltimoString(25) | EMPINTPHONE | Ja | Intern telefoonnummer |
| MobilePhone | UltimoString(25) | EMPMOBPHONE | Ja | Mobiel nummer |
| AddressLine1 | UltimoString(100) | EMPADDRESSLINE1 | Ja | Adresregel 1 |
| City | UltimoString(40) | EMPCITY | Ja | Woonplaats |
| ZipCode | UltimoString(10) | EMPZIPCODE | Ja | Postcode |
| BirthDate | Date? | EMPBIRTHDATE | Ja | Geboortedatum |
| DateInLabour | Date? | EMPDATEINLABOUR | Ja | Datum in dienst |
| DateOutLabour | Date? | EMPDATEOUTLABOUR | Ja | Datum uit dienst |
| Hours | Decimal | EMPHOURS | Nee | Contracturen |
| SalaryPerMonth | CompanyMoney | EMPMNTHSALARY | Nee | Maandsalaris |
| Tariff1-4 | CompanyMoney | EMPTARIFF1-4 | Nee | Uurtarieven |
| ContractNumber | UltimoString(30) | EMPCONTRACTNR | Ja | Contractnummer |
| Gender | Gender | EMPGDRID | Ja | Geslacht |
| SelectForBookHours | Boolean | EMPSELECTFORBOOKHOURS | Nee | Beschikbaar voor uren boeken |

---