# PartnerByPartnerId Details of a single partner __Activity name :__ GetPartnerByPartnerId Get the details of a single partner 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: `Partner` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `partnerId` | `guid` | ☑ | | The unique identifier of a partner | ## Columns The columns of the table `PartnerByPartnerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `dateOfBirth` | `datetime` | Date of Birth | ☐ | The date of birth | | `dateOfDeath` | `datetime` | Date of Death | ☐ | The date of death | | `endDate` | `datetime` | End Date | ☐ | end date | | `firstName` | `string(28)` | First Name | ☐ | The first name, given name, forename or Christian name as part of a persons personal name. | | `gender_key` | `int32` | Gender Key | ☐ | | | `gender_value` | `string(50)` | Gender | ☐ | | | `howToFormatLastName_key` | `int32` | | ☐ | | | `howToFormatLastName_value` | `string(50)` | | ☐ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `initials` | `string(6)` | Initials | ☐ | The initials | | `lastName` | `string(25)` | Last Name | ☐ | The last name, family name or surname as part of a persons personal name. | | `placeOfBirth` | `string(24)` | Place of Birth | ☐ | The place of birth | | `prefix` | `string(10)` | Name Prefix | ☐ | The prefix to the last name | | `startDate` | `datetime` | Start Date | ☐ | startdate | | `title_key` | `int32` | Title Key | ☐ | | | `title_value` | `string(50)` | Title Value | ☐ | | | `waoClassification_key` | `int32` | | ☐ | The key of the occupational disability classification. Possible values can be acquired via the metadata endpoint. | | `waoClassification_value` | `string(50)` | | ☐ | Description of the occupational disability classification. |