invantive documentation
Invantive SupportforenAnmelden / Eintragen

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