# Personen: Persons - Name: `Personen` - Catalog: `LoketNL` - Schema: `Views` - Label: Persons ## Table Columns The columns of the table `Personen` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `psn_ACHTERNAAM` | `string(25)` | Last Name | ☐ | | | `psn_BURGERLIJKESTAAT` | `int32` | Marital Status | ☐ | | | `psn_EMAIL` | `string(100)` | Email | ☐ | | | `psn_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `psn_ESSGEBRUIKERID` | `int32` | ESS User ID | ☐ | | | `psn_FAX` | `string(60)` | Fax Number | ☐ | | | `psn_GEBOORTEDATUM` | `datetime` | Date of Birth | ☐ | | | `psn_GEBOORTEPLAATS` | `string(60)` | City of Birth | ☐ | | | `psn_GEBRUIKACHTERNAAM` | `int32` | Use Last Name | ☐ | | | `psn_GESLACHT` | `int32` | Gender | ☐ | | | `psn_HUISNUMMER` | `int32` | House Number | ☐ | | | `psn_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `psn_HUISNUMMERTOEVOEGING` | `string(4)` | House Number Addition | ☐ | | | `psn_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(4)` | Deviating House Number Addition | ☐ | | | `psn_LAND` | `int32` | Country | ☐ | | | `psn_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `psn_LOCATIE` | `string(35)` | Location | ☐ | | | `psn_LOCATIEAFWIJKEND` | `string(35)` | Deviating Location | ☐ | | | `psn_MOBIEL` | `string(60)` | Mobile Phone | ☐ | | | `psn_NAAM` | `string(240)` | Name | ☐ | | | `psn_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `psn_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `psn_NATIONALITEIT` | `int32` | Nationality | ☐ | | | `psn_NUMMERIDENTIFICATIEDOCUMENT` | `string(100)` | Number Identification Document | ☐ | | | `psn_OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `psn_PARTNERACHTERNAAM` | `string(25)` | Partner Last Name | ☐ | | | `psn_PARTNERVOORVOEGSEL` | `string(10)` | Partner Prefix | ☐ | | | `psn_PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `psn_PERSOONID` | `int32` | Person ID | ☐ | | | `psn_PLAATSNAAM` | `string(24)` | City | ☐ | | | `psn_PLAATSNAAMAFWIJKEND` | `string(24)` | Deviating City | ☐ | | | `psn_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `psn_POSTCODE` | `string(9)` | ZIP Code | ☐ | | | `psn_POSTCODEAFWIJKEND` | `string(9)` | Deviating Postal Code | ☐ | | | `psn_ROEPNAAM` | `string(28)` | Call Name | ☐ | | | `psn_SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `psn_SOORTIDENTIFICATIEDOCUMENT` | `int32` | Identification Document Type | ☐ | | | `psn_STRAATNAAM` | `string(24)` | Street Name | ☐ | | | `psn_STRAATNAAMAFWIJKEND` | `string(24)` | Deviating Street Name | ☐ | | | `psn_TELEFOON` | `string(60)` | Phone | ☐ | | | `psn_TITULATUUR` | `int32` | Title | ☐ | | | `psn_VOORLETTERS` | `string(6)` | Initials | ☐ | | | `psn_VOORVOEGSEL` | `string(10)` | Prefix | ☐ | | | `wgr_ADMINISTRATIEKANTOORID` | `int32` | Administration Office ID | ☐ | | | `wgr_ADMINISTRATIENUMMER` | `string(30)` | Administration Number | ☐ | | | `wgr_AKTIEVEDIENSTVERBANDEN` | `int32` | Active Employments | ☐ | | | `wgr_BRANCHE` | `int32` | Industry | ☐ | | | `wgr_CONTACTPERSOONFUNCTIE` | `string(60)` | Contact Person Title | ☐ | | | `wgr_CONTACTPERSOONNAAM` | `string(240)` | Contact Person Name | ☐ | | | `wgr_CONTACTPERSOONTELEFOON` | `string(60)` | Contact Person Phone | ☐ | | | `wgr_EMAIL` | `string(60)` | Email | ☐ | | | `wgr_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `wgr_ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `wgr_EXTERNID` | `guid` | External ID | ☐ | | | `wgr_FAX` | `string(60)` | Fax Number | ☐ | | | `wgr_GROEPCODE` | `int32` | Group Code | ☐ | | | `wgr_HUISNUMMER` | `int32` | House Number | ☐ | | | `wgr_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `wgr_HUISNUMMERTOEVOEGING` | `string(30)` | House Number Addition | ☐ | | | `wgr_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `wgr_JAARFILTER` | `int32` | Year Filter | ☐ | | | `wgr_KVKNUMMER` | `string(60)` | CoC Number | ☐ | | | `wgr_LAND` | `int32` | Country | ☐ | | | `wgr_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `wgr_LOCATIE` | `string(120)` | Location | ☐ | | | `wgr_LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `wgr_NAAM` | `string(120)` | Name | ☐ | | | `wgr_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `wgr_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `wgr_ONDERDEELVANWERKGEVERID` | `int32` | Part of Employer ID | ☐ | | | `wgr_PLAATSNAAM` | `string(60)` | City | ☐ | | | `wgr_PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `wgr_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `wgr_POSTCODE` | `string(30)` | ZIP Code | ☐ | | | `wgr_POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `wgr_PRODUCTSETID` | `int32` | Product Set ID | ☐ | | | `wgr_PROVINCIE` | `int32` | State | ☐ | | | `wgr_RECHTSVORM` | `int32` | Legal Form | ☐ | | | `wgr_SBI` | `int32` | SBI | ☐ | | | `wgr_STRAATNAAM` | `string(60)` | Street Name | ☐ | | | `wgr_STRAATNAAMAFWIJKEND` | `string(60)` | Deviating Street Name | ☐ | | | `wgr_TELEFOON` | `string(60)` | Phone | ☐ | | | `wgr_UPLOADLIMIET` | `int32` | Upload Limit | ☐ | | | `wgr_UPLOADVERBRUIK` | `decimal` | Upload Usage | ☐ | | | `wgr_URL` | `string(120)` | URL | ☐ | | | `wgr_WEBSITELOGOID` | `int32` | Website Logo ID | ☐ | | | `wgr_WERKGEVERAFBEELDINGID` | `int32` | Employer Image ID | ☐ | | | `wgr_WERKGEVERID` | `int32` | Employer ID | ☐ | | | `wgr_WIJZEVERZENDEN` | `int32` | Dispatch Method | ☐ | |