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 |