# MediSoft_Dienstverband_3.50_1: Medisoft Employment 3.50 1 ## Documentation MediSoft_Employment_3.50_1 - Name: `MediSoft_Dienstverband_3.50_1` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Medisoft Employment 3.50 1 ## Table Columns The columns of the table `MediSoft_Dienstverband_3.50_1` 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` | Last Name | | | | `Begindatum` | `datetime` | Start date | | | | `Begindatum_2` | `datetime` | Start date | | | | `Begindatum_contract` | `datetime` | Contract start date | | | | `Burgerlijke_staat_code` | `string` | Marital status code | | | | `Einddatum` | `datetime` | End Date | | | | `Einddatum_2` | `datetime` | End Date | | | | `E-mail_prive` | `string` | Private email | | | | `E-mail_werk` | `string` | Work email | | | | `Geboortedatum` | `datetime` | Date of birth | | | | `Geslacht` | `string` | Gender | | | | `GUID` | `string` | GUID | | | | `Huisnummer` | `int32` | House number | | | | `Huisnummer_2` | `int32` | House number | | | | `Land` | `string` | Country | | | | `Medewerker` | `string` | Employee | | | | `Mobiel_prive` | `string` | Private mobile | | | | `Naam` | `string` | Employer name | | | | `Nationaliteit_code` | `string` | Nationality code | | | | `Omschrijving_2` | `string` | Description | | | | `Omschrijving_2_2` | `string` | Description | | | | `Organisatorische_eenheid` | `string` | Organisational unit | | | | `Parttime____` | `decimal` | Part-time (%) | | | | `Postcode` | `string` | Postcode | | | | `Postcode_2` | `string` | Postcode | | | | `Salaris` | `decimal` | Salary | | | | `Straat` | `string` | Street | | | | `Straat_2` | `string` | Street | | | | `Telefoonnr._prive` | `string` | Private phone number | | | | `Telefoonnr._werk` | `string` | Work phone number | | | | `Toev._aan_huisnr.` | `string` | House number suffix | | | | `Toev._aan_huisnr._2` | `string` | House number suffix | | | | `Volgnummer_dienstverband` | `int32` | Employment sequence number | | | | `Volgnummer_Organisatorische_eenheid_functie` | `int32` | Organisational unit/job sequence number | | | | `Voorletters` | `string` | Initials | | | | `Voornaam` | `string` | First Name | | | | `Voorvoegsel` | `string` | Name prefix | | | | `Werkgever` | `string` | Employer | | | | `Woonplaats` | `string` | City | | | | `Woonplaats_2` | `string` | City | | |