# ActualCostPerHourByEmployerId List of actual cost per hour for an employer __Activity name:__ GetActualCostPerHourByEmployerId Get the list of actual cost per hour 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 | | `includeEstimation` | `boolean` | ☐ | | include an estimation if no cost per unit records are present | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `ActualCostPerHourByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `costperhour_costPerHour` | `double` | | ☐ | The cost per hour for the employment | | `costperhour_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `costperhour_payrollPeriods_endDate` | `datetime` | | ☐ | The last day of the payroll period | | `costperhour_payrollPeriods_id` | `int32` | | ☐ | The id for this specific payroll period. | | `costperhour_payrollPeriods_periodNumber` | `int32` | | ☐ | The period number of the payroll period | | `costperhour_payrollPeriods_startDate` | `datetime` | | ☐ | The first day of the payroll period | | `costperhour_payrollPeriods_year` | `int32` | | ☐ | The payroll year | | `costperhour_registrationMethod_key` | `int32` | | ☐ | The key of the registrationmethod ('Wijze van aanmaken'). | | `costperhour_registrationMethod_value` | `string` | | ☐ | The description of registrationmethod ('Wijze van aanmaken'). Possible values are "Verloning", "Schatting" and "Handmatig" | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |