Table COURSEI
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| COURSEI | CSI | Individual program | Training |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CSI0 | COD | No | |
| CSI1 | TCS+COD | No | |
| CSI2 | TCS+COD+REFNUM | No | |
| CSI3 | REFNUM+TCS+COD | No | |
| CSI4 | REFNUM+CTR+COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| COD | Program code | A | 15 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTR | Contract | CTR | ||||||
| CTRDAT | Date of contract | DTR | ||||||
| DESAXX | Title | AX3 | ||||||
| DESJOB | Other title | DES | ||||||
| DUREE | Duration | DCB | 9.2 | |||||
| ENDDAT | End date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FLGPRO | Profession period | M | 4 | 1 | ||||
| JOBPOT | Standard job | JOT | [JOT]JOT0=[CSI]JOBPOT | Block | ||||
| NBRDAYDIF | Training days | NDY | ||||||
| NBRHOUDIF | DIF hours | NDY | ||||||
| NBRHOUMAX | Number of maximum hours | DCB | 9.2 | |||||
| POT | Position | POT | [POT]POT0=POT | Block | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[CSI]REFNUM | Block | ||||
| REFNUMT | Tutor | MAT | [ID]ID0=[CSI]REFNUMT | Block | ||||
| RRHCMT | HRM cmnt | AC0 | 1 | |||||
| SHOAXX | Short title | AX1 | ||||||
| STRDAT | Start date | D | ||||||
| SUIACN | Follow-up actions | 10 | ADI | [ADI]CODE=468;SUIACN | Block | |||
| SUICMT | Follow-up comment | 10 | A | 100 | ||||
| SUIDAT | Tracking date | 10 | D | |||||
| TCS | Standard program | TCS | [TCS]TCS0=[CSI]TCS | Block | ||||
| UOMTIM | Time unit | M | 15 | 313 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |