# Profit_Illness: Illnesses ## Documentation Profit_Illness - Name: `Profit_Illness` - Catalog: `AfasOnline` - Schema: `AfasOnline` - Label: Illnesses ## Table Columns The columns of the table `Profit_Illness` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AbsenceId` | `int32` | Absence notification | | | | `AbsenceTypeDesc` | `string` | Absence type | | | | `AbsenceTypeId` | `string` | Absence type code | | | | `ActionId` | `int32` | Action code (connector) | | | | `AddNumber` | `string` | House number suffix | | | | `Address4` | `string` | Country | | | | `ApplyQualifyingDays` | `decimal` | Apply waiting days | | | | `BSN` | `string` | Citizen service number | | | | `City` | `string` | City | | | | `Continuous` | `boolean` | Continuing absence | | | | `DvId` | `int32` | Employment | | | | `EmployeeId` | `string` | Employee | | | | `EmployerId` | `string` | Employer | | | | `EndDate` | `datetime` | End date/time | | | | `ExEndDate` | `string` | Expected end date | | | | `FirstDay` | `int32` | Present on first day | | | | `GUID` | `string` | GUID | | | | `HourWeekPresent` | `int32` | Hours present per week | | | | `HourWeekPresentTherapy` | `int32` | Attendance hours AT per week | | | | `HouseNumber` | `int32` | House number | | | | `ModifiedDate` | `string` | Modified on | | | | `NoStatistic` | `decimal` | Exclude absence notification from frequency statistics | | | | `NursingAddress` | `string` | Care address name | | | | `Phone` | `string` | Phone number | | | | `Presence` | `decimal` | % Attendance | | | | `PresenceTherapy` | `decimal` | % Attendance AT | | | | `PresentLastDay` | `int32` | Present on last day | | | | `ReasonDesc` | `string` | Absence reason | | | | `ReasonEnd` | `string` | Closing reason code | | | | `ReasonId` | `string` | Absence reason code | | | | `RecoveredCode` | `string` | Recovered code | | | | `ReportDate` | `string` | Notification of start of absence | | | | `ReportEndDate` | `datetime` | Notification of end of absence | | | | `StartDate` | `datetime` | Start date/time | | | | `Street` | `string` | Street | | | | `TypeWorkResumption` | `string` | Return to work kind code | | | | `TypeWorkResumptionDesc` | `string` | Return to work kind descr. | | | | `Vangnet` | `decimal` | Safety net scheme | | | | `WAO` | `decimal` | WAO/WIA (%) | | | | `ZIPCode` | `string` | Postcode | | |