# Profit_Employees_basic: Employees (Basic) ## Documentation Profit_Employees_basic - Name: `Profit_Employees_basic` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Employees (Basic) - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Employees_basic` - Insert Service URL (OData-specific): `/connectors/Profit_Employees_basic` - Update Service URL (OData-specific): `/connectors/Profit_Employees_basic` - Delete Service URL (OData-specific): `/connectors/Profit_Employees_basic` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Employees_basic` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Blocked` | `decimal` | Blocked | | | | `BSN` | `string(25)` | Citizen service number | | | | `DateBirth` | `string(8)` | Date of birth | | | | `DvId` | `string(20)` | Employment status code | | | | `EmployeeId` | `string(15)` | Employee | | | | `Employer` | `string(15)` | Employer | | | | `EmploymentEnd` | `string(8)` | End of employment date | | | | `EmploymentStart` | `string(8)` | Start of employment date | | | | `Function` | `string(50)` | Job title description | | | | `FunctionId` | `string(10)` | Job title | | | | `Mail` | `string(255)` | Work email | | | | `Name` | `string(80)` | Name | | | | `OE` | `string(10)` | Organisational unit | | | | `PersonId` | `string(15)` | Number | | |