# ActualWagesByEmployerId List of actual wages for an employer __Activity name:__ GetActualWagesByEmployerId Get the list of actual wages for an employer Select loket.nl (REST) API URL: /providers/employers/{employerId}/actualwages Insert loket.nl (REST) API URL: /providers/employers/{employerId}/actualwages Update loket.nl (REST) API URL: /providers/employers/{employerId}/actualwages Delete loket.nl (REST) API URL: /providers/employers/{employerId}/actualwages Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/actualwages - Catalog: `LoketNlRest` - Schema: `Actuals` - Field Selection Method: NotRequired - Base Path: `_embedded[*]` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## 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 of Table Function The columns of the table function `ActualWagesByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `wage_applyPayGrade` | `boolean` | | ☐ | Apply pay grade indicates that after submitting the record the server will replace the value of `grossWage` with the value represented by the selected `payGrade`. A pay grade contains time based values, the value that is active on the `start date` of the record will be selected. | | `wage_employerCosts` | `double` | | ☐ | The cost for the employer for this employee. | | `wage_employerCostsType_key` | `int32` | | ☐ | | | `wage_employerCostsType_value` | `string(50)` | | ☐ | | | `wage_endDate` | `datetime` | | ☐ | The end date for the information in the record. | | `wage_grossWage` | `double` | | ☐ | The gross wage for the employee | | `wage_grossWageType_key` | `int32` | | ☐ | | | `wage_grossWageType_value` | `string(50)` | | ☐ | | | `wage_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `wage_isGrossWageFullTime` | `boolean` | | ☐ | Indicates whether the given grossWage is either a full-time wage or a part-time wage. Full-time wage is the default value (isGrossWageFulltime = true) and Loket.nl recommends to use this option. A full-time wage takes into account the part-time percentage of an employment. While a part-time wage does not. E.g. A full-time wage of 2400 euro’s is registered. The employments works 20 out of 40 hours (40 fours is a full-time shift) thus having a 20/40 = 50% part-time percentage. The part-time hours (deviatingHoursPerWeek) are accessible through the endpoint for working hours of an employement. In the wage calculation Loket.nl will divide the grossWage component by 50% resulting in a grossWage of 1200 euro’s. In the case of a part-time wage the part-time percentage will be ignored. | | `wage_netWage` | `double` | | ☐ | Net wage for the employment | | `wage_netWageType_key` | `int32` | | ☐ | | | `wage_netWageType_value` | `string(50)` | | ☐ | | | `wage_payGrade_key` | `int32` | | ☐ | | | `wage_payGrade_value` | `string(50)` | | ☐ | | | `wage_payrollPeriodType_key` | `int32` | | ☐ | | | `wage_payrollPeriodType_value` | `string(50)` | | ☐ | | | `wage_payScale_key` | `int32` | | ☐ | | | `wage_payScale_value` | `string(50)` | | ☐ | | | `wage_startDate` | `datetime` | | ☐ | The start date for the information in the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. __Note__ It is posible to have no wage record. |