# Ziekmeldingen: Sick Leaves - Name: `Ziekmeldingen` - Catalog: `LoketNL` - Schema: `Views` - Label: Sick Leaves ## Table Columns The columns of the table `Ziekmeldingen` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `psn_ACHTERNAAM` | `string(25)` | Last Name | ☐ | | | `psn_BURGERLIJKESTAAT` | `int32` | Marital Status | ☐ | | | `psn_EMAIL` | `string(100)` | Email | ☐ | | | `psn_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `psn_ESSGEBRUIKERID` | `int32` | ESS User ID | ☐ | | | `psn_FAX` | `string(60)` | Fax Number | ☐ | | | `psn_GEBOORTEDATUM` | `datetime` | Date of Birth | ☐ | | | `psn_GEBOORTEPLAATS` | `string(60)` | City of Birth | ☐ | | | `psn_GEBRUIKACHTERNAAM` | `int32` | Use Last Name | ☐ | | | `psn_GESLACHT` | `int32` | Gender | ☐ | | | `psn_HUISNUMMER` | `int32` | House Number | ☐ | | | `psn_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `psn_HUISNUMMERTOEVOEGING` | `string(4)` | House Number Addition | ☐ | | | `psn_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(4)` | Deviating House Number Addition | ☐ | | | `psn_LAND` | `int32` | Country | ☐ | | | `psn_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `psn_LOCATIE` | `string(35)` | Location | ☐ | | | `psn_LOCATIEAFWIJKEND` | `string(35)` | Deviating Location | ☐ | | | `psn_MOBIEL` | `string(60)` | Mobile Phone | ☐ | | | `psn_NAAM` | `string(240)` | Name | ☐ | | | `psn_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `psn_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `psn_NATIONALITEIT` | `int32` | Nationality | ☐ | | | `psn_NUMMERIDENTIFICATIEDOCUMENT` | `string(100)` | Number Identification Document | ☐ | | | `psn_OVERLIJDENSDATUM` | `datetime` | Date of Death | ☐ | | | `psn_PARTNERACHTERNAAM` | `string(25)` | Partner Last Name | ☐ | | | `psn_PARTNERVOORVOEGSEL` | `string(10)` | Partner Prefix | ☐ | | | `psn_PERSONEELSNUMMER` | `int32` | Employee Number | ☐ | | | `psn_PERSOONID` | `int32` | Person ID | ☐ | | | `psn_PLAATSNAAM` | `string(24)` | City | ☐ | | | `psn_PLAATSNAAMAFWIJKEND` | `string(24)` | Deviating City | ☐ | | | `psn_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `psn_POSTCODE` | `string(9)` | ZIP Code | ☐ | | | `psn_POSTCODEAFWIJKEND` | `string(9)` | Deviating Postal Code | ☐ | | | `psn_ROEPNAAM` | `string(28)` | Call Name | ☐ | | | `psn_SOFINUMMER` | `int32` | Social Security Number | ☐ | | | `psn_SOORTIDENTIFICATIEDOCUMENT` | `int32` | Identification Document Type | ☐ | | | `psn_STRAATNAAM` | `string(24)` | Street Name | ☐ | | | `psn_STRAATNAAMAFWIJKEND` | `string(24)` | Deviating Street Name | ☐ | | | `psn_TELEFOON` | `string(60)` | Phone | ☐ | | | `psn_TITULATUUR` | `int32` | Title | ☐ | | | `psn_VOORLETTERS` | `string(6)` | Initials | ☐ | | | `psn_VOORVOEGSEL` | `string(10)` | Prefix | ☐ | | | `wgr_ADMINISTRATIEKANTOORID` | `int32` | Administration Office ID | ☐ | | | `wgr_ADMINISTRATIENUMMER` | `string(30)` | Administration Number | ☐ | | | `wgr_AKTIEVEDIENSTVERBANDEN` | `int32` | Active Employments | ☐ | | | `wgr_BRANCHE` | `int32` | Industry | ☐ | | | `wgr_CONTACTPERSOONFUNCTIE` | `string(60)` | Contact Person Title | ☐ | | | `wgr_CONTACTPERSOONNAAM` | `string(240)` | Contact Person Name | ☐ | | | `wgr_CONTACTPERSOONTELEFOON` | `string(60)` | Contact Person Phone | ☐ | | | `wgr_EMAIL` | `string(60)` | Email | ☐ | | | `wgr_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `wgr_ESSMAILVERSTUREN` | `int32` | Send ESS Mail | ☐ | | | `wgr_EXTERNID` | `guid` | External ID | ☐ | | | `wgr_FAX` | `string(60)` | Fax Number | ☐ | | | `wgr_GROEPCODE` | `int32` | Group Code | ☐ | | | `wgr_HUISNUMMER` | `int32` | House Number | ☐ | | | `wgr_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `wgr_HUISNUMMERTOEVOEGING` | `string(30)` | House Number Addition | ☐ | | | `wgr_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `wgr_JAARFILTER` | `int32` | Year Filter | ☐ | | | `wgr_KVKNUMMER` | `string(60)` | CoC Number | ☐ | | | `wgr_LAND` | `int32` | Country | ☐ | | | `wgr_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `wgr_LOCATIE` | `string(120)` | Location | ☐ | | | `wgr_LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `wgr_NAAM` | `string(120)` | Name | ☐ | | | `wgr_NADEREAANDUIDING` | `int32` | Further Designation | ☐ | | | `wgr_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `wgr_ONDERDEELVANWERKGEVERID` | `int32` | Part of Employer ID | ☐ | | | `wgr_PLAATSNAAM` | `string(60)` | City | ☐ | | | `wgr_PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `wgr_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `wgr_POSTCODE` | `string(30)` | ZIP Code | ☐ | | | `wgr_POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `wgr_PRODUCTSETID` | `int32` | Product Set ID | ☐ | | | `wgr_PROVINCIE` | `int32` | State | ☐ | | | `wgr_RECHTSVORM` | `int32` | Legal Form | ☐ | | | `wgr_SBI` | `int32` | SBI | ☐ | | | `wgr_STRAATNAAM` | `string(60)` | Street Name | ☐ | | | `wgr_STRAATNAAMAFWIJKEND` | `string(60)` | Deviating Street Name | ☐ | | | `wgr_TELEFOON` | `string(60)` | Phone | ☐ | | | `wgr_UPLOADLIMIET` | `int32` | Upload Limit | ☐ | | | `wgr_UPLOADVERBRUIK` | `decimal` | Upload Usage | ☐ | | | `wgr_URL` | `string(120)` | URL | ☐ | | | `wgr_WEBSITELOGOID` | `int32` | Website Logo ID | ☐ | | | `wgr_WERKGEVERAFBEELDINGID` | `int32` | Employer Image ID | ☐ | | | `wgr_WERKGEVERID` | `int32` | Employer ID | ☐ | | | `wgr_WIJZEVERZENDEN` | `int32` | Dispatch Method | ☐ | | | `zmg_AANTALURENGEWERKTEERSTEZIEKTEDAG` | `int32` | Hours Worked on First Sick Day | ☐ | | | `zmg_BEROEPSZIEKTE` | `int32` | Occupational Disease | ☐ | | | `zmg_CASEMANAGERFUNCTIE` | `string(60)` | Case Manager Function | ☐ | | | `zmg_CASEMANAGERNAAM` | `string(240)` | Case Manager Name | ☐ | | | `zmg_CASEMANAGERORGANISATIE` | `string(120)` | Case Manager Organisation | ☐ | | | `zmg_CASEMANAGERTELEFOON` | `string(60)` | Case Manager Phone | ☐ | | | `zmg_DATUMEERSTEZIEKTEDAG` | `datetime` | First Sick Day Date | ☐ | | | `zmg_DATUMEINDEVERPLEEGADRES` | `datetime` | Nursing Address End Date | ☐ | | | `zmg_DATUMHERSTELD` | `datetime` | Recovery Date | ☐ | | | `zmg_DATUMINGANGVERPLEEGADRES` | `datetime` | Nursing Address Start Date | ☐ | | | `zmg_DATUMPLANVANAANPAK` | `datetime` | Action Plan Date | ☐ | | | `zmg_DOELREINTEGRATIE` | `int32` | Reintegration Goal | ☐ | | | `zmg_ENTRYID` | `string(480)` | Entry ID | ☐ | | | `zmg_GESCHATTEDUUR` | `int32` | Estimated Duration | ☐ | | | `zmg_GEWENSTECONTROLEARBODIENST` | `int32` | Desired Check Occupational Health Service | ☐ | | | `zmg_HERSTELBINNENTWEEWEKEN` | `int32` | Recovery Within Two Weeks | ☐ | | | `zmg_HUISNUMMERAFWIJKEND` | `int32` | Deviating House Number | ☐ | | | `zmg_HUISNUMMERTOEVOEGINGAFWIJKEND` | `string(30)` | Deviating House Number Addition | ☐ | | | `zmg_LANDAFWIJKEND` | `int32` | Deviating Country | ☐ | | | `zmg_LOCATIEAFWIJKEND` | `string(120)` | Deviating Location | ☐ | | | `zmg_MOBILITEITSPROBLEEM` | `int32` | Mobility Problem | ☐ | | | `zmg_NADEREAANDUIDINGAFWIJKEND` | `int32` | Deviating Further Designation | ☐ | | | `zmg_PERCENTAGEARBEIDSONGESCHIKT` | `int32` | Disability Percentage | ☐ | | | `zmg_PLAATSNAAMAFWIJKEND` | `string(60)` | Deviating City | ☐ | | | `zmg_POSTBUSAFWIJKEND` | `int32` | Deviating Post Office Box | ☐ | | | `zmg_POSTCODEAFWIJKEND` | `string(30)` | Deviating Postal Code | ☐ | | | `zmg_REDENHERSTELD` | `int32` | Recovery Reason | ☐ | | | `zmg_REDENZIEK` | `int32` | Sick Reason | ☐ | | | `zmg_SPECIFICATIEONGEVAL` | `int32` | Specification of Accident | ☐ | | | `zmg_STRAATNAAMAFWIJKEND` | `string(120)` | Deviating Street Name | ☐ | | | `zmg_TOELICHTING` | `string(4000)` | Explanation | ☐ | | | `zmg_VERBIJZONDERINGREDENZIEK` | `int32` | Specification Sick Reason | ☐ | | | `zmg_VERHAALBAAR` | `int32` | Recoverable | ☐ | | | `zmg_VERMOEDELIJKEBEVALLINGSDATUM` | `datetime` | Expected Delivery Date | ☐ | | | `zmg_VERMOEDELIJKEEINDDATUMBEVALLINGSVERLOF` | `datetime` | Expected Maternity Leave End Date | ☐ | | | `zmg_VERPLEEGADRESNAAM` | `string(120)` | Nursing Address Name | ☐ | | | `zmg_VERPLEEGADRESSOORT` | `int32` | Nursing Address Type | ☐ | | | `zmg_VERPLEEGADRESTELEFOON` | `string(120)` | Nursing Address Phone | ☐ | | | `zmg_ZIEKENHUISOPNAME` | `int32` | Hospital Admission | ☐ | |