invantive documentation
Forum di supporto InvantiveAccedi / Registrati

PersonalInformations: Nmbrs Dipendenti Società Dipendenti Dati personali Contratto Stipendio Indirizzo

read only per partition XML

  • Catalogo: Nmbrs
  • Schema: Employees
  • Etichetta: Dipendenti Società Dipendenti Dati personali Contratto Stipendio Indirizzo

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: PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompany
  • Percorso XML: /nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress

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 PersonalInformations. 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
BIRTHDAY datetime Birthday /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:Birthday
BSN varchar2 Numero della sicurezza sociale /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:BSN
CITY varchar2 City /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:City
COMPANY_CODE int64 ID dell'azienda
CONTRACTENDDATE datetime Data di scadenza del contratto /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractEndDate
CONTRACTHOURS decimal Ore del contratto /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractHours
CONTRACTSTARTDATE datetime Data di inizio del contratto /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractStartDate
EMAILPRIVATE varchar2 Indirizzo e-mail privato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailPrivate
EMAILWORK varchar2 Indirizzo e-mail di lavoro /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailWork
EMPLOYEEID int32 ID dell'impiegato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeID
EMPLOYEENUMBER int32 Numero dei dipendenti /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeNumber
FIRSTNAME varchar2 Nome /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:FirstName
GENDER varchar2 Gender /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:Gender
HOURLYWAGE decimal Retribuzione oraria /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HourlyWage
HOUSENUMBER varchar2 Numero civico /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumber
HOUSENUMBERADDITION varchar2 Aggiunta del numero civico /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumberAddition
LASTNAME varchar2 Cognome /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:LastName
POSTCODE varchar2 Codice postale /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:PostCode
PREFIX varchar2 Prefix /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:Prefix
SALARYTYPE varchar2 Tipo di retribuzione /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:SalaryType
SALARYVALUE decimal Valore dello stipendio /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:SalaryValue
STREET varchar2 Street /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:Street
TELEPHONEMOBILEPRIVATE varchar2 Cellulare privato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobilePrivate
TELEPHONEMOBILEWORK varchar2 Lavoro nel settore della telefonia mobile /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobileWork
TELEPHONEPRIVATE varchar2 Numero di telefono privato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephonePrivate
TELEPHONEWORK varchar2 Telefono del lavoro /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneWork

Riferito da

Note di rilascio

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