invantive documentation
Invantive SupportforenAnmelden / Eintragen

PersonalInformations: Nmbrs Mitarbeiter Unternehmensmitarbeiter Personalinformationen Vertrag Gehalt Adresse

read only per partition XML

  • Katalog: Nmbrs
  • Schema: Employees
  • Bezeichnung: Mitarbeiter Unternehmensmitarbeiter Personalinformationen Vertrag Gehalt Adresse

Die Daten in dieser Tabelle sind nach dem Wert der Spalte COMPANY_CODE aufgeteilt.

Es können nur Daten abgerufen werden.

API-Quelle

  • XML-Dienst: EmployeeService.asmx
  • XML-Thema: PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompany
  • XML-Pfad: /nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 48

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle PersonalInformations sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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 Sozialversicherungsnummer /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 Firmen ID
CONTRACTENDDATE datetime Vertragsende /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractEndDate
CONTRACTHOURS decimal Vertragsstunden /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractHours
CONTRACTSTARTDATE datetime Vertragsbeginn /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractStartDate
EMAILPRIVATE varchar2 E-Mail-Adresse (vertraulich) /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailPrivate
EMAILWORK varchar2 E-Mail-Adresse (beruflich) /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailWork
EMPLOYEEID int32 Mitarbeiter ID /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeID
EMPLOYEENUMBER int32 Mitarbeiter-Nummer /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeNumber
FIRSTNAME varchar2 Vorname /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 Stundenlohn /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HourlyWage
HOUSENUMBER varchar2 Hausnummer /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumber
HOUSENUMBERADDITION varchar2 Hinzufügen einer Hausnummer /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumberAddition
LASTNAME varchar2 Nachname /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:LastName
POSTCODE varchar2 Postleitzahl /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 Gehaltsart /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:SalaryType
SALARYVALUE decimal Gehaltswert /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 Privatnummer /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobilePrivate
TELEPHONEMOBILEWORK varchar2 Arbeit mit dem Handy /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobileWork
TELEPHONEPRIVATE varchar2 Telefonnummer (privat) /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephonePrivate
TELEPHONEWORK varchar2 Telefon Arbeit /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneWork

Verwiesen von

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: