# CostPerHourByEmploymentId List of costs per hour for an employment __Activity name:__ GetCostPerHourByEmploymentId Get the list of costs per hour for an employment Select loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/costperhour Insert loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/costperhour Update loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/costperhour Delete loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/costperhour Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/{employmentId}/costperhour Insert loket.nl (REST) API Operation: post /providers/employers/employees/employments/{employmentId}/costperhour - Catalog: `LoketNlRest` - Schema: `CostPerHour` - Retrieve: true - Insert: true - Update: false - Delete: false - Field Selection Method: NotRequired - Base Path: `_embedded[*]` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | | `includeEstimation` | `boolean` | ☐ | | include an estimation if no cost per unit records are present | ## Columns of Table Function The columns of the table function `CostPerHourByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `costPerHour` | `double` | | ☐ | The cost per hour for the employment | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollPeriods_endDate` | `datetime` | | ☐ | The last day of the payroll period | | `payrollPeriods_id` | `int32` | | ☐ | The id for this specific payroll period. | | `payrollPeriods_periodNumber` | `int32` | | ☐ | The period number of the payroll period | | `payrollPeriods_startDate` | `datetime` | | ☐ | The first day of the payroll period | | `payrollPeriods_year` | `int32` | | ☐ | The payroll year | | `registrationMethod_key` | `int32` | | ☐ | The key of the registrationmethod ('Wijze van aanmaken'). | | `registrationMethod_value` | `string` | | ☐ | The description of registrationmethod ('Wijze van aanmaken'). Possible values are "Verloning", "Schatting" and "Handmatig" |