# hrempcourse Cursus - Catalog: `AfasOnline` - Schema: `UpdateConnector` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `hrempcourse` 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 | |---|:---:|---|:---:|---| | `cdid` | `int32` | Deelnemer | | | | `coin` | `varchar2(255)` | Opleidingsinstituut | | | | `cosn` | `int32` | Volgnummer | | | | `crid` | `int32` | Cursusevenement | | | | `dabc` | `datetime` | Begindatum cursus | | | | `daec` | `datetime` | Einddatum cursus | | | | `ds` | `varchar2(255)` | Omschrijving | | | | `dtvf` | `datetime` | Geldig van | | | | `dtvt` | `datetime` | Geldig tot | | | | `dura` | `int32` | Cursusduur | | | | `emid` | `varchar2(15)` | Medewerker | | | | `fla` | `char` | Valt onder wettelijk opleidingsrecht | | | | `flal` | `varchar2(20)` | Locatie | | | | `flap` | `varchar2(20)` | Deelname | | | | `flar` | `varchar2(20)` | Resultaat | | | | `flat` | `varchar2(20)` | Type | | | | `grat` | `char` | Certificaat behaald | | | | `meid` | `int32` | Organisatie/persoon | | | | `re` | `varchar2` | Opmerking | | | | `u133f7ad64c9c2b7b357bab975c5450e2` | `number` | Werknemer | | | | `u679fade749e04c227b4427b37b06cb9d` | `number` | Werkgever | | | | `u6b8a4e14449e3009121cc7bc22b2e4b8` | `char` | Vergoeding | | | | `uadfd842344da62b3f63c83a0fae963b6` | `datetime` | Einde terugbetaling | | | | `ubd2ee38a4490e197f2cb5198887c5fac` | `char` | Studieovereenkomst | | | | `ud74bf0e74a5f755bf87f3aba4909f8e4` | `varchar2(20)` | Terugbetalingstermij | | | | `vico` | `varchar2(20)` | Soort | | | | `virc` | `varchar2(20)` | Status cursus | | |