# ActualPayGradeAmountsByPayrollAdministrationId PayGradeAmounts for the employments __Activity name :__ GetActualPayGradeAmountsByPayrollAdministrationId Provides the PayGradeAmounts on a specific date for all PayScales of the payrolladministration's employments. This information can be used to create new wage records. 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: `Paygrade` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | ## Columns The columns of the table `ActualPayGradeAmountsByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payGrade_key` | `int32` | Salary Level Key | ☐ | | | `payGrade_payGradeAmount_startDate` | `datetime` | | ☐ | Start date of the record. | | `payGrade_payGradeAmount_value` | `double` | | ☐ | Amount for given paygrade | | `payGrade_value` | `string(50)` | Salary Scale Value | ☐ | | | `payScale_key` | `int32` | Salary Scale Key | ☐ | | | `payScale_value` | `string(50)` | Wage Value | ☐ | |