invantive documentation
Forum di supporto InvantiveAccedi / Registrati

CompanySVWs: Nmbrs SVW dipendenti azienda

read only per partition XML

  • Catalogo: Nmbrs
  • Schema: Employees
  • Etichetta: SVW dipendenti azienda

I dati in questa tabella sono partizionati per valore della colonna COMPANY_CODE.

È possibile solo recuperare i dati.

Codice sorgente dell'API

  • Servizio XML: EmployeeService.asmx
  • Argomento XML: SVW_GetAll_AllEmployeesByCompany
  • Percorso XML: /nes:EmployeeSVWsettings/nes:EmployeeSVWsetting

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 48

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella CompanySVWs. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
CLACODE int32 Codice CLA /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CLA/nes:CLACode
CLADESCRIPTION varchar2 Descrizione del CLA /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CLA/nes:CLADescription
CLAID int32 ID CLA /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 ID dell'azienda
CREATIONDATE datetime Data di creazione /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:CreationDate
EMPLOYEEID int32 ID dell'impiegato /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 Manodopera marginale /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:MarginalLabor
PREMIUMREDUCTIONCODE int32 Codice di riduzione Premium /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:PremiumReductionCode
PREMIUMREDUCTIONENDPERIOD int32 Periodo di fine della riduzione Premium /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:EndPeriod
PREMIUMREDUCTIONENDYEAR int32 Fine anno di riduzione Premium /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:PremiumReduction/nes:EndYear
RECORDID int32 ID della registrazione /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RecordID
RISKGROUPCODE int32 Codice del gruppo di rischio /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupCode
RISKGROUPDESCRIPTION varchar2 Descrizione del gruppo di rischio /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupDescription
RISKGROUPID int32 ID gruppo di rischio /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:RiskGroup/nes:RiskGroupId
SECTORCODE int32 Codice di settore /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorCode
SECTORDESCRIPTION varchar2 Descrizione del settore /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorDescription
SECTORID int32 ID settore /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:Sector/nes:SectorId
STARTPERIOD int32 Periodo di inizio /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:StartPeriod
STARTYEAR int32 Anno di inizio /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:StartYear
WAO_WIA char Legge sull'incapacità /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:WAO_WIA
WW char Legge sui disoccupati /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:WW
ZVW int32 Legge sull'assicurazione sanitaria /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZVW
ZVWCONTRIBUTION int32 Contributo alla legge sull'assicurazione sanitaria /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZVWContribution
ZW char Legge sulla salute /soap:Envelope/soap:Body/nes:SVW_GetAll_AllEmployeesByCompanyResponse/nes:SVW_GetAll_AllEmployeesByCompanyResult/nes:EmployeeSVWItem/nes:EmployeeSVWsettings/nes:EmployeeSVWsetting/nes:ZW

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: