# Freebeans_algemeen: Freebeans General ## Documentation Freebeans general - Name: `Freebeans_algemeen` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Freebeans General - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Freebeans_algemeen` - Insert Service URL (OData-specific): `/connectors/Freebeans_algemeen` - Update Service URL (OData-specific): `/connectors/Freebeans_algemeen` - Delete Service URL (OData-specific): `/connectors/Freebeans_algemeen` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Freebeans_algemeen` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Aantal_dagen_per_week` | `decimal` | Days per week | | | | `Aantal_FTE` | `decimal` | Number of FTE | | | | `Aantal_uren_per_week` | `decimal` | Hours per week | | | | `Begindatum_salaris` | `datetime` | Salary start date | | | | `Dienstverband` | `string(100)` | Employment | | | | `Dienstverband_code` | `string(20)` | Employment code | | | | `E-mail_prive` | `string(255)` | Private email | | | | `Functie` | `string(10)` | Job title | | | | `Functie-omschrijving` | `string(50)` | Job title description | | | | `Huisnummer` | `int32` | House number | | | | `Huisnummer_toevoeging` | `string(30)` | House number suffix | | | | `Land` | `string(40)` | Country | | | | `Medewerker` | `string(15)` | Employee | | | | `Naam` | `string(80)` | Name | | | | `Omschrijving` | `string(50)` | Description | | | | `Org__eenheid_omschrijving` | `string(50)` | Organisational unit description | | | | `Parttime_percentage` | `decimal` | Part-time (%) | | | | `Per` | `string(50)` | Per | | | | `Postcode` | `string(15)` | Postcode | | | | `Salaris` | `decimal` | Salary | | | | `Schaal` | `string(100)` | Scale | | | | `Schaal_code` | `string(20)` | Scale code | | | | `SOFI-nummer` | `string(25)` | Citizen service number | | | | `Straat` | `string(60)` | Street | | | | `Telefoon_prive` | `string(255)` | Work phone number | | | | `Toeslag` | `decimal` | Allowance | | | | `Uit_te_betalen_salaris` | `decimal` | Salary payable | | | | `Uurloon` | `decimal` | Hourly wage | | | | `Voorletters` | `string(15)` | Initials | | | | `Voorvoegsel` | `string(15)` | Name prefix | | | | `Werkgever` | `string(15)` | Employer | | | | `Werkgevernaam` | `string(255)` | Employer name | | |