# Profit_Illness: Illnesses ## Documentation Profit_Illness - Name: `Profit_Illness` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Illnesses - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Illness` - Insert Service URL (OData-specific): `/connectors/Profit_Illness` - Update Service URL (OData-specific): `/connectors/Profit_Illness` - Delete Service URL (OData-specific): `/connectors/Profit_Illness` - Field Selection Method (OData-specific): NotRequired ## 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(100)` | Absence type | | | | `AbsenceTypeId` | `string(20)` | Absence type code | | | | `ActionId` | `int32` | Action code (connector) | | | | `AddNumber` | `string(30)` | House number suffix | | | | `Address4` | `string(255)` | Country | | | | `ApplyQualifyingDays` | `decimal` | Apply waiting days | | | | `BSN` | `string(25)` | Citizen service number | | | | `City` | `string(50)` | City | | | | `Continuous` | `boolean` | Continuing absence | | | | `DvId` | `int32` | Employment | | | | `EmployeeId` | `string(15)` | Employee | | | | `EmployerId` | `string(15)` | Employer | | | | `EndDate` | `datetime` | End date/time | | | | `ExEndDate` | `string(8)` | Expected end date | | | | `FirstDay` | `int32` | Present on first day | | | | `GUID` | `string(38)` | GUID | | | | `HourWeekPresent` | `int32` | Hours present per week | | | | `HourWeekPresentTherapy` | `int32` | Attendance hours AT per week | | | | `HouseNumber` | `int32` | House number | | | | `ModifiedDate` | `string(8)` | Modified on | | | | `NoStatistic` | `decimal` | Exclude absence notification from frequency statistics | | | | `NursingAddress` | `string(80)` | Care address name | | | | `Phone` | `string(30)` | Phone number | | | | `Presence` | `decimal` | % Attendance | | | | `PresenceTherapy` | `decimal` | % Attendance AT | | | | `PresentLastDay` | `int32` | Present on last day | | | | `ReasonDesc` | `string(100)` | Absence reason | | | | `ReasonEnd` | `string(20)` | Closing reason code | | | | `ReasonId` | `string(20)` | Absence reason code | | | | `RecoveredCode` | `string(20)` | Recovered code | | | | `ReportDate` | `string(8)` | Notification of start of absence | | | | `ReportEndDate` | `datetime` | Notification of end of absence | | | | `StartDate` | `datetime` | Start date/time | | | | `Street` | `string(60)` | Street | | | | `TypeWorkResumption` | `string(20)` | Return to work kind code | | | | `TypeWorkResumptionDesc` | `string(100)` | Return to work kind descr. | | | | `Vangnet` | `decimal` | Safety net scheme | | | | `WAO` | `decimal` | WAO/WIA (%) | | | | `ZIPCode` | `string(15)` | Postcode | | |