# Profit_Employees: Employees ## Documentation Profit_Employees - Name: `Profit_Employees` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Employees - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Employees` - Insert Service URL (OData-specific): `/connectors/Profit_Employees` - Update Service URL (OData-specific): `/connectors/Profit_Employees` - Delete Service URL (OData-specific): `/connectors/Profit_Employees` - Field Selection Method (OData-specific): NotRequired ## 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(30)` | House number suffix | | | | `BirthName` | `string(80)` | Birth name | | | | `BirthNamePartner` | `string(80)` | Partner birth name | | | | `BSN` | `string(25)` | BSN | | | | `City` | `string(50)` | City | | | | `Country` | `string(3)` | Country | | | | `DateDeceased` | `datetime` | Date of death | | | | `DateOfBirth` | `datetime` | Date of birth | | | | `EmployeeId` | `string(15)` | Employee | | | | `EmployerId` | `string(15)` | Employer | | | | `EmploymentEnd` | `datetime` | End of employment date | | | | `EmploymentStart` | `datetime` | Start of employment date | | | | `EmploymentType` | `string(20)` | Employment code | | | | `EmploymentTypeDesc` | `string(100)` | Employment descr. | | | | `FirstName` | `string(80)` | Nickname | | | | `FTE` | `decimal` | Number of FTE | | | | `FunctionDesc` | `string(50)` | Job title | | | | `FunctionId` | `string(10)` | Job code | | | | `Gender` | `string(20)` | Gender code | | | | `HourPerWeek` | `decimal` | Hours per week | | | | `HouseNumber` | `int32` | House number | | | | `Initials` | `string(15)` | Initials | | | | `Mail` | `string(255)` | Work email | | | | `MaritalStatus` | `string(20)` | Marital status code | | | | `Mobile` | `string(255)` | Private mobile | | | | `NameUse` | `string(20)` | Name usage code | | | | `OrgUnit` | `string(10)` | OU code | | | | `OrgUnitDesc` | `string(50)` | OU descr. | | | | `PersonId` | `string(15)` | PersoonsId | | | | `Phone` | `string(255)` | Private phone number | | | | `PrefixBirthName` | `string(15)` | Birth name prefix | | | | `PrefixPartner` | `string(15)` | Partner name prefix | | | | `Street` | `string(60)` | Street | | | | `ZIPCode` | `string(15)` | Postcode | | |