# EmployeeAddresses: Nmbrs Employee Addresses - Catalog: `Nmbrs` - Schema: `Employees` - Label: Employee Addresses 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 `EmployeeAddresses` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CITY` | `varchar2` | City | ☐ | | | `COMPANY_CODE` | `int64` | Company ID | ☑ | | | `COUNTRYISOCODE` | `varchar2` | Country ISO Code | ☐ | | | `CREATIONDATE` | `datetime` | Creation Date | ☐ | | | `EMPLOYEEID` | `int32` | Employee ID | ☑ | | | `ENDPERIOD` | `int32` | End Period | ☐ | | | `ENDYEAR` | `int32` | End Year | ☐ | | | `HOUSENUMBER` | `varchar2` | House Number | ☐ | | | `HOUSENUMBERADDITION` | `varchar2` | House Number Addition | ☐ | | | `ID` | `int32` | ID | ☑ | | | `POSTALCODE` | `varchar2` | Postal Code | ☐ | | | `STARTPERIOD` | `int32` | Start Period | ☐ | | | `STARTYEAR` | `int32` | Start Year | ☐ | | | `STATEPROVINCE` | `varchar2` | State/Province | ☐ | | | `STREET` | `varchar2` | Street | ☐ | | | `TYPE` | `varchar2` | Type | ☐ | One of 'HomeAddress', 'PostAddress', 'AbsenceAddress', 'HolidaysAddress', 'WeekendAddress'. |