Table TMPEMPLO
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TMPEMPLO | TCT | Import employee and contract | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CTR0 | REFNUM+CTRNUM+CTRDAT | Yes | |
| CTR1 | REFNUM+CTRDAT | Yes | |
| CTR2 | REFNUM+CTRNUM+NUMLIG | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AEMNUM | MEC no. | A | 10 | FINTM | ||||
| AFFMUT | Compl. health ins. scheme | ADI | [ADI]CODE=329;AFFMUT | Block | PAY | |||
| AGNMIDWRK | Agency | ORG | [ORG]ORG0=AGNMIDWRK | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| AVNNAT | Benefits by type | A | 4 | PAY | ||||
| BUICAT | Category | C | 4 | FBTP | ||||
| BUICODJOB | Profession | A | 10 | FBTP | ||||
| BUICODQLY | Qualification | A | 10 | FBTP | ||||
| BUICOE | Factor | A | 10 | FBTP | ||||
| BUIGRA | Rank | C | 4 | FBTP | ||||
| BUILEV | Level | C | 4 | FBTP | ||||
| BUIRATEXS | Reduction rate Expenses | C | 4 | FBTP | ||||
| BUIRETPRV | Complementary Retirement & Welfare | C | 4 | FBTP | ||||
| BUISTA | Position | C | 4 | FBTP | ||||
| BUISTAPAY | Paying member status | C | 4 | FBTP | ||||
| CALPAY | Payroll calculation | M | 15 | 330 | ||||
| CATCSP | Socio-professional category | ADI | [ADI]CODE=362;CATCSP | Block | ||||
| CATFRT | Category 2483 | ADI | [ADI]CODE=453;CATFRT | Block | FRT | |||
| CATJOB | Professional status | ADI | [ADI]CODE=357;CATJOB | Block | PAY | |||
| CATQLF | Qualification code | ADI | [ADI]CODE=605;CATQLF | Block | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=indice+1;CCE(indice) | Block | ANA | |||
| CCP | CCPB member | M | 4 | 1 | PAY | |||
| CDDGRD | Fixed-term contract reason | ADI | [ADI]CODE=356;CDDGRD | Block | ||||
| CHEFCTR | Supervisors | 20 | MAT | [ID]ID0=[TCT]CHEFCTR | RTZ | |||
| CLA | Clauses | A | 200 | |||||
| CLAAVNSPE | Clauses of addendum | 10 | CLC | [CLC]CLC0=[TCT]CLAAVNSPE | Block | |||
| CLACTRSPE | Contract clauses | 10 | CLC | [CLC]CLC0=[TCT]CLACTRSPE | Block | |||
| CLALETSPE | Clauses of letter of appointment | 10 | CLC | [CLC]CLC0=[TCT]CLALETSPE | Block | |||
| CLEEVETIM | Time events balance | M | 4 | 1 | ||||
| CLLCVT | Collective agreement | ADI | [ADI]CODE=358;CLLCVT | Block | PAY | |||
| CMTRPL | Comment | 5 | A | 250 | ||||
| CODCNB | CNBF code | M | 15 | 310 | ||||
| COE | Coefficient | A | 9 | PAY | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTRCODSEE | Federal ID code | JOB | PAY | |||||
| CTRDAT | Date | DTR | ||||||
| CTRGRD | Reason | ADI | [ADI]CODE=386;CTRGRD | Block | ||||
| CTRNUM | Contract | CTR | ||||||
| DATANC | Seniority date | D | ||||||
| DATANCAPT | Apprentice ref date | D | ||||||
| DATCPY | Company entry date | D | ||||||
| DATFCY | Site entry date | D | ||||||
| DATLIB | Free date | D | ||||||
| DATLIC | Date of dismissal | D | ||||||
| DED | Add. deduction | DCB | 2.2 | PAY | ||||
| DEGMAL | Sickness delegation | M | 15 | 2507 | ||||
| DETACHE | Seconded abroad | M | 4 | 1 | PAY | |||
| DNAACTASS | Liable for Assedic | M | 4 | 2513 | ||||
| DNAAGS | Liable for AGS | M | 15 | 2523 | ||||
| DNACATSPE | Specific category | ADI | [ADI]CODE=441;DNACATSPE | Block | ||||
| DNACCP | Paid leave fund | M | 4 | 2514 | ||||
| DNACLC | Clause | M | 4 | 1 | ||||
| DNACODTIM | Working time unit | M | 15 | 2515 | ||||
| DNACPYSTG | Foreign company | M | 4 | 2512 | ||||
| DNAEXOASS | Unemployment exemption | M | 15 | 2522 | ||||
| DNASITADM | Admin situation | M | 4 | 2511 | ||||
| ENDCON | Contract end | D | ||||||
| ENDDATSEV | End date | D | PAY | |||||
| ENDNTC2 | Notice period end | D | ||||||
| ENDNTC3 | Notice period end | D | ||||||
| ENDTIMNTC | Notice period end | D | ||||||
| ENDTRY | Trial end | D | ||||||
| ENDTRY2 | End 2nd test | D | ||||||
| ETRFCY | Site | FCY | [FCY]FCY0=ETRFCY | Block | ||||
| ETRSRV | Department | SRV | [SRV]SRV0=[TCT]ETRSRV | Block | ||||
| ETRTIM | Arrival time | HM | ||||||
| EXOCOD1 | Exemption | EXO | [EXO]EXO0=EXOCOD1;1 | Block | PAY | |||
| EXOCOD2 | Exemption | EXO | [EXO]EXO0=EXOCOD2;1 | Block | PAY | |||
| EXOCOD3 | Exemption | EXO | [EXO]EXO0=EXOCOD3;1 | Block | PAY | |||
| EXOCOD4 | Exemption | EXO | [EXO]EXO0=EXOCOD4;1 | Block | PAY | |||
| EXOEND1 | End date | D | PAY | |||||
| EXOEND2 | End date | D | PAY | |||||
| EXOEND3 | End date | D | PAY | |||||
| EXOEND4 | End date | D | PAY | |||||
| EXOSTR1 | Start date | D | PAY | |||||
| EXOSTR2 | Start date | D | PAY | |||||
| EXOSTR3 | Start date | D | PAY | |||||
| EXOSTR4 | Start date | D | PAY | |||||
| EXSPFL | Business expenses | A | 4 | PAY | ||||
| FLGCREAVN | Generate additional clause | M | 4 | 1 | ||||
| FLGCRECTR | Contract generation | M | 4 | 1 | ||||
| FLGCRELET | Generate letter of appointment | M | 4 | 1 | ||||
| FLGDUE | Extracted DUE | M | 4 | 1 | ||||
| FLGINDSUP | Allowance + stat min | M | 4 | 1 | ||||
| FLGPRV | Completed and paid | M | 4 | 1 | ||||
| FLGPRV2 | Not completed and paid | M | 4 | 1 | ||||
| FLGPRV3 | Neither completed nor | M | 4 | 1 | ||||
| FLGVAR | Additional payments | M | 4 | 1 | ||||
| GRA | Rank | A | 5 | PAY | ||||
| HRS | Hourly gross | DCB | 5.3 | PAY | ||||
| HRSMTH | Monthly hour | DCB | 4.3 | |||||
| HRSWEK | Weekly hour | DCB | 3.3 | |||||
| INCVAR | Secondary variable | VRA | [VRA]VRA0=[TCT]INCVAR | Block | PAY | |||
| IND | Index | A | 9 | PAY | ||||
| INSAMT | Usual prepayment | VLR | PAY | |||||
| INSDAY | Prepayment day | C | 2 | PAY | ||||
| JOB | Job | A | 30 | |||||
| JOBPOT | Standard job | JOT | [JOT]JOT0=[TCT]JOBPOT | Block | ||||
| LEVFRT | Training level | ADI | [ADI]CODE=347;LEVFRT | Block | ||||
| LIEU | Place of show | A | 10 | FINTM | ||||
| LNK | Link | M | 4 | 1 | ||||
| LSTDAY | Last attend. | D | ||||||
| LVLQLF | Qualification level | A | 10 | |||||
| MODTPS | WT smoothing | M | 4 | 1 | MTT | |||
| MTH | Monthly gross | DCB | 9.2 | PAY | ||||
| NATCON | Nature of contract | ADI | [ADI]CODE=354;NATCON | Block | ||||
| NBRDAYCTR | Annualized no. days | DCB | 3.2 | |||||
| NBRPEO2 | Children | C | 2 | |||||
| NBRPEO3 | Adults | C | 2 | |||||
| NBRPEO4 | Others | C | 2 | |||||
| NBRPER | Duration (number) | C | 4 | |||||
| NBRPSN | Number of services | C | 4 | FINTM | ||||
| NEWTRY | Trial renewed | M | 4 | 1 | ||||
| NTFDAT | Notified on | D | ||||||
| NTIC | ICT | M | 4 | 1 | PAY | |||
| NUMASS | ASSEDIC number | A | 20 | PAY | ||||
| NUMBNF | Beneficiary no. | A | 10 | PAY | ||||
| NUMCCP | Membership no. | ADI | [ADI]CODE=411;NUMCCP | Block | PAY | |||
| NUMCON | Contract no. | A | 20 | |||||
| NUMLIG | Number | C | 4 | |||||
| NUMOBJ | Object number | A | 10 | FINTM | ||||
| NUMRGT | Ledger number | L | 8 | |||||
| OBJCTR | Object of contract | A | 10 | FINTM | ||||
| OBJRUB | Objective heading | RUB | [RUB]RUB0=[TCT]OBJRUB | Block | PAY | |||
| OBJVAR | Objective variable | VRA | [VRA]VRA0=[TCT]OBJVAR | Block | PAY | |||
| OPEDED | Deduction option | M | 15 | 320 | PAY | |||
| ORGMAL | Health ins. body | A | 30 | |||||
| PERCON | Contract period | M | 15 | 313 | ||||
| PLNTYP | Reference planning | PLN | ||||||
| POT | Position | POT | [POT]POT0=POT | Block | ||||
| PROPRF | Profile | PRF | [PRF]PRF0=[TCT]PROPRF | Block | ||||
| PRUACV | Industrial tribunal | M | 15 | 353 | PAY | |||
| PRUCOL | Industrial tribunal | M | 15 | 352 | PAY | |||
| PRUCTR | Industrial tribunal | M | 15 | 382 | PAY | |||
| PRUVOT | Industrial tribunal | M | 15 | 354 | PAY | |||
| PSNJOB | Job | A | 10 | FINTM | ||||
| PSNTYP | Type of service | C | 4 | FINTM | ||||
| QLF | Qualification | A | 30 | |||||
| RATMIDWRK | PT rate | RAT | ||||||
| RAZCUM | RTZ of totals | M | 4 | 1 | PAY | |||
| REFCAE | CEA reference | A | 10 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[TCT]REFNUM | Delete | ||||
| ROWOBJRUB | Sequence | C | 4 | PAY | ||||
| RPL | Substitute | 5 | MAT | [ID]ID0=RPL | RTZ | |||
| RPTBUL | Payslip | ARP | [ARP]ARP0=RPTBUL | Block | PAY | |||
| RSKWRK | Risk | VAC | [WAC]WAC0=[TCT]RSKWRK | Block | PAY | |||
| SALETP | PTW salary | DCB | 9.2 | |||||
| SCHJOB | Student | M | 4 | 1 | ||||
| SEVCTR | Multiple jobs | M | 4 | 2407 | ||||
| SEVEMP | Multiple employers | M | 4 | 2407 | PAY | |||
| STABEFETR | Situation before hiring | M | 15 | 2403 | ||||
| STACAT | Categroy | ADI | [ADI]CODE=364;STACAT | Block | PAY | |||
| STACAT2 | Category status | ADI | [ADI]CODE=368;STACAT2 | Block | ||||
| STACTR | Contract status | C | 4 | FINTM | ||||
| STAEMP | Executive status | M | 15 | 306 | ||||
| STRCAE | CEA start | D | ||||||
| STRDATSEV | Start date | D | PAY | |||||
| STRNTC2 | Notice period start | D | ||||||
| STRNTC3 | Notice period start | D | ||||||
| STRTIMNTC | Notice period start | D | ||||||
| SYSAT | WI scheme | ADI | [ADI]CODE=355;SYSAT | Block | PAY | |||
| SYSFLG | SS scheme extension | C | 4 | FPAY | ||||
| SYSMAL | Sickness scheme | ADI | [ADI]CODE=355;SYSMAL | Block | PAY | |||
| SYSSSC | Basic scheme | ADI | [ADI]CODE=355;SYSSSC | Block | PAY | |||
| SYSVIP | Old age scheme Employer's contribution | ADI | [ADI]CODE=355;SYSVIP | Block | PAY | |||
| SYSVIS | Old age scheme Employee's contribution | ADI | [ADI]CODE=355;SYSVIS | Block | PAY | |||
| TIP | Tip | M | 4 | 1 | PAY | |||
| TWDPAY | Net to gross payroll | M | 4 | 1 | PAY | |||
| TYPCAC | Fee type | C | 4 | FINTM | ||||
| TYPJOB | Job type | M | 15 | 312 | ||||
| TYPLNK | Kinship | M | 30 | 2524 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| WRKADD1 | Address | ADL | ||||||
| WRKADD2 | Address | ADL | ||||||
| WRKADD3 | Address | ADL | ||||||
| WRKCODPOS | Postal code | POS | ||||||
| WRKCODSEE | Municipality code | A | 5 | |||||
| WRKCRN | Site tax ID number | CRT | ||||||
| WRKCRY | Country | CRY | [TCY]TCY0=[TCT]WRKCRY | Block | ||||
| WRKCRYNAM | Country name | NCY | ||||||
| WRKCTY | City | CTY | ||||||
| WRKFLGADD | Site | M | 4 | 1 | ||||
| WRKSTG | Work abroad | M | 15 | 317 | PAY | |||
| XITDAT | Issue date | D | ||||||
| XITFNL | Final exit | M | 4 | 1 | ||||
| XITGRD | Reasons | ADI | [ADI]CODE=359;XITGRD | Block | ||||
| XITLEA | Departure for leave | ADI | [ADI]CODE=379;XITLEA | Block | ||||
| ZON1 | Free field | DCB | 9.2 | |||||
| ZON2 | Free field | DCB | 9.2 |