# ActualDeviatingAwfContributionsByEmployerId List of actual awf contributions for an employer __Activity name:__ GetActualDeviatingAwfContributionsByEmployerId Get the list of actual deviating awf contributions 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 `ActualDeviatingAwfContributionsByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `deviatingAwfContribution_endPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `deviatingAwfContribution_endPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the journal allocation is applicable. | | `deviatingAwfContribution_endPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `deviatingAwfContribution_endPeriod_year` | `int32` | | ☐ | The year of the last payroll period for which the record is applicable. | | `deviatingAwfContribution_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `deviatingAwfContribution_startPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the payroll period. | | `deviatingAwfContribution_startPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the last payroll period for which the record is applicable. | | `deviatingAwfContribution_startPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the payroll period. | | `deviatingAwfContribution_startPeriod_year` | `int32` | | ☐ | The year of the first payroll period for which the record is applicable. | | `deviatingAwfContribution_typeOfDeviatingAwfContribution_key` | `int32` | | ☐ | The type of deviating Deviating AWF contribution to be applied for this employment. | | `deviatingAwfContribution_typeOfDeviatingAwfContribution_value` | `string(50)` | | ☐ | Description of the nationality | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |