# CompanySVWs: Nmbrs Company Employee SVWs - Catalog: `Nmbrs` - Schema: `Employees` - Label: Company Employee SVWs 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 `CompanySVWs` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CLACODE` | `int32` | CLA Code | ☐ | | | `CLADESCRIPTION` | `varchar2` | CLA Description | ☐ | | | `CLAID` | `int32` | CLA ID | ☐ | | | `COMPANY_CODE` | `int64` | Company ID | ☑ | | | `CREATIONDATE` | `datetime` | Creation Date | ☐ | | | `EMPLOYEEID` | `int32` | Employee ID | ☑ | | | `INFLUENCEINSURANCE` | `int32` | Influence Insurance | ☐ | | | `MARGINALLABOR` | `char` | Marginal Labor | ☐ | | | `PREMIUMREDUCTIONCODE` | `int32` | Premium Reduction Code | ☐ | | | `PREMIUMREDUCTIONENDPERIOD` | `int32` | Premium Reduction End Period | ☐ | | | `PREMIUMREDUCTIONENDYEAR` | `int32` | Premium Reduction End Year | ☐ | | | `RECORDID` | `int32` | Record ID | ☑ | | | `RISKGROUPCODE` | `int32` | Risk Group Code | ☐ | | | `RISKGROUPDESCRIPTION` | `varchar2` | Risk Group Description | ☐ | | | `RISKGROUPID` | `int32` | Risk Group ID | ☐ | | | `SECTORCODE` | `int32` | Industry Code | ☐ | | | `SECTORDESCRIPTION` | `varchar2` | Industry Description | ☐ | | | `SECTORID` | `int32` | Sector ID | ☐ | | | `STARTPERIOD` | `int32` | Start Period | ☐ | | | `STARTYEAR` | `int32` | Start Year | ☐ | | | `WAO_WIA` | `char` | Incapability Law | ☐ | | | `WW` | `char` | Unemployed Law | ☐ | | | `ZVW` | `int32` | Health Insurance Law | ☐ | | | `ZVWCONTRIBUTION` | `int32` | Health Insurance Law Contribution | ☐ | | | `ZW` | `char` | Health Law | ☐ | |