Table COMPETENCE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| COMPETENCE | CPC | Skills | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CPC0 | COD | No | |
| CPC1 | NATCPC+COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| COD | Skill | CPC | [CPC]CPC0=[CPC]COD | Delete | ||||
| CODSCA | Level scale | SCA | [SCA]SCA0=[CPC]CODSCA | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRSFLG | Critical skill | M | 4 | 1 | FKZSD | |||
| DES | Title | DES | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FLGKEY | Key skill | M | 4 | 1 | ||||
| LONDES | Long description | 3 | A | 80 | ||||
| NATCPC | Nature of skill | ADI | [ADI]CODE=456;NATCPC | Block | ||||
| SHO | Short title | SHO | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |