Table DICOEMP
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| DICOEMP | DIC | Employee field dictionary | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DIC0 | FLD | No | |
| DIC1 | ROW+FLD | No | |
| DIC2 | CODACT | Yes | |
| DIC3 | TBL+FLD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CODACT | Activity code | ACV | [ACV]CODACT=[DIC]CODACT | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| DES | Title | ATX | ||||||
| ENAFLG | Active | M | 4 | 1 | ||||
| ENASEL | Selection | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FLD | Field | AVA | ||||||
| FLDDIM | Dimension | C | 2 | |||||
| FLGRET | Backpay | M | 4 | 1 | ||||
| MSFLG | Total payroll | M | 4 | 1 | MAS | |||
| NBRPAR | No. of parameters | C | 2 | |||||
| PARCOD | Parameter | 5 | A | 10 | ||||
| PARVAL | Value | 5 | AFR | 80 | ||||
| POTFLG | Initialise position/contract | M | 4 | 1 | ||||
| ROW | Sequence | L | 5 | |||||
| TBL | Table | ATB | [ATB]CODFIC=[DIC]TBL | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |