Table VALEMP
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| VALEMP | VEP | Employee values | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| VEP0 | EMP+PYRDAT+BUL | No | |
| VEP5 | BUL | No | |
| VEP1 | EMP+PYRMON | Yes | |
| VEP2 | PYRMON+EMP | Yes | |
| VEP3 | FCY+SRV+EMP+PYRDAT | Yes | |
| VEP4 | PYRDAT+EMP | Yes | |
| VEP6 | FCY+EMP+BUL | No | |
| VEP7 | FCY+SRV+EMP+BUL | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AEMNUM | MEC no. | A | 10 | FINTM | ||||
| AUUID | Single identifier | AUUID | ||||||
| BUL | Payslip | VCR | ||||||
| BULDEMAFF | Paperless payslips | C | 4 | DEMAT | ||||
| CALPAY | Payroll calculation | M | 15 | 330 | ||||
| CODACS | Access code | ACS | [ACS]ACS0=[VEP]CODACS | Block | ||||
| CPYAPL | Application date | D | 1 | KFR | ||||
| CPYYEA | Number of years | C | 4 | KFR | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTRDAT | Contract date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| DATEXM | EXM date | D | ||||||
| DATTPS | Extraction end date | D | ||||||
| DATTRY | TRY date | D | ||||||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Block | ||||
| EMP | Employee | MAT | [ID]ID0=[VEP]EMP | Block | ||||
| ENDDAT | Period end date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[VEP]FCY | Block | ||||
| FCYAPL | Application date | D | 1 | KFR | ||||
| FCYYEA | Number of years | C | 4 | KFR | ||||
| FLGANA | Analytical upd | M | 4 | 1 | ||||
| FLGDEMAT | Paperless | C | 4 | DEMAT | ||||
| FLGGEN | Generation | M | 4 | 1 | ||||
| FLGLOCK | Locked | M | 4 | 1 | ||||
| FLGOUT | Exclude | M | 4 | 1 | ||||
| FLGSYN | Overview | M | 4 | 1 | ||||
| FLGVAR | Additional payments | M | 4 | 1 | ||||
| FLGVRA | Variable upd | M | 4 | 1 | ||||
| LOCKDAT | Date lock | D | ||||||
| LOCKUSR | User lock | AUS | [AUS]CODUSR=[VEP]LOCKUSR | Other | ||||
| MOTDIFINC | Diff. between income | C | 4 | KPO | ||||
| NBREMP | Workforce | C | 4 | KFR | ||||
| ORG | Organization | ORG | [ORG]ORG0=[VEP]ORG | Block | ||||
| ORIBUL | Original slip | VCR | ||||||
| ORIDAT | Source date | D | ||||||
| ORIPYRDAT | Source date | D | ||||||
| PAYDAT | Payment date | D | ||||||
| PRF | Profile | PRF | [PRF]PRF0=[VEP]PRF | Block | ||||
| PRFSUP | Add. profile | PRF | [PRF]PRF0=[VEP]PRFSUP | Block | ||||
| PSNNUM | Service provision | C | 4 | |||||
| PST | Posted | M | 4 | 370 | ||||
| PYRDAT | Pay date | D | ||||||
| PYRMON | Pay month | D | ||||||
| RPTBUL | Payslip | ARP | [ARP]ARP0=RPTBUL | Block | ||||
| RVS | Reversal | C | 1 | |||||
| RVSDAT | Reversal date | D | ||||||
| SRV | Department | SRV | [SRV]SRV0=[VEP]SRV | Block | ||||
| STA | Status | M | 15 | 340 | ||||
| STRCTRDAT | Contract date | DTR | ||||||
| STRDAT | Period start date | D | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |