# EmployeePersonalInformations - Catalog: `Nmbrs` - Schema: `Employees` The data in this table is partitioned per value of the `COMPANY_CODE` column. This is a read-only table. The Nmbrs API may not support changing the data or the Invantive UniversalSQL driver for Nmbrs does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Nmbrs API. - Filters on API Server: CompanyID ## Table Columns The columns of the table `EmployeePersonalInformations` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BIRTHDAY` | `datetime` | Birthday | ☐ | | | `BSN` | `varchar2` | Social Security Number | ☐ | | | `BURGERLIJKESTAAT` | `varchar2` | Civil Status | ☐ | | | `COMPANY_CODE` | `int64` | Company ID | ☑ | | | `COUNTRYOFBIRTHISOCODE` | `varchar2` | Country of Birth (ISO Code) | ☐ | | | `CREATIONDATE` | `datetime` | Creation Date | ☐ | | | `DECEASEDDATE` | `datetime` | Deceased | ☐ | | | `DISPLAYNAME` | `varchar2` | Display Name | ☐ | | | `EMAILPRIVATE` | `varchar2` | Email Address Private | ☐ | | | `EMAILWORK` | `varchar2` | Email Address Work | ☐ | | | `EMPLOYEEID` | `int32` | Employee ID | ☑ | | | `EMPLOYEENUMBER` | `int32` | Employee Number | ☐ | | | `FIRSTNAME` | `varchar2` | First Name | ☐ | | | `GENDER` | `varchar2` | Gender | ☐ | One of 'undefined', 'male', 'female'. | | `ID` | `int32` | ID | ☑ | | | `IDENTIFICATIONNUMBER` | `varchar2` | Identification Number | ☐ | | | `IDENTIFICATIONTYPE` | `int32` | Identification Type | ☐ | | | `INCASEOFEMERGENCY` | `varchar2` | In Case of Emergency | ☐ | | | `INCASEOFEMERGENCYPHONE` | `varchar2` | In Case of Emergency Phone | ☐ | | | `INCASEOFEMERGENCYRELATION` | `varchar2` | In Case of Emergency Relation | ☐ | | | `INITIALS` | `varchar2` | Initials | ☐ | | | `LASTNAME` | `varchar2` | Last Name | ☐ | | | `NAAMSTELLING` | `varchar2` | Formal Name | ☐ | | | `NATIONALITYCODE` | `int32` | Nationality Code | ☐ | | | `NICKNAME` | `varchar2` | Nickname | ☐ | | | `PARTNERLASTNAME` | `varchar2` | Partner Last Name | ☐ | | | `PARTNERPREFIX` | `varchar2` | Partner Prefix | ☐ | | | `PLACEOFBIRTH` | `varchar2` | Place of Birth | ☐ | | | `PREFIX` | `varchar2` | Prefix | ☐ | | | `STARTPERIOD` | `int32` | Start Period | ☐ | | | `STARTYEAR` | `int32` | Start Year | ☐ | | | `TELEPHONEMOBILEPRIVATE` | `varchar2` | Mobile Phone Private | ☐ | | | `TELEPHONEMOBILEWORK` | `varchar2` | Mobile Phone Work | ☐ | | | `TELEPHONEOTHER` | `varchar2` | Other Phone | ☐ | | | `TELEPHONEPRIVATE` | `varchar2` | Phone Private | ☐ | | | `TELEPHONEWORK` | `varchar2` | Phone Work | ☐ | | | `TITLE` | `varchar2` | Title Name | ☐ | | | `TITLEAFTER` | `varchar2` | Title After | ☐ | |