invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

PersonalInformations: Nmbrs Empleados Empleados de la empresa Datos personales Dirección del salario del contrato

read only per partition XML

  • Catálogo: Nmbrs
  • Esquema: Employees
  • Etiqueta: Empleados Empleados de la empresa Datos personales Contrato Salario Dirección

Los datos de esta tabla están divididos por el valor de la columna COMPANY_CODE.

Solo puede recuperar datos.

Fuente de la API

  • Servicio XML: EmployeeService.asmx
  • Tema XML: PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompany
  • Ruta XML: /nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 48

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla PersonalInformations. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 Número de Seguro Social /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 de la Empresa
CONTRACTENDDATE datetime Fecha de finalización del contrato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractEndDate
CONTRACTHOURS decimal Horas de contrato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractHours
CONTRACTSTARTDATE datetime Fecha de inicio del contrato /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:ContractStartDate
EMAILPRIVATE varchar2 Dirección de correo electrónico privada /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailPrivate
EMAILWORK varchar2 Dirección de correo electrónico del trabajo /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmailWork
EMPLOYEEID int32 Identificación del Empleado /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeID
EMPLOYEENUMBER int32 Número de Empleado /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:EmployeeNumber
FIRSTNAME varchar2 Primer Nombre /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 Salario por Hora /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HourlyWage
HOUSENUMBER varchar2 Número de casa /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumber
HOUSENUMBERADDITION varchar2 Incorporación del número de la vivienda /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:HouseNumberAddition
LASTNAME varchar2 Apellido /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:LastName
POSTCODE varchar2 Código Postal /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 de salario /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:SalaryType
SALARYVALUE decimal Importe del salario /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 Teléfono móvil privado /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobilePrivate
TELEPHONEMOBILEWORK varchar2 Trabajo con el móvil /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneMobileWork
TELEPHONEPRIVATE varchar2 Teléfono: Privado /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephonePrivate
TELEPHONEWORK varchar2 Teléfono de Trabajo /soap:Envelope/soap:Body/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResponse/nes:PersonalInfoContractSalaryAddress_GetAll_AllEmployeesByCompanyResult/nes:PersonalInfoContractSalaryAddress/nes:TelephoneWork

Referenciado por

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: