Table | Abbreviation | Title | Module | Activity code |
---|---|---|---|---|
PLANEMP | PLE | Employee plannings | Time management |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PLE0 | REFNUM+DAT+CTRNUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
BRKTIM | Rest break | 3 | DCB | 2.2 | ||||
CCE1 | Analytical dimension 1 | 3 | CCE | [CCE]CCE0=DIE(0);CCE1 | Other | AX1 | ||
CCE2 | Analytical dimension 2 | 3 | CCE | [CCE]CCE0=DIE(1);CCE2 | Other | AX2 | ||
CCE3 | Analytical dimension 3 | 3 | CCE | [CCE]CCE0=DIE(2);CCE3 | Other | AX3 | ||
CCE4 | Analytical dimension 4 | 3 | CCE | [CCE]CCE0=DIE(3);CCE4 | Other | AX4 | ||
CCE5 | Analytical dimension 5 | 3 | CCE | [CCE]CCE0=DIE(4);CCE5 | Other | AX5 | ||
CCE6 | Analytical dimension 6 | 3 | CCE | [CCE]CCE0=DIE(5);CCE6 | Other | AX6 | ||
CCE7 | Analytical dimension 7 | 3 | CCE | [CCE]CCE0=DIE(6);CCE7 | Other | AX7 | ||
CCE8 | Analytical dimension 8 | 3 | CCE | [CCE]CCE0=DIE(7);CCE8 | Other | AX8 | ||
CCE9 | Analytical dimension 9 | 3 | CCE | [CCE]CCE0=DIE(8);CCE9 | Other | AX9 | ||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CRETIM | Time | L | 8 | |||||
CREUSR | Creation user | A | 5 | |||||
CTRNUM | Contract | CTR | ||||||
DAT | Day | D | ||||||
DIE | Dim type code | DIE | [DIE]DIE0=[PLE]DIE | Block | ANA | |||
ENDTIM | End time | 3 | HM | |||||
EXPNUM | Export number | L | 8 | |||||
NATCOD | Nature of activity | 3 | NAT | [NAT]NAT0=[PLE]NATCOD | Block | |||
NBRDAY | Days | NDY | ||||||
NBRHOU | Hours | NDY | ||||||
REFNUM | Employee ID | MAT | [ID]ID0=[PLE]REFNUM | Block | ||||
STRTIM | Start time | 3 | HM | |||||
TYPDAY | Day type | M | 15 | 401 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDTIM | Time | L | 8 | |||||
UPDUSR | Change user | A | 5 | |||||
YEA | Year | C | 4 |