# NonPayrollAdministrationByNonPayrollAdministrationId Details of a non payroll administration __Activity name :__ GetNonPayrollAdministrationByNonPayrollAdministrationId Get the details of a single non payroll administration 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: `NonPayrollAdministration` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `nonPayrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | ## Columns The columns of the table `NonPayrollAdministrationByNonPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `cao_key` | `int32` | Collective Labour Agreement Key | ☐ | | | `cao_value` | `string(50)` | Collective Labour Agreement Value | ☐ | | | `description` | `string(50)` | Description | ☐ | Description of the administration | | `endDate` | `datetime` | End Date | ☐ | The last day the administration is active. | | `fulltimeHours` | `double` | | ☐ | The weekly working hours. | | `holidayAllowanceBaseForCalculation_key` | `int32` | | ☐ | | | `holidayAllowanceBaseForCalculation_value` | `string(50)` | | ☐ | | | `holidayAllowancePercentage` | `double` | Holiday Allowance Percentage | ☐ | The percentage of the holidayAllowance. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | The first day the administration is active. | | `yearEndBaseForCalculation_key` | `int32` | | ☐ | | | `yearEndBaseForCalculation_value` | `string(50)` | | ☐ | | | `yearEndPercentage` | `double` | Year-End Percentage | ☐ | The percentage of the year end bonus. |