# ZiekmeldingenPerPersoon: Sick Reports per Person - Name: `ZiekmeldingenPerPersoon` - Catalog: `LoketNL` - Schema: `Lists` - Label: Sick Reports per Person ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `personId` | `string` | ☑ | | | ## Table Columns The columns of the table `ZiekmeldingenPerPersoon` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AANTALURENGEWERKTEERSTEZIEKTEDAG` | `int32` | Hours Worked on First Sick Day | ☐ | | | `BEROEPSZIEKTE` | `int32` | Occupational Disease | ☐ | | | `CASEMANAGERFUNCTIE` | `string(60)` | Case Manager Function | ☐ | | | `CASEMANAGERNAAM` | `string(240)` | Case Manager Name | ☐ | | | `CASEMANAGERORGANISATIE` | `string(120)` | Case Manager Organisation | ☐ | | | `CASEMANAGERTELEFOON` | `string(60)` | Case Manager Phone | ☐ | | | `DATUMEERSTEZIEKTEDAG` | `datetime` | First Sick Day Date | ☐ | | | `DATUMEINDEVERPLEEGADRES` | `datetime` | Nursing Address End Date | ☐ | | | `DATUMHERSTELD` | `datetime` | Recovery Date | ☐ | | | `DATUMINGANGVERPLEEGADRES` | `datetime` | Nursing Address Start Date | ☐ | | | `DATUMPLANVANAANPAK` | `datetime` | Action Plan Date | ☐ | | | `DOELREINTEGRATIE` | `int32` | Reintegration Goal | ☐ | | | `ENTRYID` | `string(480)` | Entry ID | ☐ | | | `GESCHATTEDUUR` | `int32` | Estimated Duration | ☐ | | | `GEWENSTECONTROLEARBODIENST` | `int32` | Desired Check Occupational Health Service | ☐ | | | `HERSTELBINNENTWEEWEKEN` | `int32` | Recovery Within Two Weeks | ☐ | | | `HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `MOBILITEITSPROBLEEM` | `int32` | Mobility Problem | ☐ | | | `NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `PERCENTAGEARBEIDSONGESCHIKT` | `int32` | Disability Percentage | ☐ | | | `PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `REDENHERSTELD` | `int32` | Recovery Reason | ☐ | | | `REDENZIEK` | `int32` | Sick Reason | ☐ | | | `SPECIFICATIEONGEVAL` | `int32` | Specification of Accident | ☐ | | | `STRAATNAAMAFWIJKEND` | `string(120)` | Deviating Street Name | ☐ | | | `TOELICHTING` | `string(4000)` | Explanation | ☐ | | | `VERBIJZONDERINGREDENZIEK` | `int32` | Specification Sick Reason | ☐ | | | `VERHAALBAAR` | `int32` | Recoverable | ☐ | | | `VERMOEDELIJKEBEVALLINGSDATUM` | `datetime` | Expected Delivery Date | ☐ | | | `VERMOEDELIJKEEINDDATUMBEVALLINGSVERLOF` | `datetime` | Expected Maternity Leave End Date | ☐ | | | `VERPLEEGADRESNAAM` | `string(120)` | Nursing Address Name | ☐ | | | `VERPLEEGADRESSOORT` | `int32` | Nursing Address Type | ☐ | | | `VERPLEEGADRESTELEFOON` | `string(120)` | Nursing Address Phone | ☐ | | | `ZIEKENHUISOPNAME` | `int32` | Hospital Admission | ☐ | |