# Profit_Subjects: Subjects ## Documentation Profit_Subjects - Name: `Profit_Subjects` - Catalog: `AfasOnline` - Schema: `GetConnector` - Label: Subjects - Partition-specific: false - Select: true - Insert: false - Update: false - Delete: false - Select Service URL (OData-specific): `/connectors/Profit_Subjects` - Insert Service URL (OData-specific): `/connectors/Profit_Subjects` - Update Service URL (OData-specific): `/connectors/Profit_Subjects` - Delete Service URL (OData-specific): `/connectors/Profit_Subjects` - Field Selection Method (OData-specific): NotRequired ## Table Columns The columns of the table `Profit_Subjects` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Afgehandeld` | `boolean` | Handled | | | | `Bron` | `string(5)` | Source | | | | `Campagne` | `int32` | Campaign | | | | `Comment` | `string` | Explanation | | | | `ContactNr` | `int32` | ContactId | | | | `DateCreated` | `datetime` | Submission date | | | | `Datum_afgehandeld` | `datetime` | Date handled | | | | `EndDate` | `datetime` | End Date | | | | `FeV1` | `int32` | Characteristic 1 value | | | | `FeV2` | `int32` | Characteristic 2 value | | | | `FeV3` | `int32` | Characteristic 3 value | | | | `Number` | `int32` | Number | | | | `OrgPersId` | `string(15)` | OrgPersId | | | | `Prioriteit` | `string(100)` | Priority | | | | `Project` | `string(15)` | Project | | | | `Responsible` | `string(80)` | Person responsible | | | | `Source` | `int32` | Occasion | | | | `StartDate` | `datetime` | Start date | | | | `Status` | `string(100)` | Code table value | | | | `Subject` | `string(255)` | Subject | | | | `SubjectId` | `int32` | DossierId | | | | `ToApplicant` | `boolean` | ToSollicitant | | | | `ToCreditor` | `boolean` | ToInkooprelatie | | | | `ToDebtor` | `boolean` | ToVerkooprelatie | | | | `ToEmployee` | `boolean` | ToMedewerker | | | | `ToEmployer` | `boolean` | ToWerkgever | | | | `ToOrgPers` | `boolean` | ToOrgPers | | | | `Type_actie` | `string(5)` | Action type | | | | `TypeId` | `int32` | DossierType | | | | `WFClosed` | `datetime` | Workflow completed | | | | `WFstatus` | `string(100)` | Workflow status | | |