invantive documentation
Forum di supporto InvantiveAccedi / Registrati

profit_illness: AFAS Profit Illnesses

read only REST

  • Catalogo: AfasOnline
  • Schema: GetConnector
  • Label: Illnesses

È possibile solo recuperare i dati.

Profit_Illness

Codice sorgente dell'API

  • Punto finale: /connectors/Profit_Illness
  • Metadati: metainfo/get/Profit_Illness

Caratteristiche prestazionali

Characteristic Value
Latenza media di accesso (ms) 353
Righe di scansione completa al minuto 65,100
Numero di righe di Query al minuto 169

Il risultato può essere memorizzato nella memoria cache sul client.

Colonne della tabella

Di seguito sono riportate le colonne della tabella profit_illness. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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) Modificato il 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