# ActualBasesForCalculationByEmployerId List of actual bases for calculation for an employer __Activity name:__ GetActualBasesForCalculationByEmployerId Get the list of actual bases for calculation for all employments of an employer. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `Actuals` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `ActualBasesForCalculationByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `basesForCalculation_ageBasedMaximum_key` | `int32` | | ☐ | The number for the ageBasedMaximum | | `basesForCalculation_ageBasedMaximum_value` | `string(50)` | | ☐ | The description of the ageBasedMaximum | | `basesForCalculation_ageBasedMinimum_key` | `int32` | | ☐ | The number for the ageBasedMinimum | | `basesForCalculation_ageBasedMinimum_value` | `string(50)` | | ☐ | The description of the ageBasedMinimum | | `basesForCalculation_base_key` | `int32` | | ☐ | The number for the base | | `basesForCalculation_base_value` | `string(50)` | | ☐ | The description of the base | | `basesForCalculation_deviations_financialReservationPercentage` | `double` | | ☐ | deviation from the financial reservation percentage | | `basesForCalculation_deviations_percentage` | `double` | | ☐ | Deviation from the percentage | | `basesForCalculation_deviations_reservationPercentage` | `double` | | ☐ | deviation from the reservation percentage | | `basesForCalculation_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `basesForCalculation_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `basesForCalculation_startDate` | `datetime` | | ☐ | The date on which this base starts. A (linked chain)[./#section/Data/Date-chains] per base is maintained within this resource. So multiple bases can be active at the same time but one specific base can never be active multiple times at the same time. | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |