profit_illness: AFAS Profit Illnesses
read only REST
- Catalogo:
AfasOnline - Schema:
GetConnector - Label: Illnesses
È possibile solo recuperare i dati.
Riepilogo
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, Absence |
||
absencetypedesc |
varchar2 |
Type verzuim | fetched only when named, Absence |
||
absencetypeid |
varchar2 |
Type verzuim code | fetched only when named, Absence |
||
actionid |
int32 |
Actiecode (connector) | fetched only when named, Action |
||
addnumber |
varchar2 |
Toev. aan huisnr. | fetched only when named, Add |
||
address4 |
varchar2 |
Land | fetched only when named, Address4 |
||
applyqualifyingdays |
int32 |
Wachtdagen toepassen | fetched only when named, Apply |
||
bsn |
varchar2 |
Burgerservicenummer | fetched only when named, BSN |
||
city |
varchar2 |
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 |
Medewerker | fetched only when named, Employee |
||
employerid |
varchar2 |
Werkgever | fetched only when named, Employer |
||
enddate |
datetime |
Einddatum/-tijd | fetched only when named, End |
||
exenddate |
varchar2 |
Verwachte einddatum | fetched only when named, Ex |
||
firstday |
int32 |
Aanwezig eerste dag | fetched only when named, First |
||
guid |
varchar2 |
GUID | fetched only when named, GUID |
||
hourweekpresent |
int32 |
Uren per week aanwezig | fetched only when named, Hour |
||
hourweekpresenttherapy |
int32 |
Aanwezigheidsuren AT per week | fetched only when named, Hour |
||
housenumber |
int32 |
Huisnummer | fetched only when named, House |
||
modifieddate |
varchar2 |
Modificato il | fetched only when named, Modified |
||
nostatistic |
int32 |
Verzuimmelding uitsluiten van frequentiestatistiek | fetched only when named, No |
||
nursingaddress |
varchar2 |
Naam verpleegadres | fetched only when named, Nursing |
||
phone |
varchar2 |
Telefoonnr. | fetched only when named, Phone |
||
presence |
number |
% Aanwezigheid | fetched only when named, Presence |
||
presencetherapy |
number |
% Aanwezigheid AT | fetched only when named, Presence |
||
presentlastday |
int32 |
Aanwezig laatste dag | fetched only when named, Present |
||
reasondesc |
varchar2 |
Reden verzuim | fetched only when named, Reason |
||
reasonend |
varchar2 |
Reden afsluiten code | fetched only when named, Reason |
||
reasonid |
varchar2 |
Reden verzuim code | fetched only when named, Reason |
||
recoveredcode |
varchar2 |
Code hersteld code | fetched only when named, Recovered |
||
reportdate |
varchar2 |
Melding begin verzuim | fetched only when named, Report |
||
reportenddate |
datetime |
Melding einde verzuim | fetched only when named, Report |
||
startdate |
datetime |
Begindatum/-tijd | fetched only when named, Start |
||
street |
varchar2 |
Straat | fetched only when named, Street |
||
typeworkresumption |
varchar2 |
Soort werkhervatting code | fetched only when named, Type |
||
typeworkresumptiondesc |
varchar2 |
Soort werkhervatting omschr. | fetched only when named, Type |
||
vangnet |
int32 |
Vangnetregeling | fetched only when named, Vangnet |
||
wao |
number |
WAO/WIA (%) | fetched only when named, WAO |
||
zipcode |
varchar2 |
Postcode | fetched only when named, ZIP |