# PayrollPeriodsMinimizedByPayrollAdministrationId List of all available payroll periods __Activity name :__ GetPayrollPeriodsMinimizedByPayrollAdministrationId Returns a list of all payroll periods available for the given 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: `PayrollPeriods` ## 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 `PayrollPeriodsMinimizedByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `endDate` | `datetime` | End Date | ☐ | The last day of the payroll period | | `hasApprovedPayrollRun` | `boolean` | | ☐ | Indicates if the payroll period has atleast 1 approved payrollrun | | `id` | `int32` | ID | ☐ | The id for this specific payroll period. | | `payrollPeriodType_key` | `int32` | Payroll Processing Period Type Key | ☐ | | | `payrollPeriodType_value` | `string(50)` | Payroll Processing Period Type Value | ☐ | | | `periodNumber` | `int32` | | ☐ | The period number of the payroll period | | `startDate` | `datetime` | Start Date | ☐ | The first day of the payroll period | | `testYear` | `boolean` | | ☐ | Indicates whether the payroll year is a test year. In Loket it is possible to run a year of a payrolladministration as a so-called test year. This is typically done to test the configuration of a new payroll administration, by running payrollruns within the context of a test year. Please note: if the payroll run belongs to a test year the results of the run should not be regarded as actual data but as test data. | | `year` | `int32` | Year | ☐ | The payroll year |