invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeePersonalInformationByEmployeeYearPeriod: Nmbrs Employee Period Year Personal Information

read only XML

  • Catalog: Nmbrs
  • Schema: Employees
  • Label: Employee Period Year Personal Information

Can only retrieve data.

API Source

  • XML service: EmployeeService.asmx
  • XML topic: PersonalInfo_Get
  • XML path: /nes:PersonalInfo_GetResult

Performance Characteristics

Characteristic Value
Average access latency (ms) 48

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
EmployeeId number Numeric ID of employee.
Period number Payroll period within year.
Year number Payroll year.

Table Columns

The columns of the table EmployeePersonalInformationByEmployeeYearPeriod 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
BIRTHDAY datetime Birthday /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Birthday
BSN varchar2 Social Security Number /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:BSN
BURGERLIJKESTAAT varchar2 Civil Status /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:BurgerlijkeStaat
COUNTRYOFBIRTHISOCODE varchar2 Country of Birth (ISO Code) /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:CountryOfBirthISOCode
DECEASEDDATE datetime Deceased /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:DeceasedDate
DISPLAYNAME varchar2 Display Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:DisplayName
EMAILPRIVATE varchar2 Email Address Private /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:EmailPrivate
EMAILWORK varchar2 Email Address Work /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:EmailWork
EMPLOYEEID int32 Employee ID
EMPLOYEENUMBER int32 Employee Number /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:EmployeeNumber
FIRSTNAME varchar2 First Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:FirstName
GENDER varchar2 Gender /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Gender One of 'undefined', 'male', 'female'.
ID int32 ID /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Id
IDENTIFICATIONNUMBER varchar2 Identification Number /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:IdentificationNumber
IDENTIFICATIONTYPE int32 Identification Type /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:IdentificationType
INCASEOFEMERGENCY varchar2 In Case of Emergency /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:InCaseOfEmergency
INCASEOFEMERGENCYPHONE varchar2 In Case of Emergency Phone /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:InCaseOfEmergencyPhone
INCASEOFEMERGENCYRELATION varchar2 In Case of Emergency Relation /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:InCaseOfEmergencyRelation
INITIALS varchar2 Initials /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Initials
LASTNAME varchar2 Last Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:LastName
NAAMSTELLING varchar2 Formal Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Naamstelling
NATIONALITYCODE int32 Nationality Code /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:NationalityCode
NICKNAME varchar2 Nickname /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Nickname
NUMBER int32 Number /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Number
PARTNERLASTNAME varchar2 Partner Last Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:PartnerLastName
PARTNERPREFIX varchar2 Partner Prefix /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:PartnerPrefix
PLACEOFBIRTH varchar2 Place of Birth /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:PlaceOfBirth
PREFIX varchar2 Prefix /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Prefix
TELEPHONEMOBILEPRIVATE varchar2 Mobile Phone Private /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TelephoneMobilePrivate
TELEPHONEMOBILEWORK varchar2 Mobile Phone Work /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TelephoneMobileWork
TELEPHONEOTHER varchar2 Other Phone /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TelephoneOther
TELEPHONEPRIVATE varchar2 Phone Private /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TelephonePrivate
TELEPHONEWORK varchar2 Phone Work /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TelephoneWork
TITLE varchar2 Title Name /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:Title
TITLEAFTER varchar2 Title After /soap:Envelope/soap:Body/nes:PersonalInfo_GetResponse/nes:PersonalInfo_GetResult/nes:TitleAfter

Release Notes

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