Table TIMREGUL
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TIMREGUL | TIG | Time adjustment | Time management |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TIG0 | LIG | No | |
| TIG1 | REFNUM+STRDAT+LIG | No | |
| TIG2 | REFNUM+DATPYR+STRDAT+LIG | No | |
| TIG3 | REFNUM+DATPYR+STRDAT+STRTIM+LIG | No | |
| TIG4 | REFNUM+CTRNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ANAFLG | Ana flag | C | 1 | |||||
| AUTFLG | Automatic | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BRKTIM | Rest break | DCB | 2.2 | |||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CMT | Comment | CMT | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTRDAT | Date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| DATBUL | Pay date | D | ||||||
| DATPYR | Pay date | D | ||||||
| DAYNGT | Day/night | M | 15 | 402 | ||||
| DCGUID | Line identifier | L | 8 | |||||
| DIE | Dim type code | DIE | [DIE]DIE0=[TIG]DIE | Block | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | ||||
| ENDDAT | End date | D | ||||||
| ENDDAY | Half-day | M | 4 | 1 | ||||
| ENDTIM | End time | HM | ||||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Site | FCY | [FCY]FCY0=[TIG]FCY | Block | ||||
| FLD1 | Alpha field 1 | A | 15 | |||||
| FLD2 | Alpha field 2 | A | 15 | |||||
| FLGBUL | To take | M | 4 | 1 | ||||
| LIG | Line | L | 8 | |||||
| NATCOD | Nature of activity | NAT | [NAT]NAT0=[TIG]NATCOD | Block | ||||
| NBRDAY | Days | DCB | 4.2 | |||||
| NBRHOU | Hours | DCB | 4.2 | |||||
| QTY1 | First quantity | DCB | 9.2 | |||||
| QTY2 | Second quantity | DCB | 9.2 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[TIG]REFNUM | Block | ||||
| SRV | Department | SRV | [SRV]SRV0=[TIG]SRV | Block | ||||
| STA | Status | C | 2 | |||||
| STAFLG | Signature | AUS | [AUS]CODUSR=[TIG]STAFLG | Other | ||||
| STRDAT | Start date | D | ||||||
| STRDAY | Half-day | M | 4 | 1 | ||||
| STRTIM | Start time | HM | ||||||
| TIM | Nature of events | TPS | [TIM]TIM0=[TIG]TIM | Block | ||||
| TYPDAY | Day type | M | 15 | 413 | ||||
| TYPPGN | Leave type | M | 4 | 2408 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |