invantive documentation
Invantive Support ForumsLog In / Sign Up

CompanyCurrentSVWs: Nmbrs Company Current SVW

read only per partition XML

  • Catalog: Nmbrs
  • Schema: Company
  • Label: Company Current SVW

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

Can only retrieve data.

API Source

  • XML service: CompanyService.asmx
  • XML topic: SVW_GetCurrent
  • XML path: /ncs:SVW_GetCurrentResult

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Table Columns

The columns of the table CompanyCurrentSVWs 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
CAOCODE int32 CAO Code /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:CAO/ncs:Code
CAODESCRIPTION varchar2 CAO Description /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:CAO/ncs:Description
CODECAO int32 CAO Code /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:CodeCao
COMPANY_CODE int64 Company ID
EIGENRISICODRAGERGEDIFFWGA char Carrier Own Risk Differentiated WGA /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:EigenrisicodragerGediffWGA
EIGENRISICODRAGERUNIFORMEWAO char Carrier Own Risk Uniform WAO /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:EigenrisicodragerUniformeWAO
EIGENRISICODRAGERZIEKTEWET char Carrier Own Risk ZW /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:EigenrisicodragerZiektewet
GEDIFF_WGA_WG decimal Differentiated WGA Employer /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:Gediff_WGA_wg
GEDIFF_WGA_WN decimal Differentiated WGA Employee /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:Gediff_WGA_wn
RISICOGROEP int32 Risk Group /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:RisicoGroep
RISICOGROEPCODE int32 Risk Group Code /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:Risicogroep/ncs:Code
RISICOGROEPDESCRIPTION varchar2 Risk Group Description /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:Risicogroep/ncs:Description
SECTOR int32 Industry /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:SVWSettings/ncs:Sector
SECTORCODE int32 Industry Code /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:Sector/ncs:Code
SECTORDESCRIPTION varchar2 Industry Description /soap:Envelope/soap:Body/ncs:SVW_GetCurrentResponse/ncs:SVW_GetCurrentResult/ncs:Sector/ncs:Description

Release Notes

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