# ProviderUserByUserId Details of a provider user __Activity name :__ GetProviderUserByUserId Get the details of a provider user 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: `ProviderUser` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `userId` | `guid` | ☑ | | The unique identifier of an user | ## Columns The columns of the table `ProviderUserByUserId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accessStatus_key` | `int32` | | ☐ | | | `accessStatus_value` | `string(255)` | | ☐ | | | `azureActiveDirectory_tenant_description` | `string(100)` | | ☐ | | | `azureActiveDirectory_tenant_id` | `guid` | | ☐ | Id for the tennant | | `azureActiveDirectory_tenant_tenantRegistrationLevel` | `string` | | ☐ | | | `azureActiveDirectory_userId` | `string` | | ☐ | The userId as known in the Azure AD of the selected tennant | | `contactInformation_emailAddress` | `string(255)` | Contact Details Email Address | ☐ | The e-mail address of the user. | | `contactInformation_phoneNumber` | `string(15)` | Contact Details Telephone Number | ☐ | The phone number of the user. | | `contactInformation_placeOfEmployment` | `string(24)` | | ☐ | The place of employment (standplaats) for the user. | | `dateTimeCreation` | `datetime` | | ☐ | The date on which the user was created | | `dateTimeLastLogin` | `datetime` | | ☐ | The date on which the user loged in for the last time | | `hasAuthorisationsOnUserLevel` | `boolean` | | ☐ | Indicates if the user has authorisations set on user level. If set user level authorisations overwrite team based authorisations | | `hasConnectedApplications` | `boolean` | | ☐ | Indicates if the user has connected applications (a conection with different software via this user) | | `hasIntegrations` | `boolean` | | ☐ | Indicates if the user has integrations with clients other that Loket | | `hasMultiFactorAuthentication` | `boolean` | | ☐ | Indicates if the user has multi factor authentication enabled Can only be changed from true to false. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `loginMethod_key` | `int32` | | ☐ | | | `loginMethod_value` | `string(50)` | | ☐ | | | `personalDetails_firstName` | `string(28)` | First Name | ☐ | The first name of the user | | `personalDetails_initials` | `string(6)` | Initials | ☐ | The initials of the user | | `personalDetails_lastName` | `string(25)` | Last Name | ☐ | The last name of the user | | `personalDetails_prefix` | `string(10)` | Name Prefix | ☐ | The prefix of the user | | `twoFactorAuthenticationRequired` | `boolean` | | ☐ | Indicates whether two factor authentication is required for the user. This setting is only available for login method: Via website en SSO | | `userCustomSpecifiedRole` | `string(50)` | | ☐ | Further specification of the user role. | | `userName` | `string(50)` | | ☐ | The username | | `userSpecifiedRole_key` | `int32` | | ☐ | | | `userSpecifiedRole_value` | `string(50)` | | ☐ | |