# PayrollSimulatorDataByEmploymentId Overview of the data used in a payroll simulation __Activity name :__ GetPayrollSimulatorDataByEmploymentId Get an overview of the data used in a payroll simulation 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: `PayrollSimulator` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns The columns of the table `PayrollSimulatorDataByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `startDateDeviations` | `datetime` | | ☐ | The date to be used when calling the wageprojection endpoint | | `wage_class` | `string(255)` | | ☐ | The class of the wage | | `wage_currentWage` | `double` | | ☐ | The gross wage for the employee | | `wage_type_key` | `int32` | | ☐ | | | `wage_type_value` | `string(50)` | | ☐ | | | `workingHours_currentHoursPerWeek` | `decimal` | | ☐ | The hours per week de employment currently works | | `workingHours_shift_fullTimeHoursPerWeek` | `decimal` | | ☐ | The full time hours for an employment that is linked to this shift. |