# EmployeePersonalInfoContractSalaryAddresses - 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 `EmployeePersonalInfoContractSalaryAddresses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BIRTHDAY` | `datetime` | Birthday | ☐ | | | `BSN` | `varchar2` | Social Security Number | ☐ | | | `CITY` | `varchar2` | City | ☐ | | | `COMPANY_CODE` | `int64` | Company ID | ☑ | | | `CONTRACTENDDATE` | `datetime` | Contract End Date | ☐ | | | `CONTRACTHOURS` | `decimal` | Contract Hours | ☐ | | | `CONTRACTSTARTDATE` | `datetime` | Contract Start Date | ☐ | | | `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'. | | `HOURLYWAGE` | `decimal` | Hourly Wage | ☐ | | | `HOUSENUMBER` | `varchar2` | House Number | ☐ | | | `HOUSENUMBERADDITION` | `varchar2` | House Number Addition | ☐ | | | `LASTNAME` | `varchar2` | Last Name | ☐ | | | `POSTCODE` | `varchar2` | Postal Code | ☐ | | | `PREFIX` | `varchar2` | Prefix | ☐ | | | `SALARYTYPE` | `varchar2` | Salary Type | ☐ | One of 'None', 'Bruto_Salaris_Fulltime', 'Bruto_Salaris_Partime', 'Bruto_Uurloon', 'Netto_Salaris_Partime_incl_looncomp', 'Netto_Salaris_Partime_excl_looncomp', 'Netto_Uurloon_excl_looncomp', 'Werkgerverslasten', 'Netto_Uurloon_incl_looncomp'. | | `SALARYVALUE` | `decimal` | Salary Value | ☐ | | | `STREET` | `varchar2` | Street | ☐ | | | `TELEPHONEMOBILEPRIVATE` | `varchar2` | Mobile Phone Private | ☐ | | | `TELEPHONEMOBILEWORK` | `varchar2` | Mobile Phone Work | ☐ | | | `TELEPHONEPRIVATE` | `varchar2` | Phone Private | ☐ | | | `TELEPHONEWORK` | `varchar2` | Phone Work | ☐ | |