title: "Employee" category: reference tags: [entity, employee, datamodel] source: Entities.xml date: 2026-04-17 status: published
Employee
Type: Entity Properties: 90 Contexts: 6 Statussen: 2
Zie ook het handgeschreven artikel: employee
DB-schema:
lookup_table_schema("Employee")· ../tables/Employee
Contextsbewerken
- 0: Standaard (
EmployeeContext.None) - 1: Standaard (
EmployeeContext.Standard) - 2: Relatie (
EmployeeContext.Relation) - 4: Contactpersoon (
EmployeeContext.ContactPerson) - 8: Systeemgebruiker (
EmployeeContext.SystemUser) - 16: Extern personeel (
EmployeeContext.ExternalPersonnel)
Statussenbewerken
- -1: Trash (
EmployeeStatus.Trash) - 0: None (
EmployeeStatus.None)
Propertiesbewerken
| Property | Type | Kolom | Width | Nullable | Default |
|---|---|---|---|---|---|
| Id | UltimoString | EMPID | 9 | false | |
| _ArticleResults | UltimoString | _EMPARTICLERESULTS | true | ||
| AddressLine1 | UltimoString | EMPADDRESSLINE1 | 100 | true | |
| AddressLine2 | UltimoString | EMPADDRESSLINE2 | 100 | true | |
| AddWeek | Boolean | EMPADDWEEK | false | 0 | |
| AnonymizedLongTerm | Boolean | EMPANONYMIZEDLONGTERM | false | 0 | |
| AnonymizedShortTerm | Boolean | EMPANONYMIZEDSHORTTERM | false | 0 | |
| ApprovalLevel | ApprovalLevel | EMPALID | true | ||
| BirthDate | Date? | EMPBIRTHDATE | true | ||
| City | UltimoString | EMPCITY | 40 | true | |
| ContactProcessFunctions | List[ProcessFunction] | PRFCONTACTEMPID | true | ||
| Context | Context | EMPCONTEXT | false | 1 | |
| ContractNumber | UltimoString | EMPCONTRACTNR | 30 | true | |
| CostCenter | CostCenter | EMPCCRID | true | ||
| Country | Country | EMPCNTRID | true | DefaultCountryId | |
| Craftsman | Craftsman | EMPCRMID | true | ||
| CulturePreference | UltimoString | EMPCULTURE | 15 | true | |
| CurrentWeek | WeekOfYear | EMPCURRWEEK | false | ||
| DataProvider | UltimoString | EMPDATAPROVIDER | 50 | true | |
| DateInLabour | Date? | EMPDATEINLABOUR | true | ||
| DateOutLabour | Date? | EMPDATEOUTLABOUR | true | ||
| Department | Department | EMPDEPID | true | ||
| Description | UltimoString | EMPDESCR | 200 | true | |
| EmailAddress | UltimoString | EMPEMAILADDRESS | 80 | true | |
| Exported | Boolean | EMPEXPORTED | false | ||
| ExternalId | UltimoString | EMPEXTERNALID | 50 | true | |
| ExternalStatus | UltimoString | EMPEXTERNALSTATUS | 50 | true | |
| Extra1 | Int32 | EMPEXTRA1 | false | ||
| Extra2 | Int32 | EMPEXTRA2 | false | ||
| Extra3 | UltimoString | EMPEXTRA3 | 16 | true | |
| Extra4 | UltimoString | EMPEXTRA4 | 5 | true | |
| Extra5 | UltimoString | EMPEXTRA5 | 5 | true | |
| Extra6 | UltimoString | EMPEXTRA6 | 5 | true | |
| FirstAidProfession | Profession | EMPBHVPROFID | true | ||
| FirstName | UltimoString | EMPFIRSTNAME | 50 | true | |
| Function | UltimoString | EMPFUNCTION | 200 | true | |
| Gender | Gender | EMPGDRID | true | ||
| Hours | Decimal | EMPHOURS | false | ||
| ImageFile | UltimoString | EMPIMAGEFILE | true | ||
| ImageFile2 | UltimoString | EMPIMAGEFILE2 | true | ||
| Initials | UltimoString | EMPINITIALS | 15 | true | |
| IsAllowedToSignForAcceptance | Boolean | EMPISALLOWEDTOSIGNFORACCEPTANCE | false | 0 | |
| JobPlans | List[JobPlan] | JPEMPID | true | ||
| LabourWeeks | List[EmployeeLabour] | EMPLEMPID | false | ||
| LanguagePreference | SystemCountry | EMPSCOUID | true | ||
| LearningManagementSystemExternalId | Int32 | EMPLMSEXTERNALID | false | 0 | |
| MediaFile | Media | EMPMEDID | true | ||
| MiddleName | UltimoString | EMPMIDDLENAME | 50 | true | |
| MobilePhone | UltimoString | EMPMOBPHONE | 25 | true | |
| ObjectContacts | List[ObjectContact] | OBJCONEMPID | true | ||
| ObjectFeatures | List[ObjectFeature] | OBJFEMPID | true | ||
| Phone | UltimoString | EMPPHONE | 25 | true | |
| PhoneInternal | UltimoString | EMPINTPHONE | 25 | true | |
| PreventiveMaintenanceSuccessEmail | Boolean | EMPSENDPMSUCCESSEMAIL | false | 0 | |
| Profession | Profession | EMPPROFID | true | ||
| ProviderMutationDate | DateTime? | EMPPROVIDERMUTDATE | true | ||
| ProvinceStateRegion | UltimoString | EMPPROVINCESTATEREGION | 40 | true | |
| ReceiveHealthSafetyEnvironmentReportMail | Boolean | EMPRECEIVEHSEREPORTMAIL | false | 0 | |
| RecordChangeDate | DateTime? | EMPRECCHANGEDATE | true | ||
| RecordCreateDate | DateTime? | EMPRECCREATEDATE | true | SYSDATETIME | |
| ReservableObject | ReservableObject | EMPRESOID | true | ||
| ResponsibleForSafetyDossiers | List[SafetyDossier] | SAFDRESPONSIBLEEMPID | true | ||
| SafetyDossierReviewers | List[SafetyDossierReviewer] | SAFDREMPID | false | ||
| SafetyDossierReviewerType | SafetyDossierReviewerType | EMPSAFETYDOSSIERREVIEWTYPE | false | 0 | |
| SafetyDossierReviews | List[SafetyDossierReview] | SAFDRVEMPID | true | ||
| SafetyDossiersToManage | List[SafetyDossier] | SAFDMANAGEMPID | true | ||
| SalaryAllowance | CompanyMoney | EMPSALALLWNC | false | 0 | |
| SalaryPerMonth | CompanyMoney | EMPMNTHSALARY | false | 0 | |
| SelectForBookHours | Boolean | EMPSELECTFORBOOKHOURS | false | 1 | |
| ShowAge | Boolean | EMPSHOWAGE | false | 1 | |
| ShowBirthday | Boolean | EMPSHOWBIRTHDAY | false | 1 | |
| Site | Site | EMPSITID | true | ||
| SkillCategories | List[SkillCategory] | SKCMANAGEMPID | true | ||
| SkillCategory | SkillCategory | EMPSKCID | true | ||
| SocialNumber | UltimoString | EMPSOCIALNUMBER | 15 | true | |
| Space | Space | EMPSPCID | true | ||
| Status | Status | EMPRECSTATUS | false | ||
| Surname | UltimoString | EMPSURNAME | 50 | true | |
| SystemCompany | Company | EMPCOMPID | false | ||
| Tariff1 | CompanyMoney | EMPTARIFF1 | false | 0 | |
| Tariff2 | CompanyMoney | EMPTARIFF2 | false | 0 | |
| Tariff3 | CompanyMoney | EMPTARIFF3 | false | 0 | |
| Tariff4 | CompanyMoney | EMPTARIFF4 | false | 0 | |
| Text | UltimoString | EMPTEXT | true | ||
| Title | Title | EMPTTLID | true | ||
| TransferNextTime | Boolean | EMPTRANSFERNEXTTIME | false | ||
| VacationAllowance | Decimal | EMPVACALLWNC | false | ||
| Vendor | Vendor | EMPVDRID | true | ||
| Weeks | List[EmployeeWeek] | EWEMPID | false | ||
| ZipCode | UltimoString | EMPZIPCODE | 10 | true |
Brondatabewerken
- Entity-definitie —
lookup_entity("Employee")Model-perspectief (properties, contexts, statussen). Bron:Entities.xml. - DB-schema —
lookup_table_schema("Employee")· ../tables/Employee DB-perspectief (triggers, computed, defaults). Bron:database-schema.json. - Workflows —
find_workflows("", entity="Employee")Before/After Save events voor Employee. Bron:workflows.xml.