# UpaPensionDeclarationResponseMessagesByUpaPensionDeclarationId Detail UPA pension declaration __Activity name :__ GetUpaPensionDeclarationByUpaPensionDeclarationId Details of UPA pension declaration 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 | |---|:---:|:---:|:---:|---| | `upaPensionDeclarationId` | `guid` | ☑ | | The unique identifier of the pension declaration. | ## Columns The columns of the table `UpaPensionDeclarationResponseMessagesByUpaPensionDeclarationId` 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 | | `citizenServiceNumber` | `string(9)` | Citizen Service Number | ☐ | The social security number of the employee used in communication with the Dutch tax authorities. The number has to be a valid Dutch citizen service number (BSN). | | `code` | `string` | Code | ☐ | The description of the response message | | `creationTime` | `datetime` | | ☐ | The time at which the pension message was requested by the user | | `datetimeOfMessageReceipt` | `datetime` | | ☐ | The date on which the original message was received by the external entity | | `datetimeOfRegistration` | `datetime` | | ☐ | The date on which the response message was registered in Loket | | `description` | `string` | Description | ☐ | The description of the response message | | `descriptionFragment` | `string` | | ☐ | The description of the response message | | `employeeNumber` | `int32` | Employee Number | ☐ | The employee number to uniquely identify an employee within an employer | | `errorType` | `string` | | ☐ | If there is an error type then this field contain its value. | | `externalParty_key` | `int32` | | ☐ | | | `externalParty_value` | `string` | | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `incomeRelationshipNumber` | `int32` | | ☐ | The income relationship number that is required in the tax return. Together with the citizen service number (burgerservicenummer, BSN) and wage tax number, the income relationship number uniquely identifies an employment. | | `lineNumber` | `int64` | | ☐ | If there is an error type then this field contain a value. | | `linePosition` | `int64` | | ☐ | If there is an error type then this field contain a value. | | `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 | | `responseStatus_key` | `int32` | | ☐ | | | `responseStatus_value` | `string` | | ☐ | | | `responseType_key` | `int32` | | ☐ | | | `responseType_value` | `string` | | ☐ | | | `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. |