Please enable JavaScript to view this site.

Navigation: Schema: Absence > Tables

AbsencesByEmployeeId

List of absences for an employee__Activity name :__ GetAbsencesByEmployeeIdGet a list of all absences for the given employee

Catalog: LoketNlRest

Schema: Absence

Retrieve: true

Insert: true

Update: false

Delete: false

Select loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/absences

Insert loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/absences

Update loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/absences

Delete loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/absences

Field Selection Method: NotRequired

Base Path: _embedded[*]

Select loket.nl (REST) API Operation: get /providers/employers/employees/{employeeId}/absences

Insert loket.nl (REST) API Operation: post /providers/employers/employees/{employeeId}/absences

Table Function Parameters

The following parameters can be used to control the behaviour of the table function AbsencesByEmployeeId. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

employeeId

guid

 

The unique identifier of the employee

 

Table Function Columns

The columns of the table function AbsencesByEmployeeId 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.

Name

Data Type

Label

Required

Documentation

accidentType_key

int32

 

The key of the accident type. Possible values can be aquired via the metadata endpoint.

accidentType_value

string(50)

 

Description of the accident type.

actionToBeTakenByOccupationalHealthAndSafetyService_key

int32

 

The key of the desired action to be taken by the occupational health and safety service. Possible values can be aquired via the metadata endpoint.

actionToBeTakenByOccupationalHealthAndSafetyService_value

string(50)

 

Description of the desired action to be taken by the occupational health and safety service.

caseManager_function

string(50)

 

Function of the case manager.

caseManager_name

string(25)

 

Name of the case manager for reintegration.

caseManager_organization

string(70)

 

Function of the case manager.

caseManager_phoneNumber

string(15)

 

The phone number of the employee.

causeOfAbsence_key

int32

 

The key of the cause of the absence. Possible values can be acquired via the metadata endpoint

causeOfAbsence_value

string(50)

 

Description of the cause of the absence.

comments

string(4000)

 

Free text field to register any relevant information.

contactInformation_city

string(24)

 

City of the address

contactInformation_country_isoCode

string(2)

 

The ISO 3166-1 alpha-2 value for the country

contactInformation_country_key

int32

 

The key for the country. Posible values can be aquired via the metadata endpoint

contactInformation_country_value

string(50)

 

The name of the country

contactInformation_endDate

datetime

 

end date of the contact information

contactInformation_furtherIndication_key

int32

 

The key of the further indication. Posible values can be aquired via the metadata endpoint

contactInformation_furtherIndication_value

string

 

The description of the further indication, the posible values are "WW" and "AB"

contactInformation_houseNumber

int32

 

House number of the address

contactInformation_houseNumberAddition

string(4)

 

An addition to further specify the house/door/postbox. For example used to specifty a room of floor number in addition to the house number.

contactInformation_locationType_key

int32

 

The key of the location type. Posible values can be aquired via the metadata endpoint

contactInformation_locationType_value

string(50)

 

Description of location type

contactInformation_name

string(70)

 

name of the institute for the contact information.

contactInformation_phoneNumber

string(15)

 

The phone number to contact the employee on.

contactInformation_postalCode

string(9)

 

The postal code of the address

contactInformation_startDate

datetime

 

start date of the contact information

contactInformation_street

string(24)

 

Streetname of the address

expectedDateOfChildbirth

datetime

 

Bevallingsdatum

expectedDuration_key

int32

 

The key of the expected duration of the absence. Possible values can be acquired via the metadata endpoint.

expectedDuration_value

string(50)

 

Description of the expected duration of the absence.

expectedEndDateOfMaternityLeave

datetime

 

verwachte datum einde zwangerschapsverlof

hasMobilityIssue

boolean

 

This field indicates whether the Employee has an issue limiting its mobility.

hoursWorkedOnFirstDayOfAbsence

int64

 

The number of hours worked on the first day of the absence.

id

guid

 

The unique identifier of an object (GUID/UUID)

isDisruptedEmploymentRelationship

boolean

 

Indicates whether the employement relationship between employee and employer is disrupted.

isHospitalised

boolean

 

Betreft het een ziekenhuisopnamen

isRecoveredWithinTwoWeeks

boolean

 

This field indicates whether the Employee is (expected) recoverd within two weeks, relating to a full recovery.

isThirdPartyLiability

boolean

 

This field is related to `accidentType`. When `accidentType` is specified, this field indicates whether a third party is liable for the accident.

isWorkRelatedIllness

boolean

 

Beroepsziekte

progress_currentIncapacityPercentage

int64

 

percentage of not being able to work

progress_endOfAbsence_date

datetime

 

The last day of the absence.

progress_endOfAbsence_reason_key

int32

 

The key of the reason why the absence is ended. Possible values can be aquired via the metadata endpoint.

progress_endOfAbsence_reason_value

string(50)

 

Description of the reason why the absence ended.

progress_startDate

datetime

 

start dat of the incapacityPercentage

reintegration_dateOfFinalizingPlanOfAction

datetime

 

The day on which a plan of action (for return to normal work) was finalized.

reintegration_reintegrationGoal_key

int32

 

The key for the reintegration goal. Related to the Wet Verbetering Poortwachter.

reintegration_reintegrationGoal_value

string(50)

 

The name of the country

 

25-05-2022 14:15 Version 22.1.46-BETA+3385