Table COURSEISA
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| COURSEISA | CSISA | Individual program | Training | FKSSD |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CSISA0 | COD | No | |
| CSISA1 | TCS+COD | No | |
| CSISA2 | TCS+COD+REFNUM+CTRNUM+CTRDAT | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACRNUM | Number | A | 20 | |||||
| AUUID | Single identifier | AUUID | ||||||
| COD | Program code | A | 15 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[CSISA]CREUSR | Other | ||||
| CTRDAT | Date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| NQFLVL | NQF Level | ADI | [ADI]CODE=11675;NQFLVL | Block | ||||
| PRGTYP | Type | M | 15 | 11708 | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[CSISA]REFNUM | Delete | ||||
| TCS | Standard program | TCS | [TCS]TCS0=[CSISA]TCS | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[CSISA]UPDUSR | Other |