---
title: "profit_illness (AFAS Profit)"
description: "Illnesses"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/afas/AfasOnline.GetConnector.profit_illness
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.GetConnector.profit_illness
updated: 2026-11-17T12:39:42Z
license: https://documentation.invantive.eu/de/
---

# profit_illness: AFAS Profit Illnesses

`read only` `REST`

- Katalog: `AfasOnline`
- Schema: `GetConnector`
- Label: Illnesses

Es können nur Daten abgerufen werden.

## Zusammenfassung

Profit_Illness

## API-Quelle

- Endpunkt: `/connectors/Profit_Illness`
- Metadaten: `metainfo/get/Profit_Illness`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 353 |
| Anzahl der Vollscan-Zeilen pro Minute | 65,100 |
| Anzahl der Query-Zeilen pro Minute | 169 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Tabellenspalten

Die Spalten der Tabelle `profit_illness` 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 |
|---|---|---|:---:|---|---|
| `absenceid` | `int32` | Verzuimmelding | [ ] | fetched only when named, `AbsenceId` |  |
| `absencetypedesc` | `varchar2(100)` | Type verzuim | [ ] | fetched only when named, `AbsenceTypeDesc` |  |
| `absencetypeid` | `varchar2(20)` | Type verzuim code | [ ] | fetched only when named, `AbsenceTypeId` |  |
| `actionid` | `int32` | Actiecode (connector) | [ ] | fetched only when named, `ActionId` |  |
| `addnumber` | `varchar2(30)` | Toev. aan huisnr. | [ ] | fetched only when named, `AddNumber` |  |
| `address4` | `varchar2(255)` | Land | [ ] | fetched only when named, `Address4` |  |
| `applyqualifyingdays` | `int32` | Wachtdagen toepassen | [ ] | fetched only when named, `ApplyQualifyingDays` |  |
| `bsn` | `varchar2(25)` | Burgerservicenummer | [ ] | fetched only when named, `BSN` |  |
| `city` | `varchar2(50)` | Woonplaats | [ ] | fetched only when named, `City` |  |
| `continuous` | `char` | Doorlopend verzuim | [ ] | fetched only when named, `Continuous` |  |
| `dvid` | `int32` | Dienstverband | [ ] | fetched only when named, `DvId` |  |
| `employeeid` | `varchar2(15)` | Medewerker | [ ] | fetched only when named, `EmployeeId` |  |
| `employerid` | `varchar2(15)` | Werkgever | [ ] | fetched only when named, `EmployerId` |  |
| `enddate` | `datetime` | Einddatum/-tijd | [ ] | fetched only when named, `EndDate` |  |
| `exenddate` | `varchar2(8)` | Verwachte einddatum | [ ] | fetched only when named, `ExEndDate` |  |
| `firstday` | `int32` | Aanwezig eerste dag | [ ] | fetched only when named, `FirstDay` |  |
| `guid` | `varchar2(38)` | GUID | [ ] | fetched only when named, `GUID` |  |
| `hourweekpresent` | `int32` | Uren per week aanwezig | [ ] | fetched only when named, `HourWeekPresent` |  |
| `hourweekpresenttherapy` | `int32` | Aanwezigheidsuren AT per week | [ ] | fetched only when named, `HourWeekPresentTherapy` |  |
| `housenumber` | `int32` | Huisnummer | [ ] | fetched only when named, `HouseNumber` |  |
| `modifieddate` | `varchar2(8)` | Geändert am | [ ] | fetched only when named, `ModifiedDate` |  |
| `nostatistic` | `int32` | Verzuimmelding uitsluiten van frequentiestatistiek | [ ] | fetched only when named, `NoStatistic` |  |
| `nursingaddress` | `varchar2(80)` | Naam verpleegadres | [ ] | fetched only when named, `NursingAddress` |  |
| `phone` | `varchar2(30)` | Telefoonnr. | [ ] | fetched only when named, `Phone` |  |
| `presence` | `number` | % Aanwezigheid | [ ] | fetched only when named, `Presence` |  |
| `presencetherapy` | `number` | % Aanwezigheid AT | [ ] | fetched only when named, `PresenceTherapy` |  |
| `presentlastday` | `int32` | Aanwezig laatste dag | [ ] | fetched only when named, `PresentLastDay` |  |
| `reasondesc` | `varchar2(100)` | Reden verzuim | [ ] | fetched only when named, `ReasonDesc` |  |
| `reasonend` | `varchar2(20)` | Reden afsluiten code | [ ] | fetched only when named, `ReasonEnd` |  |
| `reasonid` | `varchar2(20)` | Reden verzuim code | [ ] | fetched only when named, `ReasonId` |  |
| `recoveredcode` | `varchar2(20)` | Code hersteld code | [ ] | fetched only when named, `RecoveredCode` |  |
| `reportdate` | `varchar2(8)` | Melding begin verzuim | [ ] | fetched only when named, `ReportDate` |  |
| `reportenddate` | `datetime` | Melding einde verzuim | [ ] | fetched only when named, `ReportEndDate` |  |
| `startdate` | `datetime` | Begindatum/-tijd | [ ] | fetched only when named, `StartDate` |  |
| `street` | `varchar2(60)` | Straat | [ ] | fetched only when named, `Street` |  |
| `typeworkresumption` | `varchar2(20)` | Soort werkhervatting code | [ ] | fetched only when named, `TypeWorkResumption` |  |
| `typeworkresumptiondesc` | `varchar2(100)` | Soort werkhervatting omschr. | [ ] | fetched only when named, `TypeWorkResumptionDesc` |  |
| `vangnet` | `int32` | Vangnetregeling | [ ] | fetched only when named, `Vangnet` |  |
| `wao` | `number` | WAO/WIA (%) | [ ] | fetched only when named, `WAO` |  |
| `zipcode` | `varchar2(15)` | Postcode | [ ] | fetched only when named, `ZIPCode` |  |
