# OrganizationalEntityByOrganizationalEntityId Details of an organizational entity __Activity name:__ GetOrganizationalEntityByOrganizationalEntityId Get the details of organizational entity 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: `OrganizationalEntity` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `organizationalEntityId` | `guid` | ☑ | | The unique identifier of the organizational entity | ## Columns The columns of the table `OrganizationalEntityByOrganizationalEntityId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `department_code` | `int32` | Department Code | ☐ | | | `department_description` | `string` | Department Description | ☐ | | | `department_key` | `guid` | Department Code | ☐ | The unique identifier of an object (GUID/UUID) | | `deviatingFunctionDescription` | `string(50)` | | ☐ | The deviating function description of the employment. This description deviates from the value of the `function` field. | | `deviatingFunctionGroup` | `string(5)` | | ☐ | The deviating function group description of the employment. Only applies when a deviating function description is defined. | | `distributionUnit_code` | `int32` | Distribution Unit Code | ☐ | | | `distributionUnit_description` | `string` | Distribution Unit Description | ☐ | | | `distributionUnit_key` | `guid` | Distribution Unit Key | ☐ | The unique identifier of an object (GUID/UUID) | | `endDate` | `datetime` | End Date | ☐ | The end date of the entity. The date is up to and including. | | `function_description` | `string(50)` | Job Description | ☐ | | | `function_group` | `string(5)` | Job Group | ☐ | | | `function_key` | `guid` | Job Test | ☐ | The unique identifier of an object (GUID/UUID) | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `internalTelephoneExtensionNumber` | `string(15)` | Internal Telephone Extension Number | ☐ | The phone number of the standard working location (standplaats) for the employment. | | `placeOfEmployment` | `string(24)` | Workplace | ☐ | The standard working location (standplaats) for the employment. | | `standardFunction_category` | `int32` | | ☐ | | | `standardFunction_code` | `string(6)` | | ☐ | | | `standardFunction_key` | `int32` | | ☐ | | | `standardFunction_value` | `string` | | ☐ | | | `startDate` | `datetime` | Start Date | ☐ | The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. |