# EmployeeSelfServiceByEmployeeId Details of and employees self service portal status __Activity name :__ GetEmployeeSelfServiceByEmployeeId Get the details of an employee with regards to ESS access Select loket.nl (REST) API URL: /providers/employers/employee/{employeeId}/selfservice Insert loket.nl (REST) API URL: /providers/employers/employee/{employeeId}/selfservice Update loket.nl (REST) API URL: /providers/employers/employee/{employeeId}/selfservice Delete loket.nl (REST) API URL: /providers/employers/employee/{employeeId}/selfservice Select loket.nl (REST) API Operation: get /providers/employers/employee/{employeeId}/selfservice - Catalog: `LoketNlRest` - Schema: `EmployeeSelfService` - Field Selection Method: NotRequired - Base Path: `content` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employeeId` | `guid` | ☑ | | The unique identifier of the employee | ## Columns of Table Function The columns of the table function `EmployeeSelfServiceByEmployeeId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employee_emailAddress` | `string(255)` | | ☐ | The e-mail address of the employee. | | `employee_employeeNumber` | `int32` | | ☐ | The employee number to uniquely identify a employee within an employer. | | `employee_firstName` | `string(28)` | | ☐ | The first name of the employee | | `employee_formattedName` | `string(82)` | | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `employee_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employee_initials` | `string(6)` | | ☐ | The initials of the employee | | `employee_lastName` | `string(25)` | | ☐ | The last name of the employee | | `employee_prefix` | `string(10)` | | ☐ | The prefix of the employee | | `hasTwoFactorAuthentication` | `boolean` | | ☐ | Does the employee have two factor authentication enabled | | `status` | `string(50)` | | ☐ | Description of the status |