# ClaDataForWageProjectionByCollectiveLaborAgreementId 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` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `collectiveLaborAgreement_name` | `string(70)` | | ☐ | Company name | | `collectiveLaborAgreement_nextYear_available` | `boolean` | | ☐ | Are next payroll years values available yes or no ? | | `collectiveLaborAgreement_nextYear_status_key` | `int32` | | ☐ | The key for the status of the values | | `collectiveLaborAgreement_nextYear_status_value` | `string(50)` | | ☐ | The status of the values | | `collectiveLaborAgreement_nextYear_year` | `int32` | | ☐ | The year for which the numbers are available |