# PersonenPerWerkgever: Persons per Employer - Name: `PersonenPerWerkgever` - Catalog: `LoketNL` - Schema: `Lists` - Label: Persons per Employer ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `string` | ☑ | | | ## Table Columns The columns of the table `PersonenPerWerkgever` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ACHTERNAAM` | `string(25)` | Last Name | ☐ | | | `BURGERLIJKESTAAT` | `int32` | Marital Status | ☐ | | | `EMAIL` | `string(100)` | Email | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `ESSGEBRUIKERID` | `int32` | ESS User ID | ☐ | | | `FAX` | `string(60)` | Fax Number | ☐ | | | `GEBOORTEDATUM` | `datetime` | Date of Birth | ☐ | | | `GEBOORTEPLAATS` | `string(60)` | City of Birth | ☐ | | | `GEBRUIKACHTERNAAM` | `int32` | Use Last Name | ☐ | | | `GESLACHT` | `int32` | Gender | ☐ | | | `HUISNUMMER` | `int32` | House Number | ☐ | | | `HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `HUISNUMMERTOEVOEGING` | `string(4)` | House Number Addition | ☐ | | | `HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(4)` | Deviating House Number Addition | ☐ | | | `LAND` | `int32` | Country | ☐ | | | `LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `LOCATIE` | `string(35)` | Location | ☐ | | | `LOCATIEAFWIJKEND` | `string(35)` | Deviating Location | ☐ | | | `MOBIEL` | `string(60)` | Mobile Phone | ☐ | | | `NAAM` | `string(240)` | Name | ☐ | | | `NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `NATIONALITEIT` | `int32` | Nationality | ☐ | | | `NUMMERIDENTIFICATIEDOCUMENT` | `string(100)` | Number Identification Document | ☐ | | | `OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `PARTNERACHTERNAAM` | `string(25)` | Partner Last Name | ☐ | | | `PARTNERVOORVOEGSEL` | `string(10)` | Partner Prefix | ☐ | | | `PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `PERSOONID` | `int32` | Person ID | ☐ | | | `PLAATSNAAM` | `string(24)` | City | ☐ | | | `PLAATSNAAMAFWIJKEND` | `string(24)` | Deviating City | ☐ | | | `POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `POSTCODE` | `string(9)` | ZIP Code | ☐ | | | `POSTCODEAFWIJKEND` | `string(9)` | Deviating Postal Code | ☐ | | | `ROEPNAAM` | `string(28)` | Call Name | ☐ | | | `SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `SOORTIDENTIFICATIEDOCUMENT` | `int32` | Identification Document Type | ☐ | | | `STRAATNAAM` | `string(24)` | Street Name | ☐ | | | `STRAATNAAMAFWIJKEND` | `string(24)` | Deviating Street Name | ☐ | | | `TELEFOON` | `string(60)` | Phone | ☐ | | | `TITULATUUR` | `int32` | Title | ☐ | | | `VOORLETTERS` | `string(6)` | Initials | ☐ | | | `VOORVOEGSEL` | `string(10)` | Prefix | ☐ | |