invantive documentation
Invantive Support ForumsLog In / Sign Up

CompanySVWs: Nmbrs Company Employee SVWs

read only per partition XML

  • Catalog: Nmbrs
  • Schema: Employees
  • Label: Company Employee SVWs

The data in this table is partitioned per value of the COMPANY_CODE column.

Can only retrieve data.

API Source

  • XML service: EmployeeService.asmx
  • XML topic: SVW_GetAll_AllEmployeesByCompany
  • XML path: /nes:EmployeeSVWsettings/nes:EmployeeSVWsetting

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table CompanySVWs are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
CLACODE int32 CLA Code /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CLA/nes:CLACode
CLADESCRIPTION varchar2 CLA Description /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CLA/nes:CLADescription
CLAID int32 CLA ID /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CLA/nes:CLAId
COMPANY_CODE int64 Company ID
CREATIONDATE datetime Creation Date /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CreationDate
EMPLOYEEID int32 Employee ID /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeId
INFLUENCEINSURANCE int32 Influence Insurance /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:InfluenceInsurance
MARGINALLABOR char Marginal Labor /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:MarginalLabor
PREMIUMREDUCTIONCODE int32 Premium Reduction Code /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:PremiumReductionCode
PREMIUMREDUCTIONENDPERIOD int32 Premium Reduction End Period /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:EndPeriod
PREMIUMREDUCTIONENDYEAR int32 Premium Reduction End Year /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:EndYear
RECORDID int32 Record ID /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RecordID
RISKGROUPCODE int32 Risk Group Code /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupCode
RISKGROUPDESCRIPTION varchar2 Risk Group Description /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupDescription
RISKGROUPID int32 Risk Group ID /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupId
SECTORCODE int32 Industry Code /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorCode
SECTORDESCRIPTION varchar2 Industry Description /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorDescription
SECTORID int32 Sector ID /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorId
STARTPERIOD int32 Start Period /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:StartPeriod
STARTYEAR int32 Start Year /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:StartYear
WAO_WIA char Incapability Law /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:WAO_WIA
WW char Unemployed Law /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:WW
ZVW int32 Health Insurance Law /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZVW
ZVWCONTRIBUTION int32 Health Insurance Law Contribution /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZVWContribution
ZW char Health Law /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZW

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: