# MediSoft_Verzuim_3.50_2: Medisoft Absence 3.50 2 ## Documentation MediSoft_Absence_3.50_2 - Name: `MediSoft_Verzuim_3.50_2` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Medisoft Absence 3.50 2 - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/MediSoft_Verzuim_3.50_2` - Insert Service URL (OData-specific): `/connectors/MediSoft_Verzuim_3.50_2` - Update Service URL (OData-specific): `/connectors/MediSoft_Verzuim_3.50_2` - Delete Service URL (OData-specific): `/connectors/MediSoft_Verzuim_3.50_2` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `MediSoft_Verzuim_3.50_2` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `__Aanwezigheid` | `decimal` | Percentage present | | | | `Achternaam` | `string(80)` | Last Name | | | | `Achternaam_2` | `string(38)` | GUID | | | | `Begindatum_3` | `datetime` | Start date | | | | `Begindatum_4` | `datetime` | Start date | | | | `Begindatum_-tijd` | `datetime` | Start date/time | | | | `Datum_tijd` | `datetime` | Absence date/time | | | | `Einddatum` | `datetime` | End Date | | | | `Einddatum_-tijd` | `datetime` | End date/time | | | | `GUID` | `string(38)` | GUID | | | | `GUID_3` | `string(38)` | GUID | | | | `Koppeling_organisatorische_eenheid_functie` | `int32` | Organisational unit/job link | | | | `Medewerker` | `string(15)` | Employee | | | | `Naam_werkgever` | `string(255)` | Employer name | | | | `Omschrijving` | `string(50)` | Description | | | | `Organisatorische_eenheid` | `string(10)` | Organisational unit | | | | `Type_verzuim_code` | `string(20)` | Absence type code | | | | `Type_verzuim_code_2` | `string(20)` | Absence type code | | | | `Type_verzuim_code_3` | `string(20)` | Absence type code | | | | `Type_verzuim_code_4` | `string(20)` | Absence type code | | | | `Type_verzuim_code_5` | `string(20)` | Absence type code | | | | `Type_verzuim_code_6` | `string(20)` | Absence type code | | | | `Volgnummer_dienstverband` | `int32` | Employment sequence number | | | | `Werkgever` | `string(15)` | Employer | | |