# WagesByEmploymentId List of wages for an employment __Activity name :__ GetWagesByEmploymentId Get the list of wages for the employment 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: `Wage` ## 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 `WagesByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `applyPayGrade` | `boolean` | Apply Payroll Tax Credit | ☐ | 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. | | `employerCosts` | `double` | Employer Costs | ☐ | The cost for the employer for this employee. | | `employerCostsType_key` | `int32` | | ☐ | | | `employerCostsType_value` | `string(50)` | | ☐ | | | `endDate` | `datetime` | End Date | ☐ | The end date for the information in the record. | | `grossWage` | `double` | Gross Wage | ☐ | The gross wage for the employee | | `grossWageType_key` | `int32` | Gross Wage Type Key | ☐ | | | `grossWageType_value` | `string(50)` | Gross Wage Type Value | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `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. | | `netWage` | `double` | Net Wage | ☐ | Net wage for the employment | | `netWageType_key` | `int32` | Net Wage Type Key | ☐ | | | `netWageType_value` | `string(50)` | Net Wage Type Value | ☐ | | | `payGrade_key` | `int32` | Salary Level Key | ☐ | | | `payGrade_value` | `string(50)` | Salary Scale Value | ☐ | | | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `payScale_key` | `int32` | Salary Scale Key | ☐ | | | `payScale_value` | `string(50)` | Wage Value | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | The start date for the information in the record. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. __Note__ It is possible to have no wage record. |