Table TABAT
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TABAT | TAT | WI/Occupational disease certificate | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TAT1 | DAT+REFNUM+CTRNUM+NUM | No | |
| TAT0 | REFNUM+DAT+CTRNUM+NUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADD1 | Address | ADL | ||||||
| ADD2 | Address | ADL | ||||||
| ADD3 | Address | ADL | ||||||
| AMT1 | Salary | 12 | DCB | 9.2 | ||||
| AMT2 | Amount | 4 | DCB | 9.2 | ||||
| AMTALC | Allowance amount | 12 | DCB | 9.2 | ||||
| AMTAVN | Ben. in kind | 12 | DCB | 9.2 | ||||
| AMTCTB1 | Contributions | 12 | DCB | 9.2 | ||||
| AMTCTB2 | Contributions | 4 | DCB | 9.2 | ||||
| AMTCTB3 | Contributions | 4 | DCB | 9.2 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BUL | Payslip | VCR | ||||||
| CIV | Title | M | 15 | 231 | ||||
| CODPOS | Postal code | POS | ||||||
| CODRSK | Risk code | A | 5 | |||||
| CPY | Company | CPY | [CPY]CPY0=[TAT]CPY | Block | ||||
| CPYADDLIG | Address | 3 | ADL | |||||
| CPYCRY | Country | CRY | [TCY]TCY0=[TAT]CPYCRY | Block | ||||
| CPYCTY | City | CTY | ||||||
| CPYPOSCOD | Postal code | POS | ||||||
| CPYTEL | Telephone | TEL | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRGPFL | Submitted prof. expenses | 12 | DCB | 9.2 | ||||
| CRY | Country | CRY | [TCY]TCY0=[TAT]CRY | Block | ||||
| CTRDAT | Arrival | DTR | ||||||
| CTRDATAPT | Date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| CTY | City | CTY | ||||||
| DAT | Event date | D | ||||||
| DAT1 | Pay date | 12 | D | |||||
| DAT2 | Backpay date | 4 | D | |||||
| DATANC | Seniority date | D | ||||||
| DATBRN | Birth date | D | ||||||
| DATREF | Date | D | ||||||
| DESBID | Title | A | 30 | |||||
| ENAFLG | Subrogation | M | 15 | 369 | ||||
| ENDDAT1 | End | 12 | D | |||||
| ENDDAT2 | End | 4 | D | |||||
| ENDDAT3 | End | 4 | D | |||||
| ENDSBG | Subrogation end | D | ||||||
| ETRDAT | Receipt date | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[TAT]FCY | Block | ||||
| FCYADDLIG | Address | 3 | ADL | |||||
| FCYBID | Account no. | BID | ||||||
| FCYBIDCRY | Bank ID country | CRY | [TCY]TCY0=[TAT]FCYBIDCRY | Block | ||||
| FCYCRN | Site tax ID no. | CRT | ||||||
| FCYCRY | Country | CRY | [TCY]TCY0=[TAT]FCYCRY | Block | ||||
| FCYCTY | City | CTY | ||||||
| FCYCUR | Currency | CUR | [TCU]TCU0=[TAT]FCYCUR | Block | ||||
| FCYPOSCOD | Postal code | POS | ||||||
| FCYRPB | Supervisor | A | 40 | |||||
| FCYRPBFNC | Function | M | 15 | 233 | ||||
| FCYRPBFNC2 | Other | A | 30 | |||||
| FCYTEL | Telephone | TEL | ||||||
| FLGRCV | Recovery | M | 4 | 1 | ||||
| FLGSAL | Wage level maintenance | 4 | M | 15 | 369 | |||
| FLGVIC | Other victims | M | 4 | 1 | ||||
| GRD3 | Absence reason | 4 | A | 3 | ||||
| GRDABS | Sick leave reason | M | 15 | 389 | ||||
| JOB | Job | A | 30 | |||||
| LOSSAL | Salary loss | 4 | DCB | 9.2 | ||||
| LSTDAYDAT | Last day | D | ||||||
| MEDADD | Address | A | 50 | |||||
| MEDORG | Occupational health | ORG | [ORG]ORG0=[TAT]MEDORG | Block | ||||
| NAM | Name | A | 40 | |||||
| NBR1 | Number | C | 4 | |||||
| NBR2 | Number | C | 4 | |||||
| NBR3 | Number | C | 4 | |||||
| NBRDAYMON | Number of days | DCB | 9.2 | |||||
| NBRPYR | Number of payslips | C | 2 | |||||
| NTTTYP | Nationality | M | 15 | 390 | ||||
| NUM | Number | C | 4 | |||||
| NUMCON | Contract no. | A | 20 | |||||
| NUMSSC | Social Security | SSE | ||||||
| OLDNAM | Birth name | A | 40 | |||||
| PLCREF | Location | A | 30 | |||||
| QLF | Qualification | A | 30 | |||||
| RATPFL | Add. deduc. % | 12 | DCB | 4.2 | ||||
| RCVDAT | Resumption date | D | ||||||
| REFNUM | Employee ID | MAT | [ID]ID0=[TAT]REFNUM | Delete | ||||
| SALMIN | Minimum salary | DCB | 6.2 | |||||
| SEX | Individual's gender | M | 15 | 314 | ||||
| SRN | Employee's first name | A | 40 | |||||
| STAATT | Status | M | 15 | 2409 | ||||
| STRDAT1 | Start | 12 | D | |||||
| STRDAT2 | Start | 4 | D | |||||
| STRDAT3 | Start | 4 | D | |||||
| STRSBG | Subrogation start | D | ||||||
| TYPPGN | Leave type | M | 15 | 2408 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |