# UpaPensionDeclarationsByPayrollAdministrationId List of UPA pension declarations __Activity name :__ GetUpaPensionDeclarationsByPayrollAdministrationId A list of UPA pension declarations for an 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: `UpaPensionDeclaration` ## 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 `UpaPensionDeclarationsByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `approvalTime` | `datetime` | Approval Time | ☐ | The time at which the payroll run was approved by the user | | `approvedBy_formattedName` | `string` | Approved By Formatted Name | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `approvedBy_id` | `guid` | Approved By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `approvedBy_initials` | `string(6)` | Approved By Initials | ☐ | The initials of the user | | `approvedBy_lastName` | `string(25)` | Approved By Last Name | ☐ | The last name of the user | | `approvedBy_prefix` | `string(10)` | Approved By Name Prefix | ☐ | The prefix of the user | | `cancelledBy_formattedName` | `string` | | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `cancelledBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `cancelledBy_initials` | `string(6)` | | ☐ | The initials of the user | | `cancelledBy_lastName` | `string(25)` | | ☐ | The last name of the user | | `cancelledBy_prefix` | `string(10)` | | ☐ | The prefix of the user | | `cancelledTime` | `datetime` | | ☐ | The time at which the payroll run was Cancelled by the user | | `creationTime` | `datetime` | | ☐ | The time at which the pension message was requested by the user | | `externalParty_key` | `int32` | | ☐ | | | `externalParty_value` | `string` | | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `messageReference` | `string` | | ☐ | The message reference (berichtkenmerk) to recognize the given declaration. | | `methodOfCreation_key` | `int32` | Creation Method Key | ☐ | | | `methodOfCreation_value` | `string` | Creation Method Value | ☐ | | | `payrollTaxesNumber` | `string(12)` | | ☐ | The payroll tax number, loonheffingennummer, is the number that is used for the Loonaangifte for the Belastingdienst. | | `period_periodEndDate` | `datetime` | | ☐ | The end date of the period | | `period_periodId` | `int32` | | ☐ | The periodId of the payroll period. | | `period_periodNumber` | `int32` | | ☐ | The period number of the payroll period for which the pension declaration was created. In case of a yearly tax return this value will be set to 0 | | `period_periodStartDate` | `datetime` | | ☐ | The start date of the period | | `period_periodType_key` | `int32` | | ☐ | | | `period_periodType_value` | `string(50)` | | ☐ | | | `period_year` | `int32` | Period Year | ☐ | The year of the period for which the pension declaration was created. | | `removedBy_formattedName` | `string` | Deleted By Name | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `removedBy_id` | `guid` | Deleted By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `removedBy_initials` | `string(6)` | Deleted By Initials | ☐ | The initials of the user | | `removedBy_lastName` | `string(25)` | Deleted By Last Name | ☐ | The last name of the user | | `removedBy_prefix` | `string(10)` | Deleted By Name Prefix | ☐ | The prefix of the user | | `removeTime` | `datetime` | Deletion Time | ☐ | The time at which the pay roll run was removed. | | `requestedBy_formattedName` | `string` | Requested By Formatted Name | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `requestedBy_id` | `guid` | Requested By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `requestedBy_initials` | `string(6)` | Requested By Initials | ☐ | The initials of the user | | `requestedBy_lastName` | `string(25)` | Requested By Last Name | ☐ | The last name of the user | | `requestedBy_prefix` | `string(10)` | Requested By Name Prefix | ☐ | The prefix of the user | | `requestTime` | `datetime` | Request Time | ☐ | The time at which the payroll run was requested by the user | | `sendingPartyNumber` | `string` | | ☐ | The number of the sending party (i.e. nummer leverancier). | | `sentTime` | `datetime` | | ☐ | The time at which the pay roll run was sent. | | `upaPensionDeclarationStatus_key` | `int32` | | ☐ | | | `upaPensionDeclarationStatus_value` | `string` | | ☐ | | | `withholdingAgentName` | `string` | | ☐ | The withholding agent name (naam inhoudingsplichtige) for this return. |