# ActualSocialSecurityBenefitsByEmployerId List of actual social security benefits for an employer __Activity name:__ GetActualSocialSecurityBenefitsByEmployerId Get the list of actual social security benefits 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 `ActualSocialSecurityBenefitsByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `socialSecurityBenefits_benefit_percentage` | `double` | | ☐ | Pay out percentage of the benefit (deviating from the administration). This value determines the percentage to be applied, the only exception is when type of benefit is set to AOW where the percentage cannot be in altered (=0). | | `socialSecurityBenefits_benefit_type_key` | `int32` | | ☐ | | | `socialSecurityBenefits_benefit_type_value` | `string(50)` | | ☐ | | | `socialSecurityBenefits_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `socialSecurityBenefits_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `socialSecurityBenefits_startDate` | `datetime` | | ☐ | The start date of the entity. Valide values are either the startDate of the employment or the firstday of a payrolling year. A (broken chain)[./#section/Data/Date-chains] is maintained within this resource. | | `socialSecurityBenefits_supplementation_percentage` | `double` | | ☐ | If supplementation is applied then the supplementation percentage (up to) is registered here. | | `socialSecurityBenefits_supplementation_type_key` | `int32` | | ☐ | | | `socialSecurityBenefits_supplementation_type_value` | `string(50)` | | ☐ | |