# MediSoft_Dienstverband_3.50_3: Medisoft Employment 3.50 3 ## Documentation MediSoft_Employment_3.50_3 - Name: `MediSoft_Dienstverband_3.50_3` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Medisoft Employment 3.50 3 - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/MediSoft_Dienstverband_3.50_3` - Insert Service URL (OData-specific): `/connectors/MediSoft_Dienstverband_3.50_3` - Update Service URL (OData-specific): `/connectors/MediSoft_Dienstverband_3.50_3` - Delete Service URL (OData-specific): `/connectors/MediSoft_Dienstverband_3.50_3` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `MediSoft_Dienstverband_3.50_3` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Aantal_uren_per_week` | `decimal` | Hours per week | | | | `Achternaam` | `string(80)` | Last Name | | | | `Begindatum` | `datetime` | Start date | | | | `Begindatum_2` | `datetime` | Start date | | | | `Begindatum_contract` | `datetime` | Contract start date | | | | `Burgerlijke_staat_code` | `string(20)` | Marital status code | | | | `Einddatum` | `datetime` | End Date | | | | `Einddatum_2` | `datetime` | End Date | | | | `E-mail_prive` | `string(255)` | Private email | | | | `E-mail_werk` | `string(255)` | Work email | | | | `Geboortedatum` | `datetime` | Date of birth | | | | `Geslacht` | `string(54)` | Gender | | | | `GUID` | `string(38)` | GUID | | | | `Huisnummer` | `int32` | House number | | | | `Huisnummer_2` | `int32` | House number | | | | `Land` | `string(3)` | Country | | | | `Medewerker` | `string(15)` | Employee | | | | `Mobiel_prive` | `string(255)` | Private mobile | | | | `Naam` | `string(255)` | Employer name | | | | `Nationaliteit_code` | `string(20)` | Nationality code | | | | `Omschrijving_2` | `string(50)` | Description | | | | `Omschrijving_2_2` | `string(50)` | Description | | | | `Organisatorische_eenheid` | `string(10)` | Organisational unit | | | | `Parttime____` | `decimal` | Part-time (%) | | | | `Postcode` | `string(15)` | Postcode | | | | `Postcode_2` | `string(15)` | Postcode | | | | `Salaris` | `decimal` | Salary | | | | `Straat` | `string(60)` | Street | | | | `Straat_2` | `string(60)` | Street | | | | `Telefoonnr__prive` | `string(255)` | Private phone number | | | | `Telefoonnr__werk` | `string(255)` | Work phone number | | | | `Toev__aan_huisnr_` | `string(30)` | House number suffix | | | | `Toev__aan_huisnr__2` | `string(30)` | House number suffix | | | | `Volgnummer_dienstverband` | `int32` | Employment sequence number | | | | `Volgnummer_Organisatorische_eenheid_functie` | `int32` | Organisational unit/job sequence number | | | | `Voorletters` | `string(15)` | Initials | | | | `Voornaam` | `string(50)` | First Name | | | | `Voorvoegsel` | `string(15)` | Name prefix | | | | `Werkgever` | `string(15)` | Employer | | | | `Woonplaats` | `string(50)` | City | | | | `Woonplaats_2` | `string(50)` | City | | |