Table PJMCNSVTETMP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMCNSVTETMP | VTE | Time verification | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| VTE0 | PRCIDN+VTESEQ | No | |
| VTE1 | PRCIDN+PAUS+DATBEGPER | No | |
| VTE2 | PRCIDN+PAUS | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AGGREGATE | Group by | M | 15 | 2245 | ||||
| AUSLAUNCH | Launched | QTY | ||||||
| AUSSUSPEN | Suspended | QTY | ||||||
| AUSTOLAUNCH | To launch | QTY | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[VTE]CREUSR | Other | ||||
| CRIAUS | Employee | AUS | [AUS]CODUSR=[VTE]CRIAUS | Other | ||||
| CRICPY | Company | CPY | [CPY]CPY0=[VTE]CRICPY | Other | ||||
| CRIFCY | Site | FCY | [FCY]FCY0=[VTE]CRIFCY | Other | ||||
| CRIROL | Role | ADI | [ADI]CODE=639;CRIROL | Other | ||||
| DATBEGPER | Period start date | D | ||||||
| DATENDPER | Period end date | D | ||||||
| HAVTWD | Weekly structure | M | 4 | 1 | ||||
| PAUS | Employee | DCO | ||||||
| PRCIDN | Session ID | ID1 | ||||||
| TIMCAP | Capacity | QTY | ||||||
| TIMSPE | Time spent | QTY | ||||||
| UOM | Unit | UOM | [TUN]TUN0=[VTE]UOM | Other | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[VTE]UPDUSR | Other | ||||
| VTESEQ | Sequence | L | 8 |