Table MALADIE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| MALADIE | MAL | Sickness certificate/Maternity | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MAL1 | DAT+REFNUM+CTRNUM+NUM | No | |
| MAL0 | 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 | ||||||
| AMTGEN | General amount | DCB | 9.2 | |||||
| AMTPYR | Salary | 12 | DCB | 9.2 | ||||
| AMTSPE | Special amount | DCB | 9.2 | |||||
| ANTDAT | Early return | D | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BUL | Payslip | VCR | ||||||
| CIV | Title | M | 15 | 231 | ||||
| CODACS | Access code | ACS | [ACS]ACS0=[MAL]CODACS | Block | ||||
| CODPOS | Postal code | POS | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[MAL]CRY | Block | ||||
| CTBPYR1 | Contribution period 1 | 12 | DCB | 9.2 | ||||
| CTBPYR2 | Contribution period 2 | 12 | DCB | 9.2 | ||||
| CTRDAT | Contract date | DTR | ||||||
| CTRNUM | Contract | CTR | ||||||
| CTY | City | CTY | ||||||
| CURSAL | Currency | CUR | [TCU]TCU0=[MAL]CURSAL | Block | ||||
| DAT | Event date | D | ||||||
| DATREF | Date | D | ||||||
| DESBID | Title | A | 30 | |||||
| ENAFLG | Subrogation | M | 15 | 369 | ||||
| ENDDAT | Period end date | D | ||||||
| ENDDATPYR | End | 12 | D | |||||
| ENDSBG | Subrogation end | D | ||||||
| FCY | Site | FCY | [FCY]FCY0=[MAL]FCY | Block | ||||
| FCYADDLIG | Address | 3 | ADL | |||||
| FCYBID | Account no. | BID | ||||||
| FCYBIDCRY | Bank ID country | CRY | [TCY]TCY0=[MAL]FCYBIDCRY | Block | ||||
| FCYCRN | Site tax ID no. | CRT | ||||||
| FCYCRY | Country | CRY | [TCY]TCY0=[MAL]FCYCRY | Block | ||||
| FCYCTY | City | CTY | ||||||
| FCYCUR | Currency | CUR | [TCU]TCU0=[MAL]FCYCUR | Block | ||||
| FCYPOSCOD | Postal code | POS | ||||||
| FCYRPB | Supervisor | A | 40 | |||||
| FCYRPBFNC | Function | M | 15 | 233 | ||||
| FCYRPBFNC2 | Other | A | 30 | |||||
| FCYTEL | Telephone | TEL | ||||||
| FLGGEN | General case | M | 4 | 1 | ||||
| FLGRCV | Recovery | M | 4 | 1 | ||||
| FLGREG | Rectification certificate | M | 4 | 1 | ||||
| FLGSPE | Special case | M | 4 | 1 | ||||
| GRDABS | Absence reason | M | 15 | 360 | ||||
| GRDABSPYR | Absence reason | 12 | A | 3 | ||||
| JOB | Job | A | 30 | |||||
| LOSSAL | Salary loss | 12 | DCB | 9.2 | ||||
| LSTDAYDAT | Last day | D | ||||||
| NAM | Name | A | 40 | |||||
| NBRDAYMON | Number of days | DCB | 9.2 | |||||
| NBRHRSGEN | + 200 h of work | M | 4 | 1 | ||||
| NBRHRSOVR | No. of hours | 12 | DCB | 6.2 | ||||
| NBRHRSSPE | + 800 h of work | M | 4 | 1 | ||||
| NBRHRSWRK | No. of hours worked | 12 | DCB | 6.2 | ||||
| NBRPYR | Number of payslips | C | 2 | |||||
| NUM | Order information | C | 4 | |||||
| NUMSSC | Social Security | SSE | ||||||
| OLDNAM | Birth name | A | 40 | |||||
| PLCREF | Location | A | 30 | |||||
| PLFPYR | Cap | 12 | DCB | 9.2 | ||||
| RCVDAT | Resumption date | D | ||||||
| RCVMIDWRK | PT resumption | M | 15 | 361 | ||||
| REFNUM | Employee ID | MAT | [ID]ID0=[MAL]REFNUM | Delete | ||||
| SALRES | Salary reestablished | 12 | DCB | 9.2 | ||||
| SITDATABS | Situation | A | 30 | |||||
| SRN | Employee's first name | A | 40 | |||||
| STAATT | Status | M | 15 | 2409 | ||||
| STRDAT | Period start date | D | ||||||
| STRDATPYR | Start | 12 | D | |||||
| STRSBG | Subrogation start | D | ||||||
| TOTHRSWRK | Total worked hours | DCB | 9.2 | |||||
| TYPPGN | Leave type | M | 15 | 2408 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 |