# Profit_Employees: Employees ## Documentation Profit_Employees - Name: `Profit_Employees` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Employees ## Table Columns The columns of the table `Profit_Employees` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AddNumber` | `string` | House number suffix | | | | `BirthName` | `string` | Birth name | | | | `BirthNamePartner` | `string` | Partner birth name | | | | `BSN` | `string` | BSN | | | | `City` | `string` | City | | | | `Country` | `string` | Country | | | | `DateDeceased` | `datetime` | Date of death | | | | `DateOfBirth` | `datetime` | Date of birth | | | | `EmployeeId` | `string` | Employee | | | | `EmployerId` | `string` | Employer | | | | `EmploymentEnd` | `datetime` | End of employment date | | | | `EmploymentStart` | `datetime` | Start of employment date | | | | `EmploymentType` | `string` | Employment code | | | | `EmploymentTypeDesc` | `string` | Employment descr. | | | | `FirstName` | `string` | Nickname | | | | `FTE` | `decimal` | Number of FTE | | | | `FunctionDesc` | `string` | Job title | | | | `FunctionId` | `string` | Job code | | | | `Gender` | `string` | Gender code | | | | `HourPerWeek` | `decimal` | Hours per week | | | | `HouseNumber` | `int32` | House number | | | | `Initials` | `string` | Initials | | | | `Mail` | `string` | Work email | | | | `MaritalStatus` | `string` | Marital status code | | | | `Mobile` | `string` | Private mobile | | | | `NameUse` | `string` | Name usage code | | | | `OrgUnit` | `string` | OU code | | | | `OrgUnitDesc` | `string` | OU descr. | | | | `PersonId` | `string` | PersoonsId | | | | `Phone` | `string` | Private phone number | | | | `PrefixBirthName` | `string` | Birth name prefix | | | | `PrefixPartner` | `string` | Partner name prefix | | | | `Street` | `string` | Street | | | | `ZIPCode` | `string` | Postcode | | |