# ChildrenByEmployerId List of Children for an employer __Activity name:__ GetChildrenByEmployerId Get the list of Children for all employees of an employer 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: `Actuals` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `ChildrenByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `children_dateOfBirth` | `datetime` | | ☐ | The date of birth | | `children_dateOfDeath` | `datetime` | | ☐ | The date of death | | `children_firstName` | `string(28)` | | ☐ | The first name, given name, forename or Christian name as part of a persons personal name. | | `children_gender_key` | `int32` | | ☐ | | | `children_gender_value` | `string(50)` | | ☐ | | | `children_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `children_initials` | `string(6)` | | ☐ | The initials | | `children_lastName` | `string(25)` | | ☐ | The last name, family name or surname as part of a persons personal name. | | `children_prefix` | `string(10)` | | ☐ | The prefix to the last name | | `children_residenceStatus_key` | `int32` | | ☐ | The key for the residence status | | `children_residenceStatus_value` | `string(50)` | | ☐ | Is the child living with his parent | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) |