# knsubject Dossier - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `knsubject` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `da` | `datetime` | Instuurdatum | | | | `ds` | `varchar2(255)` | Onderwerp | | | | `dtfr` | `datetime` | Begindatum | | | | `dtst` | `datetime` | Datum afgehandeld | | | | `dtto` | `datetime` | Einddatum | | | | `emid` | `varchar2(80)` | Verantwoordelijke | | | | `feco` | `int32` | Betreft | | | | `fileid` | `varchar2(32)` | File Id | | | | `filestream` | `blob` | File as byte-array | | | | `filetrans` | `char` | Save file with subject | | | | `fvf1` | `int32` | Waarde kenmerk 1 | | | | `fvf2` | `int32` | Waarde kenmerk 2 | | | | `fvf3` | `int32` | Waarde kenmerk 3 | | | | `markopened` | `char` | Mark subject as opened | | | | `profileid` | `int32` | Profiel ID | | | | `said` | `varchar2(5)` | Type actie | | | | `sbbl` | `char` | Geblokkeerd | | | | `sbhi` | `int32` | Aanleiding | | | | `sbid` | `int32` | Dossieritem | | | | `sbpa` | `varchar2(255)` | FileName of the attachment | | | | `sbtx` | `varchar2` | Toelichting | | | | `scid` | `varchar2(5)` | Bron | | | | `st` | `char` | Afgehandeld | | | | `stid` | `int32` | Type dossieritem | | | | `subjecthandler` | `varchar2(38)` | HandlerId | | | | `usid` | `varchar2(80)` | Instuurder | | | | `vipr` | `varchar2(20)` | Prioriteit | | |