# VPLAN_Employee: Employees ## Documentation VPLAN_Employee - Name: `VPLAN_Employee` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Employees - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/VPLAN_Employee` - Insert Service URL (OData-specific): `/connectors/VPLAN_Employee` - Update Service URL (OData-specific): `/connectors/VPLAN_Employee` - Delete Service URL (OData-specific): `/connectors/VPLAN_Employee` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `VPLAN_Employee` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `afas_created_at` | `datetime` | Created on | | | | `afas_created_at_contract` | `datetime` | Created on | | | | `afas_status` | `string(100)` | Employment status | | | | `afas_updated_at` | `datetime` | Modified on | | | | `afas_updated_at_contract` | `datetime` | Modified on | | | | `date_of_birth` | `datetime` | Date of birth | | | | `end_employment` | `datetime` | End of employment date | | | | `external_ref` | `string(15)` | Employee | | | | `firstname` | `string(50)` | First Name | | | | `fullname` | `string(80)` | Name | | | | `gender` | `string(100)` | Gender | | | | `infix` | `string(15)` | Name prefix | | | | `job_description` | `string(80)` | Job title (translated description) | | | | `lastname` | `string(80)` | Last Name | | | | `note` | `string` | Remark | | | | `start_employment` | `datetime` | Start of employment date | | |