# ClaDataForWageProjectionByCollectiveLaborAgreementId_ContentCollectiveLaborAgreementBaseForCalculation Wage projection Collective labor agreements defaults __Activity name :__ GetClaDataForWageProjectionByCollectiveLaborAgreementId Get de configuration of a specific Collective labor agreement. This configuration (data) can then be used (as input) to perform a wage calculation or wage projection with. 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: `WageProjection` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `collectiveLaborAgreementId` | `guid` | ☑ | | The unique identifier of the record | ## Columns The columns of the table `ClaDataForWageProjectionByCollectiveLaborAgreementId_ContentCollectiveLaborAgreementBaseForCalculation` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `baseType_key` | `int32` | | ☐ | The number for the base type 0 = nvt 1 = Vakantiebijslag 2 = Extra periode salaris | | `baseType_value` | `string(14)` | | ☐ | The description baseType | | `description` | `string(50)` | Description | ☐ | | | `key` | `int32` | Key | ☐ | The key for the baseForCalculation | | `name` | `string(70)` | Name | ☐ | Company name | | `nextYear_available` | `boolean` | | ☐ | Are next payroll years values available yes or no ? | | `nextYear_status_key` | `int32` | | ☐ | The key for the status of the values | | `nextYear_status_value` | `string(50)` | | ☐ | The status of the values | | `nextYear_year` | `int32` | | ☐ | The year for which the numbers are available | | `percentage` | `decimal` | | ☐ | The percentage | | `resultPayrollComponent_description` | `string(14)` | | ☐ | The description of the payroll component | | `resultPayrollComponent_key` | `int32` | | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart. |